EX_TRAN_ATT_VW(SQL View) |
Index Back |
|---|
| SELECT C.EMPLID , C.DATA_SOURCE_EX , C.TRANS_NBR , C.SEQ_NBR , COUNT(*) FROM PS_EX_TRANS_ATTACH C GROUP BY C.EMPLID , C.DATA_SOURCE_EX , C.TRANS_NBR , C.SEQ_NBR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSONAL_DATA |
| 2 | 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 Default Value: USR |
| 3 | TRANS_NBR |
Character(24) | VARCHAR2(24) NOT NULL |
Transaction Number
Default Value: 1 |
| 4 | SEQ_NBR |
Number(15,0) | DECIMAL(15) NOT NULL |
Sequence Number
Default Value: 1 |
| 5 | EX_MBL_NO_RECEIPTS | Number(3,0) | SMALLINT NOT NULL | Nbr of Receipts |