Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse WEB COURSE SURVEY RESPONSES Table


View exposing web course survey responses data.


Field Name

Description

Data Type

Length

COMPLETION_DATE

Date associated with completion.

DATE

DONT_SHOW_SURVEY

Dont show survey associated with the record.

VARCHAR2

1

IS_CURRENT

Indicator identifying whether current (Y/N).

VARCHAR2

1

LSO_COURSE_KEY

Surrogate key identifying the lso course.

VARCHAR2

9

MIT_ID

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

VARCHAR2

9

NOT_RATED

Not rated associated with the record.

VARCHAR2

1

QUESTION_1

Question 1 associated with the record.

VARCHAR2

2

QUESTION_1_RESP

Question 1 resp associated with the record.

VARCHAR2

26

QUESTION_2

Question 2 associated with the record.

VARCHAR2

2

QUESTION_2_RESP

Question 2 resp associated with the record.

VARCHAR2

26

QUESTION_3

Question 3 associated with the record.

VARCHAR2

2

QUESTION_3_RESP

Question 3 resp associated with the record.

VARCHAR2

26

QUESTION_4

Question 4 associated with the record.

VARCHAR2

2

QUESTION_4_RESP

Question 4 resp associated with the record.

VARCHAR2

26

QUESTION_5

Question 5 associated with the record.

VARCHAR2

2

QUESTION_5_RESP

Question 5 resp associated with the record.

VARCHAR2

26

QUESTION_6

Question 6 associated with the record.

VARCHAR2

2

QUESTION_6_RESP

Question 6 resp associated with the record.

VARCHAR2

26

QUESTION_7

Question 7 associated with the record.

VARCHAR2

2

QUESTION_7_RESP

Question 7 resp associated with the record.

VARCHAR2

26

QUESTION_8

Question 8 associated with the record.

VARCHAR2

15

QUESTION_8_TEXT

Question 8 text associated with the record.

VARCHAR2

600

QUESTION_9

Question 9 associated with the record.

VARCHAR2

15

QUESTION_9_TEXT

Question 9 text associated with the record.

VARCHAR2

600

RATING_BY

Rating by associated with the record.

VARCHAR2

12

RATING_DATE

Date associated with rating.

DATE

RECORD_COUNTER

Record counter associated with the record.

NUMBER

SAP_COURSE_NUMBER

Sap course number associated with the record.

VARCHAR2

9

STAR_RATING

Star rating associated with the record.

NUMBER

3,2

TPARTDOCNO

Tpartdocno associated with the record.

VARCHAR2

10

TRAINING_ID

Business identifier for the training.

VARCHAR2

8

TRAINING_TYPE

Training type associated with the record.

VARCHAR2

2

TRAINING_TYPE_ID

Business identifier for the training type.

VARCHAR2

8

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE