Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse OSE RESPONSE RATE DETAIL Table


View exposing survey response-rate detail by report type, survey window, student registration status, and subject.


Field Name

Description

Data Type

Length

OSE_REPORT_TYPE_KEY

Surrogate key identifying the ose report type.

VARCHAR2

20

OSE_STUDENT_REG_STATUS_KEY

Surrogate key identifying the ose student reg status.

VARCHAR2

8

OSE_SUBJECT_KEY

Surrogate key identifying the ose subject.

VARCHAR2

25

OSE_SURVEY_WINDOW_KEY

Surrogate key identifying the ose survey window.

NUMBER

8

RESPONDED_TO_SURVEY

Responded to survey associated with the record.

NUMBER

19

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE