| Table Name: | stage_task |
| Table Number: | 5014 |
| Group: | Task Mgr |
| Description: | Specifies a task in a life cycle stage |
| Flags: | |
| Baseline/Custom: | Baseline |
| Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
|---|---|---|---|---|---|---|---|---|
| active | LONG | tinyint | DIRECT | Indicates whether the task is currently being used; i.e., 0=inactive, 1=active | ||||
| appl_id | CHAR | varchar | 20 | Clarify application identifier of the application which owns the task | ||||
| description | CHAR | varchar | 255 | Description of the task | ||||
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| mandatory_ind | LONG | tinyint | 0 | DIRECT | Indicates whether the task when previewed for a process instance, must be generated; 0=not mandatory, 1=mandatory, default=0 | |||
| name | CHAR | varchar | 2 | 80 | Name of the task | |||
| objective | CHAR | varchar | 255 | Objective or desired outcome of the task | ||||
| objid | LONG | int | 3 | DIRECT | Internal record number | |||
| task_id | CHAR | varchar | 25 | Identifier of the task within stage |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views |
|---|---|---|---|---|---|---|---|
| task2cls_factory | OTOF | cls_factory | factory2stage_task | Class factory which implements the task | |||
| task_type2gbst_elm | MTO | gbst_elm | type2stage_task | Type of implementation intended for the task | |||
| task_status2gbst_elm | MTO | gbst_elm | status2stage_task | Status of the task definition | |||
| task_assign2task_set | MTM | task_set | task_set2stage_task | Task sets to which the task is assigned | mtm_stage_task4_ task_set0 | ||
| task2tsk_stg_role | OTM | tsk_stg_role | role2stage_task | Life cycle stages to which the task is assigned |
| Index Name | Fields | Flags |
|---|---|---|
| stage_task_ind | appl_id:task_id | UNIQUE |
| Index Name | Fields | Additional Information |
|---|---|---|
| objindex | objid | clustered, unique located on PRIMARY |
| stage_task_ind | appl_id, task_id | nonclustered, unique located on PRIMARY |
| View ID | View Name | Tables |
|---|
| stage_task | |||