EX_BNCHMARK_AET(SQL Table) |
Index Back |
|---|---|
Bench Mark State Record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | FILE_DIRECTORY | Character(80) | VARCHAR2(80) NOT NULL | File Directory |
| 5 | FILE_NAME | Character(80) | VARCHAR2(80) NOT NULL | File Name |
| 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 | FILE_SOURCE | Character(10) | VARCHAR2(10) NOT NULL | Source of File (Domestic,etc) |
| 8 | DATETIME_ADDED | DateTime(26) | TIMESTAMP |
DateTime Added
Default Value: %date |
| 9 | PROCESSINSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |