|
|
FACULTY PROFILE DEPT
This is a dimension table for Faculty Profile by CIP. It contains information about departments and schools of the institution.
| 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 |
| DEPARTMENT_NAME | Name of a department | VARCHAR2 | 60 |
| FACULTY_PROFILE_DEPT_KEY | Use this field to join together the FACULTY_PROFILE_DEPT and the FACULTY_PROFILE_DETAIL tables for faculty profile and headcount information by department and school. | VARCHAR2 | 92 |
| SCHOOL_ABBREVIATION | Abbreviation of the name of a school within an institution | VARCHAR2 | 30 |
| 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