Address Cleansing in HRS

Overview

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.

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

• Address cleansing exception report
• Outputs to Cypress
• See Running the Address Cleansing Exception Report in HRS for instructions on using this 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:

• Running the Address Cleansing Exception Report in HRS
• Add a Person Job Aid for HRS
• Adding a Person in HRS
• Adding a Student Help Person in HRS
• Processing the WED Missing Home Addresses Report in HRS
  

Related Links:

• Runner EDQ
• Cypress