IAP SUBJECT PERSON Table
This table contains information about the persons (Activity Leader, Contact Person, Session Leader, etc.) associated with the IAP non-credit subjects/activities.
Field Name |
Description |
Data Type |
Length |
---|---|---|---|
IAP_SUBJECT_PERSON_KEY |
Use this field to join together the IAP_SUBJECT_DETAIL and IAP_SUBJECT_PERSON tables |
VARCHAR2 |
32 |
PERSON_EMAIL |
XXX |
VARCHAR2 |
60 |
PERSON_LOCATION |
XXX |
VARCHAR2 |
30 |
PERSON_MIT_AFFILIATION |
XXX |
VARCHAR2 |
30 |
PERSON_NAME |
XXX |
VARCHAR2 |
90 |
PERSON_ORGANIZATION |
XXX |
VARCHAR2 |
60 |
PERSON_ROLE |
XXX |
VARCHAR2 |
60 |
PERSON_TITLE |
XXX |
VARCHAR2 |
60 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |