|
|
|
IPEDS STAFF SALARY RANGE
This is a dimension table for IPEDS Fall Staff Survey with Salary Range. It contains the definitions of various ranges of salary in different academic years, eg. "Below $25,000", "$25,000 - $29,999", "$30,000 and above".
| Field Name | Description | Data Type | Length |
|---|---|---|---|
| ACADEMIC_YEAR | Academic year, eg. 1999-2000, 2001-2002 | VARCHAR2 | 9 |
| 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 |
| SALARY_RANGE | Range of salary. Eg. "Below $25,000", "$24,999-$29,999", "$30,000 - $34,999", "$35,000 - $39, 999", ... "$75,000 and above" | VARCHAR2 | 25 |
| SALARY_RANGE_SORT_ORDER | Contains a number indicates the suggested order to sort the various salary range. | NUMBER | 2 |
| 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