GPDE_RP_EL_DBEN

#	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 Record
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	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
10	PRD_END_DT	Date(10)	DATE	Pay Period End Date
11	GPDE_AL_CPAY_ENDDT	Date(10)	DATE	Current Pay End Date
12	HIRE_DT	Date(10)	DATE	First Start Date
13	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
14	GPDE_TX_FACTOR	Number(5,3)	DECIMAL(4,3) NOT NULL	Number of Children
15	GPDE_TX_NUM_CHILD	Number(4,1)	DECIMAL(3,1) NOT NULL	Number of Children
16	BA_CD	Character(5)	VARCHAR2(5) NOT NULL	BA Code
17	GPDE_SI_POS_IN_JOB	Character(1)	VARCHAR2(1) NOT NULL	Position 0=0 Apprentice 1=1 Blue Collar, non prof 2=2 Blue Collar Prof 3=3 BC Foreman 4=4 White Collar 5=5 Disabled 6=6 Rehabilitation 7=7 Homeworker;domestic business 8=8 Part Time < 18 Hrs. 9=9 Part Time >= 18 Hrs.
18	GPDE_SI_EDUCATION	Character(1)	VARCHAR2(1) NOT NULL	Education 0=0 unknown 1=1General Secondary w/o Prof 2=2 General Secondary with Prof 3=3 Gen Univ Entr no Prof Train 4=4 Gen Univ Entr w/Prof Train 5=5 Technical College Degree 6=6 University Degree 7=7 unknown degree
19	GPDE_SIP_REGION	Character(1)	VARCHAR2(1) NOT NULL	Pension Insurance Region
20	GPDE_DV_SV_CODE	Character(4)	VARCHAR2(4) NOT NULL	DEUEV Contribution Group Code
21	STD_HOURS	Number(7,2)	DECIMAL(6,2) NOT NULL	Standard Hours
22	GPDE_RP_TXGRS_ANLZ	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Calculation Numeric Result
23	GPDE_RP_TXGRS_BON	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Calculation Numeric Result
24	GPDE_RP_SIGRS_ANLZ	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Calculation Numeric Result
25	GPDE_RP_SIGRS_BON	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Calculation Numeric Result
26	GPDE_RP_TOTGRSS	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Total of Gross
27	GPDE_RP_KVLFD_AN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Calculation Numeric Result
28	GPDE_RP_KVBON_AN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Calculation Numeric Result
29	GPDE_RP_RVLFD_AN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Calculation Numeric Result
30	GPDE_RP_RVBON_AN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Calculation Numeric Result
31	GPDE_RP_AVLFD_AN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Calculation Numeric Result
32	GPDE_RP_AVBON_AN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Calculation Numeric Result
33	GPDE_RP_PVLFD_AN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Calculation Numeric Result
34	GPDE_RP_PVBON_AN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Calculation Numeric Result
35	GPDE_RP_TAX_LFD	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Calculation Numeric Result
36	GPDE_RP_TAX_BON	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Calculation Numeric Result
37	GPDE_RP_SLDTY_LFD	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Calculation Numeric Result
38	GPDE_RP_SLDTY_BON	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Calculation Numeric Result
39	GPDE_RP_CHRCHT_LFD	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Calculation Numeric Result
40	GPDE_RP_CHRCHT_BON	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Calculation Numeric Result