RECONCILE_MA_RA_INFO

Description:

This table contains reconciliation information received from Medicare Advantage Risk Adjustment files.

Primary Key

Column Name	Ordinal Position
CLAIM_RECON_ID	1
CONTACT_DATE_REAL	2

Column Information

	Name	Type	Discontinued?
1	CLAIM_RECON_ID	VARCHAR	No
	The unique identifier (.1 item) for the claim status update record.
2	CONTACT_DATE_REAL	FLOAT	No
	A unique contact date in decimal format. The integer portion of the number indicates the date of contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc.
3	CONTACT_DATE	DATETIME	No
	The date of this contact in calendar format.
4	MA_RA_ALLOW_STATUS_C_NAME	VARCHAR	No
	Identifies the status of a claim export whether its diagnoses are allowed for risk adjustment or not. May contain organization-specific values: No Category Entries: Allowed Disallowed Not Applicable Preliminary Allowable Preliminary Disallowable Preliminary Not Applicable Final Reject
5	MA_RA_ALLOW_RSN_C_NAME	VARCHAR	No
	Indicates the reason why this claim export is allowed, disallowed, or not applicable for risk adjustment. May contain organization-specific values: No Category Entries: Disallowed due to CPT/HCPCS Disallowed due to Final Year-Specific Risk-Adjustment Payment Deadline Disallowed due to TOB Allowed due to CPT/HCPCS Quarterly Update Not Applicable for Risk Adjustment Preliminary Disallowable Preliminary Not Applicable Final Reject Preliminary Not Allowable due to CPT/HCPCS Preliminary Not Allowable due to TOB
6	MA_RA_ENC_TYPE_C_NAME	VARCHAR	No
	Determines the encounter type of an export defined on an MAO file. May contain organization-specific values: No Category Entries: Encounter Data Record Void to an Encounter Data Record Replacement to an Encounter Data Record Chart Review Record Add Void to a Chart Review Replacement to a Chart Review Record Chart Review Record Delete Void to a Chart Review Record Delete Replacement to a Chart Review Record Delete
7	MA_RA_LINKED_PAYER_REF_NUM	VARCHAR	No
	Payer's control number for an encounter data record being referenced to on a void, replacement, or linked chart review record on an MAO file.
8	MA_RA_SUBMIT_DATE	DATETIME	No
	Submission date recorded for an encounter data record or chart review on an MAO-004.