GPIN_YE_F3A (SQL Table)	Index Back
Form 3A This record is used to setup the reference date of advance, amount and the number of days for non-contribution service for the Form 3A

GPIN_YE_F3A

(SQL Table)

Form 3A

This record is used to setup the reference date of advance, amount and the number of days for non-contribution service for the Form 3A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

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

3 GPIN_DT_FILED Date(10) DATE This field holds the date on which the employee has filed his claim for the trip he has made.

4 AMOUNT Signed Number(20,3) DECIMAL(18,3) NOT NULL Commuting Allowance Paid Per Cycle.

5 DAYS Number(3,0) SMALLINT NOT NULL Days

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
3	GPIN_DT_FILED	Date(10)	DATE	This field holds the date on which the employee has filed his claim for the trip he has made.
4	AMOUNT	Signed Number(20,3)	DECIMAL(18,3) NOT NULL	Commuting Allowance Paid Per Cycle.
5	DAYS	Number(3,0)	SMALLINT NOT NULL	Days