IAP SUBJECT PERSON Table
View exposing IAP subject person detail including role, affiliation, contact information, organization, title, and location.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
IAP_SUBJECT_PERSON_KEY |
Surrogate key identifying the iap subject person. |
VARCHAR2 |
32 |
PERSON_EMAIL |
Person email associated with the record. |
VARCHAR2 |
60 |
PERSON_LOCATION |
Person location associated with the record. |
VARCHAR2 |
30 |
PERSON_MIT_AFFILIATION |
Person mit affiliation associated with the record. |
VARCHAR2 |
30 |
PERSON_NAME |
Person name associated with the person. |
VARCHAR2 |
60 |
PERSON_ORGANIZATION |
Person organization associated with the record. |
VARCHAR2 |
60 |
PERSON_ROLE |
Person role associated with the record. |
VARCHAR2 |
60 |
PERSON_TITLE |
Person title associated with the record. |
VARCHAR2 |
60 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |