|
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. |
|
|