GPAU_SPT_EXPN (SQL Table)	Index Back
SPT Taxable Expenses This table is for the maintenance of Elements that are to be considered SPT Taxable Expenses.

GPAU_SPT_EXPN

(SQL Table)

SPT Taxable Expenses

This table is for the maintenance of Elements that are to be considered SPT Taxable Expenses.

# 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 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	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