APPEAL_GRV_TAT_MILESTONES

Description:

This table holds information about turnaround time milestones for appeals and grievances. Each row corresponds to an individual milestone and the date and time associated with the milestone.

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	TAT_TIME_STANDARD_C_NAME	VARCHAR	No
	The timeliness standard category ID that corresponds to this milestone. May contain organization-specific values: Yes Category Entries: Operational Medicare Advantage
4	TAT_MILESTONE_C_NAME	VARCHAR	No
	The milestone type category ID for this milestone. May contain organization-specific values: No Category Entries: Overall Due Decision Due Effectuation Due Start of Timeframe Filing Due
5	TAT_MILE_INST_UTC_DTTM	DATETIME (UTC)	No
	The date and time associated with this milestone. Stored in UTC.
6	TAT_MILE_DUE_LOCAL_DTTM	DATETIME (Attached)	No
	The date and time associated with this milestone. Stored in the time zone determined by column APPEAL_GRV.TAT_RPT_TIME_ZONE_C.