Basic Payroll Tables and their links

SELECT * FROM PAY_ELEMENT_TYPES_F(PK: ELEMENT_TYPE_ID)

SELECT * FROM PAY_ELEMENT_LINKS_F(PK: ELEMENT_LINK_ID)
                                  (To link PAY_ELEMENT_TYPES_F:ELEMENT_TYPE_ID)

SELECT * FROM PAY_ELEMENT_ENTRIES_F (PK: ELEMENT_ENTRY_ID)
                                    (To link PER_ALL_ASSIGNMENTS_F :ASSIGNMENT_ID,
                                     PAY_ELEMENT_LINKS_F :ELEMENT_LINK_ID,
                                     PAY_ELEMENT_TYPES_F :ELEMENT_TYPE_ID)
                                                                 
SELECT * FROM PAY_ELEMENT_ENTRY_VALUES_F (PK:ELEMENT_ENTRY_VALUE_ID)
                                         (To link PAY_ELEMENT_ENTRIES_F : ELEMENT_ENTRY_ID,
                                          PAY_RUN_RESULT_VALUES : INPUT_VALUE_ID,
                                          PAY_COSTS : INPUT_VALUE_ID)                                                                

select * from PER_ALL_PEOPLE_F (PK:PERSON_ID)

select * from PER_ALL_ASSIGNMENTS_F (PK:ASSIGNMENT_ID)
                                    (To link PER_ALL_PEOPLE_F:PERSON_ID,
                                     PER_JOBS:JOB_ID,
                                     PER_GRADES:GRADE_ID,
                                     PER_POSITIONS : POSITION_ID,
                                     PER_BUSINESS_GROUPS:BUSINESS_GROUP_ID,
                                     PER_ASSIGNMENT_STATUS_TYPES:ASSIGNMENT_STATUS_TYPE_ID,
                                     HR_LOCATIONS :LOCATION_ID,
                                     PAY_PAYROLLS_F : PAYROLL_ID)
                                                           
SELECT * FROM PER_PERSON_TYPE_USAGES_F (PK: PERSON_TYPE_USAGE_ID)
                                        (To link  PER_ALL_PEOPLE_F: PERSON_ID,
                                         PER_PERSON_TYPES:PERSON_TYPE_ID)

SELECT * FROM PER_PERSON_TYPES  (PK:PERSON_TYPE_ID)
                                 (To link  PER_PERSON_TYPE_USAGES_F : PERSON_TYPE_ID)






Below are the basic main tables between HR and Payroll

1) Pay_all_payrolls_f-> Payroll_id  linked with PER_ALL_ASSIGNEMNTS_F.Payroll_id
2)Pay_personal_payment_methods_F->Assignment_id linked with PER_ALL_ASSIGNEMNTS_F.Assignment_id
3)PAY_ORG_PAYMENT_METHODS_F->Payment_type_id linked with  pay_payment_types.Payment_type_id
4) PER_ALL_ASSINMENTS_F->Assignment_id linked withPAY_ELEMENT_ENTRIES_F.Assignment_id
5)PAY_ELEMENT_TYPES_F->ELEMENT_LINK_ID linked with  PER_ELEMENT_LINKS_F.ELEMENT_LINK_ID
6)PAY_ELEMENT_TYPES_F-> element_type_id linked withpay_input_values_f.element_type_id
7)HR_ALL_POSITIONS_F->position_id  linked with PAY_ELEMENT_TYPES_F.Position_id