VAPS FTRVD003 Table
View exposing closed-trip summary detail from the legacy VAPS travel system including traveler identifier, trip begin and end dates, destinations, trip cost, problem code, and closure audit fields.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CHANGE_USERID |
User identifier of the person who last changed the closed-trip record. |
VARCHAR2 |
10 |
CLOSED_BEGIN_DATE |
Begin date of the closed trip. |
DATE |
|
CLOSED_CHANGE_DATE |
Date the closed-trip record was last changed. |
DATE |
|
CLOSED_DATE |
Date the trip was closed. |
DATE |
|
CLOSED_DATE_ENTERED |
Date the closed-trip record was entered. |
DATE |
|
CLOSED_DESTINATION1 |
Primary destination associated with the closed trip. |
VARCHAR2 |
20 |
CLOSED_DESTINATION2 |
Secondary destination associated with the closed trip. |
VARCHAR2 |
20 |
CLOSED_DESTINATION3 |
Tertiary destination associated with the closed trip. |
VARCHAR2 |
20 |
CLOSED_END_DATE |
End date of the closed trip. |
DATE |
|
CLOSED_PROBLEM_CODE |
Problem code associated with the closed trip. |
VARCHAR2 |
1 |
CLOSED_TRIP_COST |
Total cost associated with the closed trip. |
NUMBER |
11,2 |
CLOSED_USERID |
User identifier of the person who closed the trip. |
VARCHAR2 |
10 |
ID |
Traveler identifier associated with the trip. |
VARCHAR2 |
9 |
ORIG_USERID |
User identifier of the person who originally entered the trip record. |
VARCHAR2 |
10 |
TRIP_NO |
Legacy VAPS trip identifier. |
VARCHAR2 |
8 |