STUDENT AUDIT SUMMARY Table
Student's degree audit profile and summary data. One record per student per degree level (Undergraduate or Graduate).
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AUDIT_CLASS |
The student class/year (eg. Class of 2014, Class of 2015) for which the degree audit is applied. |
VARCHAR2 |
4 |
AUDIT_DATE |
Date when the degree audit program was run. |
DATE |
8 |
AUDIT_ID |
An identifier for the student audit record in STUDENT_AUDIT_SUMMARY and STUDENT_AUDIT_STRIP. |
NUMBER |
8 |
AUDIT_LEVEL |
'U'=Undergraduate degree audit, 'G'=Graduate degree audit |
VARCHAR2 |
2 |
AUDIT_TEXT |
XXX |
VARCHAR2 |
4000 |
COMPLETED_UNITS |
Number of units completed |
NUMBER |
4 |
COURSE_AUDIT_PROGRAM_CODE_1 |
The department section of the Course of Major. Eg. For Course of Major "18 C", this is "18". For Course of Major "6 3", this is "6". Combining COURSE_AUDIT_PROGRAM_CODE_1 and COURSE_AUDIT_PROGRAM_CODE_2 will yield the Course of Major (eg. 18 C, 6 3) for the degree audit. |
VARCHAR2 |
4 |
COURSE_AUDIT_PROGRAM_CODE_2 |
The second part of the Course of Major. Eg. For Course of Major "18 C", this is "C". For Course of Major "6 3", this is "6. Combining COURSE_AUDIT_PROGRAM_CODE_1 and COURSE_AUDIT_PROGRAM_CODE_2 will yield the Course of Major (eg. 18 C, 6 3) for the degree audit. |
VARCHAR2 |
4 |
CUMULATIVE_GPA |
Cumulative GPA |
NUMBER |
3.1 |
EARLY_SOPHOMORE_TERM_CODE |
XXX |
VARCHAR2 |
6 |
GIR_SUBJECT_COMPLETED |
Number of GIR (General Institute Requirements) subjects completed. |
NUMBER |
3.1 |
GIR_SUBJECT_REQUIRED |
Number of GIR (General Institute Requirements) subjects required. |
NUMBER |
3.1 |
H_G_UNITS |
Number of units in higher graduate level (H) and graduate level (G) subjects. |
NUMBER |
3 |
H_UNITS |
Number of units in higher graduate level subjects. |
NUMBER |
3 |
IS_DEGREE_CANDIDATE |
A flag indicates whether the student is a degree candidate for the next degree award term. Y (Yes), N (No). |
VARCHAR2 |
1 |
IS_EARLY_SOPHOMORE |
XXX |
VARCHAR2 |
1 |
LAST_ACTIVITY_DATE |
Date when information in 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 |
PROGRESS_RATIO |
Progress towards completion of the Institute requirements, between 0 and 1. |
NUMBER |
3.2 |
SCHOOL_AUDIT_PROGRAM_CODE_1 |
'MIT' = undergraduate degree audit, 'GRAD'= graduate degree audit |
VARCHAR2 |
4 |
SCHOOL_AUDIT_PROGRAM_CODE_2 |
Not in use. |
VARCHAR2 |
4 |
STUDENT_AUDIT_SUMMARY_KEY |
Use this field to join together the STUDENT_AUDIT_SUMMARY and the SUBJECT_AUDIT_DETAIL tables for the degree audit profile and the subject details. |
NUMBER |
8 |
UNITS_UBS_COMPLETED |
Units Beyond GIRs Completed. |
NUMBER |
3.1 |
UNITS_UBS_REQUIRED |
Units Beyond GIRs Required. |
NUMBER |
3.1 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |