PLAN_NO_SUPPORT_YR_AUDIT

Description: |
This table contains the results of health plan audits for risk adjustment categories that cannot be found on supporting evidence that can be submitted in the plan year, as of the given review date with the evidence available.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
SUMMARY_DATA_ID | 1 |
CONTACT_DATE_REAL | 2 |
LINE | 3 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | SUMMARY_DATA_ID | NUMERIC | No |
The unique identifier (.1 item) for the summary 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 | AUDIT_TEMPLATE_VERSION_C_NAME | VARCHAR | No |
The category version category ID for the category template determined during a health plan audit that is not supported with evidence for submission for this plan year.
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
RxHCC V08 2025
5 | LAST_REVIEW_UTC_DTTM | DATETIME (UTC) | No |
The UTC date and time when the user last reviewed and marked the category as not being supported for this plan year.
6 | LAST_REVIEW_COMMENT | VARCHAR | No |
The review comments entered by the last audit reviewer about the category decision.