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 | null |
|
|
Diagram producer might be missing
No diagrams were produced please see application output for any errors