VAPS TRAVELER HISTORY Table
View exposing historical legacy VAPS traveler records including traveler identifiers and travel administration attributes over time.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
HIST_ADDR1 |
Primary address line at the time of the record. |
VARCHAR2 |
25 |
HIST_ADDR2 |
Secondary address line at the time of the record. |
VARCHAR2 |
25 |
HIST_ADDR3 |
Additional address line at the time of the record. |
VARCHAR2 |
21 |
HIST_ADDR4 |
Additional address line at the time of the record. |
VARCHAR2 |
21 |
HIST_CHANGE_DATE |
Date the historical change occurred. |
DATE |
|
HIST_CHANGE_TYPE |
Code identifying the type of change recorded. |
VARCHAR2 |
1 |
HIST_CHANGE_USERID |
User who made the change. |
VARCHAR2 |
10 |
HIST_CORP_CARD |
Corporate card number at the time of the record. |
VARCHAR2 |
15 |
HIST_DATE_ENTERED |
Date the historical record was created. |
DATE |
|
HIST_FIRST_NAME |
First name of the traveler at the time of the record. |
VARCHAR2 |
10 |
HIST_INSURANCE_CODE |
Insurance code at the time of the record. |
VARCHAR2 |
1 |
HIST_LAST_NAME |
Last name of the traveler at the time of the record. |
VARCHAR2 |
15 |
HIST_MI |
Middle initial of the traveler. |
VARCHAR2 |
1 |
HIST_ORIG_USERID |
User who created the original record. |
VARCHAR2 |
10 |
HIST_TRAV_ID |
Traveler identifier for the historical record. |
VARCHAR2 |
9 |
HIST_TRAV_ROOM |
Room location associated with the traveler at the time of the record. |
VARCHAR2 |
10 |
HIST_ZIP |
Postal code at the time of the record. |
VARCHAR2 |
5 |
HIST_ZIP_PLUS4 |
Extended ZIP code at the time of the record. |
VARCHAR2 |
4 |