Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse VAPS TRAVELER Table


XXX


Field Name

Description

Data Type

Length

ADDR1

XXX

VARCHAR2

25

ADDR2

XXX

VARCHAR2

25

ADDR3

XXX

VARCHAR2

21

ADDR4

XXX

VARCHAR2

21

CHANGE_DATE

XXX

DATE

CHANGE_USERID

XXX

VARCHAR2

10

CORP_CARD

XXX

VARCHAR2

15

DATE_ENTERED

XXX

DATE

FIRST_NAME

The person's first name.

VARCHAR2

10

ID

XXX

VARCHAR2

9

INSURANCE_CODE

XXX

VARCHAR2

1

LAST_NAME

The person's last name.

VARCHAR2

15

ORIG_USERID

XXX

VARCHAR2

10

TRAV_ROOM

XXX

VARCHAR2

10

ZIP

XXX

VARCHAR2

5

ZIP_PLUS4

XXX

VARCHAR2

4