Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse IAP SUBJECT SPONSOR Table


Sponsor for an IAP non-credit activity.


Field Name

Description

Data Type

Length

IAP_SUBJECT_SPONSOR_KEY

Use this field to join together the IAP_SUBJECT_DETAIL and IAP_SUBJECT_SPONSOR tables.

VARCHAR2

32

SPONSOR_NAME

In the PROJECT and SPONSOR tables, identifies the sponsor, associated with a particular sponsor code, providing funding for a sponsored research project. In the personnel APPOINTMENT tables, identifies the sponsor providing financial support for a Fellow; this field is not currently populated by Human Resources.

VARCHAR2

60

SPONSOR_TYPE

The type of sponsor (Example: Federal, Private - Pofit, Private - Non-Profit, State, etc..)

VARCHAR2

100

WAREHOUSE_LOAD_DATE

The date the record was loaded into the Data Warehouse from the source system.

DATE

8