|
|
|
Sample Queries Grouped by Exchange Item
Click on the Brio, SQL, or Access links
underneath the
sample query name to download the appropriate type of query
Instructions for download & processing sample queries from the web
| Sample Query | Description | Last Modified Date |
|
Exchange Item Footnotes Brio SQL |
Footnotes and link to more documentations regarding a specific institution entry for a specific year in an exchange item. | 04/01/2005 |
| Sample Query | Description | Last Modified Date |
|
AAUDE Faculty Salary by CIP Brio SQL |
Faculty salary reports by CIP. Search criteria include institutions, faculty rank, appointment type, academic year, and CIP category. | 03/05/2002 |
|
Faculty Salary by CIP with Cross Walk Brio SQL |
Report which compares faculty salary of various institutions against a key institution by CIP. Search criteria of the query include: the key institution, the list of institutions to compare against, academic year, faculty rank and appointment type. This sample query is created by (and thus specific for) the University of Texas. | 04/19/2002 |
| Sample Query | Description | Last Modified Date |
|
AAUP Faculty Salary Summary Report Brio SQL |
Faculty Salary Summary Report by institutions, gender, faculty rank, and contract type. | 10/02/2002 |
| Sample Query | Description | Last Modified Date |
|
Institution CIP Cross Walk for Faculty Salary Brio SQL |
Institution CIP cross walk by academic year for faculty salary. In a specific academic year, it lists the CIP code assigns to each department in a college/division of an institution. | 04/22/2002 |
|
Institution CIP Cross Walk for IPEDS Completion Brio SQL |
Institution CIP cross walk by academic year for IPEDS Completion Survey. In a specific academic year, it lists the CIP code assigns to each department in a college/division of an institution. | 04/22/2002 |
|
NSF Discipline CIP Cross Walk Brio SQL |
NSF Discipline and CIP cross walk. It lists the multiple CIP codes assign to each NSF Discipline code. | 04/22/2002 |
CUPA Administrative Compensation Survey
| Sample Query | Description | Last Modified Date |
|
CUPA Administrative Salary Brio SQL |
AAUDE institutions in the CUPA Administrative Salary Survey. Annualized salary for each CUPA position as submitted by the institutions for an academic year. Data items include the characteristics (structure, affiliation, etc.) for the institutions, the position numbers and descriptions, the reporting relationships of the positions, the hiring status (Internal promotion, Outside Hire, etc.), gender, minority status, years of service, and whether the position is vacant. | 06/10/2002 |
| Sample Query | Description | Last Modified Date |
|
Faculty Awards Brio SQL |
Counts of awards/honors received by faculty members in different institutions. | 04/06/2005 |
| Sample Query | Description | Last Modified Date |
|
Faculty Profile by CIP Brio SQL |
This query shows faculty profiles and headcount by departments and schools (CIP Code) within an institution for an academic year. Faculty profile information including full-time/part-time tenure/track and non-tenure-track populations, with gender and racial/ethnic parameters. | 04/24/2003 |
| Sample Query | Description | Last Modified Date |
|
Freshmen Profile Academic Background Statistics Brio SQL |
Entering class size, number and percentage of entering class reporting SAT and ACT scores, SAT Verbal & Math 25th and 75th Percentile, ACT 25th and 75th Percentile, High School GPA, etc. for the academic year. | 04/06/2004 |
|
Freshmen Profile Academic Background by Residency Brio SQL |
Entering class size, number and percentage of entering class reporting SAT and ACT scores, SAT Verbal & Math 25th and 75th Percentile, ACT 25th and 75th Percentile, High School GPA, etc. for the academic year, broken down by residency status -- resident vs. non resident. | 04/06/2004 |
|
Freshmen Profile Enrollee Distribution Brio SQL |
Number and percentage of entering freshmen for the academic year with distributions in racial/ethnicity, gender, and full-time or part-time status. | 04/06/2004 |
|
Freshmen Profile Enrollee by Residency Brio SQL |
Number and percentage of entering freshmen for the academic year, broken down by residency status (resident vs. non resident) with distributions in racial/ethnicity, gender, and full-time or part-time status. | 04/06/2004 |
|
Freshmen Profile Yield Rates Brio SQL |
Number of applied, admitted, and enrolled freshmen, and the application and matriculation yields for the academic year. | 04/06/2004 |
|
Freshmen Profile Yield Rates by Residency Brio SQL |
Number of applied, admitted, and enrolled freshmen, and the application and matriculation yields for the academic year, broken down by residency status -- resident vs. non resident. | 04/06/2004 |
| Sample Query | Description | Last Modified Date |
|
Graduate Stipends - Benefits Brio SQL |
Annual servey of graduate assistant stipends - benefits information. Health insurance (including dental and vision) coverage for graduate assistants and their spouses and dependents. Data items include the total annual premium for the insurance and the university contribution (%) to the premium. | 07/24/2003 |
|
Graduate Stipends - Cash Salary and Appointment Brio SQL |
Annual survey of graduate assistant stipends - cash salary and appointment. Cash salary and graduate appointment data for each institution are grouped by academic year and type of graduate assistant. Data items include the maximum, minimum, average, and mode cash salary; number of FTE, headcount and credit hour per semester. Two pivot reports are included in this query: "Graduate Assistant Half-Time Equivalent Stipends" with FTE, Headcount, Minimum Cash Salary, Average Cash Salary, and Maximum Cash Salary for each type of graduate assistants (Teaching Assistant, Research Assistant, and Other Graduate Assistant), and the "General Policies" report which includes the minimum and maximum credits per term, number of weeks in normal graduate appointment, and number of hours per week expected for each type of graduate assistants. | 07/31/2002 |
|
Graduate Stipends - Compensation & Cost Brio SQL |
Annual survey of graduate assistant stipends - Average GA Compensation, Tuition, and Cost to Institution. Compensation, tuition, and cost data for each institution are grouped by academic year, type of graduate assistant (Teaching Assistant, Research Assistant, and Other Graduate Assistant), resident status (resident or non-resident) and credit hour per semester (e.g. 6 credits, 9 credits). Data items include: tuition and fees paid, lost tuition and fees, cost to institution, and average GA compensation. There are three pivot reports, one for each of the three types of graduate assistants. Another two pivot reports grouped the data together by resident status. | 07/31/2002 |
|
Graduate Stipends - Salary by CIP Brio SQL |
Annual survey of graduate assistant stipends - salary by CIP code and CIP type ("payroll_dept" or "program_study") | 08/21/2007 |
| Sample Query | Description | Last Modified Date |
|
IPEDS Completion Survey Brio SQL |
Number of completions by award (degree) level conferred by gender and ethinicity within program (CIP). Various pivot reports are included in this query including: Total by Institution and Degree; Total by CIP category (2-digit CIP) and Degree; Total by Institution, Gender, and Ethnicity; Total by Institution, Ethnicity, Gender, and Degree. The survey includes data from academic years 1998-1999 and beyond. | 04/02/2002 |
IPEDS Employee by Assigned Position
| Sample Query | Description | Last Modified Date |
|
IPEDS Employee by Assigned Position Brio SQL |
Number of employees by description of position (full-time or part-time medical, full-time or part-time non-medical), primary function (Executive, adminstrative, research, instructional, professional, service, maintanence, etc.) and tenure status (tenured, non-tenure, without faculty status, etc.) for each participating institutions, grouped by academic year. | 09/15/2005 |
| Sample Query | Description | Last Modified Date |
|
IPEDS Fall Enrollment - Summary Brio SQL |
Summary of IPEDS Fall Enrollment - Part A, Form EF of the IPEDS Fall Enrollment Survey with Gender and Ethnic Enrollment by Student Level and Attendance Status | 06/18/2002 |
|
IPEDS Fall Enrollment - by Discipline Brio SQL |
IPEDS Fall Enrollment by Discipline (or CIP Code), grouped by gender and ethincity, level of study, and attendance status. | 06/18/2002 |
| Sample Query | Description | Last Modified Date |
|
IPEDS Fall Staff Survey by Employee Type Brio SQL |
Number (and percentage) of employees in each institution grouped by employee status (Part Time or Full Time), gender, types of employee (Faculty, Administrative/Managerial, Skilled Crafts, Clerical and Secretarial, etc.), and contracts (for full time faculty only). | 03/27/2002 |
|
IPEDS Fall Staff Survey with Salary Range Brio SQL |
Number (and percentage) of employees by salary range, gender, employee status, and employee type for each particpating institution in an academic year. | 06/25/2002 |
| Sample Query | Description | Last Modified Date |
|
IPEDS Finance Survey Brio SQL |
The IPEDS annual survey the financial condition of postsecondary education in the nation. The search criteria of the query include fiscal year(s) and institution name(s). There are 8 pivot reports included in this query, one for each part of the survey currently available in the Data Warehouse -- parts A, B, D, E, F, G, H, and K. The survey includes data dated back from fiscal year 1989. | 02/04/2003 |
| Sample Query | Description | Last Modified Date |
|
NSF Federal Support Survey Brio SQL |
NSF Survey of Federal Support to Universities, Colleges, and Nonprofit Institutions. The data covers obligations for research and development to universities and colleges and to FFRDCs administered by universities. | 03/26/2008 |
| Sample Query | Description | Last Modified Date |
|
NSF Grad Student Support Enrollment - Gender Brio SQL |
NSF Graduate Student Support Enrollment by Gender with Enrollment Status (Part Time or Full Time) | 07/31/2006 |
|
NSF Grad Student Support Enrollment - Gender - including NON AAUDE Institutions Brio SQL |
NSF Graduate Student Support Enrollment by Gender with Enrollment Status (Part Time or Full Time), including NON AAUDE Institutions. The NSF_INSTITUTION table is used in this query instead of the INSTITUTION table. | 08/31/2006 |
|
NSF Grad Student Support Enrollment Detail Brio SQL |
NSF Graduate Student Support Enrollment (including full-time and part-time enrollment status) by Gender and Ethnicity | 07/31/2006 |
|
NSF Grad Student Support Enrollment Detail - including NON AAUDE Institutions Brio SQL |
NSF Graduate Student Support Enrollment (including full-time and part-time enrollment status) by Gender and Ethnicity, including Non AAUDE Institutions. The NSF_INSTITUTION table is used in this query instead of the INSTITUTION table. | 08/31/2006 |
|
NSF Grad Student Support Sources - WOMEN only Brio SQL |
NSF Graduate Student Support - Full Time Graduate Students Sources of Support. Aggregation for full-time WOMEN graduate students only, by Funding Support Sources (DOD, NIH, INST, DOE, etc.) in various NSF disciplines for each school and institution in a fiscal year. There is no break-down by appointment type (ie. fellowships, teaching assistantships, research assistantships, traineeships, etc.) in this report. | 11/03/2005 |
|
NSF Grad Student Support Sources Detail Brio SQL |
NSF Graduate Student Support - Full Time Graduate Students Sources of Support. Aggregation for full-time graduate students, by Appointment Type (eg. fellowships, traineeships, research assistantships, teaching assistantships, etc.) and Funding Support Sources (DOD, NIH, INST, DOE, etc.) in various NSF disciplines for each school and institution in a fiscal year. | 11/03/2005 |
|
NSF Grad Student Support by Degree - POSTDOC on Foreign Visa Holders Brio SQL |
NSF Graduate Student Support. Aggregation for Post Doctorate students by degree type (PHD or PHDMED) for Foreign visa holders. No break-up by Funding Source. | 07/31/2006 |
|
NSF Grad Student Support by Degree - POSTDOC on Foreign Visa Holders, NON AAUDE Institutions Brio SQL |
NSF Graduate Student Support. Aggregation for Post Doctorate students by degree type (PHD or PHDMED) for Foreign visa holders. No break-up by Funding Source. Including NON AAUDE Institutions. Using the NSF_INSTITUTION table. | 08/31/2006 |
|
NSF Grad Student Support by Degree - POSTDOC on funding source Brio SQL |
NSF Graduate Student Support. Aggregation for Post Doctorate students on funding source (eg. Fellowships, Traineeships, Research grants, Non federal) and degree type (PHD or PHDMED). | 07/31/2006 |
|
NSF Grad Student Support by Degree - POSTDOC on funding source, including NON AAUDE Institutions Brio SQL |
NSF Graduate Student Support. Aggregation for Post Doctorate students on funding source (eg. Fellowships, Traineeships, Research grants, Non federal) and degree type (PHD or PHDMED). Including NON AAUDE Institutions. Using the NSF_INSTITUTION table. | 08/31/2006 |
|
NSF Grad Student Support by Degree - TOTAL COUNT of POSTDOC and NONFAC Brio SQL |
NSF Graduate Student Support. Total count of Post Doctorate students and Non-Faculty Research Staff by degree type (PHD or PHDMED). | 07/31/2006 |
|
NSF Grad Student Support by Gender - POSTDOC on Foreign Visa Holders Brio SQL |
NSF Graduate Student Support. Aggregation for Post Doctorate students by gender on Foreign visa holders. No break-up by Funding Source. | 07/31/2006 |
|
NSF Grad Student Support by Gender - POSTDOC on Foreign Visa Holders, NON AAUDE Institutions Brio SQL |
NSF Graduate Student Support. Aggregation for Post Doctorate students by gender on Foreign visa holders. No break-up by Funding Source. Including NON AAUDE Institutions. Using the NSF_INSTITUTION table. | 08/31/2006 |
|
NSF Grad Student Support by Gender - POSTDOC on funding source Brio SQL |
NSF Graduate Student Support. Aggregation for Post Doctorate students on funding source (eg. Fellowships, Traineeships, Research grants, Non federal) by Gender. | 07/31/2006 |
|
NSF Grad Student Support by Gender - POSTDOC on funding source, including NON AAUDE Institutions Brio SQL |
NSF Graduate Student Support. Aggregation for Post Doctorate students on funding source (eg. Fellowships, Traineeships, Research grants, Non federal) by Gender. Including NON AAUDE Institutions. Using the NSF_INSTITUTION table. | 08/31/2006 |
|
NSF Grad Student Support by Gender - TOTAL COUNT of POSTDOC and NONFAC Brio SQL |
NSF Graduate Student Support. Total count of Post Doctorate students and Non-Faculty Research Staff by Gender. | 07/31/2006 |
| Sample Query | Description | Last Modified Date |
|
NSF R&D Current Fund Expenditures Brio SQL |
NSF Survey of R&D Current Fund Expenditures (federally financed or non federally financed) by Field of Science and Engineering (Item 2) and Non-Science and Engineering Field (Item 2A). | 10/14/2005 |
|
NSF R&D Current Fund Expenditures, including Non AAUDE Institutions Brio SQL |
NSF Survey of R&D Current Fund Expenditures (federally financed or non federally financed) by Field of Science and Engineering (Item 2), including non AAUDE Institutions. | 05/11/2006 |
|
NSF R&D Equipment Expenditures Brio SQL |
NSF Survey of R&D Expenditures for research equipment by field of science and engineering. (Item 3) | 03/22/2002 |
|
NSF R&D Equipment Expenditures, including Non AAUDE Institutions Brio SQL |
NSF Survey of R&D Expenditures for research equipment by field of science and engineering (Item 3), including non AAUDE institutions | 05/11/2006 |
|
NSF R&D Expenditures - Subrecipients Brio SQL |
NSF Survey of R&D Expenditures by Source of Funds - Funds Received as a Subrecipient (Item 1b). Data collection started in 2000. | 10/05/2005 |
|
NSF R&D Expenditures - Subrecipients (Total) Brio SQL |
NSF Survey of R&D Expenditures by Source of Funds - Funds Received as a Subrecipient (Item 1b) -- TOTAL only. | 10/05/2005 |
|
NSF R&D Expenditures Passed Through Funds Brio SQL |
NSF Survey of R&D Expenditures by Source of Funds - Passed Through Funds (Item 1a). Data collection started in 1997. | 10/05/2005 |
|
NSF R&D Expenditures by Source of Funds Brio SQL |
NSF Survey of R&D Expenditures by Source of Funds (Item 1). Data collection started in 1980. | 03/20/2002 |
|
NSF R&D Expenditures by Source of Funds including Non AAUDE Institutions Brio SQL |
NSF Survey of R&D Expenditures by Source of Funds (Item 1), including Non AAUDE Institutions. Data collection started in 1980. | 05/10/2006 |
|
NSF R&D Federal Financed Current Fund Expenditures Brio SQL |
NSF Survey of R&D Current Fund Expenditures -- Federally Financed -- by Field of Science and Engineering (Item 2B) | 10/14/2005 |
| Sample Query | Description | Last Modified Date |
|
Retention Tracking Summary Brio SQL |
Graduation and Retention Tracking Summary Reports by institutions and entering classes/years; including a report for Summary of 4-Year and 6-Year Graduation Rates. | 03/01/2002 |
|
Retention Tracking by Demographic Brio SQL |
Graduation and Retention Tracking Reports by demographic (ethnicity and gender) for different insitutions and entering classes/years. | 03/01/2002 |
|
Retention Tracking by Resident Status Brio SQL |
Graduation and Retention Tracking Reports by Resident Status (in-state or out-of-state) for different institutions and entering classes/year. | 03/01/2002 |
| Sample Query | Description | Last Modified Date |
|
Survey of Earned Doctorates Brio SQL |
Results of the survey of earned doctorates (SED), 1920 to present. | 04/30/2004 |
| Sample Query | Description | Last Modified Date |
|
Tuition and Required Fees Brio SQL |
This query shows the tuition amount and the various fee amounts, for the academic year, in different programs (eg. Undergraduate, Graduate, Business, Engineering, Dentistry, Medicine, etc.) for both residents and non-residents of the participating universities. | 01/02/2007 |
| Sample Query | Description | Last Modified Date |
|
Delaware Survey for Expenditures Brio SQL |
This query shows salary, benefits, non-personnel item, research, and public service expenditures of an institution for a given academic year, grouped by Four-Digit CIP Codes. Also included in the query are the different types of degrees offered by the program as well as the undergraduate and graduate student credit hours by the program (CIP). | 04/24/2003 |
|
Delaware Survey for Teaching Load Brio SQL |
This query shows the faculty FTE (instructional and separatley budgeted faculty), Undergraduate and Graduate Student Credit Hours, and Undergraduate and Graduate Sections of Labs, Discussions, Recitations, and Others of the participating institutions for a given academic year. Records are grouped by Four-Digit CIP Codes and Faculty Type (ie. Tenured or Tenure Eligibile Faculty, Other Regular Faculty, Teaching Assistants, etc.). | 04/24/2003 |
e-mail aaude-warehouse@mit.edu | Warehouse home | AAUDE home