Search Results per_abs_attendance_types_vl




Overview
Explore in AI Chat

Overview

PER_ABS_ATTENDANCE_TYPES_VL is an APPS-owned, VALID database view within the PER (Human Resources) product family in Oracle EBS 12.1.1 and 12.2.2. It presents absence attendance type information in the language of the current user session. The "_VL" suffix denotes a "view with language," a standard Oracle EBS construct that joins the base transactional table to its translation table so that the descriptive name of each absence attendance type is returned in the session’s language rather than in a fixed language.

The view plays a central role in absence management reporting and integration. Absence attendance types define the categories of absence that employees can record, such as vacation, sickness, or other leave. Because the view resolves the translated name automatically via the USERENV('LANG') construct, consumers of the view—reporting tools, concurrent programs, APIs, and external integrations—receive a fully localized description without needing to perform their own joins to the translation table. This makes PER_ABS_ATTENDANCE_TYPES_VL the preferred access path for retrieving absence type definitions in the user’s language.

Underlying Base Objects

The view is defined over two referenced base objects, both exposed as synonyms in the APPS schema:

The view joins these two objects on ABSENCE_ATTENDANCE_TYPE_ID and restricts the translation rows to those matching the current session language, so that each absence type appears once with its name rendered in the appropriate language. The alias B refers to the base table and TL refers to the translation table within the view text, and the ROW_ID column is derived from the base table’s ROWID.

Key Columns

The view exposes a broad set of columns, of which the following are most significant:

Common Use Cases and Queries

The view is typically queried to enumerate the absence types available to a business group, to report on accrual direction, or to drive absence entry forms and integrations. A straightforward listing of absence types with their names and direction indicator might be written as:

SELECT absence_attendance_type_id, name, absence_category, hours_or_days, increasing_or_decreasing_flag, date_effective, date_end FROM per_abs_attendance_types_vl WHERE business_group_id = :p_business_group_id ORDER BY name;

Because the view automatically filters the translation table by USERENV('LANG'), queries against it return localized names with no additional join. Typical uses include validating that an absence type exists for a business group, determining whether an absence type increases or decreases a balance before processing an absence entry, and populating list-of-values or lookup selectors. Developers should note that the view is read-only and that the primary key is ABSENCE_ATTENDANCE_TYPE_ID; joins to absence records or accrual data should be performed on that identifier.