GPIN_TD_NFY_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	GPIN_TAX_YEAR	Number(4,0)	SMALLINT NOT NULL	This field is used to store the Tax Year.
4	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
5	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
6	GPIN_NOTIFY_LVL	Character(2)	VARCHAR2(2) NOT NULL	Used to store the notify level where an Employee listed is on the Notification page.
7	END_DT	Date(10)	DATE	end date
8	GPIN_TD_OPEN_FROM	Character(2)	VARCHAR2(2) NOT NULL	This is to store the start day of th Open period
9	GPIN_TD_OPEN_TILL	Character(2)	VARCHAR2(2) NOT NULL	This is to store the End date of the Open period.
10	GPIN_TD_FREEZE_DT	Date(10)	DATE	This field is for storing the Freeze date/cut off date at different levels- Employee, Pay group and Pay entity.
11	GPIN_SS_TD_ENABLE	Character(1)	VARCHAR2(1) NOT NULL	Enable Self service. N=No Y=Yes Default Value: N
12	GPIN_TD_NOTIFY_IND	Character(1)	VARCHAR2(1) NOT NULL	This field is used for storing the selection of rows for being notified about either Open period or Freeze date. N=N Y=Y
13	GPIN_OPN_NOTIFY_TS	Date(10)	DATE	Used to store the date when that particular item on the Adminster SS declarations page, was notified of its Open period.
14	EMAIL_ADDR	Character(70)	VARCHAR2(70) NOT NULL	Email Address
15	NAME_DISPLAY	Character(50)	VARCHAR2(50) NOT NULL	Display Name - name formatted for Display based on the Country