Oracle Fusion · Data dictionary
PJF_PROJ_ELEMENTS_B
ProjectsUsed in 57 subject areas102 reporting columns
Projects Foundation (PJF), base table, language-neutral data (paired with _TL labels and the _VL view).
Likely primary key: PROJ_ELEMENT_ID (inferred from Oracle naming conventions, verify against Tables & Views)
Joins (inferred from key columns): PROJ_ELEMENT_ID → PJF_PROJ_ELEMENTS_VL
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ALLOW_CROSS_CHARGE_FLAG | ● | Indicator (Y/N) for the allow cross charge. | |
| BASELINE_FINISH_DATE | ● | Baseline finish date. | |
| BASELINE_START_DATE | ● | Baseline start date. | |
| BILLABLE_FLAG | ● | Indicator (Y/N) for the billable. | |
| CAPITALIZABLE_FLAG | ● | Indicator (Y/N) for the capitalizable. | |
| CC_PROCESS_LABOR_FLAG | ● | Indicator (Y/N) for the cc process labor. | |
| CC_PROCESS_NL_FLAG | ● | Indicator (Y/N) for the cc process nl. | |
| CHARGEABLE_FLAG | ● | Indicator (Y/N) for the chargeable. | |
| CINT_ELIGIBLE_FLAG | ● | Indicator (Y/N) for the cint eligible. | |
| CREATED_BY | ● | User who created the row. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| CRITICAL_FLAG | ● | Indicator (Y/N) for the critical. | |
| DENORM_DISPLAY_SEQUENCE | ● | Denorm display sequence. | |
| DENORM_WBS_LEVEL | ● | Denorm wbs level. | |
| ELEMENT_NUMBER | ● | Element number. | |
| ELEMENT_TYPE | ● | Type of element. | |
| ETC_CALC_METHOD | ● | Etc calc method. | |
| GATE_FLAG | ● | Indicator (Y/N) for the gate. | |
| LAST_UPDATED_BY | ● | User who last updated the row. | |
| LAST_UPDATE_DATE | ● | Date and time the row was last updated (the incremental-extract key). | |
| LAST_UPDATE_LOGIN | ● | Session login of the user who last updated the row. | |
| LIMIT_TO_TXN_CONTROLS_FLAG | ● | Indicator (Y/N) for the limit to transaction controls. | |
| MILESTONE_FLAG | ● | Indicator (Y/N) for the milestone. | |
| NUMBER_ATTR01 | ● | Number attr01. | |
| NUMBER_ATTR02 | ● | Number attr02. | |
| NUMBER_ATTR03 | ● | Number attr03. | |
| NUMBER_ATTR04 | ● | Number attr04. | |
| NUMBER_ATTR05 | ● | Number attr05. | |
| NUMBER_ATTR06 | ● | Number attr06. | |
| NUMBER_ATTR07 | ● | Number attr07. | |
| NUMBER_ATTR08 | ● | Number attr08. | |
| NUMBER_ATTR09 | ● | Number attr09. | |
| NUMBER_ATTR10 | ● | Number attr10. | |
| PERCENT_COMP_CALC_METHOD | ● | Percent comp calc method. | |
| PLANNING_END_DATE | ● | Planning end date. | |
| PLANNING_START_DATE | ● | Planning start date. | |
| PM_SOURCE_CODE | ● | Code identifying the pm source. | |
| PM_SOURCE_REFERENCE | ● | Pm source reference. | |
| PROJ_ELEMENT_ID | PK? | ● | Identifier for the proj element. |
| RETIREMENT_COST_FLAG | ● | Indicator (Y/N) for the retirement cost. | |
| SERVICE_TYPE_CODE | ● | Code identifying the service type. | |
| STRUCTURE_TYPE | ● | Type of structure. | |
| TASK_CODE01_ID | ● | Identifier for the task code01. | |
| TASK_CODE02_ID | ● | Identifier for the task code02. | |
| TASK_CODE03_ID | ● | Identifier for the task code03. | |
| TASK_CODE04_ID | ● | Identifier for the task code04. | |
| TASK_CODE05_ID | ● | Identifier for the task code05. | |
| TASK_CODE06_ID | ● | Identifier for the task code06. | |
| TASK_CODE07_ID | ● | Identifier for the task code07. | |
| TASK_CODE08_ID | ● | Identifier for the task code08. | |
| TASK_CODE09_ID | ● | Identifier for the task code09. | |
| TASK_CODE10_ID | ● | Identifier for the task code10. | |
| TASK_CODE11_ID | ● | Identifier for the task code11. | |
| TASK_CODE12_ID | ● | Identifier for the task code12. | |
| TASK_CODE13_ID | ● | Identifier for the task code13. | |
| TASK_CODE14_ID | ● | Identifier for the task code14. | |
| TASK_CODE15_ID | ● | Identifier for the task code15. | |
| TASK_CODE16_ID | ● | Identifier for the task code16. | |
| TASK_CODE17_ID | ● | Identifier for the task code17. | |
| TASK_CODE18_ID | ● | Identifier for the task code18. | |
| TASK_CODE19_ID | ● | Identifier for the task code19. | |
| TASK_CODE20_ID | ● | Identifier for the task code20. | |
| TASK_CODE21_ID | ● | Identifier for the task code21. | |
| TASK_CODE22_ID | ● | Identifier for the task code22. | |
| TASK_CODE23_ID | ● | Identifier for the task code23. | |
| TASK_CODE24_ID | ● | Identifier for the task code24. | |
| TASK_CODE25_ID | ● | Identifier for the task code25. | |
| TASK_CODE26_ID | ● | Identifier for the task code26. | |
| TASK_CODE27_ID | ● | Identifier for the task code27. | |
| TASK_CODE28_ID | ● | Identifier for the task code28. | |
| TASK_CODE29_ID | ● | Identifier for the task code29. | |
| TASK_CODE30_ID | ● | Identifier for the task code30. | |
| TASK_CODE31_ID | ● | Identifier for the task code31. | |
| TASK_CODE32_ID | ● | Identifier for the task code32. | |
| TASK_CODE33_ID | ● | Identifier for the task code33. | |
| TASK_CODE34_ID | ● | Identifier for the task code34. | |
| TASK_CODE35_ID | ● | Identifier for the task code35. | |
| TASK_CODE36_ID | ● | Identifier for the task code36. | |
| TASK_CODE37_ID | ● | Identifier for the task code37. | |
| TASK_CODE38_ID | ● | Identifier for the task code38. | |
| TASK_CODE39_ID | ● | Identifier for the task code39. | |
| TASK_CODE40_ID | ● | Identifier for the task code40. | |
| TEXT_ATTR01 | ● | Text attr01. | |
| TEXT_ATTR02 | ● | Text attr02. | |
| TEXT_ATTR03 | ● | Text attr03. | |
| TEXT_ATTR04 | ● | Text attr04. | |
| TEXT_ATTR05 | ● | Text attr05. | |
| TEXT_ATTR06 | ● | Text attr06. | |
| TEXT_ATTR07 | ● | Text attr07. | |
| TEXT_ATTR08 | ● | Text attr08. | |
| TEXT_ATTR09 | ● | Text attr09. | |
| TEXT_ATTR10 | ● | Text attr10. | |
| TEXT_ATTR11 | ● | Text attr11. | |
| TEXT_ATTR12 | ● | Text attr12. | |
| TEXT_ATTR13 | ● | Text attr13. | |
| TEXT_ATTR14 | ● | Text attr14. | |
| TEXT_ATTR15 | ● | Text attr15. | |
| TEXT_ATTR16 | ● | Text attr16. | |
| TEXT_ATTR17 | ● | Text attr17. | |
| TEXT_ATTR18 | ● | Text attr18. | |
| TEXT_ATTR19 | ● | Text attr19. | |
| TEXT_ATTR20 | ● | Text attr20. |
Used by reports
No cataloged report reads from this table yet, it's part of the broader Fusion dictionary.
- ,
Where this surfaces in OTBI
The OTBI subject areas that expose this table. You can't join across them in OTBI, the owned conformed model joins them on shared keys.
- Budgetary Control - Transactions Real Time
- Costing - Cost Accounting Real Time
- Costing - Period Inventory Valuation Real Time
- Costing - Receipt Accounting Real Time
- Costing - Work Order Costs Real Time
- Distributed Order Orchestration - Fulfillment Lines Real Time
- Expenses - Employee Expense Overview Real Time
- Expenses - Expense Transactions Real Time
- Innovation Management - Product Proposals Real Time
- Installed Base - Customer Asset Real Time
- Inventory - Inventory Balance Real Time
- Inventory - Inventory Cycle Count Real Time
- Inventory - Inventory Supply Real Time
- Inventory - Inventory Transactions Real Time
- Inventory - Inventory Transfer Order Real Time
- Maintenance Management - Asset Real Time
- Maintenance Management - Material Usage Real Time
- Maintenance Management - Purchased Item Usage Real Time
- Maintenance Management - Resource Usage Real Time
- Maintenance Management - Work Order Performance Real Time
Need the extract + dbt staging for PJF_PROJ_ELEMENTS_B?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table