AUTH_REQ_HX_NOTIF_REQT

Description:

This table contains the various notification-related requirements for a given review category for a contact, along with when these requirements were satisfied.

Primary Key

Column Name	Ordinal Position
AUTH_REQUEST_ID	1
CONTACT_DATE_REAL	2
LINE	3

Column Information

	Name	Type	Discontinued?
1	AUTH_REQUEST_ID	NUMERIC	No
	The unique identifier for the authorization request 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	REVIEW_CATEGORY_C_NAME	VARCHAR	No
	The unique ID of the review category that the notification requirements apply to. May contain organization-specific values: Yes Category Entries: Behavioral Commercial Urgent Concurrent Behavioral Commercial Urgent Preservice Behavioral Commercial Nonurgent Preservice Behavioral Commercial Postservice Behavioral Marketplace Urgent Concurrent Behavioral Marketplace Urgent Preservice Behavioral Marketplace Nonurgent Preservice Behavioral Marketplace Postservice Behavioral Medicare Urgent Concurrent Behavioral Medicare Urgent Preservice Behavioral Medicare Nonurgent Preservice Behavioral Medicare Postservice Behavioral Medicaid Urgent Concurrent Behavioral Medicaid Urgent Preservice Behavioral Medicaid Nonurgent Preservice Behavioral Medicaid Postservice Nonbehavioral Commercial Urgent Concurrent Nonbehavioral Commercial Urgent Preservice Nonbehavioral Commercial Nonurgent Preservice Nonbehavioral Commercial Postservice Nonbehavioral Marketplace Urgent Concurrent Nonbehavioral Marketplace Urgent Preservice Nonbehavioral Marketplace Nonurgent Preservice Nonbehavioral Marketplace Postservice Nonbehavioral Medicare Urgent Concurrent Nonbehavioral Medicare Urgent Preservice Nonbehavioral Medicare Nonurgent Preservice Nonbehavioral Medicare Postservice Nonbehavioral Medicaid Urgent Concurrent Nonbehavioral Medicaid Urgent Preservice Nonbehavioral Medicaid Nonurgent Preservice Nonbehavioral Medicaid Postservice Medicare Advantage Standard Medicare Advantage Expedited Medicare Advantage Standard Part B Drugs Medicare Advantage Expedited Part B Drugs Minimum of Applicable Categories
5	NOTIF_RECPNT_TYPE_C_NAME	VARCHAR	No
	The unique ID of the required recipient type of the notification requirement. May contain organization-specific values: No Category Entries: Member Provider Authorized Representative
6	NOTIF_TOPIC_C_NAME	VARCHAR	No
	The unique ID of the notification topic of the notification requirement. May contain organization-specific values: No Category Entries: Approval Notification Denial Notification Notification of Extension Denial of Request to Expedite Dismissal Notification
7	RELATED_COMM_ID	VARCHAR	No
	The communication record that satisfies this notification requirement.
8	NOTIF_DUE_UTC_DTTM	DATETIME (UTC)	No
	The date and time (UTC) that the notification requirement is due.
9	NOTIF_COMPLETE_UTC_DTTM	DATETIME (UTC)	No
	The date and time (UTC) that the notification requirement was completed.