CL_BEV_ALL
Description:
This table holds the no-add, single-response items from the Bed Events (BEV) master file.

Primary Key
Column Name Ordinal Position
RECORD_ID 1

Column Information
Name Type Discontinued?
1 RECORD_ID NUMERIC No
The unique ID of the bed event record.
2 EVENT_TYPE_C_NAME VARCHAR No
The bed event type category number for this bed event.
May contain organization-specific values: No
Category Entries:
Environmental Services
Bed Blocking
Bed Ahead
Bed Type
3 EVENT_SOURCE_C_NAME VARCHAR No
The bed event source category number for this bed event.
May contain organization-specific values: Yes
Category Entries:
Discharge
Transfer
Ad-Hoc Request
Maintenance Cleaning
Leave of Absence
Auto Creation by Scheduling Non-Bed Clean
4 BED_ID VARCHAR No
The unique ID of the bed that this bed event pertains to.
5 BED_ID_BED_LABEL VARCHAR No
The name of the bed.
6 EAF_ID_LOC_NAME VARCHAR No
The name of the revenue location.
7 PRIORITY_C_NAME VARCHAR No
The priority category number for the bed event.
May contain organization-specific values: No
Category Entries:
Stat
Next
Normal
8 DEP_ID_EXTERNAL_NAME VARCHAR No
The external name of the department record. This is often used in patient correspondence such as reminder letters.
9 EPT_ID VARCHAR No
The unique ID of the patient that was associated with this bed event.
10 EPT_CSN NUMERIC No
The unique contact serial number of the patient encounter that was associated with this bed event.
11 REASN_BED_NT_ASGN_C_NAME VARCHAR No
The reason not assigned category number for the bed event (if applicable). This item is cleared when the bed is assigned for cleaning.
May contain organization-specific values: No
Category Entries:
CMJ test
12 RECORD_CREATION_DT DATETIME No
The date when this record was created.
13 CANCEL_USER_ID VARCHAR No
The unique ID of the user record for the user who canceled this bed event. This column is only populated for events that have been canceled.
14 CANCEL_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
15 CANCEL_EVENT_TM DATETIME (Local) No
The instant when the bed event was canceled. This column is only populated for events that have been canceled.
16 ADHOC_USER_ID VARCHAR No
The unique ID of the user record for the user who created this bed event. This column is only populated for cleaning requests that weren't created automatically.
17 ADHOC_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
18 LINKED_EVENT_ID NUMERIC No
The unique ID of the Admission, Transfer, Discharge, or Leave of Absence (ADT) event that is associated with this bed event.
19 BED_TYPE_C_NAME VARCHAR No
This item tracks the bed type for the bed associated with the bed event record.
May contain organization-specific values: Yes
Category Entries:
Empty
Standard
Crib
Telemetry
Bariatric
20 PREV_OUT_EVENT_ID NUMERIC No
The unique ID of the previous outgoing event of type Discharge, Transfer Out or LOA Out. If the previous event on the bed is of type incoming (Admission, Transfer In, LOA Return) instead of an outgoing type, then this item will be empty.
21 NEXT_IN_EVENT_ID NUMERIC No
The unique ID of the next incoming event of type Admission, Transfer In, or LOA Return. If the next event on the bed is of type outgoing (Discharge, Transfer Out, LOA Out) instead of an incoming type, then this item will be empty.