changes.mady.by.user Kathleen Hart
Saved on Feb 19 2021
changes.mady.by.user Kenley Money
Number
0033
Submitting Entities
ALL
Add Date
01 Mar 2019
Update Date
Update
Description
County FIPS codes are assigned based on valid USPS ZIP codes.
If the USPS ZIP code is invalid, county value is transformed to FIPS based on a state and county name match.
If the USPS ZIP code is invalid the value is replaced with NULL.
Action / Resolution
Category 1
Transformation
Category 2
County FIPS codes
Tip / Issue
Tip