EX_BMXPNSTP_MAP

(SQL Table)
Index Back

Benchmark Expense Type mapping

Template for expense type mapping.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: SP_SETID_NONVW.SETID

Prompt Table: SP_SETID_NONVW

2 DATA_SOURCE_EX Character(3) VARCHAR2(3) NOT NULL External Data Sources for PS Expenses
AIR=Airline Ticket
AMA=American Express
AMG=American Express
AMH=American Express-Hotel Folio
AMM=American Express - Member List
AMX=American Express
CNS=CONUS
DC=Diners Club
IPH=iReceipts
MC=MasterCard CDFv2
MCX=MasterCard CDFv3
MSG=Text Message
NAP=PS NA Payroll
PDA=PDA
RNZ=Runzheimer
SAB=Sabre
UBT=User Chatbot
USB=US Bank
USR=User Input
VI4=Visa
VIS=Visa
3 EXPENSE_TYPE Character(7) VARCHAR2(7) NOT NULL Expense Type

Prompt Table: EX_TYPES_TBL

4 BNCHMRK_EXPNS_TYPE Character(4) VARCHAR2(4) NOT NULL BenchMark Expenses Type used to map User defined Expense types
BRKF=Breakfast
CCR=Compact Car rental
DHTL=Deluxe Hotel
DNR=Dinner
EHTL=Economy Hotel
FHTL=First Class Hotel
HTL=Hotel/Lodging
ICR=Intermediate Car Rental
LIE=Local Incidental Expenses
LNCH=Lunch
NGVM=No Govt Meals
PERD=Perdiem
PRML=Proportional Meals
SHTL=Airport Shuttle
TAXI=Taxi