Results for “per_hu_absence_report_v”

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

Overview

The view APPS.PER_HU_ABSENCE_REPORT_V is a Human Resources reporting object that exposes the data set produced by the Hungarian absence reporting process in Oracle E-Business Suite Release 12.1.1 and 12.2.2. Its documented description is "Hungary Absence Report View," and it belongs to the PER (Human Resources) product family. The view is owned by the APPS schema and holds VALID status in the data dictionary.

The view does not compute absence balances itself. Instead, it projects values that the Hungarian absence report generator has already written into the generic action-information store during a payroll run. Its role is therefore to present a denormalized, report-ready result set drawn from payroll action and assignment action processing, so that reporting tools, concurrent programs, or downstream extracts can retrieve Hungarian holiday and absence entitlement data without having to reconstruct PAY_ACTION_INFORMATION segment assignments manually. For users searching on "reporting_year," this view is the correct access point: REPORTING_YEAR is exposed as a first-class column derived from ACTION_INFORMATION13.

Underlying Base Objects

The view is defined over three documented base objects, all referenced as synonyms in the APPS schema:

• PAY_ACTION_INFORMATION — aliased PAI, the source of every descriptive and numeric absence attribute. The view restricts this table with ACTION_INFORMATION_CATEGORY = 'HU_ABSENCE_REPORT' and ACTION_CONTEXT_TYPE = 'AAP'.
• PAY_ASSIGNMENT_ACTIONS — aliased PAA, joined by PAA.ASSIGNMENT_ACTION_ID = PAI.ACTION_CONTEXT_ID, supplying the assignment-level action context.
• PAY_PAYROLL_ACTIONS — aliased PPA, joined by PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID, supplying the payroll action identifier and generator request reference.

The join chain is strictly payroll action to assignment action to action information, anchored on the AAP context type. Only rows carrying the HU_ABSENCE_REPORT information category are returned, so the view is effectively a typed slice of the action-information table.

Key Columns

The view exposes twenty-one columns. The identifier columns are PAYROLL_ACTION_ID, GENERATOR_REQUEST_ID (from PPA.REQUEST_ID), and ASSIGNMENT_ACTION_ID. Personal and organizational attributes include COMPANY_NAME, FULL_NAME, ORGANIZATION, LOCATION, EMPLOYEE_NUMBER, BIRTH_DATE, JOB, HIRE_DATE, SUSPENDED_END_DATE, ISSUE_DATE, and PEOPLE_GROUP.

The absence entitlement columns carry the substantive business meaning:

• REPORTING_YEAR — the reporting year for the absence statement, mapped from ACTION_INFORMATION13.
• BASE_HOLIDAY — statutory base holiday entitlement.
• ADDITIONAL_HOLIDAY_CHILD_CARE — additional holiday granted for child care.
• OTHER_ADDITIONAL_HOLIDAY — other additional holiday allowances.
• PAID_HOLIDAY_CARRY_OVER — carried-over paid holiday.
• SICKNESS_HOLIDAY — sickness-related holiday entitlement.
• TOTAL_NORMAL_PAID_HOLIDAY — the aggregate normal paid holiday figure.

Common Use Cases and Queries

Typical scenarios include reproducing the Hungarian absence statement for a given reporting year, auditing entitlement balances by organization or location, and feeding statutory extracts.

SELECT employee_number, full_name, organization,
       reporting_year, base_holiday,
       total_normal_paid_holiday
FROM   apps.per_hu_absence_report_v
WHERE  reporting_year = :p_year
ORDER  BY organization, full_name;

SELECT reporting_year,
       SUM(total_normal_paid_holiday) total_holiday
FROM   apps.per_hu_absence_report_v
GROUP  BY reporting_year;

Because the view is read-only and populated during absence report generation, querying it returns only those employees and years already processed. It is not a source of real-time absence entry and should be filtered by REPORTING_YEAR and PAYROLL_ACTION_ID to isolate a specific generation run.