This table holds all the procedures in a software package, a procedure is used to execute the different capabilities of a software package, e.g. Install the package, Uninstall or Configure the package.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| objectid | byte(16) | not null | Primary key, it is a uuid. |
| version | integer | not null | Version number is used to maintain cache and an optimistic transaction policy |
| creation_user | nvarchar(255) | with null | Used to store the identifier of the entity creator. The string must be a URI of a valid ca_discovered_user entity. |
| itemname | nvarchar(129) | not null | This is the name of the procedure. |
| itemversion | nvarchar(129) | not null | This is the version of the procedure. |
| apesos | integer | not null | This is the operating system of the procedure. |
| subpathentered | nvarchar(255) | not null | This is the text representation of the column subpath. |
| filedby | integer | not null | Type of administrator that registered the procedure, typically enterprise or domain or automatically during installation (autoreg). |
| activatedby | integer | not null | Obsolete column |
| comment | nvarchar(255) | not null | This is a user comment. |
| creationdate | integer | not null | Creation date of the procedure. |
| creationtime | integer | not null | Creation time of the procedure. |
| changedate | integer | not null | Change date of the proecedure. |
| changetime | integer | not null | Change time of the proecedure. |
| type | integer | not null | Procdedure type, typically exe, cmd, pif etc. |
| task | integer | not null | This is the task type, typically install, uninstall etc. |
| subpath | nvarchar(255) | not null | Subpath to the procedure in the volume |
| proctorun | nvarchar(255) | not null | Filename of the procedure, without path. |
| includedproc | integer | not null | The procedures relation to the software package, typically, embedded added or delivery. |
| bootflags | integer | not null | This is the boot flags of this procedure. |
| mask | integer | not null | This is the property mask of this procedure. |
| opmask | integer | not null | This is the operation property mask of this procedure. |
| bootbefore | integer | not null | Specifies that the target should be rebooted before the job is started. |
| bootafter | integer | not null | Specifies that the target should be rebooted after the job has finished. |
| mgmtmask | integer | not null | This is the management mask, typically SD SM. |
| procparameter | nvarchar(4095) | with null | Procedure parameters, entered during registration of procedure. |
| query | byte(16) | not null | This is the uuid of the query associated with the procedure. The query will resolve the prerequisites for the procedure. |
| rsw | byte(16) | with null | This is the link to the software package, FK to usd_rsw. |
| volume | byte(16) | with null | This is the volume to which the procedure belongs, FK to usd_volume. |
Product Name: Unicenter Desktop and Server Management
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| objectid | usd_v_product_procedures | procedure_uuid procedureversion procedure |
| objectid | usd_activity | instproc |
| objectid | usd_activity | actproc |
| objectid | usd_distap | ape |
| objectid | usd_applic | actproc |
| objectid | usd_apdep | depap |
| objectid | usd_apdep | ap |
| objectid | usd_link_grp_proc | ap |