PJO_PLANNING_ELEMENTS
This table is used to store the planning elements of a plan version.
Details
-
Schema: FUSION
-
Object owner: PJO
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
PJO_PLANNING_ELEMENTS_PK |
PLANNING_ELEMENT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PLANNING_ELEMENT_ID | NUMBER | 18 | Yes | PLANNING_ELEMENT_ID ***** | |
| FUNDING_SOURCE_ID | NUMBER | 18 | Funding Source Id for Award Budgets. | ||
| PERSON_TYPE_CODE | VARCHAR2 | 30 | Indicates the person type. | ||
| UNPLANNED_UOM_FLAG | VARCHAR2 | 1 | UNPLANNED_UOM_FLAG ***** | ||
| RATE_EXPENDITURE_TYPE | VARCHAR2 | 30 | Y indicates that planned effort is being held at task and resource level, N indicates that planned effort is being held at task level. | ||
| PLAN_VERSION_ID | NUMBER | 18 | Yes | PLAN_VERSION_ID ***** | |
| PROJECT_ID | NUMBER | 18 | Yes | The identifier of the project that the resource is assigned to | |
| TASK_ID | NUMBER | 18 | Yes | The identifier of the task that the resource is assigned to. This is set to 0 if the budget is entered at the project level | |
| RBS_ELEMENT_ID | NUMBER | 18 | Yes | Indicates the resource breakdown structure element id. | |
| RATE_BASED_FLAG | VARCHAR2 | 1 | Indicates whether transactional is rate based | ||
| PLANNING_START_DATE | DATE | Indicates the planning start date. | |||
| PLANNING_END_DATE | DATE | Indicates the planning end date. | |||
| UNIT_OF_MEASURE | VARCHAR2 | 30 | The unit of measure of the resource. This is a denormalized column | ||
| SPREAD_CURVE_ID | NUMBER | 18 | Indicates the spread curve id. | ||
| PROJ_ELEMENT_VERSION_ID | NUMBER | Stores the task element version ID. This can be null for the budget and forecast related records. ***** | |||
| RA_TASK_DATES_SAME | VARCHAR2 | 1 | Yes | Indicates whether assignment duration is same as task duration. ***** | |
| ASSIGNMENT_DESCRIPTION | VARCHAR2 | 240 | It stores the description of the assignment. | ||
| SCHEDULED_DELAY | NUMBER | Scheduled delay for assignment | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| PM_PRODUCT_CODE | VARCHAR2 | 30 | The identifier of the external project management system from which the budget was imported | ||
| UNPLANNED_FLAG | VARCHAR2 | 1 | Yes | Indicates that the planning transaction was created by the system as a result of actual costs being incurred | |
| PM_RES_ASGN_REFERENCE | VARCHAR2 | 25 | The identifier of the planning transaction in the external project management system from which the planning transaction was imported. ***** | ||
| EVENT_TYPE_ID | NUMBER | 18 | EVENT_TYPE_ID ***** | ||
| SUPPLIER_ID | NUMBER | 18 | Indicates the vendor. | ||
| RES_TYPE_CODE | VARCHAR2 | 30 | Indicates the resource type code for the resource. | ||
| FC_RES_TYPE_CODE | VARCHAR2 | 30 | Indicates the financial resource category type code. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated 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. | ||
| PROGRESS_ETC_METHOD_CODE | VARCHAR2 | 30 | This is an existing column in this table. This column will be used to store the ETC method code of the resource in case of Financial Plan and it will be used to store Progress ETC Method code of the resource in case of Project Plan. Both ETC Method Code (in case of Financial Plan) and Progress ETC Method (in case of Project Plan) mean the same. But in UI they will be displayed with different labels. If it is Financial Plan the value in this column will be fetched and shown as ETC Method Code. If it is Project Plan the value in this column will be fetched and shown as Progress ETC Method Code. ***** | ||
| 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. | |
| OBJECT_ID1 | NUMBER | 18 | Yes | OBJECT_ID1 ***** | |
| OBJECT_CHILD_ID1 | NUMBER | 18 | OBJECT_CHILD_ID1 ***** | ||
| OBJECT_CHILD_ID2 | NUMBER | 18 | OBJECT_CHILD_ID2 ***** | ||
| OBJECT_CHILD_ID3 | NUMBER | 18 | OBJECT_CHILD_ID3 ***** | ||
| RESOURCE_CLASS_CODE | VARCHAR2 | 30 | Indicates the resource class code. | ||
| RESOURCE_CLASS_FLAG | VARCHAR2 | 1 | Indicates the resource is a resource class | ||
| TXN_ACCUM_HEADER_ID | NUMBER | 18 | Identifier for the transaction accum header used for RBS mapping | ||
| TRANSACTION_SOURCE_CODE | VARCHAR2 | 30 | Indicates the transaction source code. | ||
| SP_FIXED_DATE | DATE | Indicates the fixed date to be used when using a fixed date spread curve. | |||
| ETC_METHOD_CODE | VARCHAR2 | 30 | Indicates the estimate to complete method code. | ||
| ORGANIZATION_ID | NUMBER | 18 | Indicates the organization. | ||
| JOB_ID | NUMBER | 18 | Indicates the job. | ||
| PERSON_ID | NUMBER | 18 | Indicates the person. | ||
| EXPENDITURE_TYPE_ID | NUMBER | 18 | EXPENDITURE_TYPE_ID ***** | ||
| EXPENDITURE_CATEGORY_ID | NUMBER | 18 | EXPENDITURE_CATEGORY_ID ***** | ||
| REVENUE_CATEGORY_ID | NUMBER | 18 | REVENUE_CATEGORY_ID ***** | ||
| PARENT_ELEMENT_ID | NUMBER | PARENT_ELEMENT_ID ***** | |||
| PROJECT_ROLE_ID | NUMBER | 18 | Indicates the project role. | ||
| PERSON_TYPE_ID | NUMBER | 18 | PERSON_TYPE_ID ***** | ||
| NON_LABOR_RESOURCE_ID | NUMBER | 18 | NON_LABOR_RESOURCE_ID ***** | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | Indicates the inventory item. | ||
| ITEM_CATEGORY_ID | NUMBER | 18 | Indicates the inventory category. | ||
| MFC_COST_TYPE_ID | NUMBER | 18 | Indicates the manufacturing source code. | ||
| PROCURE_RESOURCE_FLAG | VARCHAR2 | 1 | Indicates whether this assignments allows a procured resource. | ||
| RATE_EXPENDITURE_TYPE_ID | NUMBER | 18 | RATE_EXPENDITURE_TYPE_ID ***** | ||
| RATE_EXP_FUNC_CURR_CODE | VARCHAR2 | 30 | Indicates rate expenditure functional currency | ||
| RATE_EXPENDITURE_ORG_ID | NUMBER | 18 | Indicates rate expenditure organization | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE21 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE22 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE23 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE24 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE25 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE26 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE27 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE28 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE29 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE30 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| PROCESS_FLAG | VARCHAR2 | 1 | A flag to indicate whether or not to process the planing element. | ||
| ADDL_ATTRIBUTE_NUM_1 | NUMBER | Oracle internal use only. | |||
| ADDL_ATTRIBUTE_NUM_2 | NUMBER | Oracle internal use only. | |||
| ADDL_ATTRIBUTE_NUM_3 | NUMBER | Oracle internal use only. | |||
| ADDL_ATTRIBUTE_NUM_4 | NUMBER | Oracle internal use only. | |||
| ADDL_ATTRIBUTE_NUM_5 | NUMBER | Oracle internal use only. | |||
| ADDL_ATTRIBUTE_NUM_6 | NUMBER | Oracle internal use only. | |||
| ADDL_ATTRIBUTE_NUM_7 | NUMBER | Oracle internal use only. | |||
| ADDL_ATTRIBUTE_NUM_8 | NUMBER | Oracle internal use only. | |||
| ADDL_ATTRIBUTE_NUM_9 | NUMBER | Oracle internal use only. | |||
| ADDL_ATTRIBUTE_NUM_10 | NUMBER | Oracle internal use only. | |||
| ADDL_ATTRIBUTE_VAR_1 | VARCHAR2 | 30 | Oracle internal use only. | ||
| ADDL_ATTRIBUTE_VAR_2 | VARCHAR2 | 30 | Oracle internal use only. | ||
| ADDL_ATTRIBUTE_VAR_3 | VARCHAR2 | 30 | Oracle internal use only. | ||
| ADDL_ATTRIBUTE_VAR_4 | VARCHAR2 | 80 | Oracle internal use only. | ||
| ADDL_ATTRIBUTE_VAR_5 | VARCHAR2 | 80 | Oracle internal use only. | ||
| ADDL_ATTRIBUTE_VAR_6 | VARCHAR2 | 80 | Oracle internal use only. | ||
| ADDL_ATTRIBUTE_VAR_7 | VARCHAR2 | 240 | Oracle internal use only. | ||
| ADDL_ATTRIBUTE_VAR_8 | VARCHAR2 | 240 | Oracle internal use only. | ||
| ADDL_ATTRIBUTE_VAR_9 | VARCHAR2 | 240 | Oracle internal use only. | ||
| ADDL_ATTRIBUTE_VAR_10 | VARCHAR2 | 240 | Oracle internal use only. | ||
| ADDL_ATTRIBUTE_DATE_1 | DATE | Oracle internal use only. | |||
| ADDL_ATTRIBUTE_DATE_2 | DATE | Oracle internal use only. | |||
| ADDL_ATTRIBUTE_DATE_3 | DATE | Oracle internal use only. | |||
| ADDL_ATTRIBUTE_DATE_4 | DATE | Oracle internal use only. | |||
| ADDL_ATTRIBUTE_DATE_5 | DATE | Oracle internal use only. | |||
| CHANGE_DOCUMENT_ID | NUMBER | 18 | Identifier of the change document. | ||
| CHANGE_IMPACT_ID | NUMBER | 18 | Identifier of the change impact. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| PJO_PLANNING_ELEMENTS | pjo_plan_versions_b | PLAN_VERSION_ID |
| PJO_PLANNING_ELEMENTS | pjf_projects_all_b | PROJECT_ID |
| PJO_PLANNING_ELEMENTS | pjf_proj_elements_b | TASK_ID |
| PJO_PLANNING_ELEMENTS | pjf_rbs_elements | RBS_ELEMENT_ID |
| pjo_plan_line_details | pjo_planning_elements | PLANNING_ELEMENT_ID |
| pjo_plan_lines | pjo_planning_elements | PLANNING_ELEMENT_ID |
| pjo_periodic_xface | pjo_planning_elements | PLANNING_ELEMENT_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJO_PLANNING_ELEMENTS_N1 | Non Unique | FUSION_TS_TX_DATA | PLAN_VERSION_ID, TASK_ID, RBS_ELEMENT_ID, FUNDING_SOURCE_ID, CHANGE_DOCUMENT_ID, CHANGE_IMPACT_ID |
| PJO_PLANNING_ELEMENTS_N2 | Non Unique | Default | PERSON_ID |
| PJO_PLANNING_ELEMENTS_N3 | Non Unique | Default | LAST_UPDATE_DATE |
| PJO_PLANNING_ELEMENTS_N4 | Non Unique | Default | TASK_ID |
| PJO_PLANNING_ELEMENTS_N5 | Non Unique | Default | RBS_ELEMENT_ID |
| PJO_PLANNING_ELEMENTS_U1 | Unique | Default | PLANNING_ELEMENT_ID |