|
|
|
AAUP FACULTY BENEFIT DETAIL
The fact table for the AAUP Faculty Fringe Benefit survey.
| Field Name | Description | Data Type | Length |
|---|---|---|---|
| AAUP_FACBEN_RANK_KEY | Use this field to join the AAUP FACBEN RANK table to the AAUP FACULTY BENEFIT 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 |
| FACULTY_BENEFIT_COUNT | Number of faculty members receiving fringe benefits | NUMBER | 5 |
| FACULTY_SALARY_COUNT | Number of faculty members on salary | NUMBER | 5 |
| FRINGE_BENEFIT_OUTLAY | Faculty fringe benefit outlay | NUMBER | 13.3 |
| 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_SALARY_COUNT | Number of tenured faculty members on salary | 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