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.