HSP_BKT_REC_HX

Description: |
Additional Payment Reconciliation Information History table.
This table stores a history of the amounts from HSP_BKT_ADDTL_REC, which has the current values.

Primary Key

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

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | BUCKET_ID | NUMERIC | No |
This column stores the unique identifier for the bucket record.
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 | SOURCE_C_NAME | VARCHAR | No |
Additional Payment Reconciliation Information - Source of the change
May contain organization-specific values: No
Category Entries:
Imported
Manual Entry
Transferred
4 | INSTANT_OF_ENTRY_TM | DATETIME (Local) | No |
Additional Payment Reconciliation Information - Instant when the information was updated
5 | ADDTL_NA_AMT_HX | NUMERIC | No |
Additional Payment Reconciliation Information - Not allowed amount history
6 | ADDTL_PAYOR_PMT_HX | NUMERIC | No |
This column stores the payer payment amount history.
7 | ADDTL_N_CVD_CHGS_HX | NUMERIC | No |
Additional Payment Reconciliation Information - Non-covered charges history
8 | ADDTL_TOT_CHGS_HX | NUMERIC | No |
This column stores the payer reported amount of total charges history.
9 | ADDTL_REPT_HX_DATE | DATETIME | No |
This column stores the date on the report from the payer history.
10 | HSP_ACCOUNT_ID | NUMERIC | No |
This column stores the unique identifier for the hospital account to which the liability bucket is linked.
11 | ADDTL_TYPE_HX_C_NAME | VARCHAR | No |
Additional Payment Reconciliation Information - report type history.
May contain organization-specific values: Yes
No Entries Defined