EM FINAL ALGOR RESULT SPSHOT Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ALGORITHM_PRIORITY |
XXX |
NUMBER |
38 |
ALT1_CI_ATTRIBUTE |
XXX |
VARCHAR2 |
10 |
ALT1_MASTER_SUBJ_ID |
XXX |
VARCHAR2 |
10 |
ALT1_SECTION |
XXX |
VARCHAR2 |
5 |
ALT1_SECTION_REGISTRATION |
XXX |
VARCHAR2 |
2 |
ALT1_STATUS |
XXX |
VARCHAR2 |
10 |
ALT1_SUBJECT_ID |
XXX |
VARCHAR2 |
10 |
ALT2_CI_ATTRIBUTE |
XXX |
VARCHAR2 |
10 |
ALT2_MASTER_SUBJ_ID |
XXX |
VARCHAR2 |
10 |
ALT2_SECTION |
XXX |
VARCHAR2 |
5 |
ALT2_SECTION_REGISTRATION |
XXX |
VARCHAR2 |
2 |
ALT2_STATUS |
XXX |
VARCHAR2 |
10 |
ALT2_SUBJECT_ID |
XXX |
VARCHAR2 |
10 |
ASSIGNED_MASTER_SUBJECT |
XXX |
VARCHAR2 |
10 |
ASSIGNED_SECTION |
XXX |
VARCHAR2 |
5 |
ASSIGNED_SUBJECT |
XXX |
VARCHAR2 |
10 |
CHOICE |
XXX |
VARCHAR2 |
5 |
CIH_REQ |
XXX |
VARCHAR2 |
30 |
ELIGIBLE_TO_PREREGISTER |
XXX |
VARCHAR2 |
2 |
FINAL_ALGORITHM_RESULT_KEY |
XXX |
VARCHAR2 |
100 |
HOME_DEPT |
The primary or home department of a student for the term |
VARCHAR2 |
4 |
KERBEROS_ID |
Kerberos ID |
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 |
XXX |
VARCHAR2 |
60 |
PCT_REQ_COMPLETED |
XXX |
NUMBER |
10,2 |
PRIMARY_CI_ATTRIBUTE |
XXX |
VARCHAR2 |
10 |
PRIMARY_MASTER_SUBJ_ID |
XXX |
VARCHAR2 |
10 |
PRIMARY_SECTION |
XXX |
VARCHAR2 |
5 |
PRIMARY_SECTION_REGISTRATION |
XXX |
VARCHAR2 |
2 |
PRIMARY_STATUS |
XXX |
VARCHAR2 |
10 |
PRIMARY_SUBJECT_ID |
XXX |
VARCHAR2 |
10 |
PUT_ON_WAITLIST_CHECK |
XXX |
VARCHAR2 |
2 |
REQUEST_SNAPSHOT_ID |
XXX |
VARCHAR2 |
32 |
RESERVATION |
XXX |
VARCHAR2 |
2 |
SOURCE_CREATE_BY |
XXX |
VARCHAR2 |
40 |
SOURCE_CREATE_DATE |
XXX |
DATE |
|
SOURCE_MODIFY_BY |
XXX |
VARCHAR2 |
40 |
SOURCE_MODIFY_DATE |
XXX |
DATE |
|
STUDENT_REQUEST_ID |
XXX |
VARCHAR2 |
32 |
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 |
TLGM_CODE |
XXX |
VARCHAR2 |
5 |
UNDERGRADUATE_YEAR |
XXX |
VARCHAR2 |
2 |
WAREHOUSE_CREATE_DATE |
XXX |
DATE |
|
WAREHOUSE_CREATE_USER |
XXX |
VARCHAR2 |
1 |
WAREHOUSE_OS_USER |
XXX |
VARCHAR2 |
1 |
WAREHOUSE_UPDATE_DATE |
XXX |
DATE |
|
WAREHOUSE_UPDATE_USER |
XXX |
VARCHAR2 |
1 |