IAP ACTIVITY SESSION Table
IAP Non-Credit Activity session data. One record per session per activity. This table contains only the session data for the current IAP term. The data are refreshed daily from November 1 to the end of IAP.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
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_SESSION_DATE |
Meet date of the specific session of an IAP non-credit activity. The dates are entered as text in this format: "Jan 05", "Jan 18", "Jan 27". |
VARCHAR2 |
15 |
IAP_ACTIVITY_SESSION_DESC |
Description of the specific session of an IAP non-credit activity. |
VARCHAR2 |
900 |
IAP_ACTIVITY_SESSION_LOCATION |
Meet location of the specific session of an IAP non-credit activity. |
VARCHAR2 |
20 |
IAP_ACTIVITY_SESSION_TIME |
Meet time of the specific session of an IAP non-credit activity. |
VARCHAR2 |
15 |
IAP_ACTIVITY_SESSION_TITLE |
Title of the specific session of an IAP non-credit activity. |
VARCHAR2 |
150 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |