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.
Problems that run through this table