Search Results per_contact_relationships

Overview

The PER_CONTACT_RELATIONSHIPS table is a core data repository within the Oracle E-Business Suite Human Resources (PER) module, specifically for versions 12.1.1 and 12.2.2. It serves as the central table for storing and managing an employee's personal contacts and their associated relationships. The table's primary role is to maintain structured information about individuals connected to an employee, such as dependents, beneficiaries, emergency contacts, and parents. This data is critical for downstream business processes in benefits administration, legal compliance, and internal reporting, forming a foundational link between an employee's personal network and the organization's HR systems.

Key Information Stored

The table's primary key is CONTACT_RELATIONSHIP_ID, which uniquely identifies each contact relationship record. As indicated by its foreign key constraints, a critical column is BUSINESS_GROUP_ID, which links the contact to the specific HR business group for security and data partitioning. While the full column list is not detailed in the provided metadata, based on its description and standard HRMS design, the table typically stores the PERSON_ID of the employee, the PERSON_ID or details of the contact person, and a RELATIONSHIP_TYPE (e.g., 'SPOUSE', 'CHILD', 'EMERGENCY_CONTACT'). It also commonly holds attributes like start and end dates for the relationship, primary contact flags, and dependency statuses required for benefits eligibility.

Common Use Cases and Queries

This table is directly queried for generating emergency contact lists, validating dependent eligibility for benefits enrollment, and producing census reports for insurance carriers. A typical reporting query involves joining PER_CONTACT_RELATIONSHIPS with the PER_ALL_PEOPLE_F table to retrieve employee and contact names for a specific relationship type. For example, to list all emergency contacts, a SQL pattern would be: SELECT papf.full_name employee_name, pcr.relationship_type, cp.full_name contact_name FROM per_contact_relationships pcr, per_all_people_f papf, per_all_people_f cp WHERE pcr.person_id = papf.person_id AND pcr.contact_person_id = cp.person_id AND pcr.relationship_type = 'EMERGENCY_CONTACT' AND SYSDATE BETWEEN papf.effective_start_date AND papf.effective_end_date. Data from this table is also essential for COBRA administration and benefits coverage life events.

Related Objects

PER_CONTACT_RELATIONSHIPS has integral relationships with several other EBS objects. It is referenced by key tables in the Benefits (BEN) module, such as BEN_COVERED_DEPENDENTS_F, which links dependents to specific benefit enrollments. Within the HR module, PER_CONTACT_EXTRA_INFO_F stores additional descriptive flexfield information for each contact relationship. For compliance, it is linked to PER_COBRA_COV_ENROLLMENTS and PER_COBRA_DEPENDENTS_F. The table's primary foreign key relationship to HR_ALL_ORGANIZATION_UNITS via BUSINESS_GROUP_ID enforces multi-org security. These dependencies underscore that PER_CONTACT_RELATIONSHIPS is not a standalone entity but a pivotal hub in a wider data model supporting HR and benefits functionality.