GPJP_PP_DATA (SQL Table)	Index Back
Pay Slip Print Data This reporting table tracks the values and position of each value that will be displayed on the pay slip generated by SQR GPJPPP01.

GPJP_PP_DATA

(SQL Table)

Pay Slip Print Data

This reporting table tracks the values and position of each value that will be displayed on the pay slip generated by SQR GPJPPP01.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

3 GPJP_POSITION Character(6) VARCHAR2(6) NOT NULL Tracks the position of an element on a pay slip. The first two digits indicate the section that the element is displayed, the next two indicate the row, and the last two indicate the column.

4 JOBINSTANCE Number(10,0) DECIMAL(10) NOT NULL Job Instance

5 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

6 GPJP_HEADING Character(16) VARCHAR2(16) NOT NULL This value is displayed on the pay slip as the heading for the associated element.

7 FLD_FMT Character(1) VARCHAR2(1) NOT NULL Field format for Global Payroll elements
1=Character
2=Date
3=Monetary
4=Decimal
5=Element Pointer
6=Not Applicable

8 CALC_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result

9 CHR_PIN_VAL Character(30) VARCHAR2(30) NOT NULL Calculation Character Result

10 DATE_PIN_VAL Date(10) DATE Calculation Date Result

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
3	GPJP_POSITION	Character(6)	VARCHAR2(6) NOT NULL	Tracks the position of an element on a pay slip. The first two digits indicate the section that the element is displayed, the next two indicate the row, and the last two indicate the column.
4	JOBINSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Job Instance
5	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
6	GPJP_HEADING	Character(16)	VARCHAR2(16) NOT NULL	This value is displayed on the pay slip as the heading for the associated element.
7	FLD_FMT	Character(1)	VARCHAR2(1) NOT NULL	Field format for Global Payroll elements 1=Character 2=Date 3=Monetary 4=Decimal 5=Element Pointer 6=Not Applicable
8	CALC_RSLT_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Calculation Numeric Result
9	CHR_PIN_VAL	Character(30)	VARCHAR2(30) NOT NULL	Calculation Character Result
10	DATE_PIN_VAL	Date(10)	DATE	Calculation Date Result