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