This table stores the job containers. The job containers are used to group all the activities (usd_activity)
| 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 | This refers to a task used to run a query, for templates. |
| 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 job container. |
| comment | nvarchar(255) | not null | This is the comment of the job container. |
| credate | integer | not null | Creation date of the job container. |
| cretime | integer | not null | Creation time of the job container. |
| chdate | integer | not null | Change date of the job container. |
| chtime | integer | not null | Change time of the job container. |
| propflag | integer | not null | This is the group property flag. |
| qcalendar | nvarchar(129) | not null | This is the calendar linked to a query. |
| qevalrate | integer | not null | This is the evaluation rate of a query. |
| qnextevaldate | integer | not null | This is the next evaluation date of a query. |
| qnextevaltime | integer | not null | This is the next evaluation time of a query. |
| qevaldate | integer | not null | This is the last evaluation date of a query. |
| qevaltime | integer | not null | This is the last evaluation time of a query. |
| qtemplfold | byte(16) | not null | This is the template folder id. |
| qtype | integer | not null | This is the type of query. |
| 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 auxiliary text stores helpdesk integration information. |
| auxtext1 | nvarchar(128) | with null | This auxiliary text stores helpdesk integration information. |
| 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 | This is the query id. |
| dts_state | integer | with null | This is the file transfer state. |
Product Name: Unicenter Desktop and Server Management
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| objectid | usd_link_jc_srv | jcont |
| objectid | usd_link_jc_act | jcont |
| objectid | usd_link_jc | jcparent |
| objectid | usd_link_jc | jcchild |
| objectid | usd_jcview | jobcont |