MIS Systems Thread, Serco Attendance Percentage in Technical; Hi Everyone!
Does anyone know how I can get the current attendance percentage for a supplied student from the database? ...
24th March 2011, 11:55 AM #1
Serco Attendance Percentage
Does anyone know how I can get the current attendance percentage for a supplied student from the database? Our College would like a program displayed on student login that shows their current attendance percentage.
Ideally via SQL but if needed a daily report that contains the percentage for every student.
Hoping you can help...
24th March 2011, 03:11 PM #2
I think there is aggregate data in the table IFLSTUATTSTATS, which would let you do a simple calculation for a % result.
By Butters in forum MIS Systems
Last Post: 12th May 2010, 06:00 PM
By richard_ in forum MIS Systems
Last Post: 15th September 2009, 07:37 PM
By Dos_Box in forum General Chat
Last Post: 19th February 2009, 12:37 PM
By MattGibson in forum MIS Systems
Last Post: 26th June 2008, 12:58 PM
By danIT in forum MIS Systems
Last Post: 7th September 2006, 02:23 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)