HL_REQ_INFO_AUDIT

Description: |
Hospital Logistics Request Information Audit.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
HLR_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | HLR_ID | NUMERIC | No |
The unique identifier for the request 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 | ENTRY_UTC_DTTM | DATETIME (UTC) | No |
The UTC instant when a change was made to this Logistics Request's info.
4 | ENTRY_USER_ID | VARCHAR | No |
The user that made the change to this Logistics Request.
5 | ENTRY_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
6 | ENTRY_TECH_ID | NUMERIC | No |
The Logistics Technician that made the change to this Logistics Request.
7 | START_UTC_DTTM | DATETIME (UTC) | No |
The audit trail for this Logistics Request's start instant (I HLR 115).
8 | PRIORITY_C_NAME | VARCHAR | No |
The audit trail for this Logistics Request's priority (I HLR 120).
May contain organization-specific values: No
Category Entries:
Stat
High
Normal
Low
9 | START_PLF_ID_RECORD_NAME | VARCHAR | No |
The name of the PLF record.
10 | DYNAMIC_START_TYPE_C_NAME | VARCHAR | No |
The audit trail for this Logistics Request's dynamic start location type (I HLR 126).
May contain organization-specific values: No
Category Entries:
Specified Location
Current Location
Current Bed
Preassignment
Procedure Room
11 | END_PLF_ID_RECORD_NAME | VARCHAR | No |
The name of the PLF record.
12 | DYNAMIC_END_TYPE_C_NAME | VARCHAR | No |
The audit trail for this Logistics Request's dynamic end location type (I HLR 131).
The category values for this column were already listed for column: DYNAMIC_START_TYPE_C_NAME
13 | TECHS_NUM | INTEGER | No |
The audit trail for this Logistics Request's number of required techs (I HLR 135).
14 | MODE_C_NAME | VARCHAR | No |
The audit trail for this Logistics Request's mode (I HLR 140).
May contain organization-specific values: Yes
15 | REGION_SEC_ID | NUMERIC | No |
The audit trail for this Logistics Request's region (I HLR 240).
16 | REGION_SEC_ID_RECORD_NAME | VARCHAR | No |
The name of this cleaning sector.
17 | SECTOR_SEC_ID | NUMERIC | No |
The audit trail for this Logistics Request's sector (I HLR 241).
18 | SECTOR_SEC_ID_RECORD_NAME | VARCHAR | No |
The name of this cleaning sector.
19 | DEPARTMENT_ID_EXTERNAL_NAME | VARCHAR | No |
The external name of the department record. This is often used in patient correspondence such as reminder letters.
20 | HOSP_LOC_ID_LOC_NAME | VARCHAR | No |
The name of the revenue location.
21 | SERV_AREA_ID_LOC_NAME | VARCHAR | No |
The name of the revenue location.
22 | PHONE_NUMBER | VARCHAR | No |
The audit trail for this Logistics Request's phone number (I HLR 260).
23 | BED_TYPE_C_NAME | VARCHAR | No |
The audit trail for this Logistics Request's bed type (I HLR 148).
May contain organization-specific values: Yes
Category Entries:
Empty
Standard
Crib
Telemetry
Bariatric
24 | TRIP_TYPE_C_NAME | VARCHAR | No |
The audit trail indicating this request's trip type. Blank is interpreted as One-Way.
May contain organization-specific values: No
Category Entries:
One-Way
Round Trip