Search Results per_abs_attendance_reasons

Overview

The PER_ABS_ATTENDANCE_REASONS table is a core data dictionary table within the Oracle E-Business Suite Human Resources (HR) module. It functions as a master reference table that defines and stores the valid, user-defined reasons for employee absences. Its primary role is to provide a controlled list of reason codes that can be associated with specific absence types, enabling detailed tracking, reporting, and analysis of workforce attendance patterns. This table is essential for maintaining data integrity in the Absence Management functionality, ensuring that all recorded absences are categorized with a pre-defined and approved reason linked to a broader absence category.

Key Information Stored

The table's structure is designed to enforce uniqueness and maintain relationships with other HR entities. The key columns include:

• ABS_ATTENDANCE_REASON_ID: The unique primary key identifier (PK) for each absence reason record.
• NAME: The descriptive name of the absence reason (e.g., "Medical Appointment," "Family Emergency," "Training"). This column, combined with ABSENCE_ATTENDANCE_TYPE_ID, forms a unique key (UK2).
• ABSENCE_ATTENDANCE_TYPE_ID: A foreign key linking the reason to its parent category in the PER_ABSENCE_ATTENDANCE_TYPES table (e.g., "Sick Leave," "Vacation").
• BUSINESS_GROUP_ID: A foreign key to HR_ALL_ORGANIZATION_UNITS, scoping the reason to a specific business group for multi-organization implementations.

Common Use Cases and Queries

This table is central to configuring the absence entry user interface and generating attendance reports. Administrators use it to set up the list of reasons available for selection when an absence is recorded. A common reporting query involves joining this table to absence transaction records to analyze trends by reason. For example, to list all absence reasons for a specific type within a business group:

SELECT name
FROM per_abs_attendance_reasons
WHERE absence_attendance_type_id = (SELECT absence_attendance_type_id FROM per_absence_attendance_types WHERE name = 'Sick Leave')
AND business_group_id = &business_group
ORDER BY name;

Another critical use case is data validation, ensuring that transactional records in PER_ABSENCE_ATTENDANCES reference a valid reason ID present in this master table.

Related Objects

PER_ABS_ATTENDANCE_REASONS sits within a key relationship hierarchy in HR Absence Management:

• PER_ABSENCE_ATTENDANCE_TYPES: The parent table, referenced via the ABSENCE_ATTENDANCE_TYPE_ID foreign key. A type contains multiple reasons.
• PER_ABSENCE_ATTENDANCES: The primary transactional table, which holds individual absence entries. It references PER_ABS_ATTENDANCE_REASONS via the ABS_ATTENDANCE_REASON_ID foreign key.
• HR_ALL_ORGANIZATION_UNITS: Referenced via BUSINESS_GROUP_ID to enforce security and data partitioning by business group.

Direct manipulation of this table is typically performed via the application's administrative forms or dedicated APIs; updates via SQL should be approached with extreme caution to maintain application integrity.