Guide to the IR Indicators for Core 40, Academic Honors, and 21st Century Scholars

Last Update: 2/27/2009

Overview

The Indiana Commission for Higher Education (ICHE) requires Indiana universities to indicate annually which of their Hoosier students completed a high school Core 40 or Academic Honors diploma. The Commission also requests a list of students who have been part of the 21st Century Scholars program, regardless of whether they receive a 21st Century Scholarship from the State Student Assistance Commission of Indiana (SSACI).

Besides these three indicators for ICHE, IR receives ad hoc requests for summary or student-level reports of 21st Century Scholarship recipients.

To meet the reporting needs for ICHE, IR has created the following three indicators, by students’ University IDs:

Column Name / Alternate Column Name / Description / Valid Values
IR_ACAD_HONORS_DIPLOMA / IR_ACAD_HON_DPLM_IND / IR indicator of whether an Indiana high school graduate completed an Academic Honors Diploma. / Y or null
IR_CORE_40_DIPLOMA / IR_CORE_DPLM_IND / IR indicator of whether an Indiana high school graduate completed a Core 40 Diploma. / Y or null
IR_21ST_CENTURY_SCHOLAR / IR_TCNT_HIST_PTCPN_IND / IR indicator of whether the student was historically associated with the 21st Scholars program. Note that this does not indicate if a student is receiving a 21st Century Scholars Grant. / Y or null

These indicators exist on the following tables and views:

DSS_RDS.IR_SSACICAT_ST (IR source table)

DSS_RDS.SR_STU_TERM_GT

DSS_RDS.IR_CEN_TRM_SNPSHT_GT

DSS_RDS.IR_STU_DEGR_SNPSHT_GT

DSS_RDS.IR_ADM_SNPSHT_ST

DSS_RDS.IR_ADM_SNPSHT_PRLM_ST

In addition to these indicators, IR has also created an indicator (valid value = Y) for students who received a 21st Century Scholarship (IR_TCNT_AWD_RCPT_IND). These data are available by student, campus, and academic term. This indicator is scheduled to be made available on the following tables and views:

DSS_RDS.IR_TCNT_AWD_RCPT_ST (IR source table)

DSS_RDS.SR_STU_TERM_GT

DSS_RDS.IR_CEN_TRM_SNPSHT_GT

DSS_RDS.IR_STU_DEGR_SNPSHT_GT

DSS_RDS.IR_ADM_SNPSHT_ST

DSS_RDS.IR_ADM_SNPSHT_PRLM_ST

Here are the years when students in these categories first attended IU as degree-seeking students:

Program / First IU Freshman Class in this Program
Academic Honors Diploma / Summer/Fall 1988
21st Century Scholars / Summer/Fall 1995
Core 40 Diploma / Summer/Fall 1998

Items to Note

·  The data we have on the indicators for ICHE is most complete for fall 1998 and later beginners. Data for students who received 21st Century Scholarships extends back to fall 2004.

·  University Reporting and Research (URR) will routinely review the records to ensure that the indicators are applied to the correct students. In rare cases, URR staff may change an indicator from Y to blank if an indicator was applied in error to a student’s record in SR Student Term. URR keeps an historical list of these cases.

·  Throughout the year, students’ indicators for ICHE are updated by IU admissions and financial aid staff, based on updated high school transcripts and new data from SSACI. As a result, a student may have an indicator of Y on one day, with this being changed to N on a subsequent date. SR_STU_TERM is updated nightly to indicate the most current information we have.

·  The indicators for Academic Honors and Core 40 are not mutually exclusive; some students have both indicators. When reporting to ICHE, URR reports all students with the indicator IR_ACAD_HONORS_DIPLOMA as Academic Honors Diploma students. When reporting Core 40 students as a separate population to ICHE, we only include students who lack an IR_ACAD_HONORS_DIPLOMA indicator, and who have the indicator IR_CORE_40_DIPLOMA. This logic can also be used to get an unduplicated count of students with either one of these diplomas.

Data Sources

The data for the ICHE indicators come from 3 sources:

  1. Admissions Recruiting Categories for each program (AHON, CORE, TCNT). These can be found in DSS.ADM_APPL_CAT_ST. The IR indicators are populated from the PeopleSoft base table ODS_PSE.PS_ADM_APPL_RCR_CA.
  1. Financial Aid SSACI Table indicators for each program. These can be found in DSS_RDS.FA_SSACI_ST, indicated by a Y in each column. The IR indicators are populated from the PeopleSoft base table ODS_PSE.PS_IU_SSACI_DATA.
  1. Legacy files from IUIS from the IR archives. Those data sources included the Additional Info (Special Progams) codes (AH, CF, CS) from the IUIS tables ADMSFILE and ADMHIST, as well as the program indicators in the IUIS table SSACICAT.

The data for the indicator of 21st Century Scholarship recipients represent disbursed awards in DSS_RDS.SF_ITM_GT.

For More Information

Contact our office using the Contact Us link on our website: www.indiana.edu/~upira .

…\Reports_Public\Financial aid\SSACI_Analysis\IR_SSACICAT_ST\Documentation\IR_Core40_AcadHonors_21century_Indicators.doc Page 3 of 3