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