PRE REG DETAIL STELLAR Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
DOCTOR_OR_MASTER_THESIS |
Whether this subject will be taken for a Doctoral or a Master thesis. |
VARCHAR2 |
25 |
ENROLLMENT_KEY |
Use this field to join the STUDENT TERM ENROLLMENT table with another student table which contains the same-name KEY field. This field should only be used for joining tables, not for reporting. |
VARCHAR2 |
15 |
GASP_ACTION_REQUEST |
GASP action request is used to inform the GASP process on MITSIS of an change since the last GASP scheduling run. It is possible to run GASP multiple times. The action requests include: "(A)=subject was added to schedule", "(C)=section for subject was changed","(D)=subject was deleted from pre-registration." |
VARCHAR2 |
20 |
HGN |
This field in the CIS COURSE CATALOG table contains of 3 possible codes: U=Undergraduate, G=Graduate, H=High Graduate. This code is different from the HGN CODE in SUBJECT_OFFERED. |
VARCHAR2 |
30 |
LAST_UPDATED_DATE |
Date the record was last updated. |
DATE |
|
LISTENER_OR_PASS_FAIL |
Whether this subject will be taken as "Listener" or "Pass/Fail". |
VARCHAR2 |
25 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
PRE_REG_SECTION_KEY |
Use this field to join between the PRE REG DETAIL and the PRE REG SECTION tables. |
VARCHAR2 |
15 |
PRE_REG_STUDENT_STATUS_KEY |
Use this field to join between the PRE REG DETAIL table and the PRE REG STUDENT STATUS table. |
VARCHAR2 |
15 |
PRE_REG_SUBJECT_KEY |
Use this field to join between the PRE REG DETAIL and the PRE REG SUBJECT tables. |
VARCHAR2 |
15 |
STUDENT_TERM_ENROLLMENT_KEY |
Use this field to join to the STUDENT TERM ENROLLMENT table |
VARCHAR2 |
15 |
VARIABLE_UNITS |
Number of units pre-registered for subjects with variable unit. |
NUMBER |
|
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |