GP_RSLT_DLT_HST

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