STUDENT AUDIT SUMMARY Table
View exposing student audit summary data.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AUDIT_CLASS |
Audit class associated with the record. |
VARCHAR2 |
4 |
AUDIT_DATE |
Date associated with audit. |
DATE |
|
AUDIT_ID |
Business identifier for the audit. |
NUMBER |
8 |
AUDIT_LEVEL |
Audit level associated with the record. |
VARCHAR2 |
2 |
AUDIT_TEXT |
Audit text associated with the record. |
VARCHAR2 |
32767 |
COMPLETED_UNITS |
Completed units associated with the record. |
NUMBER |
|
COURSE_AUDIT_PROGRAM_CODE_1 |
Course audit program code 1 associated with the record. |
VARCHAR2 |
4 |
COURSE_AUDIT_PROGRAM_CODE_2 |
Course audit program code 2 associated with the record. |
VARCHAR2 |
4 |
CUMULATIVE_GPA |
Cumulative gpa associated with the record. |
NUMBER |
|
EARLY_SOPHOMORE_TERM_CODE |
Code identifying early sophomore term. |
VARCHAR2 |
6 |
GIR_SUBJECT_COMPLETED |
Gir subject completed associated with the record. |
NUMBER |
3,1 |
GIR_SUBJECT_REQUIRED |
Gir subject required associated with the record. |
NUMBER |
3,1 |
H_G_UNITS |
H g units associated with the record. |
NUMBER |
3 |
H_UNITS |
H units associated with the record. |
NUMBER |
3 |
IS_DEGREE_CANDIDATE |
Indicator identifying whether degree candidate (Y/N). |
VARCHAR2 |
1 |
IS_EARLY_SOPHOMORE |
Indicator identifying whether early sophomore (Y/N). |
VARCHAR2 |
1 |
LAST_ACTIVITY_DATE |
Date associated with last activity. |
DATE |
|
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 ratio associated with the record. |
NUMBER |
3,2 |
SCHOOL_AUDIT_PROGRAM_CODE_1 |
School audit program code 1 associated with the record. |
VARCHAR2 |
4 |
SCHOOL_AUDIT_PROGRAM_CODE_2 |
School audit program code 2 associated with the record. |
VARCHAR2 |
4 |
STUDENT_AUDIT_SUMMARY_KEY |
Surrogate key identifying the student audit summary. |
NUMBER |
8 |
UNITS_UBS_COMPLETED |
Units ubs completed associated with the record. |
NUMBER |
3 |
UNITS_UBS_REQUIRED |
Units ubs required associated with the record. |
NUMBER |
3 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |