VAPS TRIP HISTORY Table
View exposing historical legacy VAPS trip records including traveler identifiers, trip dates, destinations, and related travel processing attributes.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
HIST_BEGIN_DATE |
Trip start date. |
DATE |
|
HIST_CHANGE_DATE |
Date the trip record was last updated. |
DATE |
|
HIST_CHANGE_USERID |
User who last updated the trip record. |
VARCHAR2 |
10 |
HIST_CLOSE_DATE |
Date the trip was closed. |
DATE |
|
HIST_CLOSE_USERID |
User who closed the trip. |
VARCHAR2 |
10 |
HIST_DATE_ENTERED |
Date the trip record was created. |
DATE |
|
HIST_DESTINATION1 |
Primary destination for the trip. |
VARCHAR2 |
20 |
HIST_DESTINATION2 |
Secondary destination for the trip. |
VARCHAR2 |
20 |
HIST_DESTINATION3 |
Additional destination for the trip. |
VARCHAR2 |
20 |
HIST_END_DATE |
Trip end date. |
DATE |
|
HIST_ORIG_USERID |
User who created the original trip record. |
VARCHAR2 |
10 |
HIST_PROBLEM_CODE |
Code identifying issues associated with the trip. |
VARCHAR2 |
1 |
HIST_TRAV_ID |
Traveler identifier associated with the trip. |
VARCHAR2 |
9 |
HIST_TRIP_COST |
Total cost of the trip. |
NUMBER |
11,2 |
HIST_TRIP_NO |
Trip identifier for the historical record. |
VARCHAR2 |
8 |
HIST_TRIP_STATUS |
Status of the trip record. |
VARCHAR2 |
1 |