ATB_ROOT
Description:
ATB ROOT Data.

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 authorization bundle record.
2 PAT_ID VARCHAR No
Patient for ATB
3 REFERRAL_ID NUMERIC No
Associated Authorization Referral
4 COVERAGE_ID NUMERIC No
Coverage associated with the ATB.
5 TYPE_SVC_LINE_C_NAME VARCHAR No
The Type of Service Line category ID for the Auth Bundle that identifies the type of a service line, for example differentiating a procedure from a bed day.
May contain organization-specific values: No
Category Entries:
Procedure
Bed Day
6 REF_TO_MAIN_AUTH_BUNDLE_ID NUMERIC No
The reference to the Main ATB. Main ATBs won't have this data item set, most other ATB types will have it set.
7 AUTH_EVENT_TYPE_C_NAME VARCHAR No
The event type of this ATB if this ATB is an event record.
May contain organization-specific values: No
Category Entries:
Initial Submission to Payer
Revision to Payer
Payer Decision
Reversion to Previous Decision
8 EVENT_IS_EDITABLE_YN VARCHAR No
Whether this event typed ATB is editable as opposed to if it is an immutable and historical record.
May contain organization-specific values: No
Category Entries:
No
Yes
9 EVENT_STATUS_C_NAME VARCHAR No
The event status of the record, as in whether the event is in progress or finished.
May contain organization-specific values: No
Category Entries:
In Progress
Finalized
Canceled
10 ABANDON_SVC_ROOT_ID NUMERIC No
The pointer to the Authorization type Auth Bundle record to be set when this Service Line or Service Line Event type Auth Bundle is considered to be "Deleted".
11 SERVICE_ID_REF VARCHAR No
The reference ID to use when referring to a Service Line from an outside context.
12 EVENT_RESOLUTION_INST_UTC_DTTM DATETIME (UTC) No
Contains the instant that an event was completed or discarded. The instant is stored as the value in UTC.
13 EVENT_RESOLUTION_USER_ID VARCHAR No
Contains the user that completed or discarded the event.
14 EVENT_RESOLUTION_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.