πŸ‡ΊπŸ‡Έ US Address Validation Status Codes – Decoding Guide

 

1️⃣ HRX_UV – User Verified (Manual Override)

CodeMeaningAction Required
HRX_UV01Address marked as user verified (not validated by service provider)⚠ Review carefully. Consider re-validating unless intentionally overridden.

πŸ‘‰ Used when users bypass USPS validation.


2️⃣ HRX_US_AC – Address Corrections (System Adjustments)

These indicate automatic corrections made by the validation service.

CodeWhat Was CorrectedRisk Level
AC01ZIP Code added/changedMedium
AC02State added/changedHigh
AC03City added/changedHigh
AC09Dependent locality added/changedLow
AC10Street spelling correctedLow
AC11Street suffix corrected (St → Rd)Low
AC12Direction corrected (N → NW)Medium
AC13Unit type corrected (STE → APT)Medium
AC14Unit number added/changedHigh
AC16County added/changedLow
AC18PO Box correctedHigh
AC19Premise type correctedMedium

Governance Tip

If State, City, ZIP, Unit Number are auto-corrected → review before committing Final mode.


3️⃣ HRX_US_AE – Address Errors (Must Be Fixed)

These are hard validation failures.
Addresses with these should NOT be committed in Final mode.


πŸ”΄ Critical Structural Errors

CodeMeaningAction
AE01ZIP missing/incorrectFix ZIP
AE07Missing State/City/ZIPComplete address
AE10Street number not foundCorrect house number
AE11Street number missingEnter house number

These are mandatory fields for payroll tax accuracy.


🟠 Matching Failures

CodeMeaning
AE02Street not found or too many matches
AE03Direction + suffix combination ambiguous
AE05Insufficient info to match

These require clarification of street or direction details.


🟑 Unit / Box Issues

CodeMeaning
AE08Unit number not found
AE09Unit number missing
AE12PO/RR/HC Box not found
AE13PO/RR/HC Box missing
AE14Private mailbox missing

Important for apartment, suite, CMRA addresses.


4️⃣ HRX_US_AV – Validation Quality Level

These indicate how precisely the address was verified.


Lower Precision (Partial Validation)

CodeVerified To
AV11 / AV21State only
AV12 / AV22City only
AV13 / AV23Street name
AV14 / AV24Street number / Premise

AV11–14 = service could verify
AV21–24 = system confirmed verification level


Highest Precision

CodeMeaning
AV25Verified to unit number (Apartment/Suite/PO Box)

✅ This is the gold standard for payroll and taxation accuracy.


5️⃣ HRX_US_GS – Geospatial Accuracy

These indicate how precisely latitude/longitude was determined.


CodeGeocode LevelAccuracy
GS01Street levelMedium
GS02NeighborhoodMedium-Low
GS03CommunityLow
GS04StateVery Low
GS05Rooftop/buildingVery High
GS06Within property boundaryHighest

For compliance-heavy industries, aim for GS05 or GS06.


🎯 Recommended Operational Standard

CategoryRecommended Condition Before Final Mode
AE Codes❌ None remaining
AV CodesPrefer AV24 or AV25
GS CodesPrefer GS05 or GS06
AC CodesReview major corrections

πŸ” Decision Matrix for Payroll Readiness

ScenarioCan You Move to Final Mode?
AE present❌ No
Only AV11–AV13⚠ Review
AV24 + GS05✅ Yes
AC02 (State changed)⚠ Manual review
UV01 only⚠ Consider re-validation

🏁 Maturity Model

Basic Level

  • No AE errors

  • AV24 minimum

Controlled Level

  • AV25 preferred

  • GS05+ geocoding

  • No major AC corrections

Optimized Level

  • Scheduled quarterly validation

  • No UV01 overrides

  • Exception reporting enabled

Comments

Popular posts from this blog

Query to get Salary Change details in Fusion HCM

Oracle Fusion HCM - Enhancements to Summary of Changes and History Sections in Redwood Workforce Structures Pages

🌿 HCM Redwood Applications: Default & Validate Fields