|
|
|
AAUDE FACSAL MASKED DETAIL
This table contains AAUDE Faculty Salary data for the current and previous academic years. Data for private institutions is masked.
| 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_MASKED_KEY | User this field to join INSTITUTION_MASKED to AAUDE_FACSAL_MASKED_DETAIL | 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 |
| NINETIETH_PERCENTILE | XXX | NUMBER | 22 |
| 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