|
|
|
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").
| Field Name | Description | Data Type | Length |
|---|---|---|---|
| CUPA_POSITION_DESC | A brief description of the CUPA position. E.g. "Chief Academic Officer" for position number 201.00, "Director, Institutional Research" for position number 204.00 | VARCHAR2 | 60 |
| CUPA_POSITION_GROUP | Where relevant, CUPA-defined grouping of position. | VARCHAR2 | 100 |
| 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_POSITION_NUMBER | The CUPA defined position number with explicit decimal. E.g. 101.00 for Chief Executive Officer of a System or District, 204.00 for Director, Institutional Research. | VARCHAR2 | 6 |
| CUPA_POSITION_NUMBER_NEW | The new CUPA-defined position number, in the XXXX format. | VARCHAR2 | 6 |
| CUPA_POSITION_SUBGROUP | Where relevant, CUPA-defined sub-grouping of position. | VARCHAR2 | 100 |
| 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