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.
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.
28 | CARRIER_ID | VARCHAR | No |
Carrier (MCR) record associated with the patient's coverage.
29 | CARRIER_ID_CARRIER_NAME | VARCHAR | No |
The name of the carrier record.
30 | CARRIER_NAME | VARCHAR | No |
Name of the carrier associated with the patient's coverage.
31 | PRIM_CARE_PROV_ID_PROV_NAME | VARCHAR | No |
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
32 | REL_CODE | VARCHAR | No |
The patient's relationship to the subscriber.
33 | PROD_TYPE_C_NAME | VARCHAR | No |
The product type for an external coverage contact.
May contain organization-specific values: Yes
34 | IS_MEDICARE_ESRD_YN | VARCHAR | No |
Indicates if the member is covered by Medicare with an enrollment category of ESRD (End Stage Renal Disease).
May contain organization-specific values: No
Category Entries:
No
Yes
35 | MCARE_MCAID_DUAL_STAT_C_NAME | VARCHAR | No |
The Medicaid dual status code for a member that is covered by Medicare.
May contain organization-specific values: No
Category Entries:
No Medicaid status
Eligible - QMB only (partial dual)
Eligible - QMB and Medicaid (full dual)
Eligible - SLMB only (partial dual)
Eligible - SLMB and Medicaid (full dual)
Eligible - QDWI (partial dual)
Eligible - Qualifying individuals (partial dual)
Eligible - Other dual eligibles with Medicaid (full dual)
Eligible - Other dual eligibles without Medicaid (non-dual)
Other full dual
Unknown