|
|
|
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.
| Field Name | Description | Data Type | Length |
|---|---|---|---|
| IPEDS_EMPLOYEE_POSITION_KEY | Use this field to join together the IPEDS EMPLOYEE POSITION and the IPEDS EMPLOYEE POS DETAIL tables to get the number of employees by position, primary function and tenure status. | VARCHAR2 | 10 |
| POSITION_DESCRIPTION | Descriptive text for POSITION_DESCRIPTION_CODE | VARCHAR2 | 30 |
| POSITION_DESCRIPTION_CODE | Codes for Position Description - Part Time, Full Time, Medical or Non Medical | VARCHAR2 | 6 |
| PRIMARY_FUNCTION | Primary function of the position. Possible values are: "Primarily instruction", "Instrcution combined w/ research / public service", "Primarily Research", "Primarily Public Service (extension)", "Executive / Administrative / Managerial", "Other Professional (Support / Service)", "Techinical / Paraprofessional", "Clerical / Secretarial", "Skilled Crafts", "Service / Maintanence". | VARCHAR2 | 60 |
| PRIMARY_FUNCTION_CODE | Code for Primary Function: 1,2,3,4,5,7,8,9,10,11 | VARCHAR2 | 2 |
| TENURE_STATUS | Tenure status of the position. Possible values are: "Tenured", "Tenure Track", "Not Tenure Track", "W/O Faculty Status", 'Grad Assistants". | VARCHAR2 | 30 |
| TENURE_STATUS_CODE | Code for tenure status: 1,2,3,4,5 | VARCHAR2 | 2 |
| WAREHOUSE_LOAD_DATE | The date the records were last loaded/updated in this table in the Data Warehouse | DATE | 7 |
e-mail aaude-warehouse@mit.edu | Warehouse home | AAUDE home