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

GPNL_NRP_PSLNAD

(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 GPNL_ELEM_DESCR Character(1) VARCHAR2(1) NOT NULL Source for the description of an element in payslip
E=Element
T=User Text

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

6 GPNL_PIN_TYPE Character(3) VARCHAR2(3) NOT NULL Element Type

7 GPNL_PIN_PS1_NUM Number(8,0) INTEGER NOT NULL Pay slip Pin Number

8 GPNL_RETRO_TYPE Character(2) VARCHAR2(2) NOT NULL Retro Type
10=Current and Deltas
20=Current and Adjustment
30=One Line

9 GPNL_LINES_BEFORE Number(2,0) SMALLINT NOT NULL Number of lines before the element in payslip

10 GPNL_LINES_AFTER Number(2,0) SMALLINT NOT NULL Number of lines after the element in payslip

11 GPNL_PSLIP_SEPARAT Character(1) VARCHAR2(1) NOT NULL This field is used to specify if theacumulator will be included on the Payslips with a sparator line

12 GPNL_BASE_PRINT Character(1) VARCHAR2(1) NOT NULL This field is used to specify if the base component of an earning or deduction will be included on the Payslips.

13 GPNL_PCT_PRINT Character(1) VARCHAR2(1) NOT NULL This field is used to specify if the percent component of an earning or deduction will be included on the Payslips.

14 GPNL_RATE_PRINT Character(1) VARCHAR2(1) NOT NULL This field is used to specify if the rate component of an earning or deduction will be included on the Payslips.

15 GPNL_UNIT_PRINT Character(1) VARCHAR2(1) NOT NULL This field is used to specify if the unit component of an earning or deduction will be included on the Payslips.

16 GPNL_PS_REG_COL Character(1) VARCHAR2(1) NOT NULL This field is used to specify if the earning or deduction will be printed in the Regular column on the Payslips.

17 GPNL_PS_REGTOT_COL Character(1) VARCHAR2(1) NOT NULL This field is used to specify if the earning or deduction will be printed in the Regular and Total columns on the Payslips.

18 GPNL_PS_NREG_COL Character(1) VARCHAR2(1) NOT NULL This field is used to specify if the earning or deduction will be printed in the non Regular column on the Payslips.

19 GPNL_PS_NRGTOT_COL Character(1) VARCHAR2(1) NOT NULL This field is used to specify if the earning or deduction will be printed in the non Regular and Total columns on the Payslips.

20 GPNL_PS_TOT_COL Character(1) VARCHAR2(1) NOT NULL This field is used to specify if the earning or deduction will be printed in the Total column on the Payslips.

#	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	GPNL_ELEM_DESCR	Character(1)	VARCHAR2(1) NOT NULL	Source for the description of an element in payslip E=Element T=User Text
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
6	GPNL_PIN_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Element Type
7	GPNL_PIN_PS1_NUM	Number(8,0)	INTEGER NOT NULL	Pay slip Pin Number
8	GPNL_RETRO_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Retro Type 10=Current and Deltas 20=Current and Adjustment 30=One Line
9	GPNL_LINES_BEFORE	Number(2,0)	SMALLINT NOT NULL	Number of lines before the element in payslip
10	GPNL_LINES_AFTER	Number(2,0)	SMALLINT NOT NULL	Number of lines after the element in payslip
11	GPNL_PSLIP_SEPARAT	Character(1)	VARCHAR2(1) NOT NULL	This field is used to specify if theacumulator will be included on the Payslips with a sparator line
12	GPNL_BASE_PRINT	Character(1)	VARCHAR2(1) NOT NULL	This field is used to specify if the base component of an earning or deduction will be included on the Payslips.
13	GPNL_PCT_PRINT	Character(1)	VARCHAR2(1) NOT NULL	This field is used to specify if the percent component of an earning or deduction will be included on the Payslips.
14	GPNL_RATE_PRINT	Character(1)	VARCHAR2(1) NOT NULL	This field is used to specify if the rate component of an earning or deduction will be included on the Payslips.
15	GPNL_UNIT_PRINT	Character(1)	VARCHAR2(1) NOT NULL	This field is used to specify if the unit component of an earning or deduction will be included on the Payslips.
16	GPNL_PS_REG_COL	Character(1)	VARCHAR2(1) NOT NULL	This field is used to specify if the earning or deduction will be printed in the Regular column on the Payslips.
17	GPNL_PS_REGTOT_COL	Character(1)	VARCHAR2(1) NOT NULL	This field is used to specify if the earning or deduction will be printed in the Regular and Total columns on the Payslips.
18	GPNL_PS_NREG_COL	Character(1)	VARCHAR2(1) NOT NULL	This field is used to specify if the earning or deduction will be printed in the non Regular column on the Payslips.
19	GPNL_PS_NRGTOT_COL	Character(1)	VARCHAR2(1) NOT NULL	This field is used to specify if the earning or deduction will be printed in the non Regular and Total columns on the Payslips.
20	GPNL_PS_TOT_COL	Character(1)	VARCHAR2(1) NOT NULL	This field is used to specify if the earning or deduction will be printed in the Total column on the Payslips.