We are working on information for the Affordable Care Act...
We need to determine which of our employees were "active" on a certain day - 1/1/2015 to be exact.
Not necessarily if they worked that day, but were they an active employee on that particular day.
Our payroll software does not give us an option to run a report to get this information. I am able to access the database and have found a table that shows the employee status. H=Hire, T=Terminate, R=Rehire with the corresponding date.
I'm sure there is a way to do this but can't even get started. Some of the employees, for example #2148 has 13 in's and out's. Trying to get a list of employee names and their employee ID's that were "active" on 1/1/2015.
Any assistance would be appreciated. I have attached a file with one of our 50+ companies that we will have to evaluate.