TRAVEL TYPE Table
View exposing travel type reference records used to classify travel and expense activity.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
IS_DOMESTIC_TRIP |
Indicator identifying whether domestic trip (Y/N). |
VARCHAR2 |
1 |
IS_INTERNATIONAL_TRIP |
Indicator identifying whether international trip (Y/N). |
VARCHAR2 |
1 |
TRAVEL_TYPE_KEY |
Surrogate key identifying the travel type. |
VARCHAR2 |
146 |
TRIP_DESTINATION |
Trip destination associated with the record. |
VARCHAR2 |
48 |
TRIP_PURPOSE |
Trip purpose associated with the record. |
VARCHAR2 |
48 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |