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 |
