Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse STUDENT ALL Table


Contains biograpic, registration, address (home, term, and office), and awarded degree data about all students (including both current and graduated students) of MIT. This table also contains records of applicants to MIT. Only users who are authorized to view records of all students have access to this table. Other users are given access to the STUDENT table.


Field Name

Description

Data Type

Length

CITIZENSHIP_INDICATOR

Contains one of the following values: C Citizen, I International Student, or P Permanent Resident (this person holds a Green Card).

VARCHAR2

1

COUNTRY_OF_ORIGIN

Country of origin

VARCHAR2

40

COURSE

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

VARCHAR2

9

DATE_OF_BIRTH

The person's date of birth.

DATE

8

DEGREE_1

Type of degree: SB, SM, MNG, ENG, PHD, etc. A student may have up to 5 awarded degrees in the record. The degrees are listed according to the academic term when it was awarded (start from the earliest), and if more than one degrees were awarded in a term, the degree with the highest weight (eg. a PHD weighs more than a SM) will be listed first.

VARCHAR2

4

DEGREE_2

Type of degree: SB, SM, MNG, ENG, PHD, etc. A student may have up to 5 awarded degrees in the record. The degrees are listed according to the academic term when it was awarded (start from the earliest), and if more than one degrees were awarded in a term, the degree with the highest weight (eg. a PHD weighs more than a SM) will be listed first.

VARCHAR2

4

DEGREE_3

Type of degree: SB, SM, MNG, ENG, PHD, etc. A student may have up to 5 awarded degrees in the record. The degrees are listed according to the academic term when it was awarded (start from the earliest), and if more than one degrees were awarded in a term, the degree with the highest weight (eg. a PHD weighs more than a SM) will be listed first.

VARCHAR2

4

DEGREE_4

Type of degree: SB, SM, MNG, ENG, PHD, etc. A student may have up to 5 awarded degrees in the record. The degrees are listed according to the academic term when it was awarded (start from the earliest), and if more than one degrees were awarded in a term, the degree with the highest weight (eg. a PHD weighs more than a SM) will be listed first.

VARCHAR2

4

DEGREE_5

Type of degree: SB, SM, MNG, ENG, PHD, etc. A student may have up to 5 awarded degrees in the record. The degrees are listed according to the academic term when it was awarded (start from the earliest), and if more than one degrees were awarded in a term, the degree with the highest weight (eg. a PHD weighs more than a SM) will be listed first.

VARCHAR2

4

DEGREE_AWARD_DATE_1

The date when the degree was awarded.

DATE

8

DEGREE_AWARD_DATE_2

The date when the degree was awarded.

DATE

8

DEGREE_AWARD_DATE_3

The date when the degree was awarded.

DATE

8

DEGREE_AWARD_DATE_4

The date when the degree was awarded.

DATE

8

DEGREE_AWARD_DATE_5

The date when the degree was awarded.

DATE

8

DEGREE_AWARD_TERM_1

The academic term code when the degree was awarded.

VARCHAR2

6

DEGREE_AWARD_TERM_2

The academic term code when the degree was awarded.

VARCHAR2

6

DEGREE_AWARD_TERM_3

The academic term code when the degree was awarded.

VARCHAR2

6

DEGREE_AWARD_TERM_4

The academic term code when the degree was awarded.

VARCHAR2

6

DEGREE_AWARD_TERM_5

The academic term code when the degree was awarded.

VARCHAR2

6

DEGREE_OPTION_1

The major within the department of degree (primary degree).

VARCHAR2

4

DEGREE_OPTION_2

The major within the department of degree (second degree).

VARCHAR2

4

DEGREE_OPTION_3

The major within the department of degree (third degree).

VARCHAR2

4

DEGREE_OPTION_4

The major within the department of degree (fourth degree).

VARCHAR2

4

DEGREE_OPTION_5

The major within the department of degree (fifth degree).

VARCHAR2

4

DEPARTMENT_1

The department where the position is held.

VARCHAR2

4

DEPARTMENT_2

The department where position #2 is held, if applicable.

VARCHAR2

4

DEPARTMENT_3

The department where position #3 is held, if applicable.

VARCHAR2

4

DEPARTMENT_4

The department where position #4 is held, if applicable.

VARCHAR2

4

DEPARTMENT_5

XXX

VARCHAR2

4

DORM_ADDRESS

The student's on-campus dormitory name and street address.

VARCHAR2

30

DORM_PHONE

The student's on-campus dormitory phone number.

VARCHAR2

20

DORM_ROOM

The student's on-campus dormitory room number.

VARCHAR2

10

EARLY_SOPHOMORE_TERM_CODE

XXX

VARCHAR2

6

EMAIL_ADDRESS

A person's complete electronic mail address including user name and node name, for example, username@school.edu.

VARCHAR2

60

ETHNICITY

Ethnicity

VARCHAR2

40

FIRST_NAME

The person's first name.

VARCHAR2

30

FULL_NAME

The full name of the person.

VARCHAR2

90

GENDER

The person's gender.

VARCHAR2

30

GRAD_COHORT

The class of graduate students who are admitted to MIT for the first time and who enroll in the fall as full-time regular students having been admitted that fall term or in the previous summer. Graduate students who delay admission, or who have taken classes as special students in prior terms, as well as transfer students, are not included in any cohort. Cohorts are used to track graduation and retention rates for the most part. This does NOT apply to the graduate school since the programs are of varying lengths.

VARCHAR2

5

GRAD_ENTRANCE_TYPE

Entrance types for graduate students: "N"=Student entered MIT for the first time as a new graduate student, "R"=Graduate student who was at MIT as an undergraduate, "O"=Student who is a cross registered graduate student or an entering special graduate student.

VARCHAR2

1

GRAD_ENTRANCE_TYPE_DESC

Descriptive text for GRAD_ENTRANCE_TYPE

VARCHAR2

50

GRAD_ENTRY_TERM

The entrance term of a graudate student

VARCHAR2

6

HOME_ADDRESS1

Street number and street name.

VARCHAR2

30

HOME_ADDRESS2

Additional address information.

VARCHAR2

30

HOME_CITY

The person's home city.

VARCHAR2

30

HOME_COUNTRY

The person's home country.

VARCHAR2

30

HOME_DEPARTMENT

The home (major) department of a person.

VARCHAR2

4

HOME_PHONE

The person's home telephone number.

VARCHAR2

20

HOME_STATE

The person's home state.

VARCHAR2

2

HOME_ZIP_CODE

The person's home zip code.

VARCHAR2

9

I9_ACTIVITY_DATE

Date when the I9 form information was last updated

DATE

8

I9_CODE

Codes represent the status of the I9 (Employment Eligibility Verification) form.

VARCHAR2

1

I9_DESCRIPTION

Descriptive text for the codes represent the status of the I9 Form.

VARCHAR2

50

ILG

The Independent Living Group the student is associated with

VARCHAR2

3

IPEDS_ETHNICITY

Ethnicity as defined by IPEDS

VARCHAR2

50

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_ATTENDED_CONFIDENTIAL

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

VARCHAR2

1

IS_BIRTHDATE_CONFIDENTIAL

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

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_DEGREES_CONFIDENTIAL

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

VARCHAR2

1

IS_EARLY_SOPHOMORE

XXX

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_E_MAIL_CONFIDENTIAL

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

VARCHAR2

5

IS_HOME_ADDR_CONFIDENTIAL

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

VARCHAR2

5

IS_MIT_ID_OBSOLETE

Y/N flag indicating that the MIT ID associated with this student is obsolete and should not be used.

VARCHAR2

1

IS_OFFICE_ADDR_CONFIDENTIAL

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

VARCHAR2

5

IS_OFFICE_PHONE_CONFIDENTIAL

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

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_REG_TYPE_CONFIDENTIAL

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

VARCHAR2

5

IS_SERIOUS_CONFIDENTIAL

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

VARCHAR2

1

IS_STUDENT

In the STUDENT and STUDENT_ALL table, this flag indicates whether the person has ever been a student at MIT. In the WTW_INSTRUCTOR and WTW_OLD_INSTRUCTOR tables, this flag indicates whether this instructor was a current student, Y or N, for the specific term. In Payroll Person, indicates whether the person is currently a student, Y or N (i.e., the person may or may not have been a student in a past payroll period).

VARCHAR2

1

IS_TERM_ADDR_CONFIDENTIAL

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

VARCHAR2

5

IS_TERM_PHONE_CONFIDENTIAL

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

VARCHAR2

5

IS_YEAR_CONFIDENTIAL

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

VARCHAR2

5

IS_YEAR_CONFIDNTL

XXX

VARCHAR2

5

LAST_NAME

The person's last name.

VARCHAR2

30

LAST_UGRAD_TERM

The last term code when the student received his/her SB degree or before he/she entered MIT as a graduate student.

VARCHAR2

6

LATEST_TERM_ATTENDED

The last/latest academic term in which the student attended -- ie. the is_attended field in the student's enrollment profile is set to 'Y'.

VARCHAR2

6

LATEST_TERM_CODE

According to the Registrar's Office, the latest possible academic term that the student is eligible to register

VARCHAR2

6

LATEST_TERM_ELIGIBLE_TO_REG

The last/latest academic term in which the student is eligible to register -- ie. the eligible_to_reg field in the student's enrollment profile is set to 'Y'.

VARCHAR2

6

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

NAME_SUFFIX

Contains suffixes that may be appended to the last name, examples include: Jr., Sr., II, III, IV, etc. It is not used for honorifics such as "MD, Esq, PhD" etc.

VARCHAR2

15

NEW_MIT_ID

If the IS_MIT_ID_OBSOLETE is Y, this field may contain the MIT ID that should be used in place of the bad/obsolete MIT ID. If there is no known "good" or "new" MIT ID, then this field is blank.

VARCHAR2

9

OFFICE_LOCATION

The person's primary office address at MIT.

VARCHAR2

30

OFFICE_PHONE

The person's primary office telephone number at MIT.

VARCHAR2

20

ORIGINAL_CLASS

XXX

VARCHAR2

4

REGISTRATION_TYPE

Describes how the student has registered. Cross Registered - a student that is taking courses at MIT but whose primary affiliation is with another university. Special - A student who has registered for one or more courses but is not enrolled in a degree program. Regular - A student who is enrolled in a degree program. Non-resident - A doctoral student who is not living or working on campus. This type of student has complete all requirements other than the thesis.

VARCHAR2

18

RUNDATE

The date this data was last extracted/transported from MITSIS.

DATE

8

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

TERM_ADDR_CATEGORY

The address category of the student's current term address. For students who live in dormitories or housing facilities of the Independent Living Groups (ILG), this field contains their dormitory codes (eg. RAN, SID, SH) and ILG codes (eg. WILG, PKT), respectively. For others, the category codes may be: OFF (for Off campus), ONC (for on-campus office/lab), etc.

VARCHAR2

3

TERM_CITY

The student's home city for a term.

VARCHAR2

40

TERM_CODE

** For FINANCIAL DATA: the Term Code identifies the status of the cost collector. Blank - open for charges between start and end dates. Term Code = 1 - Closed. Pre-end date charges allowed. Term Code = 2 - No longer in use. Term Code = 3 - Terminated. Charges not allowed. ** For STUDENT DATA: the Term Code identifies one of the terms in an academic year; for example: 1999FA==>Fall Term of the 1998-99 academic year, and 1999SP==>Spring Term of the 1998-99 academic year.

VARCHAR2

6

TERM_PHONE1

The student's home telephone number for the current term.

VARCHAR2

20

TERM_PHONE2

The student's home telephone number for the current term.

VARCHAR2

20

TERM_STATE

The student's home state for the current term.

VARCHAR2

2

TERM_STREET1

The student's home street address for the current term. Line 1.

VARCHAR2

30

TERM_STREET2

The student's home street address for the current term. Line 2.

VARCHAR2

30

TERM_STREET3

The student's home street address for the current term. Line 3.

VARCHAR2

30

TERM_ZIP

The student's home zip code for the current term.

VARCHAR2

9

UGRAD_COHORT

The class of freshmen who are admitted to MIT for the first time and who enroll in the fall as full-time regular students having been admitted that fall term or in the previous summer. Freshmen who delay admission, or who have taken classes as special students in prior terms, as well as transfer students, are not included in any cohort. Cohorts are used to track graduation and retention rates for the most part.

VARCHAR2

5

UGRAD_ENTRANCE_TYPE

Entrance types for undergraduate students: "E"=Student entered the MIT undergraduate program as a freshman, "T"=Student entered the MIT undergraduate program as a transfer student, "O"=Student who is a cross registered undergraduate or an entering special undergraduate.

VARCHAR2

1

UGRAD_ENTRANCE_TYPE_DESC

Descriptive text for UGRAD_ENTRANCE_TYPE

VARCHAR2

50

UGRAD_ENTRY_TERM

The entrance term of a undergraduate student

VARCHAR2

6

VISA_TYPE

A description of the type of visa a person holds.

VARCHAR2

30

YEAR_OF_DEGREE

In STUDENT Biograhic and Directory tables this field contains the student's current year of study at MIT: 1, 2, 3, 4, G, U. The length of the field in those tables are of one character. In GRADUATE ADMISSION tables, this field, with a length of four character, contains the year when the applicant recieved the degree from the school/program attended.

VARCHAR2

1