AUTH_REQ_HX_DECISION_REQT

Description:

This table contains the various decision-related timeliness requirements for a given review category for a contact.

Primary Key

Column Name	Ordinal Position
AUTH_REQUEST_ID	1
CONTACT_DATE_REAL	2
LINE	3

Column Information

	Name	Type	Discontinued?
1	AUTH_REQUEST_ID	NUMERIC	No
	The unique identifier for the authorization request record.
2	CONTACT_DATE_REAL	FLOAT	No
	A unique contact date in decimal format. The integer portion of the number indicates the date of contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc.
3	LINE	INTEGER	No
	The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
4	REVIEW_CATEGORY_C_NAME	VARCHAR	No
	The unique ID of the review category that the decision requirements apply to. May contain organization-specific values: Yes Category Entries: Behavioral Commercial Urgent Concurrent Behavioral Commercial Urgent Preservice Behavioral Commercial Nonurgent Preservice Behavioral Commercial Postservice Behavioral Marketplace Urgent Concurrent Behavioral Marketplace Urgent Preservice Behavioral Marketplace Nonurgent Preservice Behavioral Marketplace Postservice Behavioral Medicare Urgent Concurrent Behavioral Medicare Urgent Preservice Behavioral Medicare Nonurgent Preservice Behavioral Medicare Postservice Behavioral Medicaid Urgent Concurrent Behavioral Medicaid Urgent Preservice Behavioral Medicaid Nonurgent Preservice Behavioral Medicaid Postservice Nonbehavioral Commercial Urgent Concurrent Nonbehavioral Commercial Urgent Preservice Nonbehavioral Commercial Nonurgent Preservice Nonbehavioral Commercial Postservice Nonbehavioral Marketplace Urgent Concurrent Nonbehavioral Marketplace Urgent Preservice Nonbehavioral Marketplace Nonurgent Preservice Nonbehavioral Marketplace Postservice Nonbehavioral Medicare Urgent Concurrent Nonbehavioral Medicare Urgent Preservice Nonbehavioral Medicare Nonurgent Preservice Nonbehavioral Medicare Postservice Nonbehavioral Medicaid Urgent Concurrent Nonbehavioral Medicaid Urgent Preservice Nonbehavioral Medicaid Nonurgent Preservice Nonbehavioral Medicaid Postservice Medicare Advantage Standard Medicare Advantage Expedited Medicare Advantage Standard Part B Drugs Medicare Advantage Expedited Part B Drugs Minimum of Applicable Categories
5	CALCULATION_METHOD_C_NAME	VARCHAR	No
	The unique ID of the calculation method of the due date for this review category. May contain organization-specific values: No Category Entries: Calendar Time Calendar Days Business Days Calendar Days Excluding Holidays
6	DECISION_REQ_START_UTC_DTTM	DATETIME (UTC)	No
	The date and time (UTC) of the start instant for authorization request timeliness as determined for this review category.
7	DECISION_STANDARD_DUE_UTC_DTTM	DATETIME (UTC)	No
	The calculated decision due date and time (UTC) of the authorization request without any extensions taken for this review category.
8	DECISION_CURRENT_DUE_UTC_DTTM	DATETIME (UTC)	No
	The current decision due date and time (UTC) of the authorization request for this review category.
9	ADDL_INFO_REQUEST_DUE_UTC_DTTM	DATETIME (UTC)	No
	The date and time (UTC) by which an additional information request extension can be taken for this review category.
10	ADDL_INFO_RECEIPT_DUE_UTC_DTTM	DATETIME (UTC)	No
	The date and time (UTC) when the receipt of additional information is due. Only set if additional information was requested.
11	DCSN_REQ_START_SRC_C_NAME	VARCHAR	No
	The source of the start instant for authorization request timeliness as determined for this review category. May contain organization-specific values: No Category Entries: Submission Request to Expedite Auth Rep Document Reception