|
|
|
IPEDS IC INST AFFILIATION
IPEDS institution characteristics on the institution's affiliation or operating control.
| 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 |
| CONTROL_AFFILIATION_CODE | Institutional control or affiliation (code) Value - Label 1 - Public 2 - Private for-profit 3 - Private not-for-profit (no religious affiliation) 4 - Private not-for-profit (religious affiliation) | VARCHAR2 | 2 |
| CONTROL_AFFILIATION_DESC | Institutional control or affiliation (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 |
| PUBLIC_CONTROL_PRIMARY_CODE | Primary public control level (code) Value - Label 1 - Federal 2 - State 3 - Territorial 4 - School district 5 - County 6 - Township 7 - City 8 - Special district 9 - Other | VARCHAR2 | 2 |
| PUBLIC_CONTROL_PRIMARY_DESC | Primary public control level (description) | VARCHAR2 | 75 |
| PUBLIC_CONTROL_SECONDARY_CODE | Secondary public control level, if applicable (code) Value - Label 1 - Federal 2 - State 3 - Territorial 4 - School district 5 - County 6 - Township 7 - City 8 - Special district 9 - Other 0 - | VARCHAR2 | 2 |
| PUBLIC_CONTROL_SECONDARY_DESC | Secondary public control level, if applicable (description) | VARCHAR2 | 75 |
| RELIGIOUS_AFFILIATION_CODE | Institutions religious affiliation, if applicable (code) Value - Label 22 - American Evangelical Lutheran Church 23 -American Missionary Association 24 -African Methodist Episcopal Zion church 25 -Amish Church 26 -Advent Christian Church 27 -Assemblies of God Church 28 -Brethren Church 29 -Brethren in Christ Church 30 -Roman Catholic 31 -Church of God in Christ 32 -Church of New Jerusalem 33 -Wisconsin Evangelical Lutheran Synod 34 -Christ and Missionary Alliance Church 35 -Christian Reformed Church 36 -Evangelical Congregational Church 37 -Evangelical Covenant Church of America 38 -Evangelical Free Church of America 39 -Evangelical Lutheran Church 40 -International United Pentecostal Church 41 -Free Will Baptist Church 42 -Interdenominational 43 -Mennonite Brethren Church 44 -Moravian Church 45 -North American Baptist 46 -American Lutheran and Luth Ch in America 47 -Pentecostal Holiness Church 48 -Christian Churches and Churches of Christ 49 -Reformed Church in America 50 -Episcopal Church, Reformed 51 -African Methodist Episcopal 52 -American Baptist 53 -American Lutheran 54 -Baptist 55 -Christian Methodist Episcopal 56 -Church of Christ (Scientist) 57 -Church of God 58 -Church of Brethren 59 -Church of the Nazarene 60 -Cumberland Presbyterian 61 -Christian Church (Disciples of Christ) 63 -Friends of United Meeting 64 -Free Methodist 65 -Friends 66 -Presbyterian Church (USA) 67 -Lutheran Church in America 68 -Lutheran Church -Missouri Synod 69 -Mennonite Church 70 -General Conference Mennonite Church 71 -United Methodist 73 -Protestant Episcopal 74 -Churches of Christ 75 -Southern Baptist 76 -United Church of Christ 77 -Protestant, Not Specified 78 -Multiple Protestant Denomination 79 -Other Protestant 80 -Jewish 81 -Reformed Presbyterian Church 82 -Reorganized Latter Day Saints Church 83 -Seventh Day Baptist Other -2 - Item not applicable | VARCHAR2 | 2 |
| RELIGIOUS_AFFILIATION_DESC | Institutions religious affiliation, if applicable (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