Results for “per_absence_attendances_efc”

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

Overview

The table HR.PER_ABSENCE_ATTENDANCES_EFC is a specialized mirror of the core PER_ABSENCE_ATTENDANCES table in Oracle E-Business Suite, residing in the HR schema and belonging to the Oracle Human Resources (PER) product family. Its defining characteristic is that it is not populated by routine transactional absence entry; rather, it is populated by the EFC (Euro as Functional Currency) process. During the transition to the Euro as the functional currency in the affected localization, historical absence and attendance records required restatement. This table serves as the staging repository for those restated records, allowing the original PER_ABSENCE_ATTENDANCES rows to remain untouched while the EFC-converted values are written into a separate, controlled structure.

The object carries a heuristic Data Vault classification of satellite-leaning. In Data Vault modeling terms, the composite primary key of ABSENCE_ATTENDANCE_ID combined with EFC_ACTION_ID, and the presence of a single outbound foreign key, are consistent with a satellite structure attached to a parent hub (the absence attendance business entity) and a process hub (the EFC action). This classification is a modeling observation and not a physical constraint mandated by the schema.

Key Information Stored

The documented physical schema for release 12.2.2 records eight columns, of which the following are the most significant:

• ABSENCE_ATTENDANCE_ID — the identifier of the underlying absence/attendance record in the source table. Together with the EFC action it forms the composite primary key.
• EFC_ACTION_ID — foreign key to HR_EFC_ACTIONS, identifying the specific EFC process run that generated this restated row and providing the version/temporal context.
• ABS_INFORMATION7, ABS_INFORMATION8, ABS_INFORMATION9, ABS_INFORMATION11, ABS_INFORMATION13, ABS_INFORMATION15 — configurable descriptive flexfield holder columns inherited from the source absence table, used here to carry EFC-specific or restated attributes.

The unique index PER_ABSENCE_ATTENDANCES_EFC_PK, defined on (ABSENCE_ATTENDANCE_ID, EFC_ACTION_ID), is the documented business-key candidate and confirms that a given absence record may appear once per EFC action. It functions as the surrogate primary key that the user searched for under the name per_absence_attendances_efc_pk.

Common Use Cases and Queries

Typical usage centers on reconciling Euro-restated absence values against their originals and tracing which EFC run produced them.

• Identifying all absence records affected by a given EFC run: SELECT absence_attendance_id FROM hr.per_absence_attendances_efc WHERE efc_action_id = :action_id;
• Joining back to the source table for value comparison: SELECT e.absence_attendance_id, a.absence_attendance_id FROM hr.per_absence_attendances_efc e, hr.per_absence_attendances a WHERE e.absence_attendance_id = a.absence_attendance_id;
• Auditing the EFC process via the foreign key: joining HR_EFC_ACTIONS to retrieve run metadata and timestamps.
• Reporting on restated flexible-flexfield content held in the ABS_INFORMATION columns for compliance extracts.

Related Objects

• PER_ABSENCE_ATTENDANCES — the source table this object mirrors; join on ABSENCE_ATTENDANCE_ID.
• HR_EFC_ACTIONS — referenced via PER_ABSENCE_ATTENDANCES_EFC.EFC_ACTION_ID; supplies the EFC process definition and status.
• PER_ABSENCE_ATTENDANCE_TYPES — classifies the absence records referenced by the underlying identifier.
• PER_ALL_PEOPLE_F — the person assignment behind each absence; typically reached through the source table.
• The EFC concurrent programs that populate this table, which should be used to regenerate rows rather than manual DML.