COVERAGE_5
Description:
The COVERAGE_5 table contains high-level information on both managed care and indemnity coverage records in your system.

Primary Key
Column Name Ordinal Position
CVG_ID 1

Column Information
Name Type Discontinued?
1 CVG_ID NUMERIC No
The unique identifier (.1 item) for the coverage record.
2 COBA_STATUS_C_NAME VARCHAR No
The Coordination of Benefits Agreement (COBA) status for E01 file generation.
May contain organization-specific values: No
Category Entries:
Add
Change
Delete
Add + Delete
3 COBA_DELETE_EFF_DATE DATETIME No
When the Coordination of Benefits Agreement (COBA) status in COBA_STATUS_C is DELETE or ADD+DELETE, this holds the effective date that is to be marked as deleted on the E01 file.
4 PLAN_MAPPING_SKIP_OLD_CVG_ID NUMERIC No
The source coverage that the plan swap was performed on to create this coverage
5 PLAN_MAPPING_SKIP_STATUS_C_NAME VARCHAR No
Stores the current status of plan mapping skip behavior
May contain organization-specific values: No
Category Entries:
Resolved
Unresolved Plan Swap
Expired
6 PLAN_MAPPING_SKIP_DATE DATETIME No
The date that the plan swap took place.
7 PLAN_MAPPING_SKIP_USER_ID VARCHAR No
The user that last updated the plan mapping skip status
8 PLAN_MAPPING_SKIP_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
9 MCARE_GENDER_IDENTITY_C_NAME VARCHAR No
The gender identity denoted by the subscriber on their Medicare Advantage application.
May contain organization-specific values: No
Category Entries:
Woman
Man
Non-binary
I use a different term
I choose not to answer
Form left blank
10 MCARE_SEX_ORIENTATION_C_NAME VARCHAR No
The sexual orientation denoted by the subscriber on their Medicare Advantage application.
May contain organization-specific values: No
Category Entries:
Lesbian or gay
Straight, that is not gay or lesbian
Bisexual
I use a different term
I don't know
I choose not to answer
Form left blank
11 MCARE_SPEC_GENDER_IDENTITY VARCHAR No
The term the subscriber specified for their gender identity on their Medicare Advantage application because a value for their gender identity was not present on the application.
12 MCARE_SPEC_SEX_ORIENTATION VARCHAR No
The term the subscriber specified for their sexual orientation on their Medicare Advantage application because a value for their sexual orientation was not present on the application.
13 MCARE_INDIV_REP_NAME VARCHAR No
The name of the individual representative that helped the subscriber fill out their Medicare Advantage application.
14 MCARE_INDIV_REP_REL_C_NAME VARCHAR No
The relationship of the individual representative to the subscriber that they helped fill out the Medicare Advantage application for.
May contain organization-specific values: No
Category Entries:
Agent
Broker
SHIP counselor
Authorized representative
Other (third party)
Self
I choose not to answer
15 MCARE_INDIV_REP_NPN VARCHAR No
The National Producer Number of the individual representative that helped the subscriber fill out the Medicare Advantage application, if the individual representative is an agent or a broker.