Skip to content
Release: Australia · Updated: 2026-03-12 · Official documentation · View source

Planned Work Management components

Several types of components are installed with Planned Work Management, including tables, roles, script includes, and business rules.

Tables

Planned Work Management adds the following tables.

TableDescription
Work Plan\[wm\_planned\_work\_plan\]Stores the entities filtered for the work plan.
Planned Work Schedule\[wm\_planned\_work\_schedule\]Stores the schedules configured for a work plan. A schedule can be duration, meter, condition, or script based.
Planned Work Schedule Template\[wm\_m2m\_schedule\_template\]Stores the list of work order templates applied to planned work schedules.
Planned Work Record\[wm\_m2m\_work\_plan\_to\_record\]Relates a work plan schedule to a record in the system \(from a document ID\). Also contains information about the last time or value the schedule ran for the record and the next time or value when the schedule will run.
Template Attribute Mapping\[wm\_m2m\_template\_attribute\_map\]Stores the attribute mapping for a work order template.
Schedule Occurrence\[wm\_plan\_work\_schedule\_occurrence\]Stores the occurrences of the work schedule.
Schedule Suppression\[wm\_m2m\_schedule\_suppression\]Stores the occurences of suppressed work schedules.

Roles

Planned Work Management adds the following roles.

RolesDescription
Planned work admin \[sn\_fsm\_planned\_wm.planned\_work\_admin\]Create work plans, planned work schedules, link work order templates to the schedules, and generate work orders.

Script Includes

Planned Work Management adds the following script includes.

Script IncludeDescription
PlannedWorkManagementExtensionPointImplImplements the Global.PlannedMaintenanceExtensionPoint extension point.
PlannedWorkMgmtAjaxUtilUtility function for client scripts in planned work management.
PlannedWorkMgmtAPIHelperUtilUtilities for wrapper function to invoke global scoped APIs from planned work management scope.
FSMPWMUtilUtility function for planned work management scoped application.
PWMForecastWOUtilUtility function to forecast work orders for the planned work.
PlannedMaintenanceExtensionPointImplDefault implementation for planned maintenance application.
PlannedMaintenanceExtPointUtilUtility in the planned maintenance application to retrieve extension points based on sys_class_name.
PlannedWorkManagementHistoryUtilUtility in the planned work maintenance application to fetch the maintenance cycles history for an asset or inventory.
PlannedWorkManagementScheduleUtilMaintains the processing logic for plan work record, schedule occurrences, work note comments etc.
PlannedWorkMangementPlanUtilUtility methods related to work plan.
PlannedWorkManagementEffectivityUtilUtility methods to determine and validate the effectivity of the schedule.
PlannedWorkManagementScheduleExeUtilActs as switch between the implementations of thePlannedWorkManagementExeExtensionPoint extension point based on order type. The default value of order type is work order.
PWMWorkOrderExeExtensionPointImplImplementation of the PlannedWorkManagementExeExtensionPoint extension point for the order type selected as work order.
PlannedWorkManagementConstantsHolds the constants for plan work management.
PWMScheduleSuppressionMaintains the processing logic of schedule suppression.
PWMScheduleOccurrenceMaintains the processing logic of schedule occurrence.
PWMScheduleOccurrenceDAOMaintains the DAO methods of schedule occurrence.
PWMWorkScheduleDAOMaintains the DAO methods for work schedule.
PWMPlanWorkRecordDAOMaintains the DAO methods for plan record.

Business rules

Planned Work Management adds the following business rules.

Business ruleTableDescription
cross scope record creationWork Plan\[wm\_planned\_work\_plan\]Creates the cross scope access record on the table on which Maintenance plan is created and must be run.
cancel WO when plan record inactivePlanned Work Record\[wm\_m2m\_work\_plan\_to\_record\]Cancels the work order for a plan record when that plan record is inactivated. The Plan record gets deactivated when the asset record is modified so that it doesn’t satisfies the filter condition at the plan level.
Planned work schedule to maintenance planPlanned Work Schedule \[wm\_planned\_work\_schedule\]Restricts the creation of Planned work schedule for maintenance plan. Only allows when the Plan is of class Planned work.
Restrict model per schedulePlanned Work Schedule Template\[wm\_m2m\_schedule\_template\]Restricts the creation of duplicate model schedule in the table.
Restrict table map for modelTemplate Attribute Mapping\[wm\_m2m\_template\_attribute\_map\]Restricts the user to have single table map per a work order template
Update m2m schedule records new fieldsPlanned Work Schedule\[wm\_planned\_work\_schedule\]Updates the schedule record and recalculates the next value or next run time when meter or duration fields change.
Validate plan effective start, endWork Plan\[wm\_planned\_work\_plan\]Checks if the effective start and end date of the work plan are valid.
Work schedule template to maint schedulePlanned Work Schedule Template\[wm\_m2m\_schedule\_template\]Restricts the user to add maintenance schedule to planned work schedule template.
Update latest completion date in Work orderWork Order Task\[wm\_Task\]Updates the latest completion date in work order for grace time SLA.
Compare schedule template tasksSchedule Suppression\[wm\_m2m\_schedule\_suppression\] 
Validate cyclic dependencySchedule Suppression\[wm\_m2m\_schedule\_suppression\] 
Suppress SO by schedule suppressionSchedule Suppression\[wm\_m2m\_schedule\_suppression\] 
Suppress SO by scheduleSchedule Occurrence \[wm\_plan\_work\_schedule\_occurrence\] 
Suppress SO by suppressBy scheduleSchedule Occurrence \[wm\_plan\_work\_schedule\_occurrence\] 
Cancel WO if SO inactiveSchedule Occurrence \[wm\_plan\_work\_schedule\_occurrence\] 
Check effective start of SOSchedule Occurrence \[wm\_plan\_work\_schedule\_occurrence\] 
Change WO fields on SO field changesSchedule Occurrence \[wm\_plan\_work\_schedule\_occurrence\] 

Parent Topic:Components installed with additional plugins for Field Service Management

Related topics

Extension points in Field Service Management