Search Results za_emp_eq_occupational_cat

Overview

APPS.PER_ZA_EMPLOYMENT_EQUITY_PKG is a South African localization package body in Oracle E-Business Suite (available in both 12.1.1 and 12.2.2) that loads and maintains data in the PER_ZA_EMPLOYMENT_EQUITY table for consumption by the South African Employment Equity reports. The Employment Equity (EE) reporting requirement obligates designated South African employers to classify their workforce by occupational category, occupational level, employment type, race, gender, and disability status, and to submit statutory returns reflecting these demographics. The package consolidates the extraction logic that reads human resources, payroll, and assignment data, derives the EE-relevant attributes, and stages the results in the reporting table.

Per its header ($Header: perzaeer.pkb 120.30.12010000.7), the package evolved substantially. The initial version (R. Kingham, May 2000) was later rewritten almost completely for 11i by F.D. Loubser (September 2001), followed by fixes for business group handling, multiple legal entities, QA defects, APPS-wide NOCOPY performance changes (11.5.9), and GSCC (generic schema conversion) warnings. The package is classified in ETRM as OTHER, indicating it is not a public API but an internal processing unit invoked by EE reporting components.

Key Procedures and Functions

The package exposes 25 documented procedures and functions. Principal data-population routines include POPULATE_EE_TABLE and POPULATE_EE_TABLE_EEWF, which assemble the EE extract rows; INS_G_ENC_DIFF_TABLE, which inserts encoded difference rows; and RESET_TABLES and RESET_HIGH_LOW_LISTS, which clear working state between runs.

Salary-related analysis is handled by CALC_HIGHEST_AND_LOWEST_AVG, GET_AVG_5_HIGHEST_SALARY, GET_AVG_5_LOWEST_SALARY, and GET_HIGHEST_AND_LOWEST. These derive the average of the five highest and five lowest salaries, a standard EE metric used to express occupational category pay differentials.

Attribute derivation is handled by GET_OCCUPATIONAL_CATEGORY, GET_OCCUPATIONAL_LEVEL, GET_OCCUPATIONAL_DATA, and CACHE_OCCUPATIONAL_LOCATION, which resolve the occupational classification relevant to the searched term za_emp_eq_occupational_cat. GET_EE_EMPLOYMENT_TYPE_NAME, GET_FUNCTIONAL_TYPE, and GET_FUNCTIONAL_DATA resolve employment type and functional classification. GET_ACTIVE_DAYS and GET_TERMINATION_REASON supply service and separation context, GET_LOOKUP_CODE provides reference lookup resolution, and CAT_LEV_DATA supports category/level structuring.

Tables Accessed

Employee and assignment data is sourced from PER_ALL_PEOPLE_F, PER_ALL_ASSIGNMENTS_F, PER_ASSIGNMENT_EXTRA_INFO, and PER_PERIODS_OF_SERVICE. Organizational context comes from HR_ALL_ORGANIZATION_UNITS. Payroll and compensation data is drawn from PAY_ALL_PAYROLLS_F, PAY_PAYROLL_ACTIONS, PAY_ASSIGNMENT_ACTIONS, PAY_ELEMENT_TYPES_F, PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_ENTRY_VALUES_F, PAY_INPUT_VALUES_F, PAY_RUN_RESULTS, PAY_BALANCE_TYPES, and PAY_BALANCE_FEEDS_F. All are referenced through APPS synonyms.

Usage Notes

The package is invoked through the South African Employment Equity reporting flow, typically from concurrent programs and report submission, and is referenced by three other packages in the ETRM inventory. Because it is classified OTHER rather than as a public API, direct custom calls should be avoided; customizations ordinarily consume the populated PER_ZA_EMPLOYMENT_EQUITY table after the standard EE report process completes.