Audit Changes Made to SSN-Social Security Number



Description of Issue

Is there a way to audit changes made to Social Security Numbers in Employee Master or other Payroll Programs?



Context
  • Payroll

  • Employee Master

  • Payroll Audit Inquiry



Cause




Resolution

There is no way to audit changes made to a specific field in Employee Master. However, you can utilize the Payroll Audit Inquiry program to find changes made in Employee Master, and Excel to narrow them down to a specific field/value. 



Additional Information
  1. Navigate to Payroll>Payroll Administration>Payroll Audit Inquiry.

  2. Search table name prempmst.

    1. Use Date field and colon to narrow down to a specific time frame if needed. Ex. 07012023:07152023

    2. Leave prem_proj and prem_emp fields blank to audit all changes.

  3. Click Excel to export results.

  4. Once in Excel, use filters to narrow down by field. 

    1. ex. prem_ssn for Social Security Number