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

TABLE: PA.PA_EARNED_VALUES

Object Details
Object Name: PA_EARNED_VALUES
Object Type: TABLE
Owner: PA
FND Design Data: TablePA.PA_EARNED_VALUES
Subobject Name:
Status: VALID


PA_EARNED_VALUES stores earned value history for lowest-level tasks
and resources at a point in time that the users determine.
This table is primarily maintained by external project
management tools using the Oracle Projects Activity Management
Gateway.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PA_EARNED_VALUES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROJECT_ID
ColumnTASK_ID
ColumnRESOURCE_LIST_MEMBER_ID
ColumnAS_OF_DATE
Columns
Name Datatype Length Mandatory Comments
PROJECT_ID NUMBER
Yes The project identifier
TASK_ID NUMBER
Yes The task identifier
RESOURCE_LIST_MEMBER_ID NUMBER
Yes The resource list member identifier
AS_OF_DATE DATE
Yes The date on which the earned values are computed
CURRENT_FLAG VARCHAR2 (1) Yes A flag that indicates whether the earned values are current or not
BCWS NUMBER

Budgeted Cost of Work Scheduled
ACWP NUMBER

Actual Cost of Work Performed
BCWP NUMBER

Budgeted Cost of Work Performed
BAC NUMBER

Budgeted Actual Cost
BCWS_ITD NUMBER

Budgeted Cost of Worked Scheduled; Inception-to-Date
ACWP_ITD NUMBER

Actual Cost of Work Performed, Inception-to-Date
BCWP_ITD NUMBER

Budgeted Cost of Work Performed, Inception-to-Date
BAC_ITD NUMBER

Budgeted Actual Cost, Inception-to-Date
BQWS NUMBER

Budgeted Quantity of Work Scheduled
AQWP NUMBER

Actual Quantity of Work Performed
BQWP NUMBER

Budgeted Quantity of Work Performed
BAQ NUMBER

Budgeted Actual Quantity
BQWS_ITD NUMBER

Budgeted Quantity of Worked Scheduled, Inception-to-Date
AQWP_ITD NUMBER

Actual Quantity of Work Performed, Inception-to-Date
BQWP_ITD NUMBER

Budgeted Quantity of Work Performed, Inception-to-Date
BAQ_ITD NUMBER

Budgeted Actual Quantity,Inception-to-Date
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER
Yes Standard Who Column
CREATION_DATE DATE
Yes Standard Who Column
CREATED_BY NUMBER
Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER
Yes Standard Who Column
Query Text

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


SELECT PROJECT_ID
,      TASK_ID
,      RESOURCE_LIST_MEMBER_ID
,      AS_OF_DATE
,      CURRENT_FLAG
,      BCWS
,      ACWP
,      BCWP
,      BAC
,      BCWS_ITD
,      ACWP_ITD
,      BCWP_ITD
,      BAC_ITD
,      BQWS
,      AQWP
,      BQWP
,      BAQ
,      BQWS_ITD
,      AQWP_ITD
,      BQWP_ITD
,      BAQ_ITD
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM PA.PA_EARNED_VALUES;

Dependencies

[top of page]

PA.PA_EARNED_VALUES does not reference any database object

PA.PA_EARNED_VALUES is referenced by following:

SchemaPA
ViewPA_EARNED_VALUES#