GPDE_RP_KU01

#	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	SEG_END_DT	Date(10)	DATE	Payee Process Segment's End Date
9	SLICE_END_DT	Date(10)	DATE	Element Slice End Date
10	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
11	PRD_END_DT	Date(10)	DATE	Pay Period End Date
12	GPDE_AL_CPAY_ENDDT	Date(10)	DATE	Current Pay End Date
13	GPDE_KU_ID_NUM	Character(18)	VARCHAR2(18) NOT NULL	KUG Idententification Number assigned by the BA for the KUG period
14	BGN_DT	Date(10)	DATE	Begin Date
15	END_DT	Date(10)	DATE	end date
16	GPDE_DV_RVNR	Character(12)	VARCHAR2(12) NOT NULL	Pension Insurance Number
17	GPDE_KU_HKUGSUM	Signed Number(8,2)	DECIMAL(6,2) NOT NULL	Calculation Numeric Result
18	GPDE_KU_HKGKK	Signed Number(8,2)	DECIMAL(6,2) NOT NULL	Calculation Numeric Result
19	GPDE_KU_HKUGINS	Signed Number(8,2)	DECIMAL(6,2) NOT NULL	Calculation Numeric Result
20	GPDE_KU_ENTSOLL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Calculation Numeric Result
21	GPDE_KU_ENTIST	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Calculation Numeric Result
22	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
23	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
24	GPDE_KU_BEN_STP	Character(1)	VARCHAR2(1) NOT NULL	KUG Benefit Step 1=With Children 2=Without Children
25	GPDE_KU_LSTSOLL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Calculation Numeric Result
26	GPDE_KU_LSTIST	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Calculation Numeric Result
27	GPDE_KU_AVGLST	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Calculation Numeric Result
28	GPDE_KU_KUGAMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Calculation Numeric Result
29	GPDE_KU_KUGKKAMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Calculation Numeric Result
30	GPDE_KU_NEBEN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Calculation Numeric Result
31	GPDE_SI_PROV_MAND	Character(8)	VARCHAR2(8) NOT NULL	SI Provider Compulsory
32	GPDE_KU_QUALI_ELIG	Character(1)	VARCHAR2(1) NOT NULL	KUG Benefit Step
33	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
34	GPDE_KU_SI_REFUND	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Calculation Numeric Result