WP_TASK_INFO
This table stores some general information about tasks.
Foreign Keys
Primary Key Table |
Primary Key Column |
Foreign Key Column |
---|---|---|
ITG_ACTIVITIES_NLS |
ACTIVITY_ID |
ACTIVITY_ID |
KNTA_USERS |
USER_ID |
CREATED_BY |
KNTA_USERS |
USER_ID |
LAST_UPDATED_BY |
RSC_ROLES_NLS |
ROLE_ID |
ROLE_ID |
WP_WORK_UNITS |
WORK_UNIT_ID |
UNASSIGNED_WORK_UNIT_ID |
Column Descriptions
Column Name |
Null? |
Data Type |
Description |
---|---|---|---|
TASK_INFO_ID |
NOT NULL |
NUMBER |
System-generated identifier |
VERSION |
NOT NULL |
NUMBER |
System-generated version for the entity. This column must not be updated manually |
ACTIVITY_ID |
NULLABLE |
NUMBER |
Foreign key to ITG_ACTIVITIES, indicates the task's activity |
CRITICAL_PATH_TASK |
NULLABLE |
NUMBER |
Indicates whether a given task is on the work plan critical path |
AUTO_EFFORT_MODE |
NULLABLE |
VARCHAR2(1) |
Indicates whether effort is entered automatically (computed based on the resource calendar and the task duration) or manually |
MILESTONE_MANUAL_CONV |
NULLABLE |
VARCHAR2(1) |
Indicates whether the task was turned into a milestone by the user clicking on the milestone check box or not (meaning the user set the duration of the task to be 0) |
NAME |
NULLABLE |
VARCHAR2(300) |
Indicates the name of the task |
TASK_DESC |
NULLABLE |
VARCHAR2(300) |
Indicates the description of the task |
OVERRIDE_ACTIVITY |
NULLABLE |
NUMBER |
Indicates whether the user set the activity manually on this task or if the activity was rolled down from the task's parent |
PRIORITY |
NULLABLE |
NUMBER |
Indicates the priority for the task |
TASK_TYPE_CODE |
NULLABLE |
VARCHAR2(1) |
Indicates whether the task is a leaf task (L), a summary task (S) or a milestone (M) |
ROLE_ID |
NULLABLE |
NUMBER |
Foreign key to rsc_roles table, stores the role associated with the task |
ROLE_EXPLICIT |
NULLABLE |
VARCHAR2(1) |
Indicates whether the role was explicitly set by the user or derived from the resource assigned |
SCHEDULE_CODE |
NULLABLE |
NUMBER |
Not used |
SCHEDULE_HEALTH |
NULLABLE |
VARCHAR2(255) |
Indicates the schedule health of the task |
SLACK |
NULLABLE |
NUMBER |
Indicates the task's slack |
STATUS |
NULLABLE |
NUMBER |
Indicates the status of the task |
ELIGIBLE_TASK_COUNT |
NULLABLE |
NUMBER |
Indicates the number of tasks under a particular task that need to be considered when computing exceptions |
EXCEPTION_TASK_COUNT |
NULLABLE |
NUMBER |
Indicates the number of tasks under a particular task that have exceptions |
TOTAL_EXCEPTION_COUNT |
NULLABLE |
NUMBER |
Indicates the total number of exceptions on this task or its children |
UNASSIGNED_WORK_UNIT_ID |
NULLABLE |
NUMBER |
Foreign key to the WP_WORK_UNITS table, identifies the work unit which holds the information for the unassigned part of the task |
REQUIRED |
NULLABLE |
VARCHAR2(1) |
Indicates whether this task is required on the work plan and cannot be deleted |
CREATED_BY |
NOT NULL |
NUMBER |
Identifier for the user who created the record |
CREATION_DATE |
NOT NULL |
DATE |
Date record was created |
LAST_UPDATED_BY |
NOT NULL |
NUMBER |
Identifier for the user who last updated the record |
LAST_UPDATE_DATE |
NOT NULL |
DATE |
Date record was last updated |
OWNER_TASK_ID |
NULLABLE |
NUMBER |
ID of the task in WP_TASKS table |
SERVICE_ID |
NULLABLE |
VARCHAR2(40) |
The service ID |
SERVICE_NAME |
NULLABLE |
VARCHAR2(255) |
The service name |
OVERRIDE_SERVICE |
NULLABLE |
VARCHAR2(1) |
Indicates whether this service can be overridden by parent node, the default flag 'N' represents the overridden. |
Indexes
Index Name |
Index Type |
Sequence |
Column Name |
---|---|---|---|
FK69A6A14226AE1775_I |
NONUNIQUE |
1 |
ROLE_ID |
FK69A6A142A2C1EF93_I |
NONUNIQUE |
1 |
ACTIVITY_ID |
FK69A6A142AEA94CD1_I |
NONUNIQUE |
1 |
UNASSIGNED_WORK_UNIT_ID |
SYS_C005201613 |
UNIQUE |
1 |
TASK_INFO_ID |
Sequences
Sequence Name |
Sequence Type |
---|---|
WP_TASK_INFO_S |
TASK_INFO_ID |