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.