I am running Moodle 2.4. I have a report that queries the Moodle database to retrieve user name, course name, activity name, grade, grade date and a few other data items. I need to add course enrollment method to this report for each user's courses. We're adding courses that will use the PayPal plugin for enrollment. Knowing who got into a course via PayPal, or by cohort, or by being manually enrolled will need to be part of my report. I need to know what database table holds that info so I can add it to my report query. Any help that would point me in the right direction would be great. Thanks.
Not quite the right forum for this query. You can probably find the answer in the Enrolment forum. At any rate, the 'mdl_user_enrolments' and 'mdl_enrol' tables should provide you with the desired info. The former records the id of the enrollment method (enrolid) for each course enrollment and the latter will give you the details of that enrollment method. hth
Thank you for the help... sorry for the wrong location to post.
Just moving this discussion thread to the enrolment forum for others who may have similar questions.