This table stores all the software package (usd_rsw) groups and procedure (usd_actproc) groups.
| 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. |
| qtask | byte(16) | not null | Used to be used for queries. |
| aux | byte(16) | not null | Refers to an auxiliary object |
| aux2 | byte(16) | not null | Refers to a secondary auxiliary object |
| type | integer | not null | This is the group type. |
| attributes | byte(4) | not null | This is the group attribute. |
| name | nvarchar(129) | not null | This is the name of the software package group. |
| comment | nvarchar(255) | not null | This is the comment of the software package. |
| credate | integer | not null | Creation date of the software package. |
| cretime | integer | not null | Creation time of the software package |
| chdate | integer | not null | Change date of the software package |
| chtime | integer | not null | Change time of the software package |
| propflag | integer | not null | This is the group property flag. |
| qcalendar | nvarchar(129) | not null | Used to be used for queries. |
| qevalrate | integer | not null | Used to be used for queries. |
| qnextevaldate | integer | not null | Used to be used for queries. |
| qnextevaltime | integer | not null | Used to be used for queries. |
| qevaldate | integer | not null | Used to be used for queries. |
| qevaltime | integer | not null | Used to be used for queries. |
| qtemplfold | byte(16) | not null | Used to be used for queries. |
| qtype | integer | not null | Used to be used for queries. |
| state | integer | not null | This is the group state. |
| seal | integer | not null | This is the group seal state. |
| var | integer | not null | This is a generic group variable |
| auxtext0 | nvarchar(128) | with null | This is an auxiliary text object, not used in this table. |
| auxtext1 | nvarchar(128) | with null | This is an auxiliary text object, not used in this table. |
| auxtext2 | nvarchar(128) | with null | This is an auxiliary text object, not used in this table. |
| auxtext3 | nvarchar(128) | with null | This is an auxiliary text object, not used in this table. |
| queryid | byte(16) | with null | Used to be used for queries. |
| security_group | integer | not null | Same as as ca_group_def.security_group |
Product Name: Unicenter Desktop and Server Management
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| objectid | usd_link_swgrp | grpparent |
| objectid | usd_link_swg_sw | swg |
| objectid | usd_link_grp_proc | procgrp |