fact_patient_census

407275 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
censusid 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_bed_key int 4 null
dim_bed.dim_bed_key Implied ConstraintR
dim_date_key int 4 null
dim_date.dim_date_key Implied ConstraintR
dim_payer_key int 4 null
dim_payer.dim_payer_key Implied ConstraintR
dim_location_key int 4 null
dim_location.dim_location_key Implied ConstraintR
createddate datetime 16,3 √ null
carelevelcode varchar 5 √ null
statuscodeid int 4 √ null
actioncodeid int 4 √ null
action_type varchar 30 √ null
admittofromid int 4 √ null
admissiontype int 4 √ null
admissionsource int 4 √ null
priormedicaredays int 4 √ null
hospitalstayfrom datetime 16,3 √ null
hospitalstayto datetime 16,3 √ null
admitdischargelocationtype varchar 254 √ null
begineffectivedate datetime 16,3 √ null
endeffectivedate datetime 16,3 √ null
stay_days int 4 √ null
payerid int 4 √ null
secondpayerid int 4 √ null
thirdpayerid int 4 √ null
fourthpayerid int 4 √ null
fifthpayerid int 4 √ null
admitdischargelocationid int 4 √ null
admitdischargelocation varchar 254 √ null
dss_update_time datetime 16,3 √ null

Relationships

Close relationships within degrees of separation