HSP_BKT_ADDTL_REC

Description: |
Additional Payment Reconciliation Information
This table holds current information sent back by the payor at a later date. This can be after the account has been closed.
See table HSP_BKT_REC_HX for the history of these items.

Primary Key

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

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | BUCKET_ID | NUMERIC | No |
This column stores the unique identifier for the bucket record.
2 | HSP_ACCOUNT_ID | NUMERIC | No |
This column stores the unique identifier for the hospital account to which the liability bucket is linked.
3 | ADDTL_NA_AMT | NUMERIC | No |
Additional Payment Reconciliation Information - Not allowed amount
4 | ADDTL_PAYOR_PMT | NUMERIC | No |
This column stores the payer payment amount.
5 | ADDTL_NON_CVD_CHGS | NUMERIC | No |
Additional Payment Reconciliation Information - Non-covered charges
6 | ADDTL_TOT_CHARGES | NUMERIC | No |
This column stores the payer reported amount of total charges.
7 | ADDTL_REPORT_DATE | DATETIME | No |
This column stores the date on the report from the payer.
8 | ADDTL_REPT_TYPE_C_NAME | VARCHAR | No |
Additional Payment Reconciliation Information - report type.
May contain organization-specific values: Yes
No Entries Defined