|
|
|
INSTITUTION MASKED
A view of the Institution table for use specifically with the AAUDE_FACSAL_MASKED_DETAIL table.
| 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_TERM_TYPE | The type of academic term: Semester, Quarter | VARCHAR2 | 10 |
| ACAD_YEAR_CONVERSION_FACTOR | Academic year conversion factor, used to convert a 11-12 month faculty salary to a Nine-Month Salary (ie. 9-10 month salary). | NUMBER | 9.7 |
| CARNEGIE_CLASS_CODE | Carnegie Foundation Classification Codes | VARCHAR2 | 3 |
| CARNEGIE_CLASS_DESC | Description of Carnegie class code | VARCHAR2 | 80 |
| CITY | City where the institution is located. | VARCHAR2 | 30 |
| CONTROL | Type/Control of an institution; eg. PUBLIC, PRIVATE | VARCHAR2 | 10 |
| FICE | Institutional identifier assigned to each higher education institutions by FICE (Federal Interagency Committee on Education). | VARCHAR2 | 6 |
| HIGHEST_DEG_GRANTED_CODE | The highest degree granted by the institution | VARCHAR2 | 3 |
| HIGHEST_DEG_GRANTED_DESC | The description of the highest degree granted by the institution | VARCHAR2 | 30 |
| HIGHEST_DEG_GRANTED_SE_CODE | The highest science & engineering degree granted by the institution | VARCHAR2 | 3 |
| HIGHEST_DEG_GRANTED_SE_DESC | The description of the highest science & engineering degree granted by the institution | VARCHAR2 | 30 |
| INSTITUTION_MASKED_KEY | User this field to join INSTITUTION_MASKED to AAUDE_FACSAL_MASKED_DETAIL | VARCHAR2 | 6 |
| INST_FULL_NAME | The full name of the institution. | VARCHAR2 | 60 |
| INST_NAME | Name of institution | VARCHAR2 | 60 |
| IS_AAUDE_INSTITUTION | A flag indicates whether the institution is an AAUDE member institution. Y=Yes, N=No. | VARCHAR2 | 1 |
| IS_MULTI_CAMPUS | A flag indicates whether this institution consists of multiple campuses. Y=Yes, N=No | VARCHAR2 | 1 |
| IS_PRIVATE | A flag indicates whether the insitution is a private institution. Y=Yes, N=No | VARCHAR2 | 1 |
| IS_PUBLIC | A flag indicates whether the institution is a public institution. Y=Yes, N=No | VARCHAR2 | 1 |
| NSF_FICE | FICE code used by the NSF, which is sometimes different than the code reported in the FICE column. | VARCHAR2 | 6 |
| STATE_CODE | state | VARCHAR2 | 2 |
| STATE_DESC | state name | VARCHAR2 | 30 |
| UNIT_ID | Unique identification number of each AAUDE institution | VARCHAR2 | 6 |
| WAREHOUSE_LOAD_DATE | The date the records were last loaded/updated in this table in the Data Warehouse | DATE | 7 |
| ZIP | zip code | VARCHAR2 | 10 |
e-mail aaude-warehouse@mit.edu | Warehouse home | AAUDE home