RPT_FCT_TM_ACTUAL_EFFORT

This table stores work item actual effort information.

Foreign Keys

This table does not have any foreign keys.

Column Description

Column Name

Null?

Data Type

Description

EFFORT_ID

NOT NULL

NUMBER

System-generated identifier by the sequence RPT_FCT_TM_ACTUAL_EFFORT_S

EFFORT_DATE

NOT NULL

DATE

Date for which the effort was submitted

EFFORT_HRS

NULLABLE

NUMBER

The number of effort hours entered for this date

TASK_ID

NULLABLE

NUMBER

ID of the Task if the effort is logged against a Task

TASK_PROJECT_ID

NULLABLE

NUMBER

ID of the Project if the Work Item is a Task or a Project
PROGRAM_ID NULLABLE NUMBER ID of the program if the effort is logged against a program

PROJECT_ID

NULLABLE

NUMBER

ID of the Project if the effort is logged against a Project

REQUEST_ID

NULLABLE

NUMBER

ID of the request if the effort is logged against a request

PACKAGE_ID

NULLABLE

NUMBER

ID of the Package if the effort is logged against a Package

MISCELLANEOUS_ITEM_NAME

NULLABLE

VARCHAR2(150)

The Name of the Miscellaneous Item if the effort is logged against a Miscellaneous Item

RESOURCE_ID

NULLABLE

NUMBER

ID of the Resource who logged the effort

TIME_SHEET_LINE_ID

NULLABLE

NUMBER

ID of the Time Sheet Line where the effort was logged

ACTIVITY_ID

NULLABLE

NUMBER

ID of the Activity associated with this Time Sheet Line

TASK_ROLE_ID

NULLABLE

NUMBER

The Role assigned to a Task if the effort is logged against a Task

RESOURCE_POOL_ID

NULLABLE

NUMBER

ID of the resource pool to which the resource is assigned

DISTRIBUTION_PERCENT

NULLABLE

NUMBER

The percentage of effort distributed to this resource pool

Indexes

Index Name

Index Type

Sequence

Column Name

RPT_FCT_TM_ACTUAL_EFFORT_B1

NONUNIQUE

1

DISTRIBUTION_PERCENT

RPT_FCT_TM_ACTUAL_EFFORT_B10

NONUNIQUE

1

RESOURCE_POOL_ID

RPT_FCT_TM_ACTUAL_EFFORT_B11

NONUNIQUE

1

REQUEST_ID

RPT_FCT_TM_ACTUAL_EFFORT_B12

NONUNIQUE

1

TASK_PROJECT_ID

RPT_FCT_TM_ACTUAL_EFFORT_B7

NONUNIQUE

1

RESOURCE_ID

RPT_FCT_TM_ACTUAL_EFFORT_B8

NONUNIQUE

1

ACTIVITY_ID

RPT_FCT_TM_ACTUAL_EFFORT_B9

NONUNIQUE

1

TASK_ROLE_ID

RPT_FCT_TM_ACTUAL_EFFORT_N1

NONUNIQUE

1

TIME_SHEET_LINE_ID

SYS_C003624095

UNIQUE

1

EFFORT_ID

Sequences

Sequence Name

Sequence Type

RPT_FCT_TM_ACTUAL_EFFORT_S

EFFORT_ID