eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: PA.PA_PROJ_ELEM_VER_SCHEDULE

Object Details

Object Name:	PA_PROJ_ELEM_VER_SCHEDULE
Object Type:	TABLE
Owner:	PA
FND Design Data:	PA.PA_PROJ_ELEM_VER_SCHEDULE
Subobject Name:
Status:	VALID

PA_PROJ_ELEM_VER_SCHEDULE stores workplan attributes, which are versioned. - For future use

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_PROJ_ELEM_VER_SCHEDULE_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PEV_SCHEDULE_ID
PA_PROJ_ELEM_VER_SCHEDULE_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	ELEMENT_VERSION_ID
PA_PROJ_ELEM_VER_SCHEDULE_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ID ELEMENT_VERSION_ID
PA_PROJ_ELEM_VER_SCHEDULE_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ID MILESTONE_FLAG
PA_PROJ_ELEM_VER_SCHEDULE_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ID CRITICAL_FLAG

Columns

Name	Datatype	Length	Mandatory	Comments
PEV_SCHEDULE_ID	NUMBER	(15)	Yes	The unique identifier for the workplan version attributes
ELEMENT_VERSION_ID	NUMBER	(15)	Yes	The unique identifier for the element version
PROJECT_ID	NUMBER	(15)	Yes	The identifier of the project to which the workplan version attributes belong
PROJ_ELEMENT_ID	NUMBER	(15)	Yes	The identifier of the project element to which the structure version attributes belong
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
SCHEDULED_START_DATE	DATE			The scheduled start date of the workplan version
SCHEDULED_FINISH_DATE	DATE			The scheduled finish date of the workplan version
OBLIGATION_START_DATE	DATE			The obligation start date of the workplan version
OBLIGATION_FINISH_DATE	DATE			The obligation finish date of the workplan version
ACTUAL_START_DATE	DATE			The actual start date of the workplan version
ACTUAL_FINISH_DATE	DATE			The actual end date of the workplan version
ESTIMATED_START_DATE	DATE			The estimated start date of the workplan version
ESTIMATED_FINISH_DATE	DATE			The estimated finish date of the workplan version
DURATION	NUMBER	(15)		The duration between scheduled start date and scheduled end date using work calendar
EARLY_START_DATE	DATE			The early start date of the workplan version
EARLY_FINISH_DATE	DATE			The early finish date of the workplan version
LATE_START_DATE	DATE			The late start date of the workplan version
LATE_FINISH_DATE	DATE			The late finish date of the workplan version
CALENDAR_ID	NUMBER	(15)		The identifier of the work calendar used to schedule the task. This is a task-specific attribute.
MILESTONE_FLAG	VARCHAR2	(1)		Flag that indicates if the task version is a milestone. This is a task-specific attribute.
CRITICAL_FLAG	VARCHAR2	(1)		Flag that indicates if the task version is part of the critical path. This is a task-specific attribute.
RECORD_VERSION_NUMBER	NUMBER	(15)		Sequence number for lock strategy in self-service applications
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
WQ_PLANNED_QUANTITY	NUMBER	(17)		The Planned Work Quantity for the task.
PLANNED_EFFORT	NUMBER	(17)		The Planned Effort for the task.
ACTUAL_DURATION	NUMBER			Duration between the Actual Start and Finish Dates using the project work calendar.
ESTIMATED_DURATION	NUMBER			Duration between the Estimated Start and Finish Dates using the project work calendar.
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield context field
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
SCHEDULED_START_DATE_ROLLUP	NUMBER	(15)		Rollup difference for scheduled start date.
SCHEDULED_FINISH_DATE_ROLLUP	NUMBER	(15)		Rollup difference for scheduled finish date.
ESTIMATED_START_DATE_ROLLUP	NUMBER	(15)		Rollup difference for estimated start date.
ESTIMATED_FINISH_DATE_ROLLUP	NUMBER	(15)		Rollup difference for estimated finish date.
ACTUAL_START_DATE_ROLLUP	NUMBER	(15)		Rollup difference for actual start date.
ACTUAL_FINISH_DATE_ROLLUP	NUMBER	(15)		Rollup difference for actual finish date.
DEF_SCH_TOOL_TSK_TYPE_CODE	VARCHAR2	(30)		Default Scheduling Tool Task Type for the task version.
CONSTRAINT_TYPE_CODE	VARCHAR2	(30)		Constraint Type for the task version.
CONSTRAINT_DATE	DATE			Constraint Date for the task version.
FREE_SLACK	NUMBER	(15)		Free Slack for the task version.
TOTAL_SLACK	NUMBER	(15)		Total Slack for the task version.
EFFORT_DRIVEN_FLAG	VARCHAR2	(1)		Flag to determine if the task is effort driven.
LEVEL_ASSIGNMENTS_FLAG	VARCHAR2	(1)		Flag to determine if the assignments on this task should be leveled.
EXT_ACT_DURATION	NUMBER			The duration between the actual start date and actual finish date, using the work calendar from an external source (scheduling tool)
EXT_REMAIN_DURATION	NUMBER			The remaining duration until the actual finish date, using the work calendar from an external source (scheduling tool)
EXT_SCH_DURATION	NUMBER			The duration between the scheduled start date and scheduled finish date, using the work calendar from an external source (scheduling tool)
SOURCE_OBJECT_ID	NUMBER	(15)		Identifier of the object
SOURCE_OBJECT_TYPE	VARCHAR2	(30)		Type of the object

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PEV_SCHEDULE_ID
,      ELEMENT_VERSION_ID
,      PROJECT_ID
,      PROJ_ELEMENT_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      SCHEDULED_START_DATE
,      SCHEDULED_FINISH_DATE
,      OBLIGATION_START_DATE
,      OBLIGATION_FINISH_DATE
,      ACTUAL_START_DATE
,      ACTUAL_FINISH_DATE
,      ESTIMATED_START_DATE
,      ESTIMATED_FINISH_DATE
,      DURATION
,      EARLY_START_DATE
,      EARLY_FINISH_DATE
,      LATE_START_DATE
,      LATE_FINISH_DATE
,      CALENDAR_ID
,      MILESTONE_FLAG
,      CRITICAL_FLAG
,      RECORD_VERSION_NUMBER
,      LAST_UPDATE_LOGIN
,      WQ_PLANNED_QUANTITY
,      PLANNED_EFFORT
,      ACTUAL_DURATION
,      ESTIMATED_DURATION
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      SCHEDULED_START_DATE_ROLLUP
,      SCHEDULED_FINISH_DATE_ROLLUP
,      ESTIMATED_START_DATE_ROLLUP
,      ESTIMATED_FINISH_DATE_ROLLUP
,      ACTUAL_START_DATE_ROLLUP
,      ACTUAL_FINISH_DATE_ROLLUP
,      DEF_SCH_TOOL_TSK_TYPE_CODE
,      CONSTRAINT_TYPE_CODE
,      CONSTRAINT_DATE
,      FREE_SLACK
,      TOTAL_SLACK
,      EFFORT_DRIVEN_FLAG
,      LEVEL_ASSIGNMENTS_FLAG
,      EXT_ACT_DURATION
,      EXT_REMAIN_DURATION
,      EXT_SCH_DURATION
,      SOURCE_OBJECT_ID
,      SOURCE_OBJECT_TYPE
FROM PA.PA_PROJ_ELEM_VER_SCHEDULE;

Dependencies

[top of page]

PA.PA_PROJ_ELEM_VER_SCHEDULE does not reference any database object

PA.PA_PROJ_ELEM_VER_SCHEDULE is referenced by following:

PA: PA_PROJ_ELEM_VER_SCHEDULE#