Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| trans_id | int | 4 | null |
|
|
|||||
| report_month | date | 6 | null |
|
|
|||||
| client_id | int | 4 | √ | null |
|
|
||||
| facility_id | int | 4 | null |
|
|
|||||
| parent_facility_code | varchar | 10 | √ | null |
|
|
||||
| facility_code | varchar | 5 | √ | null |
|
|
||||
| facility_type | varchar | 254 | √ | null |
|
|
||||
| facility_name | varchar | 375 | √ | null |
|
|
||||
| facility_state | varchar | 3 | √ | null |
|
|
||||
| gl_account_number | varchar | 75 | √ | null |
|
|
||||
| account_type_code | varchar | 1 | null |
|
|
|||||
| account_type_desc | varchar | 50 | null |
|
|
|||||
| last_name | varchar | 50 | √ | null |
|
|
||||
| first_name | varchar | 50 | √ | null |
|
|
||||
| resident_number | varchar | 50 | √ | null |
|
|
||||
| transaction_desc | varchar | 100 | √ | null |
|
|
||||
| transaction_amount | money | 21,4 | √ | null |
|
|
||||
| service_from | datetime2 | 16,3 | √ | null |
|
|
||||
| transaction_date | datetime2 | 16,3 | √ | null |
|
|
||||
| transaction_type | varchar | 10 | √ | null |
|
|
||||
| payer_type | varchar | 50 | √ | null |
|
|
||||
| payer_code | varchar | 20 | √ | null |
|
|
||||
| payer_name | varchar | 100 | √ | null |
|
|
||||
| insurance_name | varchar | 300 | √ | null |
|
|
||||
| ability_insurance_name | varchar | 300 | √ | null |
|
|
||||
| insurance | varchar | 300 | √ | null |
|
|
||||
| AVA_insdate | datetime2 | 16,3 | null |
|
|
|||||
| PCCSource | varchar | 50 | null |
|
|
Relationships
Close relationships within degrees of separation
