Results for “pay_grade_rules”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
PAY_GRADE_RULES is a date-effective database view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It belongs to the PAY (Payroll) product family and exposes grade rule and grade rate configuration data used by Oracle Payroll, Oracle Human Resources, and related compensation processes. As a date-effective (datetracked) view, it does not store data itself; instead, it presents only those rows from its underlying table that are valid as of the effective date held in the user's current FND session. This behavior allows applications and reports to query grade rules "as of today" without embedding date predicates in every statement.
The view is documented in the ETRM repository with status VALID, confirming it is a supported, compiled object in the APPS schema. It is commonly referenced in custom reporting, data extraction, and integration routines that need grade rule and rate information for a given business group.
Underlying Base Objects
The view is defined over a single base table, PAY_GRADE_RULES_F, which stores the full dated and non-dated attribute set for grade rules. The view applies a session-based effective date filter using the FND_SESSIONS table. Specifically, rows are returned only where EFFECTIVE_START_DATE is less than or equal to the session effective date and EFFECTIVE_END_DATE is greater than or equal to that same session effective date, both resolved through USERENV('SESSIONID').
The documented referenced base objects are FND_SESSIONS (SYNONYM) and PAY_GRADE_RULES_F (SYNONYM). FND_SESSIONS supplies the effective date for the current user session, while PAY_GRADE_RULES_F provides the underlying grade rule data. This design is the standard Oracle EBS "datetrack" pattern: the _F table holds all dated rows, and the date-effective view returns the single current row per logical record for the session's effective date. Because the view inherits the base table's column set, it is read-only in practice for configuration purposes.
Key Columns
- GRADE_RULE_ID — Primary identifier for the grade rule record.
- EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — The date range during which the row is valid; used by the session-based filter.
- BUSINESS_GROUP_ID — Business group that owns the grade rule, enabling multi-organization separation.
- RATE_ID — Identifier of the grade rate to which the rule applies.
- GRADE_OR_SPINAL_POINT_ID — Grade or spinal point associated with the rule.
- RATE_TYPE — Classification of the rate (for example, fixed or progressive).
- MINIMUM / MID_VALUE / MAXIMUM — Grade rate boundaries used for salary validation and progression logic.
- SEQUENCE / VALUE — Ordered rule entries and their associated values.
- CURRENCY_CODE — Currency in which the rate values are expressed.
- OBJECT_VERSION_NUMBER — Optimistic locking column supporting concurrent update control.
- Audit columns — REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, and CREATION_DATE track the creating concurrent request and standard audit history.
Common Use Cases and Queries
Typical scenarios include validating grade rate boundaries during salary proposals, reporting current grade rules by business group, and feeding compensation data into custom extracts. Because the view already filters by session effective date, queries are simplified.
Example: list current grade rules for a business group
- SELECT gr.GRADE_RULE_ID, gr.BUSINESS_GROUP_ID, gr.RATE_ID, gr.GRADE_OR_SPINAL_POINT_ID, gr.RATE_TYPE, gr.MINIMUM, gr.MID_VALUE, gr.MAXIMUM, gr.CURRENCY_CODE FROM APPS.PAY_GRADE_RULES gr WHERE gr.BUSINESS_GROUP_ID = :p_business_group_id ORDER BY gr.RATE_ID, gr.SEQUENCE;
Example: join to grade rates for descriptive reporting
- SELECT gr.GRADE_RULE_ID, gr.RATE_ID, gr.MINIMUM, gr.MAXIMUM, gr.CURRENCY_CODE FROM APPS.PAY_GRADE_RULES gr WHERE gr.EFFECTIVE_START_DATE <= SYSDATE AND gr.EFFECTIVE_END_DATE >= SYSDATE;
For historical or future-dated analysis, query PAY_GRADE_RULES_F directly with explicit effective date predicates, since the view always returns the session-effective row. Integrations should respect the business group and currency context to avoid ambiguous rate interpretation.
-
View: PAY_GRADE_RULES 12.1.1
Date-effective view.
APPS.PAY_GRADE_RULES·↳ FND_SESSIONS·↳ PAY_GRADE_RULES_F·Explore PAY module →
-
View: PAY_GRADE_RULES 12.2.2
Date-effective view.
APPS.PAY_GRADE_RULES·↳ FND_SESSIONS·↳ PAY_GRADE_RULES_F·Explore PAY module →
-
VIEW: APPS.PAY_GRADE_RULES 12.2.2
-
VIEW: APPS.PAY_GRADE_RULES 12.1.1
-
View: HR_ALL_POSITIONS_D 12.1.1
Used by DateTrack history.
APPS.HR_ALL_POSITIONS_D·↳ FND_FLEX_EXT·↳ FND_USER·↳ HR_ALL_POSITIONS_F·Explore PER module →
-
View: HR_ALL_POSITIONS_D 12.2.2
Used by DateTrack history.
APPS.HR_ALL_POSITIONS_D·↳ FND_FLEX_EXT·↳ FND_USER·↳ HR_ALL_POSITIONS_F·Explore PER module →
-
View: HR_POSITIONS_V1 12.2.2
To support User Interface.
APPS.HR_POSITIONS_V1·↳ FND_PROFILE·↳ HR_GENERAL·↳ HR_POSITIONS_F·Explore PER module →
-
View: HR_POSITIONS_V1 12.1.1
To support User Interface.
APPS.HR_POSITIONS_V1·↳ FND_PROFILE·↳ HR_GENERAL·↳ HR_POSITIONS_F·Explore PER module →
-
VIEW: APPS.HR_POSITIONS_V1 12.1.1
-
VIEW: APPS.HR_POSITIONS_V1 12.2.2
-
PACKAGE: APPS.PER_GRD_BUS 12.1.1
-
View: HR_POSITIONS_V 12.2.2
To support User Interface.
APPS.HR_POSITIONS_V·↳ FND_SESSIONS·↳ HR_ALL_POSITIONS_F·↳ HR_GENERAL·Explore PER module →
-
View: HR_POSITIONS_V 12.1.1
To support User Interface.
APPS.HR_POSITIONS_V·↳ FND_SESSIONS·↳ HR_ALL_POSITIONS_F·↳ HR_GENERAL·Explore PER module →
-
PACKAGE: APPS.PER_GRD_BUS 12.2.2
-
VIEW: APPS.HR_POSITIONS_V 12.1.1
-
VIEW: APPS.HR_POSITIONS_V 12.2.2
-
PACKAGE: APPS.PER_GRADES_PKG 12.1.1
-
PACKAGE: APPS.PER_GRADES_PKG 12.2.2