GPBR_MPSP_ED

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
4	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
5	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
6	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
7	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
8	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
9	ORIG_CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Original Calendar Group ID
10	RSLT_SEG_NUM	Number(4,0)	SMALLINT NOT NULL	Result Segment Number
11	GP_PSLP_SRCPRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Name of product providing payslips to ePay Payslip process.
12	GP_PSLP_ID	Character(40)	VARCHAR2(40) NOT NULL	Payslip Identifier
13	INSTANCE	Number(3,0)	SMALLINT NOT NULL	Instance Number
14	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
15	SLICE_BGN_DT	Date(10)	DATE	Element Slice Begin Date
16	SLICE_END_DT	Date(10)	DATE	Element Slice End Date
17	PIN_ELEM_GRP_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number for Element Group
18	ED_ASSIGN_INSTANCE	Number(3,0)	SMALLINT NOT NULL	Earn/Ded Assignment Instance
19	PI_INSTANCE	Number(3,0)	SMALLINT NOT NULL	Positive Input Instance
20	PRD_BGN_DT	Date(10)	DATE	Period Begin Date
21	PRD_END_DT	Date(10)	DATE	Pay Period End Date
22	SEG_BGN_DT	Date(10)	DATE	Payee Process Segment's Begin Date
23	SEG_END_DT	Date(10)	DATE	Payee Process Segment's End Date
24	PYMT_DT	Date(10)	DATE	Payment Date
25	RUN_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Run Type Name
26	CALC_RSLT_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Calculation Numeric Result
27	CALC_ADJ_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Calculation Adjustment Value
28	CALC_DELTA_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Amount Delta
29	BASE_RSLT_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Calculated Base Value
30	BASE_ADJ_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Base Adjustment
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	UNIT_ADJ_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Unit Adjustment
34	PCT_RSLT_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Percent Result Value
35	RECIPIENT_ID	Character(8)	VARCHAR2(8) NOT NULL	Payment recipient ID
36	RECIPIENT_TAG	Number(3,0)	SMALLINT NOT NULL	Used to identify recipients for E/D, PI
37	USER_FLD1	Character(25)	VARCHAR2(25) NOT NULL	User Field 1
38	USER_FLD2	Character(25)	VARCHAR2(25) NOT NULL	User Field 2
39	USER_FLD3	Character(25)	VARCHAR2(25) NOT NULL	User Field 3
40	USER_FLD4	Character(25)	VARCHAR2(25) NOT NULL	User Field 4
41	USER_FLD5	Character(25)	VARCHAR2(25) NOT NULL	User FIeld 5
42	USER_FLD6	Character(25)	VARCHAR2(25) NOT NULL	User Field 6
43	GP_MPSLP_SECTION	Character(30)	VARCHAR2(30) NOT NULL	Mobile Epay
44	GP_MPSLP_SPRNT_ORD	Number(3,0)	SMALLINT NOT NULL	Mobile Epay
45	GP_MPSLP_SUBSECTN	Character(30)	VARCHAR2(30) NOT NULL	Mobile Epay
46	GP_MPSLP_PRNT_ORD	Number(3,0)	SMALLINT NOT NULL	Mobile Epay
47	GP_MPSLP_PIN_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Mobile Epay
48	GP_MPSLP_DISP_ZERO	Character(4)	VARCHAR2(4) NOT NULL	Display Zero Default Value: N
49	GP_MPSLP_RET_ADJ	Character(4)	VARCHAR2(4) NOT NULL	Retro Adjustment Default Value: Y
50	GP_MPSLP_SUM_INST	Character(4)	VARCHAR2(4) NOT NULL	Sum Instances Default Value: N
51	GP_MPSLP_ADD_TOTAL	Character(4)	VARCHAR2(4) NOT NULL	Add to Totals Default Value: Y
52	GP_MPSLP_DISP_PYSL	Character(4)	VARCHAR2(4) NOT NULL	Display in Payslip Default Value: Y