GPIN_SSTD_ADMIN (SQL Table)	Index Back
Store the Present Tax year Table to store the Current tax year, Month to be notified and the Item to be notified about.

GPIN_SSTD_ADMIN

(SQL Table)

Store the Present Tax year

Table to store the Current tax year, Month to be notified and the Item to be notified about.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GPIN_TAX_YEAR Number(4,0) SMALLINT NOT NULL This field is used to store the Tax Year.

2 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

3 GPIN_TD_NOTIFY_OPT Character(2) VARCHAR2(2) NOT NULL This Field stores the option of the item that has to be notified to employees selected on the Administer Self Service declaration page. The option can be either Freeze date or Open period
10=Open Period
20=Freeze Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GPIN_TAX_YEAR	Number(4,0)	SMALLINT NOT NULL	This field is used to store the Tax Year.
2	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
3	GPIN_TD_NOTIFY_OPT	Character(2)	VARCHAR2(2) NOT NULL	This Field stores the option of the item that has to be notified to employees selected on the Administer Self Service declaration page. The option can be either Freeze date or Open period 10=Open Period 20=Freeze Date