CRDC - RETN: Retention Questions

Tool Search: Civil Rights Data Collection (CRDC) > Maintain Survey Results

The following questions are part of the RETN: Retention questions for CRDC:

Note: Results for the SCHR: School Characteristics module must be generated at least once for a given school prior to independently generating results for other modules.

When skip logic is provided:

  • If the skip logic criteria is met, data are required in the field for a complete submission.
  • If the skip logic criteria is not met, LEAs may omit the data.

Module Instructions

Click here to expand...

Dates

The data reported should be based on the entire 2021-22 school year, including summer, up to one day prior to
the start of the following school year.

When to Report Zero (0) and When to Use Blanks (i.e., NULL Values)

Zeroes represent an actual count or number for fields that are applicable to a given school or LEA. Report a zero ("0") only if the LEA has collected the information and the amount to report for that field is zero. Do not report a "0" for data not collected. Leave a field blank if the LEA does not collect data for that field, if the amount asked is unknown, or if the question does not apply to the LEA.

Not Applicable (NA) and Zero (0) Autofills In Tables

The online tool remembers information that has been entered in other tables and modules and uses that information to fill related tables with either a Not Applicable (NA) code or zero (0) where appropriate. For example, if it is reported that a school does not have any female students who are EL, then other tables that ask for counts of female students who are EL will be automatically filled with a zero.

Key Definitions

  • A student is retained if the student is not promoted to the next grade prior to the beginning of the following school year. Students are not considered retained if they can proceed to the next grade because they successfully completed a summer school program or for a similar reason. At the high school level, a student who has not accumulated enough credits to be classified as being in the next grade is considered retained.
  • Nonbinary means not exclusively male or female. Transgender students may be reported as male, female, or nonbinary.

Special Instructions

  • For a school that already disaggregates student enrollment data to include nonbinary students, the nonbinary category in the Retention module is OPTIONAL.
  • For a school that does NOT already disaggregate student enrollment data to include nonbinary students, the nonbinary category in the Retention module is SKIPPED.

RETN-1: Student Retention Indicator

Click here to expand...

Instructions: Schools and justice facilities, grades K-12.

For each grade listed in the table, indicate whether any students were retained at the end of the 2021-22 school year (not promoted to the next grade). Please select "Yes" or "No" in the table below. 

  • Indicate whether the school had any students who were retained in any of the grades specified. Provide a response only for the grades that were reported as having at least one student enrolled in the SCHR-3 item.
  • Respond yes if a student was not promoted to the next grade prior to the beginning of the 2022-23 school year.
  • Do not count a student as retained if the student was able to proceed to the next grade because the student successfully completed a summer school program or for a similar reason. 

Category Mapping: Grade Levels

Grade Levels: K-12

Skip Logic: Required question. All data elements must be answered.

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

Click here to expand...

Instructions: Only for schools and justice facilities (with any grade K-12) reporting kindergarten student retention.

Enter the number of students in Kindergarten who were retained at the end of the 2021-22 school year (not promoted to the next grade).

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

Grade Levels: Kindergarten 

Skip Logic: 

1) For Nonbinary questions only. NBIN-1. Nonbinary Student Indicator: School had any nonbinary students in its enrollment records (SCH_NBS_IND is YES).

2) RETN-1.1. Student Retention Indicator - Kindergarten: School with students retained in kindergarten (SCH_RET_KG_IND is YES)

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 last 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

Click here to expand...

Instructions: Only for schools and justice facilities (with any grade K-12) reporting grade 1 student retention.

Enter the number of students in grade 1 who were retained at the end of the 2021-22 school year (not promoted to the next grade).

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

Grade Levels: 1 

Skip Logic: 

1) For Nonbinary questions only. NBIN-1. Nonbinary Student Indicator: School had any nonbinary students in its enrollment records (SCH_NBS_IND is YES).

2) RETN-1.1. Student Retention Indicator - Kindergarten: School with students retained in kindergarten (SCH_RET_KG_IND is YES)

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 last 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

Click here to expand...

Instructions: Only for schools and justice facilities (with any grade K-12) reporting grade 2 student retention.

Enter the number of students in grade 2 who were retained at the end of the 2021-22 school year (not promoted to the next grade). 

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

Grade Levels: 2 

Skip Logic: 

1) For Nonbinary questions only. NBIN-1. Nonbinary Student Indicator: School had any nonbinary students in its enrollment records (SCH_NBS_IND is YES).

2) RETN-1.3. Student Retention Indicator - Grade 2: School with students retained in Grade 2 (SCH_RET_G02_IND is YES)

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 last 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

Click here to expand...

Instructions: Only for schools and justice facilities (with any grade K-12) reporting grade 3 student retention.

Enter the number of students in grade 3 who were retained at the end of the 2021-22 school year (not promoted to the next grade).

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

Grade Levels: 3 

Skip Logic: 

1) For Nonbinary questions only. NBIN-1. Nonbinary Student Indicator: School had any nonbinary students in its enrollment records (SCH_NBS_IND is YES).

2) RETN-1.4. Student Retention Indicator - Grade 3: School with students retained in Grade 3 (SCH_RET_G03_IND is YES)

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 last 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

Click here to expand...

Instructions: Only for schools and justice facilities (with any grade K-12) reporting grade 4 student retention.

Enter the number of students in grade 4 who were retained at the end of the 2021-22 school year (not promoted to the next grade). 

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

Grade Levels: 4 

Skip Logic: 

1) For Nonbinary questions only. NBIN-1. Nonbinary Student Indicator: School had any nonbinary students in its enrollment records (SCH_NBS_IND is YES).

2) RETN-1.5. Student Retention Indicator - Grade 4: School with students retained in Grade 4 (SCH_RET_G04_IND is YES)

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 last 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

Click here to expand...

Instructions: Only for schools and justice facilities (with any grade K-12) reporting grade 5 student retention.

Enter the number of students in grade 5 who were retained at the end of the 2021-22 school year (not promoted to the next grade). 

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

Grade Levels: 5 

Skip Logic: 

1) For Nonbinary questions only. NBIN-1. Nonbinary Student Indicator: School had any nonbinary students in its enrollment records (SCH_NBS_IND is YES).

2) RETN-1.6. Student Retention Indicator - Grade 5: School with students retained in Grade 5 (SCH_RET_G05_IND is YES)

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 last 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

Click here to expand...

Instructions: Only for schools and justice facilities (with any grade K-12) reporting grade 6 student retention.

Enter the number of students in grade 6 who were retained at the end of the 2021-22 school year (not promoted to the next grade).

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

Grade Levels: 6 

Skip Logic:  

1) For Nonbinary questions only. NBIN-1. Nonbinary Student Indicator: School had any nonbinary students in its enrollment records (SCH_NBS_IND is YES).

2) RETN-1.7. Student Retention Indicator - Grade 6: School with students retained in Grade 6 (SCH_RET_G06_IND is YES)

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 last 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

Click here to expand...

Instructions: Only for schools and justice facilities (with any grade K-12) reporting grade 7 student retention.

Enter the number of students in grade 7 who were retained at the end of the 2021-22 school year (not promoted to the next grade).

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

Grade Levels: 7 

Skip Logic: 

1) For Nonbinary questions only. NBIN-1. Nonbinary Student Indicator: School had any nonbinary students in its enrollment records (SCH_NBS_IND is YES).

2) RETN-1.8. Student Retention Indicator - Grade 7: School with students retained in Grade 7 (SCH_RET_G07_IND is YES)

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 last 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

Click here to expand...

Instructions: Only for schools and justice facilities (with any grade K-12) reporting grade 8 student retention.

Enter the number of students in grade 8 who were retained at the end of the 2021-22 school year (not promoted to the next grade).

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

Grade Levels: 8 

Skip Logic: 

1) For Nonbinary questions only. NBIN-1. Nonbinary Student Indicator: School had any nonbinary students in its enrollment records (SCH_NBS_IND is YES).

2) RETN-1.9. Student Retention Indicator - Grade 8: School with students retained in Grade 8 (SCH_RET_G08_IND is YES)

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 last 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

Click here to expand...

Instructions: Only for schools and justice facilities (with any grade K-12) reporting grade 9 student retention.

Enter the number of students in grade 9 who were retained at the end of the 2021-22 school year (not promoted to the next grade).

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

Grade Levels: 9 

Skip Logic: 

1) For Nonbinary questions only. NBIN-1. Nonbinary Student Indicator: School had any nonbinary students in its enrollment records (SCH_NBS_IND is YES).

2) RETN-1.10. Student Retention Indicator - Grade 9: School with students retained in Grade 9 (SCH_RET_G09_IND is YES)

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 last 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

Click here to expand...

Instructions: Only for schools and justice facilities (with any grade K-12) reporting grade 10 student retention.

Enter the number of students in grade 10 who were retained at the end of the 2021-22 school year (not promoted to the next grade).

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

Grade Levels: 10 

Skip Logic: 

1) For Nonbinary questions only. NBIN-1. Nonbinary Student Indicator: School had any nonbinary students in its enrollment records (SCH_NBS_IND is YES).

2) RETN-1.11. Student Retention Indicator - Grade 10: School with students retained in Grade 10 (SCH_RET_G10_IND is YES

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 last 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

Click here to expand...

Instructions: Only for schools and justice facilities (with any grade K-12) reporting grade 11 student retention.

Enter the number of students in grade 11 who were retained at the end of the 2021-22 school year (not promoted to the next grade).  

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

Grade Levels: 11 

Skip Logic: 

1) For Nonbinary questions only. NBIN-1. Nonbinary Student Indicator: School had any nonbinary students in its enrollment records (SCH_NBS_IND is YES).

2) RETN-1.12. Student Retention Indicator - Grade 11: School with students retained in Grade 11 (SCH_RET_G11_IND is YES)

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 last 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

Click here to expand...

Instructions: Only for schools and justice facilities (with any grade K-12) reporting grade 12 student retention.

Enter the number of students in grade 12 who were retained at the end of the 2021-22 school year (not promoted to the next grade).

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

Grade Levels: 12 

Skip Logic: 

1) For Nonbinary questions only. NBIN-1. Nonbinary Student Indicator: School had any nonbinary students in its enrollment records (SCH_NBS_IND is YES).

2) RETN-1.13. Student Retention Indicator - Grade 12: School with students retained in Grade 12 (SCH_RET_G12_IND is YES)

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 last 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