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.
Table 1. Tables installed with Planned Work Management
Table Description
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.
Table 2. Roles in Planned Work Management
Roles Description
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.
Table 3. Script includes installed with Planned Work Management
Script Include Description
PlannedWorkManagementExtensionPointImpl Implements the Global.PlannedMaintenanceExtensionPoint extension point.
PlannedWorkMgmtAjaxUtil Utility function for client scripts in planned work management.
PlannedWorkMgmtAPIHelperUtil Utilities for wrapper function to invoke global scoped APIs from planned work management scope.
FSMPWMUtil Utility function for planned work management scoped application.
PWMForecastWOUtil Utility function to forecast work orders for the planned work.
PlannedMaintenanceExtensionPointImpl Default implementation for planned maintenance application.
PlannedMaintenanceExtPointUtil Utility in the planned maintenance application to retrieve extension points based on sys_class_name.
PlannedWorkManagementHistoryUtil Utility in the planned work maintenance application to fetch the maintenance cycles history for an asset or inventory.
PlannedWorkManagementScheduleUtil Maintains the processing logic for plan work record, schedule occurrences, work note comments etc.
PlannedWorkMangementPlanUtil Utility methods related to work plan.
PlannedWorkManagementEffectivityUtil Utility methods to determine and validate the effectivity of the schedule.
PlannedWorkManagementScheduleExeUtil Acts as switch between the implementations of the PlannedWorkManagementExeExtensionPoint extension point based on order type. The default value of order type is work order.
PWMWorkOrderExeExtensionPointImpl Implementation of the PlannedWorkManagementExeExtensionPoint extension point for the order type selected as work order.
PlannedWorkManagementConstants Holds the constants for plan work management.
PWMScheduleSuppression Maintains the processing logic of schedule suppression.
PWMScheduleOccurrence Maintains the processing logic of schedule occurrence.
PWMScheduleOccurrenceDAO Maintains the DAO methods of schedule occurrence.
PWMWorkScheduleDAO Maintains the DAO methods for work schedule.
PWMPlanWorkRecordDAO Maintains the DAO methods for plan record.

Business rules

Planned Work Management adds the following business rules.
Table 4. Business rules installed with Planned Work Management
Business rule Table Description
cross scope record creation Work 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 inactive Planned 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 plan Planned 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 schedule Planned Work Schedule Template

[wm_m2m_schedule_template]

Restricts the creation of duplicate model schedule in the table.
Restrict table map for model Template 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 fields Planned 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, end Work Plan

[wm_planned_work_plan]

Checks if the effective start and end date of the work plan are valid.
Work schedule template to maint schedule Planned 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 order Work Order Task

[wm_Task]

Updates the latest completion date in work order for grace time SLA.
Compare schedule template tasks Schedule Suppression

[wm_m2m_schedule_suppression]

Suppresses schedule occurrences by comparing planned work schedule templates.
Validate cyclic dependency Schedule Suppression

[wm_m2m_schedule_suppression]

Blocks duplicate and cyclic dependencies.
Suppress SO by schedule Schedule Occurrence

[wm_plan_work_schedule_occurrence]

Checks and suppresses a schedule occurrence.
Suppress SO by suppressBy schedule Schedule Occurrence

[wm_plan_work_schedule_occurrence]

Runs suppression logic based on suppressBy schedule added.
Cancel WO if SO inactive Schedule Occurrence

[wm_plan_work_schedule_occurrence]

Cancels the work orders of a schedule occurrence when you inactivate the schedule occurrence.
Check effective start of SO Schedule Occurrence

[wm_plan_work_schedule_occurrence]

Validates if the earliest start date a schedule occurrence is before the requested due date.
Change WO fields on SO field changes Schedule Occurrence

[wm_plan_work_schedule_occurrence]

Updates work orders with the latest values from schedule occurrences.