
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.
This table will store all the information which is been entered in the employee assignment form.
This table will store all the information which is been entered in the employee address form.
This table will store all the information which is been entered in the employee salary form.
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.
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.
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.
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.
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.
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.
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.
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.