AAUDE banner Data Warehouse logo

AAMC Faculty Counts

Basic, Clinical, and Other medical faculty counts published by the AAMC.

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


Table Name Description Type Last Load Date
AAMC_INSTITUTION This is a dimension table containing AAMC institution names. Dimension Unavailable
AAMC_FACULTY_TYPE This is a dimension table containing information about AAMC faculty types. Dimension Unavailable
AAMC_DETAIL This is a fact table containing AAMC Faculty Counts. Fact Unavailable
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
ACADEMIC_YEAR Contains information about academic years. Dimension 18-OCT-2001

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