Home » Applications » Oracle Fusion Apps & E-Business Suite » employee salary history (9, unix)
employee salary history [message #426388] Thu, 15 October 2009 03:54 Go to next message
derrywriter
Messages: 8
Registered: October 2009
Junior Member
Hi all,

I have been asked to wrtie a sql script to show the salary history for an employee over a date range including start and end date plus the grade point.

Does anyone know where I can look in HR schema to get this info?

Thanks,

dw
Re: employee salary history [message #426466 is a reply to message #426388] Thu, 15 October 2009 09:58 Go to previous message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
I'm not an HRMS expert.
But I think you can use the following tables to get the required.

pay_element_types_f
pay_element_links_f
pay_element_entries_f
per_all_assignments_f
per_all_people_f

By
Vamsi
Previous Topic: Journal Name
Next Topic: Oracle retail docs
Goto Forum:
  


Current Time: Thu Sep 29 15:50:08 CDT 2016

Total time taken to generate the page: 0.08735 seconds