SUBJECT ENROLLMENT SUMMARY Table
Subject enrollment data at subject level. There is one record per academic term, per student, per subject regardless of the sections the student is enrolled in.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACADEMIC_TERMS_KEY |
Use this field to join to the ACADEMIC_TERMS table to get information about the academic term(s). |
VARCHAR2 |
6 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
REG_STATUS_DATE |
The effective date of the registration status. |
DATE |
8 |
STUDENT_COUNT |
Used to count a student on a report. Always contains a value of 1. |
NUMBER |
1 |
STUDENT_TERM_ENROLLMENT_KEY |
Use this field to join to the STUDENT TERM ENROLLMENT table |
VARCHAR2 |
15 |
SUBJECT_GROUPING_KEY |
Use this field to join together the Subject Grouping, Subject, Subject Enrollment tables. |
VARCHAR2 |
32 |
SUBJECT_OFFERED_SUMMARY_KEY |
Use this field to join together the Subject and Subject Enrollment tables. |
VARCHAR2 |
14 |
SUBJECT_REG_STATUS_KEY |
Key field used to join to the SUBJECT_REG_STATUS table. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
2 |
SUBJECT_SUMMARY_KEY |
Use this field to join together the Subject and Subject Enrollment tables. |
VARCHAR2 |
14 |
TOTAL_UNITS |
Total number of credit units of a subject. |
NUMBER |
2 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |