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!

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

Status vs Unknown Action Dates vs Specified Date Range

Status
Not open for further replies.

vlfox

Technical User
Oct 13, 2005
40
US
We’re on ADP Enterprise, Reportsmith 4.0 - SQL:

I’m looking for a better system for when my VP asks for a report of “Who was in this Employment Status, in this JobCode, and in this Location Code anytime within this date range?”

An employee may have had several Actions, several JobCodes, and/or several Locations over his career. He may have even had several statuses due to Active, Leave, Term, ReHires so I won’t know those dates or details. I just want to capture them if they ever a met all of these parameters at anytime during the specified date range.

So far we’ve been changing the effective date of the report to None and pulling anyone that’s ever had the JobCode, then taking it all to Excel and weeding through all of them…Would love to simplify.

ThanX to all !
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top