STUDENT ACADEMIC BY TERM Table
This table contains the term GPA and other academic information, with one record per student per academic term.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
COMPLETED_UNITS |
Number of units completed |
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 |
COURSE_DESCRIPTION |
The description of the course or program (eg. "Elec. Eng & Comp Sci" for "6 2", "Management - SM" for "15 M", "Mathematics Doctoral" for "18 D") in which a student is enrolled. |
VARCHAR2 |
30 |
FULL_NAME |
The full name of the person. |
VARCHAR2 |
90 |
GPA |
Grade Point Average |
NUMBER |
2.1 |
GPA_2_DECIMALS |
Grade Point Average, with 2 decimal places |
NUMBER |
3.2 |
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_DEPT |
The primary or home department of a student for the term |
VARCHAR2 |
4 |
IS_DOUBLE_MAJOR |
A "Y" in this field indicates that the student is enrolled pursuing an undergraduate double major. "N" otherwise |
VARCHAR2 |
1 |
LAST_ACTIVITY_DATE |
Date when information in the record was last updated. |
DATE |
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_TERM_ENROLLMENT_KEY |
Use this field to join to the STUDENT TERM ENROLLMENT table |
VARCHAR2 |
15 |
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_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 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |