|
|
|
IPEDS IC AWARD LEVEL
IPEDS institution characteristics on award levels. This table contains information about the types and levels of certificates/awards/degrees offered by the 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 |
| AWD_LVL_1YR_BUT_NOT_2YR_CODE | Institution offers a postsecondary award, certificate, or diploma program of at least one but less than two academic years (code) Value - Label 1 - Yes 0 - implied no -1 - {Not reported} -2 - {Item not applicable} | VARCHAR2 | 2 |
| AWD_LVL_1YR_BUT_NOT_2YR_DESC | Institution offers a postsecondary award, certificate, or diploma program of at least one but less than two academic years (description) | VARCHAR2 | 75 |
| AWD_LVL_2YR_BUT_NOT_4YR_CODE | Institution offers a postsecondary award, certificate, or diploma program of at least two but less than four academic years (code) Value - Label 1 - Yes 0 - implied no -1 - {Not reported} -2 - {Item not applicable} | VARCHAR2 | 2 |
| AWD_LVL_2YR_BUT_NOT_4YR_DESC | Institution offers a postsecondary award, certificate, or diploma program of at least two but less than four academic years (description) | VARCHAR2 | 75 |
| AWD_LVL_ASSOCIATES_DEGREE_CODE | Institution offers an Associates degree (code) Value - Label 1 - Yes 0 - implied no -1 - {Not reported} -2 - {Item not applicable} | VARCHAR2 | 2 |
| AWD_LVL_ASSOCIATES_DEGREE_DESC | Institution offers an Associates degree (description) | VARCHAR2 | 75 |
| AWD_LVL_BACHELORS_DEGREE_CODE | Institution offers a Bachelors degree or equivalent (code) Value - Label 1 - Yes 0 - implied no -1 - {Not reported} -2 - {Item not applicable} | VARCHAR2 | 2 |
| AWD_LVL_BACHELORS_DEGREE_DESC | Institution offers a Bachelors degree or equivalent (description) | VARCHAR2 | 75 |
| AWD_LVL_DOCTORS_DEGREE_CODE | Institution offers a Doctors degree (code) Value - Label 1 - Yes 0 - implied no -1 - {Not reported} -2 - {Item not applicable} | VARCHAR2 | 2 |
| AWD_LVL_DOCTORS_DEGREE_DESC | Institution offers a Doctors degree (description) | VARCHAR2 | 75 |
| AWD_LVL_FIRST_PROF_CERT_CODE | Institution offers a First-professional certificate (post-degree) (code) Value - Label 1 - Yes 0 - implied no -1 - {Not reported} -2 - {Item not applicable} | VARCHAR2 | 2 |
| AWD_LVL_FIRST_PROF_CERT_DESC | Institution offers a First-professional certificate (post-degree) (description) | VARCHAR2 | 75 |
| AWD_LVL_FIRST_PROF_DEGREE_CODE | Institution offers a First-professional degree (code) Value - Label 1 - Yes 0 - implied no -1 - {Not reported} -2 - {Item not applicable} | VARCHAR2 | 2 |
| AWD_LVL_FIRST_PROF_DEGREE_DESC | Institution offers a First-professional degree (description) | VARCHAR2 | 75 |
| AWD_LVL_LESS_THAN_1YR_CODE | Institution offers a postsecondary award, certificate, or diploma program of less than one academic year (code) Value - Label 1 - Yes 0 - implied no -1 - {Not reported} -2 - {Item not applicable} | VARCHAR2 | 2 |
| AWD_LVL_LESS_THAN_1YR_DESC | Institution offers a postsecondary award, certificate, or diploma program of less than one academic year (description) | VARCHAR2 | 75 |
| AWD_LVL_MASTERS_DEGREE_CODE | Institution offers a Masters degree (code) Value - Label 1 - Yes 0 - implied no -1 - {Not reported} -2 - {Item not applicable} | VARCHAR2 | 2 |
| AWD_LVL_MASTERS_DEGREE_DESC | Institution offers a Masters degree (description) | VARCHAR2 | 75 |
| AWD_LVL_OTHER_CODE | Institution offers another level award (code) Value - Label 1 - Yes 0 - implied no -1 - {Not reported} -2 - {Item not applicable} | VARCHAR2 | 2 |
| AWD_LVL_OTHER_DESC | Institution offers another level award (description) | VARCHAR2 | 75 |
| AWD_LVL_POST_BACCAL_CERT_CODE | Institution offers Post-baccalaureate certification (code) Value - Label 1 - Yes 0 - implied no -1 - {Not reported} -2 - {Item not applicable} | VARCHAR2 | 2 |
| AWD_LVL_POST_BACCAL_CERT_DESC | Institution offers Post-baccalaureate certification (description) | VARCHAR2 | 75 |
| AWD_LVL_POST_MASTERS_CERT_CODE | Institution offers Post-masters certification (code) Value - Label 1 - Yes 0 - implied no -1 - {Not reported} -2 - {Item not applicable} | VARCHAR2 | 2 |
| AWD_LVL_POST_MASTERS_CERT_DESC | Institution offers Post-masters certification (description) | VARCHAR2 | 75 |
| FOPNA_IS_GRADUATE_CODE | Institution offers a formally organized graduate program (either academic or occupational) with well defined completion requirements that does not lead to a formal award (code) Value - Label 1 - Yes 2 - No 0 - implied no -1 - {Not reported} -2 - {Item not applicable} -3 - {Not available} -4 - {Implied yes} | VARCHAR2 | 2 |
| FOPNA_IS_GRADUATE_DESC | Institution offers a formally organized graduate program (either academic or occupational) with well defined completion requirements that does not lead to a formal award (description) | VARCHAR2 | 75 |
| FOPNA_IS_UNDERGRADUATE_CODE | Institution offers a formally organized undergraduate program (either academic or occupational) with well defined completion requirements that does not lead to a formal award (code) Value - Label 1 - Yes 2 - No 0 - implied no -1 - {Not reported} -2 - {Item not applicable} -3 - {Not available} -4 - {Implied yes} | VARCHAR2 | 2 |
| FOPNA_IS_UNDERGRADUATE_DESC | Institution offers a formally organized undergraduate program (either academic or occupational) with well defined completion requirements that does not lead to a formal award (description) | VARCHAR2 | 75 |
| FORMAL_ORG_PROG_NO_AWARD_CODE | Institution offers a formally organized program (either academic or occupational) with well defined completion requirements that does not lead to a formal award (code) Value - Label 1 - Yes 2 - No 0 - implied no -1 - {Not reported} -2 - {Item not applicable} -3 - {Not available} -4 - {Implied yes} | VARCHAR2 | 2 |
| FORMAL_ORG_PROG_NO_AWARD_DESC | Institution offers a formally organized program (either academic or occupational) with well defined completion requirements that does not lead to a formal award (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 |
| 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