EX_STATE_MAP (SQL Table)	Index Back
Expenses State/Prv Map Table Expenses State/Province Map Table

EX_STATE_MAP

(SQL Table)

Expenses State/Prv Map Table

Expenses State/Province Map Table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 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

2 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
Prompt Table: COUNTRY_TBL

3 STATE Character(6) VARCHAR2(6) NOT NULL State
Prompt Table: STATE_TBL

4 STATE_NAME Character(30) VARCHAR2(30) NOT NULL State Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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
2	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
3	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: STATE_TBL
4	STATE_NAME	Character(30)	VARCHAR2(30) NOT NULL	State Name