| employee salary history [message #426388] |
Thu, 15 October 2009 03:54  |
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  |
 |
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
