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:
- PER_ALL_PEOPLE_F:
- This table stores information about people, including their personal details, employment statuses, and more.
- PAY_ASSIGNMENTS_F:
- Stores assignment information for workers, including position details, job information, and compensation data.
- PER_JOBS:
- Contains job-related data, such as job titles, descriptions, and other attributes.
- PAY_PEOPLE_GROUPS:
- Stores information about people groups, which are used to categorize workers for various purposes.
- PER_GRADES:
- Contains grade-related information, which can be used for compensation management and employee categorization.
- PER_DEPARTMENTS_TL:
- Stores department-related information, including department names and descriptions.
- PAY_ELEMENT_ENTRIES_F:
- Contains information about payroll elements, such as earnings, deductions, and taxes.
Views:
- PER_PERSON_NAMES_V:
- A view that provides person name details, including formatted names and name types.
- PER_PERIODS_OF_SERVICE_V:
- A view that presents periods of service data, including start and end dates.
- PAY_BALANCES_V:
- A view that displays payroll balances, such as vacation balances, sick leave balances, and more.
- PAY_PAYROLL_ACTIONS_V:
- A view that offers information about payroll actions, such as payroll process details.
- PER_JOBS_VL:
- A view that provides job-related data with translations for different languages.
- PAY_PEOPLE_GROUPS_VL:
- A view that presents people group data with translations for different languages.
Oracle Fusion HCM Training Demo Day 1 Video:
Conclusion:
Unogeeks is the No.1 Training Institute for Fusion HCM Training. Anyone Disagree? Please drop in a comment
You can check out our Oracle Fusion HCM Training details here Oracle Fusion HCM Training
You can check out our other latest blogs on Oracle Fusion HCM Training in this Oracle Fusion HCM Blogs
Follow & Connect with us:
———————————-
For Training inquiries:
Call/Whatsapp: +91 73960 33555
Mail us at: info@unogeeks.com
Our Website ➜ https://unogeeks.com
Follow us:
Instagram: https://www.instagram.com/unogeeks
Facebook: https://www.facebook.com/UnogeeksSoftwareTrainingInstitute
Twitter: https://twitter.com/unogeeks