The DB Editor can also view and edit the different tables which make up InfoAsset Planner's Work Manager tool. Work Management tables include work orders, inspection, and service requests.
To open Work Management tables via the DB Editor, expand one of the Work Item folders; that is, Work Order, Inspection, Service Request, or one of their corresponding Details folders.
Notice that these Work Management tables are divided into three groups (Work Orders, Inspections, and Service Requests) with specified sub tables. These sub-tables are described below:
- Active Work Item table (i.e., Work Order) - Includes basic information concerning the work item including the ID, Type, Status, and Date/Time information. It is easy to add fields to the active Work Item tables; however, removing fields may cause unexpected errors and is not advised.
- Work Item table Archive (i.e., Work Order Archive) - Work Items may be set as "Active" or "Archived" if perhaps they are completed and not as relevant. Archived items will be stored in their corresponding Archive tables. Like the Active Work Items tables, adding fields to Archive table is possible; however, removing fields may cause unexpected errors and is not advised.
- Details tables (i.e., IMIC_PlanPipeRepair) - Associated tables with other relevant information my be joined to the root Work Item table. So long as they can be joined with the unique Work Order, Inspection, or Service Request ID, users may add their own custom detail tables. Default Details tables being with the prefix 'IMIC_', but users may add other, compatible custom tables to the InfoAsset Planner project database if necessary. Compared to the Active and Archived tables, Details tables are best for adding/removing fields as necessary.
Like other DB Editor tables, the Work Management tables are fully editable.