PJO_PROJECT_PROGRESS
Progress related information for a Project are captured in this table
Details
-
Schema: FUSION
-
Object owner: PJO
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
Name | Columns |
---|---|
PJO_PROJECT_PROGRESS_PK |
PROJECT_PROGRESS_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
---|---|---|---|---|---|---|
PROJECT_PROGRESS_ID | NUMBER | 18 | Yes | PROJECT_PROGRESS_ID ***** | ||
PROJECT_ID | NUMBER | 18 | Yes | PROJECT_ID ***** | ||
STRUCTURE_TYPE | VARCHAR2 | 30 | Yes | STRUCTURE_TYPE ***** | ||
STRUCTURE_VERSION_ID | NUMBER | 18 | Yes | STRUCTURE_VERSION_ID ***** | ||
PROJ_ELEMENT_ID | NUMBER | 18 | Yes | PROJ_ELEMENT_ID ***** | ||
ELEMENT_VERSION_ID | NUMBER | 18 | Yes | ELEMENT_VERSION_ID ***** | ||
AS_OF_DATE | DATE | Yes | AS_OF_DATE ***** | |||
OBJECT_TYPE | VARCHAR2 | 150 | Yes | OBJECT_TYPE ***** | ||
OBJECT_ID | NUMBER | 18 | Yes | OBJECT_ID ***** | ||
PLAN_VERSION_ID | NUMBER | 18 | PLAN_VERSION_ID ***** | |||
CURRENT_FLAG | VARCHAR2 | 1 | Yes | CURRENT_FLAG ***** | ||
PUBLISHED_FLAG | VARCHAR2 | 1 | Yes | PUBLISHED_FLAG ***** | ||
ACTUALS_THRU_PERIOD | VARCHAR2 | 30 | ACTUALS_THRU_PERIOD ***** | |||
SUMMARIZATION_DATE | DATE | SUMMARIZATION_DATE ***** | ||||
PROGRESS_PERIOD | VARCHAR2 | 30 | Yes | PROGRESS_PERIOD ***** | ||
PERCENT_COMP_CALC_METHOD | VARCHAR2 | 30 | PERCENT_COMP_CALC_METHOD ***** | |||
ETC_CALC_METHOD | VARCHAR2 | 30 | ETC_CALC_METHOD ***** | |||
PERCENT_COMPLETE | NUMBER | 14 | PERCENT_COMPLETE ***** | |||
ORIGINAL_PERCENT_COMPLETE | NUMBER | 14 | ORIGINAL_PERCENT_COMPLETE ***** | |||
ESTIMATED_START_DATE | DATE | ESTIMATED_START_DATE ***** | ||||
ESTIMATED_FINISH_DATE | DATE | ESTIMATED_FINISH_DATE ***** | ||||
ACTUAL_START_DATE | DATE | ACTUAL_START_DATE ***** | ||||
ACTUAL_FINISH_DATE | DATE | ACTUAL_FINISH_DATE ***** | ||||
PROGRESS_STATUS_CODE | VARCHAR2 | 30 | PROGRESS_STATUS_CODE ***** | |||
PROGRESS_STATUS_WEIGHT | NUMBER | 18 | PROGRESS_STATUS_WEIGHT ***** | |||
UNIT_OF_MEASURE | VARCHAR2 | 30 | UNIT_OF_MEASURE ***** | |||
UNPLANNED_UOM_FLAG | VARCHAR2 | 1 | UNPLANNED_UOM_FLAG ***** | |||
TRANSACTION_CURRENCY_CODE | VARCHAR2 | 30 | TRANSACTION_CURRENCY_CODE ***** | |||
TOTAL_PLAN_QUANTITY | NUMBER | TOTAL_PLAN_QUANTITY ***** | ||||
TOTAL_PLAN_EFFORT | NUMBER | TOTAL_PLAN_EFFORT ***** | ||||
TOTAL_PLAN_COST_TC | NUMBER | TOTAL_PLAN_COST_TC ***** | ||||
TOTAL_PLAN_COST_FC | NUMBER | TOTAL_PLAN_COST_FC ***** | ||||
TOTAL_PLAN_COST_PC | NUMBER | TOTAL_PLAN_COST_PC ***** | ||||
TOTAL_PLAN_RAW_COST_TC | NUMBER | TOTAL_PLAN_RAW_COST_TC ***** | ||||
TOTAL_PLAN_RAW_COST_FC | NUMBER | TOTAL_PLAN_RAW_COST_FC ***** | ||||
TOTAL_PLAN_RAW_COST_PC | NUMBER | TOTAL_PLAN_RAW_COST_PC ***** | ||||
BASELINE_PLAN_QUANTITY | NUMBER | BASELINE_PLAN_QUANTITY ***** | ||||
BASELINE_PLAN_EFFORT | NUMBER | BASELINE_PLAN_EFFORT ***** | ||||
BASELINE_PLAN_COST_TC | NUMBER | BASELINE_PLAN_COST_TC ***** | ||||
BASELINE_PLAN_COST_FC | NUMBER | BASELINE_PLAN_COST_FC ***** | ||||
BASELINE_PLAN_COST_PC | NUMBER | BASELINE_PLAN_COST_PC ***** | ||||
BASELINE_PLAN_RAW_COST_TC | NUMBER | BASELINE_PLAN_RAW_COST_TC ***** | ||||
BASELINE_PLAN_RAW_COST_FC | NUMBER | BASELINE_PLAN_RAW_COST_FC ***** | ||||
BASELINE_PLAN_RAW_COST_PC | NUMBER | BASELINE_PLAN_RAW_COST_PC ***** | ||||
ACTUAL_QUANTITY_THRU_PERIOD | NUMBER | ACTUAL_QUANTITY_THRU_PERIOD ***** | ||||
ACTUAL_EFFORT_THRU_PERIOD | NUMBER | ACTUAL_EFFORT_THRU_PERIOD ***** | ||||
ACTUAL_COST_THRU_PERIOD_TC | NUMBER | ACTUAL_COST_THRU_PERIOD_TC ***** | ||||
ACTUAL_COST_THRU_PERIOD_FC | NUMBER | ACTUAL_COST_THRU_PERIOD_FC ***** | ||||
ACTUAL_COST_THRU_PERIOD_PC | NUMBER | ACTUAL_COST_THRU_PERIOD_PC ***** | ||||
ACTUAL_RAW_COST_THRU_PRD_TC | NUMBER | ACTUAL_RAW_COST_THRU_PRD_TC ***** | ||||
ACTUAL_RAW_COST_THRU_PRD_FC | NUMBER | ACTUAL_RAW_COST_THRU_PRD_FC ***** | ||||
ACTUAL_RAW_COST_THRU_PRD_PC | NUMBER | ACTUAL_RAW_COST_THRU_PRD_PC ***** | ||||
RES_ACT_QTY_THRU_PRD | NUMBER | RES_ACT_QTY_THRU_PRD ***** | ||||
RES_ACT_EFF_THRU_PRD | NUMBER | RES_ACT_EFF_THRU_PRD ***** | ||||
RES_ACT_COST_THRU_PRD_FC | NUMBER | RES_ACT_COST_THRU_PRD_FC ***** | ||||
RES_ACT_COST_THRU_PRD_PC | NUMBER | RES_ACT_COST_THRU_PRD_PC ***** | ||||
RES_ACT_RAWCOST_THRU_PRD_FC | NUMBER | RES_ACT_RAWCOST_THRU_PRD_FC ***** | ||||
RES_ACT_RAWCOST_THRU_PRD_PC | NUMBER | RES_ACT_RAWCOST_THRU_PRD_PC ***** | ||||
ETC_QUANTITY | NUMBER | ETC_QUANTITY ***** | ||||
ETC_EFFORT | NUMBER | ETC_EFFORT ***** | ||||
ETC_COST_TC | NUMBER | ETC_COST_TC ***** | ||||
ETC_COST_FC | NUMBER | ETC_COST_FC ***** | ||||
ETC_COST_PC | NUMBER | ETC_COST_PC ***** | ||||
ETC_RAW_COST_TC | NUMBER | ETC_RAW_COST_TC ***** | ||||
ETC_RAW_COST_FC | NUMBER | ETC_RAW_COST_FC ***** | ||||
ETC_RAW_COST_PC | NUMBER | ETC_RAW_COST_PC ***** | ||||
RES_ETC_QUANTITY | NUMBER | RES_ETC_QUANTITY ***** | ||||
RES_ETC_EFFORT | NUMBER | RES_ETC_EFFORT ***** | ||||
RES_ETC_COST_FC | NUMBER | RES_ETC_COST_FC ***** | ||||
RES_ETC_COST_PC | NUMBER | RES_ETC_COST_PC ***** | ||||
RES_ETC_RAW_COST_FC | NUMBER | RES_ETC_RAW_COST_FC ***** | ||||
RES_ETC_RAW_COST_PC | NUMBER | RES_ETC_RAW_COST_PC ***** | ||||
EARNED_VALUE_COST_PC | NUMBER | EARNED_VALUE_COST_PC ***** | ||||
EARNED_VALUE_COST_FC | NUMBER | EARNED_VALUE_COST_FC ***** | ||||
EARNED_VALUE_EFFORT | NUMBER | EARNED_VALUE_EFFORT ***** | ||||
PRIOR_PROJECT_PROGRESS_ID | NUMBER | 18 | PRIOR_PROJECT_PROGRESS_ID ***** | |||
DATA_FLAG | VARCHAR2 | 1 | DATA_FLAG ***** | |||
ROLLUP_FLAG | VARCHAR2 | 1 | ROLLUP_FLAG ***** | |||
ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Project Progress (PJO_PROJECT_PROGRESS_DFF) | ||
ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Progress (PJO_PROJECT_PROGRESS_DFF) | ||
ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Progress (PJO_PROJECT_PROGRESS_DFF) | ||
ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Progress (PJO_PROJECT_PROGRESS_DFF) | ||
ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Progress (PJO_PROJECT_PROGRESS_DFF) | ||
ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Progress (PJO_PROJECT_PROGRESS_DFF) | ||
ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Progress (PJO_PROJECT_PROGRESS_DFF) | ||
ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Progress (PJO_PROJECT_PROGRESS_DFF) | ||
ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Progress (PJO_PROJECT_PROGRESS_DFF) | ||
ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Progress (PJO_PROJECT_PROGRESS_DFF) | ||
ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Progress (PJO_PROJECT_PROGRESS_DFF) | ||
ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Progress (PJO_PROJECT_PROGRESS_DFF) | ||
ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Progress (PJO_PROJECT_PROGRESS_DFF) | ||
ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Progress (PJO_PROJECT_PROGRESS_DFF) | ||
ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Progress (PJO_PROJECT_PROGRESS_DFF) | ||
ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Progress (PJO_PROJECT_PROGRESS_DFF) | ||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | ||
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |||
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | ||
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | ||
PM_SOURCE_CODE | VARCHAR2 | 30 | Source of the progress record. For example, OPEN_INTERFACE. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
PJO_PROJECT_PROGRESS | pjf_projects_all_b | PROJECT_ID |
PJO_PROJECT_PROGRESS | pjf_proj_elements_b | PROJ_ELEMENT_ID |
PJO_PROJECT_PROGRESS | pjf_proj_element_version | ELEMENT_VERSION_ID |
PJO_PROJECT_PROGRESS | pjo_plan_versions_b | PLAN_VERSION_ID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
PJO_PROJECT_PROGRESS_N1 | Non Unique | APPS_TS_TX_DATA | PROJECT_ID, PUBLISHED_FLAG, CURRENT_FLAG |
PJO_PROJECT_PROGRESS_N2 | Non Unique | APPS_TS_TX_DATA | PROJECT_ID, AS_OF_DATE |
PJO_PROJECT_PROGRESS_U1 | Unique | Default | PROJECT_PROGRESS_ID |
PJO_PROJECT_PROGRESS_U2 | Unique | APPS_TS_TX_DATA | PROJECT_ID, PROJ_ELEMENT_ID, OBJECT_ID, AS_OF_DATE |
PJO_PROJECT_PROGRESS_U3 | Unique | APPS_TS_TX_DATA | PRIOR_PROJECT_PROGRESS_ID |