HL_GROUP_INFO
Description:
Hospital Logistics Group Information.

Primary Key
Column Name Ordinal Position
HLR_ID 1

Column Information
Name Type Discontinued?
1 HLR_ID NUMERIC No
The unique identifier (.1 item) for the request record.
2 HLR_TYPE_C_NAME VARCHAR No
The Hospital Logistics Request type.
May contain organization-specific values: No
Category Entries:
Request
Group
Job
3 GROUP_TYPE_C_NAME VARCHAR No
Indicates what type of Logistics Group this is.
May contain organization-specific values: Yes
Category Entries:
Manual
Default
Bed Clean
Stat Interrupt
4 GROUP_STATUS_C_NAME VARCHAR No
This Logistics Group's current status.
May contain organization-specific values: No
Category Entries:
Pending
Started
Completed
Canceled
Held
5 GROUP_REGION_SEC_ID NUMERIC No
The Logistics Region that this Group belongs to.
6 GROUP_REGION_SEC_ID_RECORD_NAME VARCHAR No
The name of this cleaning sector.