Address Cleansing in HRS

Overview

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

Process Considerations:


You may click on the links below to navigate directly to a section:


Background

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.


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.

Troubleshooting

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 - Service Operations Department or HERE for the UWSS IT HelpDesk if you have any issues with these instructions.