EMPLIDTRAVEL_PARTNERPrompt Table: TV_TRAVEL_PTNR
ITINERARY_IDCONFIRM_STATUSC=Confirmed
U=Unconfirmed
Default Value: U
A=Assigned
D=Marked for Delete
R=Rejected
T=All Transaction Statuses
U=Unassigned
TV_TA_RESSEL_VW(SQL View) |
Index Back |
|---|---|
Travel Auth My Reservation VwTravel Auth My Reservation Vw |
| SELECT EMPLID , TRAVEL_PARTNER , ITINERARY_ID , CONFIRM_STATUS , ASSOC_FLG , DESCR40 , BOOKING_DT , TXN_AMOUNT , TXN_CURRENCY_CD ,TRAVEL_AUTH_ID ,TXN_STATUS FROM PS_TV_MYRESV_HDR WHERE CONFIRM_STATUS = 'U' AND TXN_STATUS <> 'D' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | TRAVEL_PARTNER |
Character(18) | VARCHAR2(18) NOT NULL |
Travel Partner
Prompt Table: TV_TRAVEL_PTNR |
| 3 | ITINERARY_ID |
Character(18) | VARCHAR2(18) NOT NULL | Itinerary ID for Travel Reservations |
| 4 | CONFIRM_STATUS |
Character(1) | VARCHAR2(1) NOT NULL |
Confirm Status
C=Confirmed U=Unconfirmed Default Value: U |
| 5 | ASSOC_FLG | Character(1) | VARCHAR2(1) NOT NULL | used for travel reservation association or transactions |
| 6 | DESCR40 | Character(40) | VARCHAR2(40) NOT NULL | Description |
| 7 | BOOKING_DT | Date(10) | DATE | Booking Date |
| 8 | TXN_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Transaction Amount |
| 9 | TXN_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Transaction Currency |
| 10 | TRAVEL_AUTH_ID | Character(10) | VARCHAR2(10) NOT NULL | Travel Authorization Identification. Number used to define travel authorizations. Key field on most travel authorization records and exists at level 0 for travel authorization panels. |
| 11 | TXN_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Transaction Status
A=Assigned D=Marked for Delete R=Rejected T=All Transaction Statuses U=Unassigned |