OLM tables / SQL already written
I have just been given responsibility for the OLM module and I am looking to improve the reporting we have. I am trying to find either the table structure for OLM - I need to know where OLM information is held (I have some information and I'm trawling through the OTA tables but, for example, I am unable to find where external course information is held).
Alternatively I would like to find some prewritten sql that covers the standard information in OLM. Courses created, courses run, people attended etc. I am just looking for standard information and I assume it has been written many, many times before. Seems such a waste of time to do it over again.