Reporting of Student Geographic Data

a. Purpose: This is the basis for IA’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).
b. 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, IA 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.

c. IA reports:

i. Enrollment Summary Tool (See the Tableau report tabs labeled Geo)

1. https://iuia.iu.edu/finding-data/enrollment/index.html > Official/First Day Headcounts and Hours

d. Caveats:

i. 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. https://iuia.iu.edu/finding-data/ir-data-guides/index.html > Reporting Ethnicity and International

ii. Certain countries may have multiple names. If two students from the same country have their country coded with different country codes, IA reports these under a singlename (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

a. Purpose: This is the basis for IA’s enrollment geographic reports of students’ admission home state and Indiana county. It is also used for IA admissions geographic reporting.
b. 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 (degreeseeking 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:
i. https://iuia.iu.edu/finding-data/ir-data-guides/index.html > IR Admit Term_Admit Type_Admit Address.doc
c. IA reports:

i. Enrollment Summary Tool (See the Tableau report tabs labeled Geo)

1. https://iuia.iu.edu/finding-data/enrollment/index.html > Official/First Day Headcounts and Hours

ii. Admissions Point-in-Cycle Report (See the Tableau report tab labeled Geo)

1. https://iuia.iu.edu/finding-data/admissions/pointincycle/index.html Reporting of Student Geographic Data

d. Caveats:

i. In the IA 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.
ii. In the IA 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.
iii. 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

a. 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.
b. 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:

i. Local Address
ii. Student Housing Address
iii. Admissions Home Address
iv. Mailing Address

c. IA Reports:

i. https://iuia.iu.edu/compliance-reports/ipeds/index.html > Fall Enrollment > Fall Enrollment by Distance
Education Status

d. Office of Online Education reports:

i. ooe.iu.edu/resources/reports.html

e. Caveats:

i. The IA 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.
ii. Certain countries may have multiple names. If two students from the same country have their country coded with different country codes, IA 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.
iii. 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

 a. 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.
b. Definition: The associations between IU campuses and Indiana counties for IR reporting by service region is maintained by IA. These associations are listed in Appendix 2 below.
c. IA Reports:

i. Indiana High Schools to IU Campuses

1. IA.iu.edu/facts-figures/admissions/high-school/

d. Caveats:

i. Service-region reporting is done for all IU campuses other than Bloomington.
ii. IA 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

a. Table: IR_CEN_TRM_SNPSHT_GT

i. 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

b. Table: IR_ADM_SNPSHT_PRLM_AUD_ST

i. Columns:

1. PRSN_2ND_CTZN_CNTRY_CD
2. PRSN_2ND_CTZN_CNTRY_NM

2. Admission Home Country, State, Postal Code and Indiana Home County

a. Table: IR_CEN_TRM_SNPSHT_GT

i. 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

b. Table: IR_ADM_SNPSHT_PRLM_AUD_ST

i. 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

a. Table: IR_CEN_TRM_SNPSHT_GT

i. 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

a. Table: IR_CNTRY_MAP_T

i. 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).

b. Table: IR_GEO_REGN_T

i. This table associates countries with regions, sub-continents, and continents.

5. Indiana County Service Region Indicator

a. Tables: IR_CEN_TRM_SNPSHT_GT and IR_ADM_SNPSHT_PRLM_AUD_ST

i. Column: STU_CNTY_SRVC_RGN_IND (Y or N)

b. Table: IR_IN_CNTY_SRVC_RGN_T

i. 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 IA IR Data Guide website where each column mentioned above is described:

• https://iuia.iu.edu/finding-data/ir-data-guides/index.html > Reporting Student Geographic Data Field List

Appendix 1: Country Crosswalk Values from IR_CNTRY_MAP_T
Source Country Code Source Country Derived Reporting Country