GPAU_STP_TDELTA

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
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	GPAU_RETRO_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Used for capturing the retro type for STP Processing
12	PYMT_DT	Date(10)	DATE	Payment Date
13	CALC_DELTA_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Amount Delta
14	UNIT_DELTA_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Unit Delta
15	BASE_DELTA_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Base Delta
16	REPLACE_IND	Character(1)	VARCHAR2(1) NOT NULL	Replace Indicator Y/N Table Edit
17	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
18	RTO_MATCH_ACTN	Character(1)	VARCHAR2(1) NOT NULL	Retro Delta Match Action C=Apply to Calendar D=Default Match N=Do Not Process
19	TRGT_CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar to which retro deltas are targeted or forwarded
20	TRGT_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Pay group to which retro deltas are targeted or forwarded
21	PIN_RTO_ADJ_NUM	Number(8,0)	INTEGER NOT NULL	Element number field
22	FWD2_CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Forwarded To Cal Group
23	FWD2_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Forwarded To Paygroup
24	FWD2_CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	Forwarded to Calendar
25	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
26	PRC_ORD_TS	DateTime(26)	TIMESTAMP	Process Order Timestamp
27	RUN_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Run Type Name
28	RSLT_VER_NUM	Number(4,0)	SMALLINT NOT NULL	Result Version Number
29	RSLT_REV_NUM	Number(4,0)	SMALLINT NOT NULL	Result Revision Number
30	ENTRY_TYPE_RTO_ADJ	Character(3)	VARCHAR2(3) NOT NULL	Entry (element) type field