|
|
|
CUPA Administrative Compensation Survey
AAUDE institutions in the CUPA Administrative Salary Survey.
This page lists all the tables for
the CUPA Administrative Compensation Survey Star/Table Group.
Clicking on a table name will display the fields found in
that table.
| Table Name | Description | Type | Last Load Date |
|---|---|---|---|
| CUPA_INSTITUTION | This is a dimension table for CUPA Administrative Compensation Survey. It contains some of the characteristics (e.g. Institutional Structure and Institutional Affiliation) of all of the AAUDE Institutions in the CUPA Administrative Salary Survey. There is one record per institution for an academic year. | Dimension | 22-JUN-2009 |
| 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. | Fact | 22-JUN-2009 |
| CUPA_REPORTING_RELATIONSHIP | This is a dimension table for CUPA Administrative Compensation Survey. Like the CUPA POSITION table, it also contains a list of CUPA defined positions with the CUPA Position Number and the descriptions of the position. Join this table to the fact table, CUPA ADMIN SALARY DETAIL, to show the reporting relationship of the position. | Dimension | 25-JUN-2007 |
| CUPA_HIRING_DEMOGRAPHIC | This is a dimension table for CUPA Administrative Compensation Survey. It contains all the possible values of the hiring status (e.g. "Internal Promotion", "Outside Hire", "None Entered") and demographic types (e.g. "Male", "Female" for gender; and the minority status) which describe the occupant of the position. | Dimension | 12-MAY-2006 |
| CUPA_POSITION | This is a dimension table for CUPA Administrative Compensation Survey. It contains a list of CUPA defined positions with the CUPA Position Number (e.g. 501.00, 501.10, 501.50) and the brief description of the position (e.g. "Chief Student Affairs Officer", "Associate Chief Student Affairs Officer", "Dean of Students"). | Dimension | 25-JUN-2007 |
e-mail aaude-warehouse@mit.edu | Warehouse home | AAUDE home