|
|
|
All Stars Grouped by Exchange Item
This page lists all of the Stars or
Table Groups in the Data Warehouse, by Exchange Item.
Follow the Tables in Group link to see a list
of all the tables used in the star/group,
together with information on how to
combine the tables in a query.
Follow the Data Model Diagram link
(if available) to see a pictorial representation of the star.
| Star/Table Group | Description | Tables in Group | Data Model Diagram |
|---|---|---|---|
| AAMC Faculty Counts | Basic, Clinical, and Other medical faculty counts published by the AAMC. | AAMC Faculty Counts tables | AAMC Faculty Counts data model |
| Star/Table Group | Description | Tables in Group | Data Model Diagram |
|---|---|---|---|
| AAUDE Exchange Item Footnote | Footnotes and link to more documentations about a particular institution entry for a particular year in an exchange item. | AAUDE Exchange Item Footnote tables | AAUDE Exchange Item Footnote data model |
| Star/Table Group | Description | Tables in Group | Data Model Diagram |
|---|---|---|---|
| AAUDE Faculty Salary | Faculty salary by CIP, department, institution, faculty rank, appointment type and academic year. Faculty salary data in the Data Warehouse goes back to academic year 1994-1995. | AAUDE Faculty Salary tables | AAUDE Faculty Salary data model |
| AAUDE Faculty Salary - Masked | Faculty salary by CIP, department, institution, faculty rank, appointment type and academic year. Contains data for the current and previous academic year; data for private institutions is masked. | AAUDE Faculty Salary - Masked tables | AAUDE Faculty Salary - Masked data model |
| AAUDE Faculty Salary Masking Codes | Allows institutions to see their own masking codes for the current and prior academic years. | AAUDE Faculty Salary Masking Codes tables | |
| AAUDE Faculty Salary with Runzheimer Data | AAUDE Faculty Salary by CIP Star with Runzheimer Cost of Living Adjustment Data included | AAUDE Faculty Salary with Runzheimer Data tables | AAUDE Faculty Salary with Runzheimer Data data model |
| Faculty Salary with CIP Cross Walk | Comparing faculty salary across different departments of various insitutions using the Insitution CIP Cross Walk table. | Faculty Salary with CIP Cross Walk tables | Faculty Salary with CIP Cross Walk data model |
| Star/Table Group | Description | Tables in Group | Data Model Diagram |
|---|---|---|---|
| AAUP Faculty Fringe Benefit | AAUP faculty fringe benefits, including outlays and the count of faculty members (Professor, Associate Professor, and Assistant Professor) who are convered by fringes | AAUP Faculty Fringe Benefit tables | AAUP Faculty Fringe Benefit data model |
| AAUP Faculty Salary | AAUP faculty salary data by institution, faculty rank, gender, contract type | AAUP Faculty Salary tables | AAUP Faculty Salary data model |
CUPA Administrative Compensation Survey
| Star/Table Group | Description | Tables in Group | Data Model Diagram |
|---|---|---|---|
| CUPA Administrative Compensation Survey | AAUDE institutions in the CUPA Administrative Salary Survey. | CUPA Administrative Compensation Survey tables | CUPA Administrative Compensation Survey data model |
| Star/Table Group | Description | Tables in Group | Data Model Diagram |
|---|---|---|---|
| Faculty Awards | This stars shows the counts of different awards/honors received by faculty members of different institutions in different years. | Faculty Awards tables | Faculty Awards data model |
| Star/Table Group | Description | Tables in Group | Data Model Diagram |
|---|---|---|---|
| Faculty Profile by CIP | The data provide information about departmental faculty profiles, including both tenure/track and non-tenure-track populations, with gender and racial/ethnic parameters. The information is collected by CIP code. For a given academic year and an institution, there is a record for each CIP code, Faculty Rank Code, Tenure Code, Track Attribute, Full-Time/Part-Time code, Gender Code, Race/Ethnicity Code, Medical Code, and EAP Category. | Faculty Profile by CIP tables | Faculty Profile by CIP data model |
| Star/Table Group | Description | Tables in Group | Data Model Diagram |
|---|---|---|---|
| Freshmen Profile Academic Backgroud Statistics | Enrolled freshmen profile academic background statistics. Information includes size of entering class, number and percent of entering class reporting SAT and ACT scores, SAT 25th and 75th Percentile, ACT 25th and 75th Percentile, and high school GPA. | Freshmen Profile Academic Backgroud Statistics tables | Freshmen Profile Academic Backgroud Statistics data model |
| Freshmen Profile Academic Backgroud by Residency | Enrolled freshmen profile academic background statistics by residency status (resident vs. non resident). | Freshmen Profile Academic Backgroud by Residency tables | Freshmen Profile Academic Backgroud by Residency data model |
| Freshmen Profile Enrollee Distribution | Enrolled freshmen profile distributions of enrollee by racial/ethnicity, Gender, and Full-Time or Part-Time status. | Freshmen Profile Enrollee Distribution tables | Freshmen Profile Enrollee Distribution data model |
| Freshmen Profile Enrollee by Residency | Enrolled freshmen profile distributions of enrollee by racial/ethnicity, Gender, and Full-Time or Part-Time status. Each count is broken down by residency status (resident vs. non resident). | Freshmen Profile Enrollee by Residency tables | Freshmen Profile Enrollee by Residency data model |
| Freshmen Profile Yield Rates | Enrolled freshmen profile yield rates which include the application yield and the matriculation yield, as well as the number of applications, admits, and enrolled to an institution in an academic year. | Freshmen Profile Yield Rates tables | Freshmen Profile Yield Rates data model |
| Freshmen Profile Yield Rates by Residency Status | Enrolled freshmen profile yield rates by residency status. Data includes application yield, matriculation yield, number of applications, admits, and enrolled for each institution in an academic year, broken down by "resident" (legal residency used for tuition purposes, anyone whose tuition residency is in the institution's home state) and "non resident" (anyone whose tuition residency is not in the institution's home state). | Freshmen Profile Yield Rates by Residency Status tables | Freshmen Profile Yield Rates by Residency Status data model |
| Star/Table Group | Description | Tables in Group | Data Model Diagram |
|---|---|---|---|
| Graduate Stipends - Benefits | This star consists of the Benefits information for Graduate Assistants and their spouses/partners/dependents. Data items include health insurance annual premium, percentage of contribution to the premium made by the university, coverage for spouse and/or dependent, dental and vision coverage, etc. Data for each institution are grouped by academic year and the type of graduate assistant. There are two versions of the Graduate Assistant Benefits fact table: (1) The GRADSTIP BENEFITS DETAIL table contains benefits information for academic years prior to 2004-05. (2) GRADSTIP BENEFITS 2005 DETAIL table is formatted for benefits records since academic year 2004-05. | Graduate Stipends - Benefits tables | Graduate Stipends - Benefits data model |
| Graduate Stipends - Cash Salary | This star consists of the collection of graduate assistant cash salary and graduate appointment data items for Graduate Assistant Stipends. Data items include: minimum, maximum, mode, and average cash salary, number of hours per week expected, number of weeks in a noraml graduate appointment, minimum and maximum credits per term. Data for each institution are grouped by academic year and type of graduate assistant. | Graduate Stipends - Cash Salary tables | Graduate Stipends - Cash Salary data model |
| Graduate Stipends - Salary by CIP | This star consists of the collection of graduate assistant salary data by CIP. | Graduate Stipends - Salary by CIP tables | Graduate Stipends - Salary by CIP data model |
| Graduate Stipends - Tuition, Fees and Cost | This star consists of the collection of graduate assistant compensation, tuition paid, and cost to institution data items for Graduate Assistant Stipends. Data for each institution are grouped by academic year, type of graduate assistant, resident status, and credit hour per semester. Data items include: average Graduate Compensation, Tuition and Fees Paid, Lost Tuition and Fees, and Cost to Institution. | Graduate Stipends - Tuition, Fees and Cost tables | Graduate Stipends - Tuition, Fees and Cost data model |
| Star/Table Group | Description | Tables in Group | Data Model Diagram |
|---|---|---|---|
| IPEDS Completion Survey | Completions by Award Levels (Doctor's degrees, Master's degrees, First-Professional degrees, Bachelor's degrees, etc.) conferred by gender and ethnicity (White, Hispanic, Black, Asian, Non-resident alien, etc.) within Program (or CIP). | IPEDS Completion Survey tables | IPEDS Completion Survey data model |
IPEDS Employee by Assigned Position
| Star/Table Group | Description | Tables in Group | Data Model Diagram |
|---|---|---|---|
| IPEDS Employee by Assigned Position | Number of employees for each institution in an academic year, grouped by position description, primary function of the position, and tenure status | IPEDS Employee by Assigned Position tables | IPEDS Employee by Assigned Position data model |
| Star/Table Group | Description | Tables in Group | Data Model Diagram |
|---|---|---|---|
| IPEDS Fall Enrollment - Summary | Summary (Total Count) of IPEDS Fall Enrollment. The USDE National Center for Educational Statistics annual servey of enrollment statistics in postsecondary education throughout the nation. This is PART A of the Survey (Form 'EF'). It consists of the total (summary, ie. CIP code=99.0000) count of enrollment of different demographic (gender and ethnicity) by student level (graduate, undergraduate, first professional) and attendance status (Full-time or Part-time). | IPEDS Fall Enrollment - Summary tables | IPEDS Fall Enrollment - Summary data model |
| IPEDS Fall Enrollment - by Discipline | The USDE National Center for Educational Statistics annual servey of enrollment statistics in postsecondary education throughout the nation. This is PART A of the Survey (Form 'EF'). It consists of the count of enrollment by a selected group of discipline (CIP code) of different demographic (gender and ethnicity) by student level (graduate, undergraduate, first professional) and attendance status (Full-time or Part-time). | IPEDS Fall Enrollment - by Discipline tables | IPEDS Fall Enrollment - by Discipline data model |
| Star/Table Group | Description | Tables in Group | Data Model Diagram |
|---|---|---|---|
| IPEDS Fall Staff Survey by Employee Type | This represents one part of many in the IPEDS Fall Staff Survey. Counts of employees as well as the percentage of all employees for each institution are grouped by gender, employee status (Full Time or Part Time), and types of employees (faculty, administrative/managerial, Clerical and Secretarial, etc.). Full time faculty is further grouped by contracts - 9/10 month contract, 11/12 month contract, or a less than 9/10 month contract. | IPEDS Fall Staff Survey by Employee Type tables | IPEDS Fall Staff Survey by Employee Type data model |
| IPEDS Fall Staff Survey with Salary Range | This represents one part of many in the IPEDS FAll Staff Survey. It is a survey of staff in postsecondary insitutions by full/part-time status and type of work they perform (ie. Employee Type). The count (and percentage) of employees are grouped by salary range, gender, employee status, and employee type for each participating institution in an academic year. | IPEDS Fall Staff Survey with Salary Range tables | IPEDS Fall Staff Survey with Salary Range data model |
| Star/Table Group | Description | Tables in Group | Data Model Diagram |
|---|---|---|---|
| IPEDS Finance Survey | The USDE National Center for Educational Statistics annual survey of the financial condition of postsecondary education in the nation. The survey data stored in the Data Warehouse consists of the following parts: Part A (Current Funds Revenues by Source), Part B (Current Funds Expenditures by Function), Part D (Utility Expenditures), Part E (Scholarship and Fellowship Expenditures), Part F (Expenditures for Acquisitions of Library Materials), Part G (Indebtedness of Physical Plant), Part H (Details of Endowment Assets), Part K (Physical Plant Assets).The survey years range from 1989 through 2000. | IPEDS Finance Survey tables | IPEDS Finance Survey data model |
IPEDS Institution Characteristics
| Star/Table Group | Description | Tables in Group | Data Model Diagram |
|---|---|---|---|
| NSF Federal Support Survey | 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 (Federally Funded Reseach & Development Center) administered by universities. The data is aggregated into major agency groups such as the Department of Commerce (DOC), the Department of Defense (DOD), NASA, the U.S. Department of Agriculture (USDA), etc. There is one record per fiscal year, per institution, per agency group. | NSF Federal Support Survey tables | NSF Federal Support Survey data model |
| Star/Table Group | Description | Tables in Group | Data Model Diagram |
|---|---|---|---|
| NSF GSS by Degree - TOTAL Post Doc & Non-Faculty | NSF Graduate Student Support - Total count of all Post Doctorate Students and Non-Faculty Research Staff by their degree types (PHD or PHD Medical). There is no break-down by funding source in this Star. | NSF GSS by Degree - TOTAL Post Doc & Non-Faculty tables | NSF GSS by Degree - TOTAL Post Doc & Non-Faculty data model |
| NSF GSS by Gender - TOTAL Post Doc & Non-Faculty | NSF Graduate Student Support - Total count of all Post Doctorate Students and Non-Faculty Research Staff by Gender. There is no break-down by funding source in this Star. | NSF GSS by Gender - TOTAL Post Doc & Non-Faculty tables | NSF GSS by Gender - TOTAL Post Doc & Non-Faculty data model |
| NSF GSS Enrollment by Ethnicity and Gender | NSF Graduate Student Support: Enrollment count and status, by ethnicity and gender. This aggregation is for all graduate students, their enrollment status, ethnicity and gender. | NSF GSS Enrollment by Ethnicity and Gender tables | NSF GSS Enrollment by Ethnicity and Gender data model |
| NSF GSS Enrollment by Gender | NSF Graduate Student Support: Total Enrollment by Gender. This aggregation is for all graduate students, their enrollment status (Full-Time or Part-Time), grouped by gender. | NSF GSS Enrollment by Gender tables | NSF GSS Enrollment by Gender data model |
| NSF GSS POSTDOC - Foreign Visa Holder - by Degree | NSF Graduate Student Support - Total count of foreign Post Doctorate students by their degree types (PhD or PhD Medical). There is no break-down by funding source in this star. Non-faculty research staff is not included in this star. | NSF GSS POSTDOC - Foreign Visa Holder - by Degree tables | NSF GSS POSTDOC - Foreign Visa Holder - by Degree data model |
| NSF GSS POSTDOC - Foreign Visa Holder - by Gender | NSF Graduate Student Support - Total count of foreign Post Doctorate students by gender. There is no break-down by funding source in this star. Non-faculty research staff is not included in this star. | NSF GSS POSTDOC - Foreign Visa Holder - by Gender tables | NSF GSS POSTDOC - Foreign Visa Holder - by Gender data model |
| NSF GSS POSTDOC - Funding Source - by Degree | NSF Graduate Student Support - Count of Post Doctorate Students on Funding Source (e.g. fellowhips, traineeships, research grants) and Degree Type (PhD, PhD and Medical). This aggregation is for post-doctorate students only, funding source is not reported for non-faculty research staff. | NSF GSS POSTDOC - Funding Source - by Degree tables | NSF GSS POSTDOC - Funding Source - by Degree data model |
| NSF GSS POSTDOC - Funding Source - by Gender | NSF Graduate Student Support - Count of Post Doctorate Students on Funding Source (e.g. fellowhips, traineeships, research grants) by Gender. This aggregation is for post-doctorate students only, funding source is not reported for non-faculty research staff. | NSF GSS POSTDOC - Funding Source - by Gender tables | NSF GSS POSTDOC - Funding Source - by Gender data model |
| NSF GSS Support Sources | NSF Graduate Student Support: Count of full time graduate student by sources of support (Department of Defense, National Institutes of Health, etc.) and appointment types (fellowships, teaching assistantships, research grants, etc.) in different NSF disciplines (computer science, biological sciences, engineering, etc.) for each school and institution in a fiscal year. | NSF GSS Support Sources tables | NSF GSS Support Sources data model |
| NSF GSS Support Sources - WOMEN | NSF Graduate Student Support. Count of full time WOMEN graduate student by sources of support (eg. Department of Defense, National Institutes of Health) in different NSF disciplines (eg. computer science, engineering, economics, biological sciences) for each school and institution in a fiscal year. There is no break-down by appointment type (ie. fellowships, teaching assistantships, research assistantships, etc.) in this Star. | NSF GSS Support Sources - WOMEN tables | NSF GSS Support Sources - WOMEN data model |
| Star/Table Group | Description | Tables in Group | Data Model Diagram |
|---|---|---|---|
| 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. | NSF R&D Current Fund Expenditures tables | NSF R&D Current Fund Expenditures data model |
| NSF R&D Equipment Expenditures | This represents one part of three parts of the NSF Survey of R&D Expenditures at Universities and Colleges - Current fund expenditures for research equipment (federally and non-federally financed) for separately budgeted research and development, by field of science and engineering. Current fund expenditures in each field for scientific research equipment represents the subtotal (or a portion) of the amounts reported in the corresponding cells of the NSF Current Fund Expenditures by Field of Science and Engineering. | NSF R&D Equipment Expenditures tables | NSF R&D Equipment Expenditures data model |
| NSF R&D Expenditures by Source of Funds | This represents one part of three parts of the NSF Survey of R&D Expenditures at Universities and Colleges - ITEM 1: Current fund expenditures for separately budgeted research and development in the sciences and engineering by source of funds. The total amounts are dollars in thousands. | NSF R&D Expenditures by Source of Funds tables | NSF R&D Expenditures by Source of Funds data model |
| NSF R&D Federally Financed Expenditures | This represents one part (ITEM 2B) of three parts of the NSF Survey of R&D Expenditures at Universities and College for Current Fund Expenditures. This part, ITEM 2B, represents the federally financed R&D expenditures for separately budgeted research and development by field of science and engineering. | NSF R&D Federally Financed Expenditures tables | NSF R&D Federally Financed Expenditures data model |
| NSF R&D Funds Received as a Subrecipient | This represents the third part of three parts of the NSF Survey of R&D Expenditures at Universities and Colleges - ITEM 1b, Funds Received as a Subrecipient: Current fund expenditures for separately budgeted research and development in the sciences and engineering received as a subrecipient. The question in the survey: "How much of your Item 1 total (line 1100) and Federal (line 1110) R&D expenditures did you receive as a subrecipient?" | NSF R&D Funds Received as a Subrecipient tables | NSF R&D Funds Received as a Subrecipient data model |
| NSF R&D Funds Received as a Subrecipient - TOTAL | This represents the third part of three parts of the NSF Survey of R&D Expenditures at Universities and Colleges - ITEM 1b, Funds Received as a Subrecipient: Current fund expenditures for separately budgeted research and development in the sciences and engineering received as a subrecipient. The question in the survey: "How much of your Item 1 total (line 1100) and Federal (line 1110) R&D expenditures did you receive as a subrecipient?" This data model only shows records for the TOTAL amount, ie. line 1600 (which represents the sum of lines 1610 and 1620). | NSF R&D Funds Received as a Subrecipient - TOTAL tables | NSF R&D Funds Received as a Subrecipient - TOTAL data model |
| NSF R&D Passed Through Funds | This represents the second part of three parts of the NSF Survey of R&D Expenditures at Universities and Colleges - ITEM 1a, Passed Through Funds: Current fund expenditures for separately budgeted research and development in the sciences and engineering passed through the institution to subrecipients. The question in the survey: "How much of your Item 1 total (line 1100) and Federal (line 1110) R&D expenditures was passed through to subrecipients?" | NSF R&D Passed Through Funds tables | NSF R&D Passed Through Funds data model |
| Star/Table Group | Description | Tables in Group | Data Model Diagram |
|---|---|---|---|
| Retention Tracking Summary | Summary of graduation/retention tracking | Retention Tracking Summary tables | Retention Tracking Summary data model |
| Retention Tracking by Demographic | Tracking of graduation/retention by gender and ethnicity | Retention Tracking by Demographic tables | Retention Tracking by Demographic data model |
| Retention Tracking by Ethnicity | Tracking of graduation/retention by ethnicity | Retention Tracking by Ethnicity tables | Retention Tracking by Ethnicity data model |
| Retention Tracking by Gender | Tracking of graduation/retention by gender | Retention Tracking by Gender tables | Retention Tracking by Gender data model |
| Retention Tracking by Resident | Tracking of graduation/retention by resident - resident vs. non-resident | Retention Tracking by Resident tables | Retention Tracking by Resident data model |
| Star/Table Group | Description | Tables in Group | Data Model Diagram |
|---|---|---|---|
| Runzheimer Cost of Living Adjustment | This is Runzheimer Cost of Living Adjustment data for AAUDE institutions. | Runzheimer Cost of Living Adjustment tables | Runzheimer Cost of Living Adjustment data model |
| Star/Table Group | Description | Tables in Group | Data Model Diagram |
|---|---|---|---|
| Survey of Earned Doctorates | The Doctorate Records File which contains the SED data is a data bank maintained by the National Opinion Research Center of the University of Chicago under contract to the National Science Foundation. The file contains data on all earned doctorates granted by regionally accredited United States universities, in all fields, from 1920 to the present. Information in the survey covering the following items: sex, race, marital status, citizenship status, country of citizenship, sources of financial support, baccalaureate institution and year, master's institution and year, doctorate institution, field, and year, etc. | Survey of Earned Doctorates tables |
| Star/Table Group | Description | Tables in Group | Data Model Diagram |
|---|---|---|---|
| Tuition and Required Fees | Tuition and required fee amounts by academic year and programs. It shows the tuition and various fee amounts for the academic year for full-time undergraduate and graduate programs, as well as other professional programs (e.g. Dentistry, Law, Business, Medicine) for both residents and non-residents. | Tuition and Required Fees tables | Tuition and Required Fees data model |
| Tuition and Required Fees by Type | Tuition and required fee amounts by academic year, programs, and tuition/fee type. It shows the tuition and various fee amounts for the academic year for full-time undergraduate and graduate programs, as well as other professional programs (e.g. Dentistry, Law, Business, Medicine) for both residents and non-residents. | Tuition and Required Fees by Type tables | Tuition and Required Fees by Type data model |
| Star/Table Group | Description | Tables in Group | Data Model Diagram |
|---|---|---|---|
| Undergraduate Time to Degree | This is an annual collection of summary information about the population of Bachelor's Degrees awarded by institution. Several key data elements describe alternate aspects of the amount of time typically required to complete an undergraduate degree. | Undergraduate Time to Degree tables | Undergraduate Time to Degree data model |
| Star/Table Group | Description | Tables in Group | Data Model Diagram |
|---|---|---|---|
| Delaware Survey for Expenditures | The University of Delaware Survey for Expenditures. Records are grouped by academic year, institution, and Four-Digit CIP Code. In addition to salary, benefits, non-personnel item, research, and public service expenditures, the number of different types of degrees (bachelor, master, doctoral, professional) offered as well as the undergraduate and graduate student credit hours for the program (CIP) are also available. | Delaware Survey for Expenditures tables | Delaware Survey for Expenditures data model |
| Delaware Survey for Teaching Load | The University of Delaware Survey for Teaching Load. Records are grouped by academic year, institution, Four-Digit CIP Code, and faculty type (ie. Tenured or Tenure Eligible faculty, Other Regular Faculty, Supplemental Faculty, Teaching Assistants, etc.). Fields in each record include Instructional and Separately Budgeted FTE faculty,Undergraduate and Graduate Student Credit Hours and Number of Lab, Discussion, Recitation and Other Sections. | Delaware Survey for Teaching Load tables | Delaware Survey for Teaching Load data model |
e-mail aaude-warehouse@mit.edu | Warehouse home | AAUDE home
