GPNL_EE_TAX_DD (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_EE_TAX_DD

(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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERS_SRCH_GBL

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

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

4 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
Prompt Table: GPNL_PIN_TAX_VW

5 GPNL_AUTH_DT Date(10) DATE Authorization Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERS_SRCH_GBL
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number Prompt Table: GPNL_PIN_TAX_VW
5	GPNL_AUTH_DT	Date(10)	DATE	Authorization Date