SUPERCONF table

Summary

This table contains all the analog, digital, table, counter and string objects. It contains all the properties for all these objects, such as scan interval, base class interval, data reduction method, driver ID and node number. This is one of the core tables in the ODBC interface and is thought of as a “stand alone” table, that will provide you with most of the information pertaining to each object without the need of joining with many other tables, though that is still possible. Most of the other tables link to the OAN or the AREA and ENAME fields in this table. This is indicated with a $images\link.gif$ in the child table. New objects can only be created from this table and the CONF table.

Important

To create a new object in the active configuration, you must insert a new record in this table or the CONF table. As a minimum, you must fill in the AREA, ENAME and ETYPE fields. This will automatically insert a new record into the relevant type-specific table(s) and perhaps STANDARD. For example, if you create a new analog object (ETYPE=512), a new record is inserted into the ANALOG table and the STANDARD table.
The field OAN shows a unique identifier for each object. This field cannot be changed, and whatever value you supply when inserting a record will be ignored. When joining with other tables, it is always most efficient to do so using the OAN field, but it is still possible to do using the AREA and ENAME fields. Also, when supplying or changing links to other objects, this can be done using either OAN or AREA and ENAME (or all of them, if they do not conflict). For instance, to specify an object’s template, either SUB_OAN or SUB_AREA and SUB_ENAME are specified.

Field name	SQL type	Description	GUI name
OAN	INTEGER	The object’s autonumber; a unique identifier assigned to each objects, which cannot be altered or reused.	-
AREA	CHAR (31)	Area name.	Name in Area Properties dialog box
ENAME	CHAR (31)	Object name. All names within each area must be unique.	Name in Definition of Object dialog box
ETYPE	INTEGER	The object type identified by a unique number (read only for existing objects). Click here $images\chiclet.gif$ to find out which numbers to use.	Type in Definition of Object dialog box or Create Template dialog box
DESCRIPTION	CHAR (255)	Optional description. Typically used to describe the object in more detail.	Description in Definition of Object dialog box
SUB_OAN	INTEGER	The autonumber of the template.	-
SUB_AREA	CHAR (31)	The area name in which the template resides that you want to base this object on	Area in Create Template dialog box
SUB_ENAME	CHAR (31)	The name of the template. The object will automatically inherit all the properties of the specified template.	Name in Create Template or Edit Template dialog box
PROTECT_OAN	INTEGER	The autonumber of the protect object.	-
PROTECT_AREA	CHAR (31)	The name of the area where the protect object resides.	-
PROTECT_ENAME	CHAR (31)	The name of the Protect object you want to use for protecting this object. When protected, the current user must have the necessary privileges to manipulate the object. This is defined in User Administration.	Protection on Data Management Definitions tab
GROUPS	INTEGER	The number of groups this object is a member of.	-
ODBCFIELD	INTEGER	The ODBCFIELD will only be updated by the ODBC driver, never by IGSS. You can use this field for your own purposes.	-
BCLASS	INTEGER	1 = None 2 = 1st base interval (lowest) 3 = 2nd base interval 4 = 3rd base interval 5 = 4th base interval (highest) The base intervals are set in System Configuration.	Base interval on Data Management Definitions tab
SCAN_CLASS	INTEGER	1 = None 2 = 1st scan interval (lowest) 3 = 2nd scan interval 4 = 3rd scan interval 5 = 4th scan interval (highest) The scan intervals are defined in System Configuration.	Scan interval on Data Management Definitions tab
LOG_PRINT	INTEGER	0 = Do not print logged values. 1 = Print logged values.	Log to Printer on Data Management Definitions tab
DRM_AVG	INTEGER	0 = No data reduction and Transfer to History disabled. 1 = Average (data reduction) and Reduced Value (Transfer to History) 2 = Average (data reduction) and Actual Total Value (Transfer to History) 3 = Average (data reduction) and Idealized Total Value (Transfer to History) 4 = Average (data reduction) and None (Transfer to History)	Average and Transfer to History on Data Management Definitions tab
DRM_MIN	INTEGER	0 = No data reduction and Transfer to History disabled. 1 = Minimum (data reduction) and Reduced Value (Transfer to History) 2 = Minimum (data reduction) and Actual Total Value (Transfer to History) 3 = Minimum (data reduction) and Idealized Total Value (Transfer to History) 4 = Minimum (data reduction) and None (Transfer to History)	Minimum and Transfer to History on Data Management Definitions tab
DRM_MAX	INTEGER	0 = No data reduction and Transfer to History disabled. 1 = Maximum (data reduction) and Reduced Value (Transfer to History) 2 = Maximum (data reduction) and Actual Total Value (Transfer to History) 3 = Maximum (data reduction) and Idealized Total Value (Transfer to History) 4 = Maximum (data reduction) and None (Transfer to History)	Maximum and Transfer to History on Data Management Definitions tab
DRM_SUM	INTEGER	0 = No data reduction and Transfer to History disabled. 1 = Sum (data reduction) and Reduced Value (Transfer to History) 2 = Sum (data reduction) and Actual Total Value (Transfer to History) 3 = Sum (data reduction) and Idealized Total Value (Transfer to History) 4 = Sum (data reduction) and None (Transfer to History)	Sum and Transfer to History on Data Management Definitions tab
DRM_ACT	INTEGER	0 = No data reduction and Transfer to History disabled. 1 = Actual (data reduction) and Reduced Value (Transfer to History) 2 = Actual (data reduction) and Actual Total Value (Transfer to History) 3 = Actual (data reduction) and Idealized Total Value (Transfer to History) 4 = Actual (data reduction) and None (Transfer to History)	Actual and Transfer to History on Data Management Definitions tab
DRM_CHG	INTEGER	0 = No data reduction and Transfer to History disabled. 1 = Change (data reduction) and Reduced Value (Transfer to History) 2 = Change (data reduction) and Actual Total Value (Transfer to History) 3 = Change (data reduction) and Idealized Total Value (Transfer to History) 4 = Change (data reduction) and None (Transfer to History)	Change on Data Management Definitions tab
DRM_DIF	INTEGER	0 = No data reduction and Transfer to History disabled. 1 = Difference (data reduction) and Reduced Value (Transfer to History) 2 = Difference (data reduction) and Actual Total Value (Transfer to History) 3 = Difference (data reduction) and Idealized Total Value (Transfer to History) 4 = Difference (data reduction) and None (Transfer to History)	Difference and Transfer to History on Data Management Definitions tab
LOGGING	INTEGER	0 = None 1 = 1st logging percentage (lowest) 2 = 2nd logging percentage 3 = 3rd logging percentage 4 = 4th logging percentage 5 = 5th logging percentage (highest) The logging percentages are defined in System Configuration.	Logging on Data Management Definitions tab
OUTLOGGING	INTEGER	0 = Logging out disabled 1 = Logging out enabled	Out on Data Management Definitions tab
ALARMDELAY	INTEGER	0 = Alarm delay disabled 1 = Alarm delay enabled The actual delay is defined in System Configuration.	Alarm delay on Data Management Definitions tab
DRIVERID	INTEGER	The ID identifying the communication driver used for this object. Click here $images\chiclet.gif$ to view the list of driver IDs.	Driver box on the Edit Mapping tab.
DRIVERSTATION	INTEGER	The ID identifying the station communicated with by the driver.	Driver on Edit Mapping tab (definition) and Station ID on Station tab in System Configuration
NODE_NUMBER	INTEGER	The node number identifying the exact PLC to which this object is connected.	Node box on the Edit Mapping tab.
OPCVISIBLE	INTEGER	1 if the object is visible in the OPC server, 0 if not.	Atoms in OPC Server on the Display tab.
CONNECT_OAN	INTEGER	The autonumber of the connected to object.	-
CONNECT_AREA	CHAR (31)	The name of the area where the connected to object resides.	-
CONNECT_ENAME	CHAR (31)	The name of the object you want to connect this object to. For further information about connecting different object types, click here $images\chiclet.gif$ .	Connect To on Data Management Definitions tab.
SCALING_OAN	INTEGER	The autonumber of the scaling object.	-
SCALING_AREA	CHAR (31)	The name of the area where the scaling object resides.	-
SCALING_ENAME	CHAR (31)	The name of the scaling object with which you want to scale this analog or table object.	Scale As on Data Management Definitions tab
UNIT	INTEGER	Index into the BaseUnits table located in the configuration’s .mdb-file. The measuring unit is used for analog, counter and table objects.	Unit box on Analog, Counter and Table tabs.
DECIMALS	INTEGER	The number of decimals with which you want to display object values for this object.	Decimal Point on Analog, Counter and Table tabs.
MENUCMD	CHAR (260)	Optional command line for pop-up menu.	Documentation pop-up command line on Data Management Definitions tab.
MIN_VAL	DOUBLE	The minimum value of the measuring range for this object.	Minimum value on Analog, Counter and Table tabs.
MAX_VAL	DOUBLE	The maximum value of the measuring range for this object.	Maximum value on Analog, Counter and Table tabs.
LENGTH	INTEGER	For string objects this is the maximum length of the string, for table objects, this is the current number of entries in use.	Maximum Length on String Object tab and number of filled rows on the Table tab.
SYMBOL	INTEGER	0 = Single bit display disabled 1 = Single bit display enabled (state bits are shown independently) Digital objects only.	Displays in Single Bits group on Bit Map I/O tab
CONSEQALM	INTEGER	0 = Individual alarm numbers are used. The alarm numbers are found in the DIG_ALARMS table. 1 = Consecutive alarm numbers are used. The first alarm number is found in the ATOM table. Digital objects only.	Alarm numbers group on the Alarm In/Ack bit tab
SINGLEBITALM	INTEGER	0 = Single bits disabled 1 = Single bits used NOTE: There can only be several, unfinished alarms on the same object in the alarm list if Single bits are used. Digital and analog objects only.	Single Bits on the Alarm In/Ack bit tab
SINGLEBITSTATE	INTEGER	0 = Single bit states disabled 1 = Single bit states used Digital objects only.	Single Bits on the Bit Map I/O tab.
SINGLEBITCMD	INTEGER	0 = Single bit commands disabled 1 = Single bit commands used Digital objects only.	Single Bits on the Bit Map I/O tab.
MINACK	INTEGER	Bit mask for acknowledge bit to PC represented as integer (PLC acknowledge of reception of acknowledge bit from PC). Digital and analog objects only.	To PC bit map on Alarm In/Ack bit tab.
MOUTACK	INTEGER	Bit mask for acknowledge bit from PC represented as integer (operator acknowledgement). Digital and analog objects only.	From PC bit map on Alarm In/Ack bit tab.
MINALM	INTEGER	Bit mask for alarm indication bits to PC represented as integer. Digital and analog objects only.	To PC bit map on the Alarm In/Ack bit tab.
MSTATE	INTEGER	Bit mask for states represented as integer. Digital objects only.	To PC on Bit Map I/O tab
MCOMMAND	INTEGER	Bit map for commands represented as integer Digital objects only.	From PC on Bit Map I/O tab
STATE	INTEGER	Initial state 0 = 1st state 1 = 2nd state 2 = 3rd state … Digital objects only.	Selected state in States list on Change State tab. NOTE: This is the initial state as selected in Definition.
STRING	CHAR (254)	For digital objects, this is the “name” or the “String representation” of the initial state, for string objects this is the initial text string.	String on String Object tab and States list on Change State tab.
VALUE	DOUBLE	For analog objects, this is the initial process value, for digital objects, this is the “free” analog value, and for counter objects, this is the initial counter value.	Actual Value on Analog tab, Free Value on the Change State tab and Current Count on Counter tab.
COMMAND	INTEGER	For digital and counter objects, this is the Initially selected command: 0 = 1st command 1 = 2nd command 2 = 3rd command … For counter objects, these commands are Start=0, Stop=1, Reset=2, Preset=3	Selected command in Commands list on Change State tab and radiobuttons on Counter tab.
HIGHALARM	DOUBLE	High alarm value. For counter objects this is the limit. Analog and counter objects only.	High Alarm on Analog tab and Limit on Counter tab.
HIGHWARNING	DOUBLE	High limit value. Analog objects only.	High Limit on Analog tab
SETPOINT	DOUBLE	Set point value. For counter objects this is the preset value. Analog and counter objects only	Set Point on Analog tab and Preset value on Counter tab.
LOWWARNING	DOUBLE	Low limit value. Analog objects only.	Low Limit on Analog tab
LOWALARM	DOUBLE	Low alarm value. Analog objects only.	Low Alarm on Analog tab
ALARMDELAYTIME	INTEGER	Set the alarm delay for this object in milliseconds.	Alarm delay on the Data Management Definitions tab.
LOGTOSQL	INTEGER	If you want to send a copy of new log values for this object to an SQL Server, use this option. 0 = No logging 1 = Log to SQL	Log to SQL Database on the Data Management Definitions tab.