Tables installed with Field Service Management

  • Release version: Washingtondc
  • Updated February 1, 2024
  • 1 minute to read

    • Tables are added with Field Service Management.

    Table 1. Tables installed with Field Service Management
    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:
    Applicable only when the system property Update the wm_work_order_task_potential_assignment_groups table with potential assignment groups for the work order task is set to Yes.
    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.