PSARCH_IDPSARCH_BATCHNUMEMPLIDTRAVEL_PARTNERPrompt Table: TV_TRAVEL_PTNR
ITINERARY_IDCONFIRM_STATUSC=Confirmed
U=Unconfirmed
RESERVATION_NBRLEG_IDTV_MYRES_DTL_H(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PSARCH_ID |
Character(8) | VARCHAR2(8) NOT NULL | Archive ID (see PSARCHTEMPLATE). |
| 2 | PSARCH_BATCHNUM |
Number(30,0) | DECIMAL(30) NOT NULL | Archive Batch Number |
| 3 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | TRAVEL_PARTNER |
Character(18) | VARCHAR2(18) NOT NULL |
Travel Partner
Prompt Table: TV_TRAVEL_PTNR |
| 5 | ITINERARY_ID |
Character(18) | VARCHAR2(18) NOT NULL | Itinerary ID for Travel Reservations |
| 6 | CONFIRM_STATUS |
Character(1) | VARCHAR2(1) NOT NULL |
Confirm Status
C=Confirmed U=Unconfirmed |
| 7 | RESERVATION_NBR |
Number(3,0) | SMALLINT NOT NULL | reservation sequence number |
| 8 | LEG_ID |
Number(3,0) | SMALLINT NOT NULL | Leg ID |
| 9 | FLIGHT_NUM | Character(10) | VARCHAR2(10) NOT NULL | flight number |
| 10 | SEAT | Character(3) | VARCHAR2(3) NOT NULL | Seat Number |
| 11 | ARRIVAL_LOC | Character(3) | VARCHAR2(3) NOT NULL | airport arrival location |
| 12 | DEPARTURE_LOC | Character(3) | VARCHAR2(3) NOT NULL | airport departure location |
| 13 | DEPARTURE_DTTM | DateTime(26) | TIMESTAMP | Departure Datetime |