I was asked this week if it is simple to obtain information about enrollments, particularly the date it was made. Here is a query with comments on how to go about this and this can be used on ASR connection to STATS.
SELECT U.USER_ID, CM.COURSE_ID, C.ENROLLMENT_DATE, C.DTMODIFIED
FROM COURSE_USERS C, COURSE_MAIN CM, USERS U
WHERE U.PK1 = C.USERS_PK1
AND CM.PK1 = C.CRSMAIN_PK1
AND C.CRSMAIN_PK1 = (SELECT PK1 FROM COURSE_MAIN WHERE COURSE_ID = 'COURSE_ID_GOES_HERE')
--AND c.ENROLLMENT_DATE > '01-SEP-16' --Used to filter on date
order by 3 asc;