PRE REG SUBJECT Table
This is a dimension table for the Pre Registration Data. It contains all the subjects that students have pre-registered for the academic term.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
PRE_REG_SUBJECT_KEY |
Use this field to join between the PRE REG DETAIL and the PRE REG SUBJECT tables. |
VARCHAR2 |
15 |
SUBJECT_CODE |
The first part of a subject ID or the course number |
VARCHAR2 |
3 |
SUBJECT_CODE_SORT |
Department number or the first part of the Subject ID (such as 18 in subject 18.01, 21W in subject 21W.730). The subject codes in this field are prepended with a '0' to make the code 3 characters in length. This field is used for sorting/grouping the records by subject code. |
VARCHAR2 |
3 |
SUBJECT_ID |
The subject ID (eg.18.01, 15.012, 21W.731) |
VARCHAR2 |
8 |
SUBJECT_NUMBER |
Subject Number. The right half of the Subject ID, eg. 731 of Subject ID 21W.731. 'J' is never included. |
VARCHAR2 |
4 |
SUBJECT_OFFERED_STATUS |
Descriptive text for SUBJECT OFFERED STATUS CODE. |
VARCHAR2 |
30 |
SUBJECT_OFFERED_STATUS_CODE |
Subject offered status: O=Subject offered on campus, N or E=Subject not offered this term, C=Subject cancelled, B=Subject number not valid, X=Subject offered off campus. Students can pre-register for subjects that are not officially being offered. The status is associated with the student's pre-registered subjects. The status gets set multiple times: when the student pre-registers, when the student's pre-registration gets sent to be scheduled by the GASP process in MITSIS, and when the student's pre-registration gets loaded into the "registered" tables. At each of these points in time, the status gets set to whatever the current catalogue says about the subject. Since a subject may be offered early in the pre-registration process and then cancelled or vice versa, it is possible that one student's pre-registration record has an offered status for a particular subject, while another student's record says the subject is not offered. It depends on when the students pre-registered and what the course catalogue said at the point in time. It all gets cleared up before the student is scheduled or registered. |
VARCHAR2 |
2 |
SUBJECT_TITLE |
The title of the subject |
VARCHAR2 |
100 |
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 |