Process Considerations:
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.
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.
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.
Related KBs:
Related Links: