|
|
|
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.
| Field Name | Description | Data Type | Length |
|---|---|---|---|
| CUPA_REPORTING_POSITION_DESC | A brief description of the CUPA reporting relationship. | VARCHAR2 | 70 |
| CUPA_REPORTING_POSITION_NUMBER | The position number with explicit decimal (e.g. 101.00) which represents the reporting relationship. A position number of 0.00 is used to represent a null value. | VARCHAR2 | 6 |
| CUPA_REPORTING_POS_GROUP | Where relevant, CUPA-defined grouping of position. | VARCHAR2 | 100 |
| CUPA_REPORTING_POS_NUMBER_NEW | The new CUPA-defined position number, in the XXXX format. | VARCHAR2 | 6 |
| CUPA_REPORTING_POS_SUBGROUP | Where relevant, CUPA-defined sub-grouping of position. | VARCHAR2 | 100 |
| 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 |
| 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