STANDARD table

Summary

This table contains all the general information for the analog, digital, table and counter objects. It contains all the common properties for 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 meant to be joined with the CONF table, when an object of the above mentioned types is being dealt with. CONF and 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. No insertion can be done in this table.

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 (read only).	-
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
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.
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
MENUCMD	CHAR (260)	Optional command line for pop-up menu.	Documentation pop-up command line on Data Management Definitions 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.