|
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 |
NUMERIC |
No |
|
|
|
| The audit trail for this Logistics Request's start location (I HLR 125). |
|
|
| 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 |
|
|
| 11 |
END_PLF_ID |
NUMERIC |
No |
|
|
|
| The audit trail for this Logistics Request's end location (I HLR 130). |
|
|
| 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 |
NUMERIC |
No |
|
|
|
| The audit trail for this Logistics Request's department (I HLR 242). |
|
|
| 20 |
HOSP_LOC_ID |
NUMERIC |
No |
|
|
|
| The audit trail for this Logistics Request's hospital location (I HLR 243). |
|
|
| 21 |
SERV_AREA_ID |
NUMERIC |
No |
|
|
|
| The audit trail for this Logistics Request's service area (I HLR 244). |
|
|
| 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 |
|
|
