RA_CDI_REVIEW
Description:
A table to hold the recommendations made from Risk Adjustment CDI Reviews.

Primary Key
Column Name Ordinal Position
CODING_RECORD_ID 1
CONTACT_DATE_REAL 2
LINE 3

Column Information
Name Type Discontinued?
1 CODING_RECORD_ID NUMERIC No
The unique identifier (.1 item) for the coding record 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 LINE INTEGER No
The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
4 CONTACT_DATE DATETIME No
The date of this contact in calendar format.
5 RA_CDI_TYPE_C_NAME VARCHAR No
The type of recommendation being made - component or diagnosis.
May contain organization-specific values: No
Category Entries:
Category
Diagnosis
6 RA_CDI_COMP_TEMPLATE_VERSION_C_NAME VARCHAR No
The version of the component that a recommendation is being added to. One risk adjustment model may have multiple versions, as the sets of diagnoses related to a component may be changed over time by a payer or organization.
May contain organization-specific values: Yes
Category Entries:
CMS-HCC V24 2023
CMS-HCC V24 2024
CMS-HCC V28 2024
HHS-HCC V07 2024
7 RA_CDI_DX_ID_DX_NAME VARCHAR No
The name of the diagnosis.
8 RA_CDI_DX_EDG_CODE_SET_C_NAME VARCHAR No
The code set of the diagnosis being recommended in I COD 803.
May contain organization-specific values: Yes
Category Entries:
ICD-9-CM
ICD-10-CM
ICD-10-CA
ICD-10-UK
DBC
ICD-10 Dutch
ICD-10-AM
A&E Diagnoses
SKS
ICD-10-THL
ICPC-2
ICD-O-3
ICD-10-GM
ICD-9-CM Supplemental
ICD-10-BE
ICD-10-NO
Apache
DSM-5
KinCor
ORPHA
SNOMED CT
9 RA_CDI_RECOM_ACTION_C_NAME VARCHAR No
The recommendation on the component or diagnosis.
May contain organization-specific values: No
Category Entries:
Addition
Do Not Certify
Comment
10 RA_CDI_REVIEWED_YN VARCHAR No
If this recommendation has been acted on by a provider
May contain organization-specific values: No
Category Entries:
No
Yes
11 RA_CDI_REC_CMT VARCHAR No
The reviewer's comment associated with their recommendation.
12 RA_CDI_REC_ORIGIN_C_NAME VARCHAR No
The source of the recommendation.
May contain organization-specific values: No
Category Entries:
Current Conditions
Conditions Needing Recertification
Suspected
Suspected by Patient Merge
13 RA_CDI_REC_NEW_YN VARCHAR No
If the diagnosis or component being recommended or commented on is manually added by a user in this review.
The category values for this column were already listed for column: RA_CDI_REVIEWED_YN
14 REC_SRC_CODING_RECORD_CSN_ID NUMERIC No
The CSN of the review where this diagnosis or component recommendation was first added.
15 RA_REC_EVID_TYPE_C_NAME VARCHAR No
Stores the source of the evidence that was showing to a coder when the recommendation was made.
May contain organization-specific values: No
Category Entries:
Visit Diagnosis
Problem List Problem
Invoice
Claim
CDI Recommendation
External Visit Diagnosis
External Problem
Registry Metric