|
|
|
IPEDS IC DIRECTORY INFO
IPEDS institution directory information. For each institution in a given survey year, the record contains information such as institution name, address, chief administrator, key contact telephone numbers, and other identifying attributes and classifications.
| 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 |
| ADMISSIONS_TELEPHONE_NUMBER | Admissions Office telephone number (area code + number + ext; no dashes or parentheses) Value - Label -1 - {Not reported} | VARCHAR2 | 15 |
| BUREAU_OF_ECON_ANAL_REG_CODE | Bureau of Economic Analysis (OBE) Region (code) Value - Label 0 - US Service schools 1 - New England CT ME MA NH RI VT 2 - Mid East DE DC MD NJ NY PA 3 - Great Lakes IL IN MI OH WI 4 - Plains IA KS MN MO NE ND SD 5 - Southeast AL AR FL GA KY LA MS NC SC TN VA WV 6 - Southwest AZ NM OK TX 7 - Rocky Mountains CO ID MT UT WY 8 - Far West AK CA HI NV OR WA 9 - Outlying areas AS FM GU MH MP PR PW VI | VARCHAR2 | 2 |
| BUREAU_OF_ECON_ANAL_REG_DESC | Bureau of Economic Analysis (OBE) Region (description) | VARCHAR2 | 75 |
| CARNEGIE_CLASS_CODE | Carnegie Foundation Classification Codes | VARCHAR2 | 3 |
| CARNEGIE_CLASS_DESC | Description of Carnegie class code | VARCHAR2 | 80 |
| CHIEF_ADMINISTRATOR_NAME | Name of the chief administrator of the institution | VARCHAR2 | 35 |
| CHIEF_ADMINISTRATOR_TITLE | Title of the chief administrator of the institution | VARCHAR2 | 35 |
| CITY | City where the institution is located. | VARCHAR2 | 30 |
| CONTROL_OF_INSTITUTION_CODE | Control of institution (code) 1 - Public 2 - Private, non-profit 3 - Private, for profit -3 - {Not available} | VARCHAR2 | 2 |
| CONTROL_OF_INSTITUTION_DESC | Control of institution (description) | VARCHAR2 | 75 |
| COUNTRY_ABBREV | Country abbreviation US for United States CA for Canada | VARCHAR2 | 2 |
| DATE_INSTITUTION_CLOSED | Date institution closed - format is mmddyyyy | VARCHAR2 | 8 |
| DEGREE_GRANTING_STATUS_CODE | Degree granting status (code) Value - Label 1 - Degree - granting 2 - Nondegree - granting, primarily postsecondary 3 - Nondegree - granting, not primarily postsecondary 4 - Not an educational entity | VARCHAR2 | 2 |
| DEGREE_GRANTING_STATUS_DESC | Degree granting status (description) | VARCHAR2 | 75 |
| DUNS_IDENTIFICATION_NUMBER | Dunn and Bradstreet identification number Value - Label -1 - {Not reported} | VARCHAR2 | 10 |
| EMPLOYER_IDENTIFICATION_NUMBER | Employer Identification Number - assigned by the Internal Revenue Service Value - Label -1 - {Not reported} -2 - {Item not applicable} -3 - {Not available} -9 - {Form not mailed} | VARCHAR2 | 9 |
| FINANCIAL_AID_TELEPHONE_NUMBER | Financial Aid Office telephone number (area code + number + ext; no dashes or parentheses) Value - Label -1 - {Not reported} | VARCHAR2 | 15 |
| FIPS_CODE | FIPS (Federal Information Processing Standards) State code (code) Value - Label (Description) 1 - AL (Alabama) 2 - AK (Alaska) 4 - AZ (Arizona) 5 - AR (Arkansas) 6 - CA (California) 8 - CO (Colorado) 9 - CT (Connecticut) 10 - DE (Delaware) 11 - DC (Washington DC) 12 - FL (Florida) 13 - GA (Georgia) 15 - HI (Hawaii) 16 - ID (Idaho) 17 - IL (Illinois) 18 - IN (Indiana) 19 - IA (Iowa) 20 - KS (Kansas) 21 - KY (Kentucky) 22 - LA (Louisiana) 23 - ME (Maine) 24 - MD (Maryland) 25 - MA (Massachusetts) 26 - MI (Michigan) 27 - MN (Minnesota) 28 - MS Mississippi) 29 - MO (Missouri) 30 - MT (Montana) 31 - NE (Nebraska) 32 - NV (Nevada) 33 - NH (New Hampshire) 34 - NJ (New Jersey) 35 - NM (New Mexico) 36 - NY (New York) 37 - NC (North Carolina) 38 - ND (North Dakota) 39 - OH (Ohio) 40 - OK (Oklahoma) 41 - OR (Oregon) 42 - PA (Pennsylvania) 44 - RI (Rhode Island) 45 - SC (South Carolina) 46 - SD (South Dakota) 47 - TN (Tennessee) 48 - TX (Texas) 49 - UT (Utah) 50 - VT (Vermont) 51 - VA (Virginia) 53 - WA (Washington) 54 - WV (West Virginia) 55 - WI (Wisconsin) 56 - WY (Wyoming) 60 - AS (American Samoa) 64 - FM (Federated States of Micronesia) 66 - GU (Guam) 68 - MH (Marshall Islands) 69 - MP (Northern Mariana Islands) 70 - PW (Palau) 72 - PR (Puerto Rico) 78 - VI (Virgin Islands) | VARCHAR2 | 2 |
| FIPS_DESC | FIPS State code (description) | VARCHAR2 | 75 |
| FIRST_PROF_OFFERING_CODE | First-professional offering (generated, based on response to IC survey) (code) Value - Label 1 - First-professional degree or first-professional certificate (post-degree) 2 - No first-professional offering -3 - {Not Available} | VARCHAR2 | 2 |
| FIRST_PROF_OFFERING_DESC | First-professional offering (generated, based on response to IC survey) (description) | VARCHAR2 | 75 |
| GENERAL_INFO_TELEPHONE_NUMBER | General information telephone number (area code + number + ext; no dashes or parentheses) Value - Label -1 - {Not reported} | VARCHAR2 | 15 |
| GRADUATE_OFFERING_CODE | Graduate offering (generated, based on response to IC) (code) Value - Label 1 - Graduate degree or certificate offered 2 - No graduate offering -3 - {Not Available} | VARCHAR2 | 2 |
| GRADUATE_OFFERING_DESC | Graduate offering (generated, based on response to IC) (description) | VARCHAR2 | 75 |
| HIGHEST_DEGREE_OFFERING_CODE | Highest Degree offered (code) Value - Label 1 - First-professional degrees only 10 - Doctoral 11 - Doctoral and First-professional 20 - Masters 21 - Masters and First-professional 30 - Bachelors 31 - Bachelors and First-professional 40 - Associates 41 - Associates and First-professional 0 - Non-Degree Granting (Certificates only) -3 - {Not Available} | VARCHAR2 | 2 |
| HIGHEST_DEGREE_OFFERING_DESC | Highest Degree offered (description) | VARCHAR2 | 75 |
| HIGHEST_LEVEL_OFFERING_CODE | Highest level of offering (generated, based on response to IC survey) (code) 1 - Postsecondary award, certificate or diploma of less than one academic year 2 - Postsecondary award, certificate or diploma of at least one but less than two academic years 3 - Associates Degree 4 - Postsecondary award, certificate or diploma of at least two but less than four academic years 5 - Bachelors Degree 6 - Postbaccalaureate Certificate 7 - Masters Degree 8 - Post-Masters Certificate 9 - Doctors Degree 0 - Other -2 - {Item not applicable, first-professional only} -3 - {Not available} | VARCHAR2 | 2 |
| HIGHEST_LEVEL_OFFERING_DESC | Highest level of offering (generated, based on response to IC survey) (description) | VARCHAR2 | 75 |
| HISTORICAL_BLACK_COL_UNIV_CODE | Historically Black College or University (accredited institution of higher education established prior to 1964 with the principal mission of educating Black Americans). (code) Value - Label 1 - Yes 2 - No | VARCHAR2 | 2 |
| HISTORICAL_BLACK_COL_UNIV_DESC | Historically Black College or University (accredited institution of higher education established prior to 1964 with the principal mission of educating Black Americans). (description) | VARCHAR2 | 75 |
| INSTITUTIONAL_AFFILIATION_CODE | Affiliation of institution (code) Value - Label 1 - Public 2 - Private for profit 3 - Private nonprofit, no religious affiliation 4 - Private nonprofit, religious affiliation -3 - {Not available} | VARCHAR2 | 2 |
| INSTITUTIONAL_AFFILIATION_DESC | Affiliation of institution (description) | VARCHAR2 | 75 |
| INSTITUTION_KEY | Use this field to join to another table with the same-name field (ie. INSTITUTION_KEY). | VARCHAR2 | 6 |
| INSTITUTION_LEVEL_CODE | Level of institution (generated, based on response to IC survey) (code) Value - Label 1 - Four or more years (Baccalaureate or higher degree) 2 - At least 2 but less than 4 years (below the Baccalaureate) 3 - Less than 2 years (below Associates Degree) -3 - {Not Available} | VARCHAR2 | 2 |
| INSTITUTION_LEVEL_DESC | Level of institution (generated, based on response to IC survey) (description) | VARCHAR2 | 75 |
| INSTITUTION_NAME | Name of an institution. | VARCHAR2 | 60 |
| INST_CURRENTLY_ACTIVE_CODE | Institution is active in current year (code) Value - Label 1 - Yes 2 - No, not active 3 - | VARCHAR2 | 1 |
| INST_CURRENTLY_ACTIVE_DESC | Institution is active in current year (description) | VARCHAR2 | 75 |
| INST_GRANTS_MED_DEGREE_CODE | Institution grants a medical degree (code) Value - Label 1 - Yes 2 - No -2 - {Item not applicable} -3 - {Not available} | VARCHAR2 | 2 |
| INST_GRANTS_MED_DEGREE_DESC | Institution grants a medical degree (description) | VARCHAR2 | 75 |
| INST_HAS_HOSPITAL_CODE | Institution has hospital (code) Value - Label 1 - Yes 2 - No | VARCHAR2 | 2 |
| INST_HAS_HOSPITAL_DESC | Institution has hospital (description) | VARCHAR2 | 75 |
| INST_IS_TRIBAL_COLLEGE_CODE | Institution is a tribal college (code) | VARCHAR2 | 2 |
| INST_IS_TRIBAL_COLLEGE_DESC | Institution is a tribal college (description) | VARCHAR2 | 75 |
| INST_LOCALE_CODE | Locale codes - Degree of Urbanization (code) Value - Label 1 - Large City - A central city of a CMSA (Consolidated Metropolitan Statistical Area) or MSA (Metropolitan Statistical Area) with the city having a population greater than or equal to 250,000. 2 - Mid-size City - A central city of a CMSA or MSA, with the city having a population less than 250,000. 3 - Urban Fringe of Large City - Any incorporated place, CDP, or non-place territory within a CMSA or MSA of a Large City and defined as urban by the Census Bureau. 4 - Urban Fringe of Mid-size City - Any incorporated place, CDP, or non-place territory within a CMSA or MSA of a Large City of a Mid-size City and defined as urban by the Census Bureau 5 - Large Town - An incorporated place or CDP with a population greater than or equal to 25,000 and located outside a CMSA or MSA. 6 - Small Town - An incorporated place or CDP with a population less than 25,000 and greater than or equal to 2,500 and located outside a CMSA or MSA. 7 - Rural - Any incorporated place, CDP, or non-place territory designated as rural by the Census Bureau. 9 - Not Assigned -3 - {Not Available} | VARCHAR2 | 2 |
| INST_LOCALE_DESC | Locale codes - Degree of Urbanization (description) | VARCHAR2 | 75 |
| INST_OPEN_TO_GEN_PUBLIC_CODE | Institution open to the general public (code) Value - Label 1 - Institution is open to the public 2 - Institution is not open to the public | VARCHAR2 | 2 |
| INST_OPEN_TO_GEN_PUBLIC_DESC | Institution open to the general public (description) | VARCHAR2 | 75 |
| IPEDS_IC_KEY | Use this field to join between two IPEDS Institution Characteristics tables. | VARCHAR2 | 10 |
| OFFICE_OF_POSTSEC_EDUC_ID | Office of Postsecondary Education (OPE) identification number for those institutions eligible to participate in Title IV programs | VARCHAR2 | 8 |
| OFFICE_OF_POSTSEC_ED_FLAG_CODE | OPE eligibility indicator flag (code) Value - Label 1 - Institution is eligible for Title IV aid 2 - Not listed separately as being an eligible institution by OPE but is a branch campus or system office of a main campus that is eligible. 3 - Eligible for Title IV aid, but for deferment only 4 - Eligible for Title IV aid, but not in-scope of IPEDS 5 - Not currently eligible 6 - Institution is not eligible and not listed on Title IV file | VARCHAR2 | 1 |
| OFFICE_OF_POSTSEC_ED_FLAG_DESC | OPE eligibility indicator flag (description) | VARCHAR2 | 75 |
| POSTSEC_INST_INDICATOR_CODE | Postsecondary institution indicator (code) Value - Label 1 - Active postsecondary institution 2 - Not primarily postsecondary or open to public 3 - Not active | VARCHAR2 | 2 |
| POSTSEC_INST_INDICATOR_DESC | Postsecondary institution indicator (description) | VARCHAR2 | 75 |
| POSTSEC_TITLE_4_INDICATOR_CODE | Postsecondary and Title IV institution indicator (code) Value - Label 1 - Title IV postsecondary institution 2 - Non - Title IV postsecondary institution 3 - Title IV NOT primarily postsecondary institution 4 - Non - Title IV NOT primarily postsecondary institution 5 - Title IV postsecondary institution that is NOT open to the public 6 - Non - Title IV postsecondary institution that is NOT open to the public 9 - Institution is not active in current universe | VARCHAR2 | 2 |
| POSTSEC_TITLE_4_INDICATOR_DESC | Postsecondary and Title IV institution indicator (description) | VARCHAR2 | 75 |
| SECTOR_CODE | Sector of institution (generated, based on response to IC survey) (code) Value - Label 0 - Administrative unit only (central, system, or corporate office) 1 - Public, 4-year or above 2 - Private nonprofit, 4-year or above 3 - Private for-profit, 4-year or above 4 - Public, 2-year 5 - Private nonprofit, 2-year 6 - Private for-profit, 2-year 7 - Public, less-than-2-year 8 - Private nonprofit, less-than-2-year 9 - Private for-profit, less-than-2-year -3 - {Not Available} | VARCHAR2 | 2 |
| SECTOR_DESC | Sector of institution (description) | VARCHAR2 | 75 |
| STATE_ABBREV | Post office State abbreviation code. See FIPS state codes (FIPS). Additional codes not in FIPS definition: State_Abbreviation, Country (Location) AA, US (Armed Forces in Central and S merica) AB, CA (Alberta) AE, US (Armed Forces Europe, Mideast, Africa) AP, US (Armed Forces in the Pacific) BC, CA (British Columbia) LB, CA (Labrador) MB, CA (Manitoba) NB, CA (New Brunswick) NL, CA (Newfoundland and Labrador) NS, CA (Nova Scotia) NT, CA (Northwest Territories) NU, CA (Nunavut) ON, CA (Ontario) PE, CA (Prince Edward Island) PQ, US (Panama Canal Zone) QC, CA (Quebec) SK, CA (Saskatchewan) YT, CA (Yukon) | VARCHAR2 | 2 |
| STATUS_OF_INSTITUTION_CODE | Status of institution (code) Value - Label A - Active - institution active and not an add C - Combined - merged with another institution D - Delete - institution is out of business H - Area search on hold pending verification I - Inactive M - Death with data - closed in current yr N - New - added during the current year O - Out-of-scope - not within scope of universe P - Potential add - might be added Q - Potential restore - might be restored R - Restore - restored to the current universe S - Split - split into more than one institution U - Duplicate - UNITID previously assigned W - Wipe out - out-of-scope potential add X - Potential restore not within scope of IPEDS Z - Universe III - out-of-scope | VARCHAR2 | 1 |
| STATUS_OF_INSTITUTION_DESC | Status of institution (description) | VARCHAR2 | 75 |
| STREET_ADDRESS | Institution (entity) street address or post office box | VARCHAR2 | 60 |
| SURVEY_YEAR | Year the survey was issued (e.g. 1999 for Fall 1999) | VARCHAR2 | 4 |
| UNDERGRADUATE_OFFERING_CODE | Undergraduate offering (generated, based on IC response) (code) 1 - Undergraduate degree or certificate offered 2 - No undergraduate offering -3 - {Not Available} | VARCHAR2 | 2 |
| UNDERGRADUATE_OFFERING_DESC | Undergraduate offering (generated, based on IC response) (description) | VARCHAR2 | 75 |
| UNITID_FOR_MERGED_SCHOOLS | UNITID where data is found for merged schools | VARCHAR2 | 6 |
| 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 |
| WEB_ADDRESS | Institutions Internet website address Value - Label -1 - {Not reported} | VARCHAR2 | 50 |
| YEAR_DELETED_FROM_IPEDS | Year institution was deleted from IPEDS | NUMBER | 4 |
| ZIPCODE | Postal code. U.S.:ZIP + four; includes dash (-) when last four digits given (e.g., 06010-2301). Last four positions may be blank. Canada: Postal code includes a single space between the first three and last three characters. | VARCHAR2 | 10 |
e-mail aaude-warehouse@mit.edu | Warehouse home | AAUDE home