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!

Register Log in
  • Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: swagaman
  • Content: Threads
  • Order by date
  1. swagaman

    Compare Rate to Previous Rate in Salary History File

    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.
  2. swagaman

    Comparison in Derived Field (PCPW)

    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...
  3. swagaman

    Employee Status as of a specified date

    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...
  4. swagaman

    Most Recent Title change date

    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...

Part and Inventory Search

Back
Top