STUDENT GRADE DETAIL Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CLUSTER_TYPE |
The type of a cluster subject. Valid cluster_type are: J (joint subjects), M (subjects that meet together), S (SWE - School-Wide Electives) |
VARCHAR2 |
1 |
DEGREE_LEVEL |
In SUBJECT_AUDIT_DETAIL: 'U'=Undergraduate, 'G'=Graduate |
VARCHAR2 |
2 |
DESIGN_UNITS |
Engineering design points |
NUMBER |
2 |
GMOD_CODE |
XXX |
VARCHAR2 |
1 |
GMOD_DESC |
XXX |
VARCHAR2 |
30 |
GRADE |
Grade symbol or letter |
VARCHAR2 |
5 |
GRADE_DESCRIPTION |
Description of the grade symbol |
VARCHAR2 |
30 |
HGN_CODE |
Code indentifies whether the subject can be taken at a graduate level: H (Higher level graduate program), G (Graduate program), N (Not for Graduate Credit). |
VARCHAR2 |
1 |
LAB_UNITS |
The number of credit units assigned for laboratory, design, or fieldwork of a subject |
NUMBER |
2 |
LECTURE_UNITS |
The number of credit units assigned for lecture and recitation of a subject. |
NUMBER |
2 |
MASTER_SUBJECT_ID |
The subject ID of a cluster subject group that indicates the administrative home of the subject. Cluster groups include joint, meets-with, and School-Wide Elective subjects. For example, 15.070 and 6.265 "Adv Stochastic Processes" are two joint subjects, Master Subject ID of these two subjects is 15.070 as Course 15 (Sloan School of Management) is the home department of this subject. |
VARCHAR2 |
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 |
PREP_UNITS |
Total units for preparation of the course |
NUMBER |
2 |
STUDENT_TERM_ENROLLMENT_KEY |
Use this field to join to the STUDENT TERM ENROLLMENT table |
VARCHAR2 |
15 |
SUBJECT_ATTRIBUTE_LIST |
List of attributes this subject fulfills for degree requirements. Each attribute is separated by a comma in the list. Some examples of subject attribute lists are: "PHY1", "REST", "HA,HE", "CIH,HA,HD3,HE", "CAL1", "CIHW,HE,HH". You may look at the SUBJECT_ATTRIBUTE table for more information about each of the subject attribute. |
VARCHAR2 |
60 |
SUBJECT_ID |
The subject ID (eg.18.01, 15.012, 21W.731) |
VARCHAR2 |
8 |
SUBJECT_REG_STATUS |
Subject Registration Status. |
VARCHAR2 |
40 |
SUBJECT_REG_STATUS_CODE |
Subject registration code. Eg. RE (Registered), RL (Registered Listener), DE (Dropped Early, Not recorded), DR (Dropped after 5th week, on record), ET (Early thesis), AP (Advanced Placement), etc. You may query the SUBJECT_REG_STATUS table for more information about subject registration status. |
VARCHAR2 |
2 |
SUBJECT_REG_STATUS_DATE |
Date when subject registration status was last modified |
DATE |
|
SUBJECT_SUMMARY_KEY |
Use this field to join together the Subject and Subject Enrollment tables. |
VARCHAR2 |
14 |
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 |
TERM_DESCRIPTION |
Long text associated with the TERM_CODE for STUDENT data (Example: Fall 1996, Spring 1997.) |
VARCHAR2 |
30 |
THESIS_IND |
'U' indicates that this is a undergraduate thesis subject, 'G' indicates that this is a graduate thesis subject. |
VARCHAR2 |
1 |
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 |