HR - Address Cleansing Exception Report (SQR Report)

GENERAL DESCRIPTION:

The purpose of the Address Cleansing Exception Report (UWHRR020) is to list all those employees that have been identified as having invalid Home or Mail addresses in HRS via the HRS Address Cleansing batch process and route the output to UW institutions via Cypress. The HRS Address Cleansing batch process is scheduled weekly on Friday evenings. The core HRS Address Cleansing procedures are provide by Runner Technology and maintained by DoIT. Source address data files are provided approximately every two months. It may take several months for source address files to reflect the most current addresses (ie. new housing developments).

PROCESS CONSIDERATIONS:
  • There can be multiple errors for a single address.  However, Only the first fault description encountered is displayed on the report.
  • Inactive employees that have not been paid in the current calendar year are excluded from the report.
  • Name, Address, Fault Description, and Email Address report fields are truncated to comply with Cypress formatting requirements.
  • All errors need to be corrected within the Modify a Person Component (Nav: Workforce Administration > Personal Information > Modify a Person > Contact Information)
  • Be mindful of any corrections that would affect Benefits.
  • Home address should not be set to a work address.
  • Employee’s Home Address is used for calendar year-end W2 Tax Reporting information.
  • Source address data files are provided by Runner Technology approximately every two months (Feb; Apr; Jun; Aug; Oct; Dec) and implemented by DoIT.



PROCEDURE STEPS:

To Work The Address Cleansing Exception Report:

  1. Access Cypress Human Resources Inbox.

  2. Open UWHRR020 Address Cleansing Exception Report.

  3. Save as Excel file to secured network directory (not your c:\drive). 

  4. warning  Be mindful of where the Address Cleansing Exception Report is saved.  Always use a SECURED network directory.
  5. Sort file according to personal preferences. 

  6. Don't hesitate to contact the employee for their correct Home Address information.  Their preferred email is listed on the report.

Additional Tips For Working The Address Cleansing Exception Report:

  1. W-4 or insurance application forms are good source documents for address validation.

  2. It may be necessary to contact the employee directly for the correct address verification (use the preferred email address from this report).

  3. Use https://www.usps.com/ to check the address to see if it is acceptable by the post office.

  4. In the Modify a Person Component (Nav: Workforce Administration > Personal Information > Modify a Person > Contact Information), Enter just the street name, city and state to research what building numbers are valid or if an apartment number is required and the accepted range.

  5. Use MapQuest or Google maps to see if there is such a street. The view of the building may tell you if a unit or apartment number is needed.

  6. Use street addresses not building names.

  7. If the address is on a highway, be mindful it could be a State Highway or County Highway.

  8. Do not use abbreviations.

  9. Validate if direction is required (north, south, east or west) and if it should be at the beginning of the street name or at the end. In some cases there could be a street name with the directional as part of the name(eg. North Street).

  10. Foreign addresses will not be validated. However, make sure that the correct country code is listed for the address (don’t list USA as the country and enter a Spain address).

  11. As a last resort, White Pages on the web can be used. But remember that there could be many people with the same name living all over the United States, so it is no guarantee that you have the correct person that is your employee.

  12. If there is a street address and a Post Office address, use the street address on Address Line 1, then the post office box on Address Line 2. You must use the zip code for the post office box in this case. If you have the zip code of the street address, then do not list the post office box address.

  13. Addresses with appartment numbers should be entered in the Address 1 field using the following format: Street Number & Name and then the appartment number (eg. 123 Main St Apt 321). 


Sample Output:

AddressCleansingExceptionReport-SampleOutput.docx




ADDITIONAL RESOURCES:

Related KBs:

Related Links:
    • N/A



    Keywords:UWHRR020 SQR HRS-29228   Doc ID:30609
    Owner:Tom O.Group:Human Resource System (HRS)
    Created:2013-06-11 10:18 CSTUpdated:2017-02-23 15:35 CST
    Sites:Human Resource System (HRS)
    Feedback:  0   0