pm_objects

The pm_objects stores information about each procedure object (except shortcuts) in the Procedure Management library.

TABLE pm_objects (
object_guid VARCHAR(36) NOT NULL,
object_type SMALLINT NOT NULL,
object_name VARCHAR(64) NOT NULL,
version_major INTEGER NULL,
version_minor INTEGER NULL,
icon_mod_time DATETIME NOT NULL,
icon_binary VARBINARY(MAX) NULL,
icon_size INTEGER NOT NULL,
object_url VARCHAR(1000) NULL,
author VARCHAR(64) NULL,
object_create_time DATETIME NOT NULL,
object_mod_time DATETIME NOT NULL,
release_id VARCHAR(64) NULL,
security_all SMALLINT NOT NULL,
proc_id INTEGER NOT NULL,
proc_status SMALLINT NULL)

Column	Description
object_guid	Globally unique, system-generated identifier for this procedure object. The row defining the Procedure Management library root has the value ROOT_LIBRARY_GUID.
object_type	Procedure object type. Either: library (0), procedure (1), sub-procedure (2) or sub-procedure parameter template (3).
object_name	Name of this procedure object. Note: The object’s description (if defined) is also included as part of this field, in brackets following the name.
version_major	Major version number of the version associated with this procedure object, as defined in the proc_version table. This value is always 0 if the object is a library.
version_minor	Minor version number of the version associated with this procedure object, as defined in the proc_version table. This value is always 0 if the object is a library.
icon_mod_time	Time that the icon associated with this procedure object was last modified.
icon_binary	Binary form of the icon associated with this procedure object.
icon_size	Size (in bytes) of the icon associated with this procedure object.
object_url	Usage URL associated with this procedure object.
author	Value of the Author extended property for this procedure object.
object_create_time	Value of the Date Created extended property for this procedure object, showing the time that this object was created.
object_mod_time	Value of the Date Modified extended property for this procedure object, showing the time that this procedure object was last modified.
release_id	Value of the Release Identification extended property for this procedure object.
security_all	Flag that defines whether (1) or not (0) the OEM lock is set for this procedure object.
proc_id	Procedure number of the procedure associated with this procedure object, as defined in the proc_index table. This value is always -1 if the object is a library.
proc_status	For internal use only.

Column

Description

object_guid

Globally unique, system-generated identifier for this procedure object.

The row defining the Procedure Management library root has the value ROOT_LIBRARY_GUID.

object_type

Procedure object type. Either: library (0), procedure (1), sub-procedure (2) or sub-procedure parameter template (3).

object_name

Name of this procedure object.

Note: The object’s description (if defined) is also included as part of this field, in brackets following the name.

version_major

Major version number of the version associated with this procedure object, as defined in the proc_version table.