RETN-1 – Student Retention Indicator


This indicator does not display on the Results page, but it is populated in the extract with either a Yes or a No for the Kindergarten through 12th grade levels. If RETN-2 GRK through RETN-2 GR12 include any student counts, it will be populated with a Yes in the appropriate grade level, otherwise it will be populated with a No.



RET-2 – Retention of Students (GRK through GR12)


Students retained grades K-12- an unduplicated count of all students enrolled during the 2021-22 school year that were retained (not promoted to the next grade) anytime during the school year. The Retentions (RET) table will be evaluated for the Retention Codes selected on the General Settings tab.



  • Grade levels include Kindergarten – grade 12.
  • All students that were enrolled for any length of time during the 2021-22 school year are analyzed.
  • If one or more Retention (RET) codes are selected, then the program will count the student if they have a Retention (RET) record with one of the selected codes and the Retention Date is on or after the first day of school.  The student counts will be applied to their primary enrollment school as of the Retention date.
  • Ethnicity/Race - The Ethnicity (STU.ETH) and Race (STU.RC1 – STU.RC5) fields are used to determine the student ethnicity and race counts. Per Federal Guidelines, if a student’s Ethnicity is Hispanic they will only be counted in the Hispanic column. Also, race code 400 – Filipino is counted within the Asian category. 
  • Students will be counted in the Two or More races category under these conditions:
    • Ethnicity = Not Hispanic and the student has 2 or more different races in STU.RC1 – STU.RC5
    • Ethnicity = Not Hispanic and the student has no races in any of the STU.RC1 – STU.RC5 fields
    • Ethnicity = Not Hispanic and the student has a Declined to State race code in STU.RC1 as defined in the CALPADS Other tab
  • English Learners – the student’s Limited English (STU.LF) value needs to match the table, field and code specified in the General Settings tab for LEP. If the student does not have an LEP code, or if the code is other than the one specified in the setup form, the program will check the student’s Redesignation date (LAC.RD1). If there is a date, and it is on or after the Retention Date (RET.DT), the student will be flagged as Limited English. 
  • Students with Disabilities (IDEA) – students included in this category will have a Special Education (CSE) record with a disability code (CSE.DI), have an Enter date (CSE.ED) on/before the Retention Date (RET.DT) and no Exit date (CSE.XD), or an Exit date on/after the Retention Date (RET.DT).
  • Students with Disabilities (Section 504 Only) – the program will check for a record in the 504 Plans (FOF) table and evaluate the Start (FOF.SD) and End (FOF.ED) dates against the Retention Date (RET.DT). If no dates are in the record or if no FOF record is found then it will look in the User-Defined Location, field and value (usually PGM.CD = 101). If the table specified is the Special Program (PGM) table it will check the Eligibility Start (PGM.ESD) and End (PGM.EED) dates. If there is no date in those fields, it will check the Participation Start (PGM.PSD) and End (PGM.PED) dates.  It will compare these dates against the Retention Date (RET.DT). The retention date must fall within these start and end dates to qualify as an active 504 record. 
  • This logic pertains to tables:

            RETN-2 GRK – Retention of Students in Kindergarten

            through

            RETN-2 GR12 - Retention of Students in Grade 12