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
Procedure (Medication)
Revenue Code
Dental
Anesthesia
Post-Acute Service
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
Respond to Payer Documentation Request
Resolve Unsolicited Document Error
Discard Main Authorization
File Received Document
Review Received Document
Answer Payer Questionnaire
Update Suggestions
Cancel Authorization
Electronic Status Inquiry
Submit Auth Requirements Request
File Auth Requirements Response
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.
15 | ATB_HAS_AUTH_EDITOR_EDITS_YN | VARCHAR | No |
This item tracks whether an end user has made a notable edit to the ATB through the authorization editor, like adding a diagnosis, resolving a task, or submitting authorization. Only end user edits that originate in a Hyperspace style workflow are relevant.
The category values for this column were already listed for column: EVENT_IS_EDITABLE_YN
16 | LAST_REQ_EVENT_AUTH_BUNDLE_ID | NUMERIC | No |
This item stores a reference to the most recent historical event ATB record which represents a request submitted to the payer.
17 | LAST_DEC_EVENT_AUTH_BUNDLE_ID | NUMERIC | No |
This item stores a reference to the most recent historical event ATB record which represents a decision from the payer.
18 | PAYR_REQ_OUTREACH_YN | VARCHAR | No |
Tracks if the payer requested outreach by returning an action code of Contact Payer (CT).
The category values for this column were already listed for column: EVENT_IS_EDITABLE_YN