I'm looking for the database field from which I can extract the time/date a student was suspended from his course (user_enrolments.status=1). I would expect the user_enrolments.timemodified field to reflect the last modification to a student's enrolment (including when a status is changed), but it doesn't. For example, if I suspend a student today, I would expect the timemodified field to say today, but it still says whatever date was in the field before I changed the status. Is this a bug? Or is there somewhere else that records when a student's status is changed to '1'?
I'm using 2.2 and suspending the student via Course Administration -> Users -> Enrolled Users