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