Oracle Fusion HCM Table and Views

Oracle Fusion HCM stores its data in a database, and various tables and views are used to organize and manage this data. The structure of these tables and views can vary based on the specific version of Oracle Fusion HCM you’re using. Below are some commonly used tables and views in Oracle Fusion HCM:

Tables:

1. PER_ALL_PEOPLE_F:

• • This table stores information about people, including their personal details, employment statuses, and more.

1. PAY_ASSIGNMENTS_F:

• • Stores assignment information for workers, including position details, job information, and compensation data.

1. PER_JOBS:

• • Contains job-related data, such as job titles, descriptions, and other attributes.

1. PAY_PEOPLE_GROUPS:

• • Stores information about people groups, which are used to categorize workers for various purposes.

1. PER_GRADES:

• • Contains grade-related information, which can be used for compensation management and employee categorization.

1. PER_DEPARTMENTS_TL:

• • Stores department-related information, including department names and descriptions.

1. PAY_ELEMENT_ENTRIES_F:

• • Contains information about payroll elements, such as earnings, deductions, and taxes.

Views:

1. PER_PERSON_NAMES_V:

• • A view that provides person name details, including formatted names and name types.

1. PER_PERIODS_OF_SERVICE_V:

• • A view that presents periods of service data, including start and end dates.

1. PAY_BALANCES_V:

• • A view that displays payroll balances, such as vacation balances, sick leave balances, and more.

1. PAY_PAYROLL_ACTIONS_V:

• • A view that offers information about payroll actions, such as payroll process details.

1. PER_JOBS_VL:

• • A view that provides job-related data with translations for different languages.

1. PAY_PEOPLE_GROUPS_VL:

• • A view that presents people group data with translations for different languages.