Tip: State Code Transformation





Number

0034

Submitting Entities

ALL

Add Date

Mar 1, 2019

Update Date

 

Update

 

Description

If the value in the state field is “AR” and

  • The associated USPS ZIP code is valid AND in the range of AR USPS ZIP codes, the value in the state field is transformed to FIPS code = “05”.

  • The associated USPS ZIP code is NOT valid but in the range of AR zip codes, transform state to “05”.

  • The associated USPS ZIP code is valid but NOT in the range of AR zip codes, transform state value to the state FIPS of that USPS ZIP code.

 If the value in the state field is a valid non-AR state and

 The ZIP code is a valid USPS ZIP code and the state value corresponds with the state value associated with that USPS ZIP code, transform state to the state FIPS code of that state.

  •  The ZIP code is a valid USPS ZIP code but the state value does NOT correspond with the state value associated with that USPS ZIP code, the state code should be moved without transformation.

  •  The ZIP code is NOT a valid USPS ZIP code, the state code should be moved without transformation.

  If the value in the state field is NOT a valid state code, transform to NULL.

Action / Resolution

Category 1

Transformation

Category 2

State codes

Tip / Issue

Tip