VAPS OPENTRIP Table
View exposing open-trip detail from the legacy VAPS travel system including traveler identifier, trip dates, destinations, trip cost, problem code, and change and entry audit fields.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
BEGIN_DATE |
Begin date of the trip. |
DATE |
|
CHANGE_DATE |
Date the trip record was last changed. |
DATE |
|
CHANGE_USERID |
User identifier of the person who last changed the trip record. |
VARCHAR2 |
10 |
D002_TRAV_ID |
Traveler identifier associated with the open trip. |
VARCHAR2 |
9 |
DATE_ENTERED |
Date the trip record was entered. |
DATE |
|
DESTINATION1 |
Primary destination associated with the trip. |
VARCHAR2 |
20 |
DESTINATION2 |
Secondary destination associated with the trip. |
VARCHAR2 |
20 |
DESTINATION3 |
Tertiary destination associated with the trip. |
VARCHAR2 |
20 |
END_DATE |
End date of the trip. |
DATE |
|
PROBLEM_CODE |
Problem code associated with the trip record. |
VARCHAR2 |
1 |
TRIP_COST |
Total cost associated with the trip. |
NUMBER |
11,2 |
TRIP_NO |
Legacy VAPS trip identifier. |
VARCHAR2 |
8 |
USER_ID |
User identifier of the person who entered the trip record. |
VARCHAR2 |
10 |