Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Enrollment Event ID for ILT session, schema issue? — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Enrollment Event ID for ILT session, schema issue?

Received Response
edited Feb 22, 2017 5:56PM in Taleo Learn 6 comments


The pdf schema indicates an ID of 5 for ILT sessions but might include other event types


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
ILT Sessions RIGHT JOIN Enrollments
Join Conditions
ILT Sessions.ILT Session ID = Enrollments.Enrollment EventID
Enrollments.Enrollment Event Type ID = 5
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.

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!