Tag Database Definitions
ID (int) – A unique number that is automatically generated (starting at 1) that identifies each database entry and is the primary key.
Scan Enabled (bool) – Used to Enable or Disable data collection the associated tag.
Group Name (string) – Used for dividing the data set into user defined logical groups (e.g. machine-5, Tank-3, Production Line-1, etc.)
Description (string) – User defined description for the data being collected (e.g. Tank Level, Tank Temp, Pump Status, etc.)
Protocol (string – drop box) – Communication protocol used for communicating with the remote device (e.g. AB Logix, Modbus, SQL, OPC Server, etc.)
IP Address (string) – the IP address of the device where the data resides (for localhost enter 127.0.0.1)
Path (string) – Additional data required for reaching the data. This could be CPU slot position for AB Logix PLCs, OPC Server name for OPC, file path for SQL, or other such routing information. View the tool-tip-text on this field for more detailed information relating to the selected protocol.
Note: For accessing a file on another server (i.e. sql data files), just mklink command to establish a local connection to the file. A service can't access a mapped drive.
Tag Name (string) – The name of the tag for the desired remote data. The text entered into this field must exactly match that of the remote data tag, including case, underscores, etc. Certain protocols will allow browsing and selection of tags within the remote devices, provided that the devices are online during database creation. For SQL type data, actual SQL queries can be entered into this field.
Update (int) – This is the amount of time that TagTerminal will wait for a response from the remote device before generating an error. This field is not applicable to all protocols.
Data Type (string) – Classification for identifying how the application processes the data (e.g. Integer, Real, string, etc.)
Input Value (string) – This is the current value of the tag in the form delivered by the PLC.
Engineering Unit (string) – A suffix added after the value to indicate the type of data (e.g. °F, %, PSI, etc.)
Transformation-1, 2, 3 – A transformation is a user defined function that takes the raw Input and transforms it into more useful output data. A transformation can assign a color to the data, generate alarms, rescale the data, trim unwanted decimal placed, and an unlimited assortment of other useful functions. Up to three transformations can be arranged in series, where the output of one feeds the input of the next.
Input data = 12.2932
Scale a 4-20 mA signal to an output of 25 to 300
Produces > 167.5394
Trim the value to one decimal place
Produces > 167.5
Compare the value (167.5) to a setpoint of 150
Display high values in red and generate a high alarm
Produces > 167.5 / And generates a High Alarm that is sent to the system's alarm Manager
Output – The resulting value of the tag after being processed by the transformations.
Health (string) – The current health of a monitored data tag.
Log Data (bool) – Select “True” if you would like to record this tag’s value in the historical trend logs.
Retain Min/Max (bool) – Select “True” if you would like to monitor and record the minimum and maximum values between each recording period. E.g. if the data is set to record every 15 minutes, the system can additionally record the minimum and maximum values attained during this monitoring period.
Minimum (string) – The retained minimum value attained during the current recording period.
Maximum (string) – The retained maximum value attained during the current recording period.
Setpoint Value (string) – While this register is primarily intended for storing a setpoint used by a transformation, this register can actually be used to store any additional data needed by any of the transformations. Values can be manually entered into this field or forwarded into this location from other tags.
Aux-1 (string) – this is one of three additional registers for storing data needed by a transformation. Values can be manually entered into this field or forwarded into this location from other tags.
Aux-2 (string) – this is one of three additional registers for storing data needed by a transformation. Values can be manually entered into this field or forwarded into this location from other tags.
Aux-3 (string) – this is one of three additional registers for storing data needed by a transformation. Values can be manually entered into this field or forwarded into this location from other tags.
Forward Value To PLC From – The name of a tag (or tags) to where this tag’s data will be forwarded. (e.g. If a PLC contains both a temperature value and a temperature set point, then the temperature setpoint tag data can be forwarded to the tag with the actual temperature; thus allowing a transformation to compare the two values).
Tag Color Code (int) –This is the current color code that is being generated by the associated tag’s transformations. The color code identifier is then passed to the systems web interface for controlling the tags display color.
Alarm State (int) – 0=not in alarm, 1=low alarm, 2=high alarm, 3=acknowledged, 4=return normal
Alarm Group (int) – By assigning alarms to groups, the system can control what operators receive what alarms.
Alarm Delay (int) – The time remaining before an alarm is sent to the system's Alarm Manager. If the alarm condition clears before the alarm is sent then the alarm message is discarded and not sent.
The Following Tags are used specifically for writing data FROM TagsCollector TO the PLC
Write Enabled (bool) – Allow values to be written out to the associated tag.
Access Level (bool) – This is the access level required before an operator (through the UI) is permitted to send data updates to this particular tag.
Output Transformation (string) – Similar to the input transformations, an output transformation can process the data before sending the data to the field device
Output Value (string) – The value to be written out to the associated device tag. A null value represents that there is no value in the queue to be written.
Write Minimum (string) – The minimum value allowed when writing out to the associated tag.
Write Maximum (string) - The maximum value allowed when writing out to the associated tag.
Write Status (string) – Shows the status of the last write command (pending, failed, success).
Time Stamp (timeDate) – The time/date of the last successful read or write event execution.