Results for “pay_rate_determinant”

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

Overview

GHR_MASS_SALARY_CRITERIA is a table in the HR schema owned by the GHR – US Federal Human Resources product within Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the additional selection criteria that govern a mass salary action, allowing payroll and HR administrators to target a specific subset of employees (for example, by pay plan and pay rate determinant) rather than applying an increase to an entire population. Each row represents one criterion line associated with a parent mass salary record, and the table participates directly in the mass salary adjustment workflow executed from the US Federal HR forms and concurrent processes.

Under a heuristic Data Vault classification mined from its foreign key structure, the table is best modelled as a link. It resolves the many-to-many relationship between a mass salary action and the pay plans against which criteria are applied, while its descriptive attribute columns (such as INCREASE_PERCENT) and audit columns behave like satellite payload attached to that link. This classification is a modeling suggestion only; the physical table remains a standard normalized EBS transactional entity.

Key Information Stored

The table contains ten documented columns. The most significant are:

• MASS_SALARY_CRITERIA_ID – the surrogate primary key, uniquely generated per row and enforced through the unique index GHR_MASS_SALARY_CRITERIA_PK. This is the only documented unique index and therefore the sole business-key candidate.
• MASS_SALARY_ID – foreign key to GHR_MASS_SALARIES, tying the criterion to its parent mass salary action.
• PAY_PLAN – foreign key to GHR_PAY_PLANS, identifying the pay plan to which the criterion applies (e.g., a Federal General Schedule plan).
• PAY_RATE_DETERMINANT – the determinant used to resolve the applicable pay rate within the selected pay plan, refining eligibility for the action.
• INCREASE_PERCENT – the percentage increase to be applied to employees matching this criterion line.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – standard EBS audit columns that track who created and last modified the row and when.

Common Use Cases and Queries

Typical usage centres on reviewing or validating the criteria attached to a pending mass salary action before submission, or producing audit-ready reports of planned increases. A representative query retrieves all criteria for a given mass salary together with the pay plan description:

• Selecting all criterion rows for a mass salary: SELECT mass_salary_criteria_id, pay_plan, pay_rate_determinant, increase_percent FROM ghr_mass_salary_criteria WHERE mass_salary_id = :p_mass_salary_id;
• Joining to the parent action and pay plan for reporting: SELECT c.mass_salary_id, c.pay_plan, c.increase_percent FROM ghr_mass_salary_criteria c, ghr_mass_salaries s, ghr_pay_plans p WHERE c.mass_salary_id = s.mass_salary_id AND c.pay_plan = p.pay_plan;
• Audit reporting on increases applied per pay plan across a period, using CREATION_DATE and LAST_UPDATE_DATE to bound the extract.

Because the table supports the mass salary concurrent programs, queries are frequently embedded in custom validation before the action is run, ensuring that no duplicate or conflicting criteria exist for the same pay plan and determinant.

Related Objects

The following objects are most significant in relation to GHR_MASS_SALARY_CRITERIA:

• GHR_MASS_SALARIES – parent table; joined on MASS_SALARY_ID.
• GHR_PAY_PLANS – referenced table; joined on PAY_PLAN.
• GHR_MASS_SALARY_CRITERIA_EXT – extension table referencing MASS_SALARY_CRITERIA_ID, used for client-defined descriptive flexfield style attributes.
• GHR_MASS_SALARY_CRITERIA_PK – the primary key index enforcing uniqueness of MASS_SALARY_CRITERIA_ID.
• Related mass salary processing and payroll datetrack APIs that read criteria during the mass salary action run.

Together these objects form the transactional backbone for US Federal mass salary processing within Oracle EBS Human Resources.