PRE REG STUDENT STATUS Table
This is a dimension table for the Pre Registration Data. There is one record for an academic term that a student has pre-registered. The record contains the status information of the pre-registration process.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
FULL_NAME |
The full name of the person. |
VARCHAR2 |
90 |
HAS_REG_DATA_BEEN_INPUT |
Y=Registration form data hase been input for the student. N=Registration form data has not been input, still pre-registration data. |
VARCHAR2 |
1 |
LAST_UPDATED_DATE |
Date the record was last updated. |
DATE |
8 |
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_STUDENT_STATUS_KEY |
Use this field to join between the PRE REG DETAIL table and the PRE REG STUDENT STATUS table. |
VARCHAR2 |
15 |
SCHEDULE_STATUS |
Descriptions for SCHEDULE STATUS CODE. |
VARCHAR2 |
30 |
SCHEDULE_STATUS_CODE |
Codes indicating if student's pre-registration has been scheduled: PR=Pre-registered - not scheduled; RG=Pre-registered - schedule; UP=Pre-registered - schedule; RE=Registered. |
VARCHAR2 |
2 |
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 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |