HCHB_Rollup_Daily

45669 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
reporting_month date 6 null
reporting_date date 6 null
census_asof_date date 6 √ null
soc_asof_date date 6 √ null
branch_groupname varchar 200 null
Ref_Signature_BranchGroup.branch_groupname Implied ConstraintR
service_line varchar 200 null
branch_code varchar 20 null
census_total int 4 null
soc_total int 4 null
soc_medicare int 4 null
soc_episodic int 4 null
soc_ava_ref int 4 null
soc_recert int 4 null
nonadmit_ava_ref int 4 null
nonadmit_total int 4 null
soc_budget int 4 √ null
bg_sortorder int 4 null
AVA_insert_date datetime2 16,3 (getdate())

Indexes

Constraint Name Type Sort Column(s)
PK_HCHB_Rollup_Daily Primary key Asc/Asc/Asc reporting_month + reporting_date + branch_code

Relationships

Close relationships within degrees of separation