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. |
Parent Topic:Components installed with Field Service Management