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. | |||
| ACTUAL_OUTPUT_QUANTITY | NUMBER | Actual output quantity captured on the progress row. This is used in planning, progress capture, and reconciliation where physical output drives progress. |
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 |