STUDENT ACADEMIC BY TERM Table
View exposing student academic detail by term including student-term enrollment key, term, course and department, GPA, completed units, and grade-status indicators.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
COMPLETED_UNITS |
Completed units associated with the record. |
NUMBER |
|
COURSE |
Course associated with the record. |
VARCHAR2 |
12 |
COURSE_DESCRIPTION |
Description of course. |
VARCHAR2 |
30 |
FULL_NAME |
Full name associated with the person or organization. |
VARCHAR2 |
100 |
GPA |
Gpa associated with the record. |
NUMBER |
|
GPA_2_DECIMALS |
Gpa 2 decimals associated with the record. |
NUMBER |
|
HAS_INCOMPLETE_GRADE |
Has incomplete grade associated with the record. |
VARCHAR2 |
1 |
HAS_MISSING_GRADE |
Has missing grade associated with the record. |
VARCHAR2 |
1 |
HAS_OPEN_GRADE |
Has open grade associated with the record. |
VARCHAR2 |
1 |
HAS_OX_ABSENCE_EXCUSED_GRADE |
Has ox absence excused grade associated with the record. |
VARCHAR2 |
1 |
HOME_DEPT |
Home dept associated with the record. |
VARCHAR2 |
6 |
IS_DOUBLE_MAJOR |
Indicator identifying whether double major (Y/N). |
VARCHAR2 |
1 |
LAST_ACTIVITY_DATE |
Date associated with last activity. |
DATE |
|
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 |
Surrogate key identifying the student term enrollment. |
VARCHAR2 |
15 |
STUDENT_YEAR |
Student year associated with the record. |
VARCHAR2 |
1 |
TERM_CODE |
Term code associated with the record. |
VARCHAR2 |
6 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |