GPUS_PSLP_RSLT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
4	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
5	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
6	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
7	ORIG_CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Original Calendar Group ID
8	RSLT_SEG_NUM	Number(4,0)	SMALLINT NOT NULL	Result Segment Number
9	GP_RPT_KEY	Character(22)	VARCHAR2(22) NOT NULL	Output Result Key
10	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
11	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
12	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
13	INSTANCE	Number(3,0)	SMALLINT NOT NULL	Instance Number
14	PIN_CATEGORY	Character(4)	VARCHAR2(4) NOT NULL	Element Category
15	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
16	GP_CNTRY_PSLP_ELN	Character(3)	VARCHAR2(3) NOT NULL	Country
17	RSLT_VER_NUM	Number(4,0)	SMALLINT NOT NULL	Result Version Number
18	RSLT_REV_NUM	Number(4,0)	SMALLINT NOT NULL	Result Revision Number
19	GP_ELN_SET	Character(15)	VARCHAR2(15) NOT NULL	Element Set
20	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
21	GPUS_PSLP_PRT_HRS	Character(1)	VARCHAR2(1) NOT NULL	Print Hours
22	GPUS_PSLP_PRT_RATE	Character(1)	VARCHAR2(1) NOT NULL	Payslip Print Rate component indicator
23	GP_PSLP_ORDER	Character(6)	VARCHAR2(6) NOT NULL	Payslip Order
24	GPUS_PSLP_TITLEOPT	Character(2)	VARCHAR2(2) NOT NULL	The payslip title 10=Element Description 20=Element Name 30=Report Data 40=Custom Title
25	GPUS_PSLP_TITLE	Character(16)	VARCHAR2(16) NOT NULL	Payslip Title
26	GPUS_PSLP_RES_DTL	Character(1)	VARCHAR2(1) NOT NULL	Show Multiple Resolution Detail
27	SLICE_BGN_DT	Date(10)	DATE	Element Slice Begin Date
28	SLICE_END_DT	Date(10)	DATE	Element Slice End Date
29	CALC_RSLT_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Calculation Numeric Result
30	BASE_RSLT_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Calculated Base Value
31	RATE_RSLT_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Rate Result Value
32	UNIT_RSLT_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Number of units used in result calculation
33	PCT_RSLT_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Percent Result Value
34	USER_KEY1	Character(25)	VARCHAR2(25) NOT NULL	User Key 1
35	USER_KEY2	Character(25)	VARCHAR2(25) NOT NULL	User Key 2
36	USER_KEY3	Character(25)	VARCHAR2(25) NOT NULL	User Key 3
37	USER_KEY4	Character(25)	VARCHAR2(25) NOT NULL	User Key 4
38	USER_KEY5	Character(25)	VARCHAR2(25) NOT NULL	User Key 5
39	USER_KEY6	Character(25)	VARCHAR2(25) NOT NULL	User Key 6
40	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
41	SETID_DEPT	Character(5)	VARCHAR2(5) NOT NULL	Department SetID
42	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
43	SETID_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Location SetID
44	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
45	ESTABID	Character(12)	VARCHAR2(12) NOT NULL	Establishment ID
46	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract Number
47	PMT_GRP_ID	Number(3,0)	SMALLINT NOT NULL	Group Id for grouping payment
48	JOBINSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Job Instance