|
|
|
CUPA ADMIN SALARY DETAIL
The fact table for CUPA Administrative Compensation Survey. It contains records of AAUDE institutions in the CUPA Administrative Salary Survey. There is one record per institution in an academic year for each position of different demographic types (gender, minority status) and hiring status (whether it is an outside hire or an internal promotion). The following fields are included in each of the salary records: Academic Year, Institution, CUPA position number, Reporting Relationship, Vacancy Indicator, Years of Service in Present Position, Salary, and Number of Incumbents.
| Field Name | Description | Data Type | Length |
|---|---|---|---|
| CUPA_HIRING_DEMOGRAPHIC_KEY | Use this field to join the CUPA HIRING DEMOGRAPHIC table and the CUPA ADMIN SALARY DETAIL table to retrieve hiring status and demographic information for each of the CUPA Administrative Salary records. | VARCHAR2 | 4 |
| CUPA_INSTITUTION_KEY | Use this field to join the CUPA INSTITUTION table and the CUPA ADMIN SALARY DETAIL table for information about the AAUDE institutions | VARCHAR2 | 8 |
| CUPA_POSITION_KEY | Use this field to join the CUPA POSITION table and the CUPA ADMIN SALARY DETAIL table for CUPA position information of each of the CUPA salary records. This field is NOT used for reporting. | VARCHAR2 | 6 |
| CUPA_REPORTING_RELATION_KEY | Use this field to join the CUPA REPORTING RELATIONSHIP table and the CUPA ADMIN SALARY DETAIL table for the reporting relationship of each of the CUPA administrative salary records. This field is NOT used for reporting | VARCHAR2 | 6 |
| NUMBER_OF_INCUMBENTS | Number of Incumbents | NUMBER | 3 |
| SALARY | Annualized salary | NUMBER | 12.5 |
| WAREHOUSE_LOAD_DATE | The date the records were last loaded/updated in this table in the Data Warehouse | DATE | 7 |
| YEARS_OF_SERVICE | Years of service in present position | NUMBER | 5.1 |
e-mail aaude-warehouse@mit.edu | Warehouse home | AAUDE home