|
|
|
IPEDS STAFF BY EMPTYPE DETAIL
This is the fact table for IPEDS Fall Staff Survey by Employee Types. Count of employees are grouped by gender, employee status (Full Time or Part Time), employee type (Faculty, Managerial, Clerical, Skilld Craft, etc.) and contract types (9/10 months, 11/12 months, Less than 9/10 months) for full time faculty. Percentages for each employee type as percentage of all employees are also included.
| 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 |
| INSTITUTION_KEY | Use this field to join to another table with the same-name field (ie. INSTITUTION_KEY). | VARCHAR2 | 6 |
| IPEDS_GENDER_KEY | Use this field to join to another IPEDS table with the same-name field. It is not used for reporting | VARCHAR2 | 1 |
| IPEDS_STAFF_EMPTYPE_KEY | Use this field to join together the IPEDS STAFF EMPTYPE table and the IPEDS STAFF BY EMPTYPE DETAIL table. | VARCHAR2 | 8 |
| NUMBER_OF_EMPLOYEES | Number of employees | NUMBER | 6 |
| PERCENTAGE_OF_EMPLOYEES | Percentage of all employees. | NUMBER | 6.4 |
| 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