Data Warehouse

COMPLETION_DATE

The end date.

DATE

DONT_SHOW_SURVEY

XXX

VARCHAR2

1

IS_CURRENT

Indicates that the person is a current student or employee: Y or N.

VARCHAR2

1

LSO_COURSE_KEY

XXX

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

XXX

VARCHAR2

1

QUESTION_1

XXX

VARCHAR2

2

QUESTION_1_RESP

XXX

VARCHAR2

26

QUESTION_2

XXX

VARCHAR2

2

QUESTION_2_RESP

XXX

VARCHAR2

26

QUESTION_3

XXX

VARCHAR2

2

QUESTION_3_RESP

XXX

VARCHAR2

26

QUESTION_4

XXX

VARCHAR2

2

QUESTION_4_RESP

XXX

VARCHAR2

26

QUESTION_5

XXX

VARCHAR2

2

QUESTION_5_RESP

XXX

VARCHAR2

26

QUESTION_6

XXX

VARCHAR2

2

QUESTION_6_RESP

XXX

VARCHAR2

26

QUESTION_7

XXX

VARCHAR2

2

QUESTION_7_RESP

XXX

VARCHAR2

26

QUESTION_8

XXX

VARCHAR2

15

QUESTION_8_TEXT

XXX

VARCHAR2

600

QUESTION_9

XXX

VARCHAR2

15

QUESTION_9_TEXT

XXX

VARCHAR2

600

RATING_BY

XXX

VARCHAR2

12

RATING_DATE

XXX

DATE

RECORD_COUNTER

Used to count records within a group on a report. Always contains a value of 1.

NUMBER

SAP_COURSE_NUMBER

XXX

VARCHAR2

9

STAR_RATING

XXX

NUMBER

3,2

TPARTDOCNO

XXX

VARCHAR2

10

TRAINING_ID

XXX

VARCHAR2

8

TRAINING_TYPE

XXX

VARCHAR2

2

TRAINING_TYPE_ID

XXX

VARCHAR2

8

WAREHOUSE_LOAD_DATE

The date the record was loaded into the Data Warehouse from the source system.

DATE