Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse STUDENT ACADEMIC Table


This table contains student's academic information such as GPA, required & completed GIR units, swim test. There is one record per student.


Field Name

Description

Data Type

Length

ADVISOR_FULL_NAME_1

Full name of the advisor (corresponding to ADVISOR_MIT_ID_1) to the student.

VARCHAR2

90

ADVISOR_FULL_NAME_2

Full name of the advisor (corresponding to ADVISOR_MIT_ID_2) to the student.

VARCHAR2

90

ADVISOR_FULL_NAME_3

Full name of the advisor (corresponding to ADVISOR_MIT_ID_3) to the student.

VARCHAR2

90

ALT_ADVISOR_FULL_NAME_1

XXX

VARCHAR2

76

ALT_ADVISOR_FULL_NAME_2

XXX

VARCHAR2

76

ALT_ADVISOR_FULL_NAME_3

XXX

VARCHAR2

76

COMPLETED_UNITS_GRAD

Number of completed units, graduate.

NUMBER

4

COMPLETED_UNITS_UGRAD

Number of completed units, undergraduate.

NUMBER

4

COURSE

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

VARCHAR2

9

CUMULATIVE_GPA

Cumulative GPA

NUMBER

3.1

CUMULATIVE_GPA_GRAD

Cumulative GPA, graduate.

NUMBER

2.1

CUMULATIVE_GPA_UGRAD

Cumulative GPA, undergraduate.

NUMBER

2.1

CURRENT_TERM_CODE

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

VARCHAR2

6

DEGREE_AWARDED_1

XXX

VARCHAR2

16

DEGREE_AWARDED_2

XXX

VARCHAR2

16

DEGREE_AWARDED_3

XXX

VARCHAR2

16

DEGREE_AWARDED_4

XXX

VARCHAR2

16

DEGREE_AWARDED_5

XXX

VARCHAR2

16

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

EARLY_SOPHOMORE_TERM_CODE

XXX

VARCHAR2

6

FIRST_NAME

The person's first name.

VARCHAR2

30

FULL_NAME

The full name of the person.

VARCHAR2

90

GIR_SUBJECT_COMPLETED

Number of GIR (General Institute Requirements) subjects completed.

NUMBER

3.1

GIR_SUBJECT_REQUIRED

Number of GIR (General Institute Requirements) subjects required.

NUMBER

3.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

HAS_INCOMPLETE_GRADE

XXX

VARCHAR2

1

HAS_MISSING_GRADE

XXX

VARCHAR2

1

HAS_OPEN_GRADE

XXX

VARCHAR2

1

HAS_OX_ABSENCE_EXCUSED_GRADE

XXX

VARCHAR2

1

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_ATTENDED_CONFIDENTIAL

A "Y" or "S" in this field indicates that the student wants his/her attended 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_EARLY_SOPHOMORE

XXX

VARCHAR2

1

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

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_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

ORIGINAL_CLASS

XXX

VARCHAR2

4

PERCENT_GIR_COMPLETED

Percent GIR (General Institute Requirements) completed.

NUMBER

3.2

PE_POINTS

This field contains a numeric value of 0 to 8 which indicates the number of PE points the student has.

NUMBER

1

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

SWIM_TEST_COMPLETE_FLAG

A value of "A" in this field indicates that the student has completed his/her swim test. Blank or an "I" shows that the swim test is not complte. "I" was entered when a swim test was initially marked as complete but later rescinded as an error.

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

UNITS_BEYOND_GIR_COMPLETED

Number of units beyond GIR (General Institute Requirements) completed.

NUMBER

3.1

UNITS_BEYOND_GIR_REQUIRED

Number of units beyond GIR (General Institute Requirements) required.

NUMBER

3.1

WAREHOUSE_LOAD_DATE

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

DATE

8