GPDE_LN_SETUP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
3	INSTANCE	Number(3,0)	SMALLINT NOT NULL	Instance Number Default Value: 1 Prompt Table: GPDE_LN_SETUP_V
4	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
5	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY Prompt Table: CURRENCY_CD_TBL
6	GPDE_LN_AMT	Number(11,2)	DECIMAL(10,2) NOT NULL	Loan amount
7	GPDE_LN_INTEREST	Number(6,2)	DECIMAL(5,2) NOT NULL	Loan company interest rate Default Value: 0
8	GPDE_LN_PAYOUT_DT	Date(10)	DATE NOT NULL	Loan pay-out date. Date Loan was payed out to employee
9	GPDE_LN_CALC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	/Loan calculation type option 1=Flat Amount Repayment 2=Flat Amount Capital 4=End Date 7=By Periods Default Value: 4
10	GPDE_LN_DED_BEG_DT	Date(10)	DATE NOT NULL	Loan deduction begin date
11	GPDE_LN_DED_END_DT	Date(10)	DATE	Loan deduction end date
12	GPDE_LN_DED_AMT	Number(10,2)	DECIMAL(9,2) NOT NULL	Loan repayment deduction amount
13	GPDE_LN_ACTIVE	Character(1)	VARCHAR2(1) NOT NULL	yes/no, defines whether a loan is active or not active. Will be use by Payroll processing to determine whether a monthly payment has to be deducted Y/N Table Edit Default Value: Y
14	ENTERED_DT	Date(10)	DATE	Entered on
15	GPDE_LN_STOP_DESCR	Character(200)	VARCHAR2(200) NOT NULL	Loans - Description for stopped loans
16	GPDE_LN_PMT_PDS	Number(3,0)	SMALLINT NOT NULL	Number of loan repayment periods Default Value: 1
17	GPDE_LN_ACCT	Character(50)	VARCHAR2(50) NOT NULL	Ger Loans - Account
18	GPDE_LN_INVEST	Character(50)	VARCHAR2(50) NOT NULL	Loans - Investment number
19	GPDE_LN_SALIK_INTR	Number(6,2)	DECIMAL(5,2) NOT NULL	Loan company interest rate Default Value: 5