Search Results pa_class_catgs_it




Overview
Explore in AI Chat

Overview

The PA_CLASS_CATGS_IT table is a core reference table within the Oracle E-Business Suite (EBS) Projects module (PA). It serves as the master repository for defining class categories, which are fundamental to the classification and segmentation of project data. Specifically, this table supports the Oracle Project Analysis Collection Pack, a component designed for advanced project analytics and reporting. Its primary role is to establish and maintain the valid list of classification types (categories) that can be subsequently populated with specific class codes. This structure provides a flexible framework for categorizing projects, tasks, expenditures, and other entities based on custom business attributes, enabling detailed analysis and reporting.

Key Information Stored

While the provided metadata does not list all columns, the documented primary key and foreign key relationships indicate the table's essential structure. The central column is CLASS_CATEGORY, which is the table's primary key. This column stores the unique identifier for a classification type, such as 'PROJECT TYPE', 'INDUSTRY SECTOR', or 'REGION'. The table likely contains additional descriptive columns, common in such setups, which may include fields for the category's name, description, enabled flag, and flexfield context information. The integrity of the data is enforced by the primary key constraint PA_CLASS_CATGS_IT_PK on the CLASS_CATEGORY column.

Common Use Cases and Queries

The primary use case is to query the list of active class categories available for assignment within project-related forms and reports. This table is frequently referenced in setups for Descriptive Flexfields (DFFs) and in analytical reporting to understand the classification dimensions in use. A common query involves joining this table with its child code table to retrieve a full list of categories and their associated valid values.

Sample Query:
SELECT cat.class_category, cat.description
FROM pa_class_catgs_it cat
WHERE NVL(cat.enabled_flag, 'Y') = 'Y'
ORDER BY 1;

Another typical pattern is its use in validation, ensuring that only categories defined in this master table can be used when assigning classification codes to projects or transactions within the Project Analysis Collection Pack processes.

Related Objects

The table has a direct, documented relationship with the PA_CLASS_CODES_IT table, which holds the specific valid values (codes) for each category.

  • Primary Key: PA_CLASS_CATGS_IT_PK on column CLASS_CATEGORY.
  • Foreign Key (Child Table): The PA_CLASS_CODES_IT table references this table via a foreign key. The column PA_CLASS_CODES_IT.CLASS_CATEGORY must contain a value present in PA_CLASS_CATGS_IT.CLASS_CATEGORY. This enforces referential integrity, ensuring that no class code can exist without a defined parent category.

This table is a foundational element for the classification flexfields within the Projects module, and its definitions are typically accessed via the Oracle EBS application forms for setting up project classifications rather than through direct data manipulation.