Oracle HRMS – Some Important Tables

Oracle HRMS – Some Important Tables


 

1. per_all_people_f
This table will provide us the very basic information about the employee. The very data from the first screen we see when we open the ‘People -> Enter and Maintain’ form goes into this table.
2. per_all_assignments_f
This table will store all the information which is been entered in the employee assignment form.
3. per_addresses
This table will store all the information which is been entered in the employee address form.
4. per_pay_proposals
This table will store all the information which is been entered in the employee salary form.
5. per_person_types_tl
This table 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_jobs_tl
This table will contain the various types of JOBS in oracle. This table is been linked with the per_all_assignments_f table to retrieve the correct job name from the employee.
7. per_grades_tl
This table will contain 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 contain the various 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 various types of PAYROLLS in oracle. This table is been linked with the per_all_assignments_f table to retrieve the correct payroll name from the employee.
10. per_pay_bases
This table will contain the various types of PAY BASES in oracle. This table is been linked with the per_all_assignments_f table to retrieve the correct pay basis name from the employee.
11. per_assignment_status_types_tl
This table will contain the various types of assignment types in oracle. The assignment types generally would be ‘Active Assignment’ etc.. This table is been linked with the per_all_assignments_f table to retrieve the correct job name from the employee.
12. per_person_type_usages_f
This table will store the correct person type of the particluar employee. We should never depend on the person type present in the per_all_people_f table. Instead we need to link the person_id with this table and get the correct person type.

3 Comments

Regards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.

Reply

You have written an excellent blog. I learned something new from your Content. Keep sharing this kind of informative blog.
Oracle DBA Training in Chennai
Oracle DBA Online Training
Best Oracle DBA Training in Chennai

Reply

Interesting Post. Keep posting like this kind of content Payroll Outsourcing Companies In Mumbai . They are one of the leading software outsourcing company in India. This hr software helps in monitoring the employee salary and tax, etc. And this software is based on cloud usage.

Reply

Post a Comment