GPDE_AL_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	RSLT_SEG_NUM	Number(4,0)	SMALLINT NOT NULL	Result Segment Number
7	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number Prompt Table: %RECNAME_EDIT
8	ENTRY_TYPE_ELEM	Character(3)	VARCHAR2(3) NOT NULL	entry type element Prompt Table: GP_ENT_NUMER_VW
9	CALC_DELTA_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Amount Delta
10	UNIT_DELTA_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Unit Delta
11	BASE_DELTA_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Base Delta
12	REPLACE_IND	Character(1)	VARCHAR2(1) NOT NULL	Replace Indicator Y/N Table Edit Default Value: N
13	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 Default Value: N
14	RTO_MATCH_ACTN	Character(1)	VARCHAR2(1) NOT NULL	Retro Delta Match Action C=Apply to Calendar D=Default Match N=Do Not Process
15	TRGT_CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar to which retro deltas are targeted or forwarded
16	TRGT_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Pay group to which retro deltas are targeted or forwarded
17	PIN_RTO_ADJ_NUM	Number(8,0)	INTEGER NOT NULL	Element number field
18	FWD2_CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Forwarded To Cal Group
19	FWD2_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Forwarded To Paygroup
20	FWD2_CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	Forwarded to Calendar
21	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
22	PRC_ORD_TS	DateTime(26)	TIMESTAMP	Process Order Timestamp
23	RUN_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Run Type Name
24	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
25	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
26	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
27	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
28	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
29	RSLT_VER_NUM	Number(4,0)	SMALLINT NOT NULL	Result Version Number
30	RSLT_REV_NUM	Number(4,0)	SMALLINT NOT NULL	Result Revision Number
31	ENTRY_TYPE_RTO_ADJ	Character(3)	VARCHAR2(3) NOT NULL	Entry (element) type field