|
|
|
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.
| Field Name | Description | Data Type | Length |
|---|---|---|---|
| APPOINTMENT_TYPE | Appointment/contract type of a faculty member: 9-10 month; 11-12 month; Not Available. See also APPOINTMENT_TYPE_CODE | VARCHAR2 | 20 |
| APPOINTMENT_TYPE_CODE | Code value for faculty appointment type: 1=9-10 month; 2=11-12 month; X=Not Available. See also APPOINTMENT_TYPE | VARCHAR2 | 1 |
| EAP_CATEGORY | EAP (Employee by Assigned Positions) Category. | VARCHAR2 | 70 |
| EAP_CAT_CODE | EAP (Employee by Assigned Positions) Category code: 1=Instruction/Research/Public Service, 2=Primarily Instruction, 3=Primarily Research, 4=Primarily Public Service (and/or clinical or 'Medical Only' group), 5=Other (e.g. deans, librarians). | VARCHAR2 | 1 |
| FACULTY_PROFILE_TYPE_KEY | Use this field to join together the FACULTY_PROFILE_TYPE and the FACULTY_PROFILE_DETAIL tables for information about faculty profile and headcount by faculty types. | VARCHAR2 | 6 |
| FACULTY_RANK | An hierarchical appointment of academic status of a faculty member: Professor, Associate Professor, Assistant Professor, Lecturer, Instructor | VARCHAR2 | 20 |
| FACULTY_RANK_CODE | Faculty Rank code: 1=Professor, 2=Associate Professor, 3=Assistant Professor, 4=Instructor, 5=Lecturer, 6=Other. | VARCHAR2 | 1 |
| FULL_OR_PART_TIME | Full Time or Part Time | VARCHAR2 | 20 |
| FULL_PART_CODE | 1=Full-Time, 2=Part-Time | VARCHAR2 | 1 |
| MEDICAL_CODE | 1=Non-Medical, 2=Medical Only | VARCHAR2 | 1 |
| MEDICAL_STATUS | Non-Medical or Medical Only status | VARCHAR2 | 20 |
| TENURE_TYPE | Tenure type. See also TENURE_TYPE_CODE. | VARCHAR2 | 20 |
| TENURE_TYPE_CODE | Tenure code: 1=Tenured, 2=Tenure Track, 3=Non-Tenure Track | VARCHAR2 | 1 |
| TRACK_ATTRIBUTE | Track Attribute. See also TRACK_ATTR_CODE. | VARCHAR2 | 20 |
| TRACK_ATTR_CODE | Track Attribute Code: 1=Regular, 2=Research, 3=Clinical, 4=Public Service, 9=Other | VARCHAR2 | 1 |
| 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