Rate Effective Date 1

[aatlas]

I am using Report Smith version 3.1 for Oracle Database (ADP Entreprise) and I need to get the rates for all the active employees and the effective date of that pay change.
This system does not have a field for Rate effective date as PCPW had. In order to change a rate you do a Action and choose a value of Pay change and have an effective date for the change.


Can anyone help me please?

Thank you very much

 

[mcbell]

If you are still looking for this report, I've got it.

I'm not sure how to post it here though.

 

[aatlas]

Yes I still need the report. Thank you very much for replying.
Can you send this report by e-mail? If so please let me and I will give you my e-mail address.
Thank you very much again

 

[mcbell]

Not a problem. Give me your email address and I'll send it over.

 

[aatlas]

My e-mail address is acoros@atlascold.com
Thank you very much for your help again

 

[gtarrant]

If you're working with ADP Enterprise, there is a field on PS_JOB named CHANGE_AMT. Any change to this field is an indication of a rate change. Or you can just compare PS_JOB with PS_JOB (prior row) to read any changes.

 

[cabbey77]

Hello gtarrant,

How exactly do you go about comparing something with the previous row?

Thanks,

Christine