|
|
|
AAUDE FACULTY SALARY DETAIL
The fact table for AAUDE Faculty Salary Survey. This table contains data that allow comparisons of high, low, and average faculty salaries by academic rank and appointment length within CIP-defined academic departments or diciplines. Additionally, the total faculty and new hire faculty average salary, and average faculty age are reported for each academic and appointment.
| 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 |
| AAUDE_FACSAL_RANK_KEY | Use this field to join the AAUDE FACULTY RANK table to the AAUDE FACULTY SALARY DETAIL table. This field should only be used for joining data, 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 |
| AVERAGE_FACULTY_AGE | Average age of faculty | NUMBER | 4 |
| AVERAGE_SALARY | Average salary | NUMBER | 6 |
| CIP_CROSS_FACSAL_COMPARE_KEY | Use this field to join the CIP CROSS FACULTY SALARY table and the AAUDE FACULTY SALARY DETAIL table for comparing faculty salary by CIP (discipline) with other institutions. This field should only be used to join data/tables, NOT for reporting | VARCHAR2 | 11 |
| CIP_KEY | Use this field to join to another table with the same-name field (ie. CIP_KEY) for CIP information such as the CIP program code, category code, four-digit code, and the corresponding descriptions. | VARCHAR2 | 7 |
| FACULTY_FTE | Count of full-time equivalent (FTE) faculty members. FTE is a number that is used to place dissimilar individuals on a common baseline for comparison purposes | NUMBER | 6 |
| HIGH_SALARY | High salary | NUMBER | 6 |
| INSTITUTION_KEY | Use this field to join to another table with the same-name field (ie. INSTITUTION_KEY). | VARCHAR2 | 6 |
| LOW_SALARY | Low salary | NUMBER | 6 |
| MEDIAN_SALARY | Median salary | NUMBER | 6 |
| NEW_HIRE_AVERAGE_SALARY | Average salary of new hire faculty. New hire faculty is faculty on the current year roster who was not on the prior year roster | NUMBER | 6 |
| NEW_HIRE_FACULTY_FTE | Count of full-time equivalent (FTE) of new hire faculty members. New hire faculty is faculty on the current year roster who was not on the prior year roster | NUMBER | 4 |
| RUNZHEIMER_KEY | Use this field to join RUNZHEIMER_COST_OF_LIVING to relevant fact tables. | VARCHAR2 | 10 |
| SECONDARY_CIP_KEY | XXX | VARCHAR2 | 7 |
| SEVENTY_FIFTH_PERCENTILE | 75th percentile | NUMBER | 6 |
| STANDARD_DEVIATION | Standard deviation | NUMBER | 6 |
| TERTIARY_CIP_KEY | XXX | VARCHAR2 | 7 |
| TWENTY_FIFTH_PERCENTILE | 25th percentile | NUMBER | 6 |
| 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