|
|
|
IPEDS IC ACCREDITATION
IPEDS institution characteristics on accrediation. This table contains information about the accrediting agencies of each of the institution for a survey year.
| Field Name | Description | Data Type | Length |
|---|---|---|---|
| ACADEMIC_YEAR_KEY | Use this field to join the ACADEMIC YEAR table to a fact table for time dimension information. | VARCHAR2 | 4 |
| ACCREDITING_AGENCY_CODES | National institutional and specialized accrediting bodies recognized by the Secretary, U.S. Department of Education (codes) Value - Label 001 - Engineering (ENG) 002 - Engineering Technology (ENGT) 003 - Medical Assistant Education (MAAB), Accrediting Bureau of Health Education Schools 004 - Medical Laboratory Technician Education (MLTAB), Accrediting Bureau of Health Education Schools | VARCHAR2 | 200 |
| ACRD_AGNCY_NOT_APPLICABLE_CODE | Accreditation is not applicable (code) Value - Label 1 - Yes 0 - implied no -1 - {Not reported} -2 - {Item not applicable} -3 - {Item not available} | VARCHAR2 | 2 |
| ACRD_AGNCY_NOT_APPLICABLE_DESC | Accreditation is not applicable (description) | VARCHAR2 | 75 |
| ACRD_NATNL_OR_SPEC_AGENCY_CODE | Accredited by a national or specialized accrediting agency (code) Value - Label 1 - Yes 0 - implied no -1 - {Not reported} -2 - {Item not applicable} -3 - {Item not available} | VARCHAR2 | 2 |
| ACRD_NATNL_OR_SPEC_AGENCY_DESC | Accredited by a national or specialized accrediting agency (description) | VARCHAR2 | 75 |
| ACRD_REGIONAL_AGENCY_CODE | Accredited by a regional accrediting agency (code) Value - Label 1 - Yes 0 - implied no -1 - {Not reported} -2 - {Item not applicable} -3 - {Item not available} | VARCHAR2 | 2 |
| ACRD_REGIONAL_AGENCY_DESC | Accredited by a regional accrediting agency (description) | VARCHAR2 | 75 |
| ACRD_STATE_AGENCY_CODE | Accredited by a state accrediting or approval agency (code) Value - Label 1 - Yes 0 - implied no -1 - {Not reported} -2 - {Item not applicable} -3 - {Item not available} | VARCHAR2 | 2 |
| ACRD_STATE_AGENCY_DESC | Accredited by a state accrediting or approval agency (description) | VARCHAR2 | 75 |
| ACRD_US_DEPT_ED_REC_AGNCY_CODE | Accredited by a national or specialized accrediting agency recognized by the Secretary, U.S. Department of Education (code) Value - Label 1 - Yes 2 - No -1 - {Not reported} -2 - {Item not pplicable} -3 - {Item not available} | VARCHAR2 | 2 |
| ACRD_US_DEPT_ED_REC_AGNCY_DESC | Accredited by a national or specialized accrediting agency recognized by the Secretary, U.S. Department of Education (description) | VARCHAR2 | 75 |
| INSTITUTION_KEY | Use this field to join to another table with the same-name field (ie. INSTITUTION_KEY). | VARCHAR2 | 6 |
| INSTITUTION_NAME | Name of an institution. | VARCHAR2 | 60 |
| IPEDS_IC_KEY | Use this field to join between two IPEDS Institution Characteristics tables. | VARCHAR2 | 10 |
| REGIONAL_ACRD_AGENCY_NAME_CODE | Regional accrediting agency (code) Value - Label 1 - Middle States Assoc. of Colleges and Schools, Comm. on Higher Ed. 2 - Middle States Assoc. of Colleges and Schools, Comm. On Secondary Ed. 3 - New England Assoc. of Schools and Colleges, Inst. of Higher Ed. 4 - New England Assoc. of Schools and Colleges, Tech. and Career Inst. 5 - North Central Assoc. of Colleges and Schools, Higher Learning Comm. 6 - North Central Assoc. Comm. on Accreditation and School Improvement 7 - Northwest Assoc. of Schools and of Colleges and Univ. 8 - Southern Association of Colleges and Schools, Comm. on Colleges 9 - Western Assoc. of Schools and Colleges, Community and Jr. Colleges 10 - Western Assoc. of Schools and Colleges, Comm. for Schools 11 - Western Assoc. of Schools and Colleges, Comm. for Sr. Coll and Univ -1 - {Not reported} -2 - {Item not applicable} -3 - {Item not available} | VARCHAR2 | 2 |
| REGIONAL_ACRD_AGENCY_NAME_DESC | Regional accrediting agency (description) | VARCHAR2 | 75 |
| SURVEY_YEAR | Year the survey was issued (e.g. 1999 for Fall 1999) | VARCHAR2 | 4 |
| 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 |
e-mail aaude-warehouse@mit.edu | Warehouse home | AAUDE home