AUTH_REQUEST
Description:
This table contains information about an individual authorization request.

Primary Key
Column Name Ordinal Position
AUTH_REQUEST_ID 1

Column Information
Name Type Discontinued?
1 AUTH_REQUEST_ID NUMERIC No
The unique identifier for the authorization request.
2 RECORD_STATUS_2_C_NAME VARCHAR No
The Chronicles record status category ID for the authorization request.
May contain organization-specific values: No
Category Entries:
Soft Deleted
Hidden
Hidden and Soft Deleted
3 EXTERNAL_IDENTIFIER VARCHAR No
The external identifier of the authorization request.
4 LAST_EDIT_UTC_DTTM DATETIME (UTC) No
The date and time (UTC) of the latest published (non-draft) contact of the authorization request.
5 REQUEST_CONTEXT_C_NAME VARCHAR No
The request context category ID for the authorization request.
May contain organization-specific values: No
Category Entries:
Utilization Management
Utilization Management Appeals
Utilization Management Bed Days
6 PAT_ID VARCHAR No
The unique ID of the patient/member that this authorization request is for. This column is frequently used to link to the PATIENT table.
7 REFERRAL_ID NUMERIC No
The unique ID of the referral record that this authorization request is associated with.
8 COVERAGE_ID NUMERIC No
The unique ID of the coverage record that applies to this authorization request.
9 REQUEST_CREATION_UTC_DTTM DATETIME (UTC) No
The date and time (UTC) that this authorization request was initiated.
10 LOB_ID VARCHAR No
The unique ID of the line of business associated with the coverage when the authorization request was processed.
11 LOB_ID_LOB_NAME VARCHAR No
The name of the line of business record.
12 PAYER_ID_PAYOR_NAME VARCHAR No
The name of the payor.
13 BENEFIT_PLAN_ID_BENEFIT_PLAN_NAME VARCHAR No
The name of the benefit plan record.
14 ORDER_ENTRY_ORDER_ID NUMERIC No
When an authorization request is received, if any of the requested services were created during order entry, this column will be populated as a pointer back to the order.
15 DECISION_USER_ID VARCHAR No
The unique ID of the user responsible for the decision of the authorization request. In the case of medical director review, this is the person who conducted the medical director review rather than the user who changed the status in the system. This column is frequently used to link to the CLARITY_EMP table.
16 DECISION_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
17 UM_DECISION_USER_ROLE_C_NAME VARCHAR No
The decision user role category ID for the user making the decision on the authorization request.
May contain organization-specific values: No
Category Entries:
Non-Medical Director
Medical Director
Auto Status Assignment
Decision Made Externally
Auto Status Assignment Pre-Check
18 RESP_PARTY_AGENCY_ID VARCHAR No
The unique ID of the responsibility class of the party responsible for rendering a decision for the authorization request.
19 RESP_PARTY_AGENCY_ID_AGENCY_NAME VARCHAR No
The name of the agency.
20 EXT_TRACKED_RSN_C_NAME VARCHAR No
Keeps track of the reason why this auth request's turnaround time is tracked externally.
May contain organization-specific values: No
Category Entries:
Legacy Auth Request
Routed Through Payer Platform
Incoming 278N
21 APPEALED_AUTH_REQUEST_ID NUMERIC No
The Authorization Request that was adversely determined and is being appealed by this Request.
22 REGION_ID_LOC_NAME VARCHAR No
The name of the revenue location.
23 MEDICAL_GROUP_ID_LOC_NAME VARCHAR No
The name of the revenue location.
24 CREATED_BY_PENDING_CVG_YN VARCHAR No
This item will be set to Yes if the authorization request was originally created using a non-verified coverage.
May contain organization-specific values: No
Category Entries:
No
Yes
25 PREVIOUS_COVERAGE_ID NUMERIC No
When an Authorization Request is created with a non-verified coverage, the Authorization Request is eligible for a one-time coverage change. If the coverage is changed, this item will provide a link to the previous coverage.
26 CVG_CHANGE_SOURCE_C_NAME VARCHAR No
When an Authorization Request is created with a pending coverage, the Authorization Request is eligible for a one-time coverage change. If the coverage is changed, this item indicates if the change was initiated manually by a user or done automatically by the system.
May contain organization-specific values: No
Category Entries:
Manual
Automatic
27 CVG_CHANGE_USER_ID VARCHAR No
When an Authorization Request is created with a pending coverage, the Authorization Request is eligible for a one-time coverage change. If the coverage is changed, this item provides a link to the user that initiated the change.
28 CVG_CHANGE_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
29 CVG_CHANGE_UTC_DTTM DATETIME (UTC) No
When an Authorization Request is created with a pending coverage, the Authorization Request is eligible for a one-time coverage change. If the coverage is changed, this item stores the instant in which the change was made.
30 REQUESTING_ORGANIZATION_ID NUMERIC No
The unique ID of the organization that initiated this auth request.
31 REQUESTING_ORGANIZATION_ID_EXTERNAL_NAME VARCHAR No
Organization's external name used as the display name on forms and user interfaces.
32 GUIDE_REVIEW_VENDOR_C_NAME VARCHAR No
The guideline review vendor that is used for the guideline review process for the authorization request.
May contain organization-specific values: Yes
33 GUIDE_REV_INIT_MTHD_C_NAME VARCHAR No
The method used to initiate the guideline review process for the authorization request.
May contain organization-specific values: No
Category Entries:
Automated Request
Manual Entry
Tapestry Link
34 GUIDE_REV_REQ_DTTM DATETIME (Local) No
The instant the guideline review request was sent to the guideline review vendor. If the guideline review was manually initiated, this item is left blank.
35 GUIDE_REV_REQ_UTC_DTTM DATETIME (UTC) No
The instant the guideline review request was sent to the guideline review vendor. If the guideline review was manually initiated, this item is left blank.
36 EXT_EVENT_MSG VARCHAR No
Event-level MSG data received by Payer Platform from an external system.
37 EXT_EVT_REF_NUM VARCHAR No
the administrative reference number received by Payer Platform from an external system for this event
38 EXT_EVT_AUTH_NUM VARCHAR No
the authorization number received by Payer Platform from an external system for this event
39 OVERTURNED_ON_APPEAL_YN VARCHAR No
Indicates whether any denied service on this authorization request was later overturned on appeal.
The category values for this column were already listed for column: CREATED_BY_PENDING_CVG_YN