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