RECONCILE_SVC_LINE

Description:

This table contains service line information for claim reconciliation records.

Primary Key

Column Name	Ordinal Position
CLAIM_REC_ID	1
CONTACT_DATE_REAL	2
LINE	3

Column Information

	Name	Type	Discontinued?
1	CLAIM_REC_ID	VARCHAR	No
	The unique ID of the claim reconciliation record.
2	CONTACT_DATE	DATETIME	No
	The contact date of the claim, in external format.
3	CONTACT_DATE_REAL	NUMERIC	No
	The contact date of the claim, in internal format.
4	LINE	INTEGER	No
	The line count of line level procedure codes for this claim reconciliation record.
5	LINE_PROC_CODE	VARCHAR	No
	The line level procedure codes for this claim reconciliation record.
6	LINE_AMT_SUBMT	NUMERIC	No
	The line level amount submitted by the payer for this claim reconciliation record.
7	LINE_AMT_PAID	NUMERIC	No
	The line level amount paid by the payer for this claim reconciliation record.
8	LINE_STAT_CODE_C_NAME	VARCHAR	No
	The line level status code for this claim reconciliation record. May contain organization-specific values: Yes Category Entries: Unmapped code received
9	LINE_STATUS_MSG	VARCHAR	No
	The line level textual status message for this claim reconciliation record.
10	LINE_STAT_CAT_COD_C_NAME	VARCHAR	No
	The line level status category code for this claim reconciliation record. May contain organization-specific values: Yes Category Entries: Unmapped code received
11	LN_CTRL_NUM	VARCHAR	No
	Stores the American National Standards Institute (ANSI) line item control number for this claim reconciliation record.
12	LINE_PROC_MODS	VARCHAR	No
	Procedure modifiers associated with the line specified in the information request.
13	LINE_REV_CODE	VARCHAR	No
	Revenue code associated with the line specified in the information request.
14	LINE_TOOTH_CODE	VARCHAR	No
	Tooth code associated with the line specified in the information request.
15	LINE_TOOTH_SURFACES	VARCHAR	No
	Tooth surface codes associated with the line specified in the information request.