Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse IAP Non-Credit Activities


Tables are listed by alphabetical order. Clicking on a table name will display the fields/columns found in that table.


Table Name

Description

Type

Primary Provider

Sensitivity

Load Frequency

Last Load Date

IAP_SUBJECT_PERSON

This table contains information about the persons (Activity Leader, Contact Person, Session Leader, etc.) associated with the IAP non-credit subjects/activities.

Dimension

MIT Student Information System

MIT ONLY

As Needed

08-JAN-2020

IAP_SUBJECT_CATEGORY

Categories for IAP Non-Credit Activities

Dimension

MIT Student Information System

MIT ONLY

As Needed

08-JAN-2020

IAP_SUBJECT_SESSION

Individual session asscoiated with an IAP non-credit activity.

Dimension

MIT Student Information System

MIT ONLY

As Needed

02-FEB-2015

IAP_SUBJECT_DETAIL

IAP non-credit activities for the current/upcoming IAP period. Data items include the activity title, description, enrollment & attendance, prerequisites, fee, and pre registration deadline. There is one record per activity as it is offered during IAP.

Fact

MIT Student Information System

MIT ONLY

As Needed

08-JAN-2020

IAP_SUBJECT_SPONSOR

Sponsor for an IAP non-credit activity.

Dimension

MIT Student Information System

MIT ONLY

As Needed

08-JAN-2020