AAUDE banner MIT Data Warehouse logo

All Data Warehouse Tables

This page lists all the tables in the Data Warehouse, in alphabetical order.
Clicking on a Table Name will display the fields found in that table.


Table Name Description Type Exchange Item Last Load Date
AAMC_DETAIL This is a fact table containing AAMC Faculty Counts. Fact AAMC Faculty Counts 19-FEB-2014
AAMC_FACULTY_TYPE This is a dimension table containing information about AAMC faculty types. Dimension AAMC Faculty Counts Unavailable
AAMC_INSTITUTION This is a dimension table containing AAMC institution names. Dimension AAMC Faculty Counts 19-FEB-2014
AAUDE_FACSAL_DEPARTMENT Contains information about the departments and schools of an institution. This is a dimension table used with the AAUDE Faculty Salary fact table. Dimension AAUDE Faculty Salary by CIP 03-JUL-2014
AAUDE_FACSAL_MASKED_DETAIL This table contains AAUDE Faculty Salary data for the current and previous academic years. Data for private institutions is masked. Fact AAUDE Faculty Salary by CIP 14-JUL-2009
AAUDE_FACSAL_MASKING_CODES If you are at a private institution, this table will show you your instititution's masking codes for the current and previous academic years. If you are at a public institution, this table will be empty. Dimension AAUDE Faculty Salary by CIP 20-JUL-2009
AAUDE_FACSAL_RANK Contains the various different academic ranks of faculty (e.g. Professor, Associate Professor, Assistant Professor). This is a dimension table for the AAUDE Faculty Salary fact table. Dimension AAUDE Faculty Salary by CIP 29-APR-2014
AAUDE_FACULTY_SALARY_DETAIL The fact table for AAUDE Faculty Salary Survey. This table contains data that allow comparisons of high, low, and average faculty salaries by academic rank and appointment length within CIP-defined academic departments or diciplines. Additionally, the total faculty and new hire faculty average salary, and average faculty age are reported for each academic and appointment. Fact AAUDE Faculty Salary by CIP 03-JUL-2014
AAUDE_PEER_INSTITUTION This table lists the peer institutions that AAUDE institutions have chosen. Dimension AAUDE Peer Institutions 29-MAY-2013
AAUP_FACBEN_RANK Contains the various different academic ranks of faculty (e.g. Professor, Associate Professor, Assistant Professor). This is a dimension table for the AAUP Faculty Benefit fact table. Dimension AAUP Faculty Salary Survey 29-APR-2014
AAUP_FACSAL_RANK Contains the various different academic ranks of faculty (e.g. Professor, Associate Professor, Assistant Professor). This is a dimension table for the AAUP Faculty Salary fact table. Dimension AAUP Faculty Salary Survey 29-APR-2014
AAUP_FACULTY_BENEFIT_DETAIL The fact table for the AAUP Faculty Fringe Benefit survey. Fact AAUP Faculty Salary Survey 17-JUN-2014
AAUP_FACULTY_SALARY_DETAIL The fact table for the AAUP Faculty Salary survey. Fact AAUP Faculty Salary Survey 17-JUN-2014
ACADEMIC_YEAR Contains information about academic years. Dimension AAUDE Common Data 18-OCT-2001
CIP Classification of Instructional Programs (CIP). The table contains all CIP codes used in AAUDE exchange items. Dimension AAUDE Common Data 10-SEP-2004
CIP_CROSS_FACULTY_SALARY CIP cross walk for faculty salary for different institutions in different academic years. Dimension CIP Cross Walk 18-JUL-2003
CIP_CROSS_IPEDS_COMPLETION CIP cross walk for IPEDS completion survey for different institutions in different academic years. Dimension CIP Cross Walk 18-JUL-2003
CIP_CROSS_WALK CIP cross walk data for different subjects (eg. Faculty Salary, IPEDS Completion Survey) and institutions. Dimension CIP Cross Walk 18-JUL-2003
CIP_GROUP A dimension table that can be used to report on groups of CIP codes. When joining this table to a fact table it is important to limit on a single CIP group; otherwise, your results will contain duplicate rows. Dimension AAUDE Common Data 05-FEB-2013
CIP_WITH_VERSION Contains the 1985, 1990,2000 and 2010 versions/editions of the Classification of Instruction Programs (CIP). Dimension AAUDE Common Data 09-JAN-2002
CUPA_ADMIN_SALARY_DETAIL The fact table for CUPA Administrative Compensation Survey. It contains records of AAUDE institutions in the CUPA Administrative Salary Survey. There is one record per institution in an academic year for each position of different demographic types (gender, minority status) and hiring status (whether it is an outside hire or an internal promotion). The following fields are included in each of the salary records: Academic Year, Institution, CUPA position number, Reporting Relationship, Vacancy Indicator, Years of Service in Present Position, Salary, and Number of Incumbents. Fact CUPA Administrative Compensation Survey 07-MAY-2014
CUPA_HIRING_DEMOGRAPHIC This is a dimension table for CUPA Administrative Compensation Survey. It contains all the possible values of the hiring status (e.g. "Internal Promotion", "Outside Hire", "None Entered") and demographic types (e.g. "Male", "Female" for gender; and the minority status) which describe the occupant of the position. Dimension CUPA Administrative Compensation Survey 07-MAY-2014
CUPA_INSTITUTION This is a dimension table for CUPA Administrative Compensation Survey. It contains some of the characteristics (e.g. Institutional Structure and Institutional Affiliation) of all of the AAUDE Institutions in the CUPA Administrative Salary Survey. There is one record per institution for an academic year. Dimension CUPA Administrative Compensation Survey 07-MAY-2014
CUPA_POSITION This is a dimension table for CUPA Administrative Compensation Survey. It contains a list of CUPA defined positions with the CUPA Position Number (e.g. 501.00, 501.10, 501.50) and the brief description of the position (e.g. "Chief Student Affairs Officer", "Associate Chief Student Affairs Officer", "Dean of Students"). Dimension CUPA Administrative Compensation Survey 25-JUN-2007
CUPA_REPORTING_RELATIONSHIP This is a dimension table for CUPA Administrative Compensation Survey. Like the CUPA POSITION table, it also contains a list of CUPA defined positions with the CUPA Position Number and the descriptions of the position. Join this table to the fact table, CUPA ADMIN SALARY DETAIL, to show the reporting relationship of the position. Dimension CUPA Administrative Compensation Survey 25-JUN-2007
DELW_CIP_4_DIGIT This is a dimension table for Delaware Survey. It contains all Four-Digit CIP codes and descriptions from CIP-1990 and CIP-2000. Dimension University of Delaware Survey 22-APR-2003
DELW_EXPENDITURE_DETAIL This is the fact table for the University of Delaware Survey for Expenditures. The records in this table are grouped by academic year, institution, and Four-Digit CIP code. Fields in each record include salary expenditure, benefits expenditure, non-personnel item expenditure, research expenditure, public service expenditure, as well as the number of different type of degrees offered by the CIP and the undergraduate and graduate student credit hours within the program. Fact University of Delaware Survey 22-AUG-2013
DELW_FACULTY_TYPE This is a dimension table for Delaware Survey. It contains the codes and definitions of the faculty type in which the records of the Delaware Survey are grouped. Dimension University of Delaware Survey 22-APR-2003
DELW_TEACHING_LOAD_DETAIL This is the fact table for the University of Delaware Survey for teaching load.Records with information about FTE faculty, undergraduate and graduate student credit hours, and number of lab, discussion, and recitation sections are grouped by academic year, institution, four-digit CIP code, and faculty type. Fact University of Delaware Survey 20-AUG-2013
DOCTORAL_COMPLETION_COHORT The is a dimension table for the Doctoral Completions star. It contains information on the entry year of the cohort and information on who is counted as part of an entering cohort. Dimension PHD Completions 02-JUL-2014
DOCTORAL_COMPLETION_DEPARTMENT The is a dimension table for the Doctoral Completions star. It contains information optionally provided by institutions to determine the focus of a particular program. Dimension PHD Completions 02-JUL-2014
DOCTORAL_COMPLETION_DETAIL This is the fact table for the Doctoral Completions star. It contains information on cohort entering and completion counts at the level of institution, cip, and year. Fact PHD Completions 02-JUL-2014
DOCTORAL_TTD_DEGREE XXX N/A PHD Time to Degree Unavailable
DOCTORAL_TTD_DETAIL XXX N/A PHD Time to Degree 21-MAY-2014
DOCTORAL_TTD_SCHOOL XXX N/A PHD Time to Degree Unavailable
ENROLL_CIP_DEPT_DIVISION This is a dimension table for the Enrollment Detail by CIP fact table that include descriptions of division/school and department names associated with programs and CIP codes. The information in this table is intended to provide contextual information about programs. Dimension Enrollment Detail by CIP and Race Ethnicity Unavailable
ENROLL_CIP_DETAIL This is the fact table for the Enrollment Detail by CIP exchange item. In this table, you can get primary and duplicated student enrollment counts for every unique combination of the IPEDS categorical fields by student level and academic department (using CIP codes). Reporting by gender was optional. Fact Enrollment Detail by CIP and Race Ethnicity Unavailable
ENROLL_CIP_STUDENT_INFO This is a dimension table for the Enrollment Detail by CIP fact table that include break-downs by student level. It contains all the possible values in the categories of overall student level (undergraduate or graduate), detailed student level (e.g., freshman, sophomore, junior, senior, masters, doctoral, etc.), degree-seeking, gender, and status (full-time vs. part-time). Dimension Enrollment Detail by CIP and Race Ethnicity Unavailable
ENROLL_RACE_ACAD_DIVISION This is a dimension table for the Enrollment Detail by Race/Ethnicity fact table that include descriptions of division/school names associated with student enrollment. The information in this table is intended to provide contextual information about programs. Dimension Enrollment Detail by CIP and Race Ethnicity Unavailable
ENROLL_RACE_DETAIL This is the fact table for the Enrollment Detail by Race/Ethnicity exchange item. Student enrollment counts for every unique combination of academic division, IPEDS race/ethnicity fields by student level, degree-seeking status, and full-time status. Reporting by gender was optional. Fact Enrollment Detail by CIP and Race Ethnicity Unavailable
ENROLL_RACE_ETHNICITY This is a dimension table for the Enrollment Detail by Race/Ethnicity fact table that include break-downs by student level and race/ethnicity. It contains all the possible values in the categories of overall student level (undergraduate or graduate), degree-seeking, gender, and status (full-time vs. part-time). Dimension Enrollment Detail by CIP and Race Ethnicity Unavailable
ENROLL_RACE_STUDENT_INFO This is a dimension table for the Enrollment Detail by Race/Ethnicity fact table that include break-downs by student level. It contains all the possible values in the categories of overall student level (undergraduate or graduate), degree-seeking, gender, and status (full-time vs. part-time). Dimension Enrollment Detail by CIP and Race Ethnicity Unavailable
EXCHANGE_ITEM This is a dimension table that contains the name and some characteristics of all the exchange items in the Data Warehouse Dimension AAUDE Exchange Item Footnote 30-MAR-2005
EXCHANGE_ITEM_FOOTNOTE_DETAIL This is a fact table that contains documentation and footnotes for a particular exchange item of an institution for a particular year. Fact AAUDE Exchange Item Footnote 25-APR-2014
FACULTY_DEMOGRAPHIC This is a dimension table for Faculty Profile by CIP. It contains the demographic (gender and race/ethnicity) information. Dimension Faculty Profile by CIP 22-APR-2003
FACULTY_PROFILE_DEPT This is a dimension table for Faculty Profile by CIP. It contains information about departments and schools of the institution. Dimension Faculty Profile by CIP 21-MAY-2014
FACULTY_PROFILE_DETAIL This is a fact table. This table contains of information about departmental faculty profiles, including full-time/part-time tenure/track and non-tenure-track populations, with gender and ethnic parameters. The records are grouped by academic year, institution, and CIP code. Fact Faculty Profile by CIP 21-MAY-2014
FACULTY_PROFILE_FTE_SOURCE This is a dimension table for the Faculty Profile by CIP star. It contains infomation about the source of funds or revenue source for FTE headcounts. Dimension Faculty Profile by CIP Unavailable
FACULTY_PROFILE_TYPE This is a dimension table for Faculty Profile by CIP. It contains information about profiles of faculty, including faculty rank, tenure, track attribute, full-time/part-time status, gender, race/ethnicity, medical/non-medical, and EAP category. Dimension Faculty Profile by CIP 22-APR-2003
FISCAL_YEAR Contains information about fiscal year, primarily used for the NSF Graduate Students Support exchange item. Dimension NSF Graduate Student Support 30-JAN-2002
FROSH_ACADEMIC_DETAIL This fact table contains the freshmen profile for academic and test data. There is one record for an institution in an academic year, where each record contains information such as the total number of students in the entering class, number and percentage of which reporting SAT scores, number and percentage of which reporting ACT scores, High School GPA, SAT Verbal and Math Percentile, and ACT Composite Percentile. Fact Freshman Profile 31-JAN-2014
FROSH_ACAD_RESIDENCY_DETAIL This fact table, similar to FROSH_ACADEMIC_DETAIL, contains the freshmen profile for academic and test data. In this table, the level of detail of the records are further grouped by residency status (ie. resident vs. non resident). There is one record per academic year, per institution, per residency status. Fact Freshman Profile 31-JAN-2014
FROSH_ENROLLEE_DETAIL This fact table contains the freshmen profile data for the number of enrollees by ethnicity, gender, and full-time vs. part-time status. For each academic year and institution, it contains the number of entering freshmen grouped by ethnicity (eg. White, African American, Asian, Hispanic, Nonresident Alien, Native American), Gender (Men, Women), and Status (Full-Time, Part-Time). Fact Freshman Profile 31-JAN-2014
FROSH_ENROLL_RESIDENCY_DETAIL This fact table, similar to FROSH_ENROLLEE_DETAIL, contains the freshmen profile data for number of enrollees by ethnicity, gender, and full-time/part-time status. The records in this table, however, are further grouped by residency status (ie. resident vs. non resident). There is one record per academic year per institution per category (ethnicity, gender, and status) and residency. Fact Freshman Profile 31-JAN-2014
FROSH_PROFILE This is a dimension table for Freshmen Profile for Number of Enrollees. It contains all the possible values for profile categories in ethnicity, gender, and full-time/part-time status. Dimension Freshman Profile 05-APR-2004
FROSH_PROFILE_RESIDENCY This is a dimension table for Freshmen Profile for Number of Enrollees by Residencty. It contains all the possible values in the categories of residency (resident vs. non resident), ethnicity, gender, and status (full-time vs. part-time). Dimension Freshman Profile 05-APR-2004
FROSH_YIELD_DETAIL This is a fact table contains the data for freshmen profile yield rates. There is one record for an insitution in an academic year. Each record contains yield rate information which includes the number of applications, number of admits, number of enrolled, application yield percent, and matriculation yield percent. Fact Freshman Profile 31-JAN-2014
FROSH_YIELD_RESIDENCY_DETAIL This is the version of the freshmen profile yield rate table with records grouped by residency status (ie. resident vs. non resident). There is one record per academic year per institutio per residency status. Fact Freshman Profile 31-JAN-2014
GRADSTIP_BENEFITS_2005_DETAIL This is a benefits fact table for Graduate Assistant Stipends where you can retrieve data for health insurance benefits (including the total annual premium and the university contribution to premium in percentage) provided for graduate assistants and their spouses, partners, and dependents. Data are grouped by academic year for each participating institution and the type of graduate assistant (Teaching Assistant, Reseach Assistant, and Other Graduate Assistant). ** This table contains Graduate Assistant Benefits records from academic year 2005 onwards. ** Fact Graduate Assistant Stipends 23-MAY-2014
GRADSTIP_BENEFITS_DETAIL This is a benefits fact table for Graduate Assistant Stipends where you can retrieve data for health insurance benefits (including the total annual premium and the university contribution to premium in percentage) provided for graduate assistants and their spouses, partners, and dependents. Data are grouped by academic year for each participating institution and the type of graduate assistant (Teaching Assistant, Reseach Assistant, and Other Graduate Assistant). ** This table contains Graduate Assistant Benefits records prior to academic year 2005. ** Fact Graduate Assistant Stipends 05-SEP-2005
GRADSTIP_BY_CIP_DETAIL This is a salary by CIP code and CIP Type ("payroll_dept" or "program_study") fact table for Graduate Assistant Stipends Fact Graduate Assistant Stipends 23-MAY-2014
GRADSTIP_CASH_SALARY_DETAIL This is a cash salary fact table for Graduate Assistant Stipends. In this table, you can find the minimum, maximum, average, and mode cash salary of specific academic year for each participating institution, grouped by the different types of graduate assistants (ie. Teaching Assistant, Research Assistant, and Other Graduate Assistant). Also included in this table are the graduate appointment information such as the number of FTE and Headcount for each type of graduate assistant; as well as the minimum and maximum course load in academic credits permitted per term for a graduate assistant. Fact Graduate Assistant Stipends 23-MAY-2014
GRADSTIP_CIP_TYPE This is a dimension table for Graduate Assistant Stipends - Salary by CIP. Dimension Graduate Assistant Stipends 23-MAY-2014
GRADSTIP_INSTITUTION This is a dimension table for the stars of Graduate Assistant Stipends. The table consists of institution characteristics by academic year. Other than the institution code and name, the table also contains information regarding graduate assistant stipend general policies such as whether all graduate assistants are subject to the same university-wide stipend scale, if stipends are determined invidually by the school or department, and if there is a university policy regarding increases in graduate assistant stipends for the 2nd year of service. Dimension Graduate Assistant Stipends 20-MAY-2014
GRADSTIP_STUDENT_PROFILE This is a dimension table for the Graduate Assistant Stipends star of Tuition and Fees Detail. The graduate student profile includes information such as the type of graduate student (Teaching Assistant, Research Assistant, etc.), the resident status (resident or non-resident) of the graduate student and the credit hours per semester the students enrol in. Dimension Graduate Assistant Stipends 10-JUN-2003
GRADSTIP_STUDENT_TYPE This is a dimension table for the Graduate Assistant Stipends star of Cash Salary Detail. It contains all the possible values of the different types of graduate assistants. Dimension Graduate Assistant Stipends 10-JUN-2003
GRADSTIP_TUITION_FEES_DETAIL This is a tuition and fees fact table for Graduate Assistant Stipends where you can retreive data for the Average Graduate Assistant Compensation and Cost to Institution for each participating institution. Data are grouped by academic year, type of graduate assistant (Teaching Assistant, Research Assistant, and Other Graduate Assistant), as well as the resident status and the credit hours per semester of the graduate assistant. Fact Graduate Assistant Stipends 23-MAY-2014
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 AAUDE Common Data 14-JUL-2009
INSTITUTION_MASKED A view of the Institution table for use specifically with the AAUDE_FACSAL_MASKED_DETAIL table. Dimension AAUDE Faculty Salary by CIP 14-JUL-2009
IPEDS_AWARD_LEVEL Contains defnitions of all the award/degree levels used in IPEDS. This is a dimension table for the IPEDS Completion Survey fact table. Dimension IPEDS Completion Survey 24-OCT-2001
IPEDS_COMPLETION_DETAIL This is the IPEDS Completion Survey fact table. It contains the USDE National Center for Educational Statistics annual survey of recognized completions in postsecondary education programs. This table consists of the completions by award level conferred by sex and ethnicity with program (CIP). Fact IPEDS Completion Survey 07-MAY-2014
IPEDS_DEMOGRAPHIC Contains the demographic (gender and ethinicty) information as used in IPEDS. This is a dimension table for IPEDS Completion Survey and IPEDS Fall Enrollment. Dimension IPEDS Completion Survey 24-OCT-2001
IPEDS_EMPLOYEE_POSITION This is a deminsion table for IPEDS Employee by Assigned Positions. The table contains the characteristics of a position, such as: the description of the position (Full time non-medical, Full time medical only, etc.), primary function of the position (eg. Executive/Secretarial, Primarily Research, Technical/Paraprofessional, etc.) and the tenure status of the position. Dimension IPEDS Employee by Assigned Position 28-NOV-2011
IPEDS_EMPLOYEE_POS_DETAIL IPEDS Employee by Assigned Position. This is a fact table which contains the number of employees by assigned position, primary function, and tenure status for each participating institution in an academic year. Fact IPEDS Employee by Assigned Position 28-NOV-2011
IPEDS_ENRL_DISCP_STATUS This is a dimension table for IPEDS Fall Enrollment by Discipline (CIP). It contains the enrollment status information which include the selected CIP and discipline (e.g. Education, Engineering, Law), level of study (Undergraduate, Graduate, First Professional), attendance status (Full Time, Part Time), and Type of Student (First-time Freshmen, Graduate, First Professional, etc.) Dimension IPEDS Fall Enrollment 19-MAY-2003
IPEDS_ENRL_TOTAL_STATUS This is a dimension table for the Summary of IPEDS Fall Enrollment. It contains all the possible values for the level of study (Undergraduate, Graduate, First Professional), attendance status (Full-Time, Part-Time), Type of Student (First-time Freshmen, Graduate, First Professional, etc.). Dimension IPEDS Fall Enrollment 19-MAY-2003
IPEDS_ENROLMENT_DISCP_DETAIL This is a fact table for IPEDS Fall Enrollment by Discipline (CIP). It contains the total number of students, grouped by gender and ethnicity, enrolled in an institution for a specified academic year by student level and attendance status (full time or part time) in various selected disciplines (or CIP codes). The disciplines include: Education, Engineering, Dentistry, Medicine, Law, Biological Sciences/Life Sciences, Mathematics, Physical Sciences, and Business Management. Fact IPEDS Fall Enrollment 22-MAR-2007
IPEDS_ENROLMENT_TOTAL_DETAIL This is a fact table for the Summary of IPEDS Fall Enrollment. It contains the total number of students separated by gender and ethnicity enrolled in an institution for a specified academic year by student level and attendance status (full time or part time). Fact IPEDS Fall Enrollment 22-MAR-2007
IPEDS_FINANCE_DETAIL This is a fact table for IPEDS Finance Survey - the USDE National Center for Educational Statistics annual survey of the financial condition of postsecondary education in the nation. The table consists of the following parts of the survey: 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 G (Indebtedness of Physical Plant), Part H (Details of Endowment Assets, and part K (Physical Plant Assets). Data in the table range from fiscal year 1989 through 2000. Fact IPEDS Finance Survey 25-APR-2003
IPEDS_FINANCE_FASB_DETAIL Detail table for IPEDS Finance item. Contains finance information reported using the FASB accounting standard. This standard is typically used by private institutions. Use this table in conjunction with the IPEDS_FINANCE_FIELD table. Fact IPEDS Finance Survey 10-APR-2014
IPEDS_FINANCE_FIELD Description of the measure and where to find it in the IPEDS Finance Survey. Contains information on the location (Part Code), line number, and column number of data elements in the survey Dimension IPEDS Finance Survey 10-APR-2014
IPEDS_FINANCE_GASB3435_DETAIL Detail table for IPEDS Finance item. Contains finance information reported using the GASB 34 and 35 accounting standard. This standard is typically used by public institutions. Use this table in conjunction with the IPEDS_FINANCE_FIELD table. Fact IPEDS Finance Survey 10-APR-2014
IPEDS_FINANCE_GASB_DETAIL Detail table for IPEDS Finance item. Contains finance information reported using the GASB accounting standard. This standard is typically used by public institutions. Use this table in conjunction with the IPEDS_FINANCE_FIELD table. Fact IPEDS Finance Survey 10-APR-2014
IPEDS_FINANCE_TYPE This is a dimension table for IPEDS Survey. It contains information about the parts (part code and description) of the survey, the line numbers and their descriptions, and the various types of amount (e.g. Restricted Amount, Unrestricted Amount, Beginning Balance, Sum Amount, etc.). Dimension IPEDS Finance Survey 10-JAN-2003
IPEDS_GENDER Gender: Men or Women Dimension IPEDS Fall Staff Survey 25-MAR-2002
IPEDS_IC_ACCREDITATION IPEDS institution characteristics on accrediation. This table contains information about the accrediting agencies of each of the institution for a survey year. Fact IPEDS Institution Characteristics 21-NOV-2003
IPEDS_IC_ADMISSIONS_CONSIDER IPEDS institution characteristics on admissions consideration for undergraduate selection. This table contains information regarding each institution's undergraduate admissions policies and selection process for a survey year. Fact IPEDS Institution Characteristics 21-NOV-2003
IPEDS_IC_AWARD_LEVEL IPEDS institution characteristics on award levels. This table contains information about the types and levels of certificates/awards/degrees offered by the institution for a survey year. Fact IPEDS Institution Characteristics 21-NOV-2003
IPEDS_IC_CALENDAR_APP_FEE IPEDS institution characteristics on academic calendar, application fees, and levels of enrollment. The information for each institution is organized by survey year. Fact IPEDS Institution Characteristics 21-NOV-2003
IPEDS_IC_CONFERENCE_ASSOC IPEDS institution characteristics on conference associations. For a survey year, the table lists each institution's sports conference (eg. NCAA, NSCAA, NAIA) associations. Fact IPEDS Institution Characteristics 21-NOV-2003
IPEDS_IC_DIRECTORY_INFO IPEDS institution directory information. For each institution in a given survey year, the record contains information such as institution name, address, chief administrator, key contact telephone numbers, and other identifying attributes and classifications. Fact IPEDS Institution Characteristics 21-NOV-2003
IPEDS_IC_EDUCATIONAL_OFFERING IPEDS intitution characteristics on types of educational offering. This table contains information about the different types of educational offerings, which include academic, continuing professional, occupational, recreational, remedial, and secondary (high school)programs offered by each institution for a survey year. Fact IPEDS Institution Characteristics 21-NOV-2003
IPEDS_IC_INST_AFFILIATION IPEDS institution characteristics on the institution's affiliation or operating control. Fact IPEDS Institution Characteristics 21-NOV-2003
IPEDS_IC_NONTRADITIONAL_CREDIT IPEDS institution characteristics on acceptance of non-traditional credits earned prior to admissions. Information for each institution is organized by survey year. Fact IPEDS Institution Characteristics 21-NOV-2003
IPEDS_IC_SAT_ACT_SCORE IPEDS institution characteristics on SAT and ACT scores. Each institution in a given survey year consists of a record that shows the number of submitting SAT and ACT scores, and the scores in the 25th and 75th percentile for SAT Verbal, SAT Math, ACT Composite, ACT English, and ACT Math. These represent scores for the SAT and ACT tests taken by first-time first year award seeking undergraduate students of the institution. Fact IPEDS Institution Characteristics 21-NOV-2003
IPEDS_IC_SPECIAL_LEARNING IPEDS institution characteristics on special learning opportunities and student services. This table lists the different types of special learning opportunities and student services programs offered by each institution for a given survey year. Fact IPEDS Institution Characteristics 21-NOV-2003
IPEDS_MAJOR Contains codes and values for IPEDS major designations. This is a dimension table for the IPEDS Completion fact table. Dimension IPEDS Completion Survey 11-MAY-2009
IPEDS_STAFF_BY_EMPTYPE_DETAIL This is the fact table for IPEDS Fall Staff Survey by Employee Types. Count of employees are grouped by gender, employee status (Full Time or Part Time), employee type (Faculty, Managerial, Clerical, Skilld Craft, etc.) and contract types (9/10 months, 11/12 months, Less than 9/10 months) for full time faculty. Percentages for each employee type as percentage of all employees are also included. Fact IPEDS Fall Staff Survey 10-MAY-2012
IPEDS_STAFF_EMPLOYEE_TYPE This is a dimension table for IPEDS Fall Staff Survey by Employee Types. This table contains information for employee status, employee type, and contract type. Dimension IPEDS Fall Staff Survey 27-MAR-2002
IPEDS_STAFF_SALARY_RANGE This is a dimension table for IPEDS Fall Staff Survey with Salary Range. It contains the definitions of various ranges of salary in different academic years, eg. "Below $25,000", "$25,000 - $29,999", "$30,000 and above". Dimension IPEDS Fall Staff Survey 10-MAY-2012
IPEDS_STAFF_SAL_RANGE_DETAIL This is a fact table for IPEDS Fall Staff Survey of count and percentage of employees for different institutions in different academic years, by employee status (Full Time or Part Time), type of work they perform and gender with Salary Range. Fact IPEDS Fall Staff Survey 10-MAY-2012
NSF_CIP_CROSS_WALK Mapping of NSF codes and CIP codes. Dimension NSF Graduate Student Support 23-JUL-2007
NSF_DISCIPLINE This is a dimension table. It contains all the NSF defined disciplines, including Computer Science, Biological Sciences, Engineering, Economics, etc. This table may be joined to the NSF Cross Walk table for NSF and CIP mapping information. Dimension NSF Graduate Student Support 18-MAR-2002
NSF_FEDSUP_AGENCY_GRP This is a dimension table used in the NSF Federal Support Survey data model. Federal Support survey data is aggregated into major agency groups. This table contains the abbreviated codes and names of the agency groups. Dimension NSF Federal Support Survey 01-DEC-2005
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. Fact NSF Federal Support Survey 26-MAR-2008
NSF_GSS_BY_DEGREE_TOTAL NSF Graduate Student Support. This is a fact table for the aggregation for post doctorate students (both Post Doc and Non-Faculty Research Staff) by degree type. It contains a record for a count of Post Doc or Non-Faculty Research Staff, by degree type (PhD or PhD Med), for each school in an institution for a fiscal year. The count in each record represents the "TOTAL", not a break-down by funding source. Fact NSF Graduate Student Support 28-FEB-2012
NSF_GSS_BY_GENDER_TOTAL NSF Graduate Student Support. This is a fact table for the aggregation for post doctorate students (both Post Doc and Non-Faculty Research Staff) by gender. It contains a record for a count of Post Doc or Non-Faculty Research Staff by gender for each school in an institution for a fiscal year. The count in each record represents the "TOTAL", not a break-down by funding source. Fact NSF Graduate Student Support 14-MAY-2014
NSF_GSS_DEGREE "PhD" or "PhD and Medical" Dimension NSF Graduate Student Support 08-FEB-2002
NSF_GSS_DEMOGRAPHIC This is a dimension table used in various NSF Graduate Student Support stars. It contains the gender and ethnicity information Dimension NSF Graduate Student Support 04-FEB-2002
NSF_GSS_ENRL_GENDER_DETAIL This is a fact table of NSF Graduate Student Support Total Enrollment by Gender. There is a record per fiscal year, school (Graduate School, School of Medicine), institution, enrollment status (Part-Time, Full-Time), and gender. Fact NSF Graduate Student Support 14-MAY-2014
NSF_GSS_ENROLLMENT_DETAIL This is a fact table for the NSF Graduate Student Support Total Enrollment by Ethnicity and Gender Star. There is one record (ie. a student count) per fiscal year, school, institution, enrollment status (full time or part time), gender and ethnicity. Fact NSF Graduate Student Support 14-MAY-2014
NSF_GSS_ENROLL_STATUS This is a dimension table used in various NSF Graduate Student Support stars. It contains the enrollment status information, including whether the student count were reported as First Time only. Dimension NSF Graduate Student Support 31-JAN-2002
NSF_GSS_FOREIGN_TYPE "Foreign" or "Non foreign" Dimension NSF Graduate Student Support 06-FEB-2002
NSF_GSS_FUNDING_SOURCE Funding Source -- such as Fellowships, Traineeships, Non federal, Research grants. Dimension NSF Graduate Student Support 06-FEB-2002
NSF_GSS_GENDER This is a dimension table used in various NSF Graduate Student Support table groups. It contains the gender codes: Men, Women Dimension NSF Graduate Student Support 05-FEB-2002
NSF_GSS_SCHOOL This is a dimension table used in the various NSF Graduate Student Support stars. It lists the schools within the institution, eg. Graduate School, School of Medicine. Dimension NSF Graduate Student Support 28-SEP-2002
NSF_GSS_SUPPORT_APPT_TYPE This is a dimension table used in the NSF GSS Support Sources data models. It contains information regarding the appointment type: Graduate fellowships, traineeships, graduate research assistantships, teaching assistantships, and other types of support. Dimension NSF Graduate Student Support 03-NOV-2005
NSF_GSS_SUPPORT_SOURCE This is a dimension table used in the NSF GSS Support Sources data model. It contains information about the sources of support. Examples of Federal funding sources are: DOD, NIH, NSF, NASA, DOE; and examples of Non-Federal funding sources are: INST, FOREIGN, SELF, and OTHER_US. Dimension NSF Graduate Student Support 03-NOV-2005
NSF_GSS_SUPPORT_SOURCE_DETAIL NSF Graduate Student Support. This is a fact table that contains the count of full time graduate students by their appointment type (graduate fellowships, graduate teaching assistantships, etc.) and funding source (DOD, NIH, DOE, etc.) in different NSF disciplines (Computer Science, Biological Sciences, Engineering, etc.). Fact NSF Graduate Student Support 14-MAY-2014
NSF_GSS_SUPPORT_WOMEN_DETAIL NSF Graduate Student Support. This is a fact table that contains the count of full time *WOMEN* graduate students by funding source (DOD, NIH, DOE, etc.) in various different NSF disciplines (Computer Science, Engineering, Biological Sciences, etc.). There is no break-down by appointment type (ie. Graduate fellowships, Graduate teaching assistantships, etc.) in this table. Fact NSF Graduate Student Support 28-FEB-2012
NSF_HERD_BASIC_APPLIED_DETAIL XXX Fact NSF R+D Expenditures Unavailable
NSF_HERD_CAPITALIZATION XXX Dimension NSF R+D Expenditures 14-OCT-2005
NSF_HERD_CAP_THRESHOLD_DETAIL XXX Fact NSF R+D Expenditures Unavailable
NSF_HERD_COST_TYPE XXX Dimension NSF R+D Expenditures 14-OCT-2005
NSF_HERD_COST_TYPE_DETAIL XXX Fact NSF R+D Expenditures Unavailable
NSF_HERD_MEDICAL_TYPE XXX Dimension NSF R+D Expenditures 14-OCT-2005
NSF_HERD_NONFEDERAL_DETAIL XXX Fact NSF R+D Expenditures Unavailable
NSF_HERD_PASS_THROUGH_TYPE XXX Dimension NSF R+D Expenditures 14-OCT-2005
NSF_HERD_RESEARCH_TYPE XXX Dimension NSF R+D Expenditures 14-OCT-2005
NSF_HERD_SELECT_EXP_DETAIL XXX Dimension NSF R+D Expenditures Unavailable
NSF_HERD_SELECT_EXP_TYPE XXX Dimension NSF R+D Expenditures 14-OCT-2005
NSF_HERD_STAFFING_DETAIL XXX Fact NSF R+D Expenditures Unavailable
NSF_HERD_STAFF_TYPE XXX Dimension NSF R+D Expenditures 14-OCT-2005
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 NSF R+D Expenditures 26-MAR-2008
NSF_POSTDOC_BY_DEGREE_DETAIL NSF Graduate Student Support. This is a fact table which contains a count of Post Doctorate students on funding source (ie. fellowship, traineeship, research grant), by degree type (PhD or PhD Med), for each school and institution in a fiscal year. Fact NSF Graduate Student Support 28-FEB-2012
NSF_POSTDOC_BY_DEG_FORGN_TOTAL NSF Graduate Student Support. This is a fact table for the total count of foreign vs. non-foreign Post Doctorate students by degree type (PhD or PhD Med), for each school and institution in a fiscal year. There is no break-down by funding source in this table. It also does not include Non-Faculty research staff. Fact NSF Graduate Student Support 28-FEB-2012
NSF_POSTDOC_BY_GENDER_DETAIL NSF Graduate Student Support. This is a fact table which contains the count of Post Doctorate students on funding source (ie. fellowship, traineeship, research grant), by gender, for each school and institution in a fiscal year. Fact NSF Graduate Student Support 14-MAY-2014
NSF_POSTDOC_BY_GEN_FORGN_TOTAL NSF Graduate Student Support. This is a fact table for the total count of foreign vs. non-foreign Post Doctorate students by gender for each school and institution in a fiscal year. There is no break-down by funding source in this table. It also does not include Non-Faculty research staff. Fact NSF Graduate Student Support 14-MAY-2014
NSF_RDEXP_BY_SOURCE_DETAIL NSF R&D Expenditures, Item 1, Expenditures by Source of Funds -- This is a fact table for NSF R+D current fund expenditures (total amount, with dollars in thousands) for separately budgeted research and development in the sciences and engineering by source of funds (e.g federal government, state and local governments, institution funds, etc.) Fact NSF R+D Expenditures 10-JUL-2014
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 NSF R+D Expenditures 10-JUL-2014
NSF_RDEXP_EQUIPMENT_DETAIL NSF R&D Expenditures, Item 3, Equipment Expenditures -- This is the fact table for NSF R+D Equipment Expenditures. It contains records for current fund expenditures of scientific research equipment by field of science and engineering. The equipment expenditures represent the subtotal of the amounts reported in the corresponding cells of the "NSF R+D Current Fund Expenditures by Field of Science and Engineering". Fact NSF R+D Expenditures 10-JUL-2014
NSF_RDEXP_FEDERAL_SPONSOR This dimension table contains the abbreviation and the name of the federal agencies. It is a dimension table used in the data model of NSF R&D Current Fund Expenditures - Federally Financed Expenditures. Dimension NSF R+D Expenditures 14-OCT-2005
NSF_RDEXP_FED_FINANCED_DETAIL NSF Survey of R&D Expenditures -- Item 2B: Federally financed R&D expenditures for each field of Science & Engineering in Item 2 (Current Fund Expenditures). Fact NSF R+D Expenditures 10-JUL-2014
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 NSF R+D Expenditures 14-OCT-2005
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 NSF R+D Expenditures 19-MAR-2002
NSF_RDEXP_FUND_SOURCE This is a dimension table for the star of NSF R&D Expenditures by Source of Funds. It contains all the source of funds, including federal, state, and local governments and institution funds. Dimension NSF R+D Expenditures 19-MAR-2002
NSF_RDEXP_MEDICAL_DETAIL XXX N/A NSF R+D Expenditures Unavailable
NSF_RDEXP_PASSED_THRU_DETAIL NSF R&D Expenditures, Item 1a, "Passed Through Funds" -- This is a fact table for NSF R&D current fund expenditures (Total and Federally Financed) for Separately Budgeted Research and Development in the Sciences and Engineering passed through the Institution to subrecipients. The Amount field consists of dollars in thousands. Fact NSF R+D Expenditures 18-MAY-2011
NSF_RDEXP_SUBRECIPIENT_DETAIL NSF R&D Expenditures, Item 1b, Funds Received as a Subrecipient -- This is a fact table for NSF R&D Current Fund Expenditures (Total and Federally Financed) for Separately Budgeted Research and Development in the Sciences and Engineering Received as a Subrecipient. Amount in the records represents dollars in thousands. Fact NSF R+D Expenditures 18-MAY-2011
NSF_RDEXP_SUBRECIPIENT_TOTAL NSF R&D Expenditures, Item 1b, Funds Received as a Subrecipient; TOTAL (sum of lines 1610 and 1620) only. This is a fact table for NSF R+D current fund expenditures (total amount, with dollars in thousands) for separately budgeted research and development in the sciences and engineering received as a subrecipient. Fact NSF R+D Expenditures 18-MAY-2011
NSF_RDEXP_SUBRECPNT_TYPE This is a dimension table for the stars of NSF R&D Passed Through Funds and NSF R&D Funds Received as a Subrecipient. It includes the subrecipient and finance type information. Dimension NSF R+D Expenditures 05-OCT-2005
RETENTION_CLASS_DEMOGRAPHIC This is the dimension table for the Tracking of Graduation/Retention by Demographic Star. The table consists of the entering class information for each institution, including: entering year, class size, and mean test scores. There is one record per institution per entering class. Dimension Retention/Graduation Survey 22-APR-2014
RETENTION_CLASS_ETHNICITY This is the dimension table for the Tracking of Graduation/Retention by Ethnicity Star. The table consists of the entering class information for each institution, including: entering year, class size, and mean test scores. There is one record per institution per entering class. Dimension Retention/Graduation Survey 22-APR-2014
RETENTION_CLASS_GENDER This is the dimension table for the Tracking of Graduation/Retention by Gender Star. The table consists of the entering class information for each institution, including: entering year, class size, and mean test scores. There is one record per institution per entering class. Dimension Retention/Graduation Survey 22-APR-2014
RETENTION_CLASS_RESIDENT This is the dimension table for the Tracking of Graduation/Retention by Resident Star. The table consists of the entering class information for each institution, including: entering year, class size, and mean test scores. There is one record per institution per entering class. Dimension Retention/Graduation Survey 22-APR-2014
RETENTION_CLASS_TOTAL This is the dimension table for the Summary of Graduation/Retention Tracking star. The table consists of the entering class information for each institution, including: entering year, class size, and mean test scores. There is one record per institution per entering class. Dimension Retention/Graduation Survey 22-APR-2014
RETENTION_DEMOGRAPHIC_DETAIL This is the fact table for Tracking of Graduation/Retention by demographic (ie. gender and ethnicity). It consists of detail tracking of each retention type. There is one record per institution per entering year per retention type. Fact Retention/Graduation Survey 22-APR-2014
RETENTION_ETHNICITY_DETAIL This is the fact table for Tracking of Graduation/Retention by ethnicity. It consists of detail tracking of each retention type. There is one record per institution per entering year per retention type. Fact Retention/Graduation Survey 22-APR-2014
RETENTION_GENDER_DETAIL The fact table for Tracking of Graduation/Retention by gender (men vs. women). This table consists of detail tracking of each retention type. There is one record per institution per entering year per retention type. Fact Retention/Graduation Survey 22-APR-2014
RETENTION_RESIDENT_DETAIL The fact table for Tracking of Graduation/Retention by Resident Status (in-state vs. out-of-state). This table consists of detail tracking of each retention type (ie. returned/continued/graduated for a specific beginning of year). There is one record per institution per entering year per retentition type. Fact Retention/Graduation Survey 22-APR-2014
RETENTION_TOTAL_DETAIL The fact table for Summary of Graduation/Retention Tracking. This table consists of detail tracking (including student count and percentage of entering freshman class) of each retention type. There is one record per institution per entering year per retention type. Fact Retention/Graduation Survey 22-APR-2014
RETENTION_TYPE This is a dimension table for the Graduation/Retention Tracking stars. It consists of all the possible retention types (eg. Returned, Continued, Graduated) for the specific school year (ie. beginning of 2nd year, beginning of 3rd year, etc.). Dimension Retention/Graduation Survey 22-JAN-2002
RUNZHEIMER_COST_OF_LIVING Composite table containing Runzheimer Cost of Living adjustment data. This table can be used as a dimension with other warehouse stars, or can be reported on directly. Dimension Runzheimer Cost of Living 18-OCT-2013
RUNZHEIMER_DETAIL Fact table contianing Runzheimer Cost of Living adjustment data for all AAUDE institutions, starting with Academic year 2004-2005. Fact Runzheimer Cost of Living 18-OCT-2013
RUNZHEIMER_LOCATION Dimension table containing information about the locations and living communities associated with Runzheimer cost of living data Fact Runzheimer Cost of Living Unavailable
SED_DETAIL Survey of Earned Doctorates. The table contains data on all earned doctorates granted by regionally accredited U.S. universities, in all fields, from 1920 to the present. Doctorates are defined as Ph.D., Sc.D., Ed.D., Doctor of Arts, etc.; professional doctorates such as M.S., D.D.s., and D.V.M. are not included. The information about each doctorate recipient is contained in one record, to which is assigned a unique and permanent identification number (ID NUMBER). Since 1958, the "survey of Earned Doctorates" questionnaire has been distributed with the cooperation of the Graduate Deans and filled out by the graduates at the time they complete all requirements for the doctoral degree. Blanks in a variable mean that the recipient did not supply the information. Fact Survey of Earned Doctorates 20-JUL-2004
TUITION_FEE_BY_FIELD_DETAIL Fact table associated with the tuition and fee fields that provide information about tuition and required fees typically included in comments. The values represent flags ("1" = yes, "2" = no) regarding the existence of such things as tuition plateau, fixed rate tuition, or tuition that varies by the college/school of a student's major, the department offering a course, or the level of a student (first-year, sophomore, junior, senior). N/A Tuition and Required Fees 16-JUL-2014
TUITION_FEE_BY_TYPE_DETAIL This is a fact table for "Tuition and Required Fees." There is one record for per institution, acacdemic year, program, residency status, and tuition/fee type. Fact Tuition and Required Fees 16-JUL-2014
TUITION_FEE_DETAIL This is the fact table for "Tuition and Required Fees". There is one record for a program (Graduate, Undergraduate, Business, Law, Medicine, etc.) for a resident/non-resident student of an institution in an academic year. Fact Tuition and Required Fees 02-JAN-2007
TUITION_FEE_FIELD This table contains descriptive titles and informative descriptions about the additional information that has been typically included in Tuition and Required Fees comment fields. N/A Tuition and Required Fees Unavailable
TUITION_FEE_PROGRAM This is a dimension table for "Tuition and Required Fees". It contains information about the academic programs (ie. Undergraduate, Graduate, Business, Law, Dentistry, Medicine, etc.) for which the tuition and fee data are collected. There is also a RESIDENT STATUS field in this table. Dimension Tuition and Required Fees 04-JUN-2003
TUITION_FEE_TYPE This is a dimension table for Tuition and Required Fees. It contains information about tuition/fee types. Dimension Tuition and Required Fees 22-OCT-2008
UGRAD_TTD_DETAIL Detail table for the AAUDE Undergraduate Time to Degree Exchange Item Fact Undergraduate Time to Degree 18-JUL-2014
UGRAD_TTD_INSTITUTION This is a dimension table containing information about institutions participating in the Undergraduate Time to Degree exchange item Dimension Undergraduate Time to Degree Unavailable
UGRAD_TTD_MAJOR This is a dimension table containing information about majors used in the Undergraduate Time to Degree exchange Item Dimension Undergraduate Time to Degree Unavailable
UGRAD_TTD_OVERALL_DETAIL Overall undergraduate time to degree calculated using one row per graduate Fact Undergraduate Time to Degree 03-JUL-2014

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