1. Capital Asset Management Implementation Guide
  2. Queries for the Maintenance Scheduler Persona

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