|
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. |
|
|