ATB_AUTH_SERVICE_DETAILS
Description:
This table contains information about the service being requested for authorization.

Primary Key
Column Name Ordinal Position
AUTH_BUNDLE_ID 1

Column Information
Name Type Discontinued?
1 AUTH_BUNDLE_ID NUMERIC No
The unique identifier (.1 item) for the Auth Bundle record.
2 AUTH_SVC_CODE_REP_C_NAME VARCHAR No
The Service Code Representation category ID for the Auth Bundle.This item outlines what the "code" is that this Service represents. A code could be a recognized code set, a list or range of those code set values, or a free text string.
May contain organization-specific values: No
Category Entries:
Coded Procedure
Revenue Code Only
3 AUTH_CODE_PROC_ID_PROC_NAME VARCHAR No
The name of each procedure.
4 AUTH_REV_CODE_ID NUMERIC No
The unique ID of the Revenue Code that details the care that this particular service outlines.
5 AUTH_REV_CODE_ID_REVENUE_CODE_NAME VARCHAR No
The name of the revenue code.
6 AUTH_MEDICATION_ID_MEDICATION_NAME VARCHAR No
The name of this medication record.
7 AUTH_PA_AMT_QUANTITY_TYPE_C_NAME VARCHAR No
The Quantity Type category ID for the Auth Bundle's count information.
May contain organization-specific values: No
Category Entries:
Units
Visits
International Units
Episodes
Milliseconds
Seconds
Minutes
Hours
Days
Weeks
Months
Years
8 AUTH_QUANTITY INTEGER No
The Quantity amount for the Auth Bundle's count information.
9 AUTH_PA_AMT_FREQUENCY_TYPE_C_NAME VARCHAR No
The Frequency Type category ID for the Auth Bundle's count information.
May contain organization-specific values: No
Category Entries:
Milliseconds
Seconds
Minutes
Hours
Days
Weeks
Months
Years
10 AUTH_FREQUENCY INTEGER No
The Frequency amount for the Auth Bundle's count information.
11 AUTH_PA_AMT_PERIOD_TYPE_C_NAME VARCHAR No
The Period Type category ID for the Auth Bundle's count information.
May contain organization-specific values: No
Category Entries:
Visits
Episodes
Remaining
Milliseconds
Seconds
Minutes
Hours
Days
Weeks
Months
Years
12 AUTH_PERIODS INTEGER No
The Periods amount for the Auth Bundle's count information.
13 AUTH_BED_DAY_TYPE_ID NUMERIC No
The unique ID of the Bed Day for Auth Bundle services that pertain to Bed Days.
14 AUTH_BED_DAY_TYPE_ID_BED_DAY_TYPE_NAME VARCHAR No
The name of the bed day type record (i.e. ICU or non-authorized.)
15 AUTH_BED_DAY_COUNT INTEGER No
The count of days that this service represents, if this service pertains to Bed Days.
16 AUTH_NIGHT_COUNT INTEGER No
The count of nights that this service represents, if this service pertains to Bed Days.