Search Results per_establishment_attendances

Overview

The PER_ESTABLISHMENT_ATTENDANCES table is a core data object within the Oracle E-Business Suite (EBS) Human Resources (HR) module, specifically under the PER product family. It serves as the system of record for tracking an individual's academic history. Its primary role is to store a chronological record of the educational establishments—such as schools, colleges, or universities—that a person (employee, applicant, or contingent worker) is currently attending or has attended in the past. This table is fundamental for maintaining comprehensive personnel records, supporting qualification verification, and enabling reporting on workforce education and development.

Key Information Stored

The table's structure is designed to link a person, an establishment, and the relevant attendance period within a specific business group. The primary identifier is the ATTENDANCE_ID. Key columns include PERSON_ID, which links to the person (PER_ALL_PEOPLE_F), and ESTABLISHMENT_ID, which links to the PER_ESTABLISHMENTS table containing details about the educational institution. The attendance period is defined by ATTENDED_START_DATE, with an optional end date. The BUSINESS_GROUP_ID column enforces data security and partitioning at the business group level, linking to HR_ALL_ORGANIZATION_UNITS. The unique key constraint (PER_ESTABLISHMENT_ATTEND_UK) ensures a person cannot have duplicate attendance records for the same establishment starting on the same date.

Common Use Cases and Queries

This table is central to employee profile management and reporting. Common use cases include generating resumes, verifying qualifications during recruitment, and analyzing the educational background of the workforce. A typical query to retrieve a person's educational history would join to person and establishment tables:

• SELECT pea.attended_start_date, pea.attended_end_date, pe.establishment_name, pe.establishment_type FROM per_establishment_attendances pea, per_establishments pe WHERE pea.establishment_id = pe.establishment_id AND pea.person_id = :p_person_id ORDER BY pea.attended_start_date DESC;

For reporting, it is often joined with PER_QUALIFICATIONS to associate specific degrees or certifications obtained from the attended establishment. Data from this table is also critical for integrations with third-party background check services or internal learning management systems.

Related Objects

PER_ESTABLISHMENT_ATTENDANCES has integral relationships with several other HR objects. It is a parent table to PER_QUALIFICATIONS via the foreign key on ATTENDANCE_ID, meaning a qualification (like a degree) is linked to a specific period of attendance. It is a child table to PER_ESTABLISHMENTS (via ESTABLISHMENT_ID) and HR_ALL_ORGANIZATION_UNITS (via BUSINESS_GROUP_ID). Key APIs, such as the PER Person API, likely manipulate data in this table when creating or updating a person's education history. Views like PER_PEOPLE_V or other person summary views may incorporate data from this table for reporting purposes.