LCI_CONTACT_DATA
Description:
Clarity table for overtime single items in LCI.

Primary Key
Column Name Ordinal Position
EXTERNAL_CVG_ID 1
CONTACT_DATE_REAL 2

Column Information
Name Type Discontinued?
1 EXTERNAL_CVG_ID NUMERIC No
The unique identifier (.1 item) for the external coverage record record.
2 CONTACT_DATE_REAL FLOAT No
A unique contact date in decimal format. The integer portion of the number indicates the date of contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc.
3 GROUP_CODE VARCHAR No
The group code of an external coverage contact.
4 GROUP_NAME VARCHAR No
The group name of an external coverage contact.
5 PLAN_TYPE_C_NAME VARCHAR No
The plan type of an external coverage contact.
May contain organization-specific values: Yes
Category Entries:
Health
Dental
6 PLAN_NAME VARCHAR No
The plan name of an external coverage contact.
7 PAYER_NAME VARCHAR No
The payer name of an external coverage contact.
8 CVG_EFF_DATE DATETIME No
The coverage effective date of an external coverage contact.
9 CVG_TERM_DATE DATETIME No
The coverage termination date of an external coverage contact.
10 CVG_ADJ_TYPE INTEGER No
The coverage adjustment type of an external coverage contact.
11 CVG_ADJ_SEQUENCE INTEGER No
The coverage adjustment sequence of an external coverage contact.
12 CVG_STATUS_C_NAME VARCHAR No
The coverage status of an external coverage contact.
May contain organization-specific values: No
Category Entries:
Covered
Not Covered
Pending
In Question
Invalid
13 PROGRAM_ID NUMERIC No
The contract (program) ID of an external coverage contact.
14 PROGRAM_ID_RECORD_NAME VARCHAR No
The name of the program record.
15 REGION_NAME VARCHAR No
The region name of an external coverage contact.
16 LOB_ID VARCHAR No
The line of business of an external coverage contact.
17 LOB_ID_LOB_NAME VARCHAR No
The name of the line of business record.
18 CORPORATION_NAME VARCHAR No
The corporation name of an external coverage contact.
19 PAT_PRIMARY_LOC_ID_LOC_NAME VARCHAR No
The name of the revenue location.
20 ENROLLMENT_CAT_C_NAME VARCHAR No
The enrollment category of an external coverage contact.
May contain organization-specific values: Yes
Category Entries:
End-Stage Renal Disease
Disabled
Aged Dual
Aged Non-dual
21 REL_CODE_SET_C_NAME VARCHAR No
The relationship code set of an external coverage contact.
May contain organization-specific values: No
Category Entries:
HIPAA
CWF
22 SUBSCRIBER_NAME VARCHAR No
The subscriber name for an external coverage contact.
23 SUBSCRIBER_DOB_DATE DATETIME No
The subscriber date of birth for an external coverage contact.
24 SUBSCRIBER_SEX_C_NAME VARCHAR No
The subscriber sex for an external coverage contact.
May contain organization-specific values: Yes
Category Entries:
Female
Male
Unknown
Nonbinary
X
Other
25 MEM_REL_TO_SUB_C_NAME VARCHAR No
The member's relationship to the subscriber for an external coverage contact.
May contain organization-specific values: Yes
Category Entries:
Self
Spouse
Child
Employee
Unknown
26 GROUP_NUMBER VARCHAR No
The group number for an external coverage contact.
27 EXT_DEMOG_ID NUMERIC No
The REQ that this LCI is attached to at this timestamp.