REIMB_CALC_HX

Description: |
This table contains a line for each reimbursement calculation related to a transaction.

Primary Key

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

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | TX_ID | NUMERIC | No |
Unique ID of the transaction.
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 | AMOUNT | NUMERIC | No |
Dollar amount of the calculated reimbursement. This value is the amount we expect to be reimbursed and cannot exceed the charge amount.
4 | USER_ID | VARCHAR | No |
User ID of the person who performed the reimbursement calculation.
5 | USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
6 | CALC_MODULE_C_NAME | VARCHAR | No |
Module that triggered this reimbursement calculation. The possible values for this column are: 1) CLAIMS: Claims Processing 2) CHG ENTRY: Charge Entry 3) ACCT MAINT: Account Maintenance 4) PMT POST: Payment Posting 5) RECALC UTIL: Reimbursement Recalculation Utility
May contain organization-specific values: No
Category Entries:
Claims Processing
Charge Entry
Account Maintenance
Payment Posting
Reimbursement Recalculation Utility
Testing/Modeling
Ad Hoc Reevaluation
Manual Override
Plan Swap Override
7 | CALC_DATE | DATETIME | No |
Date of the reimbursement calculation.
8 | CALC_TIME | DATETIME (Local) | No |
Date and time of the reimbursement calculation.
9 | CONTRACT_AMOUNT | NUMERIC | No |
Stores the allowed amount as calculated by the reimbursement contract. This amount can exceed the charge amount.
10 | REIMB_SOURCE_C_NAME | VARCHAR | No |
Stores how the reimbursement amount was calculated for the charge.
May contain organization-specific values: No
Category Entries:
System Calculated
Contract Overridden
Expected Amounts Overridden
Overridden by Wisdom Estimate
11 | COVERAGE_ID | NUMERIC | No |
This column stores the coverage used to compute reimbursement.
12 | REIMB_COVERAGE_ID | NUMERIC | No |
This item is part of the reimbursement history group. It stores the coverage used to compute reimbursement.