|
|
|
DELW FACULTY TYPE
This is a dimension table for Delaware Survey. It contains the codes and definitions of the faculty type in which the records of the Delaware Survey are grouped.
| Field Name | Description | Data Type | Length |
|---|---|---|---|
| DELW_FACULTY_TYPE_KEY | Use this field to join together the DELW_FACULTY_TYPE and DELW_TEACHING_LOAD_DETAIL tables for Delaware Survey for Teaching Load data by faculty type. | VARCHAR2 | 1 |
| FACULTY_TYPE | Faculty Type (see also FACULTY TYPE CODE) | VARCHAR2 | 50 |
| FACULTY_TYPE_CODE | Faculty Type Code: 1=Tenured/Tenure Eligible, 2=Other Regular Faculty, 3=Supplemental Faculty, 4=Teaching Assistants for Credit Bearing Courses, 5=Teaching Assistants for Non-Credit Bearing Courses, 6=All Instructor Types | 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