GPFR_SMPL_PSLPT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	JOBINSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Job Instance
2	GPFR_PYSL_B_A	Character(1)	VARCHAR2(1) NOT NULL	Payslip or Annex A=Annex B=Pay-slip Default Value: B
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
4	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
5	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
6	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
7	RSLT_SEG_NUM	Number(4,0)	SMALLINT NOT NULL	Result Segment Number
8	GPFR_PIN_NUM_EE	Number(8,0)	INTEGER NOT NULL	Employer PIN for Payslip Prompt Table: %GP_EDIT_FLD7
9	GPFR_PIN_NUM_ER	Number(8,0)	INTEGER NOT NULL	Employer PIN for payslip Prompt Table: %GP_EDIT_FLD8
10	SLICE_BGN_DT	Date(10)	DATE	Element Slice Begin Date
11	SLICE_END_DT	Date(10)	DATE	Element Slice End Date
12	GPFR_ELEMENT_ORDER	Number(9,2)	DECIMAL(8,2) NOT NULL	Print Order of the element in payslip
13	DESCRLONG	Long Character	CLOB	Long Description
14	BASE_RSLT_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Calculated Base Value
15	UNIT_RSLT_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Number of units used in result calculation
16	GPFR_PERC_EE	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	GPFR - Employee percentage
17	GPFR_DED_EE	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	GPFR - Payslip Employee Deduction amount
18	GPFR_ERN_EE	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	GPFR - Employee earning amount
19	GPFR_PERC_ER	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	GPFR - Employer percentage
20	GPFR_AMT_ER	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	GPFR - Payslip Employer amount
21	DESCR25	Character(25)	VARCHAR2(25) NOT NULL	Short description