AUTHORIZATIONS_2
Description:
This table contains additional information about authorization records.

Primary Key
Column Name Ordinal Position
AUTH_ID 1

Column Information
Name Type Discontinued?
1 AUTH_ID NUMERIC No
The unique identifier (.1 item) for the authorization record.
2 UM_WORKFLOW_STAGE_C_NAME VARCHAR No
The workflow stage category ID for the authorization.
May contain organization-specific values: No
Category Entries:
Intake & Admin Review
Medical Review
Medical Director Review
Pre-Decision
Decision
3 DTR_DOC_NEEDED_YN VARCHAR No
Whether DTR is required before submitting Authorization Request
May contain organization-specific values: No
Category Entries:
No
Yes
4 DTR_AGENCY_ID VARCHAR No
The Guideline Vendor responsible for DTR Questionnaires for this request
5 DTR_AGENCY_ID_AGENCY_NAME VARCHAR No
The name of the agency.
6 DTR_REQ_AUD_ID NUMERIC No
The record ID of the PPR record tracking this DTR session
7 UM_CVG_GUIDANCE_EXP_DATE DATETIME No
The expiration date of the requested coverage guidance.
8 PROV_AUTO_AUTH_YN VARCHAR No
Whether authorization request will be automatically authorized.
The category values for this column were already listed for column: DTR_DOC_NEEDED_YN
9 PAT_FHIR_ID VARCHAR No
The FHIR Patient ID in the DTR request.
10 SVC_REQ_FHIR_ID VARCHAR No
The FHIR ServiceRequest ID in the DTR request.
11 CVG_FHIR_ID VARCHAR No
The FHIR Coverage ID in the DTR request.
12 DTR_HISTORICAL_AUTH_ID NUMERIC No
Historical coverage guidance authorization record linked to this authorization record
13 DTR_ANSWER_ID VARCHAR No
The internal guideline generated QuestionnaireResponse returned via DTR for this request
14 APPR_PA_AMT_FREQUENCY_TYPE_C_NAME VARCHAR No
Determines the approved timing of the service. This is the referral version of Tapestry frequency I AUT 2080.
May contain organization-specific values: No
Category Entries:
Milliseconds
Seconds
Minutes
Hours
Days
Weeks
Months
Years
15 REQ_PA_AMT_FREQUENCY_TYPE_C_NAME VARCHAR No
Determines the requested timing of the service. This is the referral version of Tapestry frequency I AUT 2083.
The category values for this column were already listed for column: APPR_PA_AMT_FREQUENCY_TYPE_C_NAME
16 APPEALED_ORIG_SERVICE_AUTH_ID NUMERIC No
The ID of the original authorization request service that was appealed.
17 COPIED_FROM_AUTH_ID NUMERIC No
The source authorization ID of a split or copied authorization request
18 USER_SVC_UNIT_TYPE_C_NAME NUMERIC No
The user-entered unit type for this service.
May contain organization-specific values: No
Category Entries:
Days
Days of Rental
Doses of Medication
Hours
Months of Rental
Procedures
Purchase Items
Units
15 Minutes
30 Minutes
Months
Trips
Visits
Days of Maintenance
Months of Maintenance
19 SVC_UNIT_TYPE_C_NAME NUMERIC No
Unit type associated with the service, taking the unit type set by the user in I AUT 2096 into account.
The category values for this column were already listed for column: USER_SVC_UNIT_TYPE_C_NAME
20 UAR_PX_AUTH_REQD_YN VARCHAR No
This item stores the authorization requirement determined by UAR for a single service. It is set on Service Auths and Coverage Guidance AUTs. Set to No if the service doesn't require authorization. Set to Yes if the service requires authorization. Left blank if the service is externally delegated or not covered.
The category values for this column were already listed for column: DTR_DOC_NEEDED_YN
21 EXT_SVC_CONTACT_PAYER_YN VARCHAR No
This indicates whether contact payer status is received in Payer Platform from an external system for this service.
The category values for this column were already listed for column: DTR_DOC_NEEDED_YN