HCHB_MonthEndCloseAR

289722 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
closing_period int 4 null
Agency varchar 65 √ null
Payor Type varchar 50 null
Branch varchar 65 null
Name varchar 100 null
Service Line varchar 25 √ null
Payor Source varchar 500 √ null
SOC datetime 16,3 √ null
EOE datetime 16,3 √ null
HICN varchar 25 √ null
EOE Type char 1 √ null
Final Bill Date datetime 16,3 √ null
Days Delayed int 4 √ null
Gross Revenue decimal 17,4 null
Cash Received decimal 17,4 √ null
Gross AR decimal 17,4 √ null
1 - 30 decimal 17,4 √ null
31 - 60 decimal 17,4 √ null
61 - 90 decimal 17,4 √ null
91 - 120 decimal 17,4 √ null
121 - 150 decimal 17,4 √ null
151 - 180 decimal 17,4 √ null
181 - 210 decimal 17,4 √ null
211 - 240 decimal 17,4 √ null
241 - 270 decimal 17,4 √ null
271 - 300 decimal 17,4 √ null
301 - 330 decimal 17,4 √ null
331 - 360 decimal 17,4 √ null
361+ decimal 17,4 √ null
UnEarned Revenue decimal 17,4 √ null
Net Earned AR decimal 17,4 √ null
AVA_insert_datetime datetime2 16,3 (getdate())

Indexes

Constraint Name Type Sort Column(s)
UIX_HCHB_MonthEndCloseAR Performance Asc/Asc/Asc/Asc/Asc/Asc/Asc closing_period + Branch + Payor Type + Payor Source + Name + SOC + Gross Revenue

Diagram producer might be missing

No diagrams were produced please see application output for any errors