Enrollment Event ID for ILT session, schema issue?
Summary
The pdf schema indicates an ID of 5 for ILT sessions but might include other event typesContent
I created a BI report to see if had any ILT type enrollments that were orphans (no matching ILT session). Shouldn't be possible in my mind, but you never know.
Data Views
Enrollments, ILT Sessions
Joins
ILT Sessions RIGHT JOIN Enrollments
Join Conditions
ILT Sessions.ILT Session ID = Enrollments.Enrollment EventID
Enrollments.Enrollment Event Type ID = 5
Filters
ILT Sessions.ILT Session ID IS NULL
In my result set I see event types of course, self study, class, forum..... I was not expecting that.
Tagged:
0