Search results for query: *

Using ADP - PCPW - SQLBASE I am creating a rate history report which lists the rate effective date and rate. I would like to compare the rate to the immediately previous rate in order to calculate the percentage increase. Any suggestions would be greatly appreciated.

Thank you!

I am using ADP - PCPW and would like to create a derived field to describe an employees position in the paygrade range based on the percentofrange. I couldn't figure out how to use comparisons like "percentofrange >= 67) so I resorted to the brute force method below. Is there a more elegant...

Thanks - that worked!

Here is the SQL. Thanks for your assistance. SELECT REPORTS.V_HRP_HSTEMPSTATUS.EMPSTATUS, REPORTS.V_EMPLOYEE.NAME, REPORTS.V_EMPLOYEE.STATUS, REPORTS.V_HRP_HSTEMPSTATUS.CHANGEDATE FROM REPORTS.V_EMPLOYEE, REPORTS.V_HRP_HSTEMPSTATUS WHERE (((REPORTS.V_HRP_HSTEMPSTATUS.CHANGEDATE = (SELECT...

Thanks for the suggestions. I am using PCPW with HR Profile and don't think that the tables are effective dated. I also tried the SQL suggested above. However, it only gives me records where the date in the most recent record is on or before the report variable date. So if someone's status...

Using ADP with SQLbase - I need to find the status of employees as of a certain date. The status is in the V_HRP_HSTEMPSTATUS table. Thanks to a previous post in this forum, I can find the status with the most recent changedate. However, for this report I need the last status with a...

Got it - that worked. Thanks for your help.

Thanks for the quick reply. Yes, this is PCPW. I tried the code that you suggested and must be missing something. I am getting an error message "command not ended properly". I have pasted the SQL below. Can you tell me what I did wrong? Thanks, SELECT REPORTS.V_HRP_HSTJOBTITLE.CHANGEDATE...

With ADP, SQL Base, I need to write a report that lists employees and the effective date for their job title. This would be the most recent changedate in the V-HRP_HSTJOBTITLE table. I can get all of the records, but I can't figure out how to get the record with the most recent changedate for...