VAPS TRAVELER Table
View exposing legacy VAPS traveler reference records including traveler identifiers and related travel administration attributes.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADDR1 |
Primary address line for the traveler. |
VARCHAR2 |
25 |
ADDR2 |
Secondary address line for the traveler. |
VARCHAR2 |
25 |
ADDR3 |
Additional address line for the traveler. |
VARCHAR2 |
21 |
ADDR4 |
Additional address line for the traveler. |
VARCHAR2 |
21 |
CHANGE_DATE |
Date the traveler record was last updated. |
DATE |
|
CHANGE_USERID |
User who last updated the traveler record. |
VARCHAR2 |
10 |
CORP_CARD |
Corporate card number associated with the traveler. |
VARCHAR2 |
15 |
DATE_ENTERED |
Date the traveler record was created. |
DATE |
|
FIRST_NAME |
First name of the traveler. |
VARCHAR2 |
10 |
ID |
Unique identifier for the traveler. |
VARCHAR2 |
9 |
INSURANCE_CODE |
Code identifying traveler insurance coverage. |
VARCHAR2 |
1 |
LAST_NAME |
Last name of the traveler. |
VARCHAR2 |
15 |
ORIG_USERID |
User who originally created the traveler record. |
VARCHAR2 |
10 |
TRAV_ROOM |
Office or room location associated with the traveler. |
VARCHAR2 |
10 |
ZIP |
Postal code for the traveler address. |
VARCHAR2 |
5 |
ZIP_PLUS4 |
Extended ZIP code for the traveler address. |
VARCHAR2 |
4 |