Queries for the Maintenance Scheduler Persona

The queries for the maintenance scheduler persona are associated with the Work With Work Orders (P48201), One View Equipment License/Permit Information (P13500), and Condition-Based Alerts Workbench (P1310) programs.

The following table lists and describes the queries available for the maintenance scheduler:

Query Name

Program

Criteria

Overdue PMs

Work With Work Orders (P48201)

  • WO Type = 6

  • Actual Finish Date = Blank

Open Emergency Work Orders

Work With Work Orders (P48201)

  • WO Type = 5

  • Actual Finish Date = Blank

Overdue Work Orders

Work With Work Orders (P48201)

  • Actual Finish Date = Blank

  • Requested Finish Date < Today

CBM Alerts

Condition-Based Alerts Workbench (P1310)

  • Alert Level = 2

  • Alert Status = 1

CBM Warnings

Condition-Based Alerts Workbench (P1310)

  • Alert Level = 1

  • Alert Status = 1