RA_EVIDENCE_CODING_RECORD

Description:

This table contains data about the evidence linked to coding records for Health Plan Risk Adjustment.

Primary Key

Column Name	Ordinal Position
CODING_RECORD_ID	1

Column Information

	Name	Type	Discontinued?
1	CODING_RECORD_ID	NUMERIC	No
	The unique identifier (.1 item) for the coding record.
2	LINKED_EVIDENCE_C_NAME	VARCHAR	No
	The type of evidence linked to this coding record. May contain organization-specific values: No Category Entries: Internal Encounter External Encounter Claim Attachment
3	ASSOC_PAT_ENC_CSN_ID	NUMERIC	No
	The member contact with information on the internal encounter whose diagnosis coding is tracked by this record.
4	ASSOC_CLAIM_ID	NUMERIC	No
	The claim record whose diagnosis coding is tracked by this record.
5	EVIDENCE_SERVICE_DATE	DATETIME	No
	The date the associated claim or encounter occurred on.
6	LAST_TASK_COMPLETION_DATE	DATETIME	No
	The date the latest task associated with this coding record was completed.
7	ASSOC_ENC_EVENT_IDENT	VARCHAR	No
	The received document event ID for the external encounter whose diagnosis coding is tracked by this record.
8	ASSOC_ATTACHMENT_DOCUMENT_ID	VARCHAR	No
	The attachment whose diagnosis coding is tracked by this record.