All Tables in Aeries to use Student ID instead of SN
It would be so helpful for all tables to use the student ID as the unique identifier instead of School Code/Student Number. This would avoid the need to query the STU table to obtain the ID number.
Heather Benson commented
Can we just get rid of the student number? It's confusing and the Permanent/Student ID is an easier/better number to search with.
I agree, it would be great to be able to select if we want to print reports with school based IDs or permanent IDs.
Anatoliy Russ commented
Currently students have a school based ID and a permanent ID. It would be great if we had the option to turn off school based IDs and replace them with the permanent ID. This would alleviate some of the issues with querying out student records in school based tables when all records are needed but the only way to get the students' records is by joining with another table that has both the school based ID and permanent ID.