HAL Knowledge Base

New Academic Year for Schools

Modified on Mon, 16 Nov, 2026 at 1:47 PM

New Academic Year for Schools

  1. URL - admin/reports/runReport/346 - All Academic year

    1. Create a new entry for the next year
      1. Select Active - Prep, Migration Complete - No and Description - check the previous one
  2. After this they will start promotion process

  3. After completing promotion process they will ask us to check if they missed any student

  4. Run the following query to check whether the promotions are completed. The result should be Zero rows

    1. SELECT CONCAT_WS("-",val_classes.class,val_sections.section), student_master.* FROM student\_master inner join student_class_section on student_class_section.studentmaster_id = student_master.id and student_class_section.valacademicyear_id = previousYear(eg:2) inner join val_class_sections on val_class_sections.id = student_class_section.valclasssections_id inner join val_classes on val_classes.id = val_class_sections.valclasses_id inner join val_sections on val_sections.id = val_class_sections.valsections_id WHERE status = 'ACTIVE' AND year\_of\_admission != currentYear(eg:3) and student_master.id not in (select student_master.id from student_class_section inner join student_master on student_master.id = student_class_section.studentmaster_id and student_master.status = 'ACTIVE' and student_class_section.valacademicyear_id = currentYear(eg:3) and student_master.year_of_admission != currentYear(eg:3))
    2. This is should result as zero if some students listed we have check those students
  5. **Finally Close that year and update the new year

    1. admin/reports/runReport/346 edit the current year and previous year
    2. Previous year - Update Active - No and Migration Complete - Yes
    3. Current year - Update Active - Yes and Migration Complete - No**
Still need help?Contact support
Knowledge Base