Search Results ben_popl_rptg_grp_f_pk




Overview
Explore in AI Chat

Overview

The BEN_POPL_RPTG_GRP_F table is a core data object within the Oracle E-Business Suite (EBS) Advanced Benefits (BEN) module, specifically in versions 12.1.1 and 12.2.2. It functions as a junction table that establishes the relationship between a population (such as employees eligible for a specific benefit program or plan) and a reporting group. This table enables the classification of participant populations for various reporting and analytical purposes, which is essential for compliance, plan administration, and management reporting. As a date-effective table (indicated by the '_F' suffix and the EFFECTIVE_START_DATE and EFFECTIVE_END_DATE columns in its primary key), it maintains a historical record of these associations, allowing for accurate tracking of changes over time.

Key Information Stored

The table's structure is designed to manage the lifecycle of the population-to-reporting-group assignment. The primary key is a composite of POPL_RPTG_GRP_ID, EFFECTIVE_START_DATE, and EFFECTIVE_END_DATE, which uniquely identifies each valid-dated record. The most critical foreign key column is RPTG_GRP_ID, which links to the BEN_RPTG_GRP table to identify the specific reporting group. While the provided metadata does not list all columns, a typical implementation would also include columns to identify the specific population (likely via a foreign key to a population definition table), creation and last update dates, and the associated business group for security and multi-organization support.

Common Use Cases and Queries

This table is primarily used in scenarios requiring reports on benefit plan participation segmented by custom reporting groups. For instance, an organization may need to report on all employees enrolled in a dental plan, broken down by geographic region or department codes defined as reporting groups. A common query pattern involves joining this table to the population definition and reporting group tables to extract a current snapshot of assignments.

Sample SQL Pattern:
SELECT prg.popl_rptg_grp_id,
prg.effective_start_date,
prg.effective_end_date,
rg.name reporting_group_name
FROM ben_popl_rptg_grp_f prg,
ben_rptg_grp rg
WHERE prg.rptg_grp_id = rg.rptg_grp_id
AND SYSDATE BETWEEN prg.effective_start_date AND prg.effective_end_date
AND [population criteria];

Related Objects

The table's integrity and functionality are defined by its relationships with other key Advanced Benefits tables. The primary documented relationship is a foreign key constraint where BEN_POPL_RPTG_GRP_F.RPTG_GRP_ID references the BEN_RPTG_GRP table. This ensures that every reporting group association points to a valid, defined reporting group. While not explicitly listed in the provided metadata, this table would also typically have a foreign key relationship to a population definition table (which may be named similarly to BEN_POPL_*) to identify the specific program or plan population. The table itself is referenced by its primary key constraint, BEN_POPL_RPTG_GRP_F_PK.