Family Field Descriptions

This field does not appear on the datasheet. The OEE Metric View uses the value in this field to determine whether an OEE code is an Availability, Performance, or Quality code in the OEE (%) calculation. This field contains the following values, depending on the type of OEE code:

• For child OEE codes, this field contains the parent OEE code.
• For parent OEE codes, this field contains the same value as the OEE code field.

When the Production Data is created, this field does not contain any value. It is populated with the sum of the values in the Loss Amount field in all Production Loss records to which the Production Data is linked. This field is disabled.

Along with the value in the Margin field in the Production Data, the value in the Losses field is used to calculate the cost of losses, which appears in the Production Summary workspace.

This value is set by default to the value in the Maximum Sustained Capacity Rate field in the Production Profile that is linked to the Production Plan to which the Production Data is linked.

This field is disabled.

On the Production Data Entry page, the Period column displays the start time and end time, separated by a dash.

In the baseline database, this field stores time using the Coordinated Universal Time (UTC) format (i.e., the UTC check box is selected when you view the field properties in the Configuration Manager).

This field is disabled.

By default, the value is set to the planned production amount, which appears in the <Product Name (<UOM>)> cell in the Plan Details workspace for the associated production plan.

You can modify this value.

The value in the Unaccounted Loss column is not stored in the Production Data and is for display purposes only.

The number that appears in each cell in this column is calculated using the Unaccounted Loss equation.

This field is disabled.

This field contains a list, which displays all colors that you can assign to the impact code.

In the baseline database, colors are not assigned to the baseline Production Event Codes. You will need to assign the required colors manually.

This field stores the value that appears in the Production Event Code box in the datasheet.

The field does not appear in the datasheet.

The values in the Start Date and End Date fields of a Production Event determine whether the Production Event appears in the Production Event drop-down list box when creating or modifying a loss.

A Production Event that does not have a value in the End Date field will appear in the Production Event drop-down list box for losses that are associated with any day after the start date of the Production Event.

You can enter a value in the field. The value must be unique.

You can select a value in this field.

The full path to the selected production event code appears in the Production Event Code box in the datasheet. This includes all the categories under which that production event code is grouped.

For example, if you select Equipment Malfunction, which is grouped under Operational Losses, the Production Event Code box will display the value Operational Losses\Equipment Malfunction. However, the Production Event Code field stores only the selected production event code (that is, Equipment Malfunction).

Identifies the Production Unit to which the loss is attributed.

This field contains a list of IDs of all available Production Units. The field, however, stores the key of the Production Unit.

When you create a Production Event via the Production Data workspace, the field is automatically populated with the Production Unit for which the Production Plan was created. You can, however, modify the value in the field.

A Production Event that does not have a value in the Start Date field will appear in the Production Event drop-down list box for losses that are associated with any day before the end date of the Production Event.

This field is disabled. It is populated with a value only if you modify the record.

You can enter or select a value in the field.

This field is disabled.

If the Loss Amount field in the Production Loss and the Maximum Sustained Hourly Rate field in the corresponding Production Profile contain values, this field is automatically populated using the following formula:

Equivalent Downtime Hours = Loss Amount / Maximum Sustained Hourly Rate

This field contains a list of all Impact Codes that are returned by the ImpactCodeList query. Each item in the list appears in the following format:

Code - Description

where Code and Description are values in the Code and Description fields respectively in the Impact Code.

When you select an item from the list, while the Code and Description are displayed in the datasheet, only the Code is stored in the field.

When you create a Production Loss, this field is automatically populated with the value in the Unaccounted Loss field in the Production Loss. You can, however, enter a value in the field.

If the Equivalent Downtime Hours field in the Production Loss and the Maximum Sustained Hourly Rate field in the corresponding Production Profile contain values, this field will be automatically populated using the following formula:

Loss Amount = Equivalent Downtime Hours x Maximum Sustained Hourly Rate

If the Equivalent Downtime Hours field is blank, and if you enter a value in the Loss Amount field, the Equivalent Downtime Hours field will be automatically populated based on the formula.

The margin defined for each Production Profile.

This field is used to calculate the cost of losses. It contains a list of all margins.

A value that is used to categorize the loss based on the effectiveness of the production process.

Selecting this field displays the Select OEE Code window, which contains a hierarchical tree of OEE Codes that are mapped to the selected Impact Code. These OEE Codes are returned by the GetOEECodeByImpactKey query.

This field contains a list of Event IDs of all Production Events that are returned by the EventList query. The field, however, stores the key of the Production Event.

The Production Events are sorted chronologically in descending order based on Start Date.

• Per Hour
• Per Shift
• Per Day
• Per Week
• Per Month
• Per Quarter
• Per Year Campaign

For a Time-based plan, depending on the value you selected in the Template Frequency field, the end time is populated automatically.

For a Quantity-based plan, the value is determined automatically based on the product quantity and start time that you specified.

The type of production plan.

This field contains the following options:

• Plan is time-based

• Plan is quantity-based

  The Quantity field is displayed when you select a quantity-based plan. You can enter a numeric value in this field.

The value in this field will be AP (Actual Plan) if you have created a Production Plan:

• Via the Production Plan Builder
• From a Plan Template
• Manually

The value in this field will be PT (Plan Template) if you created a Plan Template.

The order in which the products will be produced.

This field contains the following values:

• Concurrent: The unit produces the products at the same time.
• Sequential: The unit produces the first product, and it begins producing the second product after production of the first product is complete. When you select Sequential, the following fields are displayed:
  • Sequence: The order in which the products should be produced. You can enter a numeric value in this field.
  • End Time: The date and time on which the production of the product ends is based on the value that you specified in the Sequence field.

On the datasheet, this field appears as a list labeled Duration. You can select one of the following values:

• Custom: You can manually set the end date and time.
• Week: The end date and time is automatically set to one week from the value in the Start Time field.
• Month: The end date and time is automatically set to one month from the value in the Start Time field.
• Quarter: The end date and time is automatically set to three months from the value in the Start Time field.
• Year: The end date and time is automatically set to one year from the value in the Start Time field.

• Product UOM is the value in the Product UOM field.
• Production Rate UOM is the value in the Production Rate UOM field.

• Product UOM
• Production Rate UOM
• Standard Batch Size
• Standard Batch Cycle Time

Standard Batch Size / Standard Batch Cycle Time

• Product UOM is the value in the Product UOM field.

• Production Rate UOM is the value in the Production Rate UOM field.

This field is automatically populated only if the MSHR Auto Calculate check box in the Settings window is selected. You can, however, enter a value manually.

The following formula is used to populate this field:

Standard Batch Size / Production Rate UOM (hours),

where:

• Standard Batch Size is the number that you enter in the Standard Batch Size field.

• Production Rate UOM, which is measured in hours, depends on the value that you enter in the Production Rate UOM field, as indicated in the following table:

  Production Rate UOM in the Production Profile	Hours in the formula for each Production Rate UOM
  Hour	1
  Day	24
  Week	24 × 7
  Month	24× 30
  Quarter	24 × 90
  Year	24 × 365

  For example, if Standard Batch Size is 1000 and Production Rate UOM is Month, Maximum Sustained Hourly Rate (MSHR) is calculated as follows:

  1000 / (24 × 30)

  Important: Because this formula assumes 30 days for a month, the calculated value would be inaccurate if a month does not have 30 days.

This field is used to calculate Equivalent Downtime Hours.

This field is not required; however, if left blank, Equivalent Downtime Hours will not be used when reconciling losses.

This field contains a button, which enables you to select the required OPC Tag.

This field is required if you want to use the process historian to production data.

• Hour
• Day
• Week
• Month
• Quarter
• Year

The default value is Day. This is a required field.

The number that you enter is appended automatically with the value in the Production Rate UOM field. This is a required field.

Using this field, you can associate production loss to the asset hierarchy and information about all the losses will available at the asset hierarchy level of the associated unit.

This field contains the button, which you can use to select the Functional Location that contains more information about the production unit. When you save the Production Unit, it will be linked automatically to the selected Functional Location.

By default, this field is set to (UTC - 05:00) Eastern Time (US & Canada).