Overview and History

Overview and History

Dual Credit generally refers to a course in which high school students have the opportunity to earn both high school and college credits in the same course. The IU Advance College Program (ACP) is one of several dual-credit programs offered through IU, so ACP students are a subset of Dual Credit students. Historically, UIRR has identified high school students taking courses in these programs for official reporting to the Indiana Commission for Higher Education (Indiana CHE).

In fall 2017, a subset of these students were excluded from most official enrollment reports in order to more accurately represent on-campus enrollments. These students were identified using the following logic:

IU Northwest students with one of the following as their Plan 1 academic plan:
ACPNDG - ACP Students
DCPNDG - Dual Credit Program Students
IU Southeast students in the academic program “ACES0 - Advising Ctr for ExplorStdnts” and with one of the following as their Plan 1 academic plan:
ACPNDG1 - ACP Students
BTCNDG - Bridge to College
IPFW students with the following as their Plan 1 academic plan:
GUISTHSPRP - HS Student Non-Deg Conditional
Students at one of the remaining IU campuses who were enrolled in at least one class having an ACP course attribute.

Beginning in spring 2018, a slightly different subset ofstudents enrolled in dual credit classes is excluded from most official enrollment reports, due in part to the fact that course attributes are no longer maintained as consistently as in the past. These students are identified using the following logic:

For campuses other than IPFW, the dual credit students who are excluded from official enrollment reports are high school students who are enrolled at IU and paying $25 per academic unit for at least one course. These “Priority Dual Credit” courses are typically listed in the State of Indiana Core Transfer Library as either Priority Dual Credit for Liberal Arts or Career and Technical Education (CTE) dual credit courses. See the Indiana Dual Credit FAQ and the Advance College Program website for more information:
For IPFW students, dual credit students who are excluded from official enrollment reports are those whose Plan 1 academic plan is GUISTHSPRP - HS Student Non-Deg Conditional.

UIRR Reporting Fields

The field CLS_DCR_RPT_IND in IR_CEN_TRM_SNPSHT_GT is used by UIRR to identify dual credit students who are to be excluded from most official enrollment reports, as described above. In other words, to match UIRR reports that exclude dual credit students in fall 2017, spring 2018, and future terms, select rows where CLS_DCR_RPT_IND = N to exclude these students.

Another UIRR reporting field, STU_ACP_STDNT_RPT_IND, matches STU_ACP_STDNT_IND. This field has not been used by UIRR to exclude students from official enrollment reports.

Both of these fields are on the UIRR census snapshot table IR_CEN_TRM_SNPSHT_GT. See the next section below for the detailed logic that was used to set these fields for various academic terms.

Logic forDual Credit and ACP fields

Technical Names and Definitions:

General Note: When the fields below occur on a table with the granularity of SR Student Term (table keys of University ID, Career, Institution, and Term), the indicators are set to Y if the student is enrolled in at least one dual credit/ACP class for that career, institution, and term.

CLS_ACP_IND – Advance College Project Class Indicator
In IR_CEN_CRS_SNPSHT_GT, the logic matches what is used for the columns STU_ACP_STDNT_IND and STU_ACP_STDNT_RPT_IND in IR_CEN_TRM_SNPSHT_GT (see the next major bullet point below).
In SR_ENRL_ST and other enrollment-by-class data groups based on SR_ENRL_ST, the column CLS_ACP_IND is set to Y for the following student class enrollments:
For fall 2014 and future terms, the class must have a class session code of ACP, and the class enrollment must meet both criteria for the Dual Credit Class indicator (CLS_DCR_IND):
Has a derived expanded level name (ACAD_DRVD_EXPND_LVL_NM) of High School or Undergrad Special for the term and campus[1], AND
Is charged $25 per credit in tuition for at least one class
For terms prior to fall 2014, the class must have a course attribute code of RPCD and a course attribute value code that included the two-character campus code (e.g. BL) followed by the letters ‘AC’. These class enrollments must also meet the criteria for the Dual Credit Class indicator (CLS_DCR_IND) (see the previous bullet sub-points).

STU_ACP_STDNT_IND (and STU_ACP_STDNT_RPT_IND) – Advance College Project Student Indicator
In IR_CEN_TRM_SNPSHT_GT for terms prior to fall 2014, this is set to Y for students enrolled in at least one class with a course attribute code of RPCD and a course attribute value code that included the two-character campus code (e.g. BL) followed by the letters ‘AC’.
In IR_CEN_TRM_SNPSHT_GT for terms 4148-4178, inclusive, this is set to Y for students enrolled in at least one class with a course attribute code of ACP.
In IR_CEN_TRM_SNPSHT_GT for spring 2018 and later terms, this is set to Y for students who meet all of these criteria:
Has a derived expanded level name (ACAD_DRVD_EXPND_LVL_NM) of High School or Undergrad Special for the term and campus[2], AND
Is charged $25 per credit in tuition for at least one class2, AND
Is enrolled in at least one class with a session code from the class table with the value ACP.
In tables other than IR_CEN_TRM_SNPSHT_GT, the following logic is used:
For terms prior to fall 2014, the following criteria are used for a value of Y:
Has a derived expanded level name (ACAD_DRVD_EXPND_LVL_NM) of High School or Undergrad Special for the term and campus2, AND
Is charged $25 per credit in tuition for at least one class2, AND
The student is enrolled in at least one class with a course attribute code of RPCD and a course attribute value code that included the two-character campus code (e.g. BL) followed by the letters ‘AC’.
For fall 2014 and later terms, this is set to Y for students who meet all of these criteria:
Has a derived expanded level name (ACAD_DRVD_EXPND_LVL_NM) of High School or Undergrad Special for the term and campus2, AND
Is charged $25 per credit in tuition for at least one class2, AND
Is enrolled in at least one class with a session code from the class table with the value ACP.

CLS_DCR_IND – Class Dual Credit Indicator
In IR_CEN_TRM_SNPSHT_GT for terms prior to spring 2018, this is set to Y for students enrolled in at least one class with a dual credit course attribute. This includes classes with ACP course attributes (see above), as well as classes with a course attribute of RPCD and a course attribute value code that includes the two-character campus code (e.g. BL) followed by the letters ‘BC’ at Southeast or ‘DCP’ or ‘DCC’ at Northwest.
In IR_CEN_TRM_SNPSHT_GT for spring 2018 and later terms, this is set to Y for studentswho meet these criteria:
Has a derived expanded level name (ACAD_DRVD_EXPND_LVL_NM) of High School or Undergrad Special for the term and campus2, AND
Is charged $25 per credit in tuition for theclass2.
In tables other than IR_CEN_TRM_SNPSHT_GT, the logic matches the logic described in the previous bullet (i.e., the IR_CEN_TRM_SNPSHT_GT logic for spring 2018 and later).

CLS_DCR_RPT_IND – Class Dual Credit Reporting Indicator
This column only exists on IR_CEN_TRM_SNPSHT_GT.
For terms prior to fall 2012, the following logic was used. (See above for the pre-spring 2018 logic for STU_ACP_STDNT_IND.)

CASE WHEN INST_CD='IUKOA'AND ACAD_PRM_PLAN_1_CD='ACPPR'THEN 'Y'

WHEN INST_CD='IUEAA'AND ACAD_PRM_PLAN_1_CD='ACP'THEN 'Y'

WHEN INST_CD='IUSBA'AND ACAD_PRM_PLAN_1_CD='ACPNDG'THEN 'Y'

WHEN INST_CD='IUBLA'AND ACAD_PRM_PLAN_1_CD='ADVCOLPRJ'THEN 'Y'

WHEN INST_CD = 'IUNWA'AND ACAD_PRM_PLAN_1_CD IN ('ACPNDG','DCPNDG') THEN 'Y'

WHEN INST_CD = 'IUNWA'AND ACAD_PRM_PLAN_1_CD NOT IN ('ACPNDG','DCPNDG') THEN 'N'

WHEN INST_CD = 'IUSEA'AND ACAD_PRM_PGM_CD ='ACES0'

AND ACAD_PRM_PLAN_1_CD IN ('ACPNDG1','BTCNDG') THEN 'Y'

WHEN INST_CD = 'IUSEA'THEN 'N'

WHEN INST_CD = 'IUFWA'AND ACAD_PRM_PLAN_1_CD IN ('GUISTHSPRP') then 'Y'

WHEN INST_CD = 'IUFWA'THEN 'N'

ELSE nvl(STU_ACP_STDNT_IND,'N') END AS CLS_DCR_RPT_IND

For terms between fall 2012 and fall 2017 (inclusive), the following logic was used. (See above for the pre-spring 2018 logic for STU_ACP_STDNT_IND.)

CASE WHEN INST_CD = 'IUNWA'AND ACAD_PRM_PLAN_1_CD IN ('ACPNDG','DCPNDG') THEN 'Y'

WHEN INST_CD = 'IUNWA'AND ACAD_PRM_PLAN_1_CD NOT IN ('ACPNDG','DCPNDG') THEN 'N'

WHEN INST_CD = 'IUSEA'AND ACAD_PRM_PGM_CD ='ACES0'

AND ACAD_PRM_PLAN_1_CD IN ('ACPNDG1','BTCNDG') THEN 'Y'

WHEN INST_CD = 'IUSEA'THEN 'N'

WHEN INST_CD = 'IUFWA'AND ACAD_PRM_PLAN_1_CD IN ('GUISTHSPRP') then 'Y'

WHEN INST_CD = 'IUFWA'THEN 'N'

ELSE STU_ACP_STDNT_IND END AS CLS_DCR_RPT_IND

For spring 2018 and later terms, this field matches CLS_DCR_IND (see above for more details).

CLS_DCR_EXCLV_IND – Class Dual Credit Exclusive Indicator (only enrolled in dual credit classes)
This is set to Y for the subset of students with CLS_DCR_IND = Y who were exclusively enrolled in classes with CLS_DCR_IND = Y.

CLS_DCR_UNT_NBR – Class Dual Credit Unit Number
This is the sum of academic units of all classes taken by the student with CLS_DCR_IND = Y.

CLS_DCR_OCMP_IND – Class Dual Credit Off-Campus Indicator
For terms prior to spring 2018, this is set to Y for the subset of students with CLS_DCR_IND = Y that excluded . . .
Northwest students with a course attribute value code of ‘NWDCC’
and Southeast students with a course attribute value code of ‘SEBC’.
For spring 2018 and later terms, this is set to Y for a subset of students with CLS_DCR_IND = Y and a class location code other than one of the IU campuses.

CLS_DCR_OCMP_EXCLV_IND – Class Dual Credit Off-Campus Exclusive Indicator
This is set to Y for the subset of students with CLS_DCR_OCMP_IND = Y who were only enrolled in classes with CLS_DCR_OCMP_IND = Y.

CLS_DCR_OCMP_UNT_NBR – Class Dual Credit Off-Campus Unit Number
This is the sum of academic units of all classes taken by the student with CLS_DCR_OCMP_IND = Y.

Tables: SR_ENRL_DRVD_COL_MT and IR_ENRL_DRVD_COL_GT

SR_ENRL_ST

SR_STU_TERM_DRVD_COL_MT[3]and IR_STU_TERM_DRVD_COL_GT3

SR_STU_TERM_ST

SR_DAILY_TRM_DTL_SNPSHT_ST

IR_CEN_TRM_SNPSHT_GT

IR_CEN_CRS_SNPSHT_GT

\\ads\usss\External_Share\UIRR\Misc_Working_Files\Website\1-uirr webserve\www\reports\resources\IRDSI\doc\ir data guides\Dual Credit-ACP Reporting Status.docx Page 1 of 5 Last Update: 9/24/2018

[1] IPFW students are instead identified as those with a Plan 1 of GUISTHSPRP - HS Student Non-Deg Conditional. Also, IPFW students’ tuition information is not available to the IU side of IPFW, so all students with Plan 1 = GUISTHSPRP are selected for exclusion from enrollment reports.

[2] IPFW students are instead identified as those with a Plan 1 of GUISTHSPRP - HS Student Non-Deg Conditional. Also, IPFW students’ tuition information is not available to the IU side of IPFW, so all students with Plan 1 = GUISTHSPRP are selected for exclusion from enrollment reports.

[3]This table includes students enrolled more than 730 days in the past, i.e. “active” students who are in SR_STU_TERM_ST/GT or SR_HIST_TERM_ST/GT. Note that non-IU contract students (see footnote 2) are designated in this table by a C in the column STU_DRVD_ENRL_TYP_CD.