stage_patient_diagnosis

1511543 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
clientdiagnosisid int 4 √ null
dim_date_key int 4 null
dim_date.dim_date_key Implied ConstraintR
dim_facility_key int 4 null
dim_facility.dim_facility_key Implied ConstraintR
dim_patient_key int 4 null
dim_patient.dim_patient_key Implied ConstraintR
dim_diagnosis_key int 4 null
dim_diagnosis.dim_diagnosis_key Implied ConstraintR
facilityid int 4 √ null
PCC_Cache_FacID.FacilityID Implied ConstraintR
patientid int 4 √ null
diagnosiscode varchar 15 √ null
classification varchar 254 √ null
rank varchar 254 √ null
onsetdate datetime 16,3 √ null
resolveddate datetime 16,3 √ null
length_of_diagnosis int 4 √ null
struckout varchar 1 √ null
icdversion varchar 50 √ null
dss_update_time datetime 16,3 √ null

Relationships

Close relationships within degrees of separation