Results for “sickness_holiday”

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

Overview

PER_HU_EMPLOYMENT_CERT_V is a reporting view owned by the APPS schema within the Oracle E-Business Suite Human Resources (PER) product family. It is a Hungarian localization object, and its name follows the standard EBS convention of appending the country code (HU for Hungary) and a business-purpose suffix to the base entity. The view exists specifically to supply data to the Hungarian Employment Certificate Web ADI report (often referred to as the "Munkaigazolás" or employment history certificate), a statutory document that employers in Hungary must issue to departing employees summarizing the details of their employment.

Because the view is a single denormalized projection rather than a transactional entity, it does not store data of its own. Instead, it flattens Hungary-specific payroll action information out of the generic PAY_ACTION_INFORMATION storage model into human-readable, business-named columns. This makes the output directly consumable by the Web ADI (Web Applications Desktop Integrator) layout, which maps spreadsheet cells to view columns when generating the printable certificate. From a technical perspective the view is read-only and is intended for reporting and integration, not for data maintenance.

Underlying Base Objects

The ETRM metadata documents three referenced base objects, all exposed to APPS through synonyms:

• PAY_PAYROLL_ACTIONS (aliased PPA) — supplies the payroll action header keys, including PAYROLL_ACTION_ID and REQUEST_ID.
• PAY_ASSIGNMENT_ACTIONS (aliased PAA) — supplies assignment-level action identity, notably ASSIGNMENT_ACTION_ID, linking the payroll run to a specific assignment.
• PAY_ACTION_INFORMATION (aliased PAI1, PAI2, PAI3) — the core generic key-value store. Each alias represents a logical grouping: PAI1 for employer/location data, PAI2 for personal and pension data, and PAI3 for employee location data.

The join between these tables is driven by PAYROLL_ACTION_ID, REQUEST_ID, and ASSIGNMENT_ACTION_ID. Because PAY_ACTION_INFORMATION is an attribute-flexfield table, the Hungarian localization stores each certificate field in numbered ACTION_INFORMATION columns. The view resolves those numbered slots into meaningful names, which is the principal reason it exists.

Key Columns

The columns fall into three functional groups. Employer-related attributes include ORGANIZATION_ID, EMPLOYER_LOCATION_NAME, EMPLOYER_LOCATION_TYPE, EMPLOYER_STREET_NO, EMPLOYER_TOWN, EMPLOYER_COUNTY, EMPLOYER_POSTAL_CODE, and building/stairway/floor/door designators.

Personal and statutory data — directly relevant to the user's search term place_of_birth — includes PERSON_ID, COMPANY_NAME, FULL_NAME, MAIDEN_NAME, TAJ_CODE (the Hungarian social security identifier), PLACE_OF_BIRTH, DATE_OF_BIRTH, MOTHER_MAIDEN_NAME, HIRE_DATE, and TERMINATION_DATE. The view additionally exposes SICKNESS_HOLIDAY, RAILWAY_BENEFIT, pension fund details (entrance date, private and voluntary fund codes, names, addresses, and account numbers), and ISSUE_DATE. Employee location columns complete the projection.

Common Use Cases and Queries

Typical usage is the generation of the Hungarian Employment Certificate, but the view also supports payroll auditing, localization migration checks, and ad hoc reporting on Hungarian employees. A minimal query to retrieve place-of-birth and related personal data would resemble:

• SELECT PERSON_ID, FULL_NAME, PLACE_OF_BIRTH, DATE_OF_BIRTH, TAJ_CODE, HIRE_DATE, TERMINATION_DATE FROM APPS.PER_HU_EMPLOYMENT_CERT_V WHERE PLACE_OF_BIRTH IS NOT NULL;
• Filtering by PAYROLL_ACTION_ID or REQUEST_ID to reconcile a specific payroll run against the printed certificate.
• Joining PERSON_ID to PER_ALL_PEOPLE_F to validate the view output against the master person record.

As the view is effectively an attribute mapping over PAY_ACTION_INFORMATION, any missing certificate value generally indicates that the corresponding ACTION_INFORMATION slot was not populated for the action, rather than a defect in the view itself.