GPNL_NRP_TAX_AD (SQL Table)	Index Back
Tax Reductions This table stores the deduction assignements for tax reductions. Used as a child table to GPNL_EE_TAX. Based on Global Payroll guideline, the PIN numbers are stored in the table and will be accessed during the payroll process via variables (type pointer) with an array.

GPNL_NRP_TAX_AD

(SQL Table)

Tax Reductions

This table stores the deduction assignements for tax reductions. Used as a child table to GPNL_EE_TAX. Based on Global Payroll guideline, the PIN numbers are stored in the table and will be accessed during the payroll process via variables (type pointer) with an array.

# 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

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

4 EFFDT Date(10) DATE Effective Date

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

6 GPNL_AUTH_DT Date(10) DATE Authorization Date

#	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	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
4	EFFDT	Date(10)	DATE	Effective Date
5	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
6	GPNL_AUTH_DT	Date(10)	DATE	Authorization Date