Search Results per_elections_pk

Overview

The PER_ELECTIONS table is a core data object within the Oracle E-Business Suite Human Resources (PER) module, specifically for versions 12.1.1 and 12.2.2. As documented in the ETRM, its primary function is to hold election-related information. This table serves as the master repository for defining and managing formal organizational elections, such as those for employee representative bodies, unions, or other governance structures. It operates at the business group level, enabling enterprises to configure and track multiple distinct election processes. The table's integrity is enforced by the primary key PER_ELECTIONS_PK on the ELECTION_ID column, establishing it as the central reference point for all associated election data.

Key Information Stored

While the provided metadata does not list all columns, the documented foreign key relationships and primary key indicate the essential data elements stored. The ELECTION_ID column is the unique system-generated identifier for each election record. The BUSINESS_GROUP_ID column links the election to a specific HR business group, a fundamental organizational construct in Oracle HRMS, ensuring data security and partitioning. The REP_BODY_ID column, which also references the HR_ALL_ORGANIZATION_UNITS table, identifies the specific representative body (e.g., works council, union) for which the election is being conducted. Other typical columns not listed in the excerpt but commonly associated would include election name, description, status (e.g., Planned, In Progress, Closed), effective dates, and parameters defining the election period and rules.

Common Use Cases and Queries

This table is central to administering and reporting on organizational elections. A primary use case is the setup and lifecycle management of an election process from creation through to completion. Common reporting needs include listing all active elections within a business group or for a specific representative body. For instance, to retrieve basic election information, a query would join PER_ELECTIONS with HR_ALL_ORGANIZATION_UNITS to get the names of the business group and representative body.

SELECT pe.election_id, pe.election_name, bg.name business_group, rb.name rep_body_name
FROM per_elections pe,
     hr_all_organization_units bg,
     hr_all_organization_units rb
WHERE pe.business_group_id = bg.organization_id
AND pe.rep_body_id = rb.organization_id
AND pe.business_group_id = :p_bg_id
AND SYSDATE BETWEEN pe.date_from AND NVL(pe.date_to, SYSDATE);

Another critical use case involves generating voter rolls or candidate lists by leveraging its child tables, PER_ELECTION_CANDIDATES and PER_ELECTION_CONSTITUENCYS.

Related Objects

The PER_ELECTIONS table has defined relationships with several other key HR objects, as per the provided foreign key metadata:

• HR_ALL_ORGANIZATION_UNITS (via BUSINESS_GROUP_ID): This foreign key ties each election record to its governing business group, a master table for all organizational units.
• HR_ALL_ORGANIZATION_UNITS (via REP_BODY_ID): This foreign key identifies the specific representative organization (also stored as an organization unit) for which the election is held.
• PER_ELECTION_CANDIDATES (via ELECTION_ID): This is a critical child table that stores records for each candidate standing in a given election. The ELECTION_ID in this table references PER_ELECTIONS.ELECTION_ID.
• PER_ELECTION_CONSTITUENCYS (via ELECTION_ID): This child table defines the constituencies or voter groups (e.g., by department, location) associated with an election. The ELECTION_ID in this table references PER_ELECTIONS.ELECTION_ID.

These relationships form a hierarchical data model where PER_ELECTIONS is the parent entity for candidate and constituency information.