Search Results pay_report_categories_pk

Overview

HR.PAY_REPORT_CATEGORIES is a reference and definition table within the Oracle E-Business Suite Payroll (PAY) module, owned by the HR schema and registered under FND Design Data as PAY.PAY_REPORT_CATEGORIES. The table stores the definitions used for report formatting within Oracle Payroll, allowing categories of payroll reports to be grouped, named, and classified for downstream reporting purposes. It resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10, and its primary access path is the unique index PAY_REPORT_CATEGORIES_PK in the APPS_TS_TX_IDX tablespace.

From a Data Vault modeling perspective, the heuristic classification for this object is standalone. This suggests the table functions primarily as a reference and definition entity rather than participating in a rich web of transactional or historical relationships. While it holds an internal foreign key to PAY_REPORT_GROUPS via REPORT_GROUP_ID, the classification indicates it is best treated as a standalone reference/dimension object in an analytical model, with the REPORT_CATEGORY_ID serving as the natural hub-style identifier.

Key Information Stored

The table contains 13 documented columns. The most significant are:

• REPORT_CATEGORY_ID (NUMBER, 15) — The surrogate primary key of the table, uniquely identifying each report category. This is the value most commonly searched for as "report_category_id."
• REPORT_GROUP_ID (NUMBER, 15) — Foreign key linking the category to its parent report group in PAY_REPORT_GROUPS, establishing the grouping hierarchy.
• CATEGORY_NAME (VARCHAR2, 80) — The descriptive name of the report category.
• SHORT_NAME (VARCHAR2, 30) — An abbreviated identifier for the category, useful for compact display in lists and reports.
• LEGISLATION_CODE (VARCHAR2) — Identifies the legislation (country/region) under which the category applies, supporting localization of payroll reporting.
• BUSINESS_GROUP_ID (NUMBER, 15) — The business group that owns the category, enabling multi-organization partitioning.
• OBJECT_VERSION_NUMBER (NUMBER) — Used for optimistic locking and concurrency control in the Oracle EBS framework.
• LAST_UPDATED_BY, LAST_UPDATE_DATE, CREATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN — The standard WHO audit columns capturing creation and modification metadata.
• ZD_EDITION_NAME — The editioning column present in the 12.2.2 physical schema, supporting Oracle's Edition-Based Redefinition (EBR) model. The unique index PAY_REPORT_CATEGORIES_PK is documented on (REPORT_CATEGORY_ID, ZD_EDITION_NAME), reflecting this editioning-aware business key.

As a matter of business-key candidate analysis, REPORT_CATEGORY_ID remains the surrogate primary key, while the editioning-aware combination of REPORT_CATEGORY_ID and ZD_EDITION_NAME serves as the effective uniqueness constraint in the 12.2.2 schema.

Common Use Cases and Queries

Typical usage involves retrieving report categories for a given business group or legislation, or resolving a category from its ID. A standard lookup by the searched term is:

• SELECT REPORT_CATEGORY_ID, CATEGORY_NAME, SHORT_NAME, LEGISLATION_CODE FROM HR.PAY_REPORT_CATEGORIES WHERE REPORT_CATEGORY_ID = :p_category_id;
• Listing categories for a group: SELECT * FROM HR.PAY_REPORT_CATEGORIES WHERE REPORT_GROUP_ID = :p_group_id ORDER BY CATEGORY_NAME;
• Filtering by localization: SELECT * FROM HR.PAY_REPORT_CATEGORIES WHERE LEGISLATION_CODE = :p_leg AND BUSINESS_GROUP_ID = :p_bg;

Reporting use cases include building pick lists for report selection, joining categories to their components to enumerate report structure, and auditing category definitions across business groups.

Related Objects

• HR.PAY_REPORT_GROUPS — Parent table; joined via PAY_REPORT_CATEGORIES.REPORT_GROUP_ID = PAY_REPORT_GROUPS.REPORT_GROUP_ID.
• HR.PAY_REPORT_CATEGORY_COMPONENTS — Child table referencing this table via REPORT_CATEGORY_ID; enumerates the components that make up each category.
• APPS.PAY_REPORT_CATEGORIES — The APPS synonym/view layer providing the standard application access point.
• APPS.PAY_REPORT_CATEGORIES_WHO — The WHO audit view exposing creation and update metadata for the table.
• PUBLIC.PAY_REPORT_CATEGORIES — Public synonym exposing the table outside the APPS schema context.

These dependencies confirm that PAY_REPORT_CATEGORIES acts as a central reference node between report groups and report category components, and its primary key column REPORT_CATEGORY_ID is the most frequently referenced identifier.