stage_patient_stay_4

132151 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
dim_stay_length_key int 4 null
dim_hospital_stay_length_key int 4 null
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_admit_date_key int 4 √ null
dim_discharge_date_key int 4 √ null
dim_admit_location_key int 4 √ null
dim_discharge_location_key int 4 √ null
dim_diagnosis_key int 4 √ null
dim_diagnosis.dim_diagnosis_key Implied ConstraintR
dim_payer_key int 4 √ null
dim_payer.dim_payer_key Implied ConstraintR
skilled_length_of_stay_days int 4 √ null
payer_skilled_stay_days smallint 2 √ null
payer_nonskilled_stay_days smallint 2 √ null
admit_censusid int 4 √ null
discharge_censusid int 4 √ null
facility_admit_date datetime 16,3 √ null
facility_discharge_date datetime 16,3 √ null
facility_length_of_stay_days int 4 √ null
facility_length_of_stay_days_capped int 4 √ null
clientdiagnosisid int 4 √ null
dischargelocationtype varchar 254 √ null
onsetdate datetime 16,3 √ null
resolveddate datetime 16,3 √ null
hospitalstayfrom datetime 16,3 √ null
hospitalstayto datetime 16,3 √ null
hospital_stay_days int 4 √ null
hospital_stay_days_capped int 4 √ null
dss_update_time datetime 16,3 √ null

Relationships

Close relationships within degrees of separation