EX_BNCHMRK3_TAO (SQL Table)	Index Back
Benchmark Location Staging Runzheimer Benchmark data will be loaded into this staging table. Expense module will select necessary data from this table. Inserts into EX_BNCHMRK3_TAO records from EX_BNCHMRK2_TAO that are not in EX_LOC_AMT_DTL Table

EX_BNCHMRK3_TAO

(SQL Table)

Benchmark Location Staging

Runzheimer Benchmark data will be loaded into this staging table. Expense module will select necessary data from this table. Inserts into EX_BNCHMRK3_TAO records from EX_BNCHMRK2_TAO that are not in EX_LOC_AMT_DTL Table

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

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