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.