GPGB_EE_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	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
3	GPGB_LOAN_ID	Character(20)	VARCHAR2(20) NOT NULL	Unique ID for employee loans
4	START_DATE	Date(10)	DATE NOT NULL	Start Date for Gen Standing PO
5	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
6	GPGB_LN_PRTY	Number(3,0)	SMALLINT NOT NULL	Loan Processing Priority
7	GPGB_LOAN_AMT	Number(9,2)	DECIMAL(8,2) NOT NULL	Initial Loan Amount
8	GPGB_LOAN_RPY_METH	Character(1)	VARCHAR2(1) NOT NULL	Loan Repayment Method - valid values are: A - Fixed amount per period P - Over a no. of periods A=Repay Fixed Amount Per Period P=Repay Over Number of Periods
9	GPGB_LOAN_RPY_PDS	Number(4,0)	SMALLINT NOT NULL	Loan repayment Periods
10	GPGB_LOAN_RPY_AMT	Number(9,2)	DECIMAL(8,2) NOT NULL	Loan Repayment Amount.
11	GPGB_LOAN_REPAID	Character(1)	VARCHAR2(1) NOT NULL	Loan Repaid indicator Y/N Table Edit Default Value: N
12	GPGB_LOAN_NO	Number(3,0)	SMALLINT NOT NULL	Loan Number automatically assigned when row inserted, it should be invisible to the user but will be used by the GP Pay Process