Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse STUDENT BASIC Table


Basic student information with MIT ID, name; and registration information such as whether the student is eligible to register, registered, and the student year, home department and course of major for the current academic term.


Field Name

Description

Data Type

Length

COURSE

The major program (eg. "6 2", "15 M", "18 D") in which the student is enrolled in for the current term.

VARCHAR2

9

CURRENT_TERM_CODE

Term code (eg. 2002FA, 2003SP) of the current academic term.

VARCHAR2

6

FIRST_NAME

The person's first name.

VARCHAR2

30

FULL_NAME

The full name of the person.

VARCHAR2

90

HOME_DEPARTMENT

The home (major) department of a person.

VARCHAR2

4

IS_ATTENDED

"Y" indicates that the student attended at least some part of the current term. "N" indicates that the student never attended this term. In the FINAID AID APPLICANT and FINAID APPLICANT tables, "Y" indicates that the student has attended at least partially in any one of the three terms (in this order: Spring, Fall, Summer) of the aid year. "N" indicates that the student has not attended in any one of the three terms of the aid year.

VARCHAR2

1

IS_COURSE_CONFIDENTIAL

A "Y" or "S" in this field indicates that the student wants his/her course of major kept confidential.

VARCHAR2

5

IS_CURRENT_STUDENT

A flag indicating whether this person in the STUDENT table is considered a current student for the current academic term.

VARCHAR2

1

IS_DATES_ATTND_CONFIDENTIAL

A "Y" or "S" in this field indicates that the student wants his/her attended dates information kept confidential.

VARCHAR2

1

IS_ELIGIBLE

"Y" indicates that the student is currently eligible to register. "N" indicates that the student is not eligible to register.

VARCHAR2

5

IS_REGISTERED

"Y" indicates that the student is currently registered. "N" indicates that the student is not currently registered. In the FINAID AID APPLICANT and FINAID APPLICANT tables, a "Y" in this field indicates that the student has registered for any one of the terms (in this order: Spring, Fall, Summer) of the aid year. "N" indicates that the student has not registered in any one of the three terms of the aid year.

VARCHAR2

1

IS_SERIOUS_CONFIDENTIAL

A "Y" in this field indicates that the student wants his/her record kept confidential

VARCHAR2

1

IS_YEAR_CONFIDENTIAL

A "Y" or "S" in this field indicates that the student wants his/her year information kept confidential.

VARCHAR2

5

LAST_NAME

The person's last name.

VARCHAR2

30

MIDDLE_NAME

The person's middle name (where available).

VARCHAR2

30

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

The student's primary year of degree for the current term. Values include 1,2,3,4 (for freshman through senior), G for Graduate, and U for Special Undergraduate. If the student is in the graduate school and also is still an undergraduate student, then this field should always contain a "G". The undergraduate year is then stored in the Undergraduate Year (UG YEAR) field, if applicable.

VARCHAR2

1

WAREHOUSE_LOAD_DATE

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

DATE

8