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
32
Views
6
Comments
edited Feb 22, 2017 5:56PM in Taleo Learn 6 comments

Summary

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

Content

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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