GP_RSLT_DELTA

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
4	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
5	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
6	ORIG_CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Original Calendar Group 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	DELTA_NUM	Number(3,0)	SMALLINT NOT NULL	Uniquely defined deltas for the same payee/pin
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 Y/N Table Edit
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 Y/N Table Edit
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
33	USER_FLD1	Character(25)	VARCHAR2(25) NOT NULL	User Field 1
34	USER_FLD2	Character(25)	VARCHAR2(25) NOT NULL	User Field 2
35	USER_FLD3	Character(25)	VARCHAR2(25) NOT NULL	User Field 3
36	USER_FLD4	Character(25)	VARCHAR2(25) NOT NULL	User Field 4
37	USER_FLD5	Character(25)	VARCHAR2(25) NOT NULL	User FIeld 5
38	USER_FLD6	Character(25)	VARCHAR2(25) NOT NULL	User Field 6