| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
COUNTRY_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Country
|
| 3 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
|
| 4 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 5 |
RPT_DT |
Date(10) |
DATE |
Report Date
|
| 6 |
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
|
| 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 |
CURRENCY_ABRV |
Character(5) |
VARCHAR2(5) NOT NULL |
Currency Abbreviation
|
| 10 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
|
| 11 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 12 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 13 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 14 |
CUR_EXCHNG_RT |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Currency Exchange Rate
|
| 15 |
AVG_BREAKFAST_AMT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Average Breakfast Amount
|
| 16 |
LOW_BREAKFAST_AMT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Low Breakfast Amount
|
| 17 |
HIGH_BREAKFAST_AMT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
High Breakfast Amount
|
| 18 |
AVG_LUNCH_AMT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Average Lunch Amount
|
| 19 |
LOW_LUNCH_AMT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Low Lunch amount
|
| 20 |
HIGH_LUNCH_AMT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
High Lunch Amount
|
| 21 |
AVG_DINNER_AMT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Average Dinner Amount
|
| 22 |
LOW_DINNER_AMT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Low Dinner Amount
|
| 23 |
HIGH_DINNER_AMT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
High Dinner Amount
|
| 24 |
AVG_DLX_HOTEL_AMT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Average Deluxe Hotel Amount
|
| 25 |
LOW_DLX_HOTEL_AMT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Low Deluxe Hotel Amount
|
| 26 |
HIGH_DLX_HOTEL_AMT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
High Deluxe Hotel Amount
|
| 27 |
AVG_1ST_HOTEL_AMT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
First class Hotel Average Amt
|
| 28 |
LOW_1ST_HOTEL_AMT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
First class Hotel Low Amount
|
| 29 |
HIGH_1ST_HOTEL_AMT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
First class Hotel High Amount
|
| 30 |
AVG_ECON_HOTEL_AMT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Economy Hotel Average Amount
|
| 31 |
LOW_ECON_HOTEL_AMT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Economy Hotel Low Amount
|
| 32 |
HIGH_ECONHOTEL_AMT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Economy Hotel High Amount
|
| 33 |
STD_3MEAL_AMT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Standard Three Meal Amount
|
| 34 |
STD_PER_DIEM_AMT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Standard Per Diem Amount
|
| 35 |
AMT1 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Used in Virtual Approver to store the various rule amounts that go on each approval step
|
| 36 |
DESCR_LN1 |
Character(50) |
VARCHAR2(50) NOT NULL |
Description Line 1
|
| 37 |
DESCR_LN2 |
Character(50) |
VARCHAR2(50) NOT NULL |
Description Line 2
|
| 38 |
AMT2 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Used in Virtual Approver to store the various rule amounts that go on each approval step
|
| 39 |
DESCR_LN3 |
Character(50) |
VARCHAR2(50) NOT NULL |
Description Line 3
|
| 40 |
AMT3 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Used in Virtual Approver to store the various rule amounts that go on each approval step
|
| 41 |
DESCR_LN4 |
Character(50) |
VARCHAR2(50) NOT NULL |
Description Line 4
|
| 42 |
AMT4 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Used in Virtual Approver to store the various rule amounts that go on each approval step
|
| 43 |
AMT5 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Used in Virtual Approver to store the various rule amounts that go on each approval step
|
| 44 |
AMT6 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount 6
|
| 45 |
LODGING_TAX |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Typical Lodging Tax
|
| 46 |
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
|
| 47 |
START_OF_SEASON |
Character(5) |
VARCHAR2(5) NOT NULL |
Start of Season
|
| 48 |
END_OF_SEASON |
Character(5) |
VARCHAR2(5) NOT NULL |
End of Season
|