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
Utilization Management Pharmacy
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 Authorization
Routed Externally
Incoming Notification
Owned by Another Payer
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 all denied services on this authorization request were later overturned on appeal.
The category values for this column were already listed for column: CREATED_BY_PENDING_CVG_YN
40 | SPLIT_FROM_AUTH_REQUEST_ID | NUMERIC | No |
The AUG ID that this authorization request is split from.
41 | AUTH_BENEFIT_TYPE_C_NAME | VARCHAR | No |
The benefit type category ID of the authorization request indicating whether the authorization request applies to medical benefits or pharmacy benefits.
May contain organization-specific values: No
Category Entries:
Medical
Pharmacy
42 | SOURCE_AUTH_REQUEST_ID | NUMERIC | No |
Tracks the source authorization request that this request was created from.
43 | DERIVATION_TYPE_C_NAME | VARCHAR | No |
Indicates how the child authorization request was created from the parent request.
May contain organization-specific values: No
Category Entries:
Copy workflow
44 | PUBLISHED_START_DATE | DATETIME | No |
The authorization start date (I AUG 2600) from the published contact.