LOADED_EXTERNAL_CVG_DATA
Description:
Clarity table for no-add single items in LCI.

Primary Key
Column Name Ordinal Position
EXTERNAL_CVG_ID 1

Column Information
Name Type Discontinued?
1 EXTERNAL_CVG_ID NUMERIC No
The unique identifier for the loaded coverage information record.
2 PAT_ID VARCHAR No
The unique ID of the patient record linked to the External ID bundle associated with this external coverage data.
3 EXT_DEMOG_ID NUMERIC No
The unique ID of the External Demographic Set that this external coverage is loaded to.
4 EXTERNAL_CVG_PAYER_ID_PAYOR_NAME VARCHAR No
The name of the payor.
5 EXTERNAL_CVG_PLAN_ID_BEN_PACKAGE_NAME VARCHAR No
*** Deprecated *** In table CLARITY_EPP_OT, the column BEN_PACKAGE_NAME (CMK .2) has been deprecated. This column already exists as BENEFIT_PACKAGE_NM (CMK .2) in table CL_CMK. To look up the deprecated column's value after the Clarity Compass upgrade, join column CLARITY_EPP_OT.BEN_PACKAGE_ID to table CL_CMK column BENEFIT_PACKAGE_ID and get the BENEFIT_PACKAGE_NM value. The name of the benefit package for this benefit plan.The ID of the benefit package is in the column BEN_PACKAGE_ID.
6 EXTERNAL_CVG_SUB_IDENT VARCHAR No
The ID of the subscriber for the associated external coverage.
7 EXTERNAL_CVG_SUB_NAME VARCHAR No
The name of the subscriber for the associated external coverage.
8 EXTERNAL_CVG_SUB_DOB_DATE DATETIME No
The date of birth of the subscriber for the associated external coverage.
9 EXTERNAL_CVG_SUB_SEX_C_NAME VARCHAR No
The sex of the subscriber for the associated external coverage.
May contain organization-specific values: Yes
Category Entries:
Female
Male
Unknown
Nonbinary
X
Other
10 EXT_CVG_MEM_REL_TO_SUB_C_NAME VARCHAR No
The member's relationship to the subscriber for the associated external coverage.
May contain organization-specific values: Yes
Category Entries:
Self
Spouse
Child
Employee
Unknown
11 EXTERNAL_CVG_GROUP_NUM VARCHAR No
The group number for the associated external coverage.
12 EXT_CVG_SOURCE_SYSTEM_C_NAME VARCHAR No
The external source that sent the external coverage information.
May contain organization-specific values: Yes
Category Entries:
MyChart
EpicCare Link
Welcome
RTE Response
Roster Management Engine
MyChart Guest
Interconnect Network
Yaqeen Register
Standalone Webservice
Payer Platform
Incoming External Pre-Adjudicated Claims (X12 837) Interface
PB Exchange
Roster Assignment and Attribution
Electronic Authorization Request Autotrigger
13 EXTERNAL_CVG_MEMBER_IDENT VARCHAR No
The member's insurance ID for the associated external coverage.
14 EXTERNAL_CVG_GROUP_CODE VARCHAR No
Unique identifier to represent the secondary level of the client organization.
15 EXTERNAL_CVG_GROUP_NAME VARCHAR No
The name of the group plan.
16 EXTERNAL_CVG_EFF_DATE DATETIME No
The first date the patient is covered by the plan.
17 EXTERNAL_CVG_TERM_DATE DATETIME No
The last date the patient is covered by the plan.
18 EXTERNAL_CVG_CA_PLAN_TYPE_C_NAME VARCHAR No
General plan or product group type.
May contain organization-specific values: Yes
Category Entries:
Health
Dental
19 EXTERNAL_CVG_BENEFIT_PLAN_NAME VARCHAR No
Name of the Benefit Plan.
20 EXTERNAL_CVG_REGION_NAME VARCHAR No
Name of the region.
21 EXTERNAL_CVG_LOB_ID VARCHAR No
ID of the Line of Business.
22 EXTERNAL_CVG_LOB_ID_LOB_NAME VARCHAR No
The name of the line of business record.
23 EXTERNAL_CVG_CORPORATION_NAME VARCHAR No
Name of the corporation.
24 EXTERNAL_CVG_PAYER_NAME VARCHAR No
Name of the payer.
25 EXTERNAL_CVG_VBP_PROGRAM_ID NUMERIC No
Contract ID associated with a row of Eligibility
26 EXTERNAL_CVG_VBP_PROGRAM_ID_RECORD_NAME VARCHAR No
The name of the program record.
27 EXT_CVG_PAT_PRIMARY_LOC_ID_LOC_NAME VARCHAR No
The name of the revenue location.
28 EXTERNAL_CVG_ENROLLMENT_C_NAME VARCHAR No
Coverage enrollment category
May contain organization-specific values: Yes
Category Entries:
End-Stage Renal Disease
Disabled
Aged Dual
Aged Non-dual
29 EXTERNAL_CVG_ADJ_TYPE INTEGER No
Type of change happening to the external coverage
30 EXTERNAL_CVG_ADJ_SEQ INTEGER No
The order in which adjustments occurred over time for the associated external coverage.
31 EXT_CVG_REL_CODE_SET_C_NAME VARCHAR No
Determines whether the associated external coverage is HIPAA (Health Insurance Portability and Accountability Act) or CWF (Common Working File)
May contain organization-specific values: No
Category Entries:
HIPAA
CWF