Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse FUND CENTER HIERARCHY Table


View exposing fund center hierarchy data used to organize and report funding structures within MIT financial systems.


Field Name

Description

Data Type

Length

FUND_CENTER_ID

Business identifier for the fund center.

VARCHAR2

34

FUND_CENTER_ID_LEVEL1

Fund center id level1 associated with the record.

VARCHAR2

34

FUND_CENTER_ID_LEVEL10

Fund center id level10 associated with the record.

VARCHAR2

34

FUND_CENTER_ID_LEVEL2

Fund center id level2 associated with the record.

VARCHAR2

34

FUND_CENTER_ID_LEVEL3

Fund center id level3 associated with the record.

VARCHAR2

34

FUND_CENTER_ID_LEVEL4

Fund center id level4 associated with the record.

VARCHAR2

34

FUND_CENTER_ID_LEVEL5

Fund center id level5 associated with the record.

VARCHAR2

34

FUND_CENTER_ID_LEVEL6

Fund center id level6 associated with the record.

VARCHAR2

34

FUND_CENTER_ID_LEVEL7

Fund center id level7 associated with the record.

VARCHAR2

34

FUND_CENTER_ID_LEVEL8

Fund center id level8 associated with the record.

VARCHAR2

34

FUND_CENTER_ID_LEVEL9

Fund center id level9 associated with the record.

VARCHAR2

34

FUND_CENTER_KEY

Surrogate key identifying the fund center.

VARCHAR2

34

FUND_CENTER_NAME

Fund center name associated with the record.

VARCHAR2

45

FUND_CENTER_NAME_LEVEL1

Fund center name level1 associated with the record.

VARCHAR2

45

FUND_CENTER_NAME_LEVEL10

Fund center name level10 associated with the record.

VARCHAR2

45

FUND_CENTER_NAME_LEVEL2

Fund center name level2 associated with the record.

VARCHAR2

45

FUND_CENTER_NAME_LEVEL3

Fund center name level3 associated with the record.

VARCHAR2

45

FUND_CENTER_NAME_LEVEL4

Fund center name level4 associated with the record.

VARCHAR2

45

FUND_CENTER_NAME_LEVEL5

Fund center name level5 associated with the record.

VARCHAR2

45

FUND_CENTER_NAME_LEVEL6

Fund center name level6 associated with the record.

VARCHAR2

45

FUND_CENTER_NAME_LEVEL7

Fund center name level7 associated with the record.

VARCHAR2

45

FUND_CENTER_NAME_LEVEL8

Fund center name level8 associated with the record.

VARCHAR2

45

FUND_CENTER_NAME_LEVEL9

Fund center name level9 associated with the record.

VARCHAR2

45

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE