Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse SPONSOR Table


Contains data about each sponsor.


Field Name

Description

Data Type

Length

ADMINISTERING_ACTIVITY

Associated with Federal Sponsors. Identifies what branch.

VARCHAR2

30

AUDIT_REPORT_SENT_FOR_FY

Identifies whether or not an audit report has been sent to the sponsor for the fiscal year.

VARCHAR2

4

COUNTRY_CODE

The 3 digit code which identifies a country (Example: USA United States of America).

VARCHAR2

3

COUNTRY_NAME

The long name of the country (Example United States, France)

VARCHAR2

40

DUN_AND_BRADSTREET_NUMBER

Dun and Bradstreet Number.

VARCHAR2

9

POSTAL_CODE

Postal Code (part of an address)

VARCHAR2

15

SPONSOR_CODE

Sponsor code. OSP accounts are coded. Fund accounts are coded if there are restrictions in the award that make accounting system controls desirable. Contracts or grants from federal government and other restrictive sponsors are coded.

VARCHAR2

6

SPONSOR_KEY

Key identifying an entry in the Sponsor master table. This field should only be used for linking tables together, not for reporting.

VARCHAR2

10

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

SPONSOR_TYPE_CODE

Numerical code identifing the type of sponsor (Example: 0 - Federal, 3 - Private-Pofit, 4 - Private-Non-Profit, 1 - State, etc?.)

VARCHAR2

2

STATE

State.

VARCHAR2

30

WAREHOUSE_LOAD_DATE

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

DATE

8