| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
CREDIT_CARD_VENDOR |
Character(5) |
VARCHAR2(5) NOT NULL |
Corporate Card Vendor
|
| 3 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 4 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 5 |
SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
|
| 6 |
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
|
| 7 |
NORMAL_PROC |
Character(1) |
VARCHAR2(1) NOT NULL |
Normal Load Process
|
| 8 |
RELOAD_PROC |
Character(1) |
VARCHAR2(1) NOT NULL |
Reload
|
| 9 |
AMX_TRANS_NO |
Character(15) |
VARCHAR2(15) NOT NULL |
Transaction Number
|
| 10 |
DUPLICATES_EXIST |
Character(1) |
VARCHAR2(1) NOT NULL |
Duplicates Exist
|
| 11 |
DELAY_DAYS_EX |
Number(3,0) |
SMALLINT NOT NULL |
Delay Days
|
| 12 |
DATEVAL1 |
Date(10) |
DATE |
DateVal1
|
| 13 |
CC_LOAD_LVL3_EX |
Character(1) |
VARCHAR2(1) NOT NULL |
Load Enhanced Data
|
| 14 |
EX_LVL3_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Credit Card Level 3 Options
1=All
2=Detail
3=Summary
|
| 15 |
COUNTER1 |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Counter 1
|
| 16 |
COUNTER |
Number(10,0) |
DECIMAL(10) NOT NULL |
Counter
|
| 17 |
COUNTER_ALL |
Number(10,0) |
DECIMAL(10) NOT NULL |
Counter for Hierarchy
|
| 18 |
COUNTER_DET |
Number(10,0) |
DECIMAL(10) NOT NULL |
Count for Detail Only
|
| 19 |
COUNTER_SUM |
Number(10,0) |
DECIMAL(10) NOT NULL |
Counter for Summary Only
|
| 20 |
COUNTER_MNT |
Number(10,0) |
DECIMAL(10) NOT NULL |
Count New Credit Card Accts
|
| 21 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|
| 22 |
VS_ACCT_NBR |
Character(19) |
VARCHAR2(19) NOT NULL |
Account Number
|
| 23 |
VS_POSTING_DT |
Date(10) |
DATE |
Posting Date
|
| 24 |
VS_CCTRANS_NBR |
Character(24) |
VARCHAR2(24) NOT NULL |
Transaction Number
|
| 25 |
VS_CCSEQ_NBR |
Number(10,0) |
DECIMAL(10) NOT NULL |
Visa Sequence Number
|
| 26 |
VS_ITEM_SEQ_NBR |
Number(5,0) |
INTEGER NOT NULL |
Item Sequence Number
|
| 27 |
LAST_LINE_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Last Line Sequence Number
|
| 28 |
EX_LVL3_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Enhanced Data Type
|
| 29 |
SEQ_NBR_5 |
Number(5,0) |
INTEGER NOT NULL |
Sequence number five digits long
|
| 30 |
SORT_SEQ_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Sort Sequence Number
|
| 31 |
INCLUDE_CC_MAINT |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Account Maintenance
|
| 32 |
UPD_CC_PROF |
Character(1) |
VARCHAR2(1) NOT NULL |
Update Profile for New Account
|
| 33 |
NORMAL_MAINT |
Character(1) |
VARCHAR2(1) NOT NULL |
Normal CC Load Maint Processin
|
| 34 |
RELOAD_MAINT |
Character(1) |
VARCHAR2(1) NOT NULL |
Reload CC Maintanance Errors
|
| 35 |
CRDMEM_ACCT_NBR |
Character(44) |
VARCHAR2(44) NOT NULL |
Cardmember Number
|
| 36 |
EXPIRATION_DT |
Date(10) |
DATE NOT NULL |
Expiration Date
|
| 37 |
MC_ACCT_NUM |
Character(19) |
VARCHAR2(19) NOT NULL |
Master Card Account Number
|
| 38 |
MC_PROCESS_TRANSID |
Character(50) |
VARCHAR2(50) NOT NULL |
MasterCard ProcessorTransId
|
| 39 |
SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|
| 40 |
ITEM_SEQ_NBR |
Number(5,0) |
INTEGER NOT NULL |
Item Sequence Number
|
| 41 |
EX_CC_LINES |
Character(1) |
VARCHAR2(1) NOT NULL |
Create Expense Lines
|
| 42 |
RECNAME_TMP |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name
|
| 43 |
EX_ENHDET_CNT |
Number(10,0) |
DECIMAL(10) NOT NULL |
Enhanced Detail Count
|
| 44 |
EX_TRANS_CNT |
Number(10,0) |
DECIMAL(10) NOT NULL |
Transaction Count
|
| 45 |
EX_ENHSUM_CNT |
Number(10,0) |
DECIMAL(10) NOT NULL |
Enhanced Data Summary count
|
| 46 |
EX_ERROR_CNT |
Number(10,0) |
DECIMAL(10) NOT NULL |
Ex Error Count
|
| 47 |
TRANS_NBR |
Character(24) |
VARCHAR2(24) NOT NULL |
Transaction Number
|
| 48 |
TRANS_DATE |
Date(10) |
DATE |
Transaction Date
|
| 49 |
AMX_TRANS_NBR |
Character(50) |
VARCHAR2(50) NOT NULL |
Amex Dual Transaction Nbr
|
| 50 |
AMX_ITEM_SEQ_NBR |
Number(8,0) |
INTEGER NOT NULL |
Amex Item Sequence Nbr
|
| 51 |
AMX_ITEM_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Amex Item Code
|
| 52 |
AMX_ITM_CATCD |
Character(2) |
VARCHAR2(2) NOT NULL |
Amex Item Category Code
|
| 53 |
AMX_ITEM_DTE |
Date(10) |
DATE |
Amex Item Date
|
| 54 |
EX_CALLED_FROM |
Character(6) |
VARCHAR2(6) NOT NULL |
Called from AppEngine Prog
|
| 55 |
DC_TRANS_NUM |
Character(17) |
VARCHAR2(17) NOT NULL |
Diners Club Transaction Number
|
| 56 |
DATA_SOURCE_EX_LD |
Character(3) |
VARCHAR2(3) NOT NULL |
External Data Sources for PS Expenses
AIR=Airline Ticket
AMA=American Express - GL1205
AMG=American Express - GL1025
AMH=American Express-Hotel Folio
AMM=American Express - KR1205
AMX=American Express - KR1025
CNS=CONUS
DC=Diners Club
MC=MasterCard CDF2
MCX=MasterCard CDF3
NAP=PS NA Payroll
PDA=Mobile Device
RNZ=Runzheimer
SAB=Sabre
USB=US Bank
USR=User Input
VI4=Visa 4.4
VIS=Visa 4.0
|
| 57 |
DUPLICATES_EXIST2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Enhanced Data Duplicates
|
| 58 |
EX_STG_ERR_DUP |
Character(1) |
VARCHAR2(1) NOT NULL |
Expense Error Table Duplicate
|
| 59 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 60 |
WHERE_CLAUSE |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|