Open topic with navigation

TIBCO iProcess® Engine 11.9.1

# pm_objects

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

## Structure

The `pm_objects` table has the following structure:

    TABLE pm_objects (
    	object_guid		VARCHAR(36)		NOT NULL,
    	object_type		SMALLINT			NOT NULL,
    	object_name		VARCHAR(64)		NOT NULL,
    	version_major		INTEGERNULL,
    	version_minor		INTEGERNULL,
    	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		SMALLINTNULL)

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.

## Primary Key

The following primary key is defined for this table.

Key Name | Column(s)
`pk_pm_objects` | `object_guid`

## Triggers

The following `DELETE CASCADE` trigger is defined for this table.

Trigger Name | Triggered by | Affects Table(s)
`tr_pm_objects` | `DELETE` | pmobjects_security

## Indexes

None.

## Table Activity

The `pm_objects` table contains one row for each procedure object (except shortcuts) in the Procedure Management library.

Rows are added, updated and deleted in the following situations.

A row is... | When...
added | a procedure object is created.
updated | a procedure object is modified.
deleted | a procedure object is deleted.

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO iProcess® Engine