EPR COURSE AND EVALUATION Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACADEMIC_TERM |
The code of the academic term into which the fiscal period falls. Examples: 2003FA (Fall Term 2002-2003), 2003SP (Spring term 2002-2003). |
VARCHAR2 |
30 |
COURSE_LOCATION |
XXX |
VARCHAR2 |
100 |
COURSE_NUMBER |
Course number or first part of the Subject ID (such as 6, 15, 18, 21W). |
VARCHAR2 |
30 |
COURSE_TITLE |
XXX |
VARCHAR2 |
200 |
COURSE_TYPE |
XXX |
VARCHAR2 |
60 |
DATA_SOURCE |
Source of the data in this record. |
VARCHAR2 |
16 |
ENROLLMENT_NUMBER |
XXX |
NUMBER |
5 |
INSTRUCTOR_RATING |
XXX |
NUMBER |
5,2 |
IS_EVALUATION_GIVEN |
XXX |
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 |
XXX |
NUMBER |
5 |
OVERALL_COURSE_RATING |
XXX |
NUMBER |
5,2 |
RATING_SCALE |
XXX |
VARCHAR2 |
30 |
SOURCE_LAST_UPDATE_DATE |
XXX |
DATE |
|
TEACHING_ROLE |
Teaching roles, eg. Lecturer, Recitation Lecturer, Lab Instructor, Teaching Assistant, Writing Instructor, etc. |
VARCHAR2 |
100 |
TERM |
The current academic term code (eg. 2000FA, 2000SP) |
VARCHAR2 |
50 |
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 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
|
YEAR |
In KRB_PERSON, YEAR is a one-character field identifying the students year of degree (or current year); eg.: 1, 2, 3, 4, G, U. In TIP_MATERIAL YEAR is a Year when a Title was published |
VARCHAR2 |
6 |