|
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. |
|
per_all_assignments_f |
This table
will store all the information which is been entered in the employee
assignment form. |
|
per_addresses |
This table
will store all the information which is been entered in the employee address
form. |
|
per_pay_proposals |
This table
will store all the information which is been entered in the employee salary
form. |
|
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. |
|
per_jobs_tl |
This table
will contain the various types of JOBS in oracle. This table has been linked
with the per_all_assignments_f table to retrieve the correct job name from
the employee. |
|
per_grades_tl |
This table
will contain the various types of GRADES in oracle. This table has been
linked with the per_all_assignments_f table to retrieve the correct grade
name from the employee. |
|
hr_locations_all |
This table
will contain the various LOCATIONS in oracle. This table has been linked with
the per_all_assignments_f table to retrieve the correct location name from
the employee. |
|
pay_all_payrolls_f |
This table
will contain the various types of PAYROLLS in oracle. This table has been
linked with the per_all_assignments_f table to retrieve the correct payroll
name from the employee. |
|
per_pay_bases |
This table
will contain the various types of PAY BASES in oracle. This table has been
linked with the per_all_assignments_f table to retrieve the correct pay basis
name from the employee. |
|
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 has been linked
with the per_all_assignments_f table to retrieve the correct job name from
the employee. |
|
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. |
