Results for “career_ladder”

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

Overview

The GHR_POSITION_DESCRIPTIONS table, owned by the HR schema, is a core data object within the GHR — US Federal Human Resources product family in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores Federal Position Description details, which are the formal, classified records that document the duties, responsibilities, classification standards, and supervisory relationships associated with a federal position. Position descriptions in the federal HR context are the authoritative source for how a position is classified under OPM (Office of Personnel Management) rules, and this table captures that classification metadata alongside routing and approval tracking information.

From a Data Vault modeling perspective, the heuristic classification for this table is hub-leaning. This suggests that GHR_POSITION_DESCRIPTIONS functions primarily as a hub, with POSITION_DESCRIPTION_ID serving as the durable business key around which related satellites and link tables (such as GHR_PD_CLASSIFICATIONS and GHR_PD_ROUTING_HISTORY) are organized. This classification is a modeling suggestion derived from the foreign key structure, not a physical constraint.

Key Information Stored

The table contains 54 documented columns. The most significant include:

• POSITION_DESCRIPTION_ID — The surrogate primary key (GHR_POSITION_DESCRIPTIONS_PK), uniquely identifying each position description record.
• ROUTING_GROUP_ID — Foreign key to GHR_ROUTING_GROUPS, indicating the routing or approval workflow group assigned to the position description.
• DATE_FROM and DATE_TO — Effective date range for the position description record.
• OPM_CERT_NUM — OPM classification certificate number associated with the position.
• FLSA — Fair Labor Standards Act exemption status (exempt/non-exempt).
• POSITION_STATUS, POSITION_IS, POSITION_SENSITIVITY, COMPETITIVE_LEVEL — Classification attributes defining the position's nature, sensitivity, and competitive service level.
• POSITION_CLASS_STD, CATEGORY, CAREER_LADDER — Position classification standard, category, and career ladder designation.
• SUPERVISOR_NAME, SUPERVISOR_TITLE, SUPERVISOR_DATE, MANAGER_NAME, MANAGER_TITLE, MANAGER_DATE, CLASSIFIER_NAME, CLASSIFIER_TITLE, CLASSIFIER_DATE — Certification and sign-off details from supervisors, managers, and classifiers.
• PA_REQUEST_ID — Link to the personnel action request driving the position description action.
• BUSINESS_GROUP_ID — Multi-tenant / business group segregation key typical of HR tables.
• OBJECT_VERSION_NUMBER, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE — Standard WHO columns supporting concurrency control and audit.

The table also includes 20 descriptive flexfield attribute columns (ATTRIBUTE1 through ATTRIBUTE20) and an ATTRIBUTE_CATEGORY column, enabling extensibility without schema changes.

Common Use Cases and Queries

Typical reporting scenarios include retrieving active position descriptions effective as of a given date, listing positions by classification standard, and auditing routing history. Sample SQL patterns:

• Active positions: SELECT POSITION_DESCRIPTION_ID, OPM_CERT_NUM, POSITION_STATUS, DATE_FROM, DATE_TO FROM HR.GHR_POSITION_DESCRIPTIONS WHERE SYSDATE BETWEEN DATE_FROM AND NVL(DATE_TO, SYSDATE);
• Join to routing groups: SELECT p.POSITION_DESCRIPTION_ID, r.* FROM HR.GHR_POSITION_DESCRIPTIONS p, HR.GHR_ROUTING_GROUPS r WHERE p.ROUTING_GROUP_ID = r.ROUTING_GROUP_ID;
• Classification lookup: SELECT p.POSITION_DESCRIPTION_ID, c.* FROM HR.GHR_POSITION_DESCRIPTIONS p, HR.GHR_PD_CLASSIFICATIONS c WHERE p.POSITION_DESCRIPTION_ID = c.POSITION_DESCRIPTION_ID;

These queries support federal HR analysis, compliance audits, and OPM reporting.

Related Objects

• GHR_ROUTING_GROUPS — Referenced via ROUTING_GROUP_ID; defines approval routing groups.
• GHR_PD_CLASSIFICATIONS — References this table via POSITION_DESCRIPTION_ID; holds classification decisions.
• GHR_PD_ROUTING_HISTORY — References this table via POSITION_DESCRIPTION_ID; tracks routing/approval history.
• HR.PER_ALL_PEOPLE_F and HR.PER_JOBS — Commonly joined for incumbent and job context.
• PA_REQUEST_ID links to personnel action request tables used in the HR workflow.

These relationships establish GHR_POSITION_DESCRIPTIONS as a central hub for federal position classification and routing data.