EM STUDENT SCHEDULE SNAPSHOT Table
View exposing snapshot records of student schedules used for enrollment reporting and schedule analysis.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ALT1_CI_ATTRIBUTE |
Alt1 ci attribute associated with the record. |
VARCHAR2 |
10 |
ALT1_MASTER_SUBJ_ID |
Business identifier for the alt1 master subj. |
VARCHAR2 |
10 |
ALT1_SECTION |
Alt1 section associated with the record. |
VARCHAR2 |
5 |
ALT1_SECTION_REGISTRATION |
Alt1 section registration associated with the record. |
VARCHAR2 |
2 |
ALT1_STATUS |
Alt1 status associated with the record. |
VARCHAR2 |
10 |
ALT1_SUBJECT_ID |
Business identifier for the alt1 subject. |
VARCHAR2 |
10 |
ALT2_CI_ATTRIBUTE |
Alt2 ci attribute associated with the record. |
VARCHAR2 |
10 |
ALT2_MASTER_SUBJ_ID |
Business identifier for the alt2 master subj. |
VARCHAR2 |
10 |
ALT2_SECTION |
Alt2 section associated with the record. |
VARCHAR2 |
5 |
ALT2_SECTION_REGISTRATION |
Alt2 section registration associated with the record. |
VARCHAR2 |
2 |
ALT2_STATUS |
Alt2 status associated with the record. |
VARCHAR2 |
10 |
ALT2_SUBJECT_ID |
Business identifier for the alt2 subject. |
VARCHAR2 |
10 |
ELIGIBLE_TO_PREREGISTER |
Eligible to preregister associated with the record. |
VARCHAR2 |
2 |
HOME_DEPT |
Home dept associated with the record. |
VARCHAR2 |
4 |
INIT_CIH_REQ |
Init cih req associated with the record. |
VARCHAR2 |
30 |
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 |
60 |
PCT_REQ_COMPLETED |
Pct req completed associated with the record. |
NUMBER |
10,2 |
PRIMARY_CI_ATTRIBUTE |
Primary ci attribute associated with the record. |
VARCHAR2 |
10 |
PRIMARY_MASTER_SUBJ_ID |
Business identifier for the primary master subj. |
VARCHAR2 |
10 |
PRIMARY_SECTION |
Primary section associated with the record. |
VARCHAR2 |
5 |
PRIMARY_SECTION_REGISTRATION |
Primary section registration associated with the record. |
VARCHAR2 |
2 |
PRIMARY_STATUS |
Primary status associated with the record. |
VARCHAR2 |
10 |
PRIMARY_SUBJECT_ID |
Business identifier for the primary subject. |
VARCHAR2 |
10 |
PUT_ON_WAITLIST_CHECK |
Put on waitlist check associated with the record. |
VARCHAR2 |
2 |
RESERVATION |
Reservation associated with the record. |
VARCHAR2 |
2 |
SNAPSHOT_NAME |
Snapshot name associated with the record. |
VARCHAR2 |
25 |
SOURCE_CREATE_BY |
Source create by associated with the record. |
VARCHAR2 |
40 |
SOURCE_CREATE_DATE |
Date associated with source create. |
DATE |
|
SOURCE_MODIFY_BY |
Source modify by associated with the record. |
VARCHAR2 |
40 |
SOURCE_MODIFY_DATE |
Date associated with source modify. |
DATE |
|
STUDENT_REQUEST_ID |
Business identifier for the student request. |
VARCHAR2 |
32 |
STUDENT_SCHEDULE_KEY |
Surrogate key identifying the student schedule. |
VARCHAR2 |
100 |
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 |
1 |
WAREHOUSE_OS_USER |
Warehouse os user associated with the record. |
VARCHAR2 |
1 |
WAREHOUSE_UPDATE_DATE |
Date associated with warehouse update. |
DATE |
|
WAREHOUSE_UPDATE_USER |
Warehouse update user associated with the record. |
VARCHAR2 |
1 |