GPMY_NRP_LN_AD

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GP_PKG_ID	Character(10)	VARCHAR2(10) NOT NULL	Field used for element packaging
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
4	GPMY_LN_CD	Character(18)	VARCHAR2(18) NOT NULL	Loan Code
5	GPMY_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
6	EFFDT	Date(10)	DATE	Effective Date
7	END_DT	Date(10)	DATE	end date
8	GPMY_LN_TOT_AMT	Number(13,2)	DECIMAL(12,2) NOT NULL	Loan Total Amount
9	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
10	GPMY_PERCENTAGE	Number(6,2)	DECIMAL(5,2) NOT NULL	Percentage
11	GPMY_LN_INST_AMT	Number(13,2)	DECIMAL(12,2) NOT NULL	Installment Amount
12	CURRENCY_CD1	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
13	GPMY_LN_INST_NBR	Number(3,0)	SMALLINT NOT NULL	Loan Installment Number
14	GPMY_LN_RCV_TER	Character(1)	VARCHAR2(1) NOT NULL	Active Recovery on Termination
15	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
16	FREQUENCY_ID	Character(5)	VARCHAR2(5) NOT NULL	Defines a frequency and a set of parameters used for frequency conversion. Typically, these frequencies reflect how often an event occurs. Some examples are compensation frequency and pay frequency.
17	COMMENTS	Long Character	CLOB	Comment