APPEAL_GRV_2
Description:
This table contains information about an individual appeal or grievance as an extension of APPEAL_GRV.

Primary Key
Column Name Ordinal Position
APPEAL_GRV_ID 1

Column Information
Name Type Discontinued?
1 APPEAL_GRV_ID NUMERIC No
The unique identifier (.1 item) for the appeal/grievance record.
2 NEXT_OUTST_DECISION_UTC_DTTM DATETIME (UTC) No
The date and time of the earliest outstanding decision due requirement, in UTC. If there are no outstanding decision due requirements, this item will be null.
3 NEXT_OUTST_DECISION_LOCAL_DTTM DATETIME (Attached) No
The date and time of the earliest outstanding decision due requirement. If there are no outstanding decision due requirements, this item will be null. Stored in the time zone determined by column APPEAL_GRV.TAT_RPT_TIME_ZONE_C.
4 NEXT_OUTST_EFFECT_UTC_DTTM DATETIME (UTC) No
The date and time of the earliest outstanding effectuation due requirement, in UTC. If there are no outstanding effectuation due requirements, this item will be null.
5 NEXT_OUTST_EFFECT_LOCAL_DTTM DATETIME (Attached) No
The date and time of the earliest outstanding effectuation due requirement. If there are no outstanding effectuation due requirements, this item will be null. Stored in the time zone determined by column APPEAL_GRV.TAT_RPT_TIME_ZONE_C.
6 NEXT_OUTST_NOTIF_UTC_DTTM DATETIME (UTC) No
The date and time of the earliest outstanding notification due requirement, in UTC. If there are no outstanding notification due requirements, this item will be null.
7 NEXT_OUTST_NOTIF_LOCAL_DTTM DATETIME (Attached) No
The date and time of the earliest outstanding notification due requirement. If there are no outstanding notification due requirements, this item will be null. Stored in the time zone determined by column APPEAL_GRV.TAT_RPT_TIME_ZONE_C.
8 REQUIREMENTS_COMP_UTC_DTTM DATETIME (UTC) No
The instant when all required decision, effectuation, and notification requirements were met, in UTC.
9 REQUIREMENTS_COMP_LOCAL_DTTM DATETIME (Attached) No
The instant when all required decision, effectuation, and notification requirements were met. Stored in the time zone determined by column APPEAL_GRV.TAT_RPT_TIME_ZONE_C.
10 DECISION_ON_TIME_C_NAME VARCHAR No
The on time status category ID of decision timeliness requirements.
May contain organization-specific values: No
Category Entries:
Incomplete
Completed Late
Completed On Time
11 EFFECTUATION_ON_TIME_C_NAME VARCHAR No
The on time status category ID of effectuation timeliness requirements.
The category values for this column were already listed for column: DECISION_ON_TIME_C_NAME
12 NOTIFICATIONS_ON_TIME_C_NAME VARCHAR No
The on time status category ID of notification timeliness requirements.
The category values for this column were already listed for column: DECISION_ON_TIME_C_NAME
13 OVERALL_ON_TIME_C_NAME VARCHAR No
The overall on time status category ID of the appeal or grievance, including decision, effectuation, and notification requirements.
The category values for this column were already listed for column: DECISION_ON_TIME_C_NAME
14 APPEAL_GRV_WKFL_STEP_C_NAME VARCHAR No
The current workflow step category ID for the Appeal or Grievance
May contain organization-specific values: No
Category Entries:
Intake
Submission
Initial Review
MD Review
External Decision
Finalize
Completed
15 PAT_ENC_CSN_ID NUMERIC No
The unique contact serial number for the patient contact associated with this appeal or grievance used to associate notes. This number is unique across all patient encounters in your system. If you use IntraConnect, this is the Unique Contact Identifier (UCI).
16 FILED_LATE_EXCPTNS_ALLOWED_YN VARCHAR No
Whether exceptions to the timely filing timeframe can be made for any applicable timeliness standard.
May contain organization-specific values: No
Category Entries:
No
Yes
17 FILED_LATE_OVERRIDE_YN VARCHAR No
Used if the appeal/grievance was filed late, but the system is not automatically marking it as late. Yes means the appeal/grievance was filed outside of the filing timeframe, no or blank means it was not, or the system was able to automatically determine the status in FILED_ON_TIME_C.
The category values for this column were already listed for column: FILED_LATE_EXCPTNS_ALLOWED_YN
18 DISMISSED_YN VARCHAR No
Stores whether the appeal/grievance was dismissed.
The category values for this column were already listed for column: FILED_LATE_EXCPTNS_ALLOWED_YN