Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse STUDENT AUDIT STRIP Table


View exposing student audit strip data.


Field Name

Description

Data Type

Length

AUDIT_ID

Business identifier for the audit.

NUMBER

8

AUDIT_STRIP_TEXT

Audit strip text associated with the record.

VARCHAR2

100

LINE_SEQ_NUMBER

Line seq number associated with the record.

NUMBER

2

LINE_TYPE

Line type associated with the record.

VARCHAR2

1

MIT_ID

MIT ID number of the person. Use this field to join with other tables containing data about people at MIT.

VARCHAR2

9

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE