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
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.
17 | AUTH_QUANTITY_PER_PERIOD | INTEGER | No |
The Quantity Per Period amount for the Auth Bundle's count information.
18 | AUTH_PROC_CODE_DESC | VARCHAR | No |
The procedure code description storing additional information related to the procedure code.
19 | AUTH_SERVICE_GROUPER_ID_GROUPER_NAME | VARCHAR | No |
Record name