EM WAITLIST SNAPSHOT Table
View exposing snapshot records of student waitlist activity and status used for enrollment reporting and operational analysis.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CIH_REQ |
Cih req associated with the record. |
VARCHAR2 |
30 |
CI_ATTRIBUTE |
Ci attribute associated with the record. |
VARCHAR2 |
10 |
ELIGIBLE_TO_PREREGISTER |
Eligible to preregister associated with the record. |
VARCHAR2 |
2 |
HOME_DEPT |
Home dept associated with the record. |
VARCHAR2 |
4 |
KERBEROS_ID |
Business identifier for the kerberos. |
VARCHAR2 |
10 |
MASTER_SUBJ_ID |
Business identifier for the master subj. |
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 |
OFFER_BY |
Offer by associated with the record. |
VARCHAR2 |
10 |
OFFER_RECEIVED_DATE |
Date associated with offer received. |
DATE |
|
PCT_REQ_COMPLETED |
Pct req completed associated with the record. |
NUMBER |
10,2 |
SECTION |
Section associated with the record. |
VARCHAR2 |
5 |
SECTION_REGISTRATION |
Section registration associated with the record. |
VARCHAR2 |
2 |
SNAPSHOTNAME |
Snapshotname associated with the record. |
VARCHAR2 |
25 |
SUBJECT_ID |
Business identifier for the subject. |
VARCHAR2 |
10 |
TERM_CODE |
Code identifying term. |
VARCHAR2 |
6 |
TIMEFRAME |
Timeframe associated with the record. |
VARCHAR2 |
30 |
TLGM_CODE |
Code identifying tlgm. |
VARCHAR2 |
5 |
UNDERGRADUATE_YEAR |
Undergraduate year associated with the record. |
VARCHAR2 |
2 |
WAITLIST_PRIORITY |
Waitlist priority associated with the record. |
NUMBER |
3 |
WAITLIST_REQUEST_ID |
Business identifier for the waitlist request. |
VARCHAR2 |
32 |
WAITLIST_REQUEST_SOURCE |
Waitlist request source associated with the record. |
VARCHAR2 |
30 |
WAITLIST_SNAPSHOT_KEY |
Surrogate key identifying the waitlist snapshot. |
VARCHAR2 |
100 |
WAITLIST_STATUS |
Waitlist status associated with the record. |
VARCHAR2 |
20 |
WAITLIST_STATUS_DATE |
Date associated with waitlist status. |
DATE |
|
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 |