APPEAL_GRV_NOTIF_TAT
Description:
This table holds information about notifications that complete required turnaround time events for appeals and grievances. Each row corresponds to an individual turnaround time requirement and the communication that satisfied that requirement.

Primary Key
Column Name Ordinal Position
APPEAL_GRV_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 APPEAL_GRV_ID NUMERIC No
The unique identifier (.1 item) for the appeal/grievance record.
2 LINE INTEGER No
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 NOTIF_TAT_TIME_STANDARD_C_NAME VARCHAR No
The timeliness standard category ID that corresponds to this notification requirement.
May contain organization-specific values: Yes
Category Entries:
Operational
Medicare Advantage
4 APPEAL_GRV_LETTER_TYPE_C_NAME VARCHAR No
The notification type category ID for this notification requirement.
May contain organization-specific values: Yes
Category Entries:
Acknowledgement
Extension Taken
Dismissal
Upheld Decision
Overturned Decision
Request to Expedite Denial
Partially Overturned Decision
Request to Expedite Approval
Extension Denial
Decision Effectuation
Grievance Resolution
Upheld Dismissal
Vacated Dismissal
5 NOTIF_TAT_RECIP_CLASS_ID VARCHAR No
The unique ID of the recipient class that this notification is required to be sent to.
6 NOTIF_TAT_RECIP_CLASS_ID_EVENT_NAME VARCHAR No
The name of the event.
7 NOTIF_TAT_METHOD_C_NAME VARCHAR No
The category ID for how this notification is required to be sent. (Oral vs Written)
May contain organization-specific values: No
Category Entries:
Written
Oral
Oral or Written
8 NOTIF_TAT_DUE_UTC_DTTM DATETIME (UTC) No
The date and time that this notification requirement is due. Stored in UTC.
9 NOTIF_TAT_OCCUR_UTC_DTTM DATETIME (UTC) No
The date and time that this notification was submitted. NULL indicates that the notification is still outstanding. Stored in UTC.
10 NOTIF_LETTER VARCHAR No
The letter GUID (I TAG 5020) that satisfies this notification requirement.
11 NOTIF_CALL_COMM_ID VARCHAR No
The unique ID of the communication that satisfies this notification requirement.
12 NOTIF_TAT_DUE_LOCAL_DTTM DATETIME (Attached) No
The date and time that this notification requirement is due. Stored in the time zone determined by column APPEAL_GRV.TAT_RPT_TIME_ZONE_C.
13 NOTIF_TAT_OCCUR_LOCAL_DTTM DATETIME (Attached) No
The date and time that this notification was submitted. NULL indicates that the notification is still outstanding. Stored in the time zone determined by column APPEAL_GRV.TAT_RPT_TIME_ZONE_C.