AAUDE banner Data Warehouse logo

NSF R&D Current Fund Expenditures

This represents two parts (ITEM 2 and ITEM 2A) of three parts of the NSF Survey of R&D Expenditures at Universities and Colleges. ITEM 2: Current fund expenditures (federally and non-federally financed) for separately budgeted research and development, by field of science and engineering. ITEM 2A: Current fund expenditures for separately budgeted research and development by Non-Science and Engineering field. The total amounts are dollars in thousands.

This page lists all the tables for the NSF R&D Current Fund Expenditures Star/Table Group.
Clicking on a table name will display the fields found in that table.


Table Name Description Type Last Load Date
NSF_INSTITUTION This is a dimension table which include the names and FICE code of all institutions (AAUDE and Non AAUDE) with data in the various NSF tables Dimension 26-MAR-2008
FISCAL_YEAR Contains information about fiscal year, primarily used for the NSF Graduate Students Support exchange item. Dimension 30-JAN-2002
NSF_RDEXP_FINANCE_TYPE This is a dimension table for the stars of NSF R&D Current Fund Expenditures by field of science and engineering, and also NSF R&D Equipment Expenditures. Types of finance: federally financed, non-federally financed. Dimension 19-MAR-2002
NSF_RDEXP_CURR_FUND_DETAIL NSF Survey of R&D Expenditures - Current Fund Expenditures -- This fact table contains data from the NSF Survey of R+D Current Fund Expenditures (federally or non-federally financed) by fields of science and engineering (Item 2) as well as the non-science and engineering fields (Item 2A). Beginning in 2003, Item 2a (Non-Science and Engineering) part of the survey was no longer an optional survey item. Fact 16-NOV-2009
NSF_RDEXP_FIELD This is a dimension table for the stars of NSF R&D Current Fund Expenditures and NSF R&D Equipment Expenditures. It contains all the fields of science and engineering as well as non-science and engineering as defined in the survey. Examples are: chemical engineering, civil engineering, chemistry, physics, mathematical sciences, computer science, social sciences and life sciences. For non-science and engineering fields, examples are: education, law, humanities, visual & performing arts, business & management, social work, and communications, journalism, & library science. The field "NSF_MAJOR_CATEGORY" may be used to distinguish the "Science and Engineering" fields from the "Non-Science and Engineering fields. Dimension 14-OCT-2005
INSTITUTION This table contains information about an institution which includes: name, AAUDE institution code, AAUDE Unit ID, Public/Private/System, FICE code, city, and state, and the academic year conversion factor of the institution. Dimension 14-JUL-2009

e-mail aaude-warehouse@mit.edu | Warehouse home | AAUDE home