Results for “target_job_id”

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

Overview

GHR_MASS_SALARIES is a transactional table owned by the HR schema within the GHR – US Federal Human Resources product family in Oracle E‑Business Suite 12.1.1 and 12.2.2. It stores the defining criteria and processing status for mass salary actions — pay adjustments applied simultaneously across a defined population of Federal employees. Each row represents one mass salary action, capturing the governing legal authority (such as an Executive Order or OPM issuance), the effective date of the adjustment, the selection criteria used to identify affected employees, and the processing state of the action.

From a dimensional modeling perspective, the documented foreign key structure suggests a satellite-leaning classification, since the table primarily holds descriptive attributes and status flags tied to a parent business transaction rather than serving as a standalone reference or pure association entity. This classification is heuristic and offered as a modeling suggestion rather than a documented Oracle construct.

Key Information Stored

The table contains 37 documented columns. The surrogate primary key is MASS_SALARY_ID, enforced by the GHR_MASS_SALARIES_PK constraint. A second unique index, GHR_MASS_SALARIES_UK, is defined on NAME, making NAME the business-key candidate by which users typically identify a given mass salary action.

• MASS_SALARY_ID — surrogate primary key uniquely identifying the action.
• NAME — user-assigned business identifier for the action.
• PA_REQUEST_ID — foreign key to GHR_PA_REQUESTS, linking the action to its personnel action request.
• EFFECTIVE_DATE — the date on which the resulting salary change takes effect.
• EXECUTIVE_ORDER_NUMBER, EXECUTIVE_ORDER_DATE — the governing Executive Order and its date.
• OPM_ISSUANCE_NUMBER, OPM_ISSUANCE_DATE — the Office of Personnel Management authority reference.
• ORGANIZATION_ID — FK to HR_ALL_ORGANIZATION_UNITS, scope of the action.
• PERSONNEL_OFFICE_ID — FK to GHR_POIS, the processing personnel office.
• USER_TABLE_ID — FK to PAY_USER_TABLES, allowing a user-defined selection table.
• SUBMIT_FLAG — controls whether the action is submitted for processing.
• PROCESS_TYPE — classification of the mass salary process.
• TARGET_* columns (e.g., TARGET_AGENCY_CODE_SUBELEMENT, TARGET_DUTY_STATION_ID, TARGET_JOB_ID, TARGET_FLSA_CATEGORY) — capture the target attributes that define the employee population affected.
• NOA_CODE, NTE_DATE, LOCALITY_PAY_AREA_CODE, BARGAINING_UNIT_STATUS, FLSA_CATEGORY, JOB_ID — Federal pay attributes constraining the action.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard audit trail columns.

Common Use Cases and Queries

Typical use cases include verifying that a mass salary action was submitted and completed, reconciling EC/OPM authority references against resulting salary changes, and reporting on affected populations by duty station, agency subelement, or bargaining unit. A common pattern joins the action header to its criteria:

SELECT ms.MASS_SALARY_ID, ms.NAME, ms.EFFECTIVE_DATE,
       ms.OPM_ISSUANCE_NUMBER, ms.EXECUTIVE_ORDER_NUMBER
FROM   HR.GHR_MASS_SALARIES ms
WHERE  ms.SUBMIT_FLAG = 'Y'
AND    ms.EFFECTIVE_DATE BETWEEN :start_date AND :end_date;

Reporting at the office or organization level uses the FK to HR_ALL_ORGANIZATION_UNITS:

SELECT ms.NAME, hou.NAME AS organization_name
FROM   HR.GHR_MASS_SALARIES ms,
       HR.HR_ALL_ORGANIZATION_UNITS hou
WHERE  ms.ORGANIZATION_ID = hou.ORGANIZATION_ID;

Related Objects

• GHR_PA_REQUESTS — referenced via GHR_MASS_SALARIES.PA_REQUEST_ID; provides the personnel action request context.
• HR_ALL_ORGANIZATION_UNITS — referenced via ORGANIZATION_ID; scopes the action to an organization.
• GHR_POIS — referenced via PERSONNEL_OFFICE_ID; identifies the processing personnel office.
• PAY_USER_TABLES — referenced via USER_TABLE_ID; supports user-defined selection criteria.
• GHR_MASS_SALARY_CRITERIA — the child table referencing this table via MASS_SALARY_ID in a one-to-many relationship, holding the detailed selection criteria.