Manufacturing Execution System (MES)

Data Editor

User Guide

Version 6.0
June, 2018
© 2018 AVEVA Group plc or its subsidiaries. All rights reserved.
The Schneider Electric industrial soft ware business and AVEVA have merged to trade as AVEVA Group
plc, a UK listed company. The Schneider Electric and Life is On trademarks are owned by Schneider
Electric and are being licensed to AVEVA by Schneider Electric.
No part of this documentation shall be reproduced, stored in a ret rieval system, or transmitted by any
means, electronic, mechanical, photocopying, rec ording, or otherwise, without the prior written
permission of AVEVA. No liability is assumed with respect to the use of the information contained herein.
Although precaution has been taken in the preparation of this documentation, AV EVA assumes no
responsibility for errors or omissions. The information in this documentation is subject to change without
notice and does not represent a commitment on the part of AVEVA. The soft ware described in this
documentation is furnished under a license agreement. This soft ware may be used or copied only in
accordance with the terms of such license agreement.
ArchestrA, Aquis, Avantis, DYNS IM, eDNA, EYESIM, InBatch, InduSoft, InStep, IntelaTrac, InTouch,
PIPEPHASE, PRiSM, PRO/II, PROV IS ION, ROMeo, SIM4ME, SimCentral, SimSci, Skelta,
SmartGlance, Spiral Software, Termis, WindowMaker, WindowViewer, and Wonderware are trademarks
of AVEVA and/or its subsidiaries. An extensive listing of AVEVA trademarks can be found at:
https://sw.aveva.com/legal. All other brands may be trademarks of their respective owners.
Publication date: 6/29/2018
Contact Information
AVEVA Group plc
High Cross
Madingley Road
Cambridge
CB3 OHB. UK
https://sw.aveva.com/
For information on how to cont act sales, customer training, and technical support, see
https://sw.aveva.com/contact.
 MES Data Editor User Guide

Contents
Chapter 1 Getting Started..................................................................................................... 5
Introduction .............................................................................................................................. 5
Precautions for Using Data Edit or .............................................................................................. 5
Logging In to Data Editor ........................................................................................................... 6
Data Editor Layout and Controls ................................................................................................ 7
On-Screen Keyboard................................................................................................................. 7
Filtering the Grid ....................................................................................................................... 8
Performance Checking ........................................................................................................ 9
Editing a Record ....................................................................................................................... 9
Inserting a Record................................................................................................................... 10
Copying a Record ................................................................................................................... 10
Deleting a Record ................................................................................................................... 11
Refreshing the Grid ................................................................................................................. 11
Filter and Data E ntry Controls .................................................................................................. 11
Configuring Tab Components .................................................................................................. 15
Configuring Grids .............................................................................................................. 15
Specifying What Columns and Rows Are Displayed ....................................................... 15
Grouping Grid Data ..................................................................................................... 16
Sorting by Columns ..................................................................................................... 17
Changing the Column Order......................................................................................... 18
Filtering the Grid.......................................................................................................... 18
Configuring a Tab's Button Bar........................................................................................... 18
Saving and Reloading Tab Configurations .......................................................................... 20
Viewing Version Information About the MES Database .............................................................. 20

Chapter 2 Maintaining Item Consumption Records on the BOM Tab ......................... 21

Introduction to the BOM Tab .................................................................................................... 21
Item Consumption Filter .......................................................................................................... 21
Item Consumption Data ........................................................................................................... 23

Chapter 3 Maintaining Item Production Records on the Production Tab ................... 25

Introduction to the Production Tab ............................................................................................ 25
Item Production Filters............................................................................................................. 26
Item Production Data............................................................................................................... 27

Chapter 4 Maintaining Labor Usage Records on the Labor Tab ................................. 29

Introduction to the Labor Tab ................................................................................................... 29

Version 6.0 3
MES Data Editor User Guide Contents

Labor Us e Filter ...................................................................................................................... 30

Labor Us e Data....................................................................................................................... 31

Chapter 5 Maintaining Lot and Sublot Records on the Lot Tab ................................... 33
Introduction to the Lots Tab ..................................................................................................... 33
Lot Filter ................................................................................................................................. 34
Inserting a New Lot ................................................................................................................. 34
Renaming a Lot or Sublot ........................................................................................................ 35

Chapter 6 Maintaining Job Step Data Records on the Steps Tab ............................... 37
Introduction to the Steps Tab ................................................................................................... 37
Job Step Dat a Filter ................................................................................................................ 37
Job Step Dat a......................................................................................................................... 39

Chapter 7 Maintaining Utilization and Job History Records on the Utilization Tab ... 41
Introduction to the Utilization Tab ............................................................................................. 41
Entity Usage Filter................................................................................................................... 42
Entity Usage Dat a ................................................................................................................... 43
Job History Dat a ..................................................................................................................... 44

4 Version 6.0
 MES Data Editor User Guide

C HAPTER 1
Getting Started
In This Chapter
Introduction .................................................................................................................................... 5
Precautions for Using Data Edit or .................................................................................................... 5
Logging In to Data Editor................................................................................................................. 6
Data Editor Layout and Controls ...................................................................................................... 7
On-Screen Keyboard ...................................................................................................................... 7
Filtering the Grid ............................................................................................................................. 8
Editing a Record ............................................................................................................................. 9
Inserting a Record ........................................................................................................................ 10
Copying a Record ......................................................................................................................... 10
Deleting a Record ......................................................................................................................... 11
Refreshing the Grid....................................................................................................................... 11
Filter and Data E ntry Controls ........................................................................................................ 11
Configuring Tab Components ........................................................................................................ 15
Viewing Version Information About the MES Database .................................................................... 20

Introduction
Manufacturing Execution System (MES) Data E ditor is used t o insert, edit, and delete data records in the
MES databas e. Using the Data Editor, you can view and alter dat a for item production, item
consumption, labor usage, item lots, job steps, and entity utilization.
Data Editor is organized by tabs, which separate the different types of data that can be maintained. The
data records that appear in the tabs can be filtered, to help you focus on those records that you want to
view or manage.

Precautions for Using Data Editor

Data Editor is designed for use by someone very familiar with the MES database and the information
stored in the MES database tables. It is not intended for most users of the MES system, as the y should
have access to MES Operat or, MES Client, MES Web Portal, or a custom user interface making calls
through the MES API. In many cases, Data Editor directly calls the underlying stored procedures to
update, delet e, or insert records in the underlying table, bypassing the MES middleware. Therefore,
access to Data Editor should be limited only to those with a good understanding of the underlying data.
Access to Data Editor is controlled by the May run Data Editor user privilege, which can be enabled or
disabled by user group in MES Client.
In addition, note the following:
 Changes or deletions of data in Data Editor are permanently saved after the Save button is clicked in
the corresponding dialog box. There are no rollback capabilities for the data in D ata Editor.
 All data modified or inserted using the Data Editor must fulfill all MES Business Rules requirements.

Version 6.0 5
MES Data Editor User Guide Getting Started

Logging In to Data Editor

Only users who are members of a user group that has been assigned the privilege May run Data Editor
will be grant ed access. The Dat a Editor login window will always contain at least a Password field.
Depending on your system configuration, the window might also contain a Login Text view-only pane
and/or a User Name field.
1. On the Start menu, click the MES Data Editor tile.
The login dialog box appears.

2. In the Language list, click the language in which you want the login dialog box to appear.
You can select only those languages that are configured in the MES Client application. If you restart
the application, the language setting resets to the default language, which is specified by the Display
system parameter Default Language in MES Client.
3. In the User Name and Password boxes, type your username and password.
o If the MES user Security mode is set to Native, you can obtain the username and password from
the MES administrat or who set up users in MES Client.
o If the Security mode is set to OS User or OS Group, enter your Windows username, including the
domain.
4. Click the green check mark button.
The MES Data E ditor application opens.

6 Version 6.0
Getting Started MES Data Editor User Guide

Data Editor Layout and Controls

The Data Editor window layout is shown in the following figure, and the controls are described below.

Tabs for accessing dat a record areas.

Grid that shows the filtered list of data records, including all data columns.
Button controls for accessing functions that can be performed on data records, including
filtering, editing, inserting, and deleting the rec ords.

On-Screen Keyboard
To assist users who do not have a physical keyboard attached to the local machine, text boxes in MES
.NET applications, such as Operator and Data Editor, include a keyboard button. Clicking this button
opens an on-screen keyboard, as shown below.

 After opening the keyboard, the focus for the text entry will be to the text box associated with the
keyboard button.

Version 6.0 7
MES Data Editor User Guide Getting Started

 You can leave the keyboard open (either displayed or minimized). However, if the keyboard is open
and you click another text box keyboard button, the focus will go to the keyboard and not to the new
text box. You must first click in the new text box before typing on the keyboard to enter text into it.
 The Enter and Tab keys work just like they do on a physical keyboard.
 The keyboard can be resized by clicking and dragging an edge or corner.
Depending on the Windows version, there are additional keyboard features, such as the Fade key
(making it transparent) and selectable options on the option keys. For more information about the
on-screen keyboard features, see the help topic "Use the On-Screen Key board (OSK) to type" on the
Microsoft Support web site.
To change the keyboard language
 Open the Input Method menu on the system tray and select the language.

Filtering the Grid

When you first open Dat a Editor, the filter dialog box for the selected tab might appear. Otherwise, you
can filter the data records that appear in the tabs at any time.
To filter the data records that appear in the tab (except for the Lots tab)

1. Click the Filter button.

8 Version 6.0
Getting Started MES Data Editor User Guide

The filter dialog box appears.

2. Enter the filter criteria.

To view all records, click Clear to clear the filter criteria.
3. Click Apply.
Only the data records that match the filter criteria appear in the grid.

Performance Checking
There are a number of areas in Data Editor where there is a pot ential for slow performance, depending
on the number of rec ords in certain dat abase tables and on specified filter criteria. For example, if the
Item_P rod table cont ains many rec ords and no filter criteria are entered in the Item Production Filter
dialog box, clicking Apply on the filter dialog box could cause a long delay while the rec ords are
retrieved. Similarly, if the It em_Prod table contains many records with different operations starting with
the letter A, and the filter criteria A% is entered in the Operation ID field of the filter dialog box, a
significant delay could occur bet ween clicking the lookup button for the Operation ID field and when the
lookup dialog box appears.
To limit such potential performance problems, every place where filter criteria can be entered to limit a
database result set, Data Editor will first check the size of the result set to ensure that it is not too large (a
system paramet er determines what th at size is; for example, it might be set to 5000 records). If the size of
the result set exceeds the defined maximum size, a message appears, allowing you to either proceed or
to cancel the request and specify different filter criteria.

Editing a Record
Data Editor allows you to edit data records in the MES database. All data entered must still meet all MES
Business Rules requirements.
To edit a data record
1. Select the data record in the grid that you want to edit.
2. Click the Edit button at the bottom of the window.
An edit window for the currently selected tab appears.

Version 6.0 9
MES Data Editor User Guide Getting Started

The edit window includes all editable data fields. Required fields are denoted by bold labels. If you
attempt to save your changes and a required field does not have an entry, you will be prompted to
complete the required field.
3. After you have completed your edits, do one of the following:
 To save your edits, click Save.
The edit window closes and the grid is refreshed with the updated record.
 To cancel your edits, click Cancel.
The edit window closes and your edits are discarded.

Inserting a Record
Data Editor allows you to insert new records into the MES database. All data entered must still meet all
MES Business Rules requirements.
To insert a new record
1. Click the Insert button at the bottom of the window.
An insert window for the currently selected tab appears.
The insert window includes all editable data fields. Required fields are denoted by bold labels. If you
attempt to save your changes and a required field does not have an entry, you will be prompted to
complete the required field.
2. After you have completed entering data for the new record, do one of the following:
 To save the new rec ord, click Save.
The edit window closes and the grid is refreshed with the new record.
 To cancel the insertion of the record, click Cancel.
The edit window closes and the new record is discarded.

Copying a Record
Data Editor allows you to copy certain data records in the MES database to create a new rec ord. All data
entered must still meet all MES Business Rules requirements.
To copy a data record
1. Select the record in the grid that you want to copy.
2. Click the Copy button at the bottom of the window.
An edit window for the new copied record appears.
The edit window includes all editable data fields. Required fields are denoted by bold labels. If you
attempt to save your changes and a required field does not have an entry, you will be prompted to
complete the required field.
3. After you have completed your edits to the copy, do one of the following:
 To save your edits, click Save.
The edit window closes and the grid is refreshed with the updated record.
 To cancel your edits, click Cancel.
The edit window closes and your edits are discarded.

10 Version 6.0
Getting Started MES Data Editor User Guide

Deleting a Record
Data Editor allows you to delet e records from the MES database.
To delete a record
1. Select the record in the grid.
2. Click the Delete button at the bottom of the window.
A confirmation prompt appears.
3. Click OK to confirm the deletion, or Cancel to cancel the deletion.
If you confirmed the deletion, the grid is refreshed and the record is removed.

Refreshing the Grid

 Click the Refresh button at the bottom of the window.
The grid refreshes and the most recent rec ords and data appear.

Filter and Data Entry Controls

The following controls are used in the filter and dat a entry dialog boxes.
Lists, Radio Buttons, Option Check Boxes
These are standard Windows controls.
For lists, you can:
 Open the list and select one.
 Click in the box and begin typing. A matching list entry is automatically entered in the box.
Lookup Button

Clicking this button opens a dialog box that allows you to search for or select an entry to add to the filter
or dat a box.
 When filtering data records, you can manually enter the filter criteria in the box or select it in the
lookup dialog box.
 When creating or editing a data record, entries for these boxes can only be made by selecting one
from the look up dialog box.
 Selecting the <> entry in the lookup dialog box causes the corresponding filter or data box to be
cleared.
The common lookup dialog boxes are listed below.
Work Order
Clicking a work order box Lookup button opens the Select a Work Order dialog box.

Version 6.0 11
MES Data Editor User Guide Getting Started

In the Filter box, enter the initial characters of a partial work order ID or a complete work order ID
(with or without the SQL wildcard characters % or _) and click Apply. The work orders which IDs
match the Filter box entry are listed, as shown below. Select a work order and click OK.

Operation
Clicking an operation box Lookup button opens the Select an Operation dialog box. Operations
associated with a valid work order ID entry are listed.

Select an operation and click OK.

12 Version 6.0
Getting Started MES Data Editor User Guide

Item
Clicking an item box Lookup button opens the Items dialog box. Items associated with a valid work
order ID entry are listed.

Select an item and click OK.

Enti ty
Clicking an entity box Lookup button opens the Please select an entity dialog box.

Select an entity and click OK.

Version 6.0 13
MES Data Editor User Guide Getting Started

Reason
Clicking a reas on box Lookup button opens a select a reason dialog box, such as the Select Reject
Reason dialog box shown below.

Select a reason group and then a reason and click OK.

Wildcard Characters in Filters
The SQL wildcard characters % and _ (underscore) can be used in any filter box—whether in a filter or
lookup dialog box—that accepts alphanumeric text.
On-Screen Data Entry Button
Clicking the on-screen data entry button, highlighted below, will open a dialog box to assist you with
making an entry.

 For alphanumeric text boxes, the Microsoft on-screen keyboard appears. See On-Screen Keyboard
on page 7.
 For numeric boxes, a numeric keypad appears.
 For date/time boxes, the Enter a Date and Time dialog box appears.

14 Version 6.0
Getting Started MES Data Editor User Guide

 For time duration boxes, the Enter a Duration dialog box appears.

Configuring Tab Components

You can configure the following Data Editor tab components:
 The column configuration for grids
 The toolbar buttons that appear
You can also save and reload a configuration for each tab.

Configuring Grids
With the grids in tabs, you can:
 Specify what columns and rows are displayed
 Arrange the grid rows by groups and subgroups
 Sort the grid by columns
 Arrange the order of the columns
 Filter the grid rows by a column’s data

Specifying What Columns and Rows Are Displayed

1. Right -click on the tab grid area and click Configure.
The Column Configuration for Grid dialog box displays.

Version 6.0 15
MES Data Editor User Guide Getting Started

The list of columns that are available are specific to the tab.

2. Set the desired options, described below.

Include Title Row
Select this option to include a title row for the table, and enter the title in the accompanying box.
Include Group By Row
Include the Group By row in the grid, which allows you to rearrange the grid into groups and
subgroups. See Grouping Grid Data on page 16.
Include Filter Row
Include a filter row, which allows you t o filt er the contents of the grid. To use filtering, see Filtering the
Grid on page 18.
Use this setting along with the Filterable check boxes to enable filtering for specific columns.
Visible
To make a column visible in the grid, select this option.
Filterable
To enable the filter cell for a column, select this option. To use filtering, see Filtering the Grid on page
18.
Back Color
This option is not supported.
3. Click OK to save your changes.

Grouping Grid Data

The grid can be arranged into groups and subgroups by column data categories.

16 Version 6.0
Getting Started MES Data Editor User Guide

To group the grid data by column data categories

1. Drag the column heading to the shaded area above the column headings.

The rows of the grid are now grouped by that data category.

2. Drag another column heading to this area to add a subgroup.

As you add groupings, the diagram in the shaded area is updated to illustrat e the order in which each
grouping is applied. The data rows will also be divided into sections, reflecting t he grouped method used.
To remove a grouping
 Drag the heading of that grouping from the shaded area.

Sorting by Columns
To sort by a column
 Click the column heading.
To reverse the sort
 Click the column heading again.

Version 6.0 17
MES Data Editor User Guide Getting Started

To add a secondary or tertiary sort column

 Shift+click another column.

Changing the Column Order

To change the order of a column
 Drag the column heading to the desired location in the column heading row.

Filtering the Grid

If the filter row in the grid’s column configuration has been turned on and filtering has been enabled for
any of the columns, then you can filter the dat a rows included in the grid by those columns.
To filter the grid by a column’s data
1. In the filter cell for the column, ent er the filter criteria.
The filter criteria must include the beginning characters of the data on which you want to filter, or the
entire dat a value. For example, if all work order IDs begin with WO-, then t he filter c riteria must begin
with those characters. So the filter WO-3 could include rows whose work order ID begins with WO-3,
WO-300, WO-301, or WO-3249. However, the filter entry 300 would not match any work order ID
entry.
Filter criteria is case-sensitive.
2. Press the Tab key.
Only rows whos e data match the entered filter criteria appear in the grid.
To clear the filter
 Delet e the filter entry and press the Tab key.

Configuring a Tab's Button Bar

You can add and remove the buttons that are included in a tab’s button bar.
Some of the available buttons are specific to the tab. Other general buttons, like the Refresh button,
might also be available to be included in the button bar.
To open the Configure Button Bar window
 Right -click the button bar area and click Configure.

18 Version 6.0
Getting Started MES Data Editor User Guide

The Configure Button Bar window appears.

To add a button to the button bar

1. On the Configure Button Bar dialog box, select the button in the Available Buttons pane.
2. Click the Add button.
3. In the settings pane, enter the Position number of the button to determine its position in the button
bar.
You can add one or more space separator buttons (the rectangular button without an icon) to visually
separate groups of buttons in the button bar.
To remove a button from the button bar
1. On the Configure Button Bar dialog box, select the button in the button bar.
2. Click the Remove button.
The button is moved back to the Available Buttons pane.
To configure a button in the button bar
You can configure settings for selected button in the button bar. These settings are described in the
following table.
Control ID
Identifies the control (for example, window or tab) on which this button bar appears.
ID
Identifies the selected button (and its definition) in the database.
Posi tion
Specifies the position number, or location, of the selected button in the button bar.
Execution Level
Specifies the minimum Button Execution Level that a user must have (a user privilege defined in
MES Client) to have authorization to use the selected button.
Text
Defines the text, if any, that appears as a label on the selected button.

Version 6.0 19
MES Data Editor User Guide Getting Started

Tooltip
Defines the text, if any, that will appear when the cursor is hovered over the selected button .
User Data
Defines the external application and/or parameters that will be passed when the selected but ton is
pressed.
Image
Indicates which image, if any, should be displayed on the selected button. The selected image is
displayed below this list.
Add Image button
Not supported.

Saving and Reloading Tab Configurations

You can save the current grid and toolbar button configuration for a tab. You can then reload the saved
configuration or the default configuration.
If you do not save changes that you made to the current configuration, those changes are lost when you
navigate to another tab.
You can also save the current configuration as the default configuration for the tab for all Data Edit or
users.
To access the save and reload configuration options
 Right -click anywhere on the t ab area except the toolbar area, then click the desired menu command.
The menu commands are described below.
Save Configuration
Saves the current configuration for the active entity.
If you reload the default configuration, this saved configuration is cleared.
Save As Default Configuration
Saves the current configuration for this tab as the default configuration for all Data Editor us ers.
Reload Configuration
Reloads your last saved configuration for this tab.
Revert to Default Configuration
Reloads the default configuration for this tab. This also clears the saved configuration.

Viewing Version Information About the MES Database

 Right -click anywhere on the tab except the toolbar area and then click About.
The About dialog box appears for that tab's editor. The information includes the MES database
version, database server name, dat abase name, and version information about the MES .NE T
controls that are used for that tab's editor.

20 Version 6.0
 MES Data Editor User Guide

C HAPTER 2
Maintaining Item Consumption Records on
the BOM Tab
In This Chapter
Introduction to the BOM Tab.......................................................................................................... 21
Item Consumption Filter ................................................................................................................ 21
Item Consumption Data................................................................................................................. 23

Introduction to the BOM Tab

The BOM tab allows data in the Item_Cons table to be maintained. It is only available if MES Operations
is licensed and the user has the May edit consumption data Data Editor user privilege.
The following topics describe:
 The data by which the item consumption records can be filtered
 The data that can be entered or edit ed for item consumption records

Item Consumption Filter

Version 6.0 21
MES Data Editor User Guide Maintaining Item Consumption Records on the BOM Tab

The available filters are listed below, with additional information about using the filter provided as
needed.
Work Order
Operation
Seq No
Shift
Shift Start (Begin)
If a Shift Start (Begin) entry that is after the Shift Start (End) entry is entered, the Shift Start (End)
entry is changed to match the Shift Start (Begin) entry.
Shift Start (End)
If a Shift Start (End) entry that is before the Shift Start (Begin) entry is entered, the Shift Start (Begin)
entry is changed to match the Shift Start (End) entry.
Item ID
Lot Number
Finished Goods Lot Number
Sublot Number
Finished Goods S ublot Number
Reason
Grade
State
Run Entity
Storage Entity
Quantity Consumed (Min/Max)
User
External Reference
Scrapped
Item_Cons spare 1 to spare 4

22 Version 6.0
Maintaining Item Consumption Records on the BOM Tab MES Data Editor User Guide

Item Consumption Data

The available data entries are listed below, with additional information about ent ering the data provided
as needed. Required ent ries in the dialog box have bold labels.
Work Order
A work order ID entry must be selected from the lookup dialog box. Also, a work order ID must be
entered before any other data entries can be made.
When a work order ID is entered or changed, the following data is entered automatically:
o Operation, using the first available entry in the list.
o Seq No, using the first available entry in the list.
o Item Consumed, using the first available entry in the list.

Operation
Only operations IDs associated with the work order are included in the lis t.
Seq No
Only sequence numbers associated wit h the work order and operation are included in the list.
Shift
A shift can only be entered onc e a run entity is entered.
Shift Start
A shift start can only be entered once a run entity is entered.
Item Consumed
Only consumable items associated with the work order, operation, and sequence number (that is, the
job) are included in the list.

Version 6.0 23
MES Data Editor User Guide Maintaining Item Consumption Records on the BOM Tab

Lot Number
Finished Goods Lot Number
Sublot Number
Finished Goods S ublot Number
Reason
The item reason must be selected from the lookup dialog box.
Grade
A read-only field, determined by the Reason entry.
State
A read-only field, determined by the Reason entry.
Run Entity
Storage Entity
Quantity Consumed
User
External Reference
Scrapped
A read-only field, determined by the Reason entry.
Item_Cons spare 1 to spare 4

24 Version 6.0
 MES Data Editor User Guide

C HAPTER 3
Maintaining Item Production Records on the
Production Tab
In This Chapter
Introduction to the Production Tab ................................................................................................. 25
Item Production Filters .................................................................................................................. 26
Item Production Data .................................................................................................................... 27

Introduction to the Production Tab

The Production tab allows data in the Item_Prod table to be maintained. This tab is available if the May
edit production data Data Editor user privilege is enabled for the user.
The following topics describe:
 The data by which the item production records can be filtered
 The item production dat a that can be entered or edited

Version 6.0 25
MES Data Editor User Guide Maintaining Item Production Records on the Production Tab

Item Production Filters

The available filters are listed below, with additional information about using the filter provided as
needed.
Work Order
Operation
Seq No
Shift
Shift Start (Begin)
If a Shift Start (Begin) entry that is after the Shift Start (End) entry is entered, the Shift Start (End)
entry is changed to match the Shift Start (Begin) entry.
Shift Start (End)
If a Shift Start (End) entry that is before the Shift Start (Begin) entry is entered, the Shift Start (Begin)
entry is changed to match the Shift Start (End) entry.
User
Hour Start (Begin)
If also entering an Hour Start (End), make sure it occurs after or on the Hours Start (Begin) entry, as
these two fields are not validated prior to the filtering.
Hour Start (End)
If als o entering an Hour Start (Begin), make sure it occurs prior to or on the Hours Start (End) entry,
as these two fields are not validated prior to the filtering.

26 Version 6.0
Maintaining Item Production Records on the Production Tab MES Data Editor User Guide

Item ID
Lot Number
Sublot Number
Reason
Grade
State
Run Entity
Storage Entity
Quantity Produced (Min/Max)
External Reference
Production
Processed
Byproduct
Move Status
Item_Prod spare 1 to spare 4

Item Production Data

The available data entries are listed below, with additional information about ent ering the data provided
as needed. Required ent ries in the dialog box have bold labels.
Work Order
A work order ID entry must be selected from the lookup dialog box. Also, a work or der ID must be
entered before any other data entries can be made.

Version 6.0 27
MES Data Editor User Guide Maintaining Item Production Records on the Production Tab

When a work order ID is entered or changed, the following data is entered automatically:
o Operation, using the first available entry in the list.
o Seq No, using the first available entry in the list.
o Item Produced.

Operation
Only operations IDs associated with the work order are included in the list.
Seq No
Only sequence numbers associated wit h the work order and operation are included in the list.
Shift
A shift can only be entered onc e a run entity is entered.
Shift Start
A shift start can only be entered once a run entity is entered.
Hour Start
Item Produced
Only items associated with the work order and operation are included in the list.
Lot Number
Sublot Number
Reason
A reason can only be entered once a run entity is entered.
Grade
A read-only field, determined by the Reason entry.
State
A read-only field, determined by the Reason entry.
Run Entity
Storage Entity
Quantity Produced
If the Good Production check box is selected, the number of decimal places that can be entered here
is limited to the value entered for the Maximum number of decimals for good piece part entries
system parameter.
User
External Reference
Good Production
A read-only field, determined by the Reason entry.
Processed
Byproduct
Moved to Next Op
Item_Prod spare 1 to spare 4

28 Version 6.0
 MES Data Editor User Guide

C HAPTER 4
Maintaining Labor Usage Records on the
Labor Tab
In This Chapter
Introduction to the Labor Tab ......................................................................................................... 29
Labor Us e Filter ............................................................................................................................ 30
Labor Us e Data ............................................................................................................................ 31

Introduction to the Labor Tab

The Labor tab allows data in the Labor_Usage table to be maintained. It is only available if MES
Operations is licensed and the user has the May edit labor usage data Data Editor user privilege
enabled.
Data Edit or does not limit insertions, updates, or deletions of data in this tab based upon the Allow user to
account for less than 100% of his time and Allow user to account for more than 100% of his time system
parameters (since doing so would always cause problems).
The following topics describe:
 The data by which the labor usage records can be filtered
 The data that can be entered or edit ed for labor usage records

Version 6.0 29
MES Data Editor User Guide Maintaining Labor Usage Records on the Labor Tab

Labor Use Filter

The available filters are listed below, with additional information about using the filter provided as
needed.
User
Enti ty
Event Start (Begin)
If an E vent Start (Begin) entry that is after th e E vent Start (End) entry is entered, the E vent Start
(End) entry is changed to match the E vent Start (Begin) entry.
Event Start (End)
If an E vent Start (End) entry that is before the E vent Start (Begin) ent ry is entered, the E vent Start
(Begin) entry is changed to match the E vent Start (End) entry.
Duration (Min/Max)
Enter a minimum or maximum event duration, or enter both to specify an inclusive range.
Labor Category
Labor Department
Shift
Shift Start (Begin)
If a Shift Start (Begin) entry that is after the Shift Start (End) entry is entered, the Shift Start (End)
entry is changed to match the Shift Start (Begin) entry.
Shift Start (End)
If a Shift Start (End) entry that is before the Shift Start (Begin) entry is entered, the Shift Start (Begin)
entry is changed to match the Shift Start (End) entry.

30 Version 6.0
Maintaining Labor Usage Records on the Labor Tab MES Data Editor User Guide

Work Order
Operation
Seq No
Step No
Item ID
Lot Number
Sublot Number
Percent To Apply (Min/Max)
Acti ve
Comments

Labor Use Data

The available data entries are listed below, with additional information about ent ering the data provided
as needed. Required ent ries in the dialog box have bold labels.
Only labor usage rec ords that are not currently active can be edited. Currently active records can be
displayed, but no changes can be made to them.

Version 6.0 31
MES Data Editor User Guide Maintaining Labor Usage Records on the Labor Tab

User
Enti ty
Start Time
End Time
Duration
Percent To Apply
Labor Category
Labor Department
Shift
A shift can only be entered onc e an entity is entered.
Shift Start
A shift start can only be entered once an entity is entered.
Work Order
A work order ID entry must be selected from the lookup dialog box.
When a work order ID is entered or changed, the following data is entered automatically:
o Operation, using the first available entry in the list.
o Seq No, using the first available entry in the list.
o Item Produced.

Operation
Only operations IDs associated with the work order are included in the list.
Seq No
Only sequence numbers associated wit h the work order and operation are included in the list.
Item Produced
A read-only field, determined by the Work Order entry.
Step No
Only job step numbers associated with the work order, operation, and sequence number are
included in the list.
Acti ve
A read-only field.
Lot Number
Sublot Number
Comments

32 Version 6.0
 MES Data Editor User Guide

C HAPTER 5
Maintaining Lot and Sublot Records on the
Lot Tab

In This Chapter
Introduction to the Lots Tab ........................................................................................................... 33
Lot Filter....................................................................................................................................... 34
Inserting a New Lot ....................................................................................................................... 34
Renaming a Lot or Sublot .............................................................................................................. 35

Introduction to the Lots Tab

The Lot tab allows data in the Lot and Sublot tables to be maintained. It is only available if MES
Operations is licensed and the user has the May edit lot data Data Editor user privilege enabled.
The following topics describe:
 The data by which the lot records can be filtered
 Inserting a new lot record
 Renaming a lot or sublot

Note: Changing the parent of a lot or sublot using the the Change Parent button is not supported.

Version 6.0 33
MES Data Editor User Guide Maintaining Lot and Sublot Records on the Lot Tab

Lot Filter

The lot records can be filtered by entering a lot number in the Filters panel and clicking Apply. To s ee all
lots, clear the Lot box before clicking Apply.
All lots whose IDs match the filter criteria a re listed in an item/lot tree.

Inserting a New Lot

1. In the item/lot tree, select the parent item for the lot.
2. Click the Insert button.

34 Version 6.0
Maintaining Lot and Sublot Records on the Lot Tab MES Data Editor User Guide

The Insert Node dialog box appears.

3. Enter the lot name and click OK.

Renaming a Lot or Sublot

1. In the item/lot tree, select the the lot or sublot to rename.
2. Click the Edit button.
The Rename Node dialog box appears.

3. Enter the new name and click OK.

Version 6.0 35
 MES Data Editor User Guide

C HAPTER 6
Maintaining Job Step Data Records on the
Steps Tab
In This Chapter
Introduction to the Steps Tab ......................................................................................................... 37
Job Step Dat a Filter ...................................................................................................................... 37
Job Step Dat a .............................................................................................................................. 39

Introduction to the Steps Tab

The Steps tab allows data in the Job_Step_Data table to be maintained. It is only available if MES
Operations is licensed and the user has the May edit job data Data Editor us er privilege.
The following topics describe:
 The data by which the job step dat a records can be filtered
 The data that can be entered or edit ed for job step data records

Job Step Data Filter

Version 6.0 37
MES Data Editor User Guide Maintaining Job Step Data Records on the Steps Tab

The available filters are listed below, with additional information about using the filter provided as
needed.
Work Order
Operation
Seq No
Step No
Lot Number
Sublot Number
Step State
Step Start (Begin)
If a Step Start (Begin) entry that is after the Step Start (End) ent ry is entered, the Step Start (End)
entry is changed to match the Step Start (Begin) entry.
Step Start (End)
If a Step Start (End) entry that is before the Step Start (Begin) entry is entered, the Step Start (Begin)
entry is changed to match the Step Start (End) entry.
Start User
Step Finish (Begin)
If a Step Finish (Begin) ent ry that is after the Step Finish (End) entry is ent ered, the Step Finish (End)
entry is changed to match the Step Finish (Begin) entry.
Step Finish (End)
If a Step Finish (End) entry that is before the Step Finish (B egin) ent ry is entered, the Step Finish
(Begin) entry is changed to match the Step Finish (E nd) entry.
Finish User
Step Data Time (Begin)
If a Step Dat a Time (Begin) entry that is after the Step Data Time (E nd) entry is entered, the Step
Data Time (End) ent ry is changed to match the Step Dat a Time (Begin) entry.
Step Data Time (End)
If a Step Dat a Time (End) entry that is before the Step D ata Time (B egin) entry is entered, the Step
Data Time (Begin) entry is changed to match the Step Data Time (E nd) entry.
Data User
Step Data
Form
Job_Step_Data spare 1 to 6

38 Version 6.0
Maintaining Job Step Data Records on the Steps Tab MES Data Editor User Guide

Job Step Data

The available data entries are listed below, with additional information about ent ering the data provided
as needed. Required ent ries in the dialog box have bold labels.
Work Order
A work order ID entry must be selected from the lookup dialog box.
When a work order ID is entered or changed, the following data is entered automatically:
o Operation, using the first available entry in the list.
o Seq No, using the first available entry in the list.

Operation
Only operations IDs associated with the work order are included in the list.
Seq No
Only sequence numbers associated wit h the work order and operation are included in the list.
Step Number
Only job step numbers associated with the work order, operation, and sequence number are
included in the list.

Version 6.0 39
MES Data Editor User Guide Maintaining Job Step Data Records on the Steps Tab

Lot Number
Sublot Number
Step State
Step Start
Start User
Step Finish
Finish User
Step Data Time
Data User
Step Data
Form Done
Job_Step_Data spare 1 to 6

40 Version 6.0
 MES Data Editor User Guide

C HAPTER 7
Maintaining Utilization and Job History
Records on the Utilization Tab
In This Chapter
Introduction to the Utilization Tab ................................................................................................... 41
Entity Usage Filter ........................................................................................................................ 42
Entity Usage Dat a......................................................................................................................... 43
Job History Dat a ........................................................................................................................... 44

Introduction to the Utilization Tab

The Utilization tab allows data in the Util_History and Job_History tables to be maintained. The
Job_Hour_History table is also affected, as it is periodically updat ed with new data from the Util_History
and Job_History tables. The Utilization tab is only available if MES Performance is licensed and the
user has the May edit utilization dat a Data Edit or user privilege.
The Util_History table captures utilization data and a chronological sequence of utilization events for
each entity that can capture utilization data. This data includes entity utilization states, utilization
reasons, number of occurrences, and the timestamps when an entity's utilization state or reason
changes (that is, when a new event occurs ).
The Job_Hour_History table, which is used in the calculation of equipment performance statistics, is
updated every hour as necessary to reflect Util_History table changes, including those made from the
Utilization tab. However, because rec ently entered job statistical data is considered volatile with a
possibility of changing frequently, a predefined cut-off period is used to determine when equipment
performance statistical data is based on data in the Job_Hour_History table or generated dynamically.
The default cut-off period is 2 hours prior to the current hour. When the Job_Hour_History table is
updated every hour, only event data that occurred prior to the pre-defined cut-off period is updated.
Deleting a utilization history record increments or decrements the value in the runtime, downtime, or
idletime fields of the corresponding Job_Hour_History record, depending on the reason code of the
deleted record (t he reason code determines the time category). Similarly, inserting a new utilization
history record increments or decrements the runtime, downtime, or idletime field of the corresponding
Job_Hour_History record (or creates a new Job_Hour_History record, if no record with a key
corresponding to the newly inserted utilization history rec ord exists).
The Job_History table captures the jobs that are run on each entity that can run jobs. Also captured are
the position on which the job was running and when the job started and ended. Updates to utilization
event history records do not have any impact on the Job_History table. In the Utilization tab,
Job_History records are shown listed below the utilization history rec ord to which they correspond; that
is, under the foll owing conditions:
 The job start time of the Job_History record is great er than or equal to the start time of the utilization
event for the related entity
 The job end time of the Job_History record ends before the end time of the utilization event for the
related entity

Version 6.0 41
MES Data Editor User Guide Maintaining Utilization and Job History Records on the Utilization Tab

When the start time or the end time of a Job_History record is modified, the corres ponding runtime,
downtime, and idletime of the job in the Job_Hour_History table is updated. Similarly, the good and reject
production counts for the affected period are also updated in the Job_Hour_History table.
The following topics describe:
 The data by which the utilization history data records can be filtered
 The data that can be entered or edit ed for utilization history data records
 The data that can be entered or edit ed for job history records that are associated with utilization
history data records

Entity Usage Filter

The available filters are listed below, with additional information about using the filter provided as
needed.
Enti ty
An entity entry must be selected from the lookup dialog box. Only entities that can run jobs, shown in
bold in the dialog box, can be selected.
Item ID
Shift
Shift Start (Begin)
If a Shift Start (Begin) entry that is after the Shift Start (End) entry is entered, the Shift Start (End)
entry is changed to match the Shift Start (Begin) entry.
Shift Start (End)
If a Shift Start (End) entry that is before the Shift Start (Begin) entry is entered, the Shift Start (Begin)
entry is changed to match the Shift Start (End) entry.
Event Start (Begin)
If an E vent Start (Begin) entry that is after the E vent Start (End) entry is entered, the E vent Start
(End) entry is changed to match the E vent Start (Begin) entry.

42 Version 6.0
Maintaining Utilization and Job History Records on the Utilization Tab MES Data Editor User Guide

Event Start (End)

If an E vent Start (End) entry that is before the E vent Start (Begin) ent ry is entered, the E vent Start
(Begin) entry is changed to match the E vent Start (End) entry.
Duration (Min/Max)
Enter a minimum or maximum event duration, or enter both to specify an inclusive range.
Work Order
Operation
Seq No
Reason
Enti ty State
Reason Pending
Time Type
Time Category
Comments

Entity Usage Data

The available data entries are listed below, with additional information about ent ering the data provided
as needed. Required ent ries in the dialog box have bold labels.
If any changes are made to event time intervals—by inserting, modifying, or deleting a utilization log
record—that would c ause the data to no longer consist of a contiguous sequence of event intervals, Data
Editor will automatically make whatever adjustments are necessary to restore the data to a contiguous
set of time intervals.
Enti ty
An entity entry must be selected from the lookup dialog box. Only entities that can run jobs, shown in
bold in the dialog box, can be selected.

Version 6.0 43
MES Data Editor User Guide Maintaining Utilization and Job History Records on the Utilization Tab

Event Start
Event End
Duration
Reason
Enti ty State
A read-only entry, determined by the Reason entry.
Reason Pending
Time Category
Read-only check boxes, determined by the Reason entry.
Time Type
Read-only check boxes, determined by the Reason entry.
Comments

Job History Data

You can insert job history records to associate them with a utilization history record.

Caution: Extreme care should be taken when modifying job history records, especially the record for the
job that is currently running on the entity.

To insert a job history record

1. Select the utilization history record wit h which to associate the job history record.

2. Click the Insert Job Detail Row button.

The Job Detail dialog box appears.

3. Complete the job history dat a entries, described below.

Once inserted, you can edit the job history record just as you would any other data record.
Job History Data Entries
Enti ty
A read-only entry, determined by the associated utilization history record.
Job Position
A read-only entry, determined by the associated utilization history record.

44 Version 6.0
Maintaining Utilization and Job History Records on the Utilization Tab MES Data Editor User Guide

Item Produced
A read-only entry, determined by the work order entered.
Work Order
A work order ID entry must be selected from the lookup dialog box.
When a work order ID is entered or changed, the following data is entered automatically:
o Operation, using the first available entry in the list.
o Seq No, using the first available entry in the list.
o Item Produced.

Operation
Only operations IDs associated with the work order are included in the list.
Seq No
Only sequence numbers associated wit h the work order and operation are included in the li st.
Job Start Time
Job End Time
Duration

Version 6.0 45