GPUS_PSLP_RSUM

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	JOBINSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Job Instance
2	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
4	PMT_GRP_ID	Number(3,0)	SMALLINT NOT NULL	Group Id for grouping payment
5	GP_CNTRY_PSLP_ELN	Character(3)	VARCHAR2(3) NOT NULL	Country
6	GP_ELN_SET	Character(15)	VARCHAR2(15) NOT NULL	Element Set
7	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
8	GPUS_PSLP_ELN_CAT	Character(2)	VARCHAR2(2) NOT NULL	Payslip ELN Categlroy 10=Hours and Earnings 20=Taxes 30=Before-Tax Deductions 40=After-Tax Deductions 50=Employer Paid Benefits 60=Gross to Net Accumulators 70=Absences
9	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
10	GPUS_PSLP_CURR_YTD	Character(2)	VARCHAR2(2) NOT NULL	Used by Payslip to indicate whether the amount prints in the current or year to date column. 10=Current 20=Year to Date
11	GPUS_PSLP_PRT_HRS	Character(1)	VARCHAR2(1) NOT NULL	Print Hours
12	GPUS_PSLP_PRT_RATE	Character(1)	VARCHAR2(1) NOT NULL	Payslip Print Rate component indicator
13	GP_PSLP_ORDER	Character(6)	VARCHAR2(6) NOT NULL	Payslip Order
14	USER_KEY1	Character(25)	VARCHAR2(25) NOT NULL	User Key 1
15	USER_KEY2	Character(25)	VARCHAR2(25) NOT NULL	User Key 2
16	PIN_CATEGORY	Character(4)	VARCHAR2(4) NOT NULL	Element Category
17	INSTANCE	Number(3,0)	SMALLINT NOT NULL	Instance Number
18	GPUS_PSLP_TITLE	Character(16)	VARCHAR2(16) NOT NULL	Payslip Title
19	GPUS_PSLP_TITLEOPT	Character(2)	VARCHAR2(2) NOT NULL	The payslip title 10=Element Description 20=Element Name 30=Report Data 40=Custom Title
20	SLICE_END_DT	Date(10)	DATE	Element Slice End Date
21	RATE_RSLT_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Rate Result Value
22	UNIT_RSLT_SUM	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Summary of units used in result calculation
23	CALC_RSLT_SUM	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Summary of calculations