|
|
|
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 | Unavailable |
| 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 | Unavailable |
| 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 | 04-SEP-2009 |
| 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 | 19-OCT-2001 |
| 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 | 04-SEP-2009 |
| AAUDE_PEER_INSTITUTION | This table lists the peer institutions that AAUDE institutions have chosen. | Dimension | AAUDE Peer Institutions | 24-APR-2009 |
| 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 | 19-OCT-2001 |
| 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 | 19-OCT-2001 |
| AAUP_FACULTY_BENEFIT_DETAIL | The fact table for the AAUP Faculty Fringe Benefit survey. | Fact | AAUP Faculty Salary Survey | 18-SEP-2009 |
| AAUP_FACULTY_SALARY_DETAIL | The fact table for the AAUP Faculty Salary survey. | Fact | AAUP Faculty Salary Survey | 18-SEP-2009 |
| ACADEMIC_YEAR | Contains information about academic years. | Dimension | AAUDE Common Data | 18-OCT-2001 |
| CIP | Classification of Instructional Programs (CIP). The table contains all of the CIP codes published in CIP-1990 and CIP-2000. | 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_WITH_VERSION | Contains the 1990 and 2000 versions/editions of the Classification of Instruction Programs (CIP) - data downloaded from the National Center for Education Statistics (NCES) | 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 | 22-JUN-2009 |
| 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 | 12-MAY-2006 |
| 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 | 22-JUN-2009 |
| 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 | 24-JUL-2009 |
| 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 | 24-JUL-2009 |
| 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 | 08-SEP-2009 |
| FACULTY_AWARD | This is a dimension table that contains the awards and some of their characteristics that a faculty member in an institution recieved. | Dimension | Faculty Awards | 04-APR-2005 |
| FACULTY_AWARD_DETAIL | This fact table contains the number of awards received by faculty members in an institution. | Fact | Faculty Awards | 04-APR-2005 |
| FACULTY_AWARD_YEAR | This is a dimension table that contains the award year information to be used in the Faculty Awards data model. | Dimension | Faculty Awards | 04-APR-2005 |
| 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 | 08-SEP-2009 |
| 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 | 08-SEP-2009 |
| 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 | Freshmen Profile | 19-FEB-2009 |
| 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 | Freshmen Profile | 19-FEB-2009 |
| 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 | Freshmen Profile | 19-FEB-2009 |
| 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 | Freshmen Profile | 19-FEB-2009 |
| 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 | Freshmen 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 | Freshmen 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 | Freshmen Profile | 19-FEB-2009 |
| 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 | Freshmen Profile | 19-FEB-2009 |
| 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-SEP-2009 |
| 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-SEP-2009 |
| 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-SEP-2009 |
| GRADSTIP_CIP_TYPE | This is a dimension table for Graduate Assistant Stipends - Salary by CIP. | Dimension | Graduate Assistant Stipends | 23-SEP-2009 |
| 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 | 23-SEP-2009 |
| 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-SEP-2009 |
| 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 | 15-MAY-2009 |
| 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 | 08-SEP-2009 |
| 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 | 08-SEP-2009 |
| 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_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 | 30-MAR-2009 |
| 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-MAR-2006 |
| 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 | 30-MAR-2009 |
| 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 | 09-DEC-2008 |
| 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 | 09-DEC-2008 |
| 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 | 08-DEC-2008 |
| 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 | 08-DEC-2008 |
| 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 | 05-DEC-2008 |
| 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 | 09-DEC-2008 |
| 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 | 09-DEC-2008 |
| 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 | 09-DEC-2008 |
| 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 | 09-DEC-2008 |
| 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 | 09-DEC-2008 |
| 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 | 30-APR-2009 |
| 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 | 30-APR-2009 |
| 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 | 30-APR-2009 |
| 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 | 30-APR-2009 |
| NSF_RDEXP_FIELD | This is a dimension table for the stars of NSF R&D Current Fund Expenditures and NSF R&D Equipment Expenditures. It contains all the fields of science and engineering as well as non-science and engineering as defined in the survey. Examples are: chemical engineering, civil engineering, chemistry, physics, mathematical sciences, computer science, social sciences and life sciences. For non-science and engineering fields, examples are: education, law, humanities, visual & performing arts, business & management, social work, and communications, journalism, & library science. The field "NSF_MAJOR_CATEGORY" may be used to distinguish the "Science and Engineering" fields from the "Non-Science and Engineering fields. | Dimension | 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_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 | 30-APR-2009 |
| 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 | 30-APR-2009 |
| 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 | 30-APR-2009 |
| 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 | 31-JUL-2009 |
| 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 | 31-JUL-2009 |
| 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 | 31-JUL-2009 |
| 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 | 31-JUL-2009 |
| 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 | 31-JUL-2009 |
| 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 | 31-JUL-2009 |
| 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 | 31-JUL-2009 |
| 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 | 31-JUL-2009 |
| 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 | 31-JUL-2009 |
| 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 | 31-JUL-2009 |
| 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 | Unavailable |
| 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 | Unavailable |
| 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_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 | 28-OCT-2008 |
| 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_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 | 21-AUG-2009 |
| 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 |
e-mail aaude-warehouse@mit.edu | Warehouse home | AAUDE home