Overview

Starting with the fall 2018 first day of classes snapshot, UIRR will offer different sets of data for reporting student headcounts geographically in the Census Snapshot table (IR_CEN_TRM_SNPSHT_GT) or the IR Admissions Snapshot table (IR_ADM_SNPSHT_PRLM_AUD_GT). Each set of fields is designed to meet one of these purposes:

  1. Country of Origin
    1. Purpose: This is the basis for UIRR’s enrollment geographic reports of students’ country of origin. The goal is to represent the breadth of student geographic origins by country (e.g. Nicaragua), region (e.g. Latin America), sub-continent (e.g. Central America/Mexico), and continent (e.g. North America).
    2. Definition: If the student has a record with IU International Services, then this represents the country of origin maintained by their office for the student. For example, if a naturalized U.S. citizen lived in Indiana for most of their life and originated from Nicaragua, UIRR would report this U.S. citizen’s country of origin as Nicaragua. Students with no record with International Services are reported by default with the U.S. as their country of origin.
    3. UIRR reports:
    4. Caveats:
      • This is not to be used for international student reporting. Instead, use the reporting ethnicity columns with a value of “non-resident alien” (NR-Alien) for that purpose. See this IR Data Guide for more information:
        1. uirr.iu.edu/resources/ir-data-guides/ > Reporting Ethnicity and International
      • Certain countries may have multiple names. If two students from the same country have their country coded with different country codes, UIRR reports these under a single name (e.g. Myanmar and Burma are reported as Myanmar). See the appendix below for a list of these cases.
  2. Admission home state and Indiana home county as of the student’s first IU enrollment by career
    1. Purpose: This is the basis for UIRR’s enrollment geographic reports of students’ admission home state and Indiana county. It is also used for UIRR admissions geographic reporting.
    2. Definition: This is the student’s admission home address at the point when the student first enrolled at IU in a particular combination of academic career and degree-seeking status (degree-seeking or non-degree). For example, if a student first enrolled as a non-degree undergraduate on 7/15/2016, the admission home address that was effective on 7/15/2016 would be displayed on student term rows with non-degree undergraduate enrollment. Then, if that same student first enrolled as a degree-seeking undergraduate on 6/20/2018, the admission home address that was effective on 6/20/2018 would be displayed on student term rows with degree-seeking undergraduate enrollment. See the following IR Data Guide for additional information:
    3. UIRR reports:
    4. Caveats:
      • In the UIRR Enrollment Summary Tool, students with a country of origin other than U.S. are excluded from the headcounts of students by U.S. home state and Indiana home county. In other words, a naturalized U.S. citizen who lived most of their life in Monroe County, Indiana, would not be listed under Indiana or an Indiana county, but instead only under their country of origin.
      • In the UIRR Admissions Point-in-Cycle report, the country of origin is not used, and geographic reporting is based solely on the admissions home address data, as described above.
      • If an admission home address was not on file at the time of first enrollment at IU, this field is populated with one of these other address types from the time of first enrollment, selected in the following sequence: mailing address, home address, then local address.
  3. Current address as of a particular snapshot
    1. Purpose: This is primarily to indicate the student’s residential location when reporting online student headcounts, particularly students whose classes are part of the Online Course Connect program.
    2. Definition: The current address fields include the country, state, postal code, and Indiana county where applicable. A student’s current address is selected from one of these types of addresses in the SIS, in the following order:
      • Local Address
      • Student Housing Address
      • Admissions Home Address
      • Mailing Address
    3. UIRR Reports:
    4. Office of Online Education reports:
    5. Caveats:
      • The UIRR census snapshot table (IR_CEN_TRM_SNPSHT_GT) captures the current address for all enrolled students, including those who are not enrolled in online programs or distance education classes.
      • Certain countries may have multiple names. If two students from the same country have their country coded with different country codes, UIRR reports these under a single name (e.g. Myanmar and Burma are reported as Myanmar). See the appendix below for a list of these cases.
      • Note that the logic for this field matches the following table and field: PSE_PRSN_ADDR_ST.PRSN_DRV_FA2_ADDR_KEY
  4. Indicator of whether a student is from the Indiana county service region for the student’s campus
    1. Purpose: This yes-no flag indicates if a student’s Indiana home county (see the description above) is within the service region of the campus where the student is enrolled. Note that there are instances where two campuses share the same service region county. For example, both the Kokomo and South Bend campuses serve students from Fulton County.
    2. Definition: The associations between IU campuses and Indiana counties for IR reporting by service region is maintained by UIRR. These associations are listed in Appendix 2 below.
    3. UIRR Reports:
    4. Caveats:
      • Service-region reporting is done for all IU campuses other than Bloomington.
      • UIRR reports admissions headcounts by Indiana county service region regardless of a student’s country of origin. For example, a naturalized U.S. citizen with an Indiana home county of Fulton and enrolled at Kokomo would be reported as within the service region, regardless of the student’s country of origin.

Tables and Columns

Here is a summary of the tables and columns with data used for each of the four purposes listed above:

  1. Country of Origin
    1. Table: IR_CEN_TRM_SNPSHT_GT
      • Columns:
        1. PRSN_2ND_CTZN_CNTRY_CD (see the next field for the corresponding country name)
        2. STU_DRVD_GEO_CNTRY_NM
        3. STU_DRVD_GEO_REGION_NM
        4. STU_DRVD_GEO_SUBREGION_NM
        5. STU_DRVD_GEO_CONTINENT_NM
        6. STU_DRVD_GEO_TYP_NM
        7. STU_DRVD_GEO_NM
    2. Table: IR_ADM_SNPSHT_PRLM_AUD_ST
      • Columns:
        1. PRSN_2ND_CTZN_CNTRY_CD
        2. PRSN_2ND_CTZN_CNTRY_NM
  2. Admission Home Country, State, Postal Code and Indiana Home County
    1. Table: IR_CEN_TRM_SNPSHT_GT
      • Columns:
        1. PRSN_ADMT_HM_CNTY_CD
        2. PRSN_ADMT_HM_CNTY_NM
        3. PRSN_ADMT_HM_ST_CD
        4. PRSN_ADMT_HM_ST_NM
        5. PRSN_ADMT_HM_ZIP_CD
        6. PRSN_ADMT_HM_CNTRY_CD
        7. PRSN_ADMT_HM_CNTRY_NM
    2. Table: IR_ADM_SNPSHT_PRLM_AUD_ST
      • Columns:
        1. PRSN_ADMT_HM_CNTY_CD
        2. PRSN_ADMT_HM_CNTY_NM
        3. PRSN_ADMT_HM_ST_CD
        4. PRSN_ADMT_HM_ST_NM
        5. PRSN_ADHM_ZIP_CD
        6. PRSN_ADDR_ADHM_CNTRY_CD
        7. PRSN_ADDR_ADHM_CNTRY_NM
  3. Current Address as of the Snapshot
    1. Table: IR_CEN_TRM_SNPSHT_GT
      • Columns:
        1. STU_DRV_CUR_ADDR_CNTRY_CD
        2. STU_DRV_CUR_ADDR_CNTRY_NM
        3. STU_DRV_CUR_ADDR_ST_CD
        4. STU_DRV_CUR_ADDR_ST_NM
        5. STU_DRV_CUR_ADDR_IN_CNTY_CD
        6. STU_DRV_CUR_ADDR_IN_CNTY_NM
        7. STU_DRV_CUR_ADDR_ZIP_CD
  4. Country Crosswalks
    1. Table: IR_CNTRY_MAP_T
      • This table indicates how country codes for the same country are reported under a single country (e.g. Myanmar and Burma are reported as Myanmar).
    2. Table: IR_GEO_REGN_T
      • This table associates countries with regions, sub-continents, and continents.
  5. Indiana County Service Region Indicator
    1. Tables: IR_CEN_TRM_SNPSHT_GT and IR_ADM_SNPSHT_PRLM_AUD_ST
      • Column: STU_CNTY_SRVC_RGN_IND (Y or N)
    2. Table: IR_IN_CNTY_SRVC_RGN_T
      • This table associates each IU campus (except Bloomington) with the Indiana county codes in that campus’ service region. Note that Indiana county code descriptions are found in PSE_CNTY_CD_GT.

See also the following Excel file on the UIRR IR Data Guide website where each column mentioned above is described:

Appendix 1: Country Crosswalks Values from IR_CNTRY_MAP_T

Source Country Code Source Country Derived Reporting Country
BMA Burma Myanmar
MMR Myanmar Myanmar
SRB Republic of Serbia Republic of Serbia
SCG Serbia and Montenegro Republic of Serbia
ENG England United Kingdom
NIR Northern Ireland United Kingdom
SCT Scotland United Kingdom
GBR United Kingdom United Kingdom
WAL Wales United Kingdom

Appendix 2: Campus Service Region Counties from IR_IN_CNTY_SRVC_RGN_T

INST_CD COUNTY_CD COUNTY_DESC INST_CD COUNTY_CD COUNTY_DESC
IUCOA 03 Bartholomew IUKOA 08 Carroll
IUCOA 16 Decatur IUKOA 09 Cass
IUCOA 36 Jackson IUKOA 12 Clinton
IUCOA 40 Jennings IUKOA 25 Fulton
IUCOA 69 Ripley IUKOA 27 Grant
IUEAA 15 Dearborn IUKOA 29 Hamilton
IUEAA 16 Decatur IUKOA 34 Howard
IUEAA 21 Fayette IUKOA 52 Miami
IUEAA 24 Franklin IUKOA 80 Tipton
IUEAA 33 Henry IUKOA 85 Wabash
IUEAA 58 Ohio IUNWA 37 Jasper
IUEAA 68 Randolph IUNWA 45 Lake
IUEAA 69 Ripley IUNWA 46 La Porte
IUEAA 70 Rush IUNWA 56 Newton
IUEAA 81 Union IUNWA 64 Porter
IUEAA 89 Wayne IUSBA 20 Elkhart
IUFTW 01 Adams IUSBA 25 Fulton
IUFTW 02 Allen IUSBA 43 Kosciusko
IUFTW 17 De Kalb IUSBA 44 La Grange
IUFTW 35 Huntington IUSBA 46 La Porte
IUFTW 44 La Grange IUSBA 50 Marshall
IUFTW 57 Noble IUSBA 71 St Joseph
IUFTW 76 Steuben IUSBA 75 Starke
IUFTW 90 Wells IUSEA 10 Clark
IUSEA 13 Crawford IUSEA 22 Floyd
IUSEA 07 Brown IUSEA 31 Harrison
IUSEA 30 Hancock IUSEA 39 Jefferson
IUSEA 32 Hendricks IUSEA 59 Orange
IUSEA 41 Johnson IUSEA 62 Perry
IUSEA 49 Marion IUSEA 72 Scott
IUSEA 55 Morgan IUSEA 78 Switzerland
IUSEA 73 Shelby IUSEA 88 Washington