GPFR_SMPL_PSLP

#	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	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
5	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
6	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
7	SLICE_BGN_DT	Date(10)	DATE	Element Slice Begin Date
8	SLICE_END_DT	Date(10)	DATE	Element Slice End Date
9	GP_ELN_SET	Character(15)	VARCHAR2(15) NOT NULL	Element Set
10	PIN_ELEM_GRP_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number for Element Group
11	BASE_RSLT_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Calculated Base Value
12	DESCRLONG	Long Character	CLOB	Long Description
13	UNIT_RSLT_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Number of units used in result calculation
14	GPFR_PERC_EE	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	GPFR - Employee percentage
15	GPFR_DED_EE	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	GPFR - Payslip Employee Deduction amount
16	GPFR_ERN_EE	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	GPFR - Employee earning amount
17	GPFR_PERC_ER	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	GPFR - Employer percentage
18	GPFR_AMT_ER	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	GPFR - Payslip Employer amount
19	GPFR_NEW_GROUP	Character(1)	VARCHAR2(1) NOT NULL	GPFR - Simplified payslip groups Y/N Table Edit Default Value: N
20	GPFR_GROUP	Character(1)	VARCHAR2(1) NOT NULL	Page navigation fields group
21	DESCR25	Character(25)	VARCHAR2(25) NOT NULL	Short description