Wednesday, June 08, 2011

Payroll Tables

Payroll Tables


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 with PAY_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 with pay_input_values_f.element_type_id 
7)HR_ALL_POSITIONS_F->position_id  linked with PAY_ELEMENT_TYPES_F.Position_id

No comments: