Tip: County Name / FIPS Code Transformation





Number

0033

Submitting Entities

ALL

Add Date

Mar 1, 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