Search Results populate_ee_table

Overview

APPS.PER_ZA_EMPLOYMENT_EQUITY_PKG is a South African localization package that loads data into the PER_ZA_EMPLOYMENT_EQUITY table for use by the Employment Equity Reports. The Employment Equity report is a statutory submission required of designated employers under South African labour legislation, and the data extracted must reflect workforce composition, occupational categorisation, remuneration, and employment status across one or more legal entities. The package therefore acts as the extraction and staging engine that transforms transactional HRMS and payroll data into the shape required by the reporting layer.

A review of the modification history shows that the package began as a simple loader and was extended incrementally: additional Employment Equity Questionnaire functionality, multi–legal entity support, reusable functions, rewrites for the 11i architecture, the introduction of business_group_id on the user table, file checking, and an employment equity enhancement delivered against bug 5406242. The header revision 120.3.12010000.1 associates the source with the 12.1 code line, and the package remains registered in the 12.2.2 environment under the APPS schema with an API classification of OTHER.

Key Procedures and Functions

The package exposes 25 documented procedures and functions. They fall into several logical groups.

• Highest/lowest value maintenance: RESET_HIGH_LOW_LISTS clears the working lists of extreme values, GET_HIGHEST_AND_LOWEST accepts a value and maintains the list of the five highest and five lowest values supplied to it, and CALC_HIGHEST_AND_LOWEST_AVG returns the average of the five highest and five lowest values held in those lists. GET_AVG_5_HIGHEST_SALARY and GET_AVG_5_LOWEST_SALARY expose the same calculation specifically for salary reporting.
• Assignment and service data: GET_ACTIVE_DAYS returns the number of days an assignment held Active Assignment status; suspended assignments are excluded because they are not income generating. GET_TERMINATION_REASON derives the termination reason associated with an assignment.
• Occupational classification: GET_OCCUPATIONAL_CATEGORY, GET_OCCUPATIONAL_LEVEL, and GET_OCCUPATIONAL_DATA resolve the occupational category, level, and combined data required by the equity report, while CACHE_OCCUPATIONAL_LOCATION caches the occupational location values to avoid repeated lookups during a run. CAT_LEV_DATA supports the category and level data structures.
• Descriptive attributes: GET_EE_EMPLOYMENT_TYPE_NAME returns the employment type description, GET_LOOKUP_CODE retrieves a lookup value, and GET_FUNCTIONAL_DATA and GET_FUNCTIONAL_TYPE return functional data and its type. Users searching for get_functional_data are encountering this routine, which supplies functional (job/task) attributes used to categorise employees for the equity extract.
• Table loading: RESET_TABLES forces a package state reset, POPULATE_EE_TABLE performs the main load into the Employment Equity table, POPULATE_EE_TABLE_EEWF provides the Employment Equity Workflow variant of that load, and INS_G_ENC_DIFF_TABLE inserts into the global encumbrance/difference table used by the reporting logic.

Tables Accessed

The package reads the core HRMS person, assignment, and organisation entities through PER_ALL_PEOPLE_F, PER_ALL_ASSIGNMENTS_F, HR_ALL_ORGANIZATION_UNITS, PER_PERIODS_OF_SERVICE, and PER_ASSIGNMENT_EXTRA_INFO, the last supplying assignment-level descriptive flexfield and extra information used in the equity classification. Payroll and compensation data are drawn from PAY_PAYROLL_ACTIONS, PAY_ASSIGNMENT_ACTIONS, PAY_RUN_RESULTS, PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_ENTRY_VALUES_F, PAY_ELEMENT_TYPES_F, PAY_INPUT_VALUES_F, PAY_BALANCE_TYPES, PAY_BALANCE_FEEDS_F, and PAY_ALL_PAYROLLS_F. These support the remuneration and payroll-related measures required by the equity submission.

Usage Notes

The package is normally invoked by the South African Employment Equity concurrent programs and their associated report definitions, or from the corresponding EBS forms, rather than being called interactively by end users. Because the documented overhaul for 11i and the 12.1/12.2 registration retain the same public interface, custom extensions that call POPULATE_EE_TABLE or POPULATE_EE_TABLE_EEWF directly should do so within a controlled process that first calls RESET_TABLES to guarantee a clean state. The package is referenced by three other packages, and its routines — particularly the occupational, salary-averaging, and functional-data functions — are intended for reuse by those dependent objects. Any customisation must respect the multi–legal entity and business_group_id handling built into later versions.