Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse SIS LOOKUP Table


Contains descriptions of codes used in MTSIS, the Student Information System.


Field Name

Description

Data Type

Length

CODE

Code

VARCHAR2

32

DESCRIPTION

the description

VARCHAR2

2000

LOOKUP_TYPE

The codes to be looked up in this table are grouped together by category/type such as: "Registration Type", "Registration Group", "Enrollment Status", "Load Level", etc.

VARCHAR2

19

WAREHOUSE_LOAD_DATE

The date the record was loaded into the Data Warehouse from the source system.

DATE

8