|
|
|
NSF FEDSUP SURVEY DETAIL
This is the fact table for NSF Survey of Federal Support to Universities, Colleges, and Nonprofit Institutions. The data cover obligations for research and development to universities and colleges and to FFRDCs administered by universities. The survey data includes data for years from 1974 for institutions that were active for those years.
| Field Name | Description | Data Type | Length |
|---|---|---|---|
| FISCAL_YEAR_KEY | Use this field to join to another table with the same-name field (ie. FISCAL_YEAR_KEY) for fiscal year information. It shouldn't be used for reporting. | VARCHAR2 | 4 |
| INSTITUTION_KEY | Use this field to join to another table with the same-name field (ie. INSTITUTION_KEY). | VARCHAR2 | 6 |
| NSF_FEDSUP_AGENCY_GRP_KEY | Use this field to join together the NSF_FEDSUP_SURVEY_DETAIL and the NSF_FEDSUP_AGENCY_GRP tables. | VARCHAR2 | 5 |
| NSF_INSTITUTION_KEY | Use this field to join the NSF INSTITUTION table with other NSF fact tables or institution tables. | VARCHAR2 | 60 |
| TOTAL_OBLIGATIONS | Total obligations of the federal agency for research and development to the institution. | NUMBER | 8 |
| WAREHOUSE_LOAD_DATE | The date the records were last loaded/updated in this table in the Data Warehouse | DATE | 7 |
e-mail aaude-warehouse@mit.edu | Warehouse home | AAUDE home