GPES_TX_CAL_DTL (SQL Table)	Index Back
Tax Calendar Month/s in which you would like calculate tax while running payroll process

GPES_TX_CAL_DTL

(SQL Table)

Tax Calendar

Month/s in which you would like calculate tax while running payroll process

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GPES_TAX_CALENDAR Character(3) VARCHAR2(3) NOT NULL Tax calendar. 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 GPES_MONTHCD Character(2) VARCHAR2(2) NOT NULL Month
01=01 - January
02=02 - February
03=03 - March
04=04 - April
05=05 - May
06=06 - June
07=07 - July
08=08 - August
09=09 - September
10=10 - October
11=11 - November
12=12 - December

4 GPES_TAX_CALC_RUN Character(1) VARCHAR2(1) NOT NULL Tax Calculation Process indicator. This field is used to populate the GP Write Array, which is used to generate the Tax Reports.
Y/N Table Edit
Default Value: N

5 GPES_MONTH Number(2,0) SMALLINT NOT NULL Month

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GPES_TAX_CALENDAR	Character(3)	VARCHAR2(3) NOT NULL	Tax calendar. 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	GPES_MONTHCD	Character(2)	VARCHAR2(2) NOT NULL	Month 01=01 - January 02=02 - February 03=03 - March 04=04 - April 05=05 - May 06=06 - June 07=07 - July 08=08 - August 09=09 - September 10=10 - October 11=11 - November 12=12 - December
4	GPES_TAX_CALC_RUN	Character(1)	VARCHAR2(1) NOT NULL	Tax Calculation Process indicator. This field is used to populate the GP Write Array, which is used to generate the Tax Reports. Y/N Table Edit Default Value: N
5	GPES_MONTH	Number(2,0)	SMALLINT NOT NULL	Month