GPES_NRP_TX8_VW (SQL View)	Index Back
Tax Location Codes Payroll's Tax Location Table contains the tax location code relating to State/Local tax jurisdictions.

GPES_NRP_TX8_VW

(SQL View)

Tax Location Codes

Payroll's Tax Location Table contains the tax location code relating to State/Local tax jurisdictions.

SELECT GPES_TAX_LOCATION , EFFDT , EFF_STATUS , DESCR , DESCRSHORT , CURRENCY_CD , GPES_MILEAGE_RT , GPES_MAINT_DOM , GPES_MAINT_INTL , GPES_MAINT_FLG_DOM , GPES_MAINT_FLG_INT , GPES_NIGHT_DOM , GPES_NIGHT_INTL , GPES_PIN_BR1_NUM + 50000000 , GPES_PIN_BR2_NUM + 50000000 , GPES_PIN_BR3_NUM + 50000000 , GPES_MAX_DEPNT_AGE , GPES_IRNR_PCT FROM PS_GPES_TAX_LOCATN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GPES_TAX_LOCATION Character(5) VARCHAR2(5) NOT NULL Fiscal Territory. This field is used to populate the GP Write Array, which is used to generate the Tax Reports.

2 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
Default Value: A

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description

5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

7 GPES_MILEAGE_RT Number(6,2) DECIMAL(5,2) NOT NULL Statutory rate for mileage

8 GPES_MAINT_DOM Number(9,2) DECIMAL(8,2) NOT NULL Statutory rate for domestic maintenance

9 GPES_MAINT_INTL Number(9,2) DECIMAL(8,2) NOT NULL Statutory rate for non-domestic maintenance

10 GPES_MAINT_FLG_DOM Number(9,2) DECIMAL(8,2) NOT NULL Domestic flight maintenance

11 GPES_MAINT_FLG_INT Number(9,2) DECIMAL(8,2) NOT NULL International flight maintenance

12 GPES_NIGHT_DOM Number(9,2) DECIMAL(8,2) NOT NULL Statutory rate for domestic night stay

13 GPES_NIGHT_INTL Number(9,2) DECIMAL(8,2) NOT NULL Statutory rate for non-domestic night stay

14 GPES_PIN_BR1_NUM Number(8,0) INTEGER NOT NULL Bracket Pin Num.

15 GPES_PIN_BR2_NUM Number(8,0) INTEGER NOT NULL Bracket Pin Num.

16 GPES_PIN_BR3_NUM Number(8,0) INTEGER NOT NULL Bracket Pin Num.

17 GPES_MAX_DEPNT_AGE Number(3,0) SMALLINT NOT NULL Maximum dependent age

18 GPES_IRNR_PCT Number(5,2) DECIMAL(4,2) NOT NULL Non-resident Withholding

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GPES_TAX_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Fiscal Territory. This field is used to populate the GP Write Array, which is used to generate the Tax Reports.
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
6	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
7	GPES_MILEAGE_RT	Number(6,2)	DECIMAL(5,2) NOT NULL	Statutory rate for mileage
8	GPES_MAINT_DOM	Number(9,2)	DECIMAL(8,2) NOT NULL	Statutory rate for domestic maintenance
9	GPES_MAINT_INTL	Number(9,2)	DECIMAL(8,2) NOT NULL	Statutory rate for non-domestic maintenance
10	GPES_MAINT_FLG_DOM	Number(9,2)	DECIMAL(8,2) NOT NULL	Domestic flight maintenance
11	GPES_MAINT_FLG_INT	Number(9,2)	DECIMAL(8,2) NOT NULL	International flight maintenance
12	GPES_NIGHT_DOM	Number(9,2)	DECIMAL(8,2) NOT NULL	Statutory rate for domestic night stay
13	GPES_NIGHT_INTL	Number(9,2)	DECIMAL(8,2) NOT NULL	Statutory rate for non-domestic night stay
14	GPES_PIN_BR1_NUM	Number(8,0)	INTEGER NOT NULL	Bracket Pin Num.
15	GPES_PIN_BR2_NUM	Number(8,0)	INTEGER NOT NULL	Bracket Pin Num.
16	GPES_PIN_BR3_NUM	Number(8,0)	INTEGER NOT NULL	Bracket Pin Num.
17	GPES_MAX_DEPNT_AGE	Number(3,0)	SMALLINT NOT NULL	Maximum dependent age
18	GPES_IRNR_PCT	Number(5,2)	DECIMAL(4,2) NOT NULL	Non-resident Withholding