EECS SUBJECT ENROLLMENT Table
View exposing EECS subject enrollment detail by term and subject including registration status, listener and fifth-week indicators, student identifiers, course affiliations, and confidentiality flags.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CLUSTER_LIST |
Cluster list associated with the record. |
VARCHAR2 |
150 |
CLUSTER_TYPE |
Cluster type associated with the record. |
VARCHAR2 |
1 |
COURSE_1 |
Course 1 associated with the record. |
VARCHAR2 |
9 |
COURSE_2 |
Course 2 associated with the record. |
VARCHAR2 |
9 |
COURSE_3 |
Course 3 associated with the record. |
VARCHAR2 |
9 |
COURSE_DESCRIPTION_1 |
Course description 1 associated with the record. |
VARCHAR2 |
30 |
COURSE_DESCRIPTION_2 |
Course description 2 associated with the record. |
VARCHAR2 |
30 |
COURSE_DESCRIPTION_3 |
Course description 3 associated with the record. |
VARCHAR2 |
30 |
COURSE_LEVEL_1 |
Course level 1 associated with the record. |
VARCHAR2 |
2 |
COURSE_LEVEL_2 |
Course level 2 associated with the record. |
VARCHAR2 |
2 |
COURSE_LEVEL_3 |
Course level 3 associated with the record. |
VARCHAR2 |
2 |
COURSE_OPTION_1 |
Course option 1 associated with the record. |
VARCHAR2 |
4 |
COURSE_OPTION_2 |
Course option 2 associated with the record. |
VARCHAR2 |
4 |
COURSE_OPTION_3 |
Course option 3 associated with the record. |
VARCHAR2 |
4 |
DEPT_1 |
Dept 1 associated with the record. |
VARCHAR2 |
6 |
DEPT_2 |
Dept 2 associated with the record. |
VARCHAR2 |
6 |
DEPT_3 |
Dept 3 associated with the record. |
VARCHAR2 |
6 |
EECS_SUBJECT_ID |
Business identifier for the eecs subject. |
VARCHAR2 |
8 |
FIRST_NAME |
First name associated with the record. |
VARCHAR2 |
15 |
FULL_NAME |
Full name associated with the record. |
VARCHAR2 |
93 |
HGN_CODE |
Code identifying hgn. |
VARCHAR2 |
1 |
HGN_CODE_DESC |
Description of hgn code. |
VARCHAR2 |
29 |
HOME_DEPT |
Home dept associated with the record. |
VARCHAR2 |
6 |
IS_COURSE_CONFIDENTIAL |
Indicator identifying whether course confidential (Y/N). |
VARCHAR2 |
1 |
IS_INCLUDED_IN_FIFTH_WEEK |
Indicator identifying whether included in fifth week (Y/N). |
VARCHAR2 |
1 |
IS_LISTENER |
Indicator identifying whether listener (Y/N). |
VARCHAR2 |
1 |
IS_REGISTERED |
Indicator identifying whether registered (Y/N). |
VARCHAR2 |
1 |
IS_YEAR_CONFIDENTIAL |
Indicator identifying whether year confidential (Y/N). |
VARCHAR2 |
1 |
LAST_NAME |
Last name associated with the record. |
VARCHAR2 |
60 |
MASTER_SUBJECT_ID |
Business identifier for the master subject. |
VARCHAR2 |
8 |
MIDDLE_NAME |
Middle name associated with the record. |
VARCHAR2 |
15 |
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 |
Reg status associated with the record. |
VARCHAR2 |
40 |
REG_STATUS_DATE |
Date associated with reg status. |
DATE |
|
STUDENT_YEAR |
Student year associated with the record. |
VARCHAR2 |
1 |
SUBJECT_ID |
Business identifier for the subject. |
VARCHAR2 |
8 |
SUBJECT_TITLE |
Subject title associated with the record. |
VARCHAR2 |
60 |
TERM_CODE |
Code identifying term. |
VARCHAR2 |
6 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |