Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse SUBJECT IAP SCHEDULE Table


Schedule (meet time and meet place) data for IAP for-credit subjects (courses). There is one record per subject per session (time period) as it is offered during IAP.


Field Name

Description

Data Type

Length

IAP_DATE

Date during IAP when the session of the subject/class meets

DATE

8

IAP_DAY

The day (ie. Day 1, Day 2, ? Day 16) during IAP when the session of the subject/class meets.

NUMBER

3

MEET_END_TIME

End time of the session.

VARCHAR2

6

MEET_PLACE

Place (classroom) where the section/class of this subject meets

VARCHAR2

15

MEET_START_TIME

Start time of the session.

VARCHAR2

6

REMARKS

Additional note of remarks about the session of this subject.

VARCHAR2

30

SESSION_NUMBER

Session number of the IAP subject.

NUMBER

3

SUBJECT_ID

The subject ID (eg.18.01, 15.012, 21W.731)

VARCHAR2

8

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

WAREHOUSE_LOAD_DATE

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

DATE

8