Oracle 11i HR/Payroll Database table Structure

[akumar.oracle]

Hi,

I am after HR and Payroll Database tables structure.

Can anyone please tell me where to find ?

I am after all the tables and how they are linked...

cheers
Arvin

[eng_ahmad_2007]

You need an instance besides experience to understand the relationship between Oracle HR and Payroll Tables.

Among the mostly-used tables:

PER_ALL_PEOPLE_F --> stores people (employees, contingent workers, ...) information
PER_ALL_ASSIGNMENTS_F --> stores assignment information.
PER_GRADES --> stores Grades Definiton
HR_LOCATIONS_ALL --> Stores Locations
HR_ALL_ORGANIZATION_UNITS --> stores all HR organizations
PAY_ELEMENT_TYPES_F --> Element Definition
PAY_ELEMENT_ENTRY_VALUES_F --> Element Entries

Regards,