Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse VAPS TRIP HISTORY Table


XXX


Field Name

Description

Data Type

Length

HIST_BEGIN_DATE

XXX

DATE

HIST_CHANGE_DATE

XXX

DATE

HIST_CHANGE_USERID

XXX

VARCHAR2

10

HIST_CLOSE_DATE

XXX

DATE

HIST_CLOSE_USERID

XXX

VARCHAR2

10

HIST_DATE_ENTERED

XXX

DATE

HIST_DESTINATION1

XXX

VARCHAR2

20

HIST_DESTINATION2

XXX

VARCHAR2

20

HIST_DESTINATION3

XXX

VARCHAR2

20

HIST_END_DATE

XXX

DATE

HIST_ORIG_USERID

XXX

VARCHAR2

10

HIST_PROBLEM_CODE

XXX

VARCHAR2

1

HIST_TRAV_ID

XXX

VARCHAR2

9

HIST_TRIP_COST

XXX

NUMBER

11,2

HIST_TRIP_NO

XXX

VARCHAR2

8

HIST_TRIP_STATUS

XXX

VARCHAR2

1