Summary of tracking data at a session level

Available columns

Name Description
candidateId The database ID used to identify the learner.
candidateName The learner’s name (family name/surname).
candidateFirstname The learner’s first name.
candidateLogin The learner’s login.
candidateEmail The learner’s e-mail address.
candidateRefNumber The learner’s reference number.
candidateGuid The learner’s GUID.
candidateGroupAncestors This column is deprecated in the CKLS 14.1 version, please use candidateEntityAncestors instead.
candidateEntityAncestors The learner’s entity ancestors.
candidateGroupName The learner’s group name.
candidateEntityName The learner’s entity name.
candidateCustomFieldGuid GUID for one of the learner’s possible custom fields.
lastPlatformAccessDate The last date at which the learner has accessed the platform.
nbLO The total number of learning objects in the same session as the learning object referenced by the tracking row.
nbLOStarted The total number of learning objects that the learner has started in the same session as the learning object referenced by the tracking row.
nbLOFinished The total number of learning objects that the learner has finished in the same session as the learning object referenced by the tracking row.
registrationDate The date of the registration.
registrationGuid The GUID of the registration.
sessionId The database ID used to identify the session.
sessionTitle The title of the session.
sessionGuid The GUID of the session.
sessionStartDate The start date of the session.
sessionEndDate The end date of the session.
trainingId The database ID used to identify the training course.
trainingTitle The title of the training course.
trainingPathCode The reference number of the training course.
trainingGuid The GUID of the training course.
catalogVisibility “Y” if the training course associated with the current context is visible in the public catalogue, “N” otherwise.
trainingStatus The status (published, archived or under construction) of the training course. The values displayed in this column can be configured via the trainingStatusFormat parameter.
trainingModality The modality of the training course.
trainingPublisher The publisher of the training course.
trainingChapters The chapter hierarchy of the training course.
trainingDuration The duration of the training course.
completionTime The date at which the content referenced by the tracking row has been completed [JULIEN] WRONG => the last access date
firstLaunchDate The date at which the content referenced by the tracking row has been launched for the first time.
progression The progress of the learner on the current content referenced by the tracking row (ie. 80%).
progressionMandatory The total progress of the learner (on the mandatory learning objects) in the current session.
score The score the learner has achieved on the content.
npsScore Score of a NPS activity.
status The progress status (completed, incomplete or not started) of the content referenced by the tracking row.
thresholdReachedDate The date on which the learner has reached the success threshold of the training course.
firstCompletionDate The date at which the content referenced by the training has been completed for the first time.
timeGlobal The total time the learner spent on the content.
timeSpentCBT The total time spent in classrooms.
timeSpentDigital The total time spent on digital activities.
timeSpent The total time the learner spent on the content.
constantValue Return the constant value specified in this column’s child elements.

Filters and parameters

Name Description
activityType Blendedx registrations are exported as soon as their related path contains at least one activity of this type. Other modalities’ registrations are exported if the filter is 0 (content) and 4 (classroom) and contains CBT activities
ancestorsWithCurrent For each tracking data row, the learner’s hierarchy can be exported with the other data. This parameter tells the provider whether to include the learner’s group in the hierarchy or not. If set to yes, the learner’s current group will be included. Otherwise, it will be removed from the exported hierarchy.
catalogVisibility Only export training courses that have the specified catalog visibility.
dateFormat Format for dates in the exported data. The default date format is YYYY-MM-DD.
dateTimeFormat Format for dates in the exported data. The default datetime format is YYYY-MM-DD hh:ii:ss.
deltaMode Only export new tracking data (with respect to the last export). In order for this parameter to work, the previous exports must have had a guid attribute (<export guid='foo'>). This feature cannot be used alongside timeFramesScale.
groupIds This parameter is deprecated in the CKLS 14.1 version, please use entityIds instead. A comma-separated list of the group ids to filter on. If multiple group ids are provided, then the export will return data about learners who belong to at least one of those groups.
entityIds A comma-separated list of the entity ids to filter on. If multiple entity IDs are provided, then the export will return data about learners who belong to at least one of those entities.
modality Only export data related to a training course that belongs to the specified modality.
onlyFromImportedRegistrations Only export tracking data related to registrations that were imported.
onlyFromImportedSessions Only export tracking data related to sessions that were imported.
reportStatus Export tracking data that have the specified report statuses (several values can be given).
sessionGuid Only export data related to a training session that has the specified GUID.
sessionTitle Only export data related to a training session that has a title that contains the given string.
statusFormat This parameter is used to convert LMS progress status to Scorm-compliant progress status.
timeFrames Once a learner has completed a learning object, a completion date will be saved in the associated tracking row. This parameter is used to the provider to only export tracking data where the completion date is in a certain time span. Must be used with timeFramesScale.
timeFramesScale Once a learner has completed a learning object, a completion date will be saved in the associated tracking row. This parameter is used to the provider to only export tracking data where the completion date is in a certain time span. Must be used with timeFrames.
timeFramesScaleMode  
timeGlobalFormat Time format in which the timeGlobal column should be exported
trainingGuid Only export data related to a training course that has the specified GUID.
trainingPathCode Only export data related to a training course that has the specified code.
trainingStatus Only export training courses that have the specified statuses. This parameter contains a comma-separated list of training statuses (see the default values in trainingStatus).
trainingStatusFormat Configure what value to display for each training status value.
preferredLocales The comma-separated list of preferred locales.

Examples

<providers>
    <consolidatedTrackingProvider>
        <columns>
            <candidateId/>
            <candidateName/>
            <candidateFirstname/>
            <candidateLogin/>
            <candidateEmail/>
            <candidateRefNumber/>
            <candidateGuid/>
            <candidateGroupAncestors/>
            <candidateEntityAncestors/>
            <candidateGroupName/>
            <candidateEntityName/>
            <candidateCustomFieldGuid/>
            <lastPlatformAccessDate/>
            <nbLO/>
            <nbLOStarted/>
            <nbLOFinished/>
            <registrationDate/>
            <registrationGuid/>
            <sessionId/>
            <sessionTitle/>
            <sessionGuid/>
            <sessionStartDate/>
            <sessionEndDate/>
            <trainingId/>
            <trainingTitle/>
            <trainingPathCode/>
            <trainingGuid/>
            <catalogVisibility/>
            <trainingStatus/>
            <trainingModality/>
            <trainingPublisher/>
            <trainingChapters/>
            <trainingDuration/>
            <completionTime/>
            <firstLaunchDate/>
            <progression/>
            <progressionMandatory/>
            <score/>
            <status/>
            <thresholdReachedDate/>
            <firstCompletionDate/>
            <timeGlobal/>
            <constantValue/>
            <npsScore/>
            <timeSpentCB/>
            <timeSpentDigital/>
            <timeSpent/>
        </columns>
        <parameters>
            <dateTimeFormat>YYYY-MM-DD hh:ii:ss</dateTimeFormat>
            <timeFrames>3</timeFrames>
            <timeFramesScale>less_than_n_days</timeFramesScale>
            <timeFrameScaleMode>lastActivity,timeSpent</timeFrameScaleMode>
        </parameters>
    </consolidatedTrackingProvider>
</providers>