|
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 |
|
|