IAP SUBJECT DETAIL Table
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.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACTIVITY_DESCRIPTION |
XXX |
VARCHAR2 |
4000 |
ACTIVITY_TITLE |
XXX |
VARCHAR2 |
150 |
ATTENDANCE |
XXX |
VARCHAR2 |
80 |
CREATE_DATE |
Date when UROP applicatioan initiated. |
DATE |
8 |
ENROLLMENT_TYPE |
XXX |
VARCHAR2 |
80 |
FEE |
XXX |
NUMBER |
22 |
FEE_REASON |
XXX |
VARCHAR2 |
60 |
IAP_SUBJECT_CATEGORY_KEY |
Use this field to join together the IAP_SUBJECT_DETAIL and IAP_SUBJECT_SPONSOR tables |
VARCHAR2 |
32 |
IAP_SUBJECT_PERSON_KEY |
Use this field to join together the IAP_SUBJECT_DETAIL and IAP_SUBJECT_PERSON tables |
VARCHAR2 |
32 |
IAP_SUBJECT_SESSION_KEY |
Use this field to join together the IAP_SUBJECT_DETAIL and IAP_SUBJECT_SESSION tables. |
VARCHAR2 |
32 |
IAP_SUBJECT_SPONSOR_KEY |
Use this field to join together the IAP_SUBJECT_DETAIL and IAP_SUBJECT_SPONSOR tables. |
VARCHAR2 |
32 |
IS_CANCELLED |
XXX |
VARCHAR2 |
1 |
IS_MULTIPLE_SESSION |
XXX |
VARCHAR2 |
1 |
LAST_ACTIVITY_DATE |
Date when information in the record was last updated. |
DATE |
8 |
MAX_ENROLLMENT |
XXX |
NUMBER |
22 |
PREREG_DEADLINE |
XXX |
DATE |
7 |
PREREQUISITES |
Prerequisites of the subject. Co-requisites are in []. Co-requisites are subjects that a student must take at the same time as the subject. |
VARCHAR2 |
100 |
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 |