AUTH_REQUEST_HX
Description:
This table contains a snapshot of information about an individual authorization request as of a point in time.

Primary Key
Column Name Ordinal Position
AUTH_REQUEST_ID 1
CONTACT_DATE_REAL 2

Column Information
Name Type Discontinued?
1 AUTH_REQUEST_ID NUMERIC No
The unique identifier for the authorization request.
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 AUTH_REQUEST_CNCT_TYPE_C_NAME VARCHAR No
The contact type category ID for the authorization request.
May contain organization-specific values: No
Category Entries:
Published
Draft
Historic
Resolved Chart Sync Conflict
Ignored Chart Sync Remote Draft
4 UM_STATUS_C_NAME VARCHAR No
The status category ID for the authorization request.
May contain organization-specific values: No
Category Entries:
Authorized
Partially Authorized
Pending Review
Withdrawn
Denied
Dismissed
No Authorization Required
Closed
Pending External Review
5 CONTACT_UTC_DTTM DATETIME (UTC) No
The date and time (UTC) of the authorization request contact. If this contact is a draft, this column holds the date and time that this draft contact was created. If this contact is published, this column holds the date and time that it was published.
6 HISTORY_USER_ID VARCHAR No
The unique ID of the user record of the user who created this contact. This column is frequently used to link to the CLARITY_EMP table.
7 HISTORY_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
8 AUTH_REQUEST_TYPE_C_NAME VARCHAR No
The request type category ID for the authorization request.
May contain organization-specific values: No
Category Entries:
Proactive
Preservice
Concurrent
Retro
Externally Tracked
Appeal
9 INSTANT_OF_ENTRY_UTC_DTTM DATETIME (UTC) No
The date and time (UTC) of when the authorization request contact was edited.
10 FINALIZED_STATUS_UTC_DTTM DATETIME (UTC) No
The date and time (UTC) the finalized status was made on the authorizations in this request.
11 SUBMISSION_OVRIDE_UTC_DTTM DATETIME (UTC) No
The date and time (UTC) of the user-override value for the authorization request submission.
12 SUBMISSION_RPT_UTC_DTTM DATETIME (UTC) No
The reported submission date and time (UTC) of the authorization request. If an override value is set, the override value is shown. Otherwise, this is the system-calculated value.
13 DECISION_OVRIDE_UTC_DTTM DATETIME (UTC) No
The date and time (UTC) of the user-override value for the authorization request decision.
14 DECISION_RPT_UTC_DTTM DATETIME (UTC) No
The reported decision date and time (UTC) of the authorization request. If an override value is set, the override value is shown. Otherwise, this is the system-calculated value.
15 ADDL_INFO_REQ_SYS_UTC_DTTM DATETIME (UTC) No
The date and time (UTC) of the system-calculated value of the additional information request.
16 ADDL_INFO_REQ_OVRIDE_UTC_DTTM DATETIME (UTC) No
The date and time (UTC) of the user-override value of the additional information request.
17 ADDL_INFO_RCPT_SYS_UTC_DTTM DATETIME (UTC) No
The system-calculated date and time (UTC) of the additional information receipt.
18 ADDL_INFO_RCPT_OVRIDE_UTC_DTTM DATETIME (UTC) No
The user-override date and time (UTC) of the additional information receipt instant.
19 PEER_TO_PEER_OFFER_UTC_DTTM DATETIME (UTC) No
The date and time (UTC) that the peer-to-peer review was offered.
20 PEER_TO_PEER_COMPLETE_UTC_DTTM DATETIME (UTC) No
The date and time (UTC) that the peer-to-peer review was completed.
21 PRIORITY_C_NAME VARCHAR No
The unique ID of the priority of the authorization request.
May contain organization-specific values: Yes
Category Entries:
Routine
Urgent
Emergency
Elective
Two Week Wait
See Details
22 RFL_TYPE_C_NAME VARCHAR No
The unique ID of the type of the authorization request.
May contain organization-specific values: Yes
23 SERVICE_REQUESTER_C_NAME VARCHAR No
The unique ID of the requester of the authorization request.
May contain organization-specific values: No
Category Entries:
Contracted Provider
Non-Contracted Provider
Enrollee
Enrollee's Representative
24 MEM_RESP_GUID VARCHAR No
A unique key representing the authorized representative associated with the authorization request. This can be used to join to table MEMBER_RESP_PERSON on MEM_RESP_GUID to report on demographic information associated with the authorized representative.
25 REF_BY_IS_CONTRACTED_SYS_YN VARCHAR No
The system-calculated value of whether the referred by entity is contracted or not.
May contain organization-specific values: No
Category Entries:
No
Yes
26 REF_BY_IS_CONTRACTED_OVRIDE_YN VARCHAR No
The user-override value of whether the referred by entity is contracted or not.
The category values for this column were already listed for column: REF_BY_IS_CONTRACTED_SYS_YN
27 REF_TO_IS_CONTRACTED_SYS_YN VARCHAR No
The system-calculated value of whether the referred to entity is contracted or not.
The category values for this column were already listed for column: REF_BY_IS_CONTRACTED_SYS_YN
28 REF_TO_IS_CONTRACTED_OVRIDE_YN VARCHAR No
The user-override value of whether the referred to entity is contracted or not.
The category values for this column were already listed for column: REF_BY_IS_CONTRACTED_SYS_YN
29 MED_DIRECTOR_REVIEW_YN VARCHAR No
Indicates whether medical director review was performed on this authorization request.
The category values for this column were already listed for column: REF_BY_IS_CONTRACTED_SYS_YN
30 MED_DIRECTOR_REVIEW_USER_ID VARCHAR No
The unique ID of the user who performed medical director review.
31 MED_DIRECTOR_REVIEW_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
32 DENIED_FOR_LACK_OF_MED_NEC_YN VARCHAR No
Whether the authorization request was denied for lack of medical necessity.
The category values for this column were already listed for column: REF_BY_IS_CONTRACTED_SYS_YN
33 PEER_TO_PEER_STATUS_C_NAME VARCHAR No
The unique ID of the status of the peer-to-peer review offer.
May contain organization-specific values: No
Category Entries:
Offered
Offered - Didn't Occur
Not Offered
Completed
N/A
34 ADDL_INFO_EXTENSION_TAKEN_YN VARCHAR No
Whether an additional information request extension was taken for the authorization request.
The category values for this column were already listed for column: REF_BY_IS_CONTRACTED_SYS_YN
35 MANUAL_EXTENSION_DAYS INTEGER No
The number of manual extension days taken for the authorization request.
36 SUBMISSION_SYS_UTC_DTTM DATETIME (UTC) No
The date and time (UTC) of the system-calculated value for the authorization request submission instant, based on associated communications with a purpose of Request for Authorization.
37 DECISN_UM_STATUS_CHANGE_SRC_C_NAME VARCHAR No
The change source category ID that resulted in the decision status being set for the authorization request.
May contain organization-specific values: No
Category Entries:
Manual Update
Auto Status Assignment
Imported
278N
278R
INTERNAL PRIOR AUTH
Auto Status Assignment Pre-Check
38 HISTORY_EDIT_SOURCE_C_NAME VARCHAR No
Where the contact (authorization request edit) was created from.
May contain organization-specific values: No
Category Entries:
End User Workflow
Import
System Processing
Chart Sync
UM Submission
Configuration Update Utility
Workqueue
Networked Record Audit Batch
Turnaround Time Refresh
Automatic Coverage Update
Tapestry Link Submission
UM Response
Background Queue
39 ADDL_INFO_REQ_EXT_TKN_UTC_DTTM DATETIME (UTC) No
The date and time (UTC) of when additional information request extension was taken for the authorization request.
40 ADDL_INFO_REQ_USER_ID VARCHAR No
The unique ID of the user who made the additional info request.
41 ADDL_INFO_REQ_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
42 MED_DIRECTOR_REVIEW_NOTE_ID VARCHAR No
The unique ID associated with the medical director review note.
43 MAN_EXT_DAYS_TKN_DTTM DATETIME (Local) No
The date and time (local) of when manual extension days were taken.
44 MAN_EXT_DAYS_TKN_UTC_DTTM DATETIME (UTC) No
The date and time (UTC) of when manual extension days were taken.
45 MAN_EXT_DAYS_USER_ID VARCHAR No
The unique ID of the user who has taken the manual extension days.
46 MAN_EXT_DAYS_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
47 EXPEDITED_STATUS_C_NAME VARCHAR No
The expedite status of the authorization request.
May contain organization-specific values: No
Category Entries:
Standard
Expedited
48 RQST_TO_EXPEDITE_DTTM DATETIME (Local) No
The instant of the request to expedite communication in local time zone.
49 RQST_TO_EXPEDITE_UTC_DTTM DATETIME (UTC) No
The instant of the request to expedite communication in UTC time zone.
50 RQST_TO_EXPEDITE_COMM_ID VARCHAR No
The unique ID of the communication record that represents the request to expedite.
51 PRIORITY_UPGRADE_DTTM DATETIME (Local) No
The instant the priority of a standard authorized request changed to a priority that is part of the expedited/urgent priorities list in the system setting in local time zone.
52 PRIORITY_UPGRADE_UTC_DTTM DATETIME (UTC) No
The instant the priority of a standard authorized request changed to a priority that is part of the expedited/urgent priorities list in the system setting in UTC time zone.
53 PRIORITY_UPGRADE_USER_ID VARCHAR No
The unique ID of the user who changed the priority of a standard authorization request to a priority part of the expedited/urgent priorities list in the system settting.
54 PRIORITY_UPGRADE_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
55 PRIORITY_DOWNGRADE_DTTM DATETIME (Local) No
The instant the priority of an expedited authorization request changed to a priority not part of the expedited/urgent priorities list in the system setting in local time zone.
56 PRIORITY_DOWNGRADE_UTC_DTTM DATETIME (UTC) No
The instant the priority of an expedited authorization request changed to a priority not part of the expedited/urgent priorities list in the system setting in UTC time zone.
57 PRIORITY_DOWNGRADE_USER_ID VARCHAR No
The unique ID of the user who changed the priority of an expedited authorization request to a priority not part of the expedited/urgent priorities list in the system settting.
58 PRIORITY_DOWNGRADE_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
59 CLM_NET_OVRIDE_STAT_C_NAME VARCHAR No
The network status to override to when adjudicating the linked claim.
May contain organization-specific values: No
Category Entries:
None
In Network
Out of Network
60 CLM_NET_OVRIDE_LVL_C_NAME VARCHAR No
The network level to override to when adjudicating the linked claim.
May contain organization-specific values: Yes
Category Entries:
Not Leveled
61 CLM_NET_OVRIDE_RSN_C_NAME VARCHAR No
The reason for override a linked claim's adjudication network.
May contain organization-specific values: Yes
62 OVERTURNED_ON_APPEAL_OVRIDE_YN VARCHAR No
Indicates whether any denied service on this authorization request was later overturned on appeal. Intended to be imported as an override value to the calculated value in AUTH_REQUEST.OVERTURNED_ON_APPEAL_YN.
The category values for this column were already listed for column: REF_BY_IS_CONTRACTED_SYS_YN
63 ELECTRONIC_SUBMIT_OVERRIDE_YN VARCHAR No
The user-override value for whether the authorization was electronically submitted.
The category values for this column were already listed for column: REF_BY_IS_CONTRACTED_SYS_YN
64 ELECTRONIC_SUBMIT_REPORT_YN VARCHAR No
The reported value of whether the authorization was electronically submitted. If an override value is set, the override value is shown. Otherwise, this is the system-calculated value.
The category values for this column were already listed for column: REF_BY_IS_CONTRACTED_SYS_YN