USPS comparison

Compares an alphanumeric house number from a data source to two alphanumeric house number intervals from USPS ZIP Code files or other reference sources that can contain alphanumeric ranges. Odd-even parity control information such as the USPS ZIP+4 control column is required.

The USPS comparison requires that the data source contains the column names for the house number and the reference source contains a low house number range, a high house number range, and a control column, indicating the parity of the house number range.

Frequency information is not taken into account when this match comparison is used but a two-source match requires four input streams. If you use this match comparison with a Two-source Match stage job, create two dummy file inputs instead of files that contain frequency information.

Required Columns

The following data source and reference source columns are required:

  • Data. The house number from the data source.
  • Reference. (1) The ZIP+4 column primary low house number for the beginning of the range from the reference source.
  • Reference. (2) The ZIP+4 column primary high house number for the ending of the range from the reference source.
  • Reference. (Control) The odd/even parity for the range defined with (1) and (2).

The control information from the USPS ZIP+4 code is:

  • O. The range represents only odd house numbers.
  • E. The range represents only even house numbers.
  • B. The range represents all numbers (both odd and even) in the interval.
  • U. The parity of the range is unknown.