GPDE_RP_KU1_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 Rcd Nbr
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	SEG_END_DT	Date(10)	DATE	Payee Process Segment's End Date
11	SLICE_END_DT	Date(10)	DATE	Element Slice End Date
12	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
13	PRD_END_DT	Date(10)	DATE	Pay Period End Date
14	GPDE_AL_CPAY_ENDDT	Date(10)	DATE	Current Pay End Date
15	GPDE_KU_ID_NUM	Character(18)	VARCHAR2(18) NOT NULL	KUG Idententification Number assigned by the BA for the KUG period
16	BGN_DT	Date(10)	DATE	Begin Date
17	END_DT	Date(10)	DATE	end date
18	GPDE_DV_RVNR	Character(12)	VARCHAR2(12) NOT NULL	Pension Insurance Number
19	GPDE_KU_HKUGSUM	Signed Number(8,2)	DECIMAL(6,2) NOT NULL	Calculation Numeric Result
20	GPDE_KU_HKGKK	Signed Number(8,2)	DECIMAL(6,2) NOT NULL	Calculation Numeric Result
21	GPDE_KU_HKUGINS	Signed Number(8,2)	DECIMAL(6,2) NOT NULL	Calculation Numeric Result
22	GPDE_KU_ENTSOLL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Calculation Numeric Result
23	GPDE_KU_ENTIST	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Calculation Numeric Result
24	GPDE_TX_INC_TX_CLS	Character(2)	VARCHAR2(2) NOT NULL	Tax Class 0=None 1=Tax Class I 2=Tax Class II 3=Tax Class III 4=Tax Class IV 5=Tax Class V 6=Tax Class VI
25	GPDE_KU_BEN_GRP	Character(1)	VARCHAR2(1) NOT NULL	KUG Benefit Group A=Tax Class I and IV B=Tax Class II C=Tax Class III D=Tax Class V E=Tax Class VI
26	GPDE_KU_BEN_STP	Character(1)	VARCHAR2(1) NOT NULL	KUG Benefit Step 1=With Children 2=Without Children
27	GPDE_KU_LSTSOLL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Calculation Numeric Result
28	GPDE_KU_LSTIST	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Calculation Numeric Result
29	GPDE_KU_AVGLST	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Calculation Numeric Result
30	GPDE_KU_KUGAMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Calculation Numeric Result
31	GPDE_KU_KUGKKAMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Calculation Numeric Result
32	GPDE_KU_NEBEN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Calculation Numeric Result
33	GPDE_SI_PROV_MAND	Character(8)	VARCHAR2(8) NOT NULL	SI Provider Compulsory
34	GPDE_KU_QUALI_ELIG	Character(1)	VARCHAR2(1) NOT NULL	KUG Benefit Step
35	GPDE_KU_TARGET_REG	Character(1)	VARCHAR2(1) NOT NULL	KUG Refund SI contribution 0=No Target Region 1=Target Region 1 2=Target Region 2 3=Transition Region
36	GPDE_KU_SI_REFUND	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Calculation Numeric Result