It will be good if you get all tables in Oracle HRMS at one place, isn’t it? Here is the list of all important tables of Oracle HRMS
This table gives us very basic information about the employee. from ‘XX HRMS Manager -> People -> Enter and maintain‘ screen data goes into this table.
Employees’ and applicants’ assignment details are stored in this table. It is lined by person_id with per_all_people_f table.
Details entered in employee address form are stored in this table.
This table will store all the information which is been entered in the employee salary form.
This table stores the type of an employee. It is linked with the per_all_people_f with the person_type_id.
This table stores types of jobs. It is linked with the per_all_assignments_f table to retrieve the correct job name of an employee.
This table contains grade information of employees. It is linked with the per_all_assignments_f table to retrieve the correct grade name for an employee.
This table contains position definition information. It is linked with per_all_assignments_f table to retrieve position details of an employee.
This table stores location of parties or employees. It is linked with the per_all_assignments_f table to retrieve the correct location of an employee.
This table will contain payroll information. It is linked with the per_all_assignments_f table to retrieve the correct payroll name of an employee.
This table contains pay bases information of an employee. It is linked with the per_all_assignments_f table to retrieve the correct pay bases name of an employee.
This table contains information about assignment types. The assignment types generally would be ‘active assignment’ etc. It is linked with the per_all_assignments_f table to retrieve the correct job name of an employee.
This table contains person type information of an employee. It is linked with per_all_people_f to retrieve correct person type of an employee.
This table contains operating unit, organization and business group information. It is linked to per_all_assignments to retrieve business group of an employee.
This view contains business group information. It is linked with other tables by business_group_id.
This view contains operating unit information. It is linked with other tables by org_id
When you create elements of employee salary, data is stored in this table.
Whatever is done with oracle payroll engine, entries are recorded in pay_payroll_actions table.
To make payroll elements eligible to a group of people, element links are created. The information is stored in pay_element_links_f table.
For each and every element entry of an employee, information is stored in pay_element_entries_f table. It is linked with per_all_assignments_f table by assignment_id.
This table contains value of elements defined for an employee in pay_element_entries_f table.
To find detailed information about oracle tables and views click here.
Hope you like the article and find it useful. We highly appreciate comments and feedback.
Hi I am Paras.
Thanks for stopping by at OracleMine.com. Speaking about my brief introduction, I work for a multinational organisation in Oracle related technologies. Being an avid blogger, I would like to inform you about my productivity and motivational blog XpressPlanet.com. Speaking of OracleMine.com, I will try my best to share knowledge on technologies in as simple and understandable manner as possible. You can also contribute your knowledge on OracleMine by writing to us at firstname.lastname@example.org. Again I appreciate your visit. Hope to see you again and again!