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
Medicare Advantage Standard (Post-1/1/2026)
Medicare Advantage Standard Part D Drugs
Medicare Advantage Expedited Part D Drugs
Minimum of Applicable Categories
Do Not Apply Timeliness Standards
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.