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 |