Results for “per_establishment_attendances”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The PER_ESTABLISHMENT_ATTENDANCES table, owned by the HR schema within the Oracle E-Business Suite Human Resources (PER) product, stores a record of educational establishments that a person is currently attending or has previously attended. Each row captures an individual attendance event linking a person (or party) to a specific establishment, together with the period of attendance and related academic attributes. The table is a core component of the HRMS educational and qualifications tracking model introduced through the Oracle HRMS datamodel, supporting applicant and employee qualification records, education history reporting, and integration with recruitment and learning management flows.

From a Data Vault modeling perspective, the FK structure suggests that this table is satellite-leaning: it carries descriptive attributes describing the attendance relationship between a person/party and an establishment, while the durable identity of the relationship is captured by the surrogate ATTENDANCE_ID. The PERSON_ID and ESTABLISHMENT_ID components function as foreign references that would form the hub and link keys in a normalized vault design.

Key Information Stored

The table contains 37 documented columns in the 12.2.2 physical schema. The most significant include:

• ATTENDANCE_ID — Surrogate primary key (constraint PER_ESTABLISHMENT_ATTEND_PK), uniquely identifying each attendance record.
• PERSON_ID — Reference to the person or applicant to whom the attendance record belongs.
• PARTY_ID — Ties the attendance record to the underlying party model, enabling a consistent TCA integration.
• ESTABLISHMENT_ID — Foreign key to PER_ESTABLISHMENTS, identifying the educational institution.
• ESTABLISHMENT — Denormalized establishment name or descriptive text.
• BUSINESS_GROUP_ID — Foreign key to HR_ALL_ORGANIZATION_UNITS, scoping the record to the appropriate business group.
• ATTENDED_START_DATE and ATTENDED_END_DATE — Business-key components in the unique constraint PER_ESTABLISHMENT_ATTEND_UK (alongside PERSON_ID, ESTABLISHMENT_ID, BUSINESS_GROUP_ID), capturing the attendance period.
• FULL_TIME — Indicates whether the attendance was full-time or part-time.
• ADDRESS — Establishment address information used for reporting.
• OBJECT_VERSION_NUMBER — Optimistic locking column used by the Oracle Applications framework.
• Standard WHO columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE.
• Descriptive flexfield columns — ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE20.

Common Use Cases and Queries

This table is queried primarily for qualification assessment, applicant screening, education-history reporting, and downstream qualification records. A typical query lists all establishments attended by a person:

SELECT a.attendance_id, a.person_id, a.establishment_id, e.establishment, a.attended_start_date, a.attended_end_date, a.full_time FROM per_establishment_attendances a, per_establishments e WHERE a.establishment_id = e.establishment_id AND a.person_id = :p_person_id ORDER BY a.attended_start_date DESC;

HR specialists may also aggregate attendance counts by establishment or business group for workforce-education analytics, filter by current attendance (where ATTENDED_END_DATE IS NULL or exceeds SYSDATE), and join to PER_QUALIFICATIONS to retrieve the qualifications derived from a given attendance. Because the table is DATE-tracked (DateTrack) in the HRMS datamodel, queries should typically use the hr_api.get_effective_date or the appropriate effective-date view to obtain the current version of a record.

Related Objects

• PER_ESTABLISHMENTS — Referenced via ESTABLISHMENT_ID; holds institution details such as name, type, and location.
• HR_ALL_ORGANIZATION_UNITS — Referenced via BUSINESS_GROUP_ID; provides the business group scope.
• PER_QUALIFICATIONS — References this table via ATTENDANCE_ID; stores the qualifications earned from an attendance.
• PER_PEOPLE_F — Source of the PERSON_ID value; provides person biographical data.
• HZ_PARTIES — TCA party record linked through PARTY_ID.
• PER_ESTABLISHMENT_ATTENDANCES API layer — PL/SQL packages such as hr_establishment_attendance_api provide insert, update, and DateTrack operations for this entity.