Does anyone know which table in WCBS/PASS holds the pupil attendance data? Is it stored by exception (ie everyone is assumed to be present if not explicitly flagged as absent) or by status for all pupils? A brief look would indicate that db.events and dbo.attendance_details might contain the data but it doesnt look quite right.
Take a look at the view XX_AC_ABSENCE_CURR_YEAR, where XX is your school code. If you look at the SQL for that view, it should give you the tables that are involved in working out attendance.
Iain, Thanks for the help. Winding my way through this I ended up at the events table with event_type of ABSNCE and category <> PRESAM and <> PRESPM