Results for “ghr_pd_classifications”

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

Overview

GHR_PD_CLASSIFICATIONS is a table in the HR schema belonging to the GHR – US Federal Human Resources product family within Oracle E-Business Suite. It stores the classification details associated with a Position Description, which is the formal record describing the duties, responsibilities, and grading attributes of a position in a US federal human resources implementation. Because federal position management depends on accurate classification data to grade, pay, and advertise positions, this table serves as a critical link between a position description record and the classification, pay plan, occupational series, and grade information used throughout the staffing and compensation lifecycle. The object is documented as VALID in ETRM 12.2.2 with owner HR and 13 columns.

From a modeling perspective, the mined foreign-key structure classifies this object heuristically as a link in a Data Vault sense: it primarily connects the position description hub to classification and pay plan references rather than acting as a standalone hub or a descriptive satellite. This is a suggested interpretation based on the documented FK relationships, not a physical constraint imposed by the database.

Key Information Stored

The table is keyed by PD_CLASSIFICATION_ID, the surrogate primary key defined by the index GHR_PD_CLASSIFICATIONS_PK. A second unique index, GHR_PD_CLASSIFICATIONS_UK, covers POSITION_DESCRIPTION_ID and CLASS_GRADE_BY, making this pair the documented business-key candidate. The most significant columns include:

• POSITION_DESCRIPTION_ID — foreign key to GHR_POSITION_DESCRIPTIONS, identifying the position description being classified.
• CLASS_GRADE_BY — the authority or basis by which the classification and grade were determined; part of the unique business key.
• OFFICIAL_TITLE — the official title assigned to the classified position.
• PAY_PLAN — foreign key to GHR_PAY_PLANS, identifying the pay plan applicable to the classification.
• OCCUPATIONAL_CODE — the occupational series or code associated with the position.
• GRADE_LEVEL — the grade level determined for the position.
• OBJECT_VERSION_NUMBER — optimistic locking column supporting concurrent updates.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — standard Oracle EBS audit columns capturing who created and last modified the row and when.

Common Use Cases and Queries

Typical reporting scenarios include retrieving the full classification profile of a position description, validating classification and grade assignments against pay plan rules, and auditing classification changes over time. A representative join pattern follows:

• Join to GHR_POSITION_DESCRIPTIONS on POSITION_DESCRIPTION_ID to return position context alongside its classification.
• Join to GHR_PAY_PLANS on PAY_PLAN to resolve pay plan descriptions and administrative details.
• Filter on CLASS_GRADE_BY to analyze classifications by determining authority.
• Filter on OCCUPATIONAL_CODE or GRADE_LEVEL to produce rosters grouped by series or grade.

Example pattern: SELECT c.POSITION_DESCRIPTION_ID, c.OFFICIAL_TITLE, c.PAY_PLAN, c.OCCUPATIONAL_CODE, c.GRADE_LEVEL FROM HR.GHR_PD_CLASSIFICATIONS c WHERE c.POSITION_DESCRIPTION_ID = :pd_id; Audit queries commonly order by LAST_UPDATE_DATE to surface recent classification amendments.

Related Objects

The following objects are most closely associated with GHR_PD_CLASSIFICATIONS through documented relationships:

• GHR_POSITION_DESCRIPTIONS — referenced via GHR_PD_CLASSIFICATIONS.POSITION_DESCRIPTION_ID.
• GHR_PAY_PLANS — referenced via GHR_PD_CLASSIFICATIONS.PAY_PLAN.
• GHR_PD_CLASSIFICATIONS_PK — primary key index on PD_CLASSIFICATION_ID.
• GHR_PD_CLASSIFICATIONS_UK — unique index on POSITION_DESCRIPTION_ID and CLASS_GRADE_BY.

Position description maintenance and federal staffing processes depend on these relationships to ensure that classification data remains consistent with position and pay plan reference data across the GHR module.