Search Results pqp_pension_types_pk

Overview

The PQP_PENSION_TYPES_F table is a core data structure within the Oracle E-Business Suite (EBS) Public Sector Payroll (PQP) module. It functions as the master repository for pension type definitions, which are critical for configuring and processing public sector pension plans. As a date-effective table, signified by the '_F' suffix and the presence of EFFECTIVE_START_DATE and EFFECTIVE_END_DATE columns, it supports the maintenance of historical, current, and future-dated pension type information. This enables organizations to manage changes to pension rules over time, ensuring accurate payroll calculations and compliance with evolving legislative requirements. Its role is foundational, as pension types defined here are referenced throughout the pension enrollment and contribution processes.

Key Information Stored

The table's primary purpose is to uniquely identify and date-track each pension type. The documented primary key structure, defined by the PQP_PENSION_TYPES_F_PK and PQP_PENSION_TYPES_PK constraints, highlights the essential columns for uniquely identifying a valid record. The key columns are:

• PENSION_TYPE_ID: The unique identifier for a specific pension type or plan.
• EFFECTIVE_START_DATE: The date from which the pension type definition becomes active.
• EFFECTIVE_END_DATE: The date after which the pension type definition is no longer active; a high value (e.g., 31-DEC-4712) indicates a currently active record.

While the provided metadata does not list all columns, typical supporting columns in such a table would include attributes like NAME, LEGISLATION_CODE, REPORTING_NAME, and descriptive flexfield columns for organization-specific extensions.

Common Use Cases and Queries

This table is primarily accessed for setup, maintenance, and reporting on pension plan options. A common operational use case is the creation or update of pension types via the EBS application interface, which inserts or updates records in this table. For reporting, a frequent requirement is to list all currently active pension types available for assignment to employees. The following sample query retrieves this information:

SELECT pension_type_id, name
FROM hr.pqp_pension_types_f
WHERE SYSDATE BETWEEN effective_start_date AND effective_end_date
ORDER BY name;

Another critical use case involves data validation and integration, where downstream interfaces or custom reports join to this table via PENSION_TYPE_ID to retrieve the descriptive name or validate that a referenced pension type is effective for a given payroll date.

Related Objects

As a master table for pension types, PQP_PENSION_TYPES_F is referenced by other transactional and setup tables within the PQP module. The documented primary key columns (PENSION_TYPE_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE) are the target for foreign key relationships from dependent tables. While specific foreign key constraints are not named in the provided metadata, common related objects in the Public Sector Payroll schema would logically include:

• PQP_PENSION_CONTRIBUTIONS_F: Likely holds contribution rates or rules linked to a specific PENSION_TYPE_ID.
• PQP_PENSION_ENROLLMENTS_F: Would store employee pension plan enrollments, referencing the PENSION_TYPE_ID to identify the chosen plan.
• PQP_PENSION_PLANS_F: May store detailed plan definitions that are associated with a high-level pension type.

Any join to these related tables would typically use the combination of PENSION_TYPE_ID and the relevant effective date to ensure correct versioning.