OSE RESPONSE RAW Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ANSWER_LIKERT_SCALE |
XXX |
NUMBER |
|
ANSWER_MULTIPLE_CHOICE |
XXX |
VARCHAR2 |
60 |
ANSWER_MULTIPLE_SELECT |
XXX |
VARCHAR2 |
500 |
ANSWER_NUMERIC |
XXX |
NUMBER |
|
ANSWER_OPEN_ENDED |
XXX |
VARCHAR2 |
4000 |
CLUSTER_LIST |
A list that contains all the subjects in a cluster group. Cluster groups include subjects that are joint or meet together. For example, 7.02 and 10.702 are subjects in a cluster. So are: 7.10, 20.111; 6.265, 15.070; 2.111, 8.411, 18.435; etc. |
VARCHAR2 |
100 |
INSTRUCTOR_MIT_ID |
For records related to courses that have been completed by the trainee, this field contains the course instructor's MIT ID number, where available. |
VARCHAR2 |
9 |
INSTRUCTOR_NAME |
For records related to courses that have been completed by the trainee, this field contains the course instructor's name, where available. |
VARCHAR2 |
122 |
LIKERT_SCALE_DESCRIPTION |
XXX |
VARCHAR2 |
241 |
MASTER_DEPT |
XXX |
VARCHAR2 |
4 |
MASTER_SUBJECT_ID |
The subject ID of a cluster subject group that indicates the administrative home of the subject. Cluster groups include joint, meets-with, and School-Wide Elective subjects. For example, 15.070 and 6.265 "Adv Stochastic Processes" are two joint subjects, Master Subject ID of these two subjects is 15.070 as Course 15 (Sloan School of Management) is the home department of this subject. |
VARCHAR2 |
8 |
MEET_LOCATION |
XXX |
VARCHAR2 |
15 |
MEET_TIME |
Scheduled times when the section/class of this subject meets |
VARCHAR2 |
30 |
QUESTION_GROUP_DISPLAY_NAME |
XXX |
VARCHAR2 |
50 |
QUESTION_GROUP_ID |
XXX |
NUMBER |
10 |
QUESTION_GROUP_ORDER |
XXX |
NUMBER |
3 |
QUESTION_GROUP_PICKLIST_NAME |
XXX |
VARCHAR2 |
30 |
QUESTION_ID |
XXX |
NUMBER |
10 |
QUESTION_ORDER_WITHIN_GROUP |
XXX |
NUMBER |
8 |
QUESTION_TARGET |
XXX |
VARCHAR2 |
15 |
QUESTION_TEXT |
XXX |
VARCHAR2 |
1000 |
QUESTION_TYPE |
XXX |
VARCHAR2 |
10 |
REGISTRATION_STATUS |
Status of registration |
VARCHAR2 |
21 |
RESPONSE_ID |
XXX |
NUMBER |
10 |
SECTION_FORMAT |
Format of a subject section. Eg. Lecture, Lab, Design, Discussion, Recitation, Tutorial, Large Ensemble, etc. |
VARCHAR2 |
5 |
SECTION_ID |
The section code or number of the subject. Eg. L01, L02, R01, B01. |
VARCHAR2 |
15 |
SUBJECT_ID |
The subject ID (eg.18.01, 15.012, 21W.731) |
VARCHAR2 |
8 |
SUBJECT_TITLE |
The title of the subject |
VARCHAR2 |
150 |
SURVEY_ID |
XXX |
NUMBER |
8 |
SURVEY_WINDOW |
XXX |
VARCHAR2 |
100 |
TEACHING_ROLE |
Teaching roles, eg. Lecturer, Recitation Lecturer, Lab Instructor, Teaching Assistant, Writing Instructor, etc. |
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 |
USER_ID |
In the Commitment History and Current Commitments tables, the kerberos ID of the person who entered the commitment. |
NUMBER |
10 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |