|
|
|
IPEDS STAFF SAL RANGE DETAIL
This is a fact table for IPEDS Fall Staff Survey of count and percentage of employees for different institutions in different academic years, by employee status (Full Time or Part Time), type of work they perform and gender with Salary Range.
| 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 |
| IPEDS_STAFF_SAL_RANGE_KEY | Use this field to join the IPEDS STAFF SAL RANGE DETAIL fact table with the IPEDS STAFF SALARY RANGE table to get information about the various ranges of salary. | VARCHAR2 | 12 |
| 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