Search Results pji_rm_work_type_info




Overview
Explore in AI Chat

Overview

The table PJI_RM_WORK_TYPE_INFO is a core data object within the Project Intelligence (PJI) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. Its primary role is to store and manage reference information pertaining to work types, which are fundamental classifications for labor and effort within the Projects applications. As a repository for work type metadata, this table supports the analytical and reporting capabilities of the PJI module, enabling the aggregation, summarization, and intelligent analysis of project performance data across the enterprise. It functions as a dimension table within the PJI data model, providing descriptive context to transactional project facts.

Key Information Stored

Based on the provided metadata, the table's structure is centered around linking to the foundational Projects work type definition. The most critical column is WORK_TYPE_ID, which serves as the primary foreign key linking this PJI table to the source transactional table, PA_WORK_TYPES_B. While the specific descriptive columns within PJI_RM_WORK_TYPE_INFO are not detailed in the excerpt, such tables typically denormalize and store attributes from the source table for performance and historical tracking within the data warehouse environment of PJI. This likely includes work type names, codes, effective dates, and flags indicating billable or non-billable status, all optimized for reporting and analytics.

Common Use Cases and Queries

This table is predominantly accessed during the generation of project intelligence reports and dashboards. Common use cases include analyzing labor distribution and costs by work type, comparing planned versus actual effort across different classifications of work, and supporting chargeback reporting. A typical analytical query would join this table to fact tables like PJI_FP_PROJ_ER_F (forecast) or PJI_AC_PROJ_ER_F (actuals) to slice project data by work type. A fundamental query pattern is:

  • SELECT wti.WORK_TYPE_NAME, SUM(f.ACTUAL_EFFORT) FROM PJI_AC_PROJ_ER_F f, PJI_RM_WORK_TYPE_INFO wti WHERE f.WORK_TYPE_ID = wti.WORK_TYPE_ID GROUP BY wti.WORK_TYPE_NAME;

It is also critical during the ETL (Extract, Transform, Load) refresh processes of the PJI warehouse, where data from the source PA_WORK_TYPES_B table is synchronized into this reporting table.

Related Objects

The primary and most significant relationship for this table is its foreign key dependency on the Projects Foundation table. As documented:

  • PA_WORK_TYPES_B: This is the source transactional table. The column PJI_RM_WORK_TYPE_INFO.WORK_TYPE_ID references PA_WORK_TYPES_B.WORK_TYPE_ID, ensuring data integrity and traceability back to the operational system.

Furthermore, PJI_RM_WORK_TYPE_INFO will be referenced by numerous PJI fact and aggregate tables that store project performance metrics. These likely include, but are not limited to, tables such as PJI_FP_PROJ_ER_F (forecast), PJI_AC_PROJ_ER_F (actuals), and various summary (aggregate) tables where work type is a key dimension for roll-up.