Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse 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