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
External Unlinked Chart Review
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.
9 | ASSOC_EXT_DX_DOCUMENT_ID | NUMERIC | No |
The unique ID of the document record with the external diagnosis data. Used for unlinked external chart reviews.