stage_patient_stay_3

132164 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
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 √ ((0))
dim_admit_location_key int 4 null
dim_discharge_location_key int 4 √ null
dim_payer_key int 4 √ null
dim_payer.dim_payer_key Implied ConstraintR
admit_censusid int 4 √ null
discharge_censusid_seq 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
hospitalstayfrom datetime 16,3 √ null
hospitalstayto datetime 16,3 √ null
hospital_stay_days int 4 √ null
hospital_stay_days_capped int 4 √ null
dischargelocationtype varchar 254 √ null
dss_update_time datetime 16,3 √ null

Relationships

Close relationships within degrees of separation