ii_objects Catalog

The ii_objects catalog contains a row for every user interface object in the database. This catalog stores basic information about each object, such as name, owner, object ID, object class, and creation date.

Objects in this table often have additional information represented in rows of one or more other user interface catalogs; for example, form objects are also represented by rows in ii_forms, ii_fields, and ii_trim. In all cases, the object ID is the key column that is used to join information from multiple catalogs about a single object.

The ii_objects catalog is a btree table, keyed on the object_class, object_owner, and object_name columns. The ii_objects catalog has a secondary index, btree unique, keyed on the object_id column:

Column Name	Data Type	Description
object_id	integer	The object identifier, unique among user interface objects in the database.
object_class	integer	The object's class. Tells what type of object this is (form, report, and so on). For object class definitions, see Object Classes in the ii_objects Catalog.
object_name	varchar(32)	The name of the object.
object_owner	varchar(32)	The object owner's user name.
object_env	integer	Currently unused.
is_current	smallint	Currently unused.
short_remark	varchar(60)	A short descriptive remark associated with the object.
object_language	smallint	Currently unused.
create_date	char(25)	The time and date when the object was initially created.
alter_date	char(25)	The time and date when the object, or associated information, was most recently altered or saved.
alter_count	integer	A count of the number of times this object has been altered or saved.
last_altered_by	varchar(32)	The name of the user who last altered or saved this object.

Object Class	Description
1002	JoinDef
1501	Generic Report
1502	Report-Writer Report
1511	RBF Report
1601	Form
2001	ABF Application
2010	4GL Intermediate Language Code
2021	Host Language Procedure
2050	4GL Procedure
2075	Database Procedure
2110	Global Variable
2120	Constant
2130	Record Definition
2133	Record Attribute
2190	Undefined Procedure
2201	QBFName
2210	4GL Frame
2219	Old 4GL Frame
2220	Report Frame
2230	QBF Frame
2249	GBF Frame
2250	Undefined Frame
2260	Vision menuframe
2261	Vision append frame
2262	Vision update frame
2264	Vision browse frame
3001	ABF Form Reference
3501	Dependency Type: member of
3502	Dependency Type: database reference
3503	Dependency Type: call with no use of return code
3504	Dependency Type: call with use of return code