This table stores all the activities (Jobs) that currently exists, e.g. to install Microsoft Word on 3 targets normally means that one activity is created with three applications linked to the activity. The activity always belongs to a job container.
| 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. |
| ordernumb | integer | not null | This is the order number of the activity inside a job container. |
| state | integer | not null | State of the activity |
| startflag | integer | not null | Descibes the start attributes of the activity. |
| activationtime | integer | not null | States when the activity is going to be activated |
| creationtime | integer | not null | The is the creation time of the activity. |
| giveuptime | integer | not null | This is the give up time of the activity. |
| execmode | integer | not null | This is the job execution mode |
| jobname | nvarchar(255) | not null | This is the name of the activity |
| promptmsg | nvarchar(255) | not null | This is a text to be prompted to the user. |
| promptto | integer | not null | This stores how long the text prompted to the user is displayed (promptMsg). |
| userparams | nvarchar(255) | not null | User supplied job parameters |
| jobbanner | nvarchar(64) | not null | This is the job banner. |
| okcnt | integer | not null | This is the total number of applications that are OK. |
| activecnt | integer | not null | This is the total number of applications that are ACTIVE. |
| errorcnt | integer | not null | This is the total number of applications that are ERROR. |
| mask | integer | not null | This is the property mask of an activity. |
| opmask | integer | not null | This is the job operation property mask. |
| 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. |
| targetmask | integer | not null | This is the target mask. |
| dtsstate | integer | not null | This states the state of the file transfer. |
| deliverytime | integer | not null | States when the activity is going to be delivered |
| cause | integer | not null | This hold the ID of the error or warning message, used with errorcause. |
| renewstate | integer | not null | This is the specific renew state of the activity, if renewed. |
| waitingcnt | integer | not null | This is the total number of applications that are WAITING. |
| waitingrenewcnt | integer | not null | This is the total number of renewed applications that are WAITING. |
| activerenewcnt | integer | not null | This is the total number of renewed applications that are ACTIVE. |
| okrenewcnt | integer | not null | This is the total number of renewed applications that are OK. |
| errorrenewcnt | integer | not null | This is the total number of renewed applications that are ERROR. |
| permmask | integer | not null | Operations/Functions allowed on the job in its current state, it is not object level security related. |
| calendar | nvarchar(32) | with null | This is the calendar attached to the activity |
| errorcause | nvarchar(255) | with null | This hold the parameters of the error or warning message, used with cause. |
| instproc | byte(16) | with null | This is the installation procedure used in the activity, FK to usd_actproc. |
| actproc | byte(16) | with null | This is the activation procedure used in the activity, FK to usd_actproc. |
| compfold | byte(16) | with null | Obsolete link to a usd_cmp_grp |
Product Name: Unicenter Desktop and Server Management
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| objectid | usd_link_act_grp | act |
| objectid | usd_link_act_cmp | act |
| objectid | usd_applic | activity |
| objectid | usd_link_jc_act | activity |
| objectid | usd_link_act_inst | activity |