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.