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.
