|
|
|
CIP CROSS IPEDS COMPLETION
CIP cross walk for IPEDS completion survey for different institutions in different academic years.
| 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_CROSS_IPEDSCOM_COMPARE_KEY | Use this field to join the CIP CROSS FACULTY SALARY table and the AAUDE FACULTY SALARY DETAIL table for comparing faculty salary by CIP (discipline) with other institutions. This field should only be used to join data/tables, NOT for reporting | VARCHAR2 | 11 |
| 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 |
| 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 |
| UNIT_ID | Unique identification number of each AAUDE institution | VARCHAR2 | 6 |
e-mail aaude-warehouse@mit.edu | Warehouse home | AAUDE home