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
CMS-HCC V28 2025
HHS-HCC V07 2025
CMS-HCC ESRD V24 2025
HHS-HCC V08 2025
CMS-HCC V28 2026
CMS-HCC ESRD V24 2026
HHS-HCC V08 2026
RxHCC V08 2025
RxHCC V08 2026
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
MONDO
EPD Short List
Preferred Ancillary Code Sets
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
Change Diagnosis
Surface
Do Not Surface
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
Acute Problems
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
External Suspected Data
Attestation
Coding Assistant
Vendor Suggestion
External Historical Data
16 | RA_CDI_ORIG_DX_ID_DX_NAME | VARCHAR | No |
The name of the diagnosis.
17 | RA_CDI_ORIG_DX_EDG_CODE_SET_C_NAME | VARCHAR | No |
The code set of the diagnosis that was recommended in RA_CDI_ORIG_DX_ID.
The category values for this column were already listed for column: RA_CDI_DX_EDG_CODE_SET_C_NAME
18 | RA_CDI_REC_USER_ID | VARCHAR | No |
The CDI user associated with the recommendation.
19 | RA_CDI_REC_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
20 | RA_CDI_RELEVANT_QUERY_CSN_ID | NUMERIC | No |
Stores the query record that was relevant to this CDI user's recommendation. The query information was seen by the user when they were making this recommendation. The query information is shown downstream if the query does not disagree with the user's recommendation.
21 | RA_CDI_REC_DISCARD_YN | VARCHAR | No |
Item that is used for pended reviews when the condition's attached query has been discarded in a pended review.
The category values for this column were already listed for column: RA_CDI_REVIEWED_YN
22 | REC_UPD_CODING_RECORD_CSN_ID | NUMERIC | No |
The CSN of the review where this diagnosis or component recommendation was most recently updated.