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.