dim_patient

262151 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
dim_patient_key int identity 4 √ null
fact_patient_census.dim_patient_key Implied ConstraintR
fact_patient_diagnosis.dim_patient_key Implied ConstraintR
fact_patient_facility_stay.dim_patient_key Implied ConstraintR
fact_patient_insurance_active.dim_patient_key Implied ConstraintR
stage_level_of_skilled_care.dim_patient_key Implied ConstraintR
stage_patient_census.dim_patient_key Implied ConstraintR
stage_patient_diagnosis.dim_patient_key Implied ConstraintR
stage_patient_insurance.dim_patient_key Implied ConstraintR
stage_patient_stay_1.dim_patient_key Implied ConstraintR
stage_patient_stay_2.dim_patient_key Implied ConstraintR
stage_patient_stay_3.dim_patient_key Implied ConstraintR
stage_patient_stay_3_diagnosis.dim_patient_key Implied ConstraintR
stage_patient_stay_3_duration.dim_patient_key Implied ConstraintR
stage_patient_stay_4.dim_patient_key Implied ConstraintR
patientid int 4 √ null
facilityid int 4 √ null
PCC_Cache_FacID.FacilityID Implied ConstraintR
facilitycode varchar 5 √ null
masterpatientid int 4 √ null
firstname varchar 50 √ null
middlename varchar 35 √ null
lastname varchar 50 √ null
title varchar 254 √ null
suffix int 4 √ null
gender char 1 √ null
address1 varchar 35 √ null
address2 varchar 35 √ null
address3 varchar 35 √ null
city varchar 50 √ null
state varchar 3 √ null
country varchar 254 √ null
zipcode varchar 15 √ null
email varchar 75 √ null
homephone varchar 35 √ null
dateofbirth datetime 16,3 √ null
deceaseddate datetime 16,3 √ null
ssnumber varchar 30 √ null
education varchar 254 √ null
citizenship varchar 254 √ null
race varchar 254 √ null
religion varchar 254 √ null
maritalstatus varchar 254 √ null
originaladmissiondate datetime 16,3 √ null
recentadmissiondate datetime 16,3 √ null
dischargedate datetime 16,3 √ null
patientidnumber varchar 35 √ null
patientmrn varchar 35 √ null
patientmedicaidnumber varchar 30 √ null
patientmedicarenumber varchar 30 √ null
createdby varchar 60 √ null
createddate datetime 16,3 √ null
revisionby varchar 60 √ null
revisiondate datetime 16,3 √ null
masterpatientdeleted varchar 1 √ null
patientdeleted varchar 1 √ null
deletedby varchar 60 √ null
deleteddate datetime 16,3 √ null
currentcensusid int 4 √ null
allergies varchar 1000 √ null
occupations varchar 50 √ null
primarypharmacyid int 4 √ null
primaryphysicianid int 4 √ null
nickname varchar 50 √ null
placeofbirth varchar 35 √ null
initialadmissiondate datetime 16,3 √ null
dss_update_time datetime 16,3 √ null

Indexes

Constraint Name Type Sort Column(s)
dim_patient_idx_0 Primary key Asc dim_patient_key

Relationships

Close relationships within degrees of separation