dim_facility

109 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
dim_facility_key int identity 4 √ null
fact_patient_census.dim_facility_key Implied ConstraintR
fact_patient_diagnosis.dim_facility_key Implied ConstraintR
fact_patient_facility_stay.dim_facility_key Implied ConstraintR
fact_patient_insurance_active.dim_facility_key Implied ConstraintR
stage_level_of_skilled_care.dim_facility_key Implied ConstraintR
stage_patient_census.dim_facility_key Implied ConstraintR
stage_patient_diagnosis.dim_facility_key Implied ConstraintR
stage_patient_insurance.dim_facility_key Implied ConstraintR
stage_patient_stay_1.dim_facility_key Implied ConstraintR
stage_patient_stay_2.dim_facility_key Implied ConstraintR
stage_patient_stay_3.dim_facility_key Implied ConstraintR
stage_patient_stay_3_diagnosis.dim_facility_key Implied ConstraintR
stage_patient_stay_3_duration.dim_facility_key Implied ConstraintR
stage_patient_stay_4.dim_facility_key Implied ConstraintR
facilityid int 4 √ null
PCC_Cache_FacID.FacilityID Implied ConstraintR
facilitycode varchar 5 √ null
facilityname varchar 75 √ null
facilityaddress varchar 35 √ null
facilitycity varchar 50 √ null
facilitycountry varchar 254 √ null
facilityphone varchar 35 √ null
facilityfax varchar 35 √ null
facilitypc varchar 15 √ null
facilitystate varchar 3 √ null
campus varchar 5 √ null
facilitytype varchar 10 √ null
region varchar 5 √ null
regionalmanager varchar 40 √ null
arstartdate datetime 16,3 √ null
currentopenmonth int 4 √ null
currentopenyear int 4 √ null
lineofbusiness varchar 10 √ null
medicaididentifierid int 4 √ null
medicaididentifiername varchar 30 √ null
medicareidentifierid int 4 √ null
medicareidentifiername varchar 30 √ null
ssnidentifierid int 4 √ null
ssnidentifiername varchar 30 √ null
mrnidentifier varchar 32 √ null
createddate datetime 16,3 √ null
revisiondate datetime 16,3 √ null
deleted varchar 1 √ null
timezone int 4 √ null
providertype varchar 20 √ null
npi varchar 10 √ null
ccn varchar 1000 √ null
stateprovider varchar 1000 √ null
stateid varchar 1000 √ null
medicarerug varchar 5 √ null
statemedicaidindex varchar 5 √ null
altstatemedicaidindex varchar 5 √ null
statemedicaidgrouper varchar 100 √ null
altstatemedicaidgrouper varchar 100 √ null
collectionsagencyclientnumber varchar 20 √ null
dss_update_time datetime 16,3 √ null

Indexes

Constraint Name Type Sort Column(s)
dim_facility_idx_0 Primary key Asc dim_facility_key

Relationships

Close relationships within degrees of separation