Search Results per_absence_attendance_types

Overview

The PER_ABSENCE_ATTENDANCE_TYPES table is a core configuration object within the Oracle E-Business Suite Human Resources (HR) module, specifically for versions 12.1.1 and 12.2.2. It serves as the master repository for user-defined absence and attendance types. These types categorize and define the nature of employee time away from work, such as vacation, sick leave, jury duty, or training. The table's role is foundational; it provides the valid list of absence categories that can be recorded against an employee in the system, enabling consistent tracking, reporting, and integration with other HR and payroll processes.

Key Information Stored

The table stores the defining attributes for each absence category. Its structure, as indicated by the metadata, centers on a unique identifier and a name constrained within a business group. The primary columns include:

• ABSENCE_ATTENDANCE_TYPE_ID: The unique primary key identifier (PK) for the absence type.
• NAME: The user-defined name of the absence type (e.g., "Annual Leave").
• BUSINESS_GROUP_ID: A foreign key to HR_ALL_ORGANIZATION_UNITS, scoping the absence type to a specific business group, as part of a unique key constraint (UK2) with NAME.

While the provided excerpt does not list all columns, typical implementations would also include descriptive columns, enabled/disabled flags, and links to legislative or payroll rules, controlling how the absence is processed.

Common Use Cases and Queries

This table is central to absence management operations. Common use cases include generating lists of available absence types for data entry, validating absence entries, and creating absence analysis reports. A frequent reporting requirement is to list all configured absence types within a business group for audit or setup verification.

Sample SQL:
SELECT absence_attendance_type_id, name
FROM per_absence_attendance_types
WHERE business_group_id = &business_group
ORDER BY name;

Another critical use case involves joining this table to the transactional PER_ABSENCE_ATTENDANCES table to report on actual absences taken, categorized by type. For example, a query to summarize total occurrences or days by absence type for a given period would require this join on the ABSENCE_ATTENDANCE_TYPE_ID column.

Related Objects

As per the foreign key relationships documented, PER_ABSENCE_ATTENDANCE_TYPES is a referenced parent table for several key transactional and configuration objects:

• PER_ABSENCE_ATTENDANCES: The primary transactional table recording individual employee absence entries. Each attendance record must reference a valid type from this table.
• PER_ABS_ATTENDANCE_REASONS: Stores further detailed reason codes that can be associated with a broader absence type.
• PAY_NET_CALCULATION_RULES: Links absence types to specific payroll calculation rules, demonstrating the integration between HR absence tracking and payroll processing.
• HR_ALL_ORGANIZATION_UNITS: The parent table for the BUSINESS_GROUP_ID, enforcing multi-org security.

This network of relationships underscores the table's importance as a controlled code lookup that ensures data integrity across the absence management lifecycle.