EPR COURSE AND EVALUATION Table
View exposing course and evaluation records associated with Employee Professional Record data used for teaching activity reporting and review.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACADEMIC_TERM |
Academic term associated with the record. |
VARCHAR2 |
30 |
COURSE_LOCATION |
Course location associated with the record. |
VARCHAR2 |
100 |
COURSE_NUMBER |
Course number associated with the record. |
VARCHAR2 |
30 |
COURSE_TITLE |
Course title associated with the record. |
VARCHAR2 |
200 |
COURSE_TYPE |
Course type associated with the record. |
VARCHAR2 |
60 |
DATA_SOURCE |
Data source associated with the record. |
VARCHAR2 |
16 |
ENROLLMENT_NUMBER |
Enrollment number associated with the record. |
NUMBER |
5 |
INSTRUCTOR_RATING |
Instructor rating associated with the record. |
NUMBER |
5,2 |
IS_EVALUATION_GIVEN |
Indicator identifying whether evaluation given (Y/N). |
VARCHAR2 |
1 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
NUMBER_OF_SURVEY_RESPONSES |
Number of survey responses associated with the record. |
NUMBER |
5 |
OVERALL_COURSE_RATING |
Overall course rating associated with the record. |
NUMBER |
5,2 |
RATING_SCALE |
Rating scale associated with the record. |
VARCHAR2 |
30 |
SOURCE_LAST_UPDATE_DATE |
Date associated with source last update. |
DATE |
|
TEACHING_ROLE |
Teaching role associated with the record. |
VARCHAR2 |
100 |
TERM |
Term associated with the record. |
VARCHAR2 |
50 |
TERM_CODE |
Code identifying term. |
VARCHAR2 |
6 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |
|
YEAR |
Year associated with the record. |
VARCHAR2 |
6 |