Plant Database Parameter Value Properties

When you configure a Plant Database data source in an object, you will notice that some functions have parameters. You can configure default values for these parameters, so that when the object retrieves the data, the default value is passed in. In some cases you will be able to enter a value or select a check box directly on the source configuration dialog box. For most values, however, when you click in the value column for the parameter, a dialog box will appear. Click on the parameters below to find out about their configurable properties.

Parameters:

Times

Property	Description
Absolute	Allows you to define a fixed date and time for the time criteria.
Relative	Allows you to define a date and time that is relative to a certain day, month, week, shift, and so forth.
Range NOTE: This choice is not available if entering 'Start Date/Time'.	Allows you to define a date and time that is either relative or absolute, depending on your selection. The displayed Start and Stop date/time changes to reflect your selection. For example, if you select Last Hour, the Start date/time changes to one hour before the current time (relative option). If you select Q1, the Start and Stop date/time values change to the first 3 months of the year (absolute option).

Dept., Line, Unit, Variable Group, Variable

Data model level filtering allows you to begin at the Department level and narrow your search down to the specific parameter level you want to set the default value for. When you insert an object and configure the source, you'll notice that the location of the function you selected from the data sources tree is reflected in the filtering Description boxes.

Property	Description
Desc. Filter	Enter the name of the Department, Line, Unit, etc., or use the wildcard symbol along with characters in the name and press ENTER. The Description list is filtered accordingly. For example, if you want the Description list to show only items that begin with the letter "a", enter "a*" in the Desc. Filter box.
Description	Select the Department, Line, Unit, etc., from the list. Any additional filter items will update accordingly.
Wildcard symbol	Enter any character that you want to use as a wildcard.
Case-sensitive	Select this check box if you want the case of the characters you enter to be recognized.

Product, Group, Property, Characteristic, Specification

For some functions, you can set either the default parameter value on the Product or on the Group/Property/Characteristic, but not on both. When this is the case you are first prompted to select the type of product search. The filtering for either Product, or Group/Property/Characteristic/Specification functions the way as Dept./Line/Unit/Variable Group/Variable. You first set the filter on the top level (e.g. the Product Group), and the following levels (Property, Characteristic, Specification) are filtered accordingly. Drill down the hierarchy, and enter filters until you arrive at the required default value for the parameter.

Property	Description
Product Search Type	Select to set the default parameter value for the Product, or the Group/Property/Characteristic/Specification. You will not be able to set defaults for both. NOTE: If there is only one type of parameter available (e.g. only Product appears as a parameter), then you will not see these options.
Desc./Code Filter	Enter the name of the Product Group, Property, etc., or use the wildcard symbol along with characters in the name and press ENTER. The Description list is filtered accordingly. For example, if you want the Description list to show only items that begin with the letter "a", enter "a*" in the Desc/Code. Filter box.
Description	Select the Product Family, Product etc., from the list. Any additional filter items will update accordingly.
Product Code	When you are filtering by Product Family, and have selected the Product from the Product's Description list, the Product Code is shown.
Wildcard symbol	Enter any character that you want to use as a wildcard.
Case-sensitive	Select this check box if you want the case of the characters you enter to be recognized.

Event Number, Product Plan ID

You can enter the number for the event or product plan if it is known; if it is not known, you can use the search criteria provided to find it.

Property	Description
Choose Entry Method	If you know the event number/product plan ID, select the first option and enter the number in the Event Number/Plan ID box. If you do not know the ID number, select the search option.
Select master unit NOTE: Event Number only	Select Department, Line, and Master Unit from the lists.
Select path NOTE: Product Plan ID only	Select a path code from the list.
Set start and end times	Select the time frame you want to search in.
Search	Click the Search button to return a list of event numbers/product plan IDs.
Event Number/Plan ID	If you know the event number/product plan ID, enter it in the Event Number/Prod Plan ID box. If you have searched for the ID number, choose the number from the list.

Event Type, Required Level

Property	Description
Event Type	Select the type of event (e.g. Downtime, Waste).
Select unit	Select a Unit by selecting the appropriate Department, Line, and Unit from the lists.
Select required reason level	Select one of the 1, 2, 3, or 4 options as the required reason level.

Master Unit, Variable ID List

Property	Description
Select master unit	Select a Master Unit by selecting the appropriate Department, Line, and Master Unit from the lists.
Select variables	Select one or more variables from the variables list. You can hold down the CTRL key and click on the variables to select more than one.

Miscellaneous Parameters

Parameter	Description
Product ID List	Select one or more products from the list. You can hold down the CTRL key and click multiple products. The parameter uses the ID associated with the product as its default value(s).
Include Applied Products	Select the check box if you want the default value for the Include Applied Products parameter to be Yes.
Include Broke Events	Select the check box if you want the default value for the Include Broke Events parameter to be Yes.
Path Code	Select a path code from the list.
Acknowledged	Select the check box if you want the default value for the Acknowledged parameter to be Yes.
Calculation Type	Select a calculation type from the list. This specifies the type of data the calculations are based on. For example, if you select 'Result', the statistics such as average, standard deviation, maximum, and so forth are calculated on the result.