dim_payer

229 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
dim_payer_key int identity 4 √ null
fact_patient_census.dim_payer_key Implied ConstraintR
fact_patient_facility_stay.dim_payer_key Implied ConstraintR
fact_patient_insurance_active.dim_payer_key Implied ConstraintR
stage_patient_census.dim_payer_key Implied ConstraintR
stage_patient_insurance.dim_payer_key Implied ConstraintR
stage_patient_stay_3.dim_payer_key Implied ConstraintR
stage_patient_stay_4.dim_payer_key Implied ConstraintR
payerid int 4 √ null
payercode varchar 5 √ null
payercode2 varchar 10 √ null
payername varchar 50 √ null
payertype varchar 20 √ null
payeraccountid int 4 √ null
SkilledCare char 1 √ null
createddate datetime 16,3 √ null
revisiondate datetime 16,3 √ null
deleted varchar 1 √ null
roomchargebilldesc varchar 50 √ null
useratedesc char 1 √ null
showcarelevel char 1 √ null
facilityid int 4 √ null
PCC_Cache_FacID.FacilityID Implied ConstraintR
mpprflag char 1 √ null
ppsflag char 1 √ null
collectionstemplateid int 4 √ null
dss_update_time datetime 16,3 √ null

Indexes

Constraint Name Type Sort Column(s)
dim_payer_idx_0 Primary key Asc dim_payer_key

Relationships

Close relationships within degrees of separation