Share this page

# 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

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: