PRE REG DETAIL Table
This table contains Student's Pre Registration information for the upcoming academic term. There is one record per subject a student pre-registers for the term. Pre-registration information about the subject includes the specific sections (Lecture, Recitation, Lab, Design), number of units (for a variable unit subject) the student pre-registers for, and also whether the student pre-registers the subject as a Listener, Pass/Fail, Doctor or Master Thesis, or at a Graduate Level or a Higher Level Graduate.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
DESIGN_SECTION_CONFLICT |
XXX |
VARCHAR2 |
1 |
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 |
LAB_SECTION_CONFLICT |
XXX |
VARCHAR2 |
1 |
LAST_UPDATED_DATE |
Date the record was last updated. |
DATE |
8 |
LECTURE_SECTION_CONFLICT |
XXX |
VARCHAR2 |
1 |
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 |
RECITATION_SECTION_CONFLICT |
XXX |
VARCHAR2 |
1 |
REG_SOURCE |
XXX |
VARCHAR2 |
60 |
REG_SOURCE_CODE |
XXX |
VARCHAR2 |
1 |
STUDENT_TERM_ENROLLMENT_KEY |
Use this field to join to the STUDENT TERM ENROLLMENT table |
VARCHAR2 |
15 |
SUBJECT_STATUS |
XXX |
VARCHAR2 |
100 |
SUBJECT_STATUS_CODE |
XXX |
VARCHAR2 |
2 |
VARIABLE_UNITS |
Number of units pre-registered for subjects with variable unit. |
NUMBER |
2 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |