ROX_Cache_Fac

552 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
Chain_ID int 4 √ null
ChainName varchar 50 √ null
Facility_ID int 4 null
Facility.Facility_id Implied ConstraintR
PCC_MDS_Patient_Facility.facility_id Implied ConstraintR
Resident_Facility.Facility_Id Implied ConstraintR
Resident_Facility.Resident_Facility_Id Implied ConstraintR
ROX_Monthly_Revenue.Facility_ID Implied ConstraintR
ROX_Patient_Billings.Facility_ID Implied ConstraintR
VW_GMLI_2.facility_id Implied ConstraintR
VW_GMLI_CurrMonth_RevTrend_2.facility_id Implied ConstraintR
VW_GMLI_History_2.facility_id Implied ConstraintR
VW_PCC_ar_baddebt.facility_id Implied ConstraintR
VW_PCC_MDS_Patient_facility.facility_id Implied ConstraintR
VW_PCC_Rev_Payor_2.facility_id Implied ConstraintR
VW_PCC_Stays.facility_id Implied ConstraintR
VW_PCC_Stays_PPPL_Payor_Costs.facility_id Implied ConstraintR
VW_ROX_PatientBillings.ROX_Facility_ID Implied ConstraintR
FacName varchar 50 null
ExportKey varchar 20 null
ADCode varchar 20 null
DataTeamCode varchar 20 null
SiteType varchar 15 null
PrimaryHealthcareSetting varchar 50 null
IsInactive bit 1 null
IsOutPatient bit 1 null
facLastModifiedDate datetime 16,3 null
AVA_InsertDate datetime2 16,3 (getdate())
Region varchar 100 √ null
Area varchar 100 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_ROX_Cache_Fac Primary key Asc Facility_ID

Relationships

Close relationships within degrees of separation