Copyright © Cloud Software Group, Inc. All Rights Reserved

proc_mgt_hierarchy

The proc_mgt_hierarchy table stores a set of hierarchy records, which define the hierarchical structure of the Procedure Management library. Each record defines the location of a procedure object in the library.

Structure

The proc_mgt_hierarchy table has the following structure:

TABLE proc_mgt_hierarchy(
parent_guid varchar2(36) NOT NULL,
object_guid varchar2(36) NOT NULL,
is_shortcut number(1) NOT NULL)

Column	Description
parent_guid	ID for the parent library, as defined in the pm_objects table.
object_guid	ID for this procedure object, as defined in the pm_objects table. Note: If is_shortcut is 1, this value is the identifier of the procedure object pointed to by the shortcut.
is_shortcut	Flag that defines whether this hierarchy record is for a real procedure object (0) or for a shortcut (1).

Primary Key

The following primary key is defined for this table.

Key Name	Column(s)	Index Tablespace
pk_proc_mgt_hierarchy	parent_guid object_guid	SMALLINDEXSPACE

Foreign Keys

The following foreign key is defined for this table.

Key Name	Column(s)	Referenced in Table...
fk_proc_mgt_hierarchy1	object_guid	pm_objects

---

1

This key enforces the DELETE CASCADE referential action.

Indexes

None.

Storage

The following STORAGE values are defined for this table.

Value	Definition
Initial	SMALLTABLESIZE
Percentage Increase	SMALLTABLEPCTINCREASE
Tablespace	SMALLTABLESPACE

Table Activity

The proc_mgt_hierarchy table contains one row for every procedure object in the Procedure Management library (except for the root Procedure Management library).

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

A row is...	When...
added	a procedure object is created, copied or moved.
updated	never.
deleted	a procedure object is deleted or moved.

 

Copyright © Cloud Software Group, Inc. All Rights Reserved