Set up the external work order table
- Last UpdatedSep 25, 2023
- 3 minute read
Note: External work order table is an arbitrary name that AVEVA™ Production Management Help uses to distinguish the table from the work order table in AVEVA™ Production Management. The work order table in AVEVA™ Production Management is not a database table, and it does not create or store data. AVEVA™ Production Management uses the work order table item to read the external work order table. The business may apply any name to the external work order table.
The external work order table is a database table that the business creates in a Microsoft SQL database and makes available to AVEVA™ Production Management. The business exports data from its Enterprise Asset Management (EAM) system to populate the external work order table with data about work order requests. After you configure Maintenance, AVEVA™ Production Management can read the external work order table and make the work order requests available to view and print in AVEVA™ Production Management. AVEVA™ Production Management also inserts work order requests that originate in AVEVA™ Production Management into the external work order table.
How the external and internal work order tables differ
The external work order table is a database table. It performs these functions:
-
Supplies Maintenance with data about work order requests.
-
Stores data about work order requests that it receives from the EAM system and AVEVA™ Production Management.
-
The work order table in AVEVA™ Production Management is not a database table. It performs these functions:
-
Reads the external work order table.
-
Writes to the external work order table.
-
Makes work order requests available to AVEVA™ Production Management to view and print.
Set up the external work order table
This step is done externally to AVEVA™ Production Management. For AVEVA™ Production Management to read data from and insert data into the external work order table, the table setup must meet the following requirements:
-
The external work order table exists in a Microsoft SQL table in an SQL database.
-
The external work order table contains fields that serve the purpose of work order request number, equipment ID, and originator. No restrictions apply to the names of these fields.
-
The business makes the external work order table available for AVEVA™ Production Management to read from and insert data into.
Required fields for work order table
The external work order table can include as many fields as the business requires. The following list describes the fields that the external work order table must contain.
|
Field |
Description |
|---|---|
|
Work Order Request Number |
The business can apply any name to this field. This is a unique identifier for the work order request. The table has a system to automatically number each work order request. The data type of the field can be long, string, or integer. The configuration of Maintenance specifies how work order request numbers are generated for work order requests that originate in AVEVA™ Production Management. |
|
Equipment ID |
The business can apply any name to this field. This is an identifier for the equipment on which the work order request is made. The data type of the field is String. The configuration of Maintenance associates an Equipment ID with a location in the plant hierarchy. |
|
Originator |
The business can apply any name to this field. This is the identifier for the person who initiates the work order request. The data type of the field is String. The configuration of Maintenance specifies the identifier that appears in the Originator field when the user initiates a work order request. |