|
|
|
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.
| Field Name | Description | Data Type | Length |
|---|---|---|---|
| AAUDE_INST_CODE | The unique 2-character alpha code assigned to each AAUDE member university for maintaining security with exchange of institutional data | VARCHAR2 | 2 |
| ACADEMIC_YEAR | Academic year, eg. 1999-2000, 2001-2002 | VARCHAR2 | 9 |
| 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_INST_AFFILIATION | Institutional Affiliation: Public, Private/Religious, or Private/Non-Religious | VARCHAR2 | 30 |
| CUPA_INST_AFFIL_CODE | Institutional Affilation Code: 1 or A=Public, 2 or B=Private/Religious, 3 or C=Private/Non-Religous | VARCHAR2 | 1 |
| CUPA_INST_STRUCTURE | Institutional Structure: Single Unit Institution, Single Unit Institution with Multiple Sites, Main Campus Heading a System, Campus within a System, System Office | VARCHAR2 | 60 |
| CUPA_INST_STRUCTURE_CODE | Institutional Structure Code: 1 or A=Single Unit Institution, 2 or B=Single Unit Institution with Multiple Sites, 3 or C=Main Campus Heading a System, 4 or D=Campus within a System, 5 or E=System Office | VARCHAR2 | 1 |
| INSTITUTION_NAME | Name of an institution. | VARCHAR2 | 60 |
| 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