Topics Map > Human Resource System (HRS) > HRS Human Resources Administration

Address Cleansing in HRS


This document provides some background information about the Address Cleansing service that is running in HRS.

CLEAN_Address is a product developed by Runner EDQ that helps ensure valid addresses are entered into PeopleSoft in a standardized format. The service validates addresses against US Postal Service records in real time as data is entered and during a weekly batch process. UW-Madison's DoIT maintains this service.

Process Considerations:

  • Address Cleansing has not been implemented for Employee Self Service or Candidate Gateway, however addresses entered via Employee Self Service are validated through weekly batch processing.
You may click on the links below to navigate directly to a section:

Batch Process

The HRHRW_UW_CLN_ADR stream is scheduled to run weekly on Friday evenings.  It includes four processes.

1) BT_HR_UW_CLN_TRUNC Application Engine

  • Truncates the address cleansing exception report

2) BT_HR_UW_CLN_ADDR_HOME Application Engine

  • Cleanses home addresses
  • Produces an error report in PDF format

3) BT_HR_UW_CLN_ADDR_MAIL Application Engine

  • Cleanses mailing addresses
  • Produces an error report in PDF format

4) BT_HR_UWHRR020 SQR Report

Real-Time Processing

When an HRS user enters an address into HRS, the CLEANSE_Address process will run before the record is saved to format the address according to USPS guidelines.


If we receive reports that the real-time address cleansing service is not functioning, contact HRS DBAs and ask them to check or restart the listening service.  The service sometimes encounters problems after refreshes or PUM implementations.

Additional Resources

Related KBs:

Related Links:

Get Help

  • Click HERE to contact UW Shared Services or HERE for the Office of Technology Services (OTS) Helpdesk if you have any issues with these instructions.

Keywords:address cleansing, Runner HR, Human Resources HR, Human Resources   Doc ID:100941
Owner:tami e.Group:UW–Shared Services
Created:2020-04-21 12:03 CDTUpdated:2021-07-23 13:21 CDT
Sites:UW–Shared Services
Feedback:  0   0