CVG_MA_ERROR_HISTORY

Description:

The history of Medicare Advantage errors that have been removed from a coverage. Each row represents an error that has been resolved. CVG_MA_ERRORS has the errors currently present on coverages.

Primary Key

Column Name	Ordinal Position
COVERAGE_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	COVERAGE_ID	NUMERIC	No
	The unique identifier 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	MA_ERR_CODE_C_NAME	VARCHAR	No
	The Medicare Advantage error code that was previously on the coverage May contain organization-specific values: No Category Entries: Part A Not Effective Part B Not Effective Part D Not Effective Member Not Found Deceased Date of Birth Mismatch Sex Mismatch First Name Mismatch Last Name Mismatch Middle Name Mismatch Incorrect Part C Premium Incorrect Part D Premium Incorrect Contract Incorrect PBP Incorrect Segment Enrolled According to CMS Not Enrolled According to CMS Termed Prior to Enrollment Not Pending Prior to Enrollment Medicaid Status Flag Mismatch ESRD Status Flag Mismatch Part A Entitlement Date Mismatch Part B Entitlement Date Mismatch Hospice Status Flag Mismatch Long Term Institutional Status Flag Mismatch Eligibility Reason Mismatch Part D Eligibility Date Mismatch Application Date Outside Election Period Missing Rx Information
4	MA_ERR_DATA	VARCHAR	No
	The data from the CMS file associated with the Medicare Advantage error
5	MA_ERR_DATE	DATETIME	No
	The date that the error was reported.
6	MA_ERR_CODE_FILE_C_NAME	VARCHAR	No
	The type of CMS file that caused this error to be logged. May contain organization-specific values: No Category Entries: Batch Eligibility Query Response Monthly NoRx File Monthly Membership Report Full Enrollment File Data
7	MA_ERR_RESOLUTION_C_NAME	VARCHAR	No
	The reason the error was resolved. May contain organization-specific values: No Category Entries: Resolved Ignored Replaced BEQ Resubmitted
8	MA_ERR_RESOLUTION_USER_ID	VARCHAR	No
	The user who resolved the error.
9	MA_ERR_RESOLUTION_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
10	MA_ERR_RESOLUTION_DATE	DATETIME	No
	The date on which the error was resolved.