Results for “pqh_de_level_numbers”

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

Overview

PQH_DE_LEVEL_NUMBERS is a Public Sector HR (PQH) reference table in the Oracle E-Business Suite database, owned by the HR schema. It stores the definition of "Level Numbers" used by the Oracle Public Sector HR "DE" (Data Entry) feature set, which supports position classification, workplace validation, and related HR data capture for public sector and government customers. The table functions as the master list of level number codes that drive the configuration of validation rules applied to workforce and position data.

Under the heuristic Data Vault classification mined from the foreign-key structure, the table is modeled as standalone. This classification suggests the table behaves as an independent reference or lookup entity rather than a transactional hub or a descriptive satellite. It holds its own surrogate key and business attributes without serving as the target of a dominant dependent relationship, although it is referenced by downstream validation objects.

The table is documented as VALID in ETRM 12.2.2 with nine physical columns. Its primary key is defined by the constraint PQH_DE_LEVEL_NUMBERS_PK on the LEVEL_NUMBER_ID column.

Key Information Stored

The documented physical schema identifies the following attributes, which represent the operative content of each row:

• LEVEL_NUMBER_ID — the surrogate primary key, uniquely identifying each level number record. It is the single unique index (PQH_DE_LEVEL_NUMBERS_PK) and the column referenced by dependent tables.
• LEVEL_NUMBER — the business-facing level number value. This is the most likely business-key candidate, as it carries the human-readable identifier used in configuration and reporting.
• DESCRIPTION — the descriptive text associated with each level number, providing user-friendly labeling.
• OBJECT_VERSION_NUMBER — the optimistic locking column used by the Oracle Application Framework (OAF) and standard EBS concurrent processing to detect concurrent row updates.
• CREATED_BY, CREATION_DATE — the standard WHO audit columns recording the creating user and timestamp.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — the standard WHO audit columns capturing the most recent modification metadata.

No additional business columns beyond LEVEL_NUMBER and DESCRIPTION are documented, indicating this is a thin lookup table whose primary purpose is to supply valid level number values to dependent validation logic.

Common Use Cases and Queries

Typical usage centers on populating and validating level number values that appear on positions, workplace validation records, and DE data entry forms. Reporting queries join this table to dependent validation tables to translate surrogate identifiers into meaningful level numbers and descriptions.

A representative query to list configured level numbers is:

• SELECT level_number_id, level_number, description FROM hr.pqh_de_level_numbers ORDER BY level_number;

A join pattern resolving dependent validation rows is:

• SELECT v.*, n.level_number, n.description FROM hr.pqh_de_wrkplc_vldtn_lvlNums v, hr.pqh_de_level_numbers n WHERE v.level_number_id = n.level_number_id;

Extracts for migrating configuration between environments and LOV (List of Values) queries driving OAF pages are also common.

Related Objects

The documented foreign-key relationship establishes the principal dependency:

• PQH_DE_WRKPLC_VLDTN_LVLNUMS — references PQH_DE_LEVEL_NUMBERS via LEVEL_NUMBER_ID, linking workplace validation rules to specific level numbers.

As a standalone reference table, PQH_DE_LEVEL_NUMBERS primarily serves as a parent to validation tables. Integration with the broader PQH DE data entry framework means related configuration and validation tables within the same module are the most significant dependents and consumers.