GPUS_TAXLOC_DTL(SQL Table) |
Index Back |
---|---|
Tax Location DetailTax Location Detail |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | GPUS_TAX_LOC_CD | Character(10) | VARCHAR2(10) NOT NULL | Tax Location |
2 | STATE | Character(6) | VARCHAR2(6) NOT NULL |
State
Prompt Table: GPUS_STATE_VW |
3 | GPUS_AK_AREA_CD | Character(2) | VARCHAR2(2) NOT NULL |
Alaska Area Code
20=Marine 31=North Slope Borough 33=Northwest Arctic Borough 34=Nome 41=Yukon-Koyukuk 44=Fairbanks Borough 46=Southeast Fairbanks 47=Denali 50=Dillingham 51=Wade Hampton 52=Bethel 55=Bristol Bay Borough 57=Aleutians East Borough 58=Aleutians West 59=Lake and Peninsula Borough 61=Matanuska-Susitna Borough 62=Anchorage Borough 71=Kenai Peninsula Borough 73=Kodiak Island Borough 75=Valdez-Cordova 81=Skagway-Yakutat-Angoon 85=Haines Borough 86=Juneau Borough 87=Sitka Borough 91=Wrangell-Petersburg 93=Prince of Wales-Outer Ketchikn 95=Ketchikan Borough 99=Outside of Alaska |
4 | GPUS_LOCALITY | Character(3) | VARCHAR2(3) NOT NULL |
locality
Prompt Table: GPUS_LOCAL_TAX |
5 | GPUS_LOCALITY_LINK | Character(10) | VARCHAR2(10) NOT NULL | other work locality |