COVERAGE_M3P_ELECT_REQS

Description:

Clarity table for related group CVG 940 - M3P Election Requests.

Primary Key

Column Name	Ordinal Position
COVERAGE_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	COVERAGE_ID	NUMERIC	No
	The unique identifier (.1 item) for the coverage record.
2	LINE	INTEGER	No
	The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3	M3P_ELECT_REQ_UTC_DTTM	DATETIME (UTC)	No
	The date and time in which a member submits an election request for the Medicare Prescription Payment Plan.
4	M3P_REQ_STATUS_C_NAME	VARCHAR	No
	The Request Status category ID for the Medicare Prescription Payment Plan election request. May contain organization-specific values: No Category Entries: Approved Rejected Pending
5	M3P_STATUS_REASON_C_NAME	VARCHAR	No
	The Status Reason category ID for the Medicare Prescription Payment Plan election request. May contain organization-specific values: Yes Category Entries: Incomplete Request Overdue Balance Awaiting Enrollment Confirmation
6	M3P_SOURCE_TYPE_C_NAME	VARCHAR	No
	The Source Type category ID for the Medicare Prescription Payment Plan election request. May contain organization-specific values: Yes Category Entries: Paper Telephone MyChart
7	M3P_PLAN_YEAR	INTEGER	No
	The plan year the member is electing to opt into the Medicare Prescription Payment Plan for.