GPUS_NRP_LN2_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	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
5	GPUS_LOAN_ID	Character(18)	VARCHAR2(18) NOT NULL	Loan ID
6	EFFDT	Date(10)	DATE	Effective Date
7	INSTANCE	Number(3,0)	SMALLINT NOT NULL	Instance Number
8	PRC_ORDER	Number(3,0)	SMALLINT NOT NULL	Process Order
9	GPUS_ENDDT	Date(10)	DATE	GPUS_ENDDT
10	GPUS_LOAN_AMT	Number(19,6)	DECIMAL(18,6) NOT NULL	Loan Amount
11	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
12	FREQUENCY_OPTN	Character(2)	VARCHAR2(2) NOT NULL	Frequency Option CP=Use Calendar Period Frequency ED=Use Element Frequency SP=Use Specified Frequency
13	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.
14	GCTL_CND_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Generation Control Options E=Use Element Generation Control N=No Generation Control S=Specified Generation Control
15	PIN_GCTL_NUM	Number(8,0)	INTEGER NOT NULL	Generation Control Number
16	ARR_PYBK_AMT_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Payback Option A=Use Specified Amount E=Use Element Payback Amount N=No Limit
17	ENTRY_TYPE_ARR_AMT	Character(3)	VARCHAR2(3) NOT NULL	entry type array amount
18	PIN_ARR_AMT_NUM	Number(8,0)	INTEGER NOT NULL	Arrears Amount element number
19	ARR_PYBK_AMT	Number(19,6)	DECIMAL(18,6) NOT NULL	Maximum Arrears Payback Amount