Oracle Fusion · Data dictionary
PJF_PROJECTS_ALL_VL
ProjectsUsed in 67 subject areas31 reporting columns
Projects Foundation (PJF) — view layer — joins the base table with translations for the current language.
Primary key: PROJECT_ID
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ALLOW_CROSS_CHARGE_FLAG | ● | Indicator (Y/N) for the allow cross charge. | |
| ASSET_ALLOCATION_METHOD | ● | Asset allocation method. | |
| CAPITAL_EVENT_PROCESSING | ● | Capital event processing. | |
| CC_PROCESS_LABOR_FLAG | ● | Indicator (Y/N) for the cc process labor. | |
| CC_PROCESS_NL_FLAG | ● | Indicator (Y/N) for the cc process nl. | |
| CINT_ELIGIBLE_FLAG | ● | Indicator (Y/N) for the cint eligible. | |
| CLIN_LINKED_CODE | ● | Code identifying the clin linked. | |
| CLOSED_DATE | ● | Closed date. | |
| COMPLETION_DATE | ● | Completion date. | |
| CREATED_BY | ● | User who created the row. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| DESCRIPTION | ● | Description. | |
| EXECUTION_CUSTOMER_NAME | ● | Name of the execution customer. | |
| EXTERNAL_PROJECT_ID | ● | Identifier for the external project. | |
| HOURS_PER_DAY | ● | Hours per day. | |
| LAST_UPDATED_BY | ● | User who last updated the row. | |
| LAST_UPDATE_DATE | ● | Date and time the row was last updated (the incremental-extract key). | |
| LIMIT_TO_TXN_CONTROLS_FLAG | ● | Indicator (Y/N) for the limit to transaction controls. | |
| NAME | ● | Name. | |
| PM_PRODUCT_CODE | ● | Code identifying the pm product. | |
| PM_PROJECT_REFERENCE | ● | Pm project reference. | |
| PRIORITY_CODE | ● | Code identifying the priority. | |
| PROJECT_CATEGORY | ● | Project category. | |
| PROJECT_CURRENCY_CODE | ● | Currency code for the project. | |
| PROJECT_ID | PK | ● | Identifier for the project. |
| PROJECT_STATUS_CODE | ● | Code identifying the project status. | |
| PROJFUNC_CURRENCY_CODE | ● | Currency code for the projfunc. | |
| SEGMENT1 | ● | Segment1. | |
| SERVICE_TYPE_CODE | ● | Code identifying the service type. | |
| START_DATE | ● | Start date. | |
| TEMPLATE_FLAG | ● | Indicator (Y/N) for the template. |
8 reports read from this table
Change a column here and these are the reports that move with it — the blast radius for any change to PJF_PROJECTS_ALL_VL.
- Project Listing Details Report
- Projects Asset Management Report
- Projects Budgets vs Actuals Report
- Projects CIP TIP Asset Detail Report
- Projects Exceptions Report
- Projects Global vs Local CER Report
- Projects Transactions Dashboard Report
- Quarterly CIP FA by Project Report
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
- Fixed Assets - Asset Source Lines 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
Need the extract + dbt staging for PJF_PROJECTS_ALL_VL?
We ship parameterized SQL, BICC config, and dbt models you own.