OSE RESPONSE RAW Table
View exposing raw online subject evaluation responses including survey, subject, section, instructor, question, and answer values across numeric, Likert, multiple-choice, multiple-select, and open-ended responses.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ANSWER_LIKERT_SCALE |
Answer likert scale associated with the record. |
NUMBER |
|
ANSWER_MULTIPLE_CHOICE |
Answer multiple choice associated with the record. |
VARCHAR2 |
60 |
ANSWER_MULTIPLE_SELECT |
Answer multiple select associated with the record. |
VARCHAR2 |
500 |
ANSWER_NUMERIC |
Answer numeric associated with the record. |
NUMBER |
|
ANSWER_OPEN_ENDED |
Answer open ended associated with the record. |
VARCHAR2 |
4000 |
CLUSTER_LIST |
Cluster list associated with the record. |
VARCHAR2 |
100 |
INSTRUCTOR_MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
INSTRUCTOR_NAME |
Instructor name associated with the record. |
VARCHAR2 |
122 |
LIKERT_SCALE_DESCRIPTION |
Description of likert scale. |
VARCHAR2 |
241 |
MASTER_DEPT |
Master dept associated with the record. |
VARCHAR2 |
4 |
MASTER_SUBJECT_ID |
Business identifier for the master subject. |
VARCHAR2 |
8 |
MEET_LOCATION |
Meet location associated with the record. |
VARCHAR2 |
15 |
MEET_TIME |
Meet time associated with the record. |
VARCHAR2 |
30 |
QUESTION_GROUP_DISPLAY_NAME |
Question group display name associated with the record. |
VARCHAR2 |
50 |
QUESTION_GROUP_ID |
Business identifier for the question group. |
NUMBER |
10 |
QUESTION_GROUP_ORDER |
Question group order associated with the record. |
NUMBER |
3 |
QUESTION_GROUP_PICKLIST_NAME |
Question group picklist name associated with the record. |
VARCHAR2 |
30 |
QUESTION_ID |
Business identifier for the question. |
NUMBER |
10 |
QUESTION_ORDER_WITHIN_GROUP |
Question order within group associated with the record. |
NUMBER |
8 |
QUESTION_TARGET |
Question target associated with the record. |
VARCHAR2 |
15 |
QUESTION_TEXT |
Question text associated with the record. |
VARCHAR2 |
1000 |
QUESTION_TYPE |
Question type associated with the record. |
VARCHAR2 |
10 |
REGISTRATION_STATUS |
Registration status associated with the record. |
VARCHAR2 |
21 |
RESPONSE_ID |
Business identifier for the response. |
NUMBER |
10 |
SECTION_FORMAT |
Section format associated with the record. |
VARCHAR2 |
5 |
SECTION_ID |
Business identifier for the section. |
VARCHAR2 |
15 |
SUBJECT_ID |
Business identifier for the subject. |
VARCHAR2 |
8 |
SUBJECT_TITLE |
Subject title associated with the record. |
VARCHAR2 |
150 |
SURVEY_ID |
Business identifier for the survey. |
NUMBER |
8 |
SURVEY_WINDOW |
Survey window associated with the record. |
VARCHAR2 |
100 |
TEACHING_ROLE |
Teaching role associated with the record. |
VARCHAR2 |
50 |
TERM_CODE |
Code identifying term. |
VARCHAR2 |
6 |
USER_ID |
Business identifier for the user. |
NUMBER |
10 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |