Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| closing_period | date | 6 | √ | null |
|
|
||||
| branch_code | varchar | 65 | √ | null |
|
|
||||
| branch_financename | varchar | 200 | √ | null |
|
|
||||
| branch_groupname | varchar | 200 | null |
|
|
|||||
| branch_serviceline | varchar | 200 | √ | null |
|
|
||||
| payor_type | varchar | 50 | √ | null |
|
|
||||
| payor_source | varchar | 500 | √ | null |
|
|
||||
| start_of_care | datetime | 16,3 | √ | null |
|
|
||||
| end_of_episode | 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 |
|
|
||||
| unearned_revenue | decimal | 17,4 | √ | null |
|
|
||||
| net_earned_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 |
|
|
Relationships
Close relationships within degrees of separation
