IAP SUBJECT DETAIL Table
View exposing IAP subject detail including title, description, enrollment attributes, fees, prerequisites, deadlines, session relationships, and cancellation indicators.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACTIVITY_DESCRIPTION |
Description of activity. |
VARCHAR2 |
4000 |
ACTIVITY_TITLE |
Activity title associated with the record. |
VARCHAR2 |
150 |
ATTENDANCE |
Attendance associated with the record. |
VARCHAR2 |
80 |
CREATE_DATE |
Date associated with create. |
DATE |
|
ENROLLMENT_TYPE |
Enrollment type associated with the record. |
VARCHAR2 |
80 |
FEE |
Fee associated with the record. |
NUMBER |
7,2 |
FEE_REASON |
Fee reason associated with the record. |
VARCHAR2 |
60 |
IAP_SUBJECT_CATEGORY_KEY |
Surrogate key identifying the iap subject category. |
VARCHAR2 |
32 |
IAP_SUBJECT_PERSON_KEY |
Surrogate key identifying the iap subject person. |
VARCHAR2 |
32 |
IAP_SUBJECT_SESSION_KEY |
Surrogate key identifying the iap subject session. |
VARCHAR2 |
32 |
IAP_SUBJECT_SPONSOR_KEY |
Surrogate key identifying the iap subject sponsor. |
VARCHAR2 |
32 |
IS_CANCELLED |
Indicator identifying whether cancelled (Y/N). |
VARCHAR2 |
1 |
IS_MULTIPLE_SESSION |
Indicator identifying whether multiple session (Y/N). |
VARCHAR2 |
1 |
LAST_ACTIVITY_DATE |
Date associated with last activity. |
DATE |
|
MAX_ENROLLMENT |
Max enrollment associated with the record. |
NUMBER |
5 |
PREREG_DEADLINE |
Prereg deadline associated with the record. |
DATE |
|
PREREQUISITES |
Prerequisites associated with the record. |
VARCHAR2 |
60 |
TERM_CODE |
Code identifying term. |
VARCHAR2 |
6 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |