CONF table

Summary

This table contains all the objects in the configuration, it contains only properties that are general for almost all objects, such as name, type and description. This is the core table in the ODBC interface. 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 from the SUPERCONF table. Whereas the SUPERCONF table is meant to be self-contained, this table is meant to be joined with the other type specific tables and perhaps the STANDARD table to complete the view of a given object. In addition, this concept will present as little irrelevant information as possible.

Important

To create a new object in the active configuration, you must insert a new record in this table or the SUPERCONF 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. 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.	-