GPJP_PP_DTL (SQL Table)	Index Back
Pay Slip Template Detail Tracks the definition of the pay slip template.

GPJP_PP_DTL

(SQL Table)

Pay Slip Template Detail

Tracks the definition of the pay slip template.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GPJP_PAYSLIP_ID Character(18) VARCHAR2(18) NOT NULL Assigns a unique ID to a template used to generate pay slips.
Prompt Table: GPJP_PP_TMPL

2 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

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.
Prompt Table: GPJP_PP_POS

4 ENTRY_TYPE_ELEM Character(3) VARCHAR2(3) NOT NULL entry type element
Prompt Table: GPJP_ENT_PP_VW

5 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
Prompt Table: %GP_EDIT_FLD1

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GPJP_PAYSLIP_ID	Character(18)	VARCHAR2(18) NOT NULL	Assigns a unique ID to a template used to generate pay slips. Prompt Table: GPJP_PP_TMPL
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
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. Prompt Table: GPJP_PP_POS
4	ENTRY_TYPE_ELEM	Character(3)	VARCHAR2(3) NOT NULL	entry type element Prompt Table: GPJP_ENT_PP_VW
5	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number Prompt Table: %GP_EDIT_FLD1
6	GPJP_HEADING	Character(16)	VARCHAR2(16) NOT NULL	This value is displayed on the pay slip as the heading for the associated element.