Hi
I'm writing a sql query to extract records of students completion of courses [SCORM content at present].
I need data for 'started' and 'completed' (last access will serve for completed courses).
This report SCORM report shows 'started on' and 'last accessed on' dates? [see attached screen shot]
http://<server>/moodle/mod/scorm/report.php?id=19
Can anyone tell me which table and fields are used for these dates on the report?
I'd be very grateful. I've found the table scorm_scoes_track useful but it doesn't have dates (only times).
Linda