11 code 104 physical location zip format check

© 2019 - State of Utah - Department of Technology Services
Jump to navigation Jump to search

Physical Location Zip Code Format Check - Code 104

This edit verifies the format of the zip code contained in the physical location address block. Prior to beginning the edit, a series of exclusions are processed to determine which records are immune to zip code editing. The first is Federal ownership (‘10’), which are exempt from all physical address edits. Second, county codes of ‘996’ and ‘998’ (for out-of-state and foreign locations) are bypassed. Third, the account must exceed the cutoff AME tolerance found in the PK005 record of the Lookup File. Fourth, the State code of the physical address cannot represent an APO (‘AA’, ‘AE’, or ‘AP’), nor a foreign location outside of Canada (‘ZZ’). Fifth, addresses with all blank fields (zip code, State code, city, and street address lines) in the physical address are skipped.


For the accounts that are still eligible for zip code editing after the five cases listed above have proven to be false, there are two possible forms of the edit. Canadian addresses (with a State code of “CN”) are flagged if the zip code is numeric (since Canada uses alternating alphabetic and numeric characters throughout its six-byte zip code field). For all other accounts (with a State code matching one of the 50 States, or DC, PR, VI, AS, or GU), the 5-digit zip code should be numeric, and not equal to ‘99999’ nor ‘00000’. If the account fails the applicable edit exception, it will be listed on the edit exception report with the physical location zip code underscored.


An additional check is conducted on the ZIP+4 extension to the physical location zip code, if the standard 5-digit zip code passes the initial edit. This is also split between the Canadian and United States addresses. A Canadian (with “CN” State code) physical location address should not have a blank ZIP+4 field, but it can also not be fully numeric. It is supposed to show one numeric digit followed by three spaces. The check for this states that anything less than “0- - -” or greater than “9- - -” (where each hyphen represents a space) is unusable. For a physical address in the U.S., the ZIP+4 field should be blank or fully numeric, and cannot equal ‘9999’. If a contradiction to these conditions is found, the zip code is still flagged with the same Code 104 error identified. BLS classification: C.1.8. EXPO “G” code: C104.


Related Links