Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse MITX RESIDENTIAL STUDENT Table


View exposing MITx residential-student attributes including student status, year, MIT identifier, Kerberos username, gender, home department, and course.


Field Name

Description

Data Type

Length

COURSE

Course associated with the record.

VARCHAR2

11

GENDER

Gender associated with the record.

VARCHAR2

100

HOME_DEPARTMENT

Home department associated with the record.

VARCHAR2

6

IS_CURRENT_STUDENT

Indicator identifying whether current student (Y/N).

VARCHAR2

1

IS_STUDENT

Indicator identifying whether student (Y/N).

VARCHAR2

1

KRB_NAME

Krb name associated with the record.

VARCHAR2

8

MIT_ID

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

VARCHAR2

9

STUDENT_YEAR

Student year associated with the record.

VARCHAR2

1