Address Validation Process Flow

If you have done any of the following, you must validate your address data prior to using any payroll features.

• Switched the product setting from Payroll Interface or Human Resources or None to Payroll

• Made changes to addresses while address validation was disabled

• Never have enabled address validation

Use the Address Validation Process flow to verify and update all active Person and Location HCM addresses. It doesn't process address records associated with candidates, contingent workers, or contacts.

This flow validates and standardizes all active addresses in your legislative data group (LDG) up to Address Line 1.

To run this process:

1. From My Client Groups, click Payroll.

2. Click Submit a Flow.

3. Select your US legislative data group (LDG).

4. Search for and select Address Validation Process.

Before you start

1. Start the Features by Country or Territory task.

2. Under the US Legislation, confirm the address validation method is either Full address verification service or Address verification without search.

Flow parameters

Address Type

Select the HCM work area of the addresses you are validating, Person or Location.

You can select only one address type per flow run. To process all addresses, you must run this flow twice, once for each type.

Verification Status

Select the verification status of the addresses you want to check.

Value	What it does
Unverified	Processes addresses that are in an unverified status. Select this option the first time you run this flow. An address record is unverified if it is missing any of these attributes. Geospatial coordinates (latitude or longitude) Validation status code This happens when an address hasn't been previously validated.
Person address records by object group	Processes only Person addresses within a specified payroll relationship group, regardless of their verification status.
User-verified address records	Processes only addresses having the HRX_UV01 validation status code in the HCM address backend table (PER_ADDRESSES_F). This status applies to: Addresses the user has defined manually Addresses uploaded with HDL without verifying them at the object or file levels

Modified Address Date From and Date To

The flow processes all addresses modified within the range of these dates. This is based the address’s LAST_UPDATE_DATE in the HCM address table.

Use these parameters to process addresses you've changed since the last time you ran this flow.

Leave blank to validate address records that are active on or after January 1 of the current calendar year.

Mode

Run this process initially in Draft mode, and then review the output report to see the proposed address changes and validation status messages.

Once you have resolved any problems and agree with the changes, run the flow again in Final mode. This commits the verified address record changes.

Payroll Relationship Group

Use payroll relationship groups to process address record for a subset of addresses associated with person records.

Use this parameter only when processing addresses with the Person address records by object group verification status.

Person

Selecting a person here causes the flow to validate only addresses associated with that person.

Note:

If you enter a value in this field, you must select the Person address type.

Location

Selecting a location here causes the flow to validate only addresses associated with that location.

Note:

If you enter a value in this field, you must select the Location address type.

Flow output

This flow produces two output reports suitable for viewing in a spreadsheet application, such as Microsoft Excel.

Note:

The Tax Jurisdictions Report is available to only Payroll and Payroll Interface extensions.

Address Validation Report

Use this report to review the addresses the process validated along with any messages it generated.

Section	Columns and descriptions
Person or Location Details	Describes the person or location address data. It includes: Person Name | Location Name Either a person name or location definition name, depending on your selections at process run time. Person Number | Location Code Either a person number or location code, depending on your selections at process run time. Person Type User-defined person types associated with the Person record.
Source Address Attributes	Describes the source address data. It includes: Address Usage Type Effective Start Date Effective End Date Address Line 1 Address Line 2 City County State ZIP Code
Validated Address Attributes	Describes the validated address data, including suggested changes. It includes: Address Line 1 Includes the premises number, such as house or building, followed by the street name. Address Line 2 Includes premise unit number info like suite or apartment. City County State ZIP Code ZIP + 4 Longitude Latitude Validation Status Codes These codes are captured in backend address table along with other address attributes. Validation Status Messages These messages describe the codes returned by the flow. It doesn't store them in the backend address table.

Tax Jurisdictions Report

Use this report to review the derived local tax jurisdictions, such as the tax districts, school districts, Pennsylvania political subdivision (PSD) codes, and so on. The process identifies these jurisdictions by comparing addresses’ geospatial coordinates (latitude, longitude) against the shape data repository.

Section	Columns and descriptions
Person or Location Details	Describes the person or location address data. It includes: Person Name | Location Name Either a person name or location definition name, depending on your selections at process run time. Person Number | Location Code Either a person number or location code, depending on your selections at process run time. Person Type User-defined person types associated with the Person record.
Source Address Attributes	Describes the source address data. It includes: Address Usage Type Effective Start Date Effective End Date Address Latitude Longitude Validation Status Codes Displays the status of geospatial coordinates for the address.
Derived Local Jurisdictions	Identifies the local jurisdictions associated with an address. County This derived county may not be the same as the USPS address's county. City This derived city may not be the same as the USPS address's city. Within City Limits Identifies if an address is within or outside city limits. Tax District Taxing townships or zones that impose local taxes, such as Ohio Joint Economic Development Districts (JEDDs) and Joint Economic Development Zones (JEDZs). School District Taxing school districts in Ohio, Pennsylvania, and Kentucky. PA PSD Code Derived Pennsylvania political subdivision (PSD) code based on the county, city or tax district, and school district combination. Special Tax District Addresses within the Oregon Portland Metropolitan Area.