Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse TEACHING EVALUATION Table


View exposing summarized teaching evaluation results by term, survey window, subject, section, and teaching role including enrollment counts, response counts, teaching and course rating statistics, and rating scale.


Field Name

Description

Data Type

Length

CLUSTER_LIST

Cluster list associated with the record.

VARCHAR2

600

COURSE_RATING_AVG

Course rating avg associated with the record.

NUMBER

15,4

COURSE_RATING_NUM_RESPONDED

Course rating num responded associated with the record.

NUMBER

19

COURSE_RATING_STD

Course rating std associated with the record.

NUMBER

15,4

MASTER_SUBJECT_ID

Business identifier for the master subject.

VARCHAR2

32

MIT_ID

MIT ID number of the person. Use this field to join with other tables containing data about people at MIT.

VARCHAR2

9

NUM_RESPONDED_TO_SURVEY

Num responded to survey associated with the record.

NUMBER

19

OSE_SUBJECT_KEY

Surrogate key identifying the ose subject.

VARCHAR2

25

RATING_SCALE

Rating scale associated with the record.

CHAR

SECTION_ENROLLMENT

Section enrollment associated with the record.

NUMBER

18

SECTION_ID

Business identifier for the section.

VARCHAR2

3

SECTION_TYPE

Section type associated with the record.

VARCHAR2

60

SUBJECT_ENROLLMENT

Subject enrollment associated with the record.

NUMBER

18

SUBJECT_ID

Business identifier for the subject.

VARCHAR2

8

SUBJECT_OR_CLUSTER

Subject or cluster associated with the record.

VARCHAR2

100

SUBJECT_TITLE

Subject title associated with the record.

VARCHAR2

240

SURVEY_ID

Business identifier for the survey.

NUMBER

8

SURVEY_WINDOW

Survey window associated with the record.

VARCHAR2

100

TEACHING_RATING_AVG

Teaching rating avg associated with the record.

NUMBER

15,4

TEACHING_RATING_NUM_RESPONDED

Teaching rating num responded associated with the record.

NUMBER

19

TEACHING_RATING_STD

Teaching rating std associated with the record.

NUMBER

15,4

TEACHING_ROLE

Teaching role 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