Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse VAPS TRAVELER HISTORY Table


XXX


Field Name

Description

Data Type

Length

HIST_ADDR1

XXX

VARCHAR2

25

HIST_ADDR2

XXX

VARCHAR2

25

HIST_ADDR3

XXX

VARCHAR2

21

HIST_ADDR4

XXX

VARCHAR2

21

HIST_CHANGE_DATE

XXX

DATE

HIST_CHANGE_TYPE

XXX

VARCHAR2

1

HIST_CHANGE_USERID

XXX

VARCHAR2

10

HIST_CORP_CARD

XXX

VARCHAR2

15

HIST_DATE_ENTERED

XXX

DATE

HIST_FIRST_NAME

XXX

VARCHAR2

10

HIST_INSURANCE_CODE

XXX

VARCHAR2

1

HIST_LAST_NAME

XXX

VARCHAR2

15

HIST_MI

XXX

VARCHAR2

1

HIST_ORIG_USERID

XXX

VARCHAR2

10

HIST_TRAV_ID

XXX

VARCHAR2

9

HIST_TRAV_ROOM

XXX

VARCHAR2

10

HIST_ZIP

XXX

VARCHAR2

5

HIST_ZIP_PLUS4

XXX

VARCHAR2

4