GPNL_PSLPLN_LAD (SQL Table)	Index Back
Payslip Lines This table is used to store the earnings and deductions that are used to print the lines

GPNL_PSLPLN_LAD

(SQL Table)

Payslip Lines

This table is used to store the earnings and deductions that are used to print the lines

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GP_PKG_ID Character(10) VARCHAR2(10) NOT NULL Field used for element packaging

2 GPNL_PAYSLIP_ID Character(6) VARCHAR2(6) NOT NULL Pay Slip Identification

3 GPNL_ELEMENT_ORD Number(9,2) DECIMAL(8,2) NOT NULL Print Order of the element in payslip

4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

5 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GP_PKG_ID	Character(10)	VARCHAR2(10) NOT NULL	Field used for element packaging
2	GPNL_PAYSLIP_ID	Character(6)	VARCHAR2(6) NOT NULL	Pay Slip Identification
3	GPNL_ELEMENT_ORD	Number(9,2)	DECIMAL(8,2) NOT NULL	Print Order of the element in payslip
4	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description