|
|
|
IPEDS IC SPECIAL LEARNING
IPEDS institution characteristics on special learning opportunities and student services. This table lists the different types of special learning opportunities and student services programs offered by each institution for a given 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 |
| 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 |
| LIBRARY_FACILITIES_CODE | Library facilities at institution (code) Value - Label 1 - Has own library 2 - Shared financial support for library 3 - None of the above 0 - - 1 - {Not reported} - 2 - {Item not applicable} | VARCHAR2 | 2 |
| LIBRARY_FACILITIES_DESC | Library facilities at institution (description) | VARCHAR2 | 75 |
| SPEC_OPS_ACCEL_PROGRAMS_CODE | Special learning opportunities - Accelerated programs (code) ACCELERATED PROGRAMS - Completion of a college program of study in fewer than the usual number of years, most often by attending summer sessions and carrying extra courses during the regular academic term. Value - Label 1 - Yes 0 - No - 1 - Dont know - 2 - Not applicable | VARCHAR2 | 2 |
| SPEC_OPS_ACCEL_PROGRAMS_DESC | Special learning opportunities - Accelerated programs (description) | VARCHAR2 | 75 |
| SPEC_OPS_DISTANCE_LEARN_CODE | Special learning opportunities - Distance learning programs (code) DISTANCE LEARNING - An option for earning course credit at off-campus locations via cable television, internet, satellite classes, videotapes, correspondence courses, or other means. Value - Label 1 - Yes 0 - No - 1 - Dont know - 2 - Not applicable | VARCHAR2 | 2 |
| SPEC_OPS_DISTANCE_LEARN_DESC | Special learning opportunities - Distance learning programs (description) | VARCHAR2 | 75 |
| SPEC_OPS_DUAL_ENROLLMENT_CODE | Special learning opportunities - Dual enrollment (code) DUAL ENROLLMENT - A program through which high school students may enroll in college courses while still enrolled in high school. Students are not required to apply for admission to the college in order to participate. Value - Label 1 - Yes 0 - No - 1 - Dont know - 2 - Not applicable | VARCHAR2 | 2 |
| SPEC_OPS_DUAL_ENROLLMENT_DESC | Special learning opportunities - Dual enrollment (description) | VARCHAR2 | 75 |
| SPEC_OPS_NONE_CODE | Special learning opportunities - None of the listed options available (code) Institution does not have any of the following special learning opportunities: Accelerated programs, Cooperative (work study), Distance learning, Dual enrollment, ROTC, Study abroad, Weekend college, or Teacher certification (below the postsecondary level). Value - Label 1 - Yes 0 - No - 1 - Dont know - 2 - Not applicable | VARCHAR2 | 2 |
| SPEC_OPS_NONE_DESC | Special learning opportunities - None of the listed options available (description) | VARCHAR2 | 75 |
| SPEC_OPS_ROTC_AIR_FORCE_CODE | Special learning opportunities - ROTC (Air Force) programs (code) Value - Label 1 - Yes 0 - No - 1 - Dont know - 2 - Not applicable | VARCHAR2 | 2 |
| SPEC_OPS_ROTC_AIR_FORCE_DESC | Special learning opportunities - ROTC (Air Force) programs (description) | VARCHAR2 | 75 |
| SPEC_OPS_ROTC_ARMY_CODE | Special learning opportunities - ROTC (Army) programs (code) Value - Label 1 - Yes 0 - No - 1 - Dont know - 2 - Not applicable | VARCHAR2 | 2 |
| SPEC_OPS_ROTC_ARMY_DESC | Special learning opportunities - ROTC (Army) programs (description) | VARCHAR2 | 75 |
| SPEC_OPS_ROTC_CODE | Special learning opportunities - ROTC programs (code) Value - Label 1 - Yes 0 - No - 1 - Dont know - 2 - Not applicable | VARCHAR2 | 2 |
| SPEC_OPS_ROTC_DESC | Special learning opportunities - ROTC programs (description) | VARCHAR2 | 75 |
| SPEC_OPS_ROTC_NAVY_CODE | Special learning opportunities - ROTC (Navy) programs (code) Value - Label 1 - Yes 0 - No - 1 - Dont know - 2 - Not applicable | VARCHAR2 | 2 |
| SPEC_OPS_ROTC_NAVY_DESC | Special learning opportunities - ROTC (Navy) programs (description) | VARCHAR2 | 75 |
| SPEC_OPS_STUDY_ABROAD_CODE | Special learning opportunities - Study abroad programs (code) STUDY ABROAD - Arrangement by which a student completes part of the college program studying in another country. Can be at a campus abroad or through a cooperative agreement with some other U.S. college or an institution of another country. Value - Label 1 - Yes 0 - No - 1 - Dont know - 2 - Not applicable | VARCHAR2 | 2 |
| SPEC_OPS_STUDY_ABROAD_DESC | Special learning opportunities - Study abroad programs (description) | VARCHAR2 | 75 |
| SPEC_OPS_TCH_CERT_EX_SPEC_CODE | Special learning opportunities - Teacher certification external specializations (code) Teacher certification (below postsecondary) programs are offered by the institution such that students must complete their preparation at another institution for certain areas of specialization. Teacher certification refers to pre-K through 12.TEACHER CERTIFICATION - Program designed to prepare students to meet the requirements for certification as teachers in elementary, middle/junior high, and secondary schools. Value - Label 1 - Yes 0 - No - 1 - Dont know - 2 - Not applicable | VARCHAR2 | 2 |
| SPEC_OPS_TCH_CERT_EX_SPEC_DESC | Special learning opportunities - Teacher certification external specializations (description) | VARCHAR2 | 75 |
| SPEC_OPS_TCH_CERT_SPECIAL_CODE | Special learning opportunities - Teacher certification specializations (code) Teacher certification (below postsecondary) programs are offered by the institution such that students can complete their preparation in certain areas of specialization. Teacher certification refers to pre-K through 12. TEACHER CERTIFICATION - Program designed to prepare students to meet the requirements for certification as teachers in elementary, middle/junior high, and secondary schools. Value - Label 1 - Yes 0 - No - 1 - Dont know - 2 - Not applicable | VARCHAR2 | 2 |
| SPEC_OPS_TCH_CERT_SPECIAL_DESC | Special learning opportunities - Teacher certification specializations (description) | VARCHAR2 | 75 |
| SPEC_OPS_TCH_CERT_ST_APPR_CODE | Special learning opportunities - Teacher certification with State cert/license approval (code) Teacher certification (below postsecondary) programs are offered by the institution such that this institution is approved by the state for the initial certification or licensure of teachers. Teacher certification refers to pre-K through 12. TEACHER CERTIFICATION - Program designed to prepare students to meet the requirements for certification as teachers in elementary, middle/junior high, and secondary schools. Value - Label 1 - Yes 0 - No - 1 - Dont know - 2 - Not applicable | VARCHAR2 | 2 |
| SPEC_OPS_TCH_CERT_ST_APPR_DESC | Special learning opportunities - Teacher certification with State cert/license approval (description) | VARCHAR2 | 75 |
| SPEC_OPS_TEACHER_CERT_CODE | Special learning opportunities - Teacher certification (below postsecondary) programs (code) Teacher certification refers to pre-K through 12.TEACHER CERTIFICATION - Program designed to prepare students to meet the requirements for certification as teachers in elementary, middle/junior high, and secondary schools. Value - Label 1 - Yes 0 - No - 1 - Dont know - 2 - Not applicable | VARCHAR2 | 2 |
| SPEC_OPS_TEACHER_CERT_DESC | Special learning opportunities - Teacher certification (below postsecondary) programs (description) | VARCHAR2 | 75 |
| SPEC_OPS_WEEKEND_COLLEGE_CODE | Special learning opportunities - Weekend college programs (code) WEEKEND COLLEGE - A program that allows students to take a complete course of study and attend classes only on weekends. Value - Label 1 - Yes 0 - No - 1 - Dont know - 2 - Not applicable | VARCHAR2 | 2 |
| SPEC_OPS_WEEKEND_COLLEGE_DESC | Special learning opportunities - Weekend college programs (description) | VARCHAR2 | 75 |
| SPEC_OPS_WORK_STUDY_CODE | Special learning opportunities - Cooperative (work-study) programs (code) COOPERATIVE (WORK-STUDY PLAN) PROGRAM - A program that provides for alternate class attendance and employment in business, industry, or government. Value - Label 1 - Yes 0 - No - 1 - Dont know - 2 - Not applicable | VARCHAR2 | 2 |
| SPEC_OPS_WORK_STUDY_DESC | Special learning opportunities - Cooperative (work-study) programs (description) | VARCHAR2 | 75 |
| STUD_SERV_ACAD_COUNSELING_CODE | Selected student services - Academic/career counseling (code) Value - Label 1 - Yes 0 - implied no - 1 - {Not reported} - 2 - {Item not applicable} | VARCHAR2 | 2 |
| STUD_SERV_ACAD_COUNSELING_DESC | Selected student services - Academic/career counseling (description) | VARCHAR2 | 75 |
| STUD_SERV_CAMPUS_DAYCARE_CODE | Selected student services - On-campus day care for children of students (code) Value - Label 1 - Yes 0 - implied no - 1 - {Not reported} - 2 - {Item not applicable} | VARCHAR2 | 2 |
| STUD_SERV_CAMPUS_DAYCARE_DESC | Selected student services - On-campus day care for children of students (description) Value - Label 1 - Yes 0 - implied no - 1 - {Not reported} - 2 - {Item not applicable} | VARCHAR2 | 75 |
| STUD_SERV_EMPLOYMENT_SERV_CODE | Selected student services - Employment services for current students (code) Value - Label 1 - Yes 0 - implied no - 1 - {Not reported} - 2 - {Item not applicable} | VARCHAR2 | 2 |
| STUD_SERV_EMPLOYMENT_SERV_DESC | Selected student services - Employment services for current students (description) | VARCHAR2 | 75 |
| STUD_SERV_NONE_CODE | Selected student services - None of the listed options available (code) Value - Label 1 - Yes 0 - implied no - 1 - {Not reported} - 2 - {Item not applicable} | VARCHAR2 | 2 |
| STUD_SERV_NONE_DESC | Selected student services - None of the listed options available (description) | VARCHAR2 | 75 |
| STUD_SERV_PLACEMENT_SERV_CODE | Selected student services - Placement services for program completers (code) Value - Label 1 - Yes 0 - implied no - 1 - {Not reported} - 2 - {Item not applicable} | VARCHAR2 | 2 |
| STUD_SERV_PLACEMENT_SERV_DESC | Selected student services - Placement services for program completers (description) Value - Label 1 - Yes 0 - implied no - 1 - {Not reported} - 2 - {Item not applicable} | VARCHAR2 | 75 |
| STUD_SERV_REMEDIAL_SERV_CODE | Selected student services - Remedial services (code) Value - Label 1 - Yes 0 - implied no - 1 - {Not reported} - 2 - {Item not applicable} | VARCHAR2 | 2 |
| STUD_SERV_REMEDIAL_SERV_DESC | Selected student services - Remedial services (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 |
| YRS_COLLEGE_ADMIT_PREREQ_CODE | Years of college as admission prerequisite (code) Years of completed college-level work required for entrance to an institution not offering a full 4-year program of study at the undergraduate level. Value - Label 1 - One 2 - Two 3 - Three 4 - Four 5 - Five 6 - Six 7 - Seven 8 - Eight 0 - -2 - {Item not applicable} | VARCHAR2 | 2 |
| YRS_COLLEGE_ADMIT_PREREQ_DESC | Years of college as admission prerequisite (description) | VARCHAR2 | 75 |
e-mail aaude-warehouse@mit.edu | Warehouse home | AAUDE home