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	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
5	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
6	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.
7	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.
8	MCARE_INDIV_REP_NAME	VARCHAR	No
	The name of the individual representative that helped the subscriber fill out their Medicare Advantage application.
9	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
10	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.