AAUDE Data Warehouse
What's New

• NSF Federal Support Survey data for fiscal years 2004 and 2005 have been loaded to the Data Warehouse.
  (July 30, 2007)

• 2006 data for NSF Graduate Student Support have been loaded to the Data Warehouse.
  (July 30, 2007)

• NSF Graduate Student Support data for Non AAUDE Institutions (for fiscal years 1972 through 2005) have been loaded into the Data Warehouse.
  (July 30, 2007)

• The Retention and Graduation Survey tables have been refreshed with data for collection year 2007 (Fall 2006).
  (July 20, 2007)

• The 2006-2007 CUPA Administrative Compensation Survey data has been loaded.
  (June 25, 2007)

• The 2006 NSF R&D Expenditures data sets for AAUDE institutions have been loaded to the Data Warehouse.
  (June 17, 2007)

• IPEDS Completion Survey data for academic year 2005-06 has been loaded into the Data Warehouse.
  (June 3, 2007)

• AAUDE Peer Lists have been updated in the Data Warehouse. The table, AAUDE PEER INSTITUTION, now contains 1733 records.
  (June 1, 2007)

• The first batch of 2006-2007 AAUP Faculty Salary Survey data, with submissions from 49 institutions, have been loaded to the Data Warehouse.
  (April 9, 2007)

• 2004-2005 University of Delaware Survey data for Expenditures and Teaching Load are now in the Data Warehouse.
  (March 30, 2007)

• We have backfilled IPEDS Fall Enrollment data from academic year 1991-1992.
  (March 21, 2007)

• The Fall 2005 Retention and Graduation Survey data have been loaded . To avoid confusions and duplication of data retrieval, we only store data for the current collection year in the Data Warehouse tables.
  (March 20, 2007)

• Freshmen Profile data for Fall 2006 is now in the Da ta Warehouse.
  (March 19, 2007)

• The first batch (with data from 15 institutions) of 2006-2007 Faculty Profile by CIP data have been loaded.
  Also loaded are the Footnotes for this exchange item.
  (March 18, 2007)

• The first batch of AAUDE Faculty Salary by CIP data for academic year 2006-07 has been loaded into the Data Warehouse. Four new fields have been added to the fact table: median_salary, twenty_fifth_percentile, seventy_five_percentile, and standard_deviation.
  (February 24, 2007)

• IPEDS Completion Survey data for academic year 2004-05 has been loaded into the Data Warehouse.
  (January 3, 2007)

• The Tuition Fee Detail table in the Tuition and Required Fees data model has been revised to include required fee data! More fields have been added to the table which include: Tuition Only Amount, Tuition Only and Required Fee, Total Required Fee, plus 9 required fee fields (Activity Fee, Health Service Fee, Recreation Fee, Athletic Fee, General Student Service Fee, etc.) The table inlcudes data from academic year 1994-95 through 2005-06. The sample query has been updated according to the new structure of the fact table.
  (January 2, 2007)

• 2005-06 data for Graduate Assistant Stipends have been loaded into the Data Warehouse.
  Tables that contain benefits, cash salary, tuition and fees, as well as the institution table have all been loaded with 2006 data.
  Two new fields, Are RAs Unionized and Are TAs Unionized, have been added to table GRADSTIP INSTITUTION. And the five new fields that are now included in the GRADSTIP CASH SALARY DETAIL table are: First Year FTE, First Year Head Count, First Year Max Cash Salary, First Year Min Cash Salary, and First Year Avg Cash Salary.
  (October 31, 2006)

• Fall 2005 data for IPEDS Employee by Assigned Position have been loaded into the Data Warehouse. Fall 2003 and Fall 2004 data have been refreshed with corrections.
  (October 28, 2006)

• Three fields in the NSF RDEXP FIELD table have been renamed to be clearer and more consistent with the NSF DICIPLINE table and other NSF tables:
  * FIELD_ITEM has been renamed to NSF_MAJOR_CATEGORY
  * NSF_FILED_NAME has been renamed to NSF_FIELD_CATEGORY
  * FIELD_CATEGORY has been renamed to NSF_FIELD_NAME
  If you have saved queries that use this table, the queries will no longer work. You need to refresh/rebuild the queries with this new modified table. Sample queries on the web which use the NSF RDEXP FIELD table have been updated accordingly: NSF R&D Current Fund Expenditures, NSF R&D Equipment Expenditures, NSF R&D Federal Financed Current Fund Expenditures.
  (October 26, 2006)

• 2005 data for NSF Graduate Student Support has been loaded to the Data Warehouse. Sample Queries are also available on the website.
  (September 26, 2006)

• NSF Graduate Student Support data for Non AAUDE Institutions (for fiscal years 1972 through 2003) have been loaded into the Data Warehouse.
  Please note that the NSF_INSTITUTON table must be used in place of INSTITUTION in the query in order to retrieve the non AAUDE institutions.
  Sample Queries are available on the web site.
  (September 1, 2006)

• The 2005-2006 Faculty Profile by CIP data have been loaded.
  Also loaded are the Footnotes for this exchange item.
  (August 1, 2006)

• We have re-loaded the 2004 data for NSF Graduate Student Support. The data structure of the NSF Graduate Student Support data for enrollment, POSTDOC by degree, and POSTDOC by gender, has been altered to include NSF Disciplines. The Sample Queries for each of the categories have been updated accordingly.
  (July 31, 2006)

• 2005 data for NSF R&D Expenditures has been loaded to the Data Warehouse.
  (July 26, 2006)

• The 2005-2006 AAUP Faculty Salary Survey data has been loaded. The AAUP FACULTY SALARY DETAIL table now contains the acad_year_conversion_factor field with the value that is used to convert a 11-12 month faculty salary to a 9-10 month salary. The Sample Brio Query has been updated to include this new field in the report.
  (May 16, 2006)

• The 2005-2006 CUPA Administrative Compensation Survey data has been loaded.
  (May 12, 2006)

• NSF R&D Expenditure data (Item 1: Funds by Source, Item 2: Current Funds, Item 3: Equipment) for Non AAUDE Institutions for years 1980 through 2003 have been loaded to the Data Warehouse. Sample queries are also included on the web site.
  (May 11, 2006)

• IPEDS Fall Staff Survey data for academic year 2005-2006 are now available: IPEDS FAll Staff Survey by Employee Type and IPEDS Fall Staff Survey with Salary Range.
  (March 10, 2006)

• Freshmen Profile data for Fall 2005 is now in the Data Warehouse.
  (March 4, 2006)

• Faculty Salary by CIP data for 2005-2006 is now in the Data Warehouse.
  (January 23, 2006)

• NSF Federal Support Survey data which covers obligations for research and development to universities and colleges and to FFRDCs (Federally Funded Research and Development Center) administered by universities has been loaded to the Data Warehouse. Data Model and Sample Queries in SQL and Brio are also available on the web site.
  (December 2, 2005)

• AAUDE Peer Lists have been updated in the Data Warehouse. We have altered the structure of the table and changed the name of some of the fields to make them clearer and the table easier to use. The table, AAUDE PEER INSTITUTION, now contains 1395 records.
  (November 15, 2005)

• The 2004 data for NSF Graduate Student Support has been loaded to the Data Warehouse. The data models have been restructured into these catagories: Enrollment, POSTDOC by Degree, POSTDOC by Gender, Sources of Support. There are Sample Queries for each of the categories.
  (November 3, 2005)

• We have backfilled the IPEDS Fall Staff Survey by Employee Type tables with data for the Fall of these years - 1993, 1995, 1997, 1999, and 2003.
  (October 13, 2005)

• More NSF R&D Expenditures data has been loaded to the Data Warehouse:
  • Passed Through Funds (Item 1a)
  • Funds Received as a Subrecipient (Item 1b)
  • Funds Received as a Subrecipient (Item 1b) - TOTAL
  • Current Fund Expenditures for Non-Science and Engineering Field (Item 2A) data has been included in the NSF R&D Current Fund Expenditures tables.
  • Current Fund Expenditures - Federally Financed Expenditures (Item 2b)
  (October 5, 2005)

• The FY2004 NSF R&D Expenditure data has been loaded to the Data Warehouse.
  (October 4, 2005)

• The final versions of the Fall 2002, Fall 2003, and Fall 2004 data for IPEDS Employee by Assigned Position have been loaded into the Data Warehouse.
  (September 15, 2005)

• 2002-2003 and 2003-2004 University of Delaware Survey data for Expenditures and Teaching Load are now in the Data Warehouse.
  (September 14, 2005)

• The Fall 2004 Retention and Graduation Survey data have been loaded.
  (June 19, 2005)

• AAUDE Peer Lists have been updated in the Data Warehouse.
  The table, AAUDE PEER INSTITUTION. now contains 1281 records.
  (May 27, 2005)

• IPEDS Completion Survey data for years: 1994-95, 1995-96, 1996-97, 1997-98, 1998-1999 have been loaded to the Data Warehouse. The Data Warehouse now contains IPEDS Completion Survey data from years 1994-95 to 2002-03.
  (May 27, 2005)

• The 2004-2005 AAUP Faculty Salary Survey data have been loaded.
  (April 20, 2005)

• The Fall 2004 Freshmen Profile data have been loaded.
  (April 20, 2005)

• The 2004-2005 Faculty Profile by CIP data have been loaded.
  Also loaded are the Footnotes for this exchange item.
  (April 15, 2005)

• The 2004-2005 CUPA Administrative Compensation Survey data have been loaded.
  (April 11, 2005)

• New data model implemented: Faculty Awards and Honors.
  (April 11, 2005)

• The 2002-2003 IPEDS Fall Enrollment data have been loaded.
  (April 7, 2005)

• The 2004-2005 Faculty Salary by CIP data have been loaded.
  (February 25, 2005)