|
|
|
FACULTY PROFILE DETAIL
This is a fact table. This table contains of information about departmental faculty profiles, including full-time/part-time tenure/track and non-tenure-track populations, with gender and ethnic parameters. The records are grouped by academic year, institution, and CIP code.
| Field Name | Description | Data Type | Length |
|---|---|---|---|
| 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 |
| 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_DEMOGRAPHIC_KEY | Use this field to join together the FACULTY_DEMOGRAPHIC and the FACULTY_PROFILE_DETAIL tables for faculty profile and headcount information by gender and ethnicity. | VARCHAR2 | 2 |
| FACULTY_HEAD_COUNT | Faculty headcount | NUMBER | 5 |
| FACULTY_PROFILE_DEPT_KEY | Use this field to join together the FACULTY_PROFILE_DEPT and the FACULTY_PROFILE_DETAIL tables for faculty profile and headcount information by department and school. | VARCHAR2 | 92 |
| FACULTY_PROFILE_FTE_SOURCE_KEY | Use this field to join the FACULTY_PROFILE_FTE_SOURCE table to the FACULTY_PROFILE_DETAIL table. This field should only be used for joining tables, not for reporting. | VARCHAR2 | 1 |
| FACULTY_PROFILE_TYPE_KEY | Use this field to join together the FACULTY_PROFILE_TYPE and the FACULTY_PROFILE_DETAIL tables for information about faculty profile and headcount by faculty types. | VARCHAR2 | 6 |
| FTE_FACULTY_HEAD_COUNT | Full time equivalent of the headcount reported based upon actual % time paid for that payroll/personnel period underlying EAP/Fac Profile reporting | NUMBER | 5.2 |
| INSTITUTION_KEY | Use this field to join to another table with the same-name field (ie. INSTITUTION_KEY). | VARCHAR2 | 6 |
| SECONDARY_CIP_KEY | XXX | VARCHAR2 | 7 |
| 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