GP_NRP_RSDLT_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	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	ORIG_CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Original Calendar Group ID
8	RSLT_SEG_NUM	Number(4,0)	SMALLINT NOT NULL	Result Segment Number
9	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
10	DELTA_NUM	Number(3,0)	SMALLINT NOT NULL	Uniquely defined deltas for the same payee/pin
11	CALC_DELTA_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Amount Delta
12	UNIT_DELTA_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Unit Delta
13	BASE_DELTA_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Base Delta
14	REPLACE_IND	Character(1)	VARCHAR2(1) NOT NULL	Replace Indicator
15	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
16	RTO_MATCH_ACTN	Character(1)	VARCHAR2(1) NOT NULL	Retro Delta Match Action C=Apply to Calendar D=Default Match N=Do Not Process
17	TRGT_CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar to which retro deltas are targeted or forwarded
18	TRGT_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Pay group to which retro deltas are targeted or forwarded
19	PIN_RTO_ADJ_NUM	Number(8,0)	INTEGER NOT NULL	Element number field
20	FWD2_CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Forwarded To Cal Group
21	FWD2_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Forwarded To Paygroup
22	FWD2_CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	Forwarded to Calendar
23	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
24	PRC_ORD_TS	DateTime(26)	TIMESTAMP	Process Order Timestamp
25	RUN_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Run Type Name
26	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
27	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
28	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
29	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
30	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
31	RSLT_VER_NUM	Number(4,0)	SMALLINT NOT NULL	Result Version Number
32	RSLT_REV_NUM	Number(4,0)	SMALLINT NOT NULL	Result Revision Number
33	ENTRY_TYPE_RTO_ADJ	Character(3)	VARCHAR2(3) NOT NULL	Entry (element) type field
34	USER_FLD1	Character(25)	VARCHAR2(25) NOT NULL	User Field 1
35	USER_FLD2	Character(25)	VARCHAR2(25) NOT NULL	User Field 2
36	USER_FLD3	Character(25)	VARCHAR2(25) NOT NULL	User Field 3
37	USER_FLD4	Character(25)	VARCHAR2(25) NOT NULL	User Field 4
38	USER_FLD5	Character(25)	VARCHAR2(25) NOT NULL	User FIeld 5
39	USER_FLD6	Character(25)	VARCHAR2(25) NOT NULL	User Field 6