PCC_Stays_Old

63255 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
FirstCensusId int 4 null
Continuum_PCC_Stays.FirstCensusID Implied ConstraintR
PatientId int 4 null
FacilityId int 4 null
PCC_Cache_FacID.FacilityID Implied ConstraintR
FacilityCode varchar 5 √ null
FacilityName varchar 375 √ null
FacilityState varchar 3 √ null
LineOfBusiness varchar 10 √ null
StayBeginDate datetime 16,3 null
StayEndDate datetime 16,3 √ null
ResidentNumber varchar 50 √ null
LastName varchar 50 √ null
FirstName varchar 50 √ null
TotalCensusDays int 4 √ null
LengthOfStay int 4 √ null
PrimaryInsCnt int 4 √ null
TotalReimbursement money 21,4 √ null
IsActivePatient char 1 √ null
asof_datetime datetime2 16,3 null

Indexes

Constraint Name Type Sort Column(s)
UIX_PCC_Stays_Old Must be unique Asc FirstCensusId

Relationships

Close relationships within degrees of separation