ATB_AUTH_TASKS
Description:
This table contains data for authorization tasks. One row represents a task.

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 TASK_ID_REF VARCHAR No
Unique reference ID that can be used to point to a certain line in the tasks related group.
4 AUTH_TASK_TYPE_C_NAME VARCHAR No
Represents the type of task that must be completed in order to complete the associated authorization objective.
May contain organization-specific values: No
Category Entries:
Respond to Clinical Document Request
Review Clinical Document Attachment
Answer Payer Questionnaire
Submit Manually
Resolve AAA Error
Resolve Guardrail Error
Resolve Payer Provided Validation Error
Resolve Data Requirement
Resolve Data Validation
Prepare Clinical Documentation Attachment
Resolve Auth Submission Requirement Rule
5 AUTH_TASK_STATUS_C_NAME VARCHAR No
Represents the status of the task on a given line of the tasks related group.
May contain organization-specific values: No
Category Entries:
Completed
Outstanding
Discarded
6 DISPLAY_STRING VARCHAR No
User-facing string explaining the steps required for this task to be completed.
7 TASK_OBJ_ID_REF VARCHAR No
Contains the reference ID of the objective that this task is a requirement for.
8 CAN_MANUALLY_RESOLVE_YN VARCHAR No
Stores whether or not a task can be manually resolved. If No or empty, it can only be resolved by automated validations running again.
May contain organization-specific values: No
Category Entries:
No
Yes
9 PYR_DV_ERROR_TYPE_C_NAME VARCHAR No
For tasks created from a payer-provided validation, stores the type of data validation error that created this task.
May contain organization-specific values: No
Category Entries:
Missing Data
Invalid Data
Data Mismatch
10 TASK_CREATION_UTC_DTTM DATETIME (UTC) No
Stores the instant that this task was created, in the UTC timezone.
11 TASK_CREATION_USER_ID VARCHAR No
Stores the user responsible for creating this task.
12 TASK_CREATION_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
13 TASK_COMPLETION_UTC_DTTM DATETIME (UTC) No
Stores the instant that this task was created. Instant is stored formatted in UTC timezone.
14 TASK_COMPLETION_USER_ID VARCHAR No
Stores the user responsible for completing the task.
15 TASK_COMPLETION_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
16 GRDRL_SETTING_ID NUMERIC No
Contains the ID of the guardrail record that is responsible for creating this task.
17 GRDRL_SETTING_ID_SETTING_NAME VARCHAR No
Setting record name.
18 GENERATION_RULE_ID VARCHAR No
Contains the ID of the rule record that is responsible for creating this task.
19 GENERATION_RULE_ID_RULE_NAME VARCHAR No
The name of the rule.