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
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