|
|
|
AAUP FACSAL RANK
Contains the various different academic ranks of faculty (e.g. Professor, Associate Professor, Assistant Professor). This is a dimension table for the AAUP Faculty Salary fact table.
| Field Name | Description | Data Type | Length |
|---|---|---|---|
| AAUP_FACSAL_RANK_KEY | Field used for joining the AAUP FACSAL RANK and AAUP FACULTY SALARY DETAIL tables together. This field should be used only for joining tables, and NOT for reporting | VARCHAR2 | 5 |
| CONTRACT_TYPE | Appointment or contract type for faculty: 9-10 month, 11-12 month | VARCHAR2 | 20 |
| FACULTY_RANK | An hierarchical appointment of academic status of a faculty member: Professor, Associate Professor, Assistant Professor, Lecturer, Instructor | VARCHAR2 | 20 |
| GENDER | Gender | VARCHAR2 | 12 |
e-mail aaude-warehouse@mit.edu | Warehouse home | AAUDE home