|
|
|
IPEDS IC EDUCATIONAL OFFERING
IPEDS intitution characteristics on types of educational offering. This table contains information about the different types of educational offerings, which include academic, continuing professional, occupational, recreational, remedial, and secondary (high school)programs offered by each 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 |
| 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 |
| PROG_ED_OFFR_ACADEMIC_CODE | Types of educational offerings - Academic (code) Type of instruction/program offered by institution. Academic, leading to a certificate, degree, or diploma. Value - Label 1 - Yes 0 - implied no - 2 - {Item not applicable} | VARCHAR2 | 2 |
| PROG_ED_OFFR_ACADEMIC_DESC | Types of educational offerings - Academic (description) | VARCHAR2 | 75 |
| PROG_ED_OFFR_CONT_PROF_CODE | Types of educational offerings - Continuing professional (code) Type of instruction/program offered by institution. Continuing professional (postbaccalaureate only). Value - Label 1 - Yes 0 - implied no - 2 - {Item not applicable} | VARCHAR2 | 2 |
| PROG_ED_OFFR_CONT_PROF_DESC | Types of educational offerings - Continuing professional (description) | VARCHAR2 | 75 |
| PROG_ED_OFFR_OCCUPATIONAL_CODE | Types of educational offerings - Occupational (code) Type of instruction/program offered by institution. Occupational, may lead to a certificate, degree, or other formal award. Value - Label 1 - Yes 0 - implied no - 2 - {Item not applicable} | VARCHAR2 | 2 |
| PROG_ED_OFFR_OCCUPATIONAL_DESC | Types of educational offerings - Occupational (description) | VARCHAR2 | 75 |
| PROG_ED_OFFR_RECREATIONAL_CODE | Types of educational offerings - Recreational or avocational (code) Type of instruction/program offered by institution. Recreational or avocational (leisure) programs. Value - Label 1 - Yes 0 - implied no - 2 - {Item not applicable} | VARCHAR2 | 2 |
| PROG_ED_OFFR_RECREATIONAL_DESC | Types of educational offerings - Recreational or avocational (description) | VARCHAR2 | 75 |
| PROG_ED_OFFR_REMEDIAL_CODE | Types of educational offerings - Basic or remedial (code) Type of instruction/program offered by institution. Adult basic or remedial instruction or high school equivalency. Value - Label 1 - Yes 0 - implied no - 2 - {Item not applicable} | VARCHAR2 | 2 |
| PROG_ED_OFFR_REMEDIAL_DESC | Types of educational offerings - Basic or remedial (description) | VARCHAR2 | 75 |
| PROG_ED_OFFR_SECONDARY_CODE | Types of educational offerings - Secondary (code) Type of instruction/program offered by institution.Secondary (high school). Value - Label 1 - Yes 0 - implied no - 2 - {Item not applicable} | VARCHAR2 | 2 |
| PROG_ED_OFFR_SECONDARY_DESC | Types of educational offerings - Secondary (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