|
|
|
AAUDE FACSAL DEPARTMENT
Contains information about the departments and schools of an institution. This is a dimension table used with the AAUDE Faculty Salary fact table.
| Field Name | Description | Data Type | Length |
|---|---|---|---|
| AAUDE_FACSAL_DEPARTMENT_KEY | Use this field to join the AAUDE FACULTY SALARY DEPARTMENT table to the AAUDE FACULTY SALARY DETAIL table. This field should only be used for joining data, NOT for reporting. | VARCHAR2 | 200 |
| DEPARTMENT_ABBREVIATION | Abbreviation of department name within an institution | VARCHAR2 | 60 |
| MULTI_CAMPUS_CODE | XXX | VARCHAR2 | 1 |
| SCHOOL_ABBREVIATION | Abbreviation of the name of a school within an institution | VARCHAR2 | 30 |
| SUBDISCIPLINE_ABBREVIATION | XXX | VARCHAR2 | 60 |
e-mail aaude-warehouse@mit.edu | Warehouse home | AAUDE home