Address Cleansing in HRS
Overview
This document provides some background information about the Address Cleansing service that is running in HRS.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.
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: