Tip: State Code Transformation

0034

ALL

Mar 1, 2019

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.

Transformation

State codes

Tip