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:
Attach Clinical Document for Payer
Review Clinical Document
Answer Payer Questionnaire
Submit Manually
Resolve Error Requirement
Resolve Guardrail Error
Resolve Payer Provided Validation Error
Resolve Data Requirement
Resolve Data Validation
Prepare Clinical Document
Resolve Auth Submission Requirement Rule
Review Payer Modifications
Review Received Document
Review Suggestion
Contact Payer
Review Payer Rejected Cancellation
Review Services Not Covered
Review Data Changes on Main Authorization
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.
20 | SECONDARY_DISPLAY_CONTENT | VARCHAR | No |
The secondary display content to show with the task when displayed to a user. This does not contribute towards the task fingerprint. When displaying the task, if this item is not populated, the system will attempt to calculate the secondary display content dynamically.
21 | TSK_TYP_MSG_CODE_C_NAME | VARCHAR | No |
This item contains a category value specific to the individual validation or check that results in this task being created. Used as a sort of categorization of the task's display message.
May contain organization-specific values: No
Category Entries:
Auth Start Date Too Far in Past
Document File Size Exceeded
Document Not Generated
Missing Admission Type
Invalid Admission Type
Missing Admission Source
Invalid Admission Source
Invalid Patient Status
Coverage Not Effective as of From Date
Member ID Is Required
Coverage Is Not Verified
Coverage Is Not Valid for Referral
Discharge Date Before Admission Start Date
Missing Auth Start Date
Auth End Date Before Start Date
Service Dates Outside Auth Dates
Missing Diagnosis
Referring Location Is Not Requester
Entity Missing Primary Identifier
Missing POS Type
Missing UB Type of Bill or POS Type
Missing UB Bill Classification
Quantity Not Greater than Zero
Admission Days Not Greater than Zero
Service Count Not Greater than Zero
Service Missing Procedure Code
Service Missing Revenue Code
Suggested Services Need Review
Service Type Not Supported
Electronic Auth Method Not Supported
Invalid Auth Number
Missing Linked Coverage
UM Coverage is Delinquent
Primary Coverage not Determined
Missing Service Provider
Missing Referred By Provider
Auth Decision Invalid
Missing Auth Number
Not All Services Marked as No Auth Required
Service Decisions Not Valid for Partial Auth
Not All Services Denied
Not All Services Withdrawn
Not All Services Dismissed
Clinical Document Recommended
Auto-Generated Doc Needs Review
Too Many Diagnoses
Missing Requester
Missing Service Provider/Location
Missing Provider Last Name
Missing Facility Name
Point of Contact Has No Contact Info
Point of Contact Name Invalid
Point of Contact Phone Invalid
Point of Contact Fax Invalid
Point of Contact Email Invalid
Received Doc Needs Review
Missing Request Type
Submission Requirement Rule Evaluation
Missing Service Code Representation
Missing Service Type
Payer Guardrail Evaluation
Payer Rejected Cancellation
Review Payer Modifications
Answer Questionnaire
External Error Requirement
Contact Payer
Clinical Document Required
Missing Point of Contact Name
Missing Point of Contact Phone
Missing Point of Contact Fax
Missing Point of Contact Email
Review Payer Decision as Overwrite of Current Decision
Missing Principal Diagnosis
Missing Principal Diagnosis Date
Missing Previous Auth or Reference Number
Service has Incomplete Recurring Counts
Invalid Questionnaire Error
Missing Service Code Description
Service Start Date Before Admission Start Date
Service Procedure Dates Invalid
Not all services Not Covered
Authorization or Reference Number not Allowed
Patient Opt Out
Service is Not Covered
Payer eMPA Off