PASS Attendance

[richard_]

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.

[Iain]

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.

[richard_]

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

Richard