Key Tables and Views in Oracle HRMS Module

Please find the list of key tables used in Oracle HRMS Module:

HRMS KEY TABLES

1)  per_all_people_f
This table will give the basic information about the employee.
per_people_f
Its secured view on top of per_all_people_f table
per_people_x
Its secured view on top of per_all_people_f table effective at system date

2)  per_all_assignments_f
This table will give the information which has been entered in the employee assignment screen.
per_assignments_f
Its secured view on top of per_all_assignments_f table
peR_assignments_x
Its secured view on top of per_all_assignments_f table effective at system date

3. per_addresses
This table will give all the information which has been entered in the employee address screen.

4. per_pay_proposals
It will give the information which has been entered in the employee salary screen.

5. per_person_types_tl
This is translatable table, which is used to find the type of the employee. This table is linked with the per_all_people_f with the person_type_id to find out the type of person.

6. per_all_positions
This table will give the employee's position information.
per_jobs_tl
This is translatable table, which  will contain the various types of JOBS in oracle.

per_positions
Its secured view on top of per_all_positions table

7. per_grades_tl
This is translatable table, which  will store the various types of GRADES in oracle. This table is been linked with the per_all_assignments_f table to retrieve the correct grade name from the employee.

8. hr_locations_all
This table will store the different LOCATIONS in oracle. This table is been linked with the per_all_assignments_f table to retrieve the correct location name from the employee.

9. pay_all_payrolls_f
This table will contain the different types of PAYROLLS in oracle. This table has been linked with the per_all_assignments_f table to retrieve the payroll name from the employee.

10. per_pay_bases
This table will store the different types of PAY BASES in oracle. This table is been linked with the per_all_assignments_f table to retrieve the pay basis name from the employee.

11. per_assignment_status_types_tl
This table will contain the different types of assignment types in oracle.

12. per_person_type_usages_f
This table will store the correct person type of the particluar employee. We should never look on the person type present in the per_all_people_f table. we need to link the person_id with this table and get the correct person type.

13. hr_all_organization_units
This table will store the employee's s organization information
hr_organization_units
Its secured view on top of hr_all_organization_units table

I hope it will be useful for you. If you have any query, write in comments box.