Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse BB RESEARCH VOLUME SELECTOR Table


XXX


Field Name

Description

Data Type

Length

DEPARTMENT_NAME

The name of the department, school, center, or lab.

VARCHAR2

40

FISCAL_YEAR

The 4 digit year. The fiscal year at MIT runs from July 1st through June 30th. (e.g.: June 30, 1997 would be fiscal year 1997, July 1, 1997 would be fiscal year 1998)

VARCHAR2

4

SCHOOL_NAME

The descriptive text for SCHOOL_CODE.

VARCHAR2

40

WAREHOUSE_LOAD_DATE

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

DATE