EECS SUBJECT ENROLLMENT Table
Subject enrollment data specific to EECS students. For use by EECS users only.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CLUSTER_LIST |
A list that contains all the subjects in a cluster group. Cluster groups include subjects that are joint or meet together. For example, 7.02 and 10.702 are subjects in a cluster. So are: 7.10, 20.111; 6.265, 15.070; 2.111, 8.411, 18.435; etc. |
VARCHAR2 |
3000 |
CLUSTER_TYPE |
The type of a cluster subject. Valid cluster_type are: J (joint subjects), M (subjects that meet together), S (SWE - School-Wide Electives) |
VARCHAR2 |
1 |
COURSE_1 |
Identifies the primary program or course of major the student is enrolled in for the term. Examples: "6 3", "18", "15 M". For students who are both at the graduate and undergraduate level, the "first" ie. "1" course is always their graduate program/major. |
VARCHAR2 |
9 |
COURSE_2 |
Identifies the secondary program or course of major the student is enrolled in for the term. Examples: "6 3", "18", "15 M". |
VARCHAR2 |
9 |
COURSE_3 |
Identifies the third program or course of major the student is enrolled in for the term. Examples: "6 3", "18", "15 M". |
VARCHAR2 |
12 |
COURSE_DESCRIPTION_1 |
Descriptions for the primary program or course of major. For students who are both at the graduate and undergraduate level, the "first" ie. "1" course is always their graduate program/major. |
VARCHAR2 |
30 |
COURSE_DESCRIPTION_2 |
Descriptions for the second program or course of major. |
VARCHAR2 |
30 |
COURSE_DESCRIPTION_3 |
Descriptions for the third program or course of major. |
VARCHAR2 |
30 |
COURSE_LEVEL_1 |
The level (Graduate or Undergraduate) of the course of major. This is for the primary course of major of the student. For students who are both at the graduate and undergraduate level, the "first" ie. "1" course is always their graduate program/major. |
VARCHAR2 |
2 |
COURSE_LEVEL_2 |
The level (Graduate or Undergraduate) of the course of major. |
VARCHAR2 |
2 |
COURSE_LEVEL_3 |
The level (Graduate or Undergraduate) of the course of major. |
VARCHAR2 |
2 |
COURSE_OPTION_1 |
The major within the department/course/degree program, Eg. "3" in the Course "6 3", "C" in the Course "18 C". |
VARCHAR2 |
6 |
COURSE_OPTION_2 |
The major within the department/course/degree program, Eg. "3" in the Course "6 3", "C" in the Course "18 C". |
VARCHAR2 |
4 |
COURSE_OPTION_3 |
The major within the department/course/degree program, Eg. "3" in the Course "6 3", "C" in the Course "18 C". |
VARCHAR2 |
4 |
DEPT_1 |
Code identifying an academic department, eg. 18 for "Mathematics", 6 for "Electrical Eng & Computer Sci". This is the primary department of the student. For students who are both at the graduate and undergraduate level, the "first" ie. "1" department is always the department of their graduate program/major. |
VARCHAR2 |
6 |
DEPT_2 |
Code identifying an academic department, eg. 18 for "Mathematics", 6 for "Electrical Eng & Computer Sci". |
VARCHAR2 |
6 |
DEPT_3 |
Code identifying an academic department, eg. 18 for "Mathematics", 6 for "Electrical Eng & Computer Sci". |
VARCHAR2 |
6 |
EECS_SUBJECT_ID |
XXX |
VARCHAR2 |
8 |
FIRST_NAME |
The person's first name. |
VARCHAR2 |
30 |
FULL_NAME |
The full name of the person. |
VARCHAR2 |
90 |
HGN_CODE |
Code indentifies whether the subject can be taken at a graduate level: H (Higher level graduate program), G (Graduate program), N (Not for Graduate Credit). |
VARCHAR2 |
1 |
HGN_CODE_DESC |
Descriptive text for HGN_CODE which identifies whether the subject can be taken at a graduate level. H=Highler level graduate program; G=Graduate program; N=Not for graduate credit. |
VARCHAR2 |
30 |
HOME_DEPT |
The primary or home department of a student for the term |
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_INCLUDED_IN_FIFTH_WEEK |
'Y' indicates that this registration status should be included in the count of Fifth week enrollment. |
VARCHAR2 |
1 |
IS_LISTENER |
'Y' indicates that this is a "listener" registration status. |
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_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 |
MASTER_SUBJECT_ID |
The subject ID of a cluster subject group that indicates the administrative home of the subject. Cluster groups include joint, meets-with, and School-Wide Elective subjects. For example, 15.070 and 6.265 "Adv Stochastic Processes" are two joint subjects, Master Subject ID of these two subjects is 15.070 as Course 15 (Sloan School of Management) is the home department of this subject. |
VARCHAR2 |
8 |
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 |
REG_STATUS |
The student's status of registration in the subject. Possible values are: Registered, Registered Listener, Early Thesis, and UROP |
VARCHAR2 |
30 |
REG_STATUS_DATE |
The effective date of the registration status. |
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 |
SUBJECT_ID |
The subject ID (eg.18.01, 15.012, 21W.731) |
VARCHAR2 |
8 |
SUBJECT_TITLE |
The title of the subject |
VARCHAR2 |
100 |
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 |