BB RESEARCH VOLUME SUMMARY Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADMIN_FLAG |
A two character code identifying how a cost collector is administered: AL for allocation cost objects; DP for DLC administered; FC for Faculty administered; RA for RA support; RT for Research Telephone; NS for NSF Shortfall; SP for service provider (facilities); CG for Core Grant (administrative component); CR for Custodial (central) responsibility. |
VARCHAR2 |
2 |
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 |
GL_CATEGORY |
XXX |
VARCHAR2 |
50 |
PRIMARY_CUMULATIVE_AMOUNT |
XXX |
NUMBER |
18,2 |
PRIMARY_FISCAL_YEAR_BUDGET |
XXX |
NUMBER |
18,2 |
PRIMARY_FYTD_AMOUNT |
XXX |
NUMBER |
18,2 |
SCHOOL_NAME |
The descriptive text for SCHOOL_CODE. |
VARCHAR2 |
40 |
SECONDARY_CUMULATIVE_AMOUNT |
XXX |
NUMBER |
18,2 |
SECONDARY_FISCAL_YEAR_BUDGET |
XXX |
NUMBER |
18,2 |
SECONDARY_FYTD_AMOUNT |
XXX |
NUMBER |
18,2 |
SUPERVISOR_MIT_ID |
The 9 digit MIT identification number of the person responsible for this project, cost center, internal order, or cost center. |
VARCHAR2 |
9 |
SUPERVISOR_NAME |
XXX |
VARCHAR2 |
50 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |