ATB_AUTH_OBJECTIVES
Description:
This table contains data for authorization objectives. A row in this table represents one objective.

Primary Key
Column Name Ordinal Position
AUTH_BUNDLE_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 AUTH_BUNDLE_ID NUMERIC No
The unique identifier (.1 item) for the auth bundle record.
2 LINE INTEGER No
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 OBJECTIVE_ID_REF VARCHAR No
The reference ID to use to distinguish this objective from other objective lines in the objective related group.
4 OBJECTIVE_TYPE_C_NAME VARCHAR No
This item store the type of objective that the data ona given line in the objective related group represents.
May contain organization-specific values: No
Category Entries:
Submit Initial Request
Respond to Payer Request
Revise Request
Resolve Other Outstanding Tasks
File Electronic Payer Decision
File Manual Payer Decision
5 OBJECTIVE_STATUS_C_NAME VARCHAR No
This item holds the status of the objective on a given line of the objective related group.
May contain organization-specific values: No
Category Entries:
Completed
Outstanding
Discarded
6 OBJ_AUTH_BUNDLE_ID NUMERIC No
This item contains the ID of the ATB record that the objective will be completed on. This item is populated only on ATBs of type Authorization in order to get to the correct ATB of type Authorization Event to be edited.
7 CREATION_UTC_DTTM DATETIME (UTC) No
Contains the instant that a given objective was created. Stored as instant in UTC.
8 CREATION_USER_ID VARCHAR No
Stores the user responsible for creating or starting an objective, if the objective was manually created. Blank if the objective was automatically created.
9 CREATION_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
10 RESOLUTION_UTC_DTTM DATETIME (UTC) No
Contains the instant that an objective was completed or discarded. The instant is stored as the value in UTC.
11 RESOLUTION_USER_ID VARCHAR No
Stores the user responsible for completing or discarding the authorization objective on the given line of the objective related group.
12 RESOLUTION_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.