|
|
|
CIP CROSS WALK
CIP cross walk data for different subjects (eg. Faculty Salary, IPEDS Completion Survey) and institutions.
| 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 |
| CIP_CATEGORY_CODE | The series number or category of a CIP code; i.e. the first 2-digit of the CIP code. | VARCHAR2 | 2 |
| CIP_CATEGORY_TITLE | The descriptive title of the 2-digit CIP category/series. | VARCHAR2 | 100 |
| CIP_FOUR_DIGIT_CODE | The first 4-digit (sub-category) of a CIP code. | VARCHAR2 | 5 |
| CIP_FOUR_DIGIT_TITLE | The descriptive title of the first 4-digit of a CIP code. | VARCHAR2 | 100 |
| CIP_PROGRAM_CODE | The 6-digit CIP program code, e.g. 040201, 230101, 149999. CIP code is the NCES 6-digit national standard curriculum identification scheme which best identifies the subject-matter discipline | VARCHAR2 | 7 |
| CIP_PROGRAM_TITLE | The descriptive title of the 6-digit CIP program code. | VARCHAR2 | 200 |
| DEPARTMENT | For CIP_CROSS_WALK: Code that an institution uses internally for a department. Department is an organizational unit within a school/college of an institution/university. For Undergraduate Time to Degree: the Department that asserts control over, or ownership of, this major program. |
VARCHAR2 | 10 |
| DEPARTMENT_NAME | Name of a department | VARCHAR2 | 60 |
| DIVISION_CODE | Code that an institution uses internally to designate a division or a school | VARCHAR2 | 10 |
| DIVISION_NAME | Name of a division or a school | VARCHAR2 | 60 |
| EDITED_CIP_CODE | Formatted CIP code. For example, raw/inputted CIP code with 4-digits only are appended with "01" to make them 6-digit CIP codes. | VARCHAR2 | 7 |
| INPUT_CIP_CODE | CIP code as entered by the institution. It is a raw and not formatted CIP code and it may not match a standard CIP code in the CIP-1990 and CIP-2000 files from where the Data Warehouse collects the CIP data. | VARCHAR2 | 7 |
| INSTITUTION_NAME | Name of an institution. | VARCHAR2 | 60 |
| IS_PRIMARY_FLAG | A flag indicates whether the CIP code used for this department and division is the primary/first choice in cases where multiple CIP codes mapped to the same department and division. Y=Yes, N=No, blank=neither | VARCHAR2 | 1 |
| SUBJECT_TYPE | Name of subject for CIP comparison/cross walk. Some examples are: Faculty Salary and IPEDS Completion | VARCHAR2 | 60 |
| UNIT_ID | Unique identification number of each AAUDE institution | VARCHAR2 | 6 |
e-mail aaude-warehouse@mit.edu | Warehouse home | AAUDE home