Results for “level_cat_code”

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

Overview

The PER_ZA_EMPLOYMENT_EQUITY table is a Human Resources (PER) module object owned by the HR schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It is classified in ETRM as a temporary table used specifically for Employment Equity Reporting, supporting South African (ZA) statutory reporting obligations. In practice, the object functions as a staging or aggregation structure into which employment equity demographic data is populated at report run time, then consumed by the corresponding report or concurrent program output. Because its contents are transient and regenerated per submission cycle, it should not be treated as a system of record for employee demographic attributes.

From a Data Vault modeling perspective, the heuristic classification mined from the foreign-key structure is standalone. This suggests the table is best modeled as an independent satellite or reporting-stage construct rather than as a hub or link, since no dependent child tables reference it and its only outbound relationship is to the legal entity dimension. Analysts building a warehouse layer over EBS should therefore treat PER_ZA_EMPLOYMENT_EQUITY as an aggregate/derived source keyed on report runs rather than a transactional entity.

Key Information Stored

The documented physical schema contains 18 columns. The most significant for identification, aggregation, and filtering are:

• REPORT_ID — the report run identifier; the principal candidate for a surrogate or composite key, scoping each set of aggregated rows to a single reporting execution.
• REPORTING_DATE — the effective date of the equity snapshot, used to align rows with statutory reporting periods.
• LEVEL_CAT and LEVEL_CAT_CODE — the occupational level or category (for example, top management through unskilled) that forms the primary row grouping in an employment equity return.
• BUSINESS_GROUP_ID — the HR security/operating unit identifier, a key business filter in multi-organization deployments.
• LEGAL_ENTITY_ID — foreign key to FV_LEGAL_ENTITIES, identifying the reporting legal entity; the denormalized LEGAL_ENTITY name is also carried for display.
• DISABILITY — flag or count reflecting employees with declared disabilities, a mandatory disclosure element.
• EMPLOYMENT_TYPE — classification such as permanent or temporary, another required disaggregation.
• MA, MC, MI, MW — male counts by racial group (African, Coloured, Indian, White), the core demographic measures.
• FA, FC, FI, FW — the matching female counts by racial group.
• TOTAL — the row-level headcount total, typically the sum of the populated demographic columns.

Common Use Cases and Queries

Typical usage centers on extracting, validating, or reconciling a completed employment equity submission. A representative query retrieves all rows for a given run, ordered by occupational level, to reproduce the report layout:

• SELECT level_cat, ma, mc, mi, mw, fa, fc, fi, fw, total FROM hr.per_za_employment_equity WHERE report_id = :p_report_id AND legal_entity_id = :p_org_id ORDER BY level_cat;
• Verification of internal consistency, for example confirming that TOTAL equals the sum of the eight demographic columns for every row, is a common data-quality check.
• Trend reporting across periods, joining on REPORTING_DATE, allows comparison of workforce composition between successive statutory submissions.
• Aggregation by LEGAL_ENTITY or BUSINESS_GROUP_ID supports group-level consolidation across multiple South African entities.

Related Objects

The documented foreign-key relationship and the surrounding PER reporting infrastructure identify the following significant related objects:

• FV_LEGAL_ENTITIES — referenced by PER_ZA_EMPLOYMENT_EQUITY.LEGAL_ENTITY_ID; the authoritative source for legal entity identity and name.
• PER_ALL_PEOPLE_F and PER_ALL_ASSIGNMENTS_F — the primary employee and assignment sources from which headcount and demographic attributes are drawn when the report is generated.
• HR_ORGANIZATION_UNITS and HR_ALL_ORGANIZATION_UNITS — provide business group and organization context for LEGAL_ENTITY_ID and BUSINESS_GROUP_ID filtering.
• PER_ZA_EMPLOYMENT_EQUITY report/concurrent program definitions in the PER module — consumed as the output staging layer.
• FND_LOOKUP_VALUES — supplies the meaning of LEVEL_CAT_CODE and EMPLOYMENT_TYPE values.