|
|
|
AAUP FACULTY SALARY DETAIL
The fact table for the AAUP Faculty Salary survey.
| 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 |
| ACADEMIC_YEAR_KEY | Use this field to join the ACADEMIC YEAR table to a fact table for time dimension information. | VARCHAR2 | 4 |
| ACAD_YEAR_CONVERSION_FACTOR | Academic year conversion factor, used to convert a 11-12 month faculty salary to a Nine-Month Salary (ie. 9-10 month salary). | NUMBER | 9.7 |
| FACULTY_COUNT | Number of faculty members | NUMBER | 5 |
| INSTITUTION_KEY | Use this field to join to another table with the same-name field (ie. INSTITUTION_KEY). | VARCHAR2 | 6 |
| SALARY_OUTLAY | In AAUP_FACULTY_SALARY_DETAIL, the reported salary outlay. In AAUP_FACULTY_BENEFIT_DETAIL, the aggregate 9 month converted salary outlay. | NUMBER | 12.2 |
| TENURED_FACULTY_COUNT | Number of tenured faculty members | NUMBER | 5 |
| 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