EECS FRESHMAN Table
Freshmen for the academic year. For use by EECS users only.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ATTENDED |
A flag indicating the student actually attended for any time during the current term. Values are Y or N. NOTE: This includes students who started the term and subsequently withdrew or completed their thesis early and are now gone. Use this field instead of the REGISTERED flag if you want to include these types of students. |
VARCHAR2 |
1 |
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 |
COURSE_OPTION |
The major within the department/course/degree program, Eg. "3" in the Course "6 3", "C" in the Course "18 C". |
VARCHAR2 |
4 |
ELIGIBLE_TO_REG |
A flag indicating the student is eligible to register for the term. Values include Y or N. NOTE: this flag means that the student has basic eligibility to register from the Registrar's perspective, i.e., s/he has been admitted for this term, is returning from a leave of absence or is a continuing student and has not graduated and has NOT been forced to withdraw for disciplinary or academic reasons. It does NOT MEAN that the student HAS NO HOLDS, financial, medical, or otherwise. |
VARCHAR2 |
1 |
EMAIL_ADDRESS |
A person's complete electronic mail address including user name and node name, for example, username@school.edu. |
VARCHAR2 |
60 |
ENROLL_STATUS |
The status of the student's registration for the term. Values include: Eligible to register, Registered, Early Thesis, Withdrew After 5th Week, etc. In the STUDENT and STUDENT_TERM_ENROLLMENT tables, only the codes (eg. EL, RE, ET, WR, WE) are shown. |
VARCHAR2 |
2 |
ENROLL_STATUS_DESCRIPTION |
Descriptive text for ENROLL_STATUS |
VARCHAR2 |
50 |
FIRST_NAME |
The person's first name. |
VARCHAR2 |
30 |
HOME_DEPARTMENT |
The home (major) department of a person. |
VARCHAR2 |
4 |
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_E_MAIL_CONFIDENTIAL |
A "Y" or "S" in this field indicates that the student wants his/her email address 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 |
LAST_NAME |
The person's last name. |
VARCHAR2 |
30 |
LOAD_LEVEL_CODE |
Code indicating the level of the load the student is taking this term. Values include: 3Q=3 quarters time,FT=full time,HT=half time,LH=Less than half time. This field may be blank if student never attended this term. |
VARCHAR2 |
2 |
LOAD_LEVEL_CODE_DESCRIPTION |
Descriptive text for LOAD_LEVEL_CODE |
VARCHAR2 |
50 |
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 |
REGISTERED |
A flag indicating the student is curently registered in the term. Values include Y or N. NOTE: A student who left (withdrew or finished early due to early thesis) will have an N in this field because he/she is not CURRENTLY registered-even though he/she had been registered. See ATTENDED for a better way to identify these kinds of students. |
VARCHAR2 |
1 |
REG_GROUP |
Registration Group. Values include:C=Continuing Registration or Non-resident Student,E=Entering Freshman (Reg),F=Registered Student with Former Attendance,N=New Regular Grad Student,O=New Special/Cross-Registered Student,P=Speciall/Cross-Registered, Previously Attended, R=New Regular Grad/Former MIT undegraduate,T=Entering Transfer Student (Reg). |
VARCHAR2 |
1 |
REG_GROUP_DESCRIPTION |
Descriptive text for REG_GROUP |
VARCHAR2 |
50 |
REG_TYPE |
Registration type. Values include:N=Regular Non-Resident Student, R=Regular Resident Student, S=Special Student, X=Cross Registered or Exchange Student. |
VARCHAR2 |
1 |
REG_TYPE_DESCRIPTION |
Descriptive text for REG_TYPE |
VARCHAR2 |
50 |
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 |
UNITS_OF_LOAD |
Total of the subject units that the student is registered for this term. Includes subjects registered for as a listener. |
NUMBER |
3 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |