EMPLIDTRAVEL_PARTNERPrompt Table: TV_TRAVEL_PTNR
ITINERARY_IDCONFIRM_STATUSC=Confirmed
U=Unconfirmed
RESERVATION_NBRLEG_IDTV_MYRESV_DTL(SQL Table) |
Index Back |
|---|
| # | 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 |
| 5 | RESERVATION_NBR |
Number(3,0) | SMALLINT NOT NULL | reservation sequence number |
| 6 | LEG_ID |
Number(3,0) | SMALLINT NOT NULL | Leg ID |
| 7 | FLIGHT_NUM | Character(10) | VARCHAR2(10) NOT NULL | flight number |
| 8 | SEAT | Character(3) | VARCHAR2(3) NOT NULL | Seat Number |
| 9 | ARRIVAL_LOC | Character(3) | VARCHAR2(3) NOT NULL | airport arrival location |
| 10 | DEPARTURE_LOC | Character(3) | VARCHAR2(3) NOT NULL | airport departure location |
| 11 | DEPARTURE_DTTM | DateTime(26) | TIMESTAMP | Departure Datetime |