I need a quick and easy way to determine the an individual's salary change and the date the change was made.
The data below, show the annual salary each salary makes, per pay check. At some poing the salary changes due to an adjustment promotion, extra.
Employee 1 has 18 pay periods. I only need to see the check effect date and pay for the starting salary and when the salary changed.
Employee Salary eff Pay
1 12-19-11 6,227.01
1 3-12-12 6,444.95