IAP ACTIVITY Table
IAP Non-Credit Activities. One record per IAP term per activity. Multi-session activities are marked with "MULTI-SESSION" in the iap_activity_date field. The current IAP term records in this table are refreshed daily from November 1 to the end of IAP.
Field Name |
Description |
Data Type |
Length |
---|---|---|---|
ESTIMATE_ENROLLMENT |
Estimate enrollment in an IAP non-credit activity |
NUMBER |
5 |
IAP_ACTIVITY_ATTENDANCE |
Information regarding the attendance of the IAP non-credit activity |
VARCHAR2 |
80 |
IAP_ACTIVITY_CATEGORY |
Category of the IAP non-credit activity |
VARCHAR2 |
60 |
IAP_ACTIVITY_CONTACT_AFFIL |
The contact person's affiliation to MIT |
VARCHAR2 |
70 |
IAP_ACTIVITY_CONTACT_EMAIL |
Email address of the contact person for the IAP non-credit activity |
VARCHAR2 |
60 |
IAP_ACTIVITY_CONTACT_NAME |
Contact person for the IAP non-credit activity. |
VARCHAR2 |
80 |
IAP_ACTIVITY_DATE |
Start date of the IAP non-credit activity. This is a text ield with date in this format: Jan 05, Jan 25. This field contains "MULTI_SESSIONS" for all activities with multiple sessions. |
VARCHAR2 |
15 |
IAP_ACTIVITY_DESCRIPTION |
Full description of the IAP non-credit activity |
VARCHAR2 |
2000 |
IAP_ACTIVITY_ENROLLMENT |
Enrollment information about the IAP non-credit activity |
VARCHAR2 |
80 |
IAP_ACTIVITY_FEE |
Fee required to participate in the IAP non-credit activity |
NUMBER |
7.2 |
IAP_ACTIVITY_FEE_REASON |
Reason(s) for the IAP activity fee |
VARCHAR2 |
60 |
IAP_ACTIVITY_ID |
Identification number of the IAP non-credit activity as used in MITSIS. |
VARCHAR2 |
8 |
IAP_ACTIVITY_KEY |
Use this field to join together tables IAP_ACTIVITY and IAP_ACTIVITY_SESSION for the IAP non-credit activity and session data. |
VARCHAR2 |
8 |
IAP_ACTIVITY_LEADER_AFFIL |
The IAP activity leader's affiliation to MIT |
VARCHAR2 |
70 |
IAP_ACTIVITY_LEADER_EMAIL |
Email address of the leader of the IAP activity |
VARCHAR2 |
60 |
IAP_ACTIVITY_LEADER_NAME |
The leader of the IAP non-credit activity |
VARCHAR2 |
80 |
IAP_ACTIVITY_OTHER_LEADERS |
Other leaders (names and their MIT affiliations) of the IAP non-credit activity |
VARCHAR2 |
400 |
IAP_ACTIVITY_PREREQUISITES |
Prerequisites for the IAP non-credit activity |
VARCHAR2 |
60 |
IAP_ACTIVITY_SCHEDULE |
The schedule (including meeting dates, times, and locations of all applicable sessions) of the IAP non-credit activity. |
VARCHAR2 |
1000 |
IAP_ACTIVITY_SECTION_SPONSOR |
Section sponsor(s) of the IAP non-credit activity |
VARCHAR2 |
50 |
IAP_ACTIVITY_SPONSOR |
Sponsor(s) of the IAP non-credit activity |
VARCHAR2 |
50 |
IAP_ACTIVITY_TIME |
Start time of the IAP non-credit activity |
VARCHAR2 |
15 |
IAP_ACTIVITY_TITLE |
Title of the IAP non-credit activity |
VARCHAR2 |
150 |
IAP_ACTIVITY_URL |
Web URL for the IAP activity |
VARCHAR2 |
160 |
MAXIMUM_ENROLLMENT |
Maximum enrollment in an IAP non-credit activity |
NUMBER |
5 |
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 |