AAUDE banner Data Warehouse logo

Faculty Profile by CIP

The data provide information about departmental faculty profiles, including both tenure/track and non-tenure-track populations, with gender and racial/ethnic parameters. The information is collected by CIP code. For a given academic year and an institution, there is a record for each CIP code, Faculty Rank Code, Tenure Code, Track Attribute, Full-Time/Part-Time code, Gender Code, Race/Ethnicity Code, Medical Code, and EAP Category.

This page lists all the tables for the Faculty Profile by CIP Star/Table Group.
Clicking on a table name will display the fields found in that table.


Table Name Description Type Last Load Date
CIP Classification of Instructional Programs (CIP). The table contains all of the CIP codes published in CIP-1990 and CIP-2000. Dimension 10-SEP-2004
ACADEMIC_YEAR Contains information about academic years. Dimension 18-OCT-2001
FACULTY_DEMOGRAPHIC This is a dimension table for Faculty Profile by CIP. It contains the demographic (gender and race/ethnicity) information. Dimension 22-APR-2003
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 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 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 08-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 14-JUL-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 Unavailable

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