GPES_ADV_LOAN

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
3	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
4	ENTERED_DT	Date(10)	DATE	Entered on Default Value: %DATE
5	GPES_ADLN_AMT	Number(11,2)	DECIMAL(10,2) NOT NULL	Advance/loan amount
6	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: EUR Prompt Table: CURRENCY_CD_TBL
7	GPES_INTEREST	Number(6,2)	DECIMAL(5,2) NOT NULL	Loan company interest rate
8	GPES_STATRY_INT	Number(6,2)	DECIMAL(5,2) NOT NULL	Statutory interest rate Default Value: GPES_STATUTORY.GPES_STATRY_INT
9	GPES_ADVLOAN_OPT	Character(1)	VARCHAR2(1) NOT NULL	Advance/Loan option 1=Advance 4=Loan Default Value: 1
10	GPES_PYMNT_DT	Date(10)	DATE	Advance/Loan payment date or EFT Payment Date
11	GPES_CALC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Advance/Loan calculation type option 1=Flat Amount 4=End Date 7=Elapsed Period Default Value: 1
12	GPES_DED_BEG_DT	Date(10)	DATE	Advance/Loan deduction begin date
13	GPES_DED_END_DT	Date(10)	DATE	Advance/Loan deduction end date
14	GPES_DED_AMT	Number(11,2)	DECIMAL(10,2) NOT NULL	Advance/Loan repayment deduction amount
15	GPES_ELPSED_PD	Number(3,0)	SMALLINT NOT NULL	Number of loan repayments
16	GPES_TAKE_XTRPD	Character(1)	VARCHAR2(1) NOT NULL	Advance/Loan repayment at extra periods option Y/N Table Edit Default Value: N
17	GPES_OVRD_REPAY	Character(1)	VARCHAR2(1) NOT NULL	Override repayments flag. Y/N Table Edit
18	GPES_LAST_REPAY_CB	Character(1)	VARCHAR2(1) NOT NULL	Last repayment amount greater than loan defined repayment amount option. Y/N Table Edit Default Value: Y