EX_ENHC_SUMM

(SQL Table)
 Index Back

Enhanced Data Summary

Summary 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 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
6 EX_ENHC_DATE Date(10) DATE Enhanced Data Date
7 EX_ENHC_DAYS Number(5,0) INTEGER NOT NULL Enhanced Number of Days
8 EX_ENHC_TYPE_NBR Character(50) VARCHAR2(50) NOT NULL Hotel Folio
9 ENHC_NAME_EX Character(125) VARCHAR2(125) NOT NULL Renter Name
10 CAR_DAILY_RATE_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Daily Rate
11 CAR_WEEKLY_RATE_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Weekly Rate
12 CLASS_CODE_EX Character(4) VARCHAR2(4) NOT NULL Class Code
13 RETURN_LOC_EX Character(80) VARCHAR2(80) NOT NULL Return Location
14 INSURANCE_TOTAL_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Insurance
15 FUEL_TOTAL_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Fuel
16 LATE_RETURN_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Late Return
17 AUTO_TOWING_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Auto Towing
18 ONEWAY_DROPOFF_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL One-Way Drop Off
19 REG_MILE_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Regular Mileage
20 EXTRA_MILE_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Extra Mileage
21 CAR_TAX_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Car Rental Tax
22 CAR_PHONE_TOT_EX Signed Number(33,3) DECIMAL(31,3) NOT NULL Telephone
23 DEPART_DATE_EX Date(10) DATE Departure Date
24 AIRFARE_RCPT_NBR Character(16) VARCHAR2(16) NOT NULL Airfare Receipt Number
25 EXCHG_TCKT_NBR_EX Character(15) VARCHAR2(15) NOT NULL Exchange Ticket
26 TOTAL_FARE_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Fare
27 EXCHG_FARE_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Exchange Fare
28 TOTAL_FEE_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Fee
29 AIR_TAX_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Tax
30 INTERNET_IND_EX Character(1) VARCHAR2(1) NOT NULL Internet
0=0
1=1
31 TICKET_IND_EX Character(1) VARCHAR2(1) NOT NULL Restricted
0=0
1=1
32 ETICKET_IND_EX Character(1) VARCHAR2(1) NOT NULL Electronic
0=0
1=1
33 ROOM_RATE_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Room Rate
34 FOOD_TOTAL_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Food & Bev
35 MINIBAR_TOTAL_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Mini Bar
36 VALET_TOTAL_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Valet
37 LAUNDRY_TOTAL_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Laundry
38 PHONE_TOTAL_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Telephone
39 GIFTSHOP_TOTAL_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Gift Shop
40 MOVIE_TOTAL_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Movie
41 BUSCENTER_TOTAL_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Business Center
42 HLTHCLUB_TOTAL_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Health Club
43 ROOM_TAX_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Room Tax
44 OTHER_TOTAL_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Other Charges
45 PREPD_TOTAL_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Prepaid
46 FOLIOADV_TOTAL_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Cash Advance
47 NONRM_TOTAL_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Non-Room
48 AUDIO_TOTAL_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Audio Visual
49 BANQUET_ROOM_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Banquet Room
50 CONFR_ROOM_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Conference Room
51 EARLY_DEPART_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Early Departure
52 GRATUITY_TOTAL_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Gratuity
53 INTERNET_TOTAL_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Internet
54 LOUNGE_TOTAL_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Lounge
55 OTHER_SRV2_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Other Charges2
56 OTHER_SRV3_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Other Charges3
57 OTHER_SRV4_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Other Charges4
58 OTHER_SRV5_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Other Charges5
59 OTHER_SRV6_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Other Charges6
60 RESTRT_TOTAL_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Restaurant
61 ROOM_SRVC_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Room Service
62 TRANSPORTATION_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Transportation
63 BAR_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Bar Charges
64 CASH_DISPURSE_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Cash Dispursement
65 DRY_CLEAN_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Dry Cleaning
66 TRAY_CHARGE_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Tray Charges
67 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code