GPAU_NRP_PT4_AD (SQL Table)	Index Back
State Payroll Tax FBT table This record stores Elements per state to be grossed up.

GPAU_NRP_PT4_AD

(SQL Table)

State Payroll Tax FBT table

This record stores Elements per state to be grossed up.

# 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 PAYROLL_STATE_AUS Character(3) VARCHAR2(3) NOT NULL Sal Package - Payroll Tax State

3 EFFDT Date(10) DATE Effective Date

4 GPAU_VAL_TYPE Character(2) VARCHAR2(2) NOT NULL Used in State Payroll Tax processing to determine whether an element is an Earnings, Deduction, or Expense.
DD=Deduction
ER=Earnings
EX=Expense

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

6 EXPENSE_CD Character(2) VARCHAR2(2) NOT NULL Expense code.
01=Airfare
02=Lodging
03=Car Rental
04=Meals
05=Telephone
06=Travel
07=Relocation
08=Entertainment
09=Parking
10=Mileage
11=Advertising
12=Referral Fee
13=Postage
14=Publication
15=Membership
16=Miscellaneous
17=Staff Time
18=Job Boards
19=Pre-Employment Request

#	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	PAYROLL_STATE_AUS	Character(3)	VARCHAR2(3) NOT NULL	Sal Package - Payroll Tax State
3	EFFDT	Date(10)	DATE	Effective Date
4	GPAU_VAL_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Used in State Payroll Tax processing to determine whether an element is an Earnings, Deduction, or Expense. DD=Deduction ER=Earnings EX=Expense
5	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
6	EXPENSE_CD	Character(2)	VARCHAR2(2) NOT NULL	Expense code. 01=Airfare 02=Lodging 03=Car Rental 04=Meals 05=Telephone 06=Travel 07=Relocation 08=Entertainment 09=Parking 10=Mileage 11=Advertising 12=Referral Fee 13=Postage 14=Publication 15=Membership 16=Miscellaneous 17=Staff Time 18=Job Boards 19=Pre-Employment Request