CRDC questions calculated in Campus

Last Modified on 10/30/2026 9:10 am CDT

Path: Reporting > Civil Rights Data Collection (CRDC)

Campus calculates the answers for the following questions via mappings you'll use the CRDC Setup Tool to create. Alternatively, you may choose to create Ad hoc filters to answer these questions. This information is provided for you to use as a reference. Consult the information on the official CRDC Resource Center website if you need information about instructions, skip logic or other CRDC topics.

1. SCHR: School Characteristics

(ONLY for SCHR-3: Grades with Students Enrolled)

Category Mapping: Grade Levels

Flat File Details:

Layout	Element Name	Data Element
Permitted Values: Yes/No/Null Length of Permitted Values: 3
SCHR-3.1	SCH_GRADE_PS	Preschool
SCHR-3.2	SCH_GRADE_KG	Kindergarten
SCHR-3.3	SCH_GRADE_G01	Grade 1
SCHR-3.4	SCH_GRADE_G02	Grade 2
SCHR-3.5	SCH_GRADE_G03	Grade 3
SCHR-3.6	SCH_GRADE_G04	Grade 4
SCHR-3.7	SCH_GRADE_G05	Grade 5
SCHR-3.8	SCH_GRADE_G06	Grade 6
SCHR-3.9	SCH_GRADE_G07	Grade 7
SCHR-3.10	SCH_GRADE_G08	Grade 8
SCHR-3.11	SCH_GRADE_G09	Grade 9
SCHR-3.12	SCH_GRADE_G10	Grade 10
SCHR-3.13	SCH_GRADE_G11	Grade 11
SCHR-3.14	SCH_GRADE_G12	Grade 12
SCHR-3.15	SCH_GRADE_UG	Ungraded

Logic
All CRDC Grade Levels will display with results for each grade: Show “Yes” next to each grade level offered at this school where at least one student is enrolled in a grade that is mapped to the CRDC Grade Level Show “No” next to all grade levels at this school where no student is enrolled in a grade that is mapped to the CRDC Grade Level Only report students where their enrollment is in the school being reported or the School of Accountability field is set to the reporting school.
An override column will be next to the results with a droplist next to each grade level that can be set to Yes, No or NULL
Detail Report Logic will display the following information: NCES School Number, School Name, Students PersonID, State ID, Name, Grade Name and CRDC Grade Level

Logic

All CRDC Grade Levels will display with results for each grade:

Show “Yes” next to each grade level offered at this school where at least one student is enrolled in a grade that is mapped to the CRDC Grade Level
Show “No” next to all grade levels at this school where no student is enrolled in a grade that is mapped to the CRDC Grade Level
Only report students where their enrollment is in the school being reported or the School of Accountability field is set to the reporting school.

An override column will be next to the results with a droplist next to each grade level that can be set to Yes, No or NULL

Detail Report Logic will display the following information:

NCES School Number, School Name, Students PersonID, State ID, Name, Grade Name and CRDC Grade Level

3. PSCH: Preschool

(NOT for PSCH-2a, 2b, 2c, 2d)

PSCH-1: Preschool Age for Non-IDEA Children

Category Mapping: Grade Levels, Fall Snapshot IDEA Students

Flat File Details:

Permitted Values: Yes/No/NULL Length of Permitted Values: 3
PSCH1.1	SCH_PSENR_NONIDEA_A3	Children age 3 years
PSCH1.2	SCH_PSENR_NONIDEA_A4_A5	Children age 4 and 5 years

Permitted Values: Yes/No/NULL

Length of Permitted Values: 3

Layout

Element Name

Data Element

PSCH1.1

SCH_PSENR_NONIDEA_A3

Children age 3 years

PSCH1.2

SCH_PSENR_NONIDEA_A4_A5

Children age 4 and 5 years

Logic
Indicate whether any of the school’s preschool services or programs serve non-IDEA children in the ages specified. Children age 3 years Children age 4 and 5 years
Results Logic: Report if the school has any students with a qualifying enrollment in a grade level that is mapped to the CRDC Grade Level = Preschool and they meet the age requirement being reported The student's age is calculated by comparing their birth date to the Fall Snapshot Count Date entered in the Report Options Report “Yes” next to each Age where there is at least 1 student = to that age on the Fall Snapshot Count Date Report "No" next to each Age where there is not any student that is = that age on the Fall Snapshot Count Date Report "NULL" if the school does not have any students in a grade level that is mapped to the CRDC Grade Level = Preschool Do not include students if they are mapped in the Fall Snapshot IDEA Category Mapping Use the Enrollment logic to determine a student's eligibility to report
An override column will be next to the results with a droplist next to each grade level that can be set to Yes, No, or NULL
Detail Report Logic will display the following information: Year, NCES School Number, School Name, Students PersonID, State ID, Name, Grade Name, CRDC Grade Level, Age The age of the student at the time of the count date will be displayed (not their current age if it has changed)

PSCH-3: Preschool Enrollment

Category Mapping: Grade Levels, Fall Snapshot IDEA Students, Fall Snapshot EL Students, Fall Snapshot 504 Students

Flat File Details:

Layout	Data Element	Male	Female
Permitted Values: Integer, NULL Length of Permitted Values: 7
PSCH-3.1, PSCH-3.2	Hispanic or Latino of any race	SCH_PSENR_HI_M	SCH_PSENR_HI_F
PSCH-3.3, PSCH-3.4	American Indian or Alaska Native	SCH_PSENR_AM_M	SCH_PSENR_AM_F
PSCH-3.5, PSCH-3.6	Asian	SCH_PSENR_AS_M	SCH_PSENR_AS_F
PSCH-3.7, PSCH-3.8	Native Hawaiian/Pacific Islander	SCH_PSENR_HP_M	SCH_PSENR_HP_F
PSCH-3.9, PSCH-3.10	Black or African American	SCH_PSENR_BL_M	SCH_PSENR_BL_F
PSCH-3.11, PSCH-3.12	White	SCH_PSENR_WH_M	SCH_PSENR_WH_F
PSCH-3.13, PSCH-3.14	Two or More races	SCH_PSENR_TR_M	SCH_PSENR_TR_F
	Total
PSCH-3.15, PSCH-3.16	English Learners (EL)	SCH_PSENR_EL_M	SCH_PSENR_EL_F
PSCH-3.17, PSCH-3.18	Students with Disabilities (IDEA)	SCH_PSENR_IDEA_M	SCH_PSENR_IDEA_F
PSCH-3.19, PSCH-3.20	Students with Disabilities (Section 504 Only)	SCH_PSENR_504_M	SCH_PSENR_504_F

Logic
PSCH3.1-PSCH3.14: Count and display the total number of distinct students that fall into each Data Element listed Use the Fall Snapshot Enrollment, Race/Ethnicity & Gender logic to determine which Data Element to report the students in Report any students with a qualifying enrollment in a grade level that is mapped to the CRDC Grade Level = Preschool Report all students who are ages 3, 4 or 5 on the Fall Snapshot date Report any student who is the age of 2 on the Fall Snapshot date and 3rd birthday occurs on or before the last day of the Regular School Year Student's birthday must be on or before 6/30/XX of the reporting year If there are no students in a data element, report "0" (not null)
PSCH3.15-PSCH3.20: Report the total number of distinct students by gender for the following category mappings: PSCH3.15 & PSCH3.16: Use the Fall Snapshot EL Students to report students in proper data element PSCH3.17 & PSCH3.18 Use Fall Snapshot IDEA Students to report students in the proper data element PSCH3.19 & PSCH3.20 Use Fall Snapshot Section 504 Students to report students in the proper data element If there are no students in a data element, report "0" (not null)
Show Totals in the question summary in the following groupings: Race/Ethnicity by Gender & Total Number by Gender The totals in the summary will be updated upon hitting save. Totals are not reported, they are only there for data verification.
In the question detail screen, an override column will be next to the results with a text box next to each data element. The field must accept NULL, Alpha & Numeric values
Detail Report Logic will display the following information: NCES School Number, School Name, Students PersonID, State ID, Name, Grade Name, Gender, Race/Ethnicity, IDEA, EL, Section 504

PSCH-4a: Preschool Enrollment of English Learner Students

Category Mapping: Grade Levels, Fall Snapshot EL Students

Flat File Details:

Layout	Data Element	Male	Female
Permitted Values: Integer, NULL Length of Permitted Values: 7
PSCH-4a.1, PSCH-4a.2	Hispanic or Latino of any race	SCH_PSELENR_HI_M	SCH_PSELENR_HI_F
PSCH-4a.3, PSCH-4a.4	American Indian or Alaska Native	SCH_PSELENR_AM_M	SCH_PSELENR_AM_F
PSCH-4a.5, PSCH-4a.6	Asian	SCH_PSELENR_AS_M	SCH_PSELENR_AS_F
PSCH-4a.7, PSCH-4a.8	Native Hawaiian/Pacific Islander	SCH_PSELENR_HP_M	SCH_PSELENR_HP_F
PSCH-4a.9, PSCH-4a.10	Black or African American	SCH_PSELENR_BL_M	SCH_PSELENR_BL_F
PSCH-4a.11, PSCH-4a.12	White	SCH_PSELENR_WH_M	SCH_PSELENR_WH_F
PSCH-4a.13, PSCH-4a.14	Two or More races	SCH_PSELENR_TR_M	SCH_PSELENR_TR_F
	Total

Logic
PSCH4a.1-PSCH4a.14: Count and display the total number of distinct Fall Snapshot EL Students that fall into each Data Element listed Use the Enrollment, Race/Ethnicity & Gender logic to determine which Data Element to report the students in Only report students who are selected and saved in the Fall Snapshot EL Students category mapping for the reporting school Report "0" if there is not a student that is eligible in a data element
Show Totals in the question summary in the following groupings: Race/Ethnicity by Gender & Total Number by Gender
The totals in the summary will be updated upon hitting save. Totals are not reported, they are only there for data verification.
In the question detail screen, an override column will be next to the results with a text box next to each data element Totals will be blank in the override columns
Detail Report Logic will display the following information: Year, NCES School Number, School Name, Students PersonID, State ID, Name, Grade Name, Gender, Race/Ethnicity, EL

PSCH-4b: Preschool Enrollment of English Learner Students - EL Students in EL Programs

Category Mapping: Grade Levels, Fall Snapshot Students Enrolled in EL Programs, Fall Snapshot IDEA Students

Flat File Details:

Layout	Data Element	Male	Female
Permitted Values: Integer, NULL Length of Permitted Values: 7
PSCH-4b.1, PSCH-4b.2	Hispanic or Latino of any race	SCH_PSELPROGENR_HI_M	SCH_PSELPROGENR_HI_F
PSCH-4b.3, PSCH-4b.4	American Indian or Alaska Native	SCH_PSELPROGENR_AM_M	SCH_PSELPROGENR_AM_F
PSCH-4b.5, PSCH-4b.6	Asian	SCH_PSELPROGENR_AS_M	SCH_PSELPROGENR_AS_F
PSCH-4b.7, PSCH-4b.8	Native Hawaiian or Other Pacific Islander	SCH_PSELPROGENR_HP_M	SCH_PSELPROGENR_HP_F
PSCH-4b.9, PSCH-4b.10	Black or African American	SCH_PSELPROGENR_BL_M	SCH_PSELPROGENR_BL_F
PSCH-4b.11, PSCH-4b.12	White	SCH_PSELPROGENR_WH_M	SCH_PSELPROGENR_WH_F
PSCH-4b.13, PSCH-4b.14	Two or More races	SCH_PSELPROGENR_TR_M	SCH_PSELPROGENR_TR_F
	Total
PSCH-4b.15, PSCH-4b.16	Students with Disabilities (IDEA)	SCH_PSELPROGENR_IDEA_M	SCH_PSELPROGENR_IDEA_F

Logic
PSCH4b.1-PSCH4b.14: Count and display the total number of distinct Fall Snapshot Students Enrolled in EL Programs that fall into each Data Element listed Use the Enrollment, Race/Ethnicity & Gender logic to determine which Data Element to report the students in Only report students who are selected and saved in the Fall Snapshot Students Enrolled in EL Programs category mapping for the reporting school Report "0" if there is not a student that is eligible in a data element Report null if both answers on question PSCH4b data elements PSCH4b.15 & PSCH4b.16 are "0"
PSCH4b.15-PSCH4b.16: Count and display the total number of IDEA students who are also Fall Snapshot IDEA Students Enrolled in EL Programs that fall into each data element listed Use the Enrollment & Gender logic to determine which data element to report the students in Students must be in both the Fall Snapshot IDEA Students & Fall Snapshot Students Enrolled in EL Programs category mappings to report Report "0" if there is not a student that is eligible in a data element Report null if both answers on question ENRL-1 data elements PSCH4b.15 & PSCH4b.16 are "0"
Show Totals in the question summary in the following groupings: Race/Ethnicity by Gender & Total Number by Gender, IDEA by Gender The totals in the summary will be updated upon hitting save. Totals are not reported, they are only there for data verification.
In the question detail screen, an override column will be next to the results with a text box next to each data element Totals will be blank in the override columns
Detail Report Logic will display the following information: Year, NCES School Number, School Name, Students PersonID, State ID, Name, Grade Name, Gender, Race/Ethnicity, EL Programs, IDEA

PSCH-5: Preschool Enrollment of Students with Disabilities - IDEA

Category Mapping: Grade Levels, Fall Snapshot IDEA Students

Flat File Details:

Layout	Data Element	Male	Female
Permitted Values: Integer, NULL Length of Permitted Values: 7
PSCH-5.1, PSCH-5.2	Hispanic or Latino of any race	SCH_PSIDEAENR_HI_M	SCH_PSIDEAENR_HI_F
PSCH-5.3, PSCH-5.4	American Indian or Alaska Native	SCH_PSIDEAENR_AM_M	SCH_PSIDEAENR_AM_F
PSCH-5.5, PSCH-5.6	Asian	SCH_PSIDEAENR_AS_M	SCH_PSIDEAENR_AS_F
PSCH-5.7, PSCH-5.8	Native Hawaiian or Other Pacific Islander	SCH_PSIDEAENR_HP_M	SCH_PSIDEAENR_HP_F
PSCH-5.9, PSCH-5.10	Black or African American	SCH_PSIDEAENR_BL_M	SCH_PSIDEAENR_BL_F
PSCH-5.11, PSCH-5.12	White	SCH_PSIDEAENR_WH_M	SCH_PSIDEAENR_WH_F
PSCH-5.13, PSCH-5.14	Two or More races	SCH_PSIDEAENR_TR_M	SCH_PSIDEAENR_TR_F
	Total
PSCH-5.15, PSCH-5.16	English Learners (EL)	SCH_PSIDEAENR_EL_M	SCH_PSIDEAENR_EL_F

	Logic
PSCH5.1	PSCH5.1-PSCH5.14: Count and display the total number of distinct Fall Snapshot IDEA Students that fall into each Data Element listed Use the Enrollment, Race/Ethnicity & Gender logic to determine which Data Element to report the students in Only report students who are selected and saved in the Fall Snapshot IDEA Students category mapping for the reporting school Report "0" if there is not a student that is eligible in a data element
PSCH5.2	PSCH5.15-PSCH5.16: Count and display the total number of students who are Fall Snapshot EL students that fall into each data element listed Use the Enrollment & Gender logic to determine which data element to report the students in Students must be in both the Fall Snapshot IDEA Students & Fall Snapshot EL Students category mappings to report Report "0" if there is not a student that is eligible in a data element
PSCH5.3	Show Totals in the question summary in the following groupings: Race/Ethnicity by Gender & Total Number by Gender, EL by Gender The totals in the summary will be updated upon hitting save. Totals are not reported, they are only there for data verification.
PSCH5.4	In the question detail screen, an override column will be next to the results with a text box next to each data element
PSCH5.5	Detail Report Logic will display the following information: Year, NCES School Number, School Name, Students PersonID, State ID, Name, Grade Name, Gender, Race/Ethnicity, IDEA, EL

PSCH-6: Preschool Enrollment of Students with Disabilities - Section 504 Only

Category Mapping: Grade Levels, Fall Snapshot 504 Students, Fall Snapshot EL Students

Flat File Details:

Layout	Data Element	Male	Female
Permitted Values: Integer, NULL Length of Permitted Values: 7
PSCH-6.1, PSCH-6.2	Hispanic or Latino of any race	SCH_PS504ENR_HI_M	SCH_PS504ENR_HI_F
PSCH-6.3, PSCH-6.4	American Indian or Alaska Native	SCH_PS504ENR_AM_M	SCH_PS504ENR_AM_F
PSCH-6.5, PSCH-6.6	Asian	SCH_PS504ENR_AS_M	SCH_PS504ENR_AS_F
PSCH-6.7, PSCH-6.8	Native Hawaiian or Other Pacific Islander	SCH_PS504ENR_HP_M	SCH_PS504ENR_HP_F
PSCH-6.9, PSCH-6.10	Black or African American	SCH_PS504ENR_BL_M	SCH_PS504ENR_BL_F
PSCH-6.11, PSCH-6.12	White	SCH_PS504ENR_WH_M	SCH_PS504ENR_WH_F
PSCH-6.13, PSCH-6.14	Two or More races	SCH_PS504ENR_TR_M	SCH_PS504ENR_TR_F
	Total
PSCH-6.15, PSCH-6.16	English Learners (EL)	SCH_PS504ENR_EL_M	SCH_PS504ENR_EL_F

	Logic
PSCH6.1	PSCH6.1-PSCH6.14: Count and display the total number of distinct Fall Snapshot 504 Students that fall into each Data Element listed Use the Enrollment, Race/Ethnicity & Gender logic to determine which Data Element to report the students in Only report students who are selected and saved in the Fall Snapshot 504 Students category mapping for the reporting school Report "0" if there is not a student that is eligible in a data element
PSCH6.2	PSCH6.15-PSCH6.16: Count and display the total number of Fall Snapshot 504 students who are also Fall Snapshot EL students that fall into each data element listed Use the Enrollment & Gender logic to determine which data element to report the students in Students must be in both the Fall Snapshot 504 Students & Fall Snapshot EL Students category mappings to report Report "0" if there is not a student that is eligible in a data element
PSCH6.3	Show Totals in the question summary in the following groupings: Race/Ethnicity by Gender & Total Number by Gender, EL by Gender The totals in the summary will be updated upon hitting save. Totals are not reported, they are only there for data verification.
PSCH6.4	In the question detail screen, an override column will be next to the results with a text box next to each data element
PSCH6.5	Detail Report Logic will display the following information: Year, NCES School Number, School Name, Students PersonID, State ID, Name, Grade Name, Gender, Race/Ethnicity, 504, EL

5. ENRL: Enrollment

Students not designated as male or female WILL NOT be included in the flat file calculations. Update values utilizing the override fields to ensure these students are included in the flat file output.

ENRL-1: Student Enrollment

Category Mapping: Fall Snapshot IDEA Students, Fall Snapshot 504 Students, Fall Snapshot EL Students

Flat File Details:

Layout	Data Element	Male	Female
Permitted Values: Integer, NULL Length of Permitted Values: 7
ENRL-1.1, ENRL-1.2, ENRL-1.3	Hispanic or Latino of any race	SCH_ENR_HI_M	SCH_ENR_HI_F
ENRL-1.4, ENRL-1.5, ENRL-1.6	American Indian or Alaska Native	SCH_ENR_AM_M	SCH_ENR_AM_F
ENRL-1.7, ENRL-1.8, ENRL-1.9	Asian	SCH_ENR_AS_M	SCH_ENR_AS_F
ENRL-1.10, ENRL-1.11, ENRL-1.12	Native Hawaiian or Other Pacific Islander	SCH_ENR_HP_M	SCH_ENR_HP_F
ENRL-1.13, ENRL-1.14, ENRL-1.15	Black or African American	SCH_ENR_BL_M	SCH_ENR_BL_F
ENRL-1.16, ENRL-1.17, ENRL-1.18	White	SCH_ENR_WH_M	SCH_ENR_WH_F
ENRL-1.19, ENRL-1.20, ENRL-1.21	Two or More races	SCH_ENR_TR_M	SCH_ENR_TR_F
Total
ENRL-1.22, ENRL-1.23, ENRL-1.24	English Learners (EL)	SCH_ENR_EL_M	SCH_ENR_EL_F
ENRL-1.25, ENRL-1.26, ENRL-1.27	Students with Disabilities (IDEA)	SCH_ENR_IDEA_M	SCH_ENR_IDEA_F
ENRL-1.28, ENRL-1.29, ENRL-1.30	Students with Disabilities (Section 504 Only)	SCH_ENR_504_M	SCH_ENR_504_F

Logic
ENRL1.1-ENRL1.21: Count and display the total number of distinct students that fall into each Data Element listed Use the Enrollment, Race/Ethnicity & Gender logic to determine which Data Element to report the students in If there are no students in a data element, report "0" (not null)
ENRL1.22-ENRL1.30: Report the total number of distinct students by gender for the following category mappings: ENRL1.22 - ENRL1.24: Fall Snapshot EL Students ENRL1.25 - ENRL1.27 Fall Snapshot IDEA Students ENRL1.28 - ENRL1.30 Fall Snapshot 504 Students If there are no students in a data element, report "0" (not null)
Show Totals in the question summary in the following groupings: Race/Ethnicity by Gender & Total Number by Gender The totals in the summary will be updated upon hitting save. Totals are not reported, they are only there for data verification.
In the question detail screen, an override column will be next to the results with a text box next to each data element. The field must accept NULL, Alpha & Numeric values
Detail Report Logic will display the following information: Year, NCES School Number, School Name, Students PersonID, State ID, Name, Grade Name, Gender, Race/Ethnicity, IDEA, 504, EL

ENRL-2a: Enrollment of English Learner Students - All EL Students

Category Mapping: Fall Snapshot EL Students

Flat File Details:

Layout	Data Element	Male	Female
Permitted Values: Integer, NULL Length of Permitted Values: 7
ENRL2a.1, ENRL2a.2, ENRL2a.3	Hispanic or Latino of any race	SCH_ELENR_HI_M	SCH_ELENR_HI_F
ENRL2a.4, ENRL2a.5, ENRL2a.6	American Indian or Alaska Native	SCH_ELENR_AM_M	SCH_ELENR_AM_F
ENRL2a.7, ENRL2a.8, ENRL2a.9	Asian	SCH_ELENR_AS_M	SCH_ELENR_AS_F
ENRL2a.10, ENRL2a.11, ENRL2a.12	Native Hawaiian or Other Pacific Islander	SCH_ELENR_HP_M	SCH_ELENR_HP_F
ENRL2a.13, ENRL2a.14, ENRL2a.15	Black or African American	SCH_ELENR_BL_M	SCH_ELENR_BL_F
ENRL2a.16, ENRL2a.17, ENRL2a.18	White	SCH_ELENR_WH_M	SCH_ELENR_WH_F
ENRL2a.19, ENRL2a.20, ENRL2a.21	Two or More races	SCH_ELENR_TR_M	SCH_ELENR_TR_F
Total

Logic
ENRL2a.1-ENRL2a.21: Count and display the total number of distinct Fall Snapshot EL Students that fall into each Data Element listed Use the Enrollment, Race/Ethnicity & Gender logic to determine which Data Element to report the students in Only report students who are selected and saved in the Fall Snapshot EL Students category mapping for the reporting school Report "0" if there is not a student that is eligible in a data element Report null if both answers on question ENRL-1 data elements ENRL1.22 - ENRL1.24 are "0"
Show Totals in the question summary in the following groupings: Race/Ethnicity by Gender & Total Number by Gender
The totals in the summary will be updated upon hitting save. Totals are not reported, they are only there for data verification.
In the question detail screen, an override column will be next to the results with a text box next to each data element Totals will be blank in the override columns
Detail Report Logic will display the following information: Year, NCES School Number, School Name, Students PersonID, State ID, Name, Grade Name, Gender, Race/Ethnicity, EL

ENRL-2b: Enrollment of English Learner Students - EL Students in Programs

Category Mapping: Fall Snapshot Students Enrolled in EL Programs, Fall Snapshot IDEA Students

Flat File Details:

Layout	Data Element	Male	Female
Permitted Values: Integer, NULL Length of Permitted Values: 7
ENRL2b.1, ENRL2b.2, ENRL2b.3	Hispanic or Latino of any race	SCH_ELPROGENR_HI_M	SCH_ELPROGENR_HI_F
ENRL2b.4, ENRL2b.5, ENRL2b.6	American Indian or Alaska Native	SCH_ELPROGENR_AM_M	SCH_ELPROGENR_AM_F
ENRL2b.7, ENRL2b.8, ENRL2b.9	Asian	SCH_ELPROGENR_AS_M	SCH_ELPROGENR_AS_F
ENRL2b.10, ENRL2b.11, ENRL2b.12	Native Hawaiian or Other Pacific Islander	SCH_ELPROGENR_HP_M	SCH_ELPROGENR_HP_F
ENRL2b.13, ENRL2b.14, ENRL2b.15	Black or African American	SCH_ELPROGENR_BL_M	SCH_ELPROGENR_BL_F
ENRL2b.16, ENRL2b.17, ENRL2b.18	White	SCH_ELPROGENR_WH_M	SCH_ELPROGENR_WH_F
ENRL2b.19, ENRL2b.20, ENRL2b.21	Two or More races	SCH_ELPROGENR_TR_M	SCH_ELPROGENR_TR_F
Total
ENRL2b.22, ENRL2b.23, ENRL2b.24	Students with Disabilities (IDEA)	SCH_ELPROGENR_IDEA_M	SCH_ELPROGENR_IDEA_F

Logic
ENRL2b.1-ENRL2b.21: Count and display the total number of distinct Fall Snapshot Students Enrolled in EL Programs that fall into each Data Element listed Use the Enrollment, Race/Ethnicity & Gender logic to determine which Data Element to report the students in Only report students who are selected and saved in the Fall Snapshot Students Enrolled in EL Programs category mapping for the reporting school Report "0" if there is not a student that is eligible in a data element Report null if answers on question ENRL-1 data elements ENRL1.22 - ENRL1.24 are "0"
ENRL2b.22-ENRL2b.24: Count and display the total number of IDEA students who are also Fall Snapshot IDEA Students Enrolled in EL Programs that fall into each data element listed Use the Enrollment & Gender logic to determine which data element to report the students in Students must be in both the Fall Snapshot IDEA Students & Fall Snapshot Students Enrolled in EL Programs category mappings to report Report "0" if there is not a student that is eligible in a data element Report null if answers on question ENRL-1 data elements ENRL1.22 - ENRL1.24 are "0"
Show Totals in the question summary in the following groupings: Race/Ethnicity by Gender & Total Number by Gender, ~~IDEA~~ by Gender The totals in the summary will be updated upon hitting save. Totals are not reported, they are only there for data verification.
In the question detail screen, an override column will be next to the results with a text box next to each data element Totals will be blank in the override columns
Detail Report Logic will display the following information: Year, NCES School Number, School Name, Students PersonID, State ID, Name, Grade Name, Gender, Race/Ethnicity, EL Programs, IDEA

ENRL-3: Enrollment of Students with Disabilities - IDEA

Category Mapping: Fall Snapshot Idea Students, Fall Snapshot EL Students

Flat File Details:

Layout	Data Element	Male	Female
Permitted Values: Integer, NULL Length of Permitted Values: 7
ENRL3.1, ENRL3.2, ENRL3.3	Hispanic or Latino of any race	SCH_IDEAENR_HI_M	SCH_IDEAENR_HI_F
ENRL3.4, ENRL3.5, ENRL3.6	American Indian or Alaska Native	SCH_IDEAENR_AM_M	SCH_IDEAENR_AM_F
ENRL3.7, ENRL3.8, ENRL3.9	Asian	SCH_IDEAENR_AS_M	SCH_IDEAENR_AS_F
ENRL3.10, ENRL3.11, ENRL3.12	Native Hawaiian or Other Pacific Islander	SCH_IDEAENR_HP_M	SCH_IDEAENR_HP_F
ENRL3.13, ENRL3.14, ENRL3.15	Black or African American	SCH_IDEAENR_BL_M	SCH_IDEAENR_BL_F
ENRL3.16, ENRL3.17, ENRL3.18	White	SCH_IDEAENR_WH_M	SCH_IDEAENR_WH_F
ENRL3.19, ENRL3.20, ENRL3.21	Two or More races	SCH_IDEAENR_TR_M	SCH_IDEAENR_TR_F
Total
ENRL3.22, ENRL3.23, ENRL3.24	English Learners (EL)	SCH_IDEAENR_EL_M	SCH_IDEAENR_EL_F

Logic
ENRL3.1-ENRL3.21: Count and display the total number of distinct Fall Snapshot IDEA Students that fall into each Data Element listed Use the Enrollment, Race/Ethnicity & Gender logic to determine which Data Element to report the students in Only report students who are selected and saved in the Fall Snapshot IDEA Students category mapping for the reporting school Report "0" if there is not a student that is eligible in a data element Report null if answers on question ENRL-1 data elements ENRL1.25 - ENRL1.27 are "0"
ENRL3.22-ENRL3.24: Count and display the total number of Fall Snapshot IDEA students who are also Fall Snapshot EL students that fall into each data element listed Use the Enrollment & Gender logic to determine which data element to report the students in Students must be in both the Fall Snapshot IDEA Students & Fall Snapshot EL Students category mappings to report Report "0" if there is not a student that is eligible in a data element Report null if answers on question ENRL-1 data elements ENRL1.25 - ENRL1.27 are "0"
Show Totals in the question summary in the following groupings: Race/Ethnicity by Gender & Total Number by Gender, EL by Gender The totals in the summary will be updated upon hitting save. Totals are not reported, they are only there for data verification.
In the question detail screen, an override column will be next to the results with a text box next to each data element
Detail Report Logic will display the following information: Year, NCES School Number, School Name, Students PersonID, State ID, Name, Grade Name, Gender, Race/Ethnicity, IDEA, EL

ENRL-4: Enrollment of Students with Disabilities - Section 504 Only

Category Mapping: Fall Snapshot 504 Students, Fall Snapshot EL Students

Flat File Details:

Layout	Data Element	Male	Female
Permitted Values: Integer, NULL Length of Permitted Values: 7
ENRL4.1, ENRL4.2, ENRL4.3	Hispanic or Latino of any race	SCH_504ENR_HI_M	SCH_504ENR_HI_F
ENRL4.4, ENRL4.5, ENRL4.6	American Indian or Alaska Native	SCH_504ENR_AM_M	SCH_504ENR_AM_F
ENRL4.7, ENRL4.8, ENRL4.9	Asian	SCH_504ENR_AS_M	SCH_504ENR_AS_F
ENRL4.10, ENRL4.11, ENRL4.12	Native Hawaiian or Other Pacific Islander	SCH_504ENR_HP_M	SCH_504ENR_HP_F
ENRL4.13, ENRL4.14, ENRL4.15	Black or African American	SCH_504ENR_BL_M	SCH_504ENR_BL_F
ENRL4.16, ENRL4.17, ENRL4.18	White	SCH_504ENR_WH_M	SCH_504ENR_WH_F
ENRL4.19, ENRL4.20, ENRL4.21	Two or More races	SCH_504ENR_TR_M	SCH_504ENR_TR_F
Total
ENRL4.22, ENRL4.23, ENRL4.24	English Learners (EL)	SCH_504ENR_EL_M	SCH_504ENR_EL_F

Logic
ENRL4.1-ENRL4.21: Count and display the total number of distinct Fall Snapshot 504 Students that fall into each Data Element listed Use the Enrollment, Race/Ethnicity & Gender logic to determine which Data Element to report the students in Only report students who are selected and saved in the Fall Snapshot 504 Students category mapping for the reporting school Report "0" if there is not a student that is eligible in a data element Report null if answers on question ENRL-1 data elements ENRL1.28 - ENRL1.30 are "0"
ENRL4.22-ENRL4.24: Count and display the total number of Fall Snapshot 504 students who are also Fall Snapshot EL students that fall into each data element listed Use the Enrollment & Gender logic to determine which data element to report the students in Students must be in both the Fall Snapshot 504 Students & Fall Snapshot EL Students category mappings to report Report "0" if there is not a student that is eligible in a data element Report null if both answers on question ENRL-1 data elements ENRL1.28 - ENRL1.30 are "0"
Show Totals in the question summary in the following groupings: Race/Ethnicity by Gender & Total Number by Gender, EL by Gender The totals in the summary will be updated upon hitting save. Totals are not reported, they are only there for data verification.
In the question detail screen, an override column will be next to the results with a text box next to each data element
Detail Report Logic will display the following information: Year, NCES School Number, School Name, Students PersonID, State ID, Name, Grade Name, Gender, Race/Ethnicity, 504, EL

7. COUR: Courses & Classes

COUR-1: Grade 7/8 Algebra 1 Classes

Category Mapping: Algebra I - Grades 7 & 8

Flat File Details:

Permitted Values: Integer, NULL Length of Permitted Values: 7
COUR1.1	SCH_ALGCLASSES_GS0708	Number of Algebra I classes for students in grades 7-8

Permitted Values: Integer, NULL

Length of Permitted Values: 7

Layout

Element Name

Data Element

COUR1.1

SCH_ALGCLASSES_GS0708

Number of Algebra I classes for students in grades 7-8

Logic
Count and display the total number of Algebra I courses for the data element listed Use the Course Count logic to determine the values reported Only report courses that are selected and saved in the Algebra I - Grades 7 & 8 category mapping for the reporting school Report "0" if there is not a course that is eligible in a data element
In the question detail screen, an override column will be next to the results with a text box to enter in values
Detail Report Logic will display the following information: Year, NCES School Number, School Name, Course Number, Course Name, SectionID, Section Number

COUR-2: Grade 7 Algebra I Enrollment Indicator

Category Mapping: Grade Levels, Algebra I - Grades 7 & 8

Flat File Details:

Permitted Values: Yes, No, NULL Length of Permitted Values: 3
COUR2.1	SCH_ALGENR_G07_IND	Whether the school had any students in grade 7 enrolled in Algebra I

Permitted Values: Yes, No, NULL

Length of Permitted Values: 3

Layout

Element Name

Data Element

COUR2.1

SCH_ALGENR_G07_IND

Whether the school had any students in grade 7 enrolled in Algebra I

Logic
Report Yes if the school has at least 1 student enrolled in Algebra I in Grade 7 At least 1 eligible student must be scheduled into an eligible Algebra I course Use the Fall Snapshot Enrollment logic to determine if a student is eligible to report The students CRDC Grade Level must be = Grade 7 Only count courses that are selected and saved in the Algebra I - Grades 7 & 8 category mapping
Report No if the school does not have any students enrolled in Algebra in Grade 7
In the question detail screen, an override column will be next to the results with a droplist to select a value
Detail Report Logic will display the following information: Year, NCES School Number, School Name, Course Number, Course Name, SectionID, Section Number, Students PersonID, State ID, Name, Grade

COUR-3: Grade 8 Algebra I Enrollment Indicator

Category Mapping: Grade Levels, Algebra I - Grades 7 & 8

Flat File Details:

Permitted Values: Yes, No, NULL Length of Permitted Values: 3
COUR3.1	SCH_ALGENR_G08_IND	Whether the school had any students in grade 8 enrolled in Algebra I

Permitted Values: Yes, No, NULL

Length of Permitted Values: 3

Layout

Element Name

Data Element

COUR3.1

SCH_ALGENR_G08_IND

Whether the school had any students in grade 8 enrolled in Algebra I

Logic
Report Yes if the school has at least 1 student enrolled in Algebra I in Grade 8 At least 1 eligible student must be scheduled into an eligible Algebra I course Use the Fall Snapshot Enrollment logic to determine if a student is eligible to report The students CRDC Grade Level must be = Grade 8 Only count courses that are selected and saved in the Algebra I - Grades 7 & 8 category mapping
Report No if the school does not have any students enrolled in Algebra in Grade 8
In the question detail screen, an override column will be next to the results with a droplist to select a value
Detail Report Logic will display the following information: Year, NCES School Number, School Name, Course Number, Course Name, SectionID, Section Number, Students PersonID, State ID, Name, Grade Name

COUR-4a: Student Enrollment in Algebra I - Grades 7 & 8

Category Mapping: Grade Levels, Algebra I - Grades 7 & 8, Regular School Year IDEA Students, Regular School Year English Learners

Layout	Data Element	Male	Female
Permitted Values: Integer, NULL Length of Permitted Values: 7
COUR4a.1, COUR4a.2, COUR4a.3	Hispanic or Latino of any race	SCH_ALGENR_G0708_HI_M	SCH_ALGENR_G0708_HI_F
COUR4a.4, COUR4a.5, COUR4a.6	American Indian or Alaska Native	SCH_ALGENR_G0708_AM_M	SCH_ALGENR_G0708_AM_F
COUR4a.7, COUR4a.8, COUR4a.9	Asian	SCH_ALGENR_G0708_AS_M	SCH_ALGENR_G0708_AS_F
COUR4a.10, COUR4a.11, COUR4a.12	Native Hawaiian or Other Pacific Islander	SCH_ALGENR_G0708_HP_M	SCH_ALGENR_G0708_HP_F
COUR4a.13, COUR4a.14, COUR4a.15	Black or African American	SCH_ALGENR_G0708_BL_M	SCH_ALGENR_G0708_BL_F
COUR4a.16, COUR4a.17, COUR4a.18	White	SCH_ALGENR_G0708_WH_M	SCH_ALGENR_G0708_WH_F
COUR4a.19, COUR4a.20, COUR4a.21	Two or More races	SCH_ALGENR_G0708_TR_M	SCH_ALGENR_G0708_TR_F
Total
COUR4a.22, COUR4a.23, COUR4a.24	English Learners (EL)	SCH_ALGENR_G0708_EL_M	SCH_ALGENR_G0708_EL_F
COUR4a.25, COUR4a.26, COUR4a.27	Students with Disabilities (IDEA)	SCH_ALGENR_G0708_IDEA_M	SCH_ALGENR_G0708_IDEA_F

Logic
Report the distinct total number of students enrolled in Algebra I in Grade 7 or Grade 8 using the Student Roster Count logic. Only students who were included in the total for COUR-2 or COUR-3 can be reported in this question. At least 1 eligible student must be scheduled into an eligible Algebra I course using the Student Roster Count logic. Use the Regular School year Enrollment, Gender & Race/Ethnicity logic to determine if a student is eligible to report The students CRDC Grade Level must be = Grade 7 or Grade 8 Only count courses that are selected and saved in the Algebra I - Grade 7 or Grade 8 category mapping Only count students in the EL and IDEA data elements if they are selected and saved in the Regular School Year IDEA Students and/or Regular School Year EL Students category mappings
Report Null if the school does not have any students enrolled in Algebra I in Grade 7 or Grade 8
In the question detail screen, an override column will be next to the results with a droplist to select a value
Detail Report Logic will display the following information: Year, NCES School Number, School Name, Course Number, Course Name, SectionID, Section Number, Students PersonID, State ID, Name, Grade Name, EL, IDEA

COUR-4b: Students who Passed Algebra I - Grades 7 & 8

Category Mapping: Grade Levels, Algebra I - Grades 7 & 8, Regular School Year IDEA Students, Regular School Year EL Students

Flat File Details:

Layout	Data Element	Male	Female
Permitted Values: Integer, NULL Length of Permitted Values: 7
COUR4b.1, COUR4b.2, COUR4b.3	Hispanic or Latino of any race	SCH_ALGPASS_G0708_HI_M	SCH_ALGPASS_G0708_HI_F
COUR4b.4, COUR4b.5, COUR4b.6	American Indian or Alaska Native	SCH_ALGPASS_G0708_AM_M	SCH_ALGPASS_G0708_AM_F
COUR4b.7, COUR4b.8, COUR4b.9	Asian	SCH_ALGPASS_G0708_AS_M	SCH_ALGPASS_G0708_AS_F
COUR4b.10, COUR4b.11, COUR4b.12	Native Hawaiian or Other Pacific Islander	SCH_ALGPASS_G0708_HP_M	SCH_ALGPASS_G0708_HP_F
COUR4b.13, COUR4b.14, COUR4b.15	Black or African American	SCH_ALGPASS_G0708_BL_M	SCH_ALGPASS_G0708_BL_F
COUR4b.16, COUR4b.17, COUR4b.18	White	SCH_ALGPASS_G0708_WH_M	SCH_ALGPASS_G0708_WH_F
COUR4b.19, COUR4b.20, COUR4b.21	Two or More races	SCH_ALGPASS_G0708_TR_M	SCH_ALGPASS_G0708_TR_F
Total
COUR4b.22, COUR4b.23, COUR4b.24	English Learners (EL)	SCH_ALGPASS_G0708_EL_M	SCH_ALGPASS_G0708_EL_F
COUR4b.25, COUR4b.26, COUR4b.27	Students with Disabilities (IDEA)	SCH_ALGPASS_G0708_IDEA_M	SCH_ALGPASS_G0708_IDEA_F

Logic
Report the distinct total number of students who passed Algebra I in Grade 7 and Grade 8 on the last using the Student Roster Count logic of the school year. Only students who were included in the total for COUR-2 or COUR-3 can be reported in this question. The student must be scheduled into an eligible Algebra I course Use the Regular School Year Enrollment, Gender & Race/Ethnicity logic to determine if a student is eligible to report The students CRDC Grade Level must be = Grade 7 or Grade 8 on the last day of the school year Only count courses that are selected and saved in the Algebra I - Grades 7 & 8 category mapping Only count students in the EL and IDEA data elements if they are selected and saved in the Regular School Year IDEA Students and/or Regular School Year EL Students category mappings
The student must have a passing score in at least 1 Algebra I course based on the Passing Score Indicator identified on the Algebra I - Grades 7 & 8 category mapping If Grading Task is selected as the passing score indicator count the student if they meet the following: The student has a posted grade to all of the grading tasks selected and are marked as passing A passing score is when the posted score has the Passing check box checked on the score group aligned to the grading tasks If Transcript is selected as the passing score indicator count the student if they meet the following The student has a posted transcript record for the course in the reporting school year and the sum of the total number of credits earned is > or = the total # of credits on the Algebra I - Grades 7 & 8 category mapping Use the Course Number to identify matching courses from the category mapping to transcript records Sum all credits earned from all transcript records in the reporting year that having a matching course number If Advanced Options are saved, use the passing score indicator selected and the Advanced Options logic to count the student: If more than 1 course is saved in the Course Requirement box, the student must pass all courses identified in 1 row to be counted. If Grading Task is selected as the passing score indicator, the student must have a passing score for all selected grading tasks on the required courses If Transcript is selected as the passing score indicator, the student must have a posted transcript record for all the courses selected in the required courses in the reporting school year and the sum of the total number of credits earned is > or = the total # of credit. If the total number of credits is added to advanced options and there are total # of credits on the pass score options, the student must meet that total number of credits entered in the advanced options If there is more than 1 Course requirement row added to advanced options, the student only has to meet the requirements in 1 of the options to be reported.
Report 0 if there are no students that meet the reporting criteria
Report NULL if the answer for COUR-2 and COUR-3 is NULL or '0'
In the question detail screen, an override column will be next to the results with a text box to select a value
The user will be able to select a link on a result and a side panel will display the eligible students Students will only appear 1 time in the side panel even if they pass more than 1 eligible course
Detail Report Logic will display the following information: Year, NCES School Number, School Name, Course Number, Course Name, SectionID, Section Number, Students PersonID, State ID, Name, Grade Name, EL, IDEA A student/course combination will appear more than 1 time in the export if the course crosses multiple sections but will only be counted 1 time The export looks at the current Passing Score Criteria on the Course Mapping to display students. If this was changed after the results were generated, it is possible the results will not match the export totals.

COUR-5: Grade 8 Geometry Enrollment Indicator

Category Mapping: Grade Levels, Geometry - Grade 8

Flat File Details:

Permitted Values: Yes, No, NULL Length of Permitted Values: 3
COUR5.1	SCH_GEOMENR_G08_IND	Whether the school had any students in grade 8 enrolled in Geometry

Permitted Values: Yes, No, NULL

Length of Permitted Values: 3

Layout

Element Name

Data Element

COUR5.1

SCH_GEOMENR_G08_IND

Whether the school had any students in grade 8 enrolled in Geometry

Logic
Report Yes if the school has at least 1 student enrolled in Geometry in Grade 8 on the Fall Snapshot Date At least 1 eligible student must be scheduled into an eligible Geometry course using the Student Roster Count logic. Use the Fall Snapshot Enrollment logic to determine if a student is eligible to report The students CRDC Grade Level must be = Grade 8 Only count courses that are selected and saved in the Geometry - Grade 8 category mapping
Report No if the school does not have any students enrolled in Geometry in Grade 8
In the question detail screen, an override column will be next to the results with a droplist to select a value
Detail Report Logic will display the following information: Year, NCES School Number, School Name, Course Number, Course Name, SectionID, Section Number, Students PersonID, State ID, Name, Grade Name

COUR-6: Student Enrollment in Geometry in Grade 8

Category Mapping: Grade Levels, Geometry - Grade 8

Flat File Details:

Permitted Values: Integer, NULL Length of Permitted Values: 7
COUR6.1	SCH_GEOMENR_G08	Total Number of Students

Permitted Values: Integer, NULL

Length of Permitted Values: 7

Layout

Element Name

Data Element

COUR6.1

SCH_GEOMENR_G08

Total Number of Students

Logic
Report the distinct total number of students enrolled in Geometry in Grade 8 for each data element The student must be scheduled into an eligible Geometry course using the Student Roster Count logic Use the Fall Snapshot Enrollment logic to determine if a student is eligible to report The students CRDC Grade Level must be = Grade 8 Only count courses that are selected and saved in the Geometry - Grade 8 category mapping
Report 0 if there are no students that meet the reporting criteria for the data element
Report NULL if the answer for COUR-5 is NULL or No
In the question detail screen, an override column will be next to the results with a text box to select a value
Detail Report Logic will display the following information: Year, NCES School Number, School Name, Course Number, Course Name, SectionID, Section Number, Students PersonID, State ID, Name, Grade Name

COUR-7: Classes in Mathematics Courses in High School

Category Mapping: Algebra I - High School, Algebra II, Geometry - High School, Advanced Mathematics, Calculus

Flat File Details:

Layout	Element Name	Data Element
Permitted Values: Integer, NULL Length of Permitted Values: 7
COUR7.1	SCH_MATHCLASSES_ALG	Number of High School Algebra I Classes
COUR7.2	SCH_MATHCLASSES_GEOM	Number of High School Geometry Classes
COUR7.3	SCH_MATHCLASSES_ALG2	Number of High School Algebra II Classes
COUR7.4	SCH_MATHCLASSES_ADVM	Number of High School Advanced Mathematics Classes
COUR7.5	SCH_MATHCLASSES_CALC	Number of High School Calculus Classes

Logic
Count and display the total number of Geometry, Algebra I, Algebra II, Advanced Mathematics & Calculus courses for the data element listed Use the Course Count logic to determine the values reported Only report courses that are selected and saved in the Geometry - High School, Algebra I - High School, Algebra II, Advanced Mathematics & Calculus category mappings for the reporting school Report "0" if there is not a course that is eligible in a data element
In the question detail screen, an override column will be next to the results with a text box to enter in values
Detail Report Logic will display the following information: Year, NCES School Number, School Name, Course Number, Course Name, SectionID, Section Number

COUR-8a: High School Student Enrollment in Algebra I - Grades 9 & 10

Category Mapping: Grade Levels, Algebra I - High School, Regular School Year IDEA Students, Regular School Year EL Students

Flat File Details:

Layout	Data Element	Male	Female
Permitted Values: Integer, NULL Length of Permitted Values: 7
COUR8a.1, COUR8a.2, COUR8a.3	Hispanic or Latino of any race	SCH_ALGENR_GS0910_HI_M	SCH_ALGENR_GS0910_HI_F
COUR8a.4, COUR8a.5, COUR8a.6	American Indian or Alaska Native	SCH_ALGENR_GS0910_AM_M	SCH_ALGENR_GS0910_AM_F
COUR8a.7, COUR8a.8, COUR8a.9	Asian	SCH_ALGENR_GS0910_AS_M	SCH_ALGENR_GS0910_AS_F
COUR8a.10, COUR8a.11, COUR8a.12	Native Hawaiian or Other Pacific Islander	SCH_ALGENR_GS0910_HP_M	SCH_ALGENR_GS0910_HP_F
COUR8a.13, COUR8a.14, COUR8a.15	Black or African American	SCH_ALGENR_GS0910_BL_M	SCH_ALGENR_GS0910_BL_F
COUR8a.16, COUR8a.17, COUR8a.18	White	SCH_ALGENR_GS0910_WH_M	SCH_ALGENR_GS0910_WH_F
COUR8a.19, COUR8a.20, COUR8a.21	Two or More races	SCH_ALGENR_GS0910_TR_M	SCH_ALGENR_GS0910_TR_F
Total
COUR8a.22, COUR8a.23, COUR8a.24	English Learners (EL)	SCH_ALGENR_GS0910_EL_M	SCH_ALGENR_GS0910_EL_F
COUR8a.25, COUR8a.26, COUR8a.27	Students with Disabilities (IDEA)	SCH_ALGENR_GS0910_IDEA_M	SCH_ALGENR_GS0910_IDEA_F

Logic
Report the total number of distinct students enrolled in Algebra I in Grades 9 or 10 for each data element The student must be scheduled into an eligible Algebra I course using the Student Roster Count logic Use the Enrollment logic to determine if a student is eligible to report The students CRDC Grade Level must be = Grade 9 or 10 Only count courses that are selected and saved in the Algebra I - High School category mapping Only count students in the EL and IDEA data elements if they are selected and saved in the Regular School Year IDEA Students and/or Regular School Year EL Students category mappings
Report 0 if there are no students that meet the reporting criteria for the data element
In the question detail screen, an override column will be next to the results with a text box to select a value
Detail Report Logic will display the following information: Year, NCES School Number, School Name, Course Number, Course Name, SectionID, Section Number, Students PersonID, State ID, Name, Grade Name, EL, IDEA

COUR-8b: High School Students who Passed Algebra I - Grades 9 & 10

Category Mapping: Grade Levels, Algebra I - High School, Regular School Year IDEA Students, Regular School Year EL Students

Flat File Details:

Layout	Data Element	Male	Female
Permitted Values: Integer, NULL Length of Permitted Values: 7
COUR8b.1, COUR8b.2, COUR8b.3	Hispanic or Latino of any race	SCH_ALGPASS_GS0910_HI_M	SCH_ALGPASS_GS0910_HI_F
COUR8b.4, COUR8b.5, COUR8b.6	American Indian or Alaska Native	SCH_ALGPASS_GS0910_AM_M	SCH_ALGPASS_GS0910_AM_F
COUR8b.7, COUR8b.8, COUR8b.9	Asian	SCH_ALGPASS_GS0910_AS_M	SCH_ALGPASS_GS0910_AS_F
COUR8b.10, COUR8b.11, COUR8b.12	Native Hawaiian or Other Pacific Islander	SCH_ALGPASS_GS0910_HP_M	SCH_ALGPASS_GS0910_HP_F
COUR8b.13, COUR8b.14, COUR8b.15	Black or African American	SCH_ALGPASS_GS0910_BL_M	SCH_ALGPASS_GS0910_BL_F
COUR8b.16, COUR8b.17, COUR8b.18	White	SCH_ALGPASS_GS0910_WH_M	SCH_ALGPASS_GS0910_WH_F
COUR8b.19, COUR8b.20, COUR8b.21	Two or More races	SCH_ALGPASS_GS0910_TR_M	SCH_ALGPASS_GS0910_TR_F
Total
COUR8b.22, COUR8b.23, COUR8b.24	English Learners (EL)	SCH_ALGPASS_GS0910_EL_M	SCH_ALGPASS_GS0910_EL_F
COUR8b.25, COUR8b.26, COUR8b.27	Students with Disabilities (IDEA)	SCH_ALGPASS_GS0910_IDEA_M	SCH_ALGPASS_GS0910_IDEA_F

Logic
Report the distinct total number of students who passed Algebra I in Grades 9 or 10. Only students who were included in the total for COUR-8a can be reported in this question. The student must be scheduled into an eligible Algebra I course using the Student Roster Count logic Use the Regular School Year Enrollment, Gender & Race/Ethnicity logic to determine if a student is eligible to report The students CRDC Grade Level must be = Grades 9, 10 Only count courses that are selected and saved in the Algebra I - High School category mapping Only count students in the EL and IDEA data elements if they are selected and saved in the Regular School Year IDEA Students and/or Regular School Year EL Students category mappings
The student must have a passing score in at least 1 Algebra I course based on the Passing Score Indicator identified on the Algebra I - High School category mapping If Grading Task is selected as the passing score indicator count the student if they meet the following: The student has a posted grade to all of the grading tasks selected and are marked as passing A passing score is when the posted score has the Passing check box checked on the score group aligned to the grading tasks If Transcript is selected as the passing score indicator count the student if they meet the following The student has a posted transcript record for the course in the reporting school year and the sum of the total number of credits earned is > or = the total # of credits on the Algebra I - Grades High School category mapping Use the Course Number to identify matching courses from the category mapping to transcript records Sum all earned from all transcript records in the reporting year that having a matching course number If Advanced Ocreditsptions are saved, use the passing score indicator selected and the Advanced Options logic to count the student: If more than 1 course is saved in the Course Requirement box, the student must pass all courses identified in 1 row to be counted. If Grading Task is selected as the passing score indicator, the student must have a passing score for all selected grading tasks on the required courses If Transcript is selected as the passing score indicator, the student must have a posted transcript record for all the courses selected in the required courses in the reporting school year and the sum of the total number of credits earned is > or = the total # of credit. If the total number of credits is added to advanced options and there are total # of credits on the pass score options, the student must meet that total number of credits entered in the advanced options If there is more than 1 Course requirement row added to advanced options, the student only has to meet the requirements in 1 of the options to be reported.
Report 0 if there are no students that meet the reporting criteria
Report NULL if the answer to question COUR-8a is '0'
In the question detail screen, an override column will be next to the results with a text box to select a value
The user will be able to select a link on a result and a side panel will display the eligible students Students will only appear 1 time in the side panel even if they pass more than 1 eligible course
Detail Report Logic will display the following information: Year, NCES School Number, School Name, Course Number, Course Name, SectionID, Section Number, Students PersonID, State ID, Name, Grade Name, EL, IDEA A student/course combination will appear more than 1 time in the export if the course crosses multiple sections but will only be counted 1 time The export looks at the current Passing Score Criteria on the Course Mapping to display students. If this was changed after the results were generated, it is possible the results will not match the export totals.

COUR-9a: High School Student Enrollment in Algebra I - Grades 11 & 12

Category Mapping: Grade Levels, Algebra I - High School, Regular School Year IDEA Students, Regular School Year EL Students

Flat File Details:

Layout	Data Element	Male	Female
Permitted Values: Integer, NULL Length of Permitted Values: 7
COUR9a.1,COUR9a.2,COUR9a.3	Hispanic or Latino of any race	SCH_ALGENR_GS1112_HI_M	SCH_ALGENR_GS1112_HI_F
COUR9a.4,COUR9a.5,COUR9a.6	American Indian or Alaska Native	SCH_ALGENR_GS1112_AM_M	SCH_ALGENR_GS1112_AM_F
COUR9a.7,COUR9a.8,COUR9a.9	Asian	SCH_ALGENR_GS1112_AS_M	SCH_ALGENR_GS1112_AS_F
COUR9a.10,COUR9a.11,COUR9a.12	Native Hawaiian or Other Pacific Islander	SCH_ALGENR_GS1112_HP_M	SCH_ALGENR_GS1112_HP_F
COUR9a.13,COUR9a.14,COUR9a.15	Black or African American	SCH_ALGENR_GS1112_BL_M	SCH_ALGENR_GS1112_BL_F
COUR9a.16,COUR9a.17,COUR9a.18	White	SCH_ALGENR_GS1112_WH_M	SCH_ALGENR_GS1112_WH_F
COUR9a.19,COUR9a.20,COUR9a.21	Two or More races	SCH_ALGENR_GS1112_TR_M	SCH_ALGENR_GS1112_TR_F
Total
COUR9a.22,COUR9a.23,COUR9a.24	English Learners (EL)	SCH_ALGENR_GS1112_EL_M	SCH_ALGENR_GS1112_EL_F
COUR9a.25,COUR9a.26,COUR9a.27	Students with Disabilities (IDEA)	SCH_ALGENR_GS1112_IDEA_M	SCH_ALGENR_GS1112_IDEA_F

Logic
Report the total number of distinct students enrolled in Algebra I in Grades 11 or 12 for each data element The student must be scheduled into an eligible Algebra I course using the Student Roster Count logic Use the Enrollment logic to determine if a student is eligible to report The students CRDC Grade Level must be = Grade 11 or 12 Only count courses that are selected and saved in the Algebra I - High School category mapping Only count students in the EL and IDEA data elements if they are selected and saved in the Regular School Year IDEA Students and/or Regular School Year EL Students category mappings
Report 0 if there are no students that meet the reporting criteria for the data element
In the question detail screen, an override column will be next to the results with a text box to select a value
Detail Report Logic will display the following information: Year, NCES School Number, School Name, Course Number, Course Name, SectionID, Section Number, Students PersonID, State ID, Name, Grade Name, EL, IDEA

COUR-9b: High School Students who Passed Algebra 1 - Grades 11 & 12

Category Mapping: Grade Levels, Algebra I - High School, Regular School Year IDEA Students, Regular School Year EL Students

Flat File Details:

Layout	Data Element	Male	Female
Permitted Values: Integer, NULL Length of Permitted Values: 7
COUR9b.1, COUR9b.2, COUR9b.3	Hispanic or Latino of any race	SCH_ALGPASS_GS1112_HI_M	SCH_ALGPASS_GS1112_HI_F
COUR9b.4, COUR9b.5, COUR9b.6	American Indian or Alaska Native	SCH_ALGPASS_GS1112_AM_M	SCH_ALGPASS_GS1112_AM_F
COUR9b.7, COUR9b.8, COUR9b.9	Asian	SCH_ALGPASS_GS1112_AS_M	SCH_ALGPASS_GS1112_AS_F
COUR9b.10, COUR9b.11, COUR9b.12	Native Hawaiian or Other Pacific Islander	SCH_ALGPASS_GS1112_HP_M	SCH_ALGPASS_GS1112_HP_F
COUR9b.13, COUR9b.14, COUR9b.15	Black or African American	SCH_ALGPASS_GS1112_BL_M	SCH_ALGPASS_GS1112_BL_F
COUR9b.16, COUR9b.17, COUR9b.18	White	SCH_ALGPASS_GS1112_WH_M	SCH_ALGPASS_GS1112_WH_F
COUR9b.19, COUR9b.20, COUR9b.21	Two or More races	SCH_ALGPASS_GS1112_TR_M	SCH_ALGPASS_GS1112_TR_F
Total
COUR9b.22, COUR9b.23, COUR9b.24	English Learners (EL)	SCH_ALGPASS_GS1112_EL_M	SCH_ALGPASS_GS1112_EL_F
COUR9b.25, COUR9b.26, COUR9b.27	Students with Disabilities (IDEA)	SCH_ALGPASS_GS1112_IDEA_M	SCH_ALGPASS_GS1112_IDEA_F

Logic
Report the distinct total number of students who passed Algebra I in Grades 11 or 12. Only students who were included in the total for COUR-9a can be reported in this question. The student must be scheduled into an eligible Algebra I course using the Student Roster Count logic Use the Regular School Year Enrollment, Gender & Race/Ethnicity logic to determine if a student is eligible to report The students CRDC Grade Level must be = Grades 11, 12 Only count courses that are selected and saved in the Algebra I - High School category mapping Only count students in the EL and IDEA data elements if they are selected and saved in the Regular School Year IDEA Students and/or Regular School Year EL Students category mappings
The student must have a passing score in at least 1 Algebra I course based on the Passing Score Indicator identified on the Algebra I - High School category mapping If Grading Task is selected as the passing score indicator count the student if they meet the following: The student has a posted grade to all of the grading tasks selected and are marked as passing A passing score is when the posted score has the Passing check box checked on the score group aligned to the grading tasks If Transcript is selected as the passing score indicator count the student if they meet the following The student has a posted transcript record for the course in the reporting school year and the sum of the total number of credits earned is > or = the total # of credits on the Algebra I - Grades High School category mapping Use the Course Number to identify matching courses from the category mapping to transcript records Sum all credits earned from all transcript records in the reporting year that having a matching course number If Advanced Options are saved, use the passing score indicator selected and the Advanced Options logic to count the student: If more than 1 course is saved in the Course Requirement box, the student must pass all courses identified in 1 row to be counted. If Grading Task is selected as the passing score indicator, the student must have a passing score for all selected grading tasks on the required courses If Transcript is selected as the passing score indicator, the student must have a posted transcript record for all the courses selected in the required courses in the reporting school year and the sum of the total number of credits earned is > or = the total # of credit. If the total number of credits is added to advanced options and there are total # of credits on the pass score options, the student must meet that total number of credits entered in the advanced options If there is more than 1 Course requirement row added to advanced options, the student only has to meet the requirements in 1 of the options to be reported.
Report 0 if there are no students that meet the reporting criteria
Report NULL if the answer to question COUR-9a is '0'
In the question detail screen, an override column will be next to the results with a text box to select a value
The user will be able to select a link on a result and a side panel will display the eligible students Students will only appear 1 time in the side panel even if they pass more than 1 eligible course
Detail Report Logic will display the following information: Year, NCES School Number, School Name, Course Number, Course Name, SectionID, Section Number, Students PersonID, State ID, Name, Grade Name, EL, IDEA A student/course combination will appear more than 1 time in the export if the course crosses multiple sections but will only be counted 1 time The export looks at the current Passing Score Criteria on the Course Mapping to display students. If this was changed after the results were generated, it is possible the results will not match the export totals.

COUR-10: Student Enrollment in Mathemantics Courses in High School - Geometry

Category Mapping: Grade Levels, Geometry - High School, Fall Snapshot IDEA Students, Fall Snapshot EL Students

Flat File Details:

Layout	Data Element	Male	Female
Permitted Values: Integer, NULL Length of Permitted Values: 7
COUR10.1, COUR10.2, COUR10.3	Hispanic or Latino of any race	SCH_MATHENR_GEOM_HI_M	SCH_MATHENR_GEOM_HI_F
COUR10.4, COUR10.5, COUR10.6	American Indian or Alaska Native	SCH_MATHENR_GEOM_AM_M	SCH_MATHENR_GEOM_AM_F
COUR10.7, COUR10.8, COUR10.9	Asian	SCH_MATHENR_GEOM_AS_M	SCH_MATHENR_GEOM_AS_F
COUR10.10, COUR10.11, COUR10.12	Native Hawaiian or Other Pacific Islander	SCH_MATHENR_GEOM_HP_M	SCH_MATHENR_GEOM_HP_F
COUR10.13, COUR10.14, COUR10.15	Black or African American	SCH_MATHENR_GEOM_BL_M	SCH_MATHENR_GEOM_BL_F
COUR10.16, COUR10.17, COUR10.18	White	SCH_MATHENR_GEOM_WH_M	SCH_MATHENR_GEOM_WH_F
COUR10.19, COUR10.20, COUR10.21	Two or More races	SCH_MATHENR_GEOM_TR_M	SCH_MATHENR_GEOM_TR_F
Total
COUR10.22, COUR10.23, COUR10.24	English Learners (EL)	SCH_MATHENR_GEOM_EL_M	SCH_MATHENR_GEOM_EL_F
COUR10.25, COUR10.26, COUR10.27	Students with Disabilities (IDEA)	SCH_MATHENR_GEOM_IDEA_M	SCH_MATHENR_GEOM_IDEA_F

Logic
Report the total number of distinct students enrolled in Geometry in Grades 9, 10, 11 or 12 for each data element The student must be scheduled into an eligible Geometry course using the Student Roster Count logic Use the Fall Snapshot Enrollment logic to determine if a student is eligible to report The students CRDC Grade Level must be = Grade 9, 10, 11 or 12 Only count courses that are selected and saved in the Geometry - High School category mapping Only count students in the EL and IDEA data elements if they are selected and saved in the Fall Snapshot IDEA Students and/or Fall Snapshot EL Students category mappings
Report 0 if there are no students that meet the reporting criteria for the data element
Report NULL if the answer for question COUR-7, Geometry is '0'
In the question detail screen, an override column will be next to the results with a text box to select a value
Detail Report Logic will display the following information: Year, NCES School Number, School Name, Course Number, Course Name, SectionID, Section Number, Students PersonID, State ID, Name, Grade Name, EL, IDEA

COUR-11: Student Enrollment in Mathematics Courses in High School - Algebra II

Category Mapping: Grade Levels, Algebra II, Fall Snapshot date IDEA Students, Fall Snapshot date EL Students

Flat File Details:

Layout	Data Element	Male	Female
Permitted Values: Integer, NULL Length of Permitted Values: 7
COUR11.1, COUR11.2, COUR11.3	Hispanic or Latino of any race	SCH_MATHENR_ALG2_HI_M	SCH_MATHENR_ALG2_HI_F
COUR11.4, COUR11.5, COUR11.6	American Indian or Alaska Native	SCH_MATHENR_ALG2_AM_M	SCH_MATHENR_ALG2_AM_F
COUR11.7, COUR11.8, COUR11.9	Asian	SCH_MATHENR_ALG2_AS_M	SCH_MATHENR_ALG2_AS_F
COUR11.10, COUR11.11, COUR11.12	Native Hawaiian or Other Pacific Islander	SCH_MATHENR_ALG2_HP_M	SCH_MATHENR_ALG2_HP_F
COUR11.13, COUR11.14, COUR11.15	Black or African American	SCH_MATHENR_ALG2_BL_M	SCH_MATHENR_ALG2_BL_F
COUR11.16, COUR11.17, COUR11.18	White	SCH_MATHENR_ALG2_WH_M	SCH_MATHENR_ALG2_WH_F
COUR11.19, COUR11.20, COUR11.21	Two or More races	SCH_MATHENR_ALG2_TR_M	SCH_MATHENR_ALG2_TR_F
Total
COUR11.22, COUR11.23, COUR11.24	English Learners (EL)	SCH_MATHENR_ALG2_EL_M	SCH_MATHENR_ALG2_EL_F
COUR11.25, COUR11.26, COUR11.27	Students with Disabilities (IDEA)	SCH_MATHENR_ALG2_IDEA_M	SCH_MATHENR_ALG2_IDEA_F

Logic
Report the total number of distinct students enrolled in Algebra II in Grades 9, 10, 11 or 12 for each data element The student must be scheduled into an eligible Algebra II course using the Student Roster Count logic Use the Fall Snapshot Enrollment logic to determine if a student is eligible to report The students CRDC Grade Level must be = Grade 9, 10, 11 or 12 Only count courses that are selected and saved in the Algebra II category mapping Only count students in the EL and IDEA data elements if they are selected and saved in the Fall Snapshot date IDEA Students and/or Fall Snapshot date EL Students category mappings
Report 0 if there are no students that meet the reporting criteria for the data element
Report NULL if the answer for question COUR-7, Algebra II is '0'
In the question detail screen, an override column will be next to the results with a text box to select a value
Detail Report Logic will display the following information: Year, NCES School Number, School Name, Course Number, Course Name, SectionID, Section Number, Students PersonID, State ID, Name, Grade Name, EL, IDEA

COUR-12: Student Enrollment in Mathematics Courses in High School - Advanced Mathematics

Category Mapping: Grade Levels, Advanced Mathematics, Fall Snapshot date IDEA Students, Fall Snapshot date EL Students

Flat File Details:

Layout	Data Element	Male	Female
Permitted Values: Integer, NULL Length of Permitted Values: 7
COUR12.1, COUR12.2, COUR12.3	Hispanic or Latino of any race	SCH_MATHENR_ADVM_HI_M	SCH_MATHENR_ADVM_HI_F
COUR12.4, COUR12.5, COUR12.6	American Indian or Alaska Native	SCH_MATHENR_ADVM_AM_M	SCH_MATHENR_ADVM_AM_F
COUR12.7, COUR12.8, COUR12.9	Asian	SCH_MATHENR_ADVM_AS_M	SCH_MATHENR_ADVM_AS_F
COUR12.10, COUR12.11, COUR12.12	Native Hawaiian or Other Pacific Islander	SCH_MATHENR_ADVM_HP_M	SCH_MATHENR_ADVM_HP_F
COUR12.13, COUR12.14, COUR12.15	Black or African American	SCH_MATHENR_ADVM_BL_M	SCH_MATHENR_ADVM_BL_F
COUR12.16, COUR12.17, COUR12.18	White	SCH_MATHENR_ADVM_WH_M	SCH_MATHENR_ADVM_WH_F
COUR12.19, COUR12.20, COUR12.21	Two or More races	SCH_MATHENR_ADVM_TR_M	SCH_MATHENR_ADVM_TR_F
Total
COUR12.22, COUR12.23, COUR12.24	English Learners (EL)	SCH_MATHENR_ADVM_EL_M	SCH_MATHENR_ADVM_EL_F
COUR12.25, COUR12.26, COUR12.27	Students with Disabilities (IDEA)	SCH_MATHENR_ADVM_IDEA_M	SCH_MATHENR_ADVM_IDEA_F

Logic
Report the total number of distinct students enrolled in Advanced Mathematics in Grades 9, 10, 11 or 12 for each data element The student must be scheduled into an eligible Advanced Mathematics course using the Student Roster Count logic Use the Fall Snapshot Enrollment logic to determine if a student is eligible to report The students CRDC Grade Level must be = Grades 9, 10, 11 or 12 Only count courses that are selected and saved in the Advanced Mathematics category mapping Only count courses that are selected and saved in the Advanced Mathematics category mapping Only count students in the EL and IDEA data elements if they are selected and saved in the Fall Snapshot date IDEA Students and/or Fall Snapshot date EL Students category mappings
Report 0 if there are no students that meet the reporting criteria for the data element
Report NULL if the answer for question COUR-7, Advanced Mathematics is '0'
In the question detail screen, an override column will be next to the results with a text box to select a value
Detail Report Logic will display the following information: Year, NCES School Number, School Name, Course Number, Course Name, SectionID, Section Number, Students PersonID, State ID, Name, Grade Name, EL, IDEA

COUR-13: Student Enrollment in Mathematics Courses in High School - Algebra II

Category Mapping: Grade Levels, Calculus, Fall Snapshot IDEA Students, Fall Snapshot EL Students

Flat File Details:

Layout	Data Element	Male	Female
Permitted Values: Integer, NULL Length of Permitted Values: 7
COUR13.1, COUR13.2, COUR13.3	Hispanic or Latino of any race	SCH_MATHENR_CALC_HI_M	SCH_MATHENR_CALC_HI_F
COUR13.4, COUR13.5, COUR13.6	American Indian or Alaska Native	SCH_MATHENR_CALC_AM_M	SCH_MATHENR_CALC_AM_F
COUR13.7, COUR13.8, COUR13.9	Asian	SCH_MATHENR_CALC_AS_M	SCH_MATHENR_CALC_AS_F
COUR13.10, COUR13.11, COUR13.12	Native Hawaiian or Other Pacific Islander	SCH_MATHENR_CALC_HP_M	SCH_MATHENR_CALC_HP_F
COUR13.13, COUR13.14, COUR13.15	Black or African American	SCH_MATHENR_CALC_BL_M	SCH_MATHENR_CALC_BL_F
COUR13.16, COUR13.17, COUR13.18	White	SCH_MATHENR_CALC_WH_M	SCH_MATHENR_CALC_WH_F
COUR13.19, COUR13.20, COUR13.21	Two or More races	SCH_MATHENR_CALC_TR_M	SCH_MATHENR_CALC_TR_F
Total
COUR13.22, COUR13.23, COUR13.24	English Learners (EL)	SCH_MATHENR_CALC_EL_M	SCH_MATHENR_CALC_EL_F
COUR13.25, COUR13.26, COUR13.27	Students with Disabilities (IDEA)	SCH_MATHENR_CALC_IDEA_M	SCH_MATHENR_CALC_IDEA_F

Logic
Report the total number of distinct students enrolled in Calculus in Grades 9, 10, 11 or 12 for each data element The student must be scheduled into an eligible Calculus course using the Student Roster Count logic Use the Fall Snapshot Enrollment logic to determine if a student is eligible to report The students CRDC Grade Level must be = Grades 9, 10, 11 or 12 Only count courses that are selected and saved in the Calculus category mapping Only count students in the EL and IDEA data elements if they are selected and saved in the Fall Snapshot IDEA Students and/or Fall Snapshot EL Students category mappings
Report 0 if there are no students that meet the reporting criteria for the data element
Report NULL if the answer for question COUR-7, Calculus is '0'
In the question detail screen, an override column will be next to the results with a text box to select a value
Detail Report Logic will display the following information: Year, NCES School Number, School Name, Course Number, Course Name, SectionID, Section Number, Students PersonID, State ID, Name, Grade Name, EL, IDEA

COUR-14: Classes in Science Courses

Category Mapping: Biology, Chemistry, Physics

Flat File Details:

Layout	Element Name	Data Element
Permitted Values: Integer, NULL Length of Permitted Values: 7
COUR-14.1	SCH_SCICLASSES_BIOL	Number of Biology Classes
COUR-14.2	SCH_SCICLASSES_CHEM	Number of Chemistry Classes
COUR-14.3	SCH_SCICLASSES_PHYS	Number of Physics Classes

Logic
Count and display the total number of Biology, Chemistry & Physics courses for the data element listed Use the Course Count logic to determine the values reported Only report courses that are selected and saved in the Biology, Chemistry & Physics category mappings for the reporting school Report "0" if there is not a course that is eligible in a data element
In the question detail screen, an override column will be next to the results with a text box to enter in values
Detail Report Logic will display the following information: Year, NCES School Number, School Name, Course Number, Course Name, SectionID, Section Number

COUR-15: Student Enrollment in Science Courses - Biology

Category Mapping: Grade Levels, Biology, Fall Snapshot IDEA Students, Fall Snapshot EL Students

Layout	Data Element	Male	Female
Permitted Values: Integer, NULL Length of Permitted Values: 7
COUR15.1, COUR15.2, COUR15.3	Hispanic or Latino of any race	SCH_SCIENR_BIOL_HI_M	SCH_SCIENR_BIOL_HI_F
COUR15.4, COUR15.5, COUR15.6	American Indian or Alaska Native	SCH_SCIENR_BIOL_AM_M	SCH_SCIENR_BIOL_AM_F
COUR15.7, COUR15.8, COUR15.9	Asian	SCH_SCIENR_BIOL_AS_M	SCH_SCIENR_BIOL_AS_F
COUR15.10, COUR15.11, COUR15.12	Native Hawaiian or Other Pacific Islander	SCH_SCIENR_BIOL_HP_M	SCH_SCIENR_BIOL_HP_F
COUR15.13, COUR15.14, COUR15.15	Black or African American	SCH_SCIENR_BIOL_BL_M	SCH_SCIENR_BIOL_BL_F
COUR15.16, COUR15.17, COUR15.18	White	SCH_SCIENR_BIOL_WH_M	SCH_SCIENR_BIOL_WH_F
COUR15.19, COUR15.20, COUR15.21	Two or More races	SCH_SCIENR_BIOL_TR_M	SCH_SCIENR_BIOL_TR_F
Total
COUR15.22, COUR15.23, COUR15.24	English Learners (EL)	SCH_SCIENR_BIOL_EL_M	SCH_SCIENR_BIOL_EL_F
COUR15.25, COUR15.26, COUR15.27	Students with Disabilities (IDEA)	SCH_SCIENR_BIOL_IDEA_M	SCH_SCIENR_BIOL_IDEA_F

Logic
Report the total number of distinct students enrolled in Biology in Grades 9, 10, 11 or 12 for each data element The student must be scheduled into an eligible Biology course using the Student Roster Count logic Use the Fall Snapshot Enrollment logic to determine if a student is eligible to report The students CRDC Grade Level must be = Grade 9, 10, 11 or 12 Only count courses that are selected and saved in the Biology category mapping Only count students in the EL and IDEA data elements if they are selected and saved in the Fall Snapshot IDEA Students and/or Fall Snapshot EL Students category mappings
Report 0 if there are no students that meet the reporting criteria for the data element
Report NULL if the answer for question COUR-14, Biology is '0'
In the question detail screen, an override column will be next to the results with a text box to select a value
Detail Report Logic will display the following information: Year, NCES School Number, School Name, Course Number, Course Name, SectionID, Section Number, Students PersonID, State ID, Name, Grade Name, EL, IDEA

COUR-16: Student Enrollment in Science Courses - Chemistry

Category Mapping: Grade Levels, Chemistry, Fall Snapshot IDEA Students, Fall Snapshot EL Students

Flat File Details:

Layout	Data Element	Male	Female
Permitted Values: Integer, NULL Length of Permitted Values: 7
COUR16.1, COUR16.2, COUR16.3	Hispanic or Latino of any race	SCH_SCIENR_CHEM_HI_M	SCH_SCIENR_CHEM_HI_F
COUR16.4, COUR16.5, COUR16.6	American Indian or Alaska Native	SCH_SCIENR_CHEM_AM_M	SCH_SCIENR_CHEM_AM_F
COUR16.7, COUR16.8, COUR16.9	Asian	SCH_SCIENR_CHEM_AS_M	SCH_SCIENR_CHEM_AS_F
COUR16.10, COUR16.11, COUR16.12	Native Hawaiian or Other Pacific Islander	SCH_SCIENR_CHEM_HP_M	SCH_SCIENR_CHEM_HP_F
COUR16.13, COUR16.14, COUR16.15	Black or African American	SCH_SCIENR_CHEM_BL_M	SCH_SCIENR_CHEM_BL_F
COUR16.16, COUR16.17, COUR16.18	White	SCH_SCIENR_CHEM_WH_M	SCH_SCIENR_CHEM_WH_F
COUR16.19, COUR16.20, COUR16.21	Two or More races	SCH_SCIENR_CHEM_TR_M	SCH_SCIENR_CHEM_TR_F
Total
COUR16.22, COUR16.23, COUR16.24	English Learners (EL)	SCH_SCIENR_CHEM_EL_M	SCH_SCIENR_CHEM_EL_F
COUR16.25, COUR16.26, COUR16.27	Students with Disabilities (IDEA)	SCH_SCIENR_CHEM_IDEA_M	SCH_SCIENR_CHEM_IDEA_F

Logic
Report the total number of distinct students enrolled in Chemistry in Grades 9, 10, 11 or 12 for each data element The student must be scheduled into an eligible Chemistry course using the Student Roster Count logic Use the Fall Snapshot Enrollment logic to determine if a student is eligible to report The students CRDC Grade Level must be = Grades 9, 10, 11 or 12 Only count courses that are selected and saved in the Chemistry category mapping Only count students in the EL and IDEA data elements if they are selected and saved in the Fall Snapshot IDEA Students and/or Fall Snapshot EL Students category mappings
Report 0 if there are no students that meet the reporting criteria for the data element
Report NULL if the answer for question COUR-14, Chemistry is '0'
In the question detail screen, an override column will be next to the results with a text box to select a value
Detail Report Logic will display the following information: Year, NCES School Number, School Name, Course Number, Course Name, SectionID, Section Number, Students PersonID, State ID, Name, Grade Name, EL, IDEA

COUR-17: Student Enrollment in Science Courses - Physics

Category Mapping: Grade Levels, Physics, Fall Snapshot IDEA Students, Fall Snapshot EL Students

Flat File Details:

Layout	Data Element	Male	Female
Permitted Values: Integer, NULL Length of Permitted Values: 7
COUR17.1, COUR17.2, COUR17.3	Hispanic or Latino of any race	SCH_SCIENR_PHYS_HI_M	SCH_SCIENR_PHYS_HI_F
COUR17.4, COUR17.5, COUR17.6	American Indian or Alaska Native	SCH_SCIENR_PHYS_AM_M	SCH_SCIENR_PHYS_AM_F
COUR17.7, COUR17.8, COUR17.9	Asian	SCH_SCIENR_PHYS_AS_M	SCH_SCIENR_PHYS_AS_F
COUR17.10, COUR17.11, COUR17.12	Native Hawaiian or Other Pacific Islander	SCH_SCIENR_PHYS_HP_M	SCH_SCIENR_PHYS_HP_F
COUR17.13, COUR17.14, COUR17.15	Black or African American	SCH_SCIENR_PHYS_BL_M	SCH_SCIENR_PHYS_BL_F
COUR17.16, COUR17.17, COUR17.18	White	SCH_SCIENR_PHYS_WH_M	SCH_SCIENR_PHYS_WH_F
COUR17.19, COUR17.20, COUR17.21	Two or More races	SCH_SCIENR_PHYS_TR_M	SCH_SCIENR_PHYS_TR_F
Total
COUR17.22, COUR17.23, COUR17.24	English Learners (EL)	SCH_SCIENR_PHYS_EL_M	SCH_SCIENR_PHYS_EL_F
COUR17.25, COUR17.26, COUR17.27	Students with Disabilities (IDEA)	SCH_SCIENR_PHYS_IDEA_M	SCH_SCIENR_PHYS_IDEA_F

Logic
Report the total number of distinct students enrolled in Physics in Grades 9, 10, 11 or 12 for each data element The student must be scheduled into an eligible Physics course using the Student Roster Count logic Use the Fall Snapshot Enrollment logic to determine if a student is eligible to report The students CRDC Grade Level must be = Grades 9, 10, 11 or 12 Only count courses that are selected and saved in the Physics category mapping Only count students in the EL and IDEA data elements if they are selected and saved in the Fall Snapshot IDEA Students and/or Fall Snapshot EL Students category mappings
Report 0 if there are no students that meet the reporting criteria for the data element
Report NULL if the answer for question COUR-14, Physics is '0'
In the question detail screen, an override column will be next to the results with a text box to select a value
Detail Report Logic will display the following information: Year, NCES School Number, School Name, Course Number, Course Name, SectionID, Section Number, Students PersonID, State ID, Name, Grade Name, EL, IDEA

COUR-18: Classes in Computer Science Courses

Category Mapping: Computer Science

Flat File Details:

Permitted Values: Integer, NULL

Length of Permitted Values: 7

Layout

Element Name

Data Element

COUR18.1

SCH_COMPCLASSES_CSCI

Classes in Computer Science Courses

Logic
Count and display the total number of Computer Science courses for the data element listed Use the Course Count logic to determine the values reported Only report courses that are selected and saved in the Computer Science category mappings for the reporting school Report "0" if there is not a course that is eligible in a data element
In the question detail screen, an override column will be next to the results with a text box to enter in values
Detail Report Logic will display the following information: Year, NCES School Number, School Name, Course Number, Course Name, SectionID, Section Number

COUR19: Student Enrollment in Computer Science Courses

Category Mapping: Grade Levels, Computer Science, Fall Snapshot IDEA Students, Fall Snapshot EL Students

Flat File Details:

Layout	Data Element	Male	Female
Permitted Values: Integer, NULL Length of Permitted Values: 7
COUR19.1, COUR19.2, COUR19.3	Hispanic or Latino of any race	SCH_COMPENR_CSCI_HI_M	SCH_COMPENR_CSCI_HI_F
COUR19.4, COUR19.5, COUR19.6	American Indian or Alaska Native	SCH_COMPENR_CSCI_AM_M	SCH_COMPENR_CSCI_AM_F
COUR19.7, COUR19.8, COUR19.9	Asian	SCH_COMPENR_CSCI_AS_M	SCH_COMPENR_CSCI_AS_F
COUR19.10, COUR19.11, COUR19.12	Native Hawaiian or Other Pacific Islander	SCH_COMPENR_CSCI_HP_M	SCH_COMPENR_CSCI_HP_F
COUR19.13, COUR19.14, COUR19.15	Black or African American	SCH_COMPENR_CSCI_BL_M	SCH_COMPENR_CSCI_BL_F
COUR19.16, COUR19.17, COUR19.18	White	SCH_COMPENR_CSCI_WH_M	SCH_COMPENR_CSCI_WH_F
COUR19.19, COUR19.20, COUR19.21	Two or More races	SCH_COMPENR_CSCI_TR_M	SCH_COMPENR_CSCI_TR_F
Total
COUR19.22, COUR19.23, COUR19.24	English Learners (EL)	SCH_COMPENR_CSCI_EL_M	SCH_COMPENR_CSCI_EL_F
COUR19.25, COUR19.26, COUR19.27	Students with Disabilities (IDEA)	SCH_COMPENR_CSCI_IDEA_M	SCH_COMPENR_CSCI_IDEA_F

Logic
Report the total number of distinct students enrolled in Computer Science in Grades 9, 10, 11 or 12 for each data element The student must be scheduled into an eligible Computer Science course using the Student Roster Count logic Use the Fall Snapshot Enrollment logic to determine if a student is eligible to report The students CRDC Grade Level must be = Grades 9, 10, 11 or 12 Only count courses that are selected and saved in the Computer Science category mapping Only count students in the EL and IDEA data elements if they are selected and saved in the Fall Snapshot IDEA Students and/or Fall Snapshot EL Students category mappings
Report 0 if there are no students that meet the reporting criteria for the data element
Report NULL if the answer for question COUR-18, is '0'
In the question detail screen, an override column will be next to the results with a text box to select a value
Detail Report Logic will display the following information: Year, NCES School Number, School Name, Course Number, Course Name, SectionID, Section Number, Students PersonID, State ID, Name, Grade Name, EL, IDEA

COUR-20: Classes in Data Science Courses

Category Mapping: Data Science

Flat File Details:

Permitted Values: Integer, NULL

Length of Permitted Values: 7

Layout

Element Name

Data Element

COUR20.1

SCH_DATACLASSES_DSCI

Classes in Data Science Courses

Logic
Count and display the total number of Data Science courses for the data element listed Use the Course Count logic to determine the values reported Only report courses that are selected and saved in the Data Science category mappings for the reporting school Report "0" if there is not a course that is eligible in a data element
In the question detail screen, an override column will be next to the results with a text box to enter in values
Detail Report Logic will display the following information: Year, NCES School Number, School Name, Course Number, Course Name, SectionID, Section Number

COUR-21: Student Enrollment in Data Science Courses

Category Mapping: Grade Levels, Data Science, Fall Snapshot IDEA Students, Fall Snapshot EL Students

Flat File Details:

Layout	Data Element	Male	Female
Permitted Values: Integer, NULL Length of Permitted Values: 7
COUR21.1, COUR21.2, COUR21.3	Hispanic or Latino of any race	SCH_DATAENR_DSCI_HI_M	SCH_DATAENR_DSCI_HI_F
COUR21.4, COUR21.5, COUR21.6	American Indian or Alaska Native	SCH_DATAENR_DSCI_AM_M	SCH_DATAENR_DSCI_AM_F
COUR21.7, COUR21.8, COUR21.9	Asian	SCH_DATAENR_DSCI_AS_M	SCH_DATAENR_DSCI_AS_F
COUR21.10, COUR21.11, COUR21.12	Native Hawaiian or Other Pacific Islander	SCH_DATAENR_DSCI_HP_M	SCH_DATAENR_DSCI_HP_F
COUR21.13, COUR21.14, COUR21.15	Black or African American	SCH_DATAENR_DSCI_BL_M	SCH_DATAENR_DSCI_BL_F
COUR21.16, COUR21.17, COUR21.18	White	SCH_DATAENR_DSCI_WH_M	SCH_DATAENR_DSCI_WH_F
COUR21.19, COUR21.20, COUR21.21	Two or More races	SCH_DATAENR_DSCI_TR_M	SCH_DATAENR_DSCI_TR_F
Total
COUR21.22, COUR21.23, COUR21.24	English Learners (EL)	SCH_DATAENR_DSCI_EL_M	SCH_DATAENR_DSCI_EL_F
COUR21.25, COUR21.26, COUR21.27	Students with Disabilities (IDEA)	SCH_DATAENR_DSCI_IDEA_M	SCH_DATAENR_DSCI_IDEA_F

Logic
Report the total number of distinct students enrolled in Data Science in Grades 9, 10, 11 or 12 for each data element The student must be scheduled into an eligible Data Science course using the Student Roster Count logic Use the Fall Snapshot Enrollment logic to determine if a student is eligible to report The students CRDC Grade Level must be = Grades 9, 10, 11 or 12 Only count courses that are selected and saved in the Data Science category mapping Only count students in the EL and IDEA data elements if they are selected and saved in the Fall Snapshot IDEA Students and/or Fall Snapshot EL Students category mappings
Report 0 if there are no students that meet the reporting criteria for the data element
Report NULL if the answer for question COUR-20, is '0'
In the question detail screen, an override column will be next to the results with a text box to select a value
Detail Report Logic will display the following information: Year, NCES School Number, School Name, Course Number, Course Name, SectionID, Section Number, Students PersonID, State ID, Name, Grade Name, EL, IDEA

COUR-22: Singe-Sex Academic Classes Indicator

Category Mapping: N/A

The results for this question are not calculated by the CRDC tool. Enter an override value to report this question in the flat file.

Flat File Details:

Permitted Values: Yes, No, NULL

Length of Permitted Values: 3

Layout

Element Name

Data Element

COUR22.1

SCH_SSCLASSES_IND

Whether the school had any students enrolled in one or more single-sex academic classes

Logic
The results column will not show but the user can enter an override Add the Permitted values shown above in the override droplist.

COUR-23: Single-Sex Academic Classes Detail

Instructions: (Only for co-educational schools, grades K-12, UG with single-sex classes)

This table is about CLASSES. For the Fall 2023 snapshot date, enter the number of single-sex academic classes in each course or subject area that had one or more students in grades K-12 (or the ungraded equivalent) enrolled.

Report classes that cover the content of the courses outlined in the definitions, regardless of the course name.
Count classes, not courses.
Enter the total count of classes, not the enrollment of students in those classes.
Include only classes that exclude students of one sex from enrolling or otherwise participating in that class because of their sex.
Include classes in Advanced Placement courses and International Baccalaureate Diploma Programme courses.
If the school has students who receive all of their academic instruction from one teacher in one single-sex classroom, then each academic subject area taught in the classroom is considered one single-sex class. For example, a co-educational elementary school that has male students who receive mathematics, science, reading/language arts and social studies instruction from one teacher in one single-sex classroom should consider each subject area a single-sex class.
A physical education class is not considered an academic class.
For schools that use regular scheduling, the count should be based on October 1 (or the closest school day to October 1).
For schools that use block scheduling that allows a full-year course to be taken in one semester, the count should be based on the sum of a count taken on October 1 (or the closest school day to October 1) in the first block, and around March 1 in the second block.

Additional instructions left out of Question UI due to 2000 character max

Mathematics includes general mathematics courses as well as college-preparatory mathematics courses such as Algebra I, Geometry, and Algebra II.
English/reading/language arts includes general English/reading/language arts courses as well as college-preparatory English/reading/language arts courses.
Science includes general science courses as well as college-preparatory science courses such as Biology, Chemistry, and Physics.
“Other academic subjects” includes history, social studies, foreign languages, and computer science.

Category Mapping: N/A

The results for this question are not calculated by the CRDC tool. Enter an override value to report this question in the flat file.

Flat File Details:

Layout	Element Name	Data Element 1	Data Element 2
Permitted Values: Integer, NULL Length of Permitted Values: 7
COUR23.1	SCH_SSCLASSES_MATH_M	Male	Mathematics
COUR23.2	SCH_SSCLASSES_MATH_F	Female	Mathematics
COUR23.3	SCH_SSCLASSES_SCI_M	Male	Science
COUR23.4	SCH_SSCLASSES_SCI_F	Female	Science
COUR23.5	SCH_SSCLASSES_ENGL_M	Male	English/Reading/Language Arts
COUR23.6	SCH_SSCLASSES_ENGL_F	Female	English/Reading/Language Arts
COUR23.7	SCH_SSCLASSES_OTHA_M	Male	Other Academic Subjects
COUR23.8	SCH_SSCLASSES_OTHA_F	Female	Other Academic Subjects
		Total

Logic
The results column will not show but the user can enter an override The Permitted values shown above will be allowed in the text box

9. EXAM: SAT/ACT

EXAM-1: Student Participation in the SAT Reasoning Test or ACT

Category Mapping: Grade Levels, Regular School Year IDEA Students, Regular School Year EL Students

Flat File Details:

Layout	Data Element	Male	Female
Permitted Values: Integer, NULL Length of Permitted Values: 7
EXAM1.1, EXAM1.2, EXAM1.3	Hispanic or Latino of any race	SCH_SATACT_HI_M	SCH_SATACT_HI_F
EXAM1.4, EXAM1.5, EXAM1.6	American Indian or Alaska Native	SCH_SATACT_AM_M	SCH_SATACT_AM_F
EXAM1.7, EXAM1.8, EXAM1.9	Asian	SCH_SATACT_AS_M	SCH_SATACT_AS_F
EXAM1.10, EXAM1.11, EXAM1.12	Native Hawaiian or Other Pacific Islander	SCH_SATACT_HP_M	SCH_SATACT_HP_F
EXAM1.13, EXAM1.14, EXAM1.15	Black or African American	SCH_SATACT_BL_M	SCH_SATACT_BL_F
EXAM1.16, EXAM1.17, EXAM1.18	White	SCH_SATACT_WH_M	SCH_SATACT_WH_F
EXAM1.19, EXAM1.20, EXAM1.21	Two or More races	SCH_SATACT_TR_M	SCH_SATACT_TR_F
Total
EXAM1.22, EXAM1.23, EXAM1.24	English Learners (EL)	SCH_SATACT_EL_M	SCH_SATACT_EL_F
EXAM1.25, EXAM1.26, EXAM1.27	Students with Disabilities (IDEA)	SCH_SATACT_IDEA_M	SCH_SATACT_IDEA_F

Logic
Report the distinct total number of students who took the SAT Reasoning Test (SAT), ACT Test (ACT) or both. Count students who have an Assessment record with a Date in the reporting school year Assessment must have a National Code = ACT or SAT Assessment date must overlap with the reporting year. Use 7/1/xx to 06/30/xx for school year dates. Only count the student once if they have multiple assessment records that meet the reporting criteria Use the Regular School Year Enrollment, Gender & Race/Ethnicity logic to determine if a student is eligible to report The students CRDC Grade Level must be = Grade 9, 10, 11, or 12 Only count students in the EL and IDEA data elements if they are selected and saved in the Regular School Year IDEA Students and/or Regular School Year EL Students category mappings
Report 0 if there are no students that meet the reporting criteria
In the question detail screen, an override column will be next to the results with a text box to select a value
Detail Report Logic will display the following information: Year, NCES School Number, School Name, Students PersonID, State ID, Name, Grade Name, ACT, SAT, IDEA, EL

12. RETN: Retention

RETN-1: Student Retention Indicator

Category Mapping: Grade Levels

Flat File Details:

Layout	Element Name	Data Element
Permitted Values: Yes, No, NULL Length of Permitted Value: 3
RETN1.1	SCH_RET_KG_IND	Kindergarten
RETN1.2	SCH_RET_G01_IND	Grade 1
RETN1.3	SCH_RET_G02_IND	Grade 2
RETN1.4	SCH_RET_G03_IND	Grade 3
RETN1.5	SCH_RET_G04_IND	Grade 4
RETN1.6	SCH_RET_G05_IND	Grade 5
RETN1.7	SCH_RET_G06_IND	Grade 6
RETN1.8	SCH_RET_G07_IND	Grade 7
RETN1.9	SCH_RET_G08_IND	Grade 8
RETN1.10	SCH_RET_G09_IND	Grade 9
RETN1.11	SCH_RET_G10_IND	Grade 10
RETN1.12	SCH_RET_G11_IND	Grade 11
RETN1.13	SCH_RET_G12_IND	Grade 12

Logic
All CRDC Grade Levels will display with results for each applicable grade: Show "Yes" next to each grade level offered at this school where at least one student is enrolled in that grade and was retained. Show "No" next to all grade levels at this school where at least one student is enrolled and no student was retained Report NULL for each grade level the school does not offer Use Regular School Year Enrollment logic to determine if a student is eligible to report
A student will be considered retained when they meet the following criteria: The End Action on the eligible enrollment for a student in the reporting year is = R: Retain If the student has more than 1 eligible enrollment, report Yes if any of the End Action fields are set to R: Retain
An override column will be next to the results with a droplist next to each grade level that can be set to Yes, No, NS or NULL
Detail Report Logic will display the following information: Year, NCES School Number, School Name, Students PersonID, State ID, Name, Grade Name and CRDC Grade Level, EL, IDEA, 504

RETN-2 GRK: Retention of Students in Kindergarten

Category Mapping: Grade Levels, Regular School Year EL, Regular School Year IDEA, Regular School Year 504

Flat File Details:

Layout	Data Element	Male	Female
Permitted Values: Integer, NULL Length of Permitted Values: 7
RETN2.1, RETN2.2, RETN2.3	Hispanic or Latino of any race	SCH_RET_KG_HI_M	SCH_RET_KG_HI_F_M
RETN2.4, RETN2.5, RETN2.6	American Indian or Alaska Native	SCH_RET_KG_AM_M	SCH_RET_KG_AM_M
RETN2.7, RETN2.8, RETN2.9	Asian	SCH_RET_KG_AS_M	SCH_RET_KG_AS_M
RETN2.10, RETN2.11, RETN2.12	Native Hawaiian or Other Pacific Islander	SCH_RET_KG_HP_M	SCH_RET_KG_HP_M
RETN2.13, RETN2.14, RETN2.15	Black or African American	SCH_RET_KG_BL_M	SCH_RET_KG_BL_M
RETN2.16, RETN2.17, RETN2.18	White	SCH_RET_KG_WH_M	SCH_RET_KG_WH_M
RETN2.19, RETN2.20, RETN2.21	Two or More races	SCH_RET_KG_TR_M	SCH_RET_KG_TR_M
Total
RETN2.22, RETN2.23, RETN2.24	English Learners (EL)	SCH_RET_KG_EL_M	SCH_RET_KG_EL_M
RETN2.25, RETN2.26, RETN2.27	Students with Disabilities (IDEA)	SCH_RET_KG_IDEA_M	SCH_RET_KG_IDEA_M
RETN2.28, RETN2.29, RETN2.30	Students with Disabilities (Section 504 Only)	SCH_RET_KG_504_M	SCH_RET_KG_504_M

Logic
Count the distinct number of students that were retained in each grade level offered by the school Report the total number of students for each grade level that were retained Report "0" if the school offers the grade level but no students were retained Report NULL for each grade level the school does not offer Use Regular School Year Enrollment logic to determine if a student is eligible to report Use the Regular School Year EL, 504 and IDEA mapping for the applicable categories.
A student will be considered retained when they meet the following criteria: The End Action on the eligible enrollment for a student in the reporting year is = R: Retain If the student has more than 1 eligible enrollment, report Yes if any of the End Action fields are set to R: Retain
An override column will be next to the results with a text box that users can enter a value.
Detail Report Logic will display the following information: Year, NCES School Number, School Name, Students PersonID, State ID, Name, Grade Name and CRDC Grade Level, EL, IDEA, 504

RETN-2 GR1: Retention of Students in Grade 1

Category Mapping: Grade Levels, Regular School Year EL, Regular School Year IDEA, Regular School Year 504

Flat File Details:

Layout	Data Element	Male	Female
Permitted Values: Integer, NULL Length of Permitted Values: 7
RETN2.31, RETN2.32, RETN2.33	Hispanic or Latino of any race	SCH_RET_G01_HI_M	SCH_RET_G01_HI_F
RETN2.34, RETN2.35, RETN2.36	American Indian or Alaska Native	SCH_RET_G01_AM_M	SCH_RET_G01_AM_F
RETN2.37, RETN2.38, RETN2.39	Asian	SCH_RET_G01_AS_M	SCH_RET_G01_AS_F
RETN2.40, RETN2.41, RETN2.42	Native Hawaiian or Other Pacific Islander	SCH_RET_G01_HP_M	SCH_RET_G01_HP_F
RETN2.43, RETN2.44, RETN2.45	Black or African American	SCH_RET_G01_BL_M	SCH_RET_G01_BL_F
RETN2.46, RETN2.47, RETN2.48	White	SCH_RET_G01_WH_M	SCH_RET_G01_WH_F
RETN2.49, RETN2.50, RETN2.51	Two or More races	SCH_RET_G01_TR_M	SCH_RET_G01_TR_F
Total
RETN2.52, RETN2.53, RETN2.54	English Learners (EL)	SCH_RET_G01_EL_M	SCH_RET_G01_EL_F
RETN2.55, RETN2.56, RETN2.57	Students with Disabilities (IDEA)	SCH_RET_G01_IDEA_M	SCH_RET_G01_IDEA_F
RETN2.58, RETN2.59, RETN2.60	Students with Disabilities (Section 504 Only)	SCH_RET_G01_504_M	SCH_RET_G01_504_F

Logic
Count the distinct number of students that were retained in each grade level offered by the school Report the total number of students for each grade level that were retained Report "0" if the school offers the grade level but no students were retained Report NULL for each grade level the school does not offer Use Regular School Year Enrollment logic to determine if a student is eligible to report Use the Regular School Year EL, 504 and IDEA mapping for the applicable categories.
A student will be considered retained when they meet the following criteria: The End Action on the eligible enrollment for a student in the reporting year is = R: Retain If the student has more than 1 eligible enrollment, report Yes if any of the End Action fields are set to R: Retain
An override column will be next to the results with a text box that users can enter a value.
Detail Report Logic will display the following information: Year, NCES School Number, School Name, Students PersonID, State ID, Name, Grade Name and CRDC Grade Level, EL, IDEA, 504

RETN-2 GR2: Retention of Students in Grade 2

Category Mapping: Grade Levels, Regular School Year EL, Regular School Year IDEA, Regular School Year 504

Flat File Details:

Layout	Data Element	Male	Female
Permitted Values: Integer, NULL Length of Permitted Values: 7
RETN2.61, RETN2.62, RETN2.63	Hispanic or Latino of any race	SCH_RET_G02_HI_M	SCH_RET_G02_HI_F
RETN2.64, RETN2.65, RETN2.66	American Indian or Alaska Native	SCH_RET_G02_AM_M	SCH_RET_G02_AM_F
RETN2.67, RETN2.68, RETN2.69	Asian	SCH_RET_G02_AS_M	SCH_RET_G02_AS_F
RETN2.70, RETN2.71, RETN2.72	Native Hawaiian or Other Pacific Islander	SCH_RET_G02_HP_M	SCH_RET_G02_HP_F
RETN2.73, RETN2.74, RETN2.75	Black or African American	SCH_RET_G02_BL_M	SCH_RET_G02_BL_F
RETN2.76, RETN2.77, RETN2.78	White	SCH_RET_G02_WH_M	SCH_RET_G02_WH_F
RETN2.79, RETN2.80, RETN2.81	Two or More races	SCH_RET_G02_TR_M	SCH_RET_G02_TR_F
Total
RETN2.82, RETN2.83, RETN2.84	English Learners (EL)	SCH_RET_G02_EL_M	SCH_RET_G02_EL_F
RETN2.85, RETN2.86, RETN2.87	Students with Disabilities (IDEA)	SCH_RET_G02_IDEA_M	SCH_RET_G02_IDEA_F
RETN2.88, RETN2.89, RETN2.90	Students with Disabilities (Section 504 Only)	SCH_RET_G02_504_M	SCH_RET_G02_504_F

Logic
Count the distinct number of students that were retained in each grade level offered by the school Report the total number of students for each grade level that were retained Report "0" if the school offers the grade level but no students were retained Report NULL for each grade level the school does not offer Use Regular School Year Enrollment logic to determine if a student is eligible to report Use the Regular School Year EL, 504 and IDEA mapping for the applicable categories.
A student will be considered retained when they meet the following criteria: The End Action on the eligible enrollment for a student in the reporting year is = R: Retain If the student has more than 1 eligible enrollment, report Yes if any of the End Action fields are set to R: Retain
An override column will be next to the results with a text box that users can enter a value.
Detail Report Logic will display the following information: Year, NCES School Number, School Name, Students PersonID, State ID, Name, Grade Name and CRDC Grade Level, EL, IDEA, 504

RETN-2 GR3: Retention of Students in Grade 3

Category Mapping: Grade Levels, Regular School Year EL, Regular School Year IDEA, Regular School Year 504

Flat File Details:

Layout	Data Element	Male	Female
Permitted Values: Integer, NULL Length of Permitted Values: 7
RETN2.91, RETN2.92, RETN2.93	Hispanic or Latino of any race	SCH_RET_G03_HI_M	SCH_RET_G03_HI_F
RETN2.94, RETN2.95, RETN2.96	American Indian or Alaska Native	SCH_RET_G03_AM_M	SCH_RET_G03_AM_F
RETN2.97, RETN2.98, RETN2.99	Asian	SCH_RET_G03_AS_M	SCH_RET_G03_AS_F
RETN2.100, RETN2.101, RETN2.102	Native Hawaiian or Other Pacific Islander	SCH_RET_G03_HP_M	SCH_RET_G03_HP_F
RETN2.103 RETN2.104, RETN2.105	Black or African American	SCH_RET_G03_BL_M	SCH_RET_G03_BL_F
RETN2.106, RETN2.107, RETN2.108	White	SCH_RET_G03_WH_M	SCH_RET_G03_WH_F
RETN2.109, RETN2.110, RETN2.111	Two or More races	SCH_RET_G03_TR_M	SCH_RET_G03_TR_F
Total
RETN2.112, RETN2.113, RETN2.114	English Learners (EL)	SCH_RET_G03_EL_M	SCH_RET_G03_EL_F
RETN2.115, RETN2.116, RETN2.117	Students with Disabilities (IDEA)	SCH_RET_G03_IDEA_M	SCH_RET_G03_IDEA_F
RETN2.118, RETN2.119, RETN2.120	Students with Disabilities (Section 504 Only)	SCH_RET_G03_504_M	SCH_RET_G03_504_F

Logic
Count the distinct number of students that were retained in each grade level offered by the school Report the total number of students for each grade level that were retained Report "0" if the school offers the grade level but no students were retained Report NULL for each grade level the school does not offer Use Regular School Year Enrollment logic to determine if a student is eligible to report Use the Regular School Year EL, 504 and IDEA mapping for the applicable categories.
A student will be considered retained when they meet the following criteria: The End Action on the eligible enrollment for a student in the reporting year is = R: Retain If the student has more than 1 eligible enrollment, report Yes if any of the End Action fields are set to R: Retain
An override column will be next to the results with a text box that users can enter a value.
Detail Report Logic will display the following information: Year, NCES School Number, School Name, Students PersonID, State ID, Name, Grade Name and CRDC Grade Level, EL, IDEA, 504

RETN-2 GR4: Retention of Students in Grade 4

Category Mapping: Grade Levels, Regular School Year EL, Regular School Year IDEA, Regular School Year 504

Flat File Details:

Layout	Data Element	Male	Female
Permitted Values: Integer, NULL Length of Permitted Values: 7
RETN2.121, RETN2.122, RETN2.123	Hispanic or Latino of any race	SCH_RET_G04_HI_M	SCH_RET_G04_HI_F
RETN2.124, RETN2.125, RETN2.126	American Indian or Alaska Native	SCH_RET_G04_AM_M	SCH_RET_G04_AM_F
RETN2.127, RETN2.128, RETN2.129	Asian	SCH_RET_G04_AS_M	SCH_RET_G04_AS_F
RETN2.130, RETN2.131, RETN2.132	Native Hawaiian or Other Pacific Islander	SCH_RET_G04_HP_M	SCH_RET_G04_HP_F
RETN2.133, RETN2.134, RETN2.135	Black or African American	SCH_RET_G04_BL_M	SCH_RET_G04_BL_F
RETN2.136, RETN2.137, RETN2.138	White	SCH_RET_G04_WH_M	SCH_RET_G04_WH_F
RETN2.139, RETN2.140, RETN2.141	Two or More races	SCH_RET_G04_TR_M	SCH_RET_G04_TR_F
Total
RETN2.142, RETN2.143, RETN2.144	English Learners (EL)	SCH_RET_G04_EL_M	SCH_RET_G04_EL_F
RETN2.145, RETN2.146, RETN2.147	Students with Disabilities (IDEA)	SCH_RET_G04_IDEA_M	SCH_RET_G04_IDEA_F
RETN2.148, RETN2.149, RETN2.150	Students with Disabilities (Section 504 Only)	SCH_RET_G04_504_M	SCH_RET_G04_504_F

Logic
Count the distinct number of students that were retained in each grade level offered by the school Report the total number of students for each grade level that were retained Report "0" if the school offers the grade level but no students were retained Report NULL for each grade level the school does not offer Use Regular School Year Enrollment logic to determine if a student is eligible to report Use the Regular School Year EL, 504 and IDEA mapping for the applicable categories.
A student will be considered retained when they meet the following criteria: The End Action on the eligible enrollment for a student in the reporting year is = R: Retain If the student has more than 1 eligible enrollment, report Yes if any of the End Action fields are set to R: Retain
An override column will be next to the results with a text box that users can enter a value.
Detail Report Logic will display the following information: Year, NCES School Number, School Name, Students PersonID, State ID, Name, Grade Name and CRDC Grade Level, EL, IDEA, 504

RETN-2 GR5: Retention of Students in Grade 5

Category Mapping: Grade Levels, Regular School Year EL, Regular School Year IDEA, Regular School Year 504

Flat File Details:

Layout	Data Element	Male	Female
Permitted Values: Integer, NULL Length of Permitted Values: 7
RETN2.151, RETN2.152, RETN2.153	Hispanic or Latino of any race	SCH_RET_G05_HI_M	SCH_RET_G05_HI_F
RETN2.154, RETN2.155, RETN2.156	American Indian or Alaska Native	SCH_RET_G05_AM_M	SCH_RET_G05_AM_F
RETN2.157, RETN2.158, RETN2.159	Asian	SCH_RET_G05_AS_M	SCH_RET_G05_AS_F
RETN2.160, RETN2.161, RETN2.162	Native Hawaiian or Other Pacific Islander	SCH_RET_G05_HP_M	SCH_RET_G05_HP_F
RETN2.163, RETN2.164, RETN2.165	Black or African American	SCH_RET_G05_BL_M	SCH_RET_G05_BL_F
RETN2.166, RETN2.167, RETN2.168	White	SCH_RET_G05_WH_M	SCH_RET_G05_WH_F
RETN2.169, RETN2.170, RETN2.171	Two or More races	SCH_RET_G05_TR_M	SCH_RET_G05_TR_F
Total
RETN2.172, RETN2.173, RETN2.174	English Learners (EL)	SCH_RET_G05_EL_M	SCH_RET_G05_EL_F
RETN2.175, RETN2.176, RETN2.177	Students with Disabilities (IDEA)	SCH_RET_G05_IDEA_M	SCH_RET_G05_IDEA_F
RETN2.178, RETN2.179, RETN2.180	Students with Disabilities (Section 504 Only)	SCH_RET_G05_504_M	SCH_RET_G05_504_F

Logic
Count the distinct number of students that were retained in each grade level offered by the school Report the total number of students for each grade level that were retained Report "0" if the school offers the grade level but no students were retained Report NULL for each grade level the school does not offer Use Regular School Year Enrollment logic to determine if a student is eligible to report Use the Regular School Year EL, 504 and IDEA mapping for the applicable categories.
A student will be considered retained when they meet the following criteria: The End Action on the eligible enrollment for a student in the reporting year is = R: Retain If the student has more than 1 eligible enrollment, report Yes if any of the End Action fields are set to R: Retain
An override column will be next to the results with a text box that users can enter a value.
Detail Report Logic will display the following information: Year, NCES School Number, School Name, Students PersonID, State ID, Name, Grade Name and CRDC Grade Level, EL, IDEA, 504

RETN-2 GR6: Retention of Students in Grade 6

Category Mapping: Grade Levels, Regular School Year EL, Regular School Year IDEA, Regular School Year 504

Flat File Details:

Layout	Data Element	Male	Female
Permitted Values: Integer, NULL Length of Permitted Values: 7
RETN2.181, RETN2.182, RETN2.183	Hispanic or Latino of any race	SCH_RET_G06_HI_M	SCH_RET_G06_HI_F
RETN2.184, RETN2.185, RETN2.186	American Indian or Alaska Native	SCH_RET_G06_AM_M	SCH_RET_G06_AM_F
RETN2.187, RETN2.188, RETN2.189	Asian	SCH_RET_G06_AS_M	SCH_RET_G06_AS_F
RETN2.190, RETN2.191, RETN2.192	Native Hawaiian or Other Pacific Islander	SCH_RET_G06_HP_M	SCH_RET_G06_HP_F
RETN2.193, RETN2.194, RETN2.195	Black or African American	SCH_RET_G06_BL_M	SCH_RET_G06_BL_F
RETN2.196, RETN2.197, RETN2.198	White	SCH_RET_G06_WH_M	SCH_RET_G06_WH_F
RETN2.199, RETN2.200, RETN2.201	Two or More races	SCH_RET_G06_TR_M	SCH_RET_G06_TR_F
Total
RETN2.202, RETN2.203, RETN2.204	English Learners (EL)	SCH_RET_G06_EL_M	SCH_RET_G06_EL_F
RETN2.205, RETN2.206, RETN2.207	Students with Disabilities (IDEA)	SCH_RET_G06_IDEA_M	SCH_RET_G06_IDEA_F
RETN2.208, RETN2.209, RETN2.210	Students with Disabilities (Section 504 Only)	SCH_RET_G06_504_M	SCH_RET_G06_504_F

Logic
Count the distinct number of students that were retained in each grade level offered by the school Report the total number of students for each grade level that were retained Report "0" if the school offers the grade level but no students were retained Report NULL for each grade level the school does not offer Use Regular School Year Enrollment logic to determine if a student is eligible to report Use the Regular School Year EL, 504 and IDEA mapping for the applicable categories.
A student will be considered retained when they meet the following criteria: The End Action on the eligible enrollment for a student in the reporting year is = R: Retain If the student has more than 1 eligible enrollment, report Yes if any of the End Action fields are set to R: Retain
An override column will be next to the results with a text box that users can enter a value.
Detail Report Logic will display the following information: Year, NCES School Number, School Name, Students PersonID, State ID, Name, Grade Name and CRDC Grade Level, EL, IDEA, 504

RETN-2 GR7: Retention of Students in Grade 7

Category Mapping: Grade Levels, Regular School Year EL, Regular School Year IDEA, Regular School Year 504

Flat File Details:

Layout	Data Element	Male	Female
Permitted Values: Integer, NULL Length of Permitted Values: 7
RETN2.211, RETN2.212, RETN2.213	Hispanic or Latino of any race	SCH_RET_G07_HI_M	SCH_RET_G07_HI_F
RETN2.214, RETN2.215, RETN2.216	American Indian or Alaska Native	SCH_RET_G07_AM_M	SCH_RET_G07_AM_F
RETN2.217, RETN2.218, RETN2.219	Asian	SCH_RET_G07_AS_M	SCH_RET_G07_AS_F
RETN2.220, RETN2.221, RETN2.222	Native Hawaiian or Other Pacific Islander	SCH_RET_G07_HP_M	SCH_RET_G07_HP_F
RETN2.223, RETN2.224, RETN2.225	Black or African American	SCH_RET_G07_BL_M	SCH_RET_G07_BL_F
RETN2.226, RETN2.227, RETN2.228	White	SCH_RET_G07_WH_M	SCH_RET_G07_WH_F
RETN2.229, RETN2.230, RETN2.231	Two or More races	SCH_RET_G07_TR_M	SCH_RET_G07_TR_F
Total
RETN2.232, RETN2.233, RETN2.234	English Learners (EL)	SCH_RET_G07_EL_M	SCH_RET_G07_EL_F
RETN2.235, RETN2.236, RETN2.237	Students with Disabilities (IDEA)	SCH_RET_G07_IDEA_M	SCH_RET_G07_IDEA_F
RETN2.238, RETN2.239, RETN2.240	Students with Disabilities (Section 504 Only)	SCH_RET_G07_504_M	SCH_RET_G07_504_F

Logic
Count the distinct number of students that were retained in each grade level offered by the school Report the total number of students for each grade level that were retained Report "0" if the school offers the grade level but no students were retained Report NULL for each grade level the school does not offer Use Regular School Year Enrollment logic to determine if a student is eligible to report Use the Regular School Year EL, 504 and IDEA mapping for the applicable categories.
A student will be considered retained when they meet the following criteria: The End Action on the eligible enrollment for a student in the reporting year is = R: Retain If the student has more than 1 eligible enrollment, report Yes if any of the End Action fields are set to R: Retain
An override column will be next to the results with a text box that users can enter a value.
Detail Report Logic will display the following information: Year, NCES School Number, School Name, Students PersonID, State ID, Name, Grade Name and CRDC Grade Level, EL, IDEA, 504

RETN-2 GR8: Retention of Students in Grade 8

Category Mapping: Grade Levels, Regular School Year EL, Regular School Year IDEA, Regular School Year 504

Flat File Details:

Layout	Data Element	Male	Female
Permitted Values: Integer, NULL Length of Permitted Values: 7
RETN2.241, RETN2.242, RETN2.243	Hispanic or Latino of any race	SCH_RET_G08_HI_M	SCH_RET_G08_HI_F
RETN2.244, RETN2.245, RETN2.246	American Indian or Alaska Native	SCH_RET_G08_AM_M	SCH_RET_G08_AM_F
RETN2.247, RETN2.248, RETN2.249	Asian	SCH_RET_G08_AS_M	SCH_RET_G08_AS_F
RETN2.250, RETN2.251, RETN2.252	Native Hawaiian or Other Pacific Islander	SCH_RET_G08_HP_M	SCH_RET_G08_HP_F
RETN2.253, RETN2.254, RETN2.255	Black or African American	SCH_RET_G08_BL_M	SCH_RET_G08_BL_F
RETN2.256, RETN2.257, RETN2.258	White	SCH_RET_G08_WH_M	SCH_RET_G08_WH_F
RETN2.259, RETN2.260, RETN2.261	Two or More races	SCH_RET_G08_TR_M	SCH_RET_G08_TR_F
Total
RETN2.262, RETN2.263, RETN2.264	English Learners (EL)	SCH_RET_G08_EL_M	SCH_RET_G08_EL_F
RETN2.265, RETN2.266, RETN2.267	Students with Disabilities (IDEA)	SCH_RET_G08_IDEA_M	SCH_RET_G08_IDEA_F
RETN2.268, RETN2.269, RETN2.270	Students with Disabilities (Section 504 Only)	SCH_RET_G08_504_M	SCH_RET_G08_504_F

Logic
Count the distinct number of students that were retained in each grade level offered by the school Report the total number of students for each grade level that were retained Report "0" if the school offers the grade level but no students were retained Report NULL for each grade level the school does not offer Use Regular School Year Enrollment logic to determine if a student is eligible to report Use the Regular School Year EL, 504 and IDEA mapping for the applicable categories.
A student will be considered retained when they meet the following criteria: The End Action on the eligible enrollment for a student in the reporting year is = R: Retain If the student has more than 1 eligible enrollment, report Yes if any of the End Action fields are set to R: Retain
An override column will be next to the results with a text box that users can enter a value.
Detail Report Logic will display the following information: Year, NCES School Number, School Name, Students PersonID, State ID, Name, Grade Name and CRDC Grade Level, EL, IDEA, 504

RETN-2 GR9: Retention of Students in Grade 9

Category Mapping: Grade Levels, Regular School Year EL, Regular School Year IDEA, Regular School Year 504

Flat File Details:

Layout	Data Element	Male	Female
Permitted Values: Integer, NULL Length of Permitted Values: 7
RETN2.271, RETN2.272, RETN2.273	Hispanic or Latino of any race	SCH_RET_G09_HI_M	SCH_RET_G09_HI_F
RETN2.274, RETN2.275, RETN2.276	American Indian or Alaska Native	SCH_RET_G09_AM_M	SCH_RET_G09_AM_F
RETN2.277, RETN2.278, RETN2.279	Asian	SCH_RET_G09_AS_M	SCH_RET_G09_AS_F
RETN2.280, RETN2.281, RETN2.282	Native Hawaiian or Other Pacific Islander	SCH_RET_G09_HP_M	SCH_RET_G09_HP_F
RETN2.283, RETN2.284, RETN2.285	Black or African American	SCH_RET_G09_BL_M	SCH_RET_G09_BL_F
RETN2.286, RETN2.287, RETN2.288	White	SCH_RET_G09_WH_M	SCH_RET_G09_WH_F
RETN2.289, RETN2.290, RETN2.291	Two or More races	SCH_RET_G09_TR_M	SCH_RET_G09_TR_F
Total
RETN2.292, RETN2.293, RETN2.294	English Learners (EL)	SCH_RET_G09_EL_M	SCH_RET_G09_EL_F
RETN2.295, RETN2.296, RETN2.297	Students with Disabilities (IDEA)	SCH_RET_G09_IDEA_M	SCH_RET_G09_IDEA_F
RETN2.298, RETN2.299, RETN2.300	Students with Disabilities (Section 504 Only)	SCH_RET_G09_504_M	SCH_RET_G09_504_F

Logic
Count the distinct number of students that were retained in each grade level offered by the school Report the total number of students for each grade level that were retained Report "0" if the school offers the grade level but no students were retained Report NULL for each grade level the school does not offer Use Regular School Year Enrollment logic to determine if a student is eligible to report Use the Regular School Year EL, 504 and IDEA mapping for the applicable categories.
A student will be considered retained when they meet the following criteria: The End Action on the eligible enrollment for a student in the reporting year is = R: Retain If the student has more than 1 eligible enrollment, report Yes if any of the End Action fields are set to R: Retain
An override column will be next to the results with a text box that users can enter a value.
Detail Report Logic will display the following information: Year, NCES School Number, School Name, Students PersonID, State ID, Name, Grade Name and CRDC Grade Level, EL, IDEA, 504

RETN-2 GR10: Retention of Students in Grade 10

Category Mapping: Grade Levels, Regular School Year EL, Regular School Year IDEA, Regular School Year 504

Flat File Details:

Layout	Data Element	Male	Female
Permitted Values: Integer, NULL Length of Permitted Values: 7
RETN2.301, RETN2.302, RETN2.303	Hispanic or Latino of any race	SCH_RET_G10_HI_M	SCH_RET_G10_HI_F
RETN2.304, RETN2.305, RETN2.306	American Indian or Alaska Native	SCH_RET_G10_AM_M	SCH_RET_G10_AM_F
RETN2.307, RETN2.308, RETN2.309	Asian	SCH_RET_G10_AS_M	SCH_RET_G10_AS_F
RETN2.310, RETN2.311, RETN2.312	Native Hawaiian or Other Pacific Islander	SCH_RET_G10_HP_M	SCH_RET_G10_HP_F
RETN2.313, RETN2.314, RETN2.315	Black or African American	SCH_RET_G10_BL_M	SCH_RET_G10_BL_F
RETN2.315, RETN2.317, RETN2.318	White	SCH_RET_G10_WH_M	SCH_RET_G10_WH_F
RETN2.319, RETN2.320, RETN2.321	Two or More races	SCH_RET_G10_TR_M	SCH_RET_G10_TR_F
Total
RETN2.322, RETN2.323, RETN2.324	English Learners (EL)	SCH_RET_G10_EL_M	SCH_RET_G10_EL_F
RETN2.325, RETN2.326, RETN2.327	Students with Disabilities (IDEA)	SCH_RET_G10_IDEA_M	SCH_RET_G10_IDEA_F
RETN2.328, RETN2.329, RETN2.330	Students with Disabilities (Section 504 Only)	SCH_RET_G10_504_M	SCH_RET_G10_504_F

Logic
Count the distinct number of students that were retained in each grade level offered by the school Report the total number of students for each grade level that were retained Report "0" if the school offers the grade level but no students were retained Report NULL for each grade level the school does not offer Use Regular School Year Enrollment logic to determine if a student is eligible to report Use the Regular School Year EL, 504 and IDEA mapping for the applicable categories.
A student will be considered retained when they meet the following criteria: The End Action on the eligible enrollment for a student in the reporting year is = R: Retain If the student has more than 1 eligible enrollment, report Yes if any of the End Action fields are set to R: Retain
An override column will be next to the results with a text box that users can enter a value.
Detail Report Logic will display the following information: Year, NCES School Number, School Name, Students PersonID, State ID, Name, Grade Name and CRDC Grade Level, EL, IDEA, 504

RETN-2 GR11: Retention of Students in Grade 11

Category Mapping: Grade Levels, Regular School Year EL, Regular School Year IDEA, Regular School Year 504

Flat File Details:

Layout	Data Element	Male	Female
Permitted Values: Integer, NULL Length of Permitted Values: 7
RETN2.331, RETN2.332, RETN2.333	Hispanic or Latino of any race	SCH_RET_G11_HI_M	SCH_RET_G11_HI_F
RETN2.334, RETN2.335, RETN2.336	American Indian or Alaska Native	SCH_RET_G11_AM_M	SCH_RET_G11_AM_F
RETN2.337, RETN2.338, RETN2.339	Asian	SCH_RET_G11_AS_M	SCH_RET_G11_AS_F
RETN2.340, RETN2.341, RETN2.342	Native Hawaiian or Other Pacific Islander	SCH_RET_G11_HP_M	SCH_RET_G11_HP_F
RETN2.343, RETN2.344, RETN2.345	Black or African American	SCH_RET_G11_BL_M	SCH_RET_G11_BL_F
RETN2.346, RETN2.347, RETN2.348	White	SCH_RET_G11_WH_M	SCH_RET_G11_WH_F
RETN2.349, RETN2.350, RETN2.351	Two or More races	SCH_RET_G11_TR_M	SCH_RET_G11_TR_F
Total
RETN2.352, RETN2.353, RETN2.354	English Learners (EL)	SCH_RET_G11_EL_M	SCH_RET_G11_EL_F
RETN2.355, RETN2.356, RETN2.357	Students with Disabilities (IDEA)	SCH_RET_G11_IDEA_M	SCH_RET_G11_IDEA_F
RETN2.358, RETN2.359, RETN2.360	Students with Disabilities (Section 504 Only)	SCH_RET_G11_504_M	SCH_RET_G11_504_F

Logic
Count the distinct number of students that were retained in each grade level offered by the school Report the total number of students for each grade level that were retained Report "0" if the school offers the grade level but no students were retained Report NULL for each grade level the school does not offer Use Regular School Year Enrollment logic to determine if a student is eligible to report Use the Regular School Year EL, 504 and IDEA mapping for the applicable categories.
A student will be considered retained when they meet the following criteria: The End Action on the eligible enrollment for a student in the reporting year is = R: Retain If the student has more than 1 eligible enrollment, report Yes if any of the End Action fields are set to R: Retain
An override column will be next to the results with a text box that users can enter a value.
Detail Report Logic will display the following information: Year, NCES School Number, School Name, Students PersonID, State ID, Name, Grade Name and CRDC Grade Level, EL, IDEA, 504

RETN-2 GR12: Retention of Students in Grade 12

Category Mapping: Grade Levels, Regular School Year EL, Regular School Year IDEA, Regular School Year 504

Flat File Details:

Layout	Data Element	Male	Female
Permitted Values: Integer, NULL Length of Permitted Values: 7
RETN2.361, RETN2.362, RETN2.363	Hispanic or Latino of any race	SCH_RET_G12_HI_M	SCH_RET_G12_HI_F
RETN2.364, RETN2.365, RETN2.366	American Indian or Alaska Native	SCH_RET_G12_AM_M	SCH_RET_G12_AM_F
RETN2.367, RETN2.368, RETN2.369	Asian	SCH_RET_G12_AS_M	SCH_RET_G12_AS_F
RETN2.370, RETN2.371, RETN2.372	Native Hawaiian or Other Pacific Islander	SCH_RET_G12_HP_M	SCH_RET_G12_HP_F
RETN2.373, RETN2.374, RETN2.375	Black or African American	SCH_RET_G12_BL_M	SCH_RET_G12_BL_F
RETN2.376, RETN2.377, RETN2.378	White	SCH_RET_G12_WH_M	SCH_RET_G12_WH_F
RETN2.379, RETN2.380, RETN2.381	Two or More races	SCH_RET_G12_TR_M	SCH_RET_G12_TR_F
Total
RETN2.382, RETN2.383, RETN2.384	English Learners (EL)	SCH_RET_G12_EL_M	SCH_RET_G12_EL_F
RETN2.385, RETN2.386, RETN2.387	Students with Disabilities (IDEA)	SCH_RET_G12_IDEA_M	SCH_RET_G12_IDEA_F
RETN2.388, RETN2.389, RETN2.390	Students with Disabilities (Section 504 Only)	SCH_RET_G12_504_M	SCH_RET_G12_504_F

Logic
Count the distinct number of students that were retained in each grade level offered by the school. Report the total number of students for each grade level that were retained Report "0" if the school offers the grade level but no students were retained Report NULL for each grade level the school does not offer Use Regular School Year Enrollment logic to determine if a student is eligible to report Use the Regular School Year EL, 504 and IDEA mapping for the applicable categories.
A student will be considered retained when they meet the following criteria: The End Action on the eligible enrollment for a student in the reporting year is = R: Retain If the student has more than 1 eligible enrollment, report Yes if any of the End Action fields are set to R: Retain
An override column will be next to the results with a text box that users can enter a value.
Detail Report Logic will display the following information: Year, NCES School Number, School Name, Students PersonID, State ID, Name, Grade Name and CRDC Grade Level, EL, IDEA, 504

Was this helpful?

Knowledge 1 Knowledge 2 Knowledge From

CRDC questions calculated in Campus

1. SCHR: School Characteristics

3. PSCH: Preschool

PSCH-1: Preschool Age for Non-IDEA Children

PSCH-3: Preschool Enrollment

PSCH-4a: Preschool Enrollment of English Learner Students

PSCH-4b: Preschool Enrollment of English Learner Students - EL Students in EL Programs

PSCH-5: Preschool Enrollment of Students with Disabilities - IDEA

PSCH-6: Preschool Enrollment of Students with Disabilities - Section 504 Only

5. ENRL: Enrollment

ENRL-1: Student Enrollment

ENRL-2a: Enrollment of English Learner Students - All EL Students

ENRL-2b: Enrollment of English Learner Students - EL Students in Programs

ENRL-3: Enrollment of Students with Disabilities - IDEA

ENRL-4: Enrollment of Students with Disabilities - Section 504 Only

7. COUR: Courses & Classes

COUR-1: Grade 7/8 Algebra 1 Classes

COUR-2: Grade 7 Algebra I Enrollment Indicator

COUR-3: Grade 8 Algebra I Enrollment Indicator

COUR-4a: Student Enrollment in Algebra I - Grades 7 & 8

COUR-4b: Students who Passed Algebra I - Grades 7 & 8

COUR-5: Grade 8 Geometry Enrollment Indicator

COUR-6: Student Enrollment in Geometry in Grade 8

COUR-7: Classes in Mathematics Courses in High School

COUR-8a: High School Student Enrollment in Algebra I - Grades 9 & 10

COUR-8b: High School Students who Passed Algebra I - Grades 9 & 10

COUR-9a: High School Student Enrollment in Algebra I - Grades 11 & 12

COUR-9b: High School Students who Passed Algebra 1 - Grades 11 & 12

COUR-10: Student Enrollment in Mathemantics Courses in High School - Geometry

COUR-11: Student Enrollment in Mathematics Courses in High School - Algebra II

COUR-12: Student Enrollment in Mathematics Courses in High School - Advanced Mathematics

COUR-13: Student Enrollment in Mathematics Courses in High School - Algebra II

COUR-14: Classes in Science Courses

COUR-15: Student Enrollment in Science Courses - Biology

COUR-16: Student Enrollment in Science Courses - Chemistry

COUR-17: Student Enrollment in Science Courses - Physics

COUR-18: Classes in Computer Science Courses

COUR19: Student Enrollment in Computer Science Courses

COUR-20: Classes in Data Science Courses

COUR-21: Student Enrollment in Data Science Courses

COUR-22: Singe-Sex Academic Classes Indicator

COUR-23: Single-Sex Academic Classes Detail

9. EXAM: SAT/ACT

EXAM-1: Student Participation in the SAT Reasoning Test or ACT

12. RETN: Retention

RETN-1: Student Retention Indicator

RETN-2 GRK: Retention of Students in Kindergarten

RETN-2 GR1: Retention of Students in Grade 1

RETN-2 GR2: Retention of Students in Grade 2

RETN-2 GR3: Retention of Students in Grade 3

RETN-2 GR4: Retention of Students in Grade 4

RETN-2 GR5: Retention of Students in Grade 5

RETN-2 GR6: Retention of Students in Grade 6

RETN-2 GR7: Retention of Students in Grade 7

RETN-2 GR8: Retention of Students in Grade 8

RETN-2 GR9: Retention of Students in Grade 9

RETN-2 GR10: Retention of Students in Grade 10

RETN-2 GR11: Retention of Students in Grade 11

RETN-2 GR12: Retention of Students in Grade 12

Related Articles