File-Based Address Validation
Use the File-Based Address Validation flow to validate multiple employee addresses after you've modified them.
This flow does three things.
-
It validates the addresses for payroll and tax purposes.
-
Validates line 1 of the addresses
-
Formats the addresses to USPS standards
-
Adds additional or missing address attributes
-
-
It produces a report of these recommendations in output suitable for viewing in a spreadsheet application, such as Microsoft Excel.
For invalid addresses, this file provides suggested alternates, including:
-
Payroll tax jurisdiction info
-
School districts and Political Subdivisions (PSDs) for Pennsylvania jurisdictions
These columns display as null for non-Pennsylvania jurisdictions.
-
-
If the flow finds any missing Geocodes, such as invalid state-county or state-county-city combinations, it automatically adds them to the TCA or localization tables. For further info, see Geographies for the US in the Help Center.
To run this report:
-
From My Client Groups, click Payroll.
-
Click Submit a Flow.
-
Select your US legislative data group
-
Search for and select File-Based Address Validation.
Before You Start
You must have prepared an input file in CSV format with the following columns.
-
StreetAddress1
-
City
-
State
-
County
-
ZIP Code
-
Additional Details
Use this column to provide notes to help you track this info. The flow doesn't transfer any of this content into the application.
Report Parameters
Upload File
Click this button to select and upload your CSV file.
Content ID
After you select and upload your CSV file, this field automatically displays your UCM ID.
Process Configuration Group
Select a process configuration group if needed.
Report Output
This flow produces an output file suitable for viewing in a spreadsheet application, such as Microsoft Excel. Use this file to identify invalid address combinations, so you can correct them.
If there are many corrections, consider building an HCM Data Loader file to upload the changes, rather than making individual edits.
The info in this file has the following organization.
Section |
Columns and description |
---|---|
Employee Address |
This section describes the address data you input into the flow. It includes these columns.
|
Validation Details |
This section provides the address data after it has been verified and corrected. It includes these columns.
|