Tables installed with Field Service Management
Tables are provided with the Field Service Management application.
| Table | Description |
|---|---|
| Work Order [wm_order] |
Stores work order records. |
| Work Order Flow [sf_work_order] |
Stores the work order state flow records. |
| Work Order Model [cmdb_workorder_product_model] |
Stores the Product Catalog work order model records. This table was modified by the Field Service Management plugin. This table is renamed and part of Service Order Management. |
| Work Order Task [wm_task] |
Unit of work performed by one person, in one session (one location and one time). |
| Work Task Flow [sf_work_task] |
Stores the work task state flow records. |
| Work Task Model [cmdb_servicetask_product_model] |
Stores the Product Catalog work task model records. This table was modified by the Field Service Management plugin. This table is renamed and part of Service Order Management. |
| WM Map Filters Config [wm_map_filters_config] |
Stores filter configurations for the agent map on the mobile UI. |
| Questionnaire [wm_questionnaire] |
Stores questionnaires created for work orders and work order tasks. |
| Work Type [wm_work_type] |
Stores the type of work performed by an agent to complete the work order task. |
| Work Order Task Potential Assignment Groups [wm_work_order_task_potential_assignment_groups] |
Calculates and stores the potential assignment group if there are multiple assignment groups that can be serviced for a work order task. Note: This is applicable only when:
|
| Scheduling history [wm_task_scheduling_history] |
Stores the history of the scheduling method of how each work order task has been assigned along with date and time. |
| Assets [alm.asset] |
Stores the inventory along with the cost and stockroom details. |
| Resource Schedule Attributes [wm_agent_schedule_attribute_plan] |
Stores the attributes like start date, end date, start location, end location, shift hours etc of agents. |