GPDE_ALDLT_NRAD

#	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	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
4	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
5	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
6	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
7	RSLT_SEG_NUM	Number(4,0)	SMALLINT NOT NULL	Result Segment Number
8	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
9	ENTRY_TYPE_ELEM	Character(3)	VARCHAR2(3) NOT NULL	entry type element
10	CALC_DELTA_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Amount Delta
11	UNIT_DELTA_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Unit Delta
12	BASE_DELTA_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Base Delta
13	REPLACE_IND	Character(1)	VARCHAR2(1) NOT NULL	Replace Indicator
14	FORWARD_IND	Character(1)	VARCHAR2(1) NOT NULL	Y/N indicates whether the delta from a retroactive recalc should be forwarded into the current calculation or not
15	RTO_MATCH_ACTN	Character(1)	VARCHAR2(1) NOT NULL	Retro Delta Match Action C=Apply to Calendar D=Default Match N=Do Not Process
16	TRGT_CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar to which retro deltas are targeted or forwarded
17	TRGT_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Pay group to which retro deltas are targeted or forwarded
18	PIN_RTO_ADJ_NUM	Number(8,0)	INTEGER NOT NULL	Element number field
19	FWD2_CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Forwarded To Cal Group
20	FWD2_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Forwarded To Paygroup
21	FWD2_CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	Forwarded to Calendar
22	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
23	PRC_ORD_TS	DateTime(26)	TIMESTAMP	Process Order Timestamp
24	RUN_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Run Type Name
25	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
26	PYMT_KEY1	Character(25)	VARCHAR2(25) NOT NULL	Payment key field. Used for optional tracking of a payment per Department, Company, Establishment or Contract Number
27	PYMT_KEY2	Character(25)	VARCHAR2(25) NOT NULL	Payment key field. Used for optional tracking of a payment per Department, Company, Establishment or Contract Number
28	PYMT_KEY3	Character(25)	VARCHAR2(25) NOT NULL	Payment key field. Used for optional tracking of a payment per Department, Company, Establishment or Contract Number
29	PYMT_KEY4	Character(25)	VARCHAR2(25) NOT NULL	Payment key field. Used for optional tracking of a payment per Department, Company, Establishment or Contract Number
30	RSLT_VER_NUM	Number(4,0)	SMALLINT NOT NULL	Result Version Number
31	RSLT_REV_NUM	Number(4,0)	SMALLINT NOT NULL	Result Revision Number
32	ENTRY_TYPE_RTO_ADJ	Character(3)	VARCHAR2(3) NOT NULL	Entry (element) type field