|
|
|
IPEDS IC CONFERENCE ASSOC
IPEDS institution characteristics on conference associations. For a survey year, the table lists each institution's sports conference (eg. NCAA, NSCAA, NAIA) associations.
| 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 |
| MEMBER_ATH_ASSOC_NAIA_CODE | Member of National Association of Intercollegiate Athletics (NAIA) (code) Value - Label 1 - Yes 0 - implied no -1 - {Not reported} -2 - {Item not applicable} -5 - implied no (prior to 2001 survey) | VARCHAR2 | 2 |
| MEMBER_ATH_ASSOC_NAIA_DESC | Member of National Association of Intercollegiate Athletics (NAIA) (description) | VARCHAR2 | 75 |
| MEMBER_ATH_ASSOC_NCAA_CODE | Member of National Collegiate Athletic Association (NCAA) (code) Value - Label 1 - Yes 0 - implied no -1 - {Not reported} -2 - {Item not applicable} -5 - implied no (prior to 2001 survey) | VARCHAR2 | 2 |
| MEMBER_ATH_ASSOC_NCAA_DESC | Member of National Collegiate Athletic Association (NCAA) (description) | VARCHAR2 | 75 |
| MEMBER_ATH_ASSOC_NCCAA_CODE | Member of National Christian College Athletic Association (NCCAA) (code) Value - Label 1 - Yes 0 - implied no -1 - {Not reported} -2 - {Item not applicable} -5 - implied no (prior to 2001 survey) | VARCHAR2 | 2 |
| MEMBER_ATH_ASSOC_NCCAA_DESC | Member of National Christian College Athletic Association (NCCAA) (description) | VARCHAR2 | 75 |
| MEMBER_ATH_ASSOC_NJCAA_CODE | Member of National Junior College Athletic Association (NJCAA) (code) Value - Label 1 - Yes 0 - implied no -1 - {Not reported} -2 - {Item not applicable} -5 - implied no (prior to 2001 survey) | VARCHAR2 | 2 |
| MEMBER_ATH_ASSOC_NJCAA_DESC | Member of National Junior College Athletic Association (NJCAA) (description) | VARCHAR2 | 75 |
| MEMBER_ATH_ASSOC_NSCAA_CODE | Member of National Small College Athletic Association (NSCAA) (code) Value - Label 1 - Yes 0 - implied no -1 - {Not reported} -2 - {Item not applicable} -5 - implied no (prior to 2001 survey) | VARCHAR2 | 2 |
| MEMBER_ATH_ASSOC_NSCAA_DESC | Member of National Small College Athletic Association (NSCAA) (description) | VARCHAR2 | 75 |
| MEMBER_ATH_ASSOC_OTHER_CODE | Member of another national athletic association (code) Value - Label 1 - Yes 0 - implied no -1 - {Not reported} -2 - {Item not applicable} -5 - implied no (prior to 2001 survey) | VARCHAR2 | 2 |
| MEMBER_ATH_ASSOC_OTHER_DESC | Member of another national athletic association (description) | VARCHAR2 | 75 |
| MEMBER_NAT_ATHLETIC_ASSOC_CODE | Member of national athletic association (code) 1 - Yes 2 - No 0 - -1 - {Not reported} - 2 -{Item not applicable} | VARCHAR2 | 2 |
| MEMBER_NAT_ATHLETIC_ASSOC_DESC | Member of national athletic association (description) | VARCHAR2 | 75 |
| NCAA_NAIA_CONF_BASEBALL_CODE | NCAA/NAIA conference number for baseball (code) See NCAA_NAIA_CONF_FOOTBALL_CODE definition for list of codes and conferences. | VARCHAR2 | 3 |
| NCAA_NAIA_CONF_BASEBALL_DESC | NCAA/NAIA conference for baseball (description) | VARCHAR2 | 75 |
| NCAA_NAIA_CONF_BASKETBALL_CODE | NCAA/NAIA conference number for basketball (code) See NCAA_NAIA_CONF_FOOTBALL_CODE definition for list of codes and conferences. | VARCHAR2 | 3 |
| NCAA_NAIA_CONF_BASKETBALL_DESC | NCAA/NAIA conference for basketball (description) | VARCHAR2 | 75 |
| NCAA_NAIA_CONF_CC_TRACK_CODE | NCAA/NAIA conference number for cross country/track (code) See NCAA_NAIA_CONF_FOOTBALL_CODE definition for list of codes and conferences. | VARCHAR2 | 3 |
| NCAA_NAIA_CONF_CC_TRACK_DESC | NCAA/NAIA conference for cross country/track (description) | VARCHAR2 | 75 |
| NCAA_NAIA_CONF_FOOTBALL_CODE | NCAA/NAIA conference number for football (code) Value - Label 100 - Mountain West Conference 101 - America East 102 - Atlantic Coast Conference 103 - Atlantic 10 Conference 104 - Big East Conference 105 - Big Sky Conference 106 - Big South Conference 107 - Big Ten Conference | VARCHAR2 | 3 |
| NCAA_NAIA_CONF_FOOTBALL_DESC | NCAA/NAIA conference for football (description) | VARCHAR2 | 75 |
| NCAA_NAIA_MMB_BASEBALL_CODE | NCAA/NAIA member for baseball (code) Value - Label 1 - Yes 2 - No (implied no, prior to 2002 survey) 0 - No (prior to 2002 survey) -1 - {Not reported} -2 - {Item not applicable} | VARCHAR2 | 2 |
| NCAA_NAIA_MMB_BASEBALL_DESC | NCAA/NAIA member for baseball (description) | VARCHAR2 | 75 |
| NCAA_NAIA_MMB_BASKETBALL_CODE | NCAA/NAIA member for basketball (code) Value - Label 1 - Yes 2 - No (implied no, prior to 2002 survey) 0 - No (prior to 2002 survey) -1 - {Not reported} -2 - {Item not applicable} | VARCHAR2 | 2 |
| NCAA_NAIA_MMB_BASKETBALL_DESC | NCAA/NAIA member for basketball (description) | VARCHAR2 | 75 |
| NCAA_NAIA_MMB_CC_TRACK_CODE | NCAA/NAIA member for cross country/track (code) Value - Label 1 - Yes 2 - No (implied no, prior to 2002 survey) 0 - No (prior to 2002 survey) -1 - {Not reported} -2 - {Item not applicable} | VARCHAR2 | 2 |
| NCAA_NAIA_MMB_CC_TRACK_DESC | NCAA/NAIA member for cross country/track (description) | VARCHAR2 | 75 |
| NCAA_NAIA_MMB_FOOTBALL_CODE | NCAA/NAIA member for football (code) Value - Label 1 - Yes 2 - No (implied no, prior to 2002 survey) 0 - No (prior to 2002 survey) -1 - {Not reported} -2 - {Item not applicable} | VARCHAR2 | 2 |
| NCAA_NAIA_MMB_FOOTBALL_DESC | NCAA/NAIA member for football (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