PR_EST_SVC_LN_RMT_INFO

Description:

Contains the adjudication information for each service line in a member estimate.

Primary Key

Column Name	Ordinal Position
ESTIMATE_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	ESTIMATE_ID	NUMERIC	No
	The unique identifier for the patient estimate record.
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	ADDL_LINE_NUM	INTEGER	No
	The line number of related group 1000 that stores additional information about the charge line. It is used to map a line in 2000 related group to a procedure line.
4	FILE_ORD_NUM	INTEGER	No
	The coverage level associated with the corresponding coverage (I PES 168).
5	REMIT_CODE_ID	VARCHAR	No
	This stores any Explanation of Benefits/Remittance Advice codes associated with the service line.
6	REMIT_CODE_ID_REMIT_CODE_NAME	VARCHAR	No
	The name of each remittance code.
7	REMIT_AMT	NUMERIC	No
	This stores the amount associated with the Explanation of Benefits or remittance advice codes.
8	REMIT_CATEGORY_C_NAME	VARCHAR	No
	This stores the payment category that the payer has assigned the amount to May contain organization-specific values: No Category Entries: Patient Not Allowed Other Adjustment Denied