3. Defining the Items for an event

the purpose of the sheet event item definition is to define which data model items to populate with data if a specific trigger is true note the sequence of steps shown in this guide is a recommendation, as it felt the most natural for the author but users are free to follow their own preferred sequence important this guide is written under the assumption, that the configurator is used in online mode this allows the configurator to download both existing data model as well as tag configurations and make them available for users to select them without the need of typing and minimizing the risk of spelling mistakes select the trigger condition name to define which data model item is populated with data through an event, the user selects the combination of data model, event name and trigger condition name from the drop down menu in the column labeled trigger condition name note only values available through the drop down menu can be selected important do not leave blank rows between entries or at the start a blank row will be seen as the end of the configuration and the configurator will not process any entry past the blank row how to understand the strings shown by the drop down menu the column with the labeled trigger condition name will provide the user with a drop down menu which shows the combinations of data model name, event name and trigger condition name as a string representation combinations of data model name, event name and trigger condition name in the drop down menu will shown as a pipe symbol " | " separated string on how to add additional combinations, please review the chapter 2 defining the event and trigger condition docid\ jfqrok kpup7 creie8h the string has to be read from the left to the right first value being the data model name line x |production monitoring|start trigger = column labeled production record data model node name from sheet event and trigger definition second value being the event name line x| production monitoring |start trigger = column labeled event name from sheet event and trigger definition t hird value being the trigger condition name line x|production monitoring| start trigger = column labeled trigger condition name from sheet event and trigger definition they are also listed in the order as in the sheet event and trigger definition define a data model item to be able to record data for an event, it is required to define which data model items are to be used for recording data if an event trigger does fire a data model item used in the column labeled hierarchy level and item , has to be defined inside litmus production record database beforehand, for example using the litmus solution litmus production record data model configurator the data model item together with its position in the data model hierarchy updated by the trigger is configured in the column labeled hierarchy level and item in online mode, users select the data model item from the drop down menu in the column labeled hierarchy level and item the hierarchy level and item is a pipe symbol " | " separated string composed of first position = is always the data model name used when setting up the data model in litmus production record database line x | station a | right side | start time last position = is always an item name set up inside a data model in litmus production record database line x | station a | right side | start time optional positions 2 (level 1), 3 (level 2), 4 (level 3), 5 (level 4), 6 (level 5) = individual hierarchy level names set up inside a data model in litmus production record database example for a hierarchy level 2 item hierarchy level 1 line x | station a | right side | start time hierarchy level 2 line x | station a | right side | start time note only values available through the drop down menu can be selected important do not leave blank rows between entries or at the start a blank row will be seen as the end of the configuration and the configurator will not process any entry past the blank row in offline mode in offline mode, the user will have to insert the pipe symbol "|" separated string manually as the configurator can not download which tags are defined on the sql server and can not create the drop down menu available in online mode note if the string incudes a wrongly spelled data model name, level name or item or the data model, level or item doesn't exists, the configuration will fail to be setup inside litmus production record database in offline mode, the configurator will verify the trigger tag string for invalid ascii characters to learn more about which ascii characters are allowed, review the section restrictions on ascii characters allowed to be used invalid ascii characters if an invalid character is found, a prompt is shown to the user invalid characters are marked in red as spaces are not a visible character, they can't be marked in red, so the user can make use of the comment added to the cell as well define the source of the item value to be able to record a value for an item for an event, litmus production record database does require a source for the value litmus production record database supports four different sources source for item value what is recorded example timeoftrigger the timestamp of when the trigger did fire litmus production record database does use for this the system time of the sql server in utc 2023 16 05 13 19 25 124 isconstant a fixed constant value provided through the configuration asset 1 valuefromtag litmus production record database will read the value from a tag for the timestamp of when the trigger fired 24 45 iscalculation litmus production record database will calculate the value for the duration of the respective event from the defined tag according to the calculation type there are currently seven supported calculation types which are inspected closer in their own section further down in this guide note if the tag stores alphanumerical values, the last value is returned as no calculation can be performed 45 7 the user sets the source of the item value by selecting it from the drop down menu in the column labeled source of item value this will add the selected string into the cell note only values available through the drop down menu can be selected define the item value or calculation source this column labeled source of item value allows the user to define the actual value or the tag to be used to read the item value from or use for the calculation note this column does not need to be filled in, if the cell itself is greyed out how to enter the value will change depending on the choice made in the column labeled source of item value source of item value = timeoftrigger the cell will be greyed out and the user does not have to insert a value source of item value = isconstant the user enters the constant value for the two options valuefromtag an iscalculation , it is required that a tag defined in litmus production record database is used in the column labeled item value / calculation these tags have to be defined inside litmus production record database beforehand, for example using the litmus solution litmus production record tag configurator in online mode, users select the tag from the drop down menu in the column labeled item value / calculation the trigger tag is a pipe symbol " | " separated string composed of first position = device name used when setting up the tag in litmus production record database plc rc1 ccs | htr htg temp pv | value second position = tag name used when setting up the tag in litmus production record database plc rc1 ccs | htr htg temp pv | value third position = item name used when setting up the tag in litmus production record database plc rc1 ccs | htr htg temp pv | value note only values available through the drop down menu can be selected important do not leave blank rows between entries or at the start a blank row will be seen as the end of the configuration and the configurator will not process any entry past the blank row t he configurator will verify the item value or tag used for the value for invalid ascii characters to learn more about which ascii characters are allowed, review the section restrictions on ascii characters allowed to be used the configurator also validates the length of the string if the source has been defined as isconstant invalid ascii characters if an invalid character is found, a prompt is shown to the user invalid characters are marked in red as spaces are not a visible character, they can't be marked in red, so the user can make use of the comment added to the cell as well invalid string length to allow for the most efficient storage the maximum length of a constant item value can not exceed 256 characters if a constant item value is longer 256 characters, the user will be prompted note constant item values which exceed the 256 character limit, will by default be trimmed to 256 characters if no action is taken by the user in offline mode if the options valuefromtag an iscalculation have been chosen as source for the item, it is required that a tag defined in litmus production record database is used in the column labeled item value / calculation in offline mode, the user will have to insert the pipe symbol "|" separated string for the tag manually as the configurator can not download which tags are defined on the sql server and can not create the drop down menu available in online mode note if the tag string incudes a wrongly spelled device, tag or item or the device, tag or item doesn't exists, the configuration will fail to be setup inside litmus production record database in offline mode, the configurator will verify the item value or tag used for the value for invalid ascii characters to learn more about which ascii characters are allowed, review the section restrictions on ascii characters allowed to be used the configurator also validates the length of the string if the source has been defined as isconstant define if an item is an identifier litmus production record database makes use of identifiers to allow users to retrieve event data without having to know any internal database id or index the concept of identifiers for production events is explained in the chapter how are data recorded in litmus production record database docid\ ulfmhqnmwb91rkntbaqqn if the user has selected as value for the column source of item value the entry iscalculation , the value for the column isidentifier will be set to the value no as items which get their value from a calculation can not be identifiers as they only can be collected at the end of an event and not at the start as identifiers have to be collected the user selects which items are an identifier by selecting the value yes from the drop down menu all identifiers have to be defined for hierarchy level 0, which means that the value in the column labeled hierarchy level and item can only consist of the data model name and item name define if an item is collected for a new or previous event litmus production record database is based on the concept of recording production events each production event has a start and end, which is also what allows to calculate the duration of the event to learn more about the core concept, please review the chapter core concept behind recording production record data via data model docid\ ffsctesqgb9gj7wy5kymo there are two options how a trigger can operate option 1 (always use newevent) an event trigger is unique and describes a single action like the start or end of a process this is for example achieved if each event trigger has a unique tag like for example a tag called runstart and another tag called runend in this case, each trigger will always describe one situation like the process has started or stopped for this type of trigger, the value in the column labelled is the item recorded for the newevent or the previousevent? should always be set to newevent option 2 (depends on item and association to monitored process) an event trigger describes two different actions like the start and end of a process at the same time this is for example achieved if the same trigger when executing finishes a process and starts a new one at the same time this for example can be if the simple value change of a tag is used for example the change of a bar code reading tag in this case, if the bar code does change, the previous event has finished and a new event has started at the same time for this type of trigger, the user has to define which item will be associated with the new event by using the value newevent and which item has to be associated the previous event by selecting the value previousevent for example if we want to record the start and end time of the process then for the item called "start time", the value in the column labelled is the item recorded for the newevent or the previousevent? will be set to newevent as we want to associate it with the newly started event while the item called "end time" will have the value in the column labelled is the item recorded for the newevent or the previousevent? be set to previousevent as it has to be associated to the previous event option 3 (always use previousevent) if the user has selected as value for the column source of item value the entry iscalculation , the value for the column is the item recorded for the newevent or the previousevent? will be set to the value previousevent items which are the result of a calculation are always recorded at the end of an event as the calculation is done over the duration of the event the user selects if an item is collected for a new event or previous event by selecting the value from the drop down menu define the type of the calculation this column allows the user to define what calculations is to be used to calculate the value for the item with a source of item value being set to iscalculated note if the tag stores alphanumerical values, the last value is returned as no calculation can be performed note this column does not need to be filled in, if the cell itself is greyed out litmus production record database supports seven different types of calculation calculation type what is calculated average calculate the average (mean) of the value for the defined tag item in the column item value / calculation for the duration between the record time of the items defined in the columns item which provides the start of the time frame for a calculation and item which provides the end of the time frame for a calculation maximum calculate the maximum of the value for the defined tag item in the column item value / calculation for the duration between the record time of the items defined in the columns item which provides the start of the time frame for a calculation and item which provides the end of the time frame for a calculation minimum calculate the minimum of the value for the defined tag item in the column item value / calculation for the duration between the record time of the items defined in the columns item which provides the start of the time frame for a calculation and item which provides the end of the time frame for a calculation standarddeviation calculate the standard deviation of the value for the defined tag item in the column item value / calculation for the duration between the record time of the items defined in the columns item which provides the start of the time frame for a calculation and item which provides the end of the time frame for a calculation median get the median ( middle number) of the value for the defined tag item in the column item value / calculation for the duration between the record time of the items defined in the columns item which provides the start of the time frame for a calculation and item which provides the end of the time frame for a calculation sum create the summation of all of the values for the defined tag item in the column item value / calculation for the duration between the record time of the items defined in the columns item which provides the start of the time frame for a calculation and item which provides the end of the time frame for a calculation mode get the mode ( most frequent number) of the value for the defined tag item in the column item value / calculation for the duration between the record time of the items defined in the columns item which provides the start of the time frame for a calculation and item which provides the end of the time frame for a calculation the user sets the calculation type of the item value by selecting it from the drop down menu in the column labeled type of calculation this will add the selected string into the cell note only values available through the drop down menu can be selected define which data model item is used to get the start time for the duration used for the calculation if a data model item stores the result of a calculation, this result is calculated for over a duration in litmus production record database, each value recorded for a data model item is recorded with the timestamp when the value was stored this recordtime is used to define the start and end of the duration used for the calculation this column allows the user to define what data model item is used to retrieve its recordtime which is used as the start time of the duration to be able to calculate the value for the item with a source of item value being set to iscalculated note this column does not need to be filled in, if the cell itself is greyed out a data model item used in the column labeled item which provides the start of the time frame for a calculation , has to be defined inside litmus production record database beforehand, for example using the litmus solution litmus production record data model configurator the data model item together with its position in the data model hierarchy updated to retrieve the recordtime as start time for the calculation duration is configured in the column labeled item which provides the start of the time frame for a calculation in online mode, users select the item from the drop down menu in the column labeled item which provides the start of the time frame for a calculation the hierarchy level and item is a pipe symbol " | " separated string composed of first position = is always the data model name used when setting up the data model in litmus production record database line x | station a | right side | start time last position = is always an item name set up inside a data model in litmus production record database line x | station a | right side | start time optional positions 2 (level 1), 3 (level 2), 4 (level 3), 5 (level 4), 6 (level 5) = individual hierarchy level names set up inside a data model in litmus production record database example for a hierarchy level 2 item hierarchy level 1 line x | station a | right side | start time hierarchy level 2 line x | station a | right side | start time note only values available through the drop down menu can be selected important do not leave blank rows between entries or at the start a blank row will be seen as the end of the configuration and the configurator will not process any entry past the blank row in offline mode in offline mode, the user will have to insert the pipe symbol "|" separated string manually as the configurator can not download which tags are defined on the sql server and can not create the drop down menu available in online mode note if the string incudes a wrongly spelled data model name, level name or item or the data model, level or item doesn't exists, the configuration will fail to be setup inside litmus production record database in offline mode, the configurator will verify the string for invalid ascii characters to learn more about which ascii characters are allowed, review the section restrictions on ascii characters allowed to be used invalid ascii characters if an invalid character is found, a prompt is shown to the user invalid characters are marked in red as spaces are not a visible character, they can't be marked in red, so the user can make use of the comment added to the cell as well define which data model item is used to get the end time for the duration used for the calculation if a data model item stores the result of a calculation, this result is calculated for over a duration in litmus production record database, each value recorded for a data model item is recorded with the timestamp when the value was stored this recordtime is used to define the start and end of the duration used for the calculation this column allows the user to define what data model item is used to retrieve its recordtime which is used as the end time of the duration to be able to calculate the value for the item with a source of item value being set to iscalculated note this column does not need to be filled in, if the cell itself is greyed out a data model item used in the column labeled item which provides the end of the time frame for a calculation , has to be defined inside litmus production record database beforehand, for example using the litmus solution litmus production record data model configurator the data model item together with its position in the data model hierarchy updated to retrieve the recordtime as end time for the calculation duration is configured in the column labeled item which provides the end of the time frame for a calculation in online mode, users select the item from the drop down menu in the column labeled item which provides the end of the time frame for a calculation the hierarchy level and item is a pipe symbol " | " separated string composed of first position = is always the data model name used when setting up the data model in litmus production record database line x | station a | right side | end time last position = is always an item name set up inside a data model in litmus production record database line x | station a | right side | end time optional positions 2 (level 1), 3 (level 2), 4 (level 3), 5 (level 4), 6 (level 5) = individual hierarchy level names set up inside a data model in litmus production record database example for a hierarchy level 2 item hierarchy level 1 line x | station a | right side | end time hierarchy level 2 line x | station a | right side | end time note only values available through the drop down menu can be selected important do not leave blank rows between entries or at the start a blank row will be seen as the end of the configuration and the configurator will not process any entry past the blank row in offline mode in offline mode, the user will have to insert the pipe symbol "|" separated string manually as the configurator can not download which tags are defined on the sql server and can not create the drop down menu available in online mode note if the string incudes a wrongly spelled data model name, level name or item or the data model, level or item doesn't exists, the configuration will fail to be setup inside litmus production record database in offline mode, the configurator will verify the string for invalid ascii characters to learn more about which ascii characters are allowed, review the section restrictions on ascii characters allowed to be used invalid ascii characters if an invalid character is found, a prompt is shown to the user invalid characters are marked in red as spaces are not a visible character, they can't be marked in red, so the user can make use of the comment added to the cell as well