Rate Effective Date 1

aatlas · Mar 12, 2004

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 · May 3, 2004

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

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

aatlas · May 3, 2004

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 · May 3, 2004

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

aatlas · May 3, 2004

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

gtarrant · May 6, 2004

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 · Aug 16, 2004

Hello gtarrant,

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

Thanks,

Christine

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Rate Effective Date 1

aatlas

Technical User

mcbell

IS-IT--Management

aatlas

Technical User

mcbell

IS-IT--Management

aatlas

Technical User

gtarrant

Technical User

cabbey77

Technical User

Similar threads

Part and Inventory Search

Sponsor