|
|
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