Field values for STATE in for country USA from the STATE_TBL which exists in both the Campus Solutions and Human Resources databases. This representative sample also includes some tax rates. There are over 1800 values in the STATE field in each STATE_TBL.
STATE | |
Field Value | Description |
$E | |
AL | Alabama |
AK | Alaska |
AS | American Samoa |
$UAS | American Samoa Federal |
AZ | Arizona |
AR | Arkansas |
AA | Armed Forces Americas |
AE | Armed Forces Europe |
AP | Armed Forces Pacific |
CA | California |
CO | Colorado |
CT | Connecticut |
DE | Delaware |
DC | District of Columbia |
$U | Federal |
FL | Florida |
FC | Foreign Country |
GA | Georgia |
GU | Guam |
$UGU | Guam Federal |
HI | Hawaii |
ID | Idaho |
IL | Illinois |
IN | Indiana |
IA | Iowa |
K1 | KY-Hazard Tiered Tax |
K0 | KY-Kenton County Tiered Tax |
K2 | KY-Mayfield Tiered Tax |
KS | Kansas |
KY | Kentucky |
LA | Louisiana |
Z3 | MD 1.25 % local tax |
Z4 | MD 2.25 % local tax |
ZD | MD 2.60 % local tax |
ZC | MD 2.65 % local tax |
ZF | MD 2.80 % local tax |
Z7 | MD 2.85 % local tax |
ZH | MD 2.90 % local tax |
ZL | MD 3.00 % local tax |
Z8 | MD 3.05 % local tax |
ZA | MD 3.10 % local tax |
ZK | MD 3.15 % local tax |
Z9 | MD 3.20 % local tax |
ZB | MD resident works in DE |
ME | Maine |
MD | Maryland |
MA | Massachusetts |
MI | Michigan |
MN | Minnesota |
MS | Mississippi |
MO | Missouri |
MT | Montana |
NE | Nebraska |
NV | Nevada |
NH | New Hampshire |
NJ | New Jersey |
NM | New Mexico |
NY | New York |
Z1 | New York, New York |
NC | North Carolina |
ND | North Dakota |
MP | Northern Mariana Islands |
O1 | OR-Multnomah Co Income Tax |
OH | Ohio |
OK | Oklahoma |
OR | Oregon |
PA | Pennsylvania |
PR | Puerto Rico |
$UPR | Puerto Rico Federal |
Z5 | Reserved |
Z6 | Reserved |
ZE | Reserved |
ZG | Reserved |
ZI | Reserved |
ZJ | Reserved |
RI | Rhode Island |
SC | South Carolina |
SD | South Dakota |
TN | Tennessee |
TX | Texas |
UT | Utah |
VT | Vermont |
VI | Virgin Islands |
$UVI | Virgin Islands Federal |
VA | Virginia |
WA | Washington |
WV | West Virginia |
WI | Wisconsin |
WY | Wyoming |
Z2 | Yonkers, New York |