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. |
---|