New Academic Year for Schools
-
URL - admin/reports/runReport/346 - All Academic year
- Create a new entry for the next year
- Select Active - Prep, Migration Complete - No and Description - check the previous one
- Create a new entry for the next year
-
After this they will start promotion process
-
After completing promotion process they will ask us to check if they missed any student
-
Run the following query to check whether the promotions are completed. The result should be Zero rows
- SELECT CONCAT_WS("-",val_classes.class,val_sections.section), student_master.* FROM
student\_masterinner 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 WHEREstatus= 'ACTIVE' ANDyear\_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)) - This is should result as zero if some students listed we have check those students
- SELECT CONCAT_WS("-",val_classes.class,val_sections.section), student_master.* FROM
-
**Finally Close that year and update the new year
- admin/reports/runReport/346 edit the current year and previous year
- Previous year - Update Active - No and Migration Complete - Yes
- Current year - Update Active - Yes and Migration Complete - No**