EX_ENHC_DET

(SQL Table)
 Index Back

Enhanced Data Details

Detail level Enhanced Data for Car, Air Travel and Hotel Folio

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERSONAL_DATA

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 TRANS_NBR Character(24) VARCHAR2(24) NOT NULL Transaction Number
4 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
5 ITEM_SEQ_NBR Number(5,0) INTEGER NOT NULL Item Sequence Number
6 EX_ENHNC_DATA Character(1) VARCHAR2(1) NOT NULL Enhanced Data Type
A=Air Travel Enhanced Data
C=Car Rental Enhanced Data
D=Hotel Folio Enhc Data Visa 4.4
H=Hotel Folio Enhanced Data
N=No Enhanced Data
7 EX_ENHC_DATE Date(10) DATE Enhanced Data Date
8 ROOM_RATE_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Room Rate
9 FOOD_TOTAL_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Food & Bev
10 MINIBAR_TOTAL_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Mini Bar
11 VALET_TOTAL_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Valet
12 LAUNDRY_TOTAL_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Laundry
13 PHONE_TOTAL_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Telephone
14 GIFTSHOP_TOTAL_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Gift Shop
15 MOVIE_TOTAL_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Movie
16 BUSCENTER_TOTAL_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Business Center
17 HLTHCLUB_TOTAL_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Health Club
18 ROOM_TAX_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Room Tax
19 OTHER_TOTAL_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Other Charges
20 PREPD_TOTAL_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Prepaid
21 FOLIOADV_TOTAL_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Cash Advance
22 NONRM_TOTAL_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Non-Room
23 DISC_TOTAL_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Discount Total
24 ROOM_TAX2_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Room Tax2
25 ROOM_TAX3_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Room Tax3
26 ROOM_TAX4_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Room Tax4
27 AUDIO_TOTAL_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Audio Visual
28 BANQUET_ROOM_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Banquet Room
29 CONFR_ROOM_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Conference Room
30 EARLY_DEPART_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Early Departure
31 GRATUITY_TOTAL_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Gratuity
32 INTERNET_TOTAL_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Internet
33 LOUNGE_TOTAL_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Lounge
34 OTHER_SRV2_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Other Charges2
35 OTHER_SRV3_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Other Charges3
36 OTHER_SRV4_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Other Charges4
37 OTHER_SRV5_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Other Charges5
38 OTHER_SRV6_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Other Charges6
39 RESTRT_TOTAL_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Restaurant
40 ROOM_SRVC_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Room Service
41 TRANSPORTATION_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Transportation
42 BAR_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Bar Charges
43 CASH_DISPURSE_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Cash Dispursement
44 DRY_CLEAN_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Dry Cleaning
45 TRAY_CHARGE_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Tray Charges
46 DESTINATION_CD_EX Character(5) VARCHAR2(5) NOT NULL Destination Code
47 CARRIER_CODE_EX Character(4) VARCHAR2(4) NOT NULL Carrier Code
48 SERVICE_CLASS_EX Character(2) VARCHAR2(2) NOT NULL Service Class
49 FARE_BASIS_EX Character(15) VARCHAR2(15) NOT NULL Fare Basis
50 STOPOVER_CD_EX Character(1) VARCHAR2(1) NOT NULL Stopover Code
51 CONJUNCT_TCKNBR_EX Character(15) VARCHAR2(15) NOT NULL Conjunction Ticket
52 EX_ITEM_DETAIL Character(25) VARCHAR2(25) NOT NULL Item
53 EX_ITEM_DESCR Character(40) VARCHAR2(40) NOT NULL Item Description
54 TXN_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Amount
55 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code