Address Cleansing in HRS

Overview

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

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

• 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