Home
Finding IR (Test)
Guidelines for Reporting HS Diploma Type

Guidelines for Reporting HS Diploma Type

Beginning undergraduates entering IU in 2009-10 and subsequent years may have one or more of the following high school diploma types:

GED (General Educational Development test) or HSE (Indiana High School Equivalency test)
Indiana Core 40 with Academic Honors (formerly Academic Honors)
Indiana Core 40 with Technical Honors
Indiana Core 40
General Diploma
Diploma Type undeclared or not received

Background

Beginning undergraduates entering IU in 2009-10 and subsequent years may have one or more of the following high school diploma types:

GED (General Educational Development test) or HSE (Indiana High School Equivalency test)
Indiana Core 40 with Academic Honors (formerly Academic Honors)
Indiana Core 40 with Technical Honors
Indiana Core 40
General Diploma
Diploma Type undeclared or not received

Also, the Indiana Commission for Higher Education (ICHE) collected the diploma type for students using these categories in 2009-10 and 2010-11 in the annual SIS file (predecessor to the CHEDSS annual file).

Since students can have various combinations of these “high school diploma types,” and because we need to report students under a single type in our current ad hoc reporting, the guidelines below describe the IA approach.

Also, the column IR_HS_DPLM_TYP_DESC exists in the following report objects with the IR High School Diploma Type descriptions listed above. This column is only populated for students who have a high school external org ID in the PeopleSoft/Oracle External Education table, or who meet the guidelines listed below for one of the three Indiana Core 40 diplomas listed above. Note that this column is populated for historical students (prior to fall 2010) in the data groups marked with an asterisk (*).

PSE_PRSN_ST (*)
IR_CEN_TRM_SNPSHT_GT
IR_STU_DEGR_SNPSHT_ST/GT (available beginning with the degree year 2009-10)
IR_STU_CMPLTN_SNPSHT_GT
IR_TTD_STU_DEGR_SNPSHT_ST
IR_FALL_ENRL_SBSQ_OTCM_GT
IR_ADM_SNPSHT_%
ADM_APPL_GT (*)
ADM_CUR_APPL_GT (*)
IR_FA_ENRL_DEGR_AWD_SUM_GT

References

See the following summary of the Indiana high school diploma types from the Indiana Department of Education:

http://www.doe.in.gov/ccr/indianas-diploma-requirements

Data

IA will continue to use DSS_RDS.IR_SSACICAT_ST[1] to store yes/no indicators for applicants and students with one or more of the following:

Academic Honors (SSACI Academic Honors indicator or the AHON or AHOT recruiting categories).
Core 40 Technical (AHOT or CORT recruiting categories)
Core 40 (SSACI Core 40 indicator or the CORE recruiting category).

Here is a sample record from DSS_RDS.IR_SSACICAT_ST:

PRSN_UNIV_ID	IR_ACAD_HONORS_DIPLOMA	IR_CORE_40_DIPLOMA	IR_COR40_TECH_DPLM_IND
0000337555	Y	N	Y

IA uses these data sources to populate DSS_RDS.IR_SSACICAT_ST:

State Student Assistance Commission of Indiana (SSACI) data table (ODS_PSE.PS_IU_SSACI_DATA)
ICHE Student Financial Aid data table (ODS_PSE.PS_IU_CHE_DATA)
IU Admissions Recruiting Categories table (ODS_PSE.PS_ADM_APPL_RCR_CA)

The Recruiting Categories table may list students under one or more of these recruiting categories:

AHON – Core 40 with Academic Honors
AHOT – Core 40 with Academic Honors and Technical
CORT – Core 40 Technical
CORE – Core 40

In addition, we use the IA last high school data (available in DSS_RDS.PSE_PRSN_ST) as an indicator of GED and HSE recipients, as well as the state where a high school is located. (GED records have a high school description beginning with GED%, and HSE records similarly have a high school description beginning with HSE%.) This data set also provides the HS graduation date, as well as the data source (i.e. self-reported or from the school.)

Reporting

IA will use the following logic for reporting students’ unduplicated high school diploma type. (Note: The International Baccalaureate Diploma is maintained separately and is not included in the unduplicated high school diploma type.):

If the student has a GED or HSE record in the IA last high school data, report the student under GED/HSE.
If the student lacks a GED and an HSE record and meets the following criteria, report the student under Core 40 with Academic Honors:
- The student has an Indiana Academic Honors diploma indicator of Y on DSS_RDS.IR_SSACICAT_ST and

one of the following is true:

The last high school attended is located in Indiana and is not a home school; or
no summary high school information is available in External Education (EXT_SUMM_TYPE = 'HSOV') and ODS_PSE.PS_IU_SSACI_DATA or ODS_PSE.PS_IU_CHE_DATA indicates that the student received the Core 40 or Academic Honors diploma.
If the student does not meet the criteria for items 1 or 2 above and meets the following criteria, report the student under Core 40 Technical:
- The student has a Core 40 Technical indicator of Y on DSS_RDS.IR_SSACICAT_ST, and
- one of the following is true:
  1. The last high school attended is located in Indiana and is not a home school; or
  2. no summary high school information is available in External Education (EXT_SUMM_TYPE = 'HSOV') and ODS_PSE.PS_IU_SSACI_DATA or ODS_PSE.PS_IU_CHE_DATA indicates that the student received the Core 40 or Academic Honors diploma.

If the student does not meet the criteria for items 1-3 above and meets the following criteria, report the student under Core 40:
- The student has a generic Core 40 indicator of Y on DSS_RDS.IR_SSACICAT_ST, and
- one of the following is true:
  1. The last high school attended is located in Indiana and is not a home school; or
  2. no summary high school information is available in External Education (EXT_SUMM_TYPE = 'HSOV') and ODS_PSE.PS_IU_SSACI_DATA or ODS_PSE.PS_IU_CHE_DATA indicates that the student received the Core 40 or Academic Honors diploma.

If the student does not meet the criteria for items 1 – 4 above AND meets all of the following criteria, report the student under “General Diploma “ for ICHE:
- the student has a last high school graduation date, and
- the student has a high school record from the school (neither self-reported nor from a home school).
Otherwise, report the student under “Diploma type undeclared or not received” for ICHE. For other reports, report this student under Other.

[1] See the separate IR Data Guide IR_Core40_AcadHonors_21century_Indicators.doc on the IA website for more information: https://iuia.iu.edu/finding-data/ir-data-guides/index.html

Programming SQL

1.	The following SQL is used to populate the unduplicated high school diploma type column (IR_HS_DPLM_TYP_DESC) in DSS_RDS.ADM_BSC_DTA_ST:

SELECT  /*+ driving_site(aa) */ 
aa.EMPLID, 
. . .
K.STU_HS_ORG_ID, 
K.STU_HS_ORG_ATP_CEEB_CD, 
K.STU_HS_NM, 
K.STU_HS_CTY_NM, 
K.STU_HS_CNTY_NM, 
K.STU_HS_ST_CD, 
K.STU_HS_ZIP_CD, 
K.STU_HS_CNTRY_CD, 
K.STU_HS_GRAD_DT, 
K.STU_HS_CLS_RNK_NBR, 
K.STU_HS_CLS_SZ_NBR, 
K.STU_HS_PCTL_NBR, 
K.STU_HS_SUM_CNVRT_GPA_NBR, 
K.STU_HS_SUM_GPA_TYP_CD, 
K.STU_HS_SUM_GPA_NBR,
K.IR_HM_SCHL_IND,
CASE WHEN K.STU_HS_NM like 'GED%' THEN 'GED'
               WHEN K.STU_HS_NM like 'HSE%' THEN 'HSE'
          WHEN p.IR_ACAD_HONORS_DIPLOMA = 'Y' 
             AND (K.STU_HS_ST_CD = 'IN'
                 OR (p2.EMPLID IS NOT NULL
                     AND REGEXP_REPLACE(nvl(K.STU_HS_ST_CD,'XX'),'[[:space:]]+','XX') = 'XX'))
             AND NVL(K.IR_HM_SCHL_IND,'N') = 'N'
             THEN 'CORE 40 with Acad Honors Diploma'
          WHEN p.IR_COR40_TECH_DPLM_IND = 'Y' 
             AND (K.STU_HS_ST_CD = 'IN'
                 OR (p2.EMPLID IS NOT NULL
                     AND REGEXP_REPLACE(nvl(K.STU_HS_ST_CD,'XX'),'[[:space:]]+','XX') = 'XX'))
             AND NVL(K.IR_HM_SCHL_IND,'N') = 'N'
             THEN 'CORE 40 Technical Diploma'
          WHEN p.IR_CORE_40_DIPLOMA = 'Y' 
             AND (K.STU_HS_ST_CD = 'IN'
                 OR (p2.EMPLID IS NOT NULL
                     AND REGEXP_REPLACE(nvl(K.STU_HS_ST_CD,'XX'),'[[:space:]]+','XX') = 'XX'))
             AND NVL(K.IR_HM_SCHL_IND,'N') = 'N'
             THEN 'CORE 40 Diploma'
          WHEN K.STU_HS_GRAD_DT is not null
             AND REGEXP_REPLACE(nvl(K.EXT_EDUC_DATA_SRCE_CD,'XXX'),'[[:space:]]+','XXX') IN ('SCH','MF','XXX')
             AND NVL(K.IR_HM_SCHL_IND,'N') = 'N'
             THEN 'General non-GED Diploma'
          ELSE 'Diploma type undeclared or not received' 
          END AS IR_HS_DPLM_TYP_DESC,
K.EXT_EDUC_DATA_SRCE_CD AS STU_HS_DTA_SRC_CD,
K.STU_HS_DTA_SRC_DESC
FROM
        (Select a.EMPLID
               from ODS_PSE.PS_PERSON a, 
                      (Select Distinct PRSN_UNIV_ID from DSS_RDS.PSE_MAX_TST_SCR_ST) b
                         , DSS_RDS.IR_STU_HS_GT d
                         , DSS_RDS.IR_SSACICAT_ST saci
                                   where a.EMPLID=b.PRSN_UNIV_ID(+)
                                         and a.EMPLID=d.PRSN_UNIV_ID(+)
                                         and a.EMPLID=saci.PRSN_UNIV_ID(+)
                                        and (b.PRSN_UNIV_ID is not NULL
                                               or d.PRSN_UNIV_ID is not NULL
                                               or saci.IR_ACAD_HONORS_DIPLOMA = 'Y'
                                               or saci.IR_CORE_40_DIPLOMA = 'Y'
                                               or saci.IR_COR40_TECH_DPLM_IND = 'Y'))aa, 
. . .

(select kx.*, n.STU_HS_DTA_SRC_DESC,
        		case when kx.IR_STU_HS_EXT_ORG_CTGRY_CD = 'HOME_SCHOOL' then 'Y' else 'N' end as IR_HM_SCHL_IND
  from DSS_RDS.IR_STU_HS_GT kx,
       (SELECT c.FIELDVALUE as STU_HS_DTA_SRC_CD, 
                c.XLATLONGNAME as STU_HS_DTA_SRC_DESC
        FROM ODS_PSE.PSXLATITEM c
        WHERE c.FIELDNAME = 'LS_DATA_SOURCE'
            AND c.EFFDT = (SELECT MAX(x.EFFDT)
                           FROM ODS_PSE.PSXLATITEM x
                           WHERE c.FIELDNAME = x.FIELDNAME
                           AND c.FIELDVALUE = x.FIELDVALUE)) n
  where kx.EXT_EDUC_DATA_SRCE_CD = n.STU_HS_DTA_SRC_CD (+)) K,
 DSS_RDS.IR_SSACICAT_ST P,
 (SELECT EMPLID
      FROM DSS_RDS.IR_SSACICAT_CUR_CHE_MT
      WHERE IU_SSACI_ACADHONOR = 'Y'
             OR IU_SSACI_CORE40 = 'Y') p2
where 
. . . 

K.PRSN_UNIV_ID(+) = AA.EMPLID
AND P.PRSN_UNIV_ID(+) = AA.EMPLID
AND P2.EMPLID(+) = AA.EMPLID
/