AUTH_REQ_HX_INP_AUTH
Description:
This table contains data in the Inpatient Authorization level of the inpatient data model. data here corresponds to one to many rows in the AUTH_REQUEST_HX table.

Primary Key
Column Name Ordinal Position
AUTH_REQUEST_ID 1
CONTACT_DATE_REAL 2

Column Information
Name Type Discontinued?
1 AUTH_REQUEST_ID NUMERIC No
The unique identifier (.1 item) 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 INP_ADMISSION_DATE DATETIME No
The date the member was admitted for an inpatient stay. This value is set at the inpatient authorization level and is sourced from the override admit date on the referral.
4 INP_DISCHARGE_DATE DATETIME No
The date the member was discharged from an inpatient stay. This value is set at the inpatient authorization level and is sourced from the override discharge date on the referral.
5 INP_ADMISSION_SOURCE_C_NAME NUMERIC No
The source of the inpatient admission. This value is set at the inpatient authorization level.
May contain organization-specific values: Yes
6 INP_DISCHRG_DISP_C_NAME NUMERIC No
The disposition of the member at discharge from an inpatient stay. This value is set at the inpatient authorization level.
May contain organization-specific values: Yes
7 INP_EARLIEST_START_DATE DATETIME No
The earliest start date across all inpatient review lines for this inpatient authorization. This tracks when the first authorized bed day period begins, which may differ from the admission date.
8 INP_LATEST_END_DATE DATETIME No
The latest end date across all inpatient review lines for this inpatient authorization. This tracks when the last authorized bed day period ends, which may differ from the discharge date.
9 INP_EXPECTED_ADMISSION_DATE DATETIME No
The expected date for the member's inpatient admission. This is typically set during a preservice review before the actual admission occurs.
10 INP_EXPECTED_DISCHARGE_DATE DATETIME No
The expected date for the member's discharge from an inpatient stay. This is typically set during a preservice review before the actual discharge occurs.
11 CONTACT_UTC_DTTM DATETIME (UTC) No
The date and time (UTC) of the authorization request contact. If this contact is a draft, this column holds the date and time that this draft contact was created. If this contact is published, this column holds the date and time that it was published.
12 INP_NEXT_REVIEW_DATE DATETIME No
The next date a concurrent review is due for this inpatient authorization. Used by utilization management staff to prioritize and schedule upcoming bed day reviews.