EM STUDENT SUBJ SELECTOR USE Table
View exposing records of student subject selector usage associated with enrollment planning and subject selection activity.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CIH_REQ |
Cih req associated with the record. |
VARCHAR2 |
64 |
ELIGIBLE_TO_PREREGISTER |
Eligible to preregister associated with the record. |
VARCHAR2 |
2 |
HOME_DEPT |
Home dept associated with the record. |
VARCHAR2 |
4 |
IS_SNAPSHOT_DATA |
Indicator identifying whether snapshot data (Y/N). |
VARCHAR2 |
3 |
KERBEROS_ID |
Business identifier for the kerberos. |
VARCHAR2 |
10 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
10 |
NAME |
Name associated with the record. |
VARCHAR2 |
90 |
PCT_REQ_COMPLETED |
Pct req completed associated with the record. |
NUMBER |
10,2 |
PICK_SUBJ_SCHEDULING |
Pick subj scheduling associated with the record. |
VARCHAR2 |
2 |
PICK_SUBJ_WAITLIST |
Pick subj waitlist associated with the record. |
VARCHAR2 |
2 |
SNAPSHOT_NAME |
Snapshot name associated with the record. |
VARCHAR2 |
25 |
STUDENT_YEAR |
Student year associated with the record. |
VARCHAR2 |
5 |
TERM_CODE |
Code identifying term. |
VARCHAR2 |
6 |
TLGM_CODE |
Code identifying tlgm. |
VARCHAR2 |
5 |
UNDERGRADUATE_YEAR |
Undergraduate year associated with the record. |
VARCHAR2 |
2 |
WAREHOUSE_CREATE_DATE |
Date associated with warehouse create. |
DATE |
|
WAREHOUSE_CREATE_USER |
Warehouse create user associated with the record. |
VARCHAR2 |
12 |