HSP_ACCT_PRORATION

Description: |
This table contains the Proration related information from the Hospital Accounts Receivable (HAR) master file.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
HSP_ACCOUNT_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | HSP_ACCOUNT_ID | NUMERIC | No |
This column stores the unique identifier for the hospital account.
2 | LINE | INTEGER | No |
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 | COVERAGE_ID | NUMERIC | No |
This column stores the unique identifier for the coverage record on the hospital account.
4 | CVG_AUTH_NUM | VARCHAR | No |
The coverage authorization number.
5 | EXP_COPAY_AMT | NUMERIC | No |
The expected copay amount.
6 | EXP_COINS_PC | NUMERIC | No |
This column stores the expected coinsurance percentage.
7 | EXP_COINS_AMT | NUMERIC | No |
This column stores the expected coinsurance amount.
8 | EXP_DED_AMT | NUMERIC | No |
This column stores the expected deductible amount.
9 | SYS_EXP_COPAY_AMT | NUMERIC | No |
This column stores the copay amount expected by the system.