Add duplicate line whenever there is a rehire date
Add duplicate line whenever there is a rehire date
(OP)
Running ADP ReportSmith 5.1.2.1
I am in the Sysadmin Reports.V_Employee table and am extracting the data to csv for an Oracle conversion.
Some of the data, however, needs to be repeated because of certain criteria.
What they need is:
EmployeeName and ServiceDate where ServiceDate contains a date of hire or rehire (which are 2 diff fields in ADP).
Most emp have just one date, the hiredate. But some emp have been rehired and thus have both the hiredate and rehiredate fields populated.
If that is the case then a new line needs to be created, see below.
Example of what is needed:
Name ServiceDate
John Smith 1/1/09 (hiredate)
John Smith 5/1/10 (rehiredate)
Currently in ADP it is one line of data:
Name HireDate ReHireDate
John Smith 1/1/09 5/1/10
How do I do that?
Thanks
I am in the Sysadmin Reports.V_Employee table and am extracting the data to csv for an Oracle conversion.
Some of the data, however, needs to be repeated because of certain criteria.
What they need is:
EmployeeName and ServiceDate where ServiceDate contains a date of hire or rehire (which are 2 diff fields in ADP).
Most emp have just one date, the hiredate. But some emp have been rehired and thus have both the hiredate and rehiredate fields populated.
If that is the case then a new line needs to be created, see below.
Example of what is needed:
Name ServiceDate
John Smith 1/1/09 (hiredate)
John Smith 5/1/10 (rehiredate)
Currently in ADP it is one line of data:
Name HireDate ReHireDate
John Smith 1/1/09 5/1/10
How do I do that?
Thanks
Talk To Other Members