The following two exceptions table attributes are useful for city/state only lookup. Determining whether to use region, SCF, or ZIP Code limitations in the exceptions statement depends on whether you'll pass the input ZIP Code field with the city/state field. If you are not including a ZIP Code in the input, do not use a ZIP Code in the exceptions statement.
Note: In these examples, Finalist alters any word(s) located in the specified ZIP Code that contains the argument word.
Table 1. Sample Application of Exceptions Table Logic With IC Attribute
| Attribute |
Description |
| IC |
Insert the substitute word as the city before the argument state word. |
| Sample Application
Exception |
Use this type of alteration only if you're passing ZIP Codes in the ZIP Code field and passing the city/state field (since you only want to insert a city for certain ZIP Codes within the state). For example, a few records at ZIP Code 60104 have only IL in the city/state field. If you only use a city/state lookup for your file, this record would fail because the city is missing. Use the following exception statement to insert a city in your record:
L3IL BELLWOOD IC60104
This statement inserts the city BELLWOOD in all your IL records for the ZIP Code 60104. Function 7 is now able to code the address. Functions 4, 5, and 6 do not need a city name to code. |
Table 2. Sample Application of Exceptions Table Logic With ST Attribute
| Attribute |
Description |
| ST |
Insert this as the state. |
| Sample Application
Input
Exception |
If you perform a city/state-only lookup, some records might fail because the state name is missing. Use an exceptions table entry to insert the state for these records. Since identical city names exist in different states, it is safest to restrict this alteration to a specific SCF or ZIP Code.
22 E LAKE ST ADDISON 60101
L3ADDISON IL ST60101
The system uses IL for the state and your input city of ADDISON. The record codes. |
Table 3. Sample Application of Exceptions Table Logic With UD Attribute
| Attribute |
Description |
| UD |
Replace the argument word with a substitute and flag as a unit designator. |
| Sample Application
Exception |
You use the word LT as an abbreviation for the unit designator LOT. Finalist will leave the word spelled as LT but flag the word as a unit designator.
L1LT LT UD |