RPT_DIM_PM_TASKS
This table holds the task information that is derived from PPM table. All the fields are derived from PPM task table.
Foreign Keys
This table does not have any foreign keys.
Column Descriptions
Column Name |
Null? |
Data Type |
Description |
---|---|---|---|
TASK_ID |
NOT NULL |
NUMBER |
Unique ID of the TASK table |
PROJECT_ID |
NULLABLE |
NUMBER |
Identifier of the related project |
WORK_PLAN_ID |
NULLABLE |
NUMBER |
Identifier of the related work plan |
TASK_NAME |
NULLABLE |
VARCHAR2(300) |
Name of the task |
TASK_DESCRIPTION |
NULLABLE |
VARCHAR2(300) |
Description of the task |
PRIORITY |
NULLABLE |
NUMBER |
Priority of the task |
STATUS |
NULLABLE |
VARCHAR2(150) |
Status of the task |
TASK_TYPE |
NULLABLE |
VARCHAR2(1) |
Type of the task |
MILESTONE |
NULLABLE |
VARCHAR2(1) |
It indicates if task is milestone |
MAJOR_MILESTONE |
NULLABLE |
VARCHAR2(1) |
It indicates if task is major milestone |
IN_CRITICAL_PATH |
NULLABLE |
VARCHAR2(1) |
It indicates if task is in critical path |
PARENT_TASK_ID |
NULLABLE |
NUMBER |
ID of parent task |
PARENT_TASK_NAME |
NULLABLE |
VARCHAR2(300) |
Name of parent task |
SCHED_START_DATE |
NULLABLE |
DATE |
Schedule start date of the task |
SCHED_FINISH_DATE |
NULLABLE |
DATE |
Schedule finish date of the task |
SCHED_DURATION |
NULLABLE |
FLOAT |
Schedule duration of the task |
PERC_COMPLETE |
NULLABLE |
FLOAT |
Percent Complete of the task |
ACTUAL_START_DATE |
NULLABLE |
DATE |
Actual start date of the task |
ACTUAL_FINISH_DATE |
NULLABLE |
DATE |
Actual finish date of the task |
ACTUAL_DURATION |
NULLABLE |
FLOAT |
Actual duration of the task |
ESTIMATED_FINISH_DATE |
NULLABLE |
DATE |
Estimated finish date of the task |
CREATED_BY_FIRSTNAME |
NULLABLE |
VARCHAR2(80) |
First Name of user who creates the task |
CREATED_BY_LASTNAME |
NULLABLE |
VARCHAR2(80) |
Last Name of user who creates the task |
CREATION_DATE |
NULLABLE |
DATE |
Task creation date |
SERVICE_ID |
NULLABLE |
VARCHAR2(40) |
ID of the related service |
SERVICE_NAME |
NULLABLE |
VARCHAR2(255) |
Name of the related service |
SCHEDULE_HEALTH |
NULLABLE |
VARCHAR2(255) |
Schedule health of the task |
EXCEPTION_TASK_COUNT |
NULLABLE |
NUMBER |
Number of exception in task |
TOTAL_EXCEPTION_COUNT |
NULLABLE |
NUMBER |
Total exception count in the project |
DATUM1_CODE |
NULLABLE |
VARCHAR2(255) |
User data code 1 |
DATUM1_VISIBLE |
NULLABLE |
VARCHAR2(255) |
Visible value of user data code 1 |
DATUM2_CODE |
NULLABLE |
VARCHAR2(255) |
User data code 2 |
DATUM2_VISIBLE |
NULLABLE |
VARCHAR2(255) |
Visible value of user data code 2 |
DATUM3_CODE |
NULLABLE |
VARCHAR2(255) |
User data code 3 |
DATUM3_VISIBLE |
NULLABLE |
VARCHAR2(255) |
Visible value of user data code 3 |
DATUM4_CODE |
NULLABLE |
VARCHAR2(255) |
User data code 4 |
DATUM4_VISIBLE |
NULLABLE |
VARCHAR2(255) |
Visible value of user data code 4 |
DATUM5_CODE |
NULLABLE |
VARCHAR2(255) |
User data code 5 |
DATUM5_VISIBLE |
NULLABLE |
VARCHAR2(255) |
Visible value of user data code 5 |
DATUM6_CODE |
NULLABLE |
VARCHAR2(255) |
User data code 6 |
DATUM6_VISIBLE |
NULLABLE |
VARCHAR2(255) |
Visible value of user data code 6 |
DATUM7_CODE |
NULLABLE |
VARCHAR2(255) |
User data code 7 |
DATUM7_VISIBLE |
NULLABLE |
VARCHAR2(255) |
Visible value of user data code 7 |
DATUM8_CODE |
NULLABLE |
VARCHAR2(255) |
User data code 8 |
DATUM8_VISIBLE |
NULLABLE |
VARCHAR2(255) |
Visible value of user data code 8 |
DATUM9_CODE |
NULLABLE |
VARCHAR2(255) |
User data code 9 |
DATUM9_VISIBLE |
NULLABLE |
VARCHAR2(255) |
Visible value of user data code 9 |
DATUM10_CODE |
NULLABLE |
VARCHAR2(255) |
User data code 10 |
DATUM10_VISIBLE |
NULLABLE |
VARCHAR2(255) |
Visible value of user data code 10 |
DATUM11_CODE |
NULLABLE |
VARCHAR2(255) |
User data code 11 |
DATUM11_VISIBLE |
NULLABLE |
VARCHAR2(255) |
Visible value of user data code 11 |
DATUM12_CODE |
NULLABLE |
VARCHAR2(255) |
User data code 12 |
DATUM12_VISIBLE |
NULLABLE |
VARCHAR2(255) |
Visible value of user data code 12 |
DATUM13_CODE |
NULLABLE |
VARCHAR2(255) |
User data code 13 |
DATUM13_VISIBLE |
NULLABLE |
VARCHAR2(255) |
Visible value of user data code 13 |
DATUM14_CODE |
NULLABLE |
VARCHAR2(255) |
User data code 14 |
DATUM14_VISIBLE |
NULLABLE |
VARCHAR2(255) |
Visible value of user data code 14 |
DATUM15_CODE |
NULLABLE |
VARCHAR2(255) |
User data code 15 |
DATUM15_VISIBLE |
NULLABLE |
VARCHAR2(255) |
Visible value of user data code 15 |
DATUM16_CODE |
NULLABLE |
VARCHAR2(255) |
User data code 16 |
DATUM16_VISIBLE |
NULLABLE |
VARCHAR2(255) |
Visible value of user data code 16 |
DATUM17_CODE |
NULLABLE |
VARCHAR2(255) |
User data code 17 |
DATUM17_VISIBLE |
NULLABLE |
VARCHAR2(255) |
Visible value of user data code 17 |
DATUM18_CODE |
NULLABLE |
VARCHAR2(255) |
User data code 18 |
DATUM18_VISIBLE |
NULLABLE |
VARCHAR2(255) |
Visible value of user data code 18 |
DATUM19_CODE |
NULLABLE |
VARCHAR2(255) |
User data code 19 |
DATUM19_VISIBLE |
NULLABLE |
VARCHAR2(255) |
Visible value of user data code 19 |
DATUM20_CODE |
NULLABLE |
VARCHAR2(255) |
User data code 20 |
DATUM20_VISIBLE |
NULLABLE |
VARCHAR2(255) |
Visible value of user data code 20 |
Indexes
Index Name |
Index Type |
Sequence |
Column Name |
---|---|---|---|
RPT_DIM_PM_TASKS_N1 |
NONUNIQUE |
1 |
TASK_ID |
RPT_DIM_PM_TASKS_N2 |
NONUNIQUE |
1 |
PROJECT_ID |
RPT_DIM_PM_TASKS_N3 |
NONUNIQUE |
1 |
PARENT_TASK_ID |
RPT_DIM_PM_TASKS_N4 |
NONUNIQUE |
1 |
STATUS |
Sequences
This table uses no sequences.