[Home] [Help]
[Dependency Information]
Object Name: | PA_PROJ_ROLLUP_BULK_TEMP |
---|---|
Object Type: | TABLE |
Owner: | PA |
FND Design Data: | ![]() |
Subobject Name: | |
Status: | VALID |
This table is used to generate schedules for sets of dates in a project. Records are deleted from the table at the end of the user session.
Tablespace: | ![]() |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PA_PROJ_ROLLUP_BULK_TEMP_U1 | NORMAL | UNIQUE |
![]() |
![]() ![]() ![]() |
PA_PROJ_ROLLUP_BULK_TEMP_N3 | NORMAL | NONUNIQUE |
![]() |
![]() ![]() ![]() |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PROCESS_NUMBER | NUMBER | Yes | Process number for generating a schedule | |
OBJECT_ID | NUMBER | (15) | Yes | Object ID of the object to be processed |
OBJECT_TYPE | VARCHAR2 | (30) | Yes | Object type for the processed object |
PARENT_OBJECT_ID | NUMBER | (15) | The parent ID for the processed object ID | |
PARENT_OBJECT_TYPE | VARCHAR2 | (30) | The parent type for the processed object ID | |
CALENDAR_ID | NUMBER | (15) | The calendar ID for the processed object | |
CONSTRAINT_TYPE_CODE | VARCHAR2 | (1) | The constraint type for the processed object | |
CONSTRAINT_DATE | DATE | The constraint date for the processed object | ||
WBS_LEVEL | NUMBER | Yes | The WBS level for the processed object | |
START_DATE1 | DATE | The start date for data set 1 | ||
START_DATE_OVERRIDE1 | DATE | The override start date for data set 1 | ||
FINISH_DATE1 | DATE | The finish date for data set 1 | ||
DURATION1 | NUMBER | The duration for data set 1 | ||
TASK_STATUS1 | NUMBER | The task status for data set 1 | ||
PROGRESS_STATUS_WEIGHT1 | NUMBER | The progress status weight for data set 1 | ||
PROGRESS_OVERRIDE1 | NUMBER | The progress status override for data set 1 | ||
REMAINING_EFFORT1 | NUMBER | The estimated remaining effort for data set 1 | ||
PERCENT_COMPLETE1 | NUMBER | The percent complete for data set 1 | ||
PERCENT_OVERRIDE1 | NUMBER | The percent complete override for data set 1 | ||
TASK_WEIGHT1 | NUMBER | The task weight for data set 1 | ||
NUMBER_FIELD1 | NUMBER | The number field for data set 1 | ||
ROLLUP_NODE1 | VARCHAR2 | (1) | The rollup node flag for data set 1 | |
DIRTY_FLAG1 | VARCHAR2 | (1) | The process dirty flag for data set 1 | |
ETC_COST1 | NUMBER | The estimate to complete cost for data set 1 | ||
PPL_ETC_COST1 | NUMBER | The estimate to complete cost for people for data set 1 | ||
EQPMT_ETC_COST1 | NUMBER | The estimate to complete cost for equipment for data set 1 | ||
PPL_UNPLAND_EFFORT1 | NUMBER | The unplanned effort for people for data set 1 | ||
EQPMT_ETC_EFFORT1 | NUMBER | The estimate to complete effort for equipment for data set 1 | ||
SUB_PRJ_ETC_COST1 | NUMBER | The estimate to complete cost for subprojects for data set 1 | ||
SUB_PRJ_PPL_ETC_COST1 | NUMBER | The subproject estimate to complete cost for people for data set 1 | ||
SUB_PRJ_EQPMT_ETC_COST1 | NUMBER | The subproject estimate to complete cost for equipment for data set 1 | ||
SUB_PRJ_PPL_ETC_EFFORT1 | NUMBER | The subproject estimate to complete effort for people for data set 1 | ||
SUB_PRJ_EQPMT_ETC_EFFORT1 | NUMBER | The subproject estimate to complete effort for equipment for data set 1 | ||
EARNED_VALUE1 | NUMBER | The actual or earned value for data set 1 | ||
BAC_VALUE1 | NUMBER | The planned value or budget at completion (BAC) value for data set 1 | ||
PERC_COMP_DERIVATIVE_CODE1 | VARCHAR2 | (30) | The percentage derivative code for data set 1 | |
START_DATE2 | DATE | The start date for data set 2 | ||
START_DATE_OVERRIDE2 | DATE | The override start date for data set 2 | ||
FINISH_DATE2 | DATE | The finish date for data set 2 | ||
DURATION2 | NUMBER | The duration for data set 2 | ||
TASK_STATUS2 | NUMBER | The task status for data set 2 | ||
PROGRESS_STATUS_WEIGHT2 | NUMBER | The progress status weight for data set 2 | ||
PROGRESS_OVERRIDE2 | NUMBER | The progress status override for data set 2 | ||
REMAINING_EFFORT2 | NUMBER | The estimated remaining effort for data set 2 | ||
PERCENT_COMPLETE2 | NUMBER | The percent complete for data set 2 | ||
PERCENT_OVERRIDE2 | NUMBER | The percent complete override for data set 2 | ||
TASK_WEIGHT2 | NUMBER | The task weight for data set 2 | ||
NUMBER_FIELD2 | NUMBER | The number field for data set 2 | ||
ROLLUP_NODE2 | VARCHAR2 | (1) | The rollup node flag for data set 2 | |
DIRTY_FLAG2 | VARCHAR2 | (1) | The process dirty flag for data set 2 | |
ETC_COST2 | NUMBER | The estimate to complete cost for data set 2 | ||
PPL_ETC_COST2 | NUMBER | The estimate to complete cost for people for data set 2 | ||
EQPMT_ETC_COST2 | NUMBER | The estimate to complete cost for equipment for data set 2 | ||
PPL_UNPLAND_EFFORT2 | NUMBER | The unplanned effort for people for data set 2 | ||
EQPMT_ETC_EFFORT2 | NUMBER | The estimate to complete effort for equipment for data set 2 | ||
SUB_PRJ_ETC_COST2 | NUMBER | The estimate to complete cost for subprojects for data set 2 | ||
SUB_PRJ_PPL_ETC_COST2 | NUMBER | The subproject estimate to complete cost for people for data set 2 | ||
SUB_PRJ_EQPMT_ETC_COST2 | NUMBER | The subproject estimate to complete cost for equipment for data set 2 | ||
SUB_PRJ_PPL_ETC_EFFORT2 | NUMBER | The subproject estimate to complete effort for people for data set 2 | ||
SUB_PRJ_EQPMT_ETC_EFFORT2 | NUMBER | The subproject estimate to complete effort for equipment for data set 2 | ||
EARNED_VALUE2 | NUMBER | The actual or earned value for data set 2 | ||
BAC_VALUE2 | NUMBER | The planned value or budget at completion (BAC) value for data set 2 | ||
PERC_COMP_DERIVATIVE_CODE2 | VARCHAR2 | (30) | The percentage derivative code for data set 2 | |
START_DATE3 | DATE | The start date for data set 3 | ||
START_DATE_OVERRIDE3 | DATE | The override start date for data set 3 | ||
FINISH_DATE3 | DATE | The finish date for data set 3 | ||
DURATION3 | NUMBER | The duration for data set 3 | ||
TASK_STATUS3 | NUMBER | The task status for data set 3 | ||
PROGRESS_STATUS_WEIGHT3 | NUMBER | The progress status weight for data set 3 | ||
PROGRESS_OVERRIDE3 | NUMBER | The progress status override for data set 3 | ||
REMAINING_EFFORT3 | NUMBER | The estimated remaining effort for data set 3 | ||
PERCENT_COMPLETE3 | NUMBER | The percent complete for data set 3 | ||
PERCENT_OVERRIDE3 | NUMBER | The percent complete override for data set 3 | ||
TASK_WEIGHT3 | NUMBER | The task weight for data set 3 | ||
NUMBER_FIELD3 | NUMBER | The number field for data set 3 | ||
ROLLUP_NODE3 | VARCHAR2 | (1) | The rollup node flag for data set 3 | |
DIRTY_FLAG3 | VARCHAR2 | (1) | The process dirty flag for data set 3 | |
ETC_COST3 | NUMBER | The estimate to complete cost for data set 3 | ||
PPL_ETC_COST3 | NUMBER | The estimate to complete cost for people for data set 3 | ||
EQPMT_ETC_COST3 | NUMBER | The estimate to complete cost for equipment for data set 3 | ||
PPL_UNPLAND_EFFORT3 | NUMBER | The unplanned effort for people for data set 3 | ||
EQPMT_ETC_EFFORT3 | NUMBER | The estimate to complete effort for equipment for data set 3 | ||
SUB_PRJ_ETC_COST3 | NUMBER | The estimate to complete cost for subprojects for data set 3 | ||
SUB_PRJ_PPL_ETC_COST3 | NUMBER | The subproject estimate to complete cost for people for data set 3 | ||
SUB_PRJ_EQPMT_ETC_COST3 | NUMBER | The subproject estimate to complete cost for equipment for data set 3 | ||
SUB_PRJ_PPL_ETC_EFFORT3 | NUMBER | The subproject estimate to complete effort for people for data set 3 | ||
SUB_PRJ_EQPMT_ETC_EFFORT3 | NUMBER | The subproject estimate to complete effort for equipment for data set 3 | ||
EARNED_VALUE3 | NUMBER | The actual or earned value for data set 3 | ||
BAC_VALUE3 | NUMBER | The planned value or budget at completion (BAC) value for data set 3 | ||
PERC_COMP_DERIVATIVE_CODE3 | VARCHAR2 | (30) | The percentage derivative code for data set 3 | |
START_DATE4 | DATE | The start date for data set 4 | ||
START_DATE_OVERRIDE4 | DATE | The override start date for data set 4 | ||
FINISH_DATE4 | DATE | The finish date for data set 4 | ||
DURATION4 | NUMBER | The duration for data set 4 | ||
TASK_STATUS4 | NUMBER | The task status for data set 4 | ||
PROGRESS_STATUS_WEIGHT4 | NUMBER | The progress status weight for data set 4 | ||
PROGRESS_OVERRIDE4 | NUMBER | The progress status override for data set 4 | ||
REMAINING_EFFORT4 | NUMBER | The estimated remaining effort for data set 4 | ||
PERCENT_COMPLETE4 | NUMBER | The percent complete for data set 4 | ||
PERCENT_OVERRIDE4 | NUMBER | The percent complete override for data set 4 | ||
TASK_WEIGHT4 | NUMBER | The task weight for data set 4 | ||
NUMBER_FIELD4 | NUMBER | The number field for data set 4 | ||
ROLLUP_NODE4 | VARCHAR2 | (1) | The rollup node flag for data set 4 | |
DIRTY_FLAG4 | VARCHAR2 | (1) | The process dirty flag for data set 4 | |
ETC_COST4 | NUMBER | The estimate to complete cost for data set 4 | ||
PPL_ETC_COST4 | NUMBER | The estimate to complete cost for people for data set 4 | ||
EQPMT_ETC_COST4 | NUMBER | The estimate to complete cost for equipment for data set 4 | ||
PPL_UNPLAND_EFFORT4 | NUMBER | The unplanned effort for people for data set 4 | ||
EQPMT_ETC_EFFORT4 | NUMBER | The estimate to complete effort for equipment for data set 4 | ||
SUB_PRJ_ETC_COST4 | NUMBER | The estimate to complete cost for subprojects for data set 4 | ||
SUB_PRJ_PPL_ETC_COST4 | NUMBER | The subproject estimate to complete cost for people for data set 4 | ||
SUB_PRJ_EQPMT_ETC_COST4 | NUMBER | The subproject estimate to complete cost for equipment for data set 4 | ||
SUB_PRJ_PPL_ETC_EFFORT4 | NUMBER | The subproject estimate to complete effort for people for data set 4 | ||
SUB_PRJ_EQPMT_ETC_EFFORT4 | NUMBER | The subproject estimate to complete effort for equipment for data set 4 | ||
EARNED_VALUE4 | NUMBER | The actual or earned value for data set 4 | ||
BAC_VALUE4 | NUMBER | The planned value or budget at completion (BAC) value for data set 4 | ||
PERC_COMP_DERIVATIVE_CODE4 | VARCHAR2 | (30) | The percentage derivative code for data set 4 | |
START_DATE5 | DATE | The start date for data set 5 | ||
START_DATE_OVERRIDE5 | DATE | The override start date for data set 5 | ||
FINISH_DATE5 | DATE | The finish date for data set 5 | ||
DURATION5 | NUMBER | The duration for data set 5 | ||
TASK_STATUS5 | NUMBER | The task status for data set 5 | ||
PROGRESS_STATUS_WEIGHT5 | NUMBER | The progress status weight for data set 5 | ||
PROGRESS_OVERRIDE5 | NUMBER | The progress status override for data set 5 | ||
REMAINING_EFFORT5 | NUMBER | The estimated remaining effort for data set 5 | ||
PERCENT_COMPLETE5 | NUMBER | The percent complete for data set 5 | ||
PERCENT_OVERRIDE5 | NUMBER | The percent complete override for data set 5 | ||
TASK_WEIGHT5 | NUMBER | The task weight for data set 5 | ||
NUMBER_FIELD5 | NUMBER | The number field for data set 5 | ||
ROLLUP_NODE5 | VARCHAR2 | (1) | The rollup node flag for data set 5 | |
DIRTY_FLAG5 | VARCHAR2 | (1) | The process dirty flag for data set 5 | |
ETC_COST5 | NUMBER | The estimate to complete cost for data set 5 | ||
PPL_ETC_COST5 | NUMBER | The estimate to complete cost for people for data set 5 | ||
EQPMT_ETC_COST5 | NUMBER | The estimate to complete cost for equipment for data set 5 | ||
PPL_UNPLAND_EFFORT5 | NUMBER | The unplanned effort for people for data set 5 | ||
EQPMT_ETC_EFFORT5 | NUMBER | The estimate to complete effort for equipment for data set 5 | ||
SUB_PRJ_ETC_COST5 | NUMBER | The estimate to complete cost for subprojects for data set 5 | ||
SUB_PRJ_PPL_ETC_COST5 | NUMBER | The subproject estimate to complete cost for people for data set 5 | ||
SUB_PRJ_EQPMT_ETC_COST5 | NUMBER | The subproject estimate to complete cost for equipment for data set 5 | ||
SUB_PRJ_PPL_ETC_EFFORT5 | NUMBER | The subproject estimate to complete effort for people for data set 5 | ||
SUB_PRJ_EQPMT_ETC_EFFORT5 | NUMBER | The subproject estimate to complete effort for equipment for data set 5 | ||
EARNED_VALUE5 | NUMBER | The actual or earned value for data set 5 | ||
BAC_VALUE5 | NUMBER | The planned value or budget at completion (BAC) value for data set 5 | ||
PERC_COMP_DERIVATIVE_CODE5 | VARCHAR2 | (30) | The percentage derivative code for data set 5 | |
START_DATE6 | DATE | The start date for data set 6 | ||
START_DATE_OVERRIDE6 | DATE | The override start date for data set 6 | ||
FINISH_DATE6 | DATE | The finish date for data set 6 | ||
DURATION6 | NUMBER | The duration for data set 6 | ||
TASK_STATUS6 | NUMBER | The task status for data set 6 | ||
PROGRESS_STATUS_WEIGHT6 | NUMBER | The progress status weight for data set 6 | ||
PROGRESS_OVERRIDE6 | NUMBER | The progress status override for data set 6 | ||
REMAINING_EFFORT6 | NUMBER | The estimated remaining effort for data set 6 | ||
PERCENT_COMPLETE6 | NUMBER | The percent complete for data set 6 | ||
PERCENT_OVERRIDE6 | NUMBER | The percent complete override for data set 6 | ||
TASK_WEIGHT6 | NUMBER | The task weight for data set 6 | ||
NUMBER_FIELD6 | NUMBER | The number field for data set 6 | ||
ROLLUP_NODE6 | VARCHAR2 | (1) | The rollup node flag for data set 6 | |
DIRTY_FLAG6 | VARCHAR2 | (1) | The process dirty flag for data set 6 | |
ETC_COST6 | NUMBER | The estimate to complete cost for data set 6 | ||
PPL_ETC_COST6 | NUMBER | The estimate to complete cost for people for data set 6 | ||
EQPMT_ETC_COST6 | NUMBER | The estimate to complete cost for equipment for data set 6 | ||
PPL_UNPLAND_EFFORT6 | NUMBER | The unplanned effort for people for data set 6 | ||
EQPMT_ETC_EFFORT6 | NUMBER | The estimate to complete effort for equipment for data set 6 | ||
SUB_PRJ_ETC_COST6 | NUMBER | The estimate to complete cost for subprojects for data set 6 | ||
SUB_PRJ_PPL_ETC_COST6 | NUMBER | The subproject estimate to complete cost for people for data set 6 | ||
SUB_PRJ_EQPMT_ETC_COST6 | NUMBER | The subproject estimate to complete cost for equipment for data set 6 | ||
SUB_PRJ_PPL_ETC_EFFORT6 | NUMBER | The subproject estimate to complete effort for people for data set 6 | ||
SUB_PRJ_EQPMT_ETC_EFFORT6 | NUMBER | The subproject estimate to complete effort for equipment for data set 6 | ||
EARNED_VALUE6 | NUMBER | The actual or earned value for data set 6 | ||
BAC_VALUE6 | NUMBER | The planned value or budget at completion (BAC) value for data set 6 | ||
PERC_COMP_DERIVATIVE_CODE6 | VARCHAR2 | (30) | The percentage derivative code for data set 6 | |
SUMMARY_OBJECT_FLAG | VARCHAR2 | (1) | Summary object flag |
Cut, paste (and edit) the following text to query this object:
SELECT PROCESS_NUMBER
, OBJECT_ID
, OBJECT_TYPE
, PARENT_OBJECT_ID
, PARENT_OBJECT_TYPE
, CALENDAR_ID
, CONSTRAINT_TYPE_CODE
, CONSTRAINT_DATE
, WBS_LEVEL
, START_DATE1
, START_DATE_OVERRIDE1
, FINISH_DATE1
, DURATION1
, TASK_STATUS1
, PROGRESS_STATUS_WEIGHT1
, PROGRESS_OVERRIDE1
, REMAINING_EFFORT1
, PERCENT_COMPLETE1
, PERCENT_OVERRIDE1
, TASK_WEIGHT1
, NUMBER_FIELD1
, ROLLUP_NODE1
, DIRTY_FLAG1
, ETC_COST1
, PPL_ETC_COST1
, EQPMT_ETC_COST1
, PPL_UNPLAND_EFFORT1
, EQPMT_ETC_EFFORT1
, SUB_PRJ_ETC_COST1
, SUB_PRJ_PPL_ETC_COST1
, SUB_PRJ_EQPMT_ETC_COST1
, SUB_PRJ_PPL_ETC_EFFORT1
, SUB_PRJ_EQPMT_ETC_EFFORT1
, EARNED_VALUE1
, BAC_VALUE1
, PERC_COMP_DERIVATIVE_CODE1
, START_DATE2
, START_DATE_OVERRIDE2
, FINISH_DATE2
, DURATION2
, TASK_STATUS2
, PROGRESS_STATUS_WEIGHT2
, PROGRESS_OVERRIDE2
, REMAINING_EFFORT2
, PERCENT_COMPLETE2
, PERCENT_OVERRIDE2
, TASK_WEIGHT2
, NUMBER_FIELD2
, ROLLUP_NODE2
, DIRTY_FLAG2
, ETC_COST2
, PPL_ETC_COST2
, EQPMT_ETC_COST2
, PPL_UNPLAND_EFFORT2
, EQPMT_ETC_EFFORT2
, SUB_PRJ_ETC_COST2
, SUB_PRJ_PPL_ETC_COST2
, SUB_PRJ_EQPMT_ETC_COST2
, SUB_PRJ_PPL_ETC_EFFORT2
, SUB_PRJ_EQPMT_ETC_EFFORT2
, EARNED_VALUE2
, BAC_VALUE2
, PERC_COMP_DERIVATIVE_CODE2
, START_DATE3
, START_DATE_OVERRIDE3
, FINISH_DATE3
, DURATION3
, TASK_STATUS3
, PROGRESS_STATUS_WEIGHT3
, PROGRESS_OVERRIDE3
, REMAINING_EFFORT3
, PERCENT_COMPLETE3
, PERCENT_OVERRIDE3
, TASK_WEIGHT3
, NUMBER_FIELD3
, ROLLUP_NODE3
, DIRTY_FLAG3
, ETC_COST3
, PPL_ETC_COST3
, EQPMT_ETC_COST3
, PPL_UNPLAND_EFFORT3
, EQPMT_ETC_EFFORT3
, SUB_PRJ_ETC_COST3
, SUB_PRJ_PPL_ETC_COST3
, SUB_PRJ_EQPMT_ETC_COST3
, SUB_PRJ_PPL_ETC_EFFORT3
, SUB_PRJ_EQPMT_ETC_EFFORT3
, EARNED_VALUE3
, BAC_VALUE3
, PERC_COMP_DERIVATIVE_CODE3
, START_DATE4
, START_DATE_OVERRIDE4
, FINISH_DATE4
, DURATION4
, TASK_STATUS4
, PROGRESS_STATUS_WEIGHT4
, PROGRESS_OVERRIDE4
, REMAINING_EFFORT4
, PERCENT_COMPLETE4
, PERCENT_OVERRIDE4
, TASK_WEIGHT4
, NUMBER_FIELD4
, ROLLUP_NODE4
, DIRTY_FLAG4
, ETC_COST4
, PPL_ETC_COST4
, EQPMT_ETC_COST4
, PPL_UNPLAND_EFFORT4
, EQPMT_ETC_EFFORT4
, SUB_PRJ_ETC_COST4
, SUB_PRJ_PPL_ETC_COST4
, SUB_PRJ_EQPMT_ETC_COST4
, SUB_PRJ_PPL_ETC_EFFORT4
, SUB_PRJ_EQPMT_ETC_EFFORT4
, EARNED_VALUE4
, BAC_VALUE4
, PERC_COMP_DERIVATIVE_CODE4
, START_DATE5
, START_DATE_OVERRIDE5
, FINISH_DATE5
, DURATION5
, TASK_STATUS5
, PROGRESS_STATUS_WEIGHT5
, PROGRESS_OVERRIDE5
, REMAINING_EFFORT5
, PERCENT_COMPLETE5
, PERCENT_OVERRIDE5
, TASK_WEIGHT5
, NUMBER_FIELD5
, ROLLUP_NODE5
, DIRTY_FLAG5
, ETC_COST5
, PPL_ETC_COST5
, EQPMT_ETC_COST5
, PPL_UNPLAND_EFFORT5
, EQPMT_ETC_EFFORT5
, SUB_PRJ_ETC_COST5
, SUB_PRJ_PPL_ETC_COST5
, SUB_PRJ_EQPMT_ETC_COST5
, SUB_PRJ_PPL_ETC_EFFORT5
, SUB_PRJ_EQPMT_ETC_EFFORT5
, EARNED_VALUE5
, BAC_VALUE5
, PERC_COMP_DERIVATIVE_CODE5
, START_DATE6
, START_DATE_OVERRIDE6
, FINISH_DATE6
, DURATION6
, TASK_STATUS6
, PROGRESS_STATUS_WEIGHT6
, PROGRESS_OVERRIDE6
, REMAINING_EFFORT6
, PERCENT_COMPLETE6
, PERCENT_OVERRIDE6
, TASK_WEIGHT6
, NUMBER_FIELD6
, ROLLUP_NODE6
, DIRTY_FLAG6
, ETC_COST6
, PPL_ETC_COST6
, EQPMT_ETC_COST6
, PPL_UNPLAND_EFFORT6
, EQPMT_ETC_EFFORT6
, SUB_PRJ_ETC_COST6
, SUB_PRJ_PPL_ETC_COST6
, SUB_PRJ_EQPMT_ETC_COST6
, SUB_PRJ_PPL_ETC_EFFORT6
, SUB_PRJ_EQPMT_ETC_EFFORT6
, EARNED_VALUE6
, BAC_VALUE6
, PERC_COMP_DERIVATIVE_CODE6
, SUMMARY_OBJECT_FLAG
FROM PA.PA_PROJ_ROLLUP_BULK_TEMP;
PA.PA_PROJ_ROLLUP_BULK_TEMP does not reference any database object
PA.PA_PROJ_ROLLUP_BULK_TEMP is referenced by following:
|
|
|