I've been working on custom SQL reports on primarily SCORM activities within a given course. The scorm table from the sql database shows start time but not completion timestamp. In layman's terms I can know when a learner starts a SCORM activity but not when it is completed. It does tell me how much time is spent - which is a good statistic - but I want to close it off with the completion date and time.
On the other hand, Moodle course-level reports - namely Activity Completion, seem to populate this information with ease. They show the timestamp of completion for every applicable activity in the course (be it SCORM or non-scorm). However, I cannot identify which sql table and/or columns it retrieves this data from. Does anyone know where in the database specifically this is stored?