Work Request Status

For simplification, the Requested ’by Status label groups Assigned to Work Order status and Requested' status into one category .

For the sample HUMC-02 floor, there are no work requests Requested status, there are some with Assigned to Work Order status.

For the three statuses that appear on the Maintenance tab's “Requests by Status” panel, only open work requests are displayed . They are grouped as follows:

• WHEN wr.status IN ('R', 'AA') THEN the group label displays 'Requested'

• WHEN wr.status IN ('I') THEN the group label displays 'Issued and In Process'

• WHEN wr.status IN ('HP', 'HA', 'HL') THEN the group label displays 'On Hold'

Here is the complete list of values for Work Request Status

• Rev -- Reviewed but On Hold

• Rej -- Rejected

• A -- Approved

• AA -- Assigned to Work Order

• I -- Issued and In Process

• HP -- On Hold for Parts

• HA -- On Hold for Access

• HL -- On Hold for Labor

• S -- Stopped

• Can -- Cancelled

• Com -- Completed

• Clo -- Closed

Example Determine Room Access for Maintenance Work

In healthcare settings, rooms are occupied by patients or house medical activities that take priority over maintenance work. For example, the maintenance team cannot easily enter an ICU or a patient-occupied room and to repair a heating system or do construction work.

In medical settings, rooms typically have color-coded flags that indicate if a room is ready to be occupied (for example, the flag is green); in this case, the room is not yet occupied by a patient and might be available for maintenance work

For unoccupied rooms, maintenance staff must sync with the medical staff and get approval for work.

Since the window of opportunity is limited, maintenance managers need to communicate to the team all the work they need to do in the room, all the deficiencies they need to fix.

1. In the Rooms tab, note the Room Flag Color field. A site can customize its own Room Flag Color Codes and import them from their external patient system, via a custom connector.

2. On the floor plan, turn on the Room Flag/Access border highlight.

3. Notice that some rooms on the floor plan are highlighted in green. These are rooms that are not occupied and available for maintenance.

4. Turn on the solid highlight Work Request Priority or Work Request Status.

5. For the rooms that have a green border and a solid red color, explain that these are rooms that are not occupied and for which there is pending high-priority maintenance work that needs to be addressed. For example, the below image shows that the room in the upper right corner has high-priority maintenance work and is currently available.

6. A maintenance manager or facility manage contacts (via telephone) the floor manager and requests access to those rooms.

7. Once access is granted, select the rooms on the floor plan and click “View selected.” In the Maintenance tab of the pop-up, you can access all the work requests that you need to fix. In the PM tab, you have all the preventive work that you need to address in the next month. Thus, once you get access to a room you can have a list of work to do

Usage Note

There is a bug in that the Work Request Status solid highlight is hiding the drawing.

It is very easy to fix for a developer with minimal expertise. There is a typo and a field missing from the SQL statement in \schema\ab-products\healthcare\ ab-hc-mnt-console-drawing-ds.axvw.

Make these corrections:

• Line 168: add o.wr_status

• Line 193: change o2.status to o2.wr_status

See Also

Facilities Console: Overview