PCC_Cache_FacID

98 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
FacilityID int 4 null
Base10_Export_Residents.FacilityId Implied ConstraintR
Base10_PCC_CovidLabResults.FacilityId Implied ConstraintR
DataTable_AR_Reconciliation_2018-12-12.FacilityId Implied ConstraintR
dim_bed.facilityid Implied ConstraintR
dim_facility.facilityid Implied ConstraintR
dim_patient.facilityid Implied ConstraintR
dim_payer.facilityid Implied ConstraintR
ds_pcc_bed.facilityid Implied ConstraintR
ds_pcc_facility.facilityid Implied ConstraintR
ds_pcc_facility_common_codes.facilityid Implied ConstraintR
ds_pcc_facility_patient.facilityid Implied ConstraintR
ds_pcc_level_of_care.facilityid Implied ConstraintR
ds_pcc_patient_ar_insurance.facilityid Implied ConstraintR
ds_pcc_patient_census.facilityid Implied ConstraintR
ds_pcc_patient_diagnosis.facilityid Implied ConstraintR
ds_pcc_payer.facilityid Implied ConstraintR
fact_patient_diagnosis.facilityid Implied ConstraintR
fact_patient_insurance_active.facilityid Implied ConstraintR
InOut_patient_facility_stay_newer.facilityid Implied ConstraintR
load_pcc_bed.facilityid Implied ConstraintR
load_pcc_facility.facilityid Implied ConstraintR
load_pcc_facility_common_codes.facilityid Implied ConstraintR
load_pcc_facility_patient.facilityid Implied ConstraintR
load_pcc_level_of_care.facilityid Implied ConstraintR
load_pcc_patient_ar_insurance.facilityid Implied ConstraintR
load_pcc_patient_census.facilityid Implied ConstraintR
load_pcc_patient_diagnosis.facilityid Implied ConstraintR
load_pcc_payer.facilityid Implied ConstraintR
PCC_Cache_FacID_20220301.FacilityID Implied ConstraintR
PCC_Stays.FacilityId Implied ConstraintR
PCC_Stays_Old.FacilityId Implied ConstraintR
PCC_view_ods_patient_contact.FacilityID Implied ConstraintR
stage_facility_attributes.facilityid Implied ConstraintR
stage_patient_census.facilityid Implied ConstraintR
stage_patient_diagnosis.facilityid Implied ConstraintR
stage_patient_insurance.facilityid Implied ConstraintR
v_patient_facility_stay_newer.facilityid Implied ConstraintR
VW_Base10_Employee_Tests_Export.FacilityId Implied ConstraintR
VW_Base10_Employees_Export.FacilityId Implied ConstraintR
VW_Base10_Resident_CovidBoosters.FacilityId Implied ConstraintR
VW_Base10_Resident_Tests_Export.FacilityId Implied ConstraintR
VW_Base10_Residents_Export.FacilityID Implied ConstraintR
VW_PCC_Facilities.FacilityID Implied ConstraintR
VW_PCC_PatientExternalFacilities.FacilityId Implied ConstraintR
VW_PCC_Split.FacilityID Implied ConstraintR
FacilityCode varchar 5 null
FacilityName varchar 375 null
FacilityType varchar 254 null
FacilityCity varchar 50 √ null
FacilityState varchar 3 √ null
Deleted varchar 1 √ null
IsInactive varchar 1 null
InactiveDate datetime 16,3 √ null
TotalRooms int 4 √ null
TotalBeds int 4 √ null
AVA_insert_date datetime2 16,3 (getdate())
AVA_Source varchar 20 null

Indexes

Constraint Name Type Sort Column(s)
PK_PCC_Cache_FacID Primary key Asc FacilityID

Relationships

Close relationships within degrees of separation