AAUDE banner Data Warehouse logo

IPEDS Employee by Assigned Position

Number of employees for each institution in an academic year, grouped by position description, primary function of the position, and tenure status

This page lists all the tables for the IPEDS Employee by Assigned Position Star/Table Group.
Clicking on a table name will display the fields found in that table.


Table Name Description Type Last Load Date
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 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 08-SEP-2009
ACADEMIC_YEAR Contains information about academic years. Dimension 18-OCT-2001
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

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