[Home] [Help]
[Dependency Information]
Object Name: | PA_SCHEDULE_OBJECTS |
---|---|
Object Type: | TABLE |
Owner: | PA |
Subobject Name: | |
Status: | VALID |
PA.PA_SCHEDULE_OBJECTS is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$TRANSACTION. Data is removed at the end of this period.
Tablespace: | ![]() |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PA_SCHEDULE_OBJECTS_N1 | NORMAL | NONUNIQUE |
![]() |
![]() |
PA_SCHEDULE_OBJECTS_N2 | NORMAL | NONUNIQUE |
![]() |
![]() |
PA_SCHEDULE_OBJECTS_N3 | NORMAL | NONUNIQUE |
![]() |
![]() |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PROCESS_NUMBER | NUMBER | Yes | Process number for genereate schedule | |
OBJECT_TYPE | VARCHAR2 | (30) | Yes | Object type for the processed object |
OBJECT_ID | NUMBER | Yes | Object id of the object to be processed | |
PARENT_OBJECT_TYPE | VARCHAR2 | (30) | The parent type for the processed object id | |
PARENT_OBJECT_ID | NUMBER | The parent id for the processed object id | ||
CALENDAR_ID | NUMBER | 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 the date set 1 | ||
FINISH_DATE1 | DATE | The finish date for the date set 1 | ||
DURATION1 | NUMBER | The duration for the date set 1 | ||
PROGRESS_STATUS_WEIGHT1 | NUMBER | The progress status weight for the date set 1 | ||
PROGRESS_OVERRIDE1 | NUMBER | The progress status override for the date set 1 | ||
REMAINING_EFFORT1 | NUMBER | The estimated remaining effort for the date set 1 | ||
PERCENT_COMPLETE1 | NUMBER | The percent complete for the date set 1 | ||
PERCENT_OVERRIDE1 | NUMBER | The percent complete override for the date set 1 | ||
TASK_WEIGHT1 | NUMBER | The task weight for the date set 1 | ||
NUMBER_FIELD1 | NUMBER | The number field for the date set 1 | ||
ROLLUP_NODE1 | VARCHAR2 | (1) | The process status flag for the date set 1 | |
DIRTY_FLAG1 | VARCHAR2 | (1) | The process status flag for the date set 1 | |
START_DATE2 | DATE | The start date for the date set 2 | ||
FINISH_DATE2 | DATE | The finish date for the date set 2 | ||
DURATION2 | NUMBER | The duration for the date set 2 | ||
PROGRESS_STATUS_WEIGHT2 | NUMBER | The progress status weight for the date set 2 | ||
REMAINING_EFFORT2 | NUMBER | The estimated remaining effort for the date set 2 | ||
PERCENT_COMPLETE2 | NUMBER | The percent complete for the date set 2 | ||
TASK_WEIGHT2 | NUMBER | The task weight for the date set 2 | ||
NUMBER_FIELD2 | NUMBER | The number field for the date set 2 | ||
ROLLUP_NODE2 | VARCHAR2 | (1) | The process status flag for the date set 2 | |
DIRTY_FLAG2 | VARCHAR2 | (1) | The process status flag for the date set 2 | |
START_DATE3 | DATE | The start date for the date set 3 | ||
FINISH_DATE3 | DATE | The finish date for the date set 3 | ||
DURATION3 | NUMBER | The duration for the date set 3 | ||
PROGRESS_STATUS_WEIGHT3 | NUMBER | The progress status weight for the date set 3 | ||
REMAINING_EFFORT3 | NUMBER | The estimated remaining effort for the date set 3 | ||
PERCENT_COMPLETE3 | NUMBER | The percent complete for the date set 3 | ||
TASK_WEIGHT3 | NUMBER | The task weight for the date set 3 | ||
NUMBER_FIELD3 | NUMBER | The number field for the date set 3 | ||
ROLLUP_NODE3 | VARCHAR2 | (1) | The process status flag for the date set 3 | |
DIRTY_FLAG3 | VARCHAR2 | (1) | The process status flag for the date set 3 | |
START_DATE4 | DATE | The start date for the date set 4 | ||
FINISH_DATE4 | DATE | The finish date for the date set 4 | ||
DURATION4 | NUMBER | The duration for the date set 4 | ||
PROGRESS_STATUS_WEIGHT4 | NUMBER | The progress status weight for the date set 4 | ||
REMAINING_EFFORT4 | NUMBER | The estimated remaining effort for the date set 4 | ||
PERCENT_COMPLETE4 | NUMBER | The percent complete for the date set 4 | ||
TASK_WEIGHT4 | NUMBER | The task weight for the date set 4 | ||
NUMBER_FIELD4 | NUMBER | The number field for the date set 4 | ||
ROLLUP_NODE4 | VARCHAR2 | (1) | The process status flag for the date set 4 | |
DIRTY_FLAG4 | VARCHAR2 | (1) | The process status flag for the date set 4 | |
START_DATE5 | DATE | The start date for the date set 5 | ||
FINISH_DATE5 | DATE | The finish date for the date set 5 | ||
DURATION5 | NUMBER | The duration for the date set 5 | ||
PROGRESS_STATUS_WEIGHT5 | NUMBER | The progress status weight for the date set 5 | ||
REMAINING_EFFORT5 | NUMBER | The estimated remaining effort for the date set 5 | ||
PERCENT_COMPLETE5 | NUMBER | The percent complete for the date set 5 | ||
TASK_WEIGHT5 | NUMBER | The task weight for the date set 5 | ||
NUMBER_FIELD5 | NUMBER | The number field for the date set 5 | ||
ROLLUP_NODE5 | VARCHAR2 | (1) | The process status flag for the date set 5 | |
DIRTY_FLAG5 | VARCHAR2 | (1) | The process status flag for the date set 5 | |
START_DATE6 | DATE | The start date for the date set 6 | ||
FINISH_DATE6 | DATE | The finish date for the date set 6 | ||
DURATION6 | NUMBER | The duration for the date set 6 | ||
PROGRESS_STATUS_WEIGHT6 | NUMBER | The progress status weight for the date set 6 | ||
REMAINING_EFFORT6 | NUMBER | The estimated remaining effort for the date set 6 | ||
PERCENT_COMPLETE6 | NUMBER | The percent complete for the date set 6 | ||
TASK_WEIGHT6 | NUMBER | The task weight for the date set 6 | ||
NUMBER_FIELD6 | NUMBER | The number field for the date set 6 | ||
ROLLUP_NODE6 | VARCHAR2 | (1) | The process status flag for the date set 6 | |
DIRTY_FLAG6 | VARCHAR2 | (1) | The process status flag for the date set 6 |
Cut, paste (and edit) the following text to query this object:
SELECT PROCESS_NUMBER
, OBJECT_TYPE
, OBJECT_ID
, PARENT_OBJECT_TYPE
, PARENT_OBJECT_ID
, CALENDAR_ID
, CONSTRAINT_TYPE_CODE
, CONSTRAINT_DATE
, WBS_LEVEL
, START_DATE1
, FINISH_DATE1
, DURATION1
, PROGRESS_STATUS_WEIGHT1
, PROGRESS_OVERRIDE1
, REMAINING_EFFORT1
, PERCENT_COMPLETE1
, PERCENT_OVERRIDE1
, TASK_WEIGHT1
, NUMBER_FIELD1
, ROLLUP_NODE1
, DIRTY_FLAG1
, START_DATE2
, FINISH_DATE2
, DURATION2
, PROGRESS_STATUS_WEIGHT2
, REMAINING_EFFORT2
, PERCENT_COMPLETE2
, TASK_WEIGHT2
, NUMBER_FIELD2
, ROLLUP_NODE2
, DIRTY_FLAG2
, START_DATE3
, FINISH_DATE3
, DURATION3
, PROGRESS_STATUS_WEIGHT3
, REMAINING_EFFORT3
, PERCENT_COMPLETE3
, TASK_WEIGHT3
, NUMBER_FIELD3
, ROLLUP_NODE3
, DIRTY_FLAG3
, START_DATE4
, FINISH_DATE4
, DURATION4
, PROGRESS_STATUS_WEIGHT4
, REMAINING_EFFORT4
, PERCENT_COMPLETE4
, TASK_WEIGHT4
, NUMBER_FIELD4
, ROLLUP_NODE4
, DIRTY_FLAG4
, START_DATE5
, FINISH_DATE5
, DURATION5
, PROGRESS_STATUS_WEIGHT5
, REMAINING_EFFORT5
, PERCENT_COMPLETE5
, TASK_WEIGHT5
, NUMBER_FIELD5
, ROLLUP_NODE5
, DIRTY_FLAG5
, START_DATE6
, FINISH_DATE6
, DURATION6
, PROGRESS_STATUS_WEIGHT6
, REMAINING_EFFORT6
, PERCENT_COMPLETE6
, TASK_WEIGHT6
, NUMBER_FIELD6
, ROLLUP_NODE6
, DIRTY_FLAG6
FROM PA.PA_SCHEDULE_OBJECTS;
PA.PA_SCHEDULE_OBJECTS does not reference any database object
PA.PA_SCHEDULE_OBJECTS is referenced by following:
|
|
|