GPUS_TAXLOC_DTL

(SQL Table)
Index Back

Tax Location Detail

Tax 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