What table is used to record session attendance?

What table is used to record session attendance?

by Dustin Elliott -
Number of replies: 2
Hello,

Can anyone tell me what table and field is used to record attendance in a Face-to-Face session?

Looking at the code for the Face-to-Face module is seems that the grade field in the mdl_facetoface_submissions table is used to determine if someone has been marked as attending a session (0=Did not attend, 100=Did attend).

My question arises because none of the records in my mdl_facetoface_submissions table have "100" as a grade, they are all 0, but everything seems to work as it should.

Am I missing something in the code? Where is the attendance being recorded?

Thanks,
Dustin Elliott
Average of ratings: -
In reply to Dustin Elliott

Re: What table is used to record session attendance?

by François Marier -
The grade field has been removed in more recent versions. The attendance is now stored in the Moodle gradebook directly, not in the Face-to-face module.

So you need to look at the gradebook tables (grade_grades for example) for the attendance data.

Cheers,
Francois
In reply to François Marier

Re: What table is used to record session attendance?

by Dustin Elliott -
Once again thank you François! I found it.

Dustin