|
|
|
IPEDS IC ADMISSIONS CONSIDER
IPEDS institution characteristics on admissions consideration for undergraduate selection. This table contains information regarding each institution's undergraduate admissions policies and selection process 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 |
| ADMCON_COLLEGE_PREP_PROG_CODE | Admission consideration for undergraduate selection - Completion of college-preparatory program (code) Value - Label 1 - Required 2 - Recommended 3 - Neither required nor recommended 4-- Dont Know -1 - {Not reported} -2 - {Item not applicable} -3 - {Item not available} | VARCHAR2 | 2 |
| ADMCON_COLLEGE_PREP_PROG_DESC | Admission consideration for undergraduate selection - Completion of college-preparatory program (description) | VARCHAR2 | 75 |
| ADMCON_DEMO_COMPETENCE_CODE | Admission consideration for undergraduate selection - Formal demonstration of competencies (e.g. portfolios, certificates of mastery, assessment instruments) (code) Value - Label 1 - Required 2 - Recommended 3 - Neither required nor recommended 4 - Dont Know -1 - {Not reported} -2 - {Item not applicable} -3 - {Item not available} | VARCHAR2 | 2 |
| ADMCON_DEMO_COMPETENCE_DESC | Admission consideration for undergraduate selection - Formal demonstration of competencies (e.g. portfolios, certificates of mastery, assessment instruments) (description) | VARCHAR2 | 75 |
| ADMCON_RECOMMENDATION_CODE | Admission consideration for undergraduate selection - Recommendations (code) Value - Label 1 - Required 2 - Recommended 3 - Neither required nor recommended 4 - Dont Know -1 - {Not reported} -2 - {Item not applicable} -3 - {Item not available} | VARCHAR2 | 2 |
| ADMCON_RECOMMENDATION_DESC | Admission consideration for undergraduate selection - Recommendations (description) | VARCHAR2 | 75 |
| ADMCON_SEC_GPA_CODE | Admission consideration for undergraduate selection - Secondary school GPA (code) Value - Label 1 - Required 2 - Recommended 3 - Neither required nor recommended 4 - Dont Know -1 - {Not reported} -2 - {Item not applicable} -3 - {Item not available} | VARCHAR2 | 2 |
| ADMCON_SEC_GPA_DESC | Admission consideration for undergraduate selection - Secondary school GPA (description) | VARCHAR2 | 75 |
| ADMCON_SEC_SCHOOL_RANK_CODE | Admission consideration for undergraduate selection - Secondary class standing (code) Value - Label 1 - Required 2 - Recommended 3 - Neither required nor recommended 4 - Dont know -1 - {Not reported} -2 - {Item not applicable} -3 - {Item not available} | VARCHAR2 | 2 |
| ADMCON_SEC_SCHOOL_RANK_DESC | Admission consideration for undergraduate selection - Secondary class standing (description) | VARCHAR2 | 75 |
| ADMCON_SEC_SCHOOL_RECORD_CODE | Admission consideration for undergraduate selection - Secondary school record (code) Value - Label 1 - Required 2 - Recommended 3 - Neither required nor recommended 4 - Dont Know -1 - {Not reported} -2 - {Item not applicable} -3 - {Item not available} | VARCHAR2 | 2 |
| ADMCON_SEC_SCHOOL_RECORD_DESC | Admission consideration for undergraduate selection - Secondary school record (description) | VARCHAR2 | 75 |
| ADMCON_TEST_SCORE_CODE | Admission consideration for undergraduate selection - Admission test scores (SAT, ACT, etc.) (code) Value - Label 1 - Required 2 - Recommended 3 - Neither required nor recommended 4 - Dont Know -1 - {Not reported} -2 - {Item not applicable} -3 - {Item not available} | VARCHAR2 | 2 |
| ADMCON_TEST_SCORE_DESC | Admission consideration for undergraduate selection - Admission test scores (SAT, ACT, etc.) (description) | VARCHAR2 | 75 |
| ADMCON_TOEFL_CODE | Admission consideration for undergraduate selection - TOEFL (Test of English as a Foreign Language) test scores (code) Value - Label 1 - Required 2 - Recommended 3 - Neither required nor recommended 4 - Dont Know -1 - {Not reported} -2 - {Item not applicable} -3 - {Item not available} | VARCHAR2 | 2 |
| ADMCON_TOEFL_DESC | Admission consideration for undergraduate selection - TOEFL (Test of English as a Foreign Language) test scores (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 |
| OPEN_ADMISSION_POLICY_CODE | Open admission policy for all or most entering first-year undergraduate-level students (code) Value - Label 1 - Yes 2 - No 3 - Institution does not admit first-year undergraduate level students -1 - {Not reported} -2 - {Item not applicable} -3 - {Item not available} | VARCHAR2 | 2 |
| OPEN_ADMISSION_POLICY_DESC | Open admission policy for all or most entering first-year undergraduate-level students (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