EX_BNCHMRK3_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
3	EXPENSE_TYPE	Character(7)	VARCHAR2(7) NOT NULL	Expense Type
4	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
5	EFFDT	Date(10)	DATE NOT NULL	Effective Date
6	TXN_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Expense Location
7	START_DT_JULIAN	Number(3,0)	SMALLINT NOT NULL	Julian Start Date
8	END_DT_JULIAN	Number(3,0)	SMALLINT NOT NULL	Julian End Date
9	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
10	FLAG_SEASONAL	Character(2)	VARCHAR2(2) NOT NULL	Seasonal Flag I=In Season M1=Mid Season M2=MidSeason N=No Season O=Out of Season
11	START_OF_SEASON	Character(5)	VARCHAR2(5) NOT NULL	Start of Season
12	END_OF_SEASON	Character(5)	VARCHAR2(5) NOT NULL	End of Season
13	BNCHMRK_AVG_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Benchmark Average Amount
14	BNCHMRK_HIGH_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Benchmark High Amount
15	BNCHMRK_LOW_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Benchmark Low Amount
16	ACTIVE_AVG_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Active Average Amount
17	ACTIVE_HIGH_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Active High Amount
18	ACTIVE_LOW_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Active Low Amount
19	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
20	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.