Grade Table in Oracle Fusion HCM

Oracle Fusion HCM does not have a specific “grade table” as a standalone table dedicated solely to storing grade-related data. Instead, grade-related information is usually stored across multiple tables within the application’s database schema, and it is part of the Compensation module.

The main tables related to grades in Oracle Fusion HCM are:

1. PAY_GRADE_DEFINITIONS: This table stores information about different pay grade definitions used in the organization. It includes attributes such as grade ID, grade name, grade range minimum, and grade range maximum.
2. PAY_GRADE_RATES: This table stores the salary rates or ranges associated with each pay grade. It includes data such as salary amounts, currency, frequency, and effective dates.
3. PAY_RATE_TYPES: This table stores the different types of pay rates that can be assigned to a pay grade, such as annual, hourly, or monthly.
4. PAY_RATE_VALUES: This table stores the specific salary values for each rate type and pay grade combination.
5. PAY_RATE_SCALES: This table stores information about pay rate scales, which are used to define salary progression within a pay grade.

These tables are linked together through relational keys to represent the hierarchy and relationships between grades and their associated salary rates.

In addition to the tables mentioned above, there might be other supporting tables related to grade and compensation data, depending on the specific configuration and implementation of Oracle Fusion HCM.

Please note that the names and structures of these tables may vary slightly based on the specific version of Oracle Fusion HCM and the modules that are implemented. Always refer to the official Oracle Fusion HCM documentation and consult with Oracle experts or implementation partners for the most up-to-date and accurate information related to grade management in Oracle Fusion HCM.