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.