Use this field level rule to translate a numeric ISO code retrieved from an extract record into its equivalent state text. This rule supports overflow.
Code |
State |
Code |
State |
Code |
State |
01 |
Alabama |
54 |
Alaska |
02 |
Arizona |
03 |
Arkansas |
04 |
California |
05 |
Colorado |
06 |
Connecticut |
07 |
Delaware |
08 |
District of Columbia |
09 |
Florida |
10 |
Georgia |
52 |
Hawaii |
11 |
Idaho |
12 |
Illinois |
13 |
Indiana |
14 |
Iowa |
15 |
Kansas |
16 |
Kentucky |
17 |
Louisiana |
18 |
Maine |
19 |
Maryland |
20 |
Massachusetts |
21 |
Michigan |
22 |
Minnesota |
23 |
Mississippi |
24 |
Missouri |
25 |
Montana |
90 |
Nationwide |
26 |
Nebraska |
27 |
Nevada |
28 |
New Hampshire |
29 |
New Jersey |
30 |
New Mexico |
31 |
New York |
32 |
North Carolina |
33 |
North Dakota |
34 |
Ohio |
35 |
Oklahoma |
36 |
Oregon |
37 |
Pennsylvania |
58 |
Puerto Rico |
38 |
Rhode Island |
39 |
South Carolina |
40 |
South Dakota |
41 |
Tennessee |
42 |
Texas |
43 |
Utah |
44 |
Vermont |
45 |
Virginia |
46 |
Washington |
47 |
West Virginia |
48 |
Wisconsin |
49 |
Wyoming |
|
|
© Copyright 2014, Oracle and/or its affiliates. All rights reserved. Legal notices.