Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse FUND Table


Contains data about sources of revenue (funds & fund centers).


Field Name

Description

Data Type

Length

FUND_CENTER_ID

Six-digit number identifying the fund center (example: 100088 Music, 100152 Division of Toxicology).

VARCHAR2

6

FUND_CENTER_NAME

Name of the Fund Center/source of revenue.

VARCHAR2

40

FUND_ID

Identification number associated with the Fund (Example: 6779500)

VARCHAR2

7

FUND_KEY

Key is used only for joining the FUND table with the FINANCIAL_DETAIL table, NOT for reporting.

VARCHAR2

10

FUND_NAME

* In the FINANCIAL tables: this represents the name of the fund/source of revenue (Example: Publications). * In STUDENT FINANCIAL AID: this is the descriptive title of a financial aid fund/award. Exampes: "Federal Perkins Loan" for PERKNL.

VARCHAR2

40

WAREHOUSE_LOAD_DATE

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

DATE

8