Audit on Employee Identification (SSN) changes

Legacy Contributor

We are trying to find a way to track the changes made to the employee identification # (SSN) in GHR.  I thought it would be possible using the newer functionality in the Employee History Reporting with Lmrk 11.0.24 but it is not.  Is there another way to pull the changes to this field?

Legacy Contributor

I think this query will show people who have had changes.

You can go to the EmployeeIdNumber business class look up each one and right click and full audit log to see what the change was and who did it.

SELECT Distinct a.EMPLOYEE, count(*) as "number of matches"
FROM lmhcm.EMPLOYEEIDNUMBEREXPORT a
JOIN lmhcm.EMPLOYEEIDNUMBEREXPORT b ON (
a.HRORGANIZATION = b.HRORGANIZATION
AND a.EMPLOYEE = b.EMPLOYEE
AND a.EMPLOYEEIDENTIFICATIONNUMBER = b.EMPLOYEEIDENTIFICATIONNUMBER
AND a.AUDITENTRYID != b.AUDITENTRYID
AND a.AUDITENTRYID != 0
AND b.AUDITENTRYID != 0
AND a.SYSTEMTIMESTAMP > b.SYSTEMTIMESTAMP
) group by a.EMPLOYEE
ORDER BY 1