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.
16 PRIMARY_COVERAGE_ID NUMERIC No
The unique ID of the coverage that represents the primary coverage for this coverage. The primary coverage is logically the same coverage as this coverage and other coverages that are associated with them.