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 PAT_FHIR_ID VARCHAR No
The FHIR Patient ID in the DTR request.
9 SVC_REQ_FHIR_ID VARCHAR No
The FHIR ServiceRequest ID in the DTR request.
10 CVG_FHIR_ID VARCHAR No
The FHIR Coverage ID in the DTR request.
11 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.
May contain organization-specific values: No
Category Entries:
Milliseconds
Seconds
Minutes
Hours
Days
Weeks
Months
Years
12 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.
The category values for this column were already listed for column: REQ_PA_AMT_FREQUENCY_TYPE_C_NAME
13 DTR_HISTORICAL_AUTH_ID NUMERIC No
Historical coverage guidance authorization record linked to this authorization record
14 DTR_ANSWER_ID VARCHAR No
The internal guideline generated QuestionnaireResponse returned via DTR for this request