Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse VAPS FTRVD007 Table


XXX


Field Name

Description

Data Type

Length

D007_BATCH_NO

XXX

NUMBER

4

D007_SEQ_NO

XXX

NUMBER

5

D007_SEQ_SUFFIX

XXX

NUMBER

2

D007_TRANS_TYPE

XXX

NUMBER

2

DATE_ENTERED

XXX

DATE

DIST_ACCT

XXX

VARCHAR2

6

DIST_AMT

XXX

NUMBER

10,2

DIST_OBJ

XXX

VARCHAR2

5

DIST_STATUS

XXX

VARCHAR2

1

JV_DATE

XXX

DATE

JV_STATUS

XXX

VARCHAR2

1

TIME_ENTERED

XXX

VARCHAR2

6

TRIP_NO

XXX

VARCHAR2

8

USER_ID

In the Commitment History and Current Commitments tables, the kerberos ID of the person who entered the commitment.

VARCHAR2

10