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

GPAU_SPT_FBT

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

2 EFFDT Date(10) DATE Effective Date
Default Value: %date

3 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

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

5 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	PAYROLL_STATE_AUS	Character(3)	VARCHAR2(3) NOT NULL	Sal Package - Payroll Tax State Prompt Table: GPAU_STATES_VW
2	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
3	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
4	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number Prompt Table: GPAU_FBT_SRCH
5	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