2939397 - After update/changing content object SCORM Exam Detail report no longer displays previous completion

After updating a content object, or changing the object associated to a item, to have a more updated content object. Running the SCORM Exam Detail report only displays the answers for the current content object and none of the older versions of the object's answers. 

SAP SuccessFactors Learning

The SCORM Exam Detail report pulls the data of the current association. If there is a change in content package on the item and no revision was created, the older content object's data answers are orphaned. 

Example: Some users completed the item before the modification of the content and some completed after the modification where the item was reassigned to them. When the content is removed and the new/same content is added, the moduleID changes in the PA_CBT_CPNT_MOD table. The moduleID will not change in the PA_CBT_STUD_CPNT_MOD table for the users that already completed the item before the content modification occurred. The SCORM Exam Detail report looks for the new moduleID, hence only the data for the users which have completed the item after the reassignment will show.

This is currently working as designed.

***The below resolution is outside the scope of support and helping to obtain this data is not something SAP Support can do.*** 

A custom report can be created to pull information.

PA_CBT_SCO_INTERACTION This table is where the question and individual responses are stored, unfortunately the only way to really segment and find the data you are looking for is doing a search of the DESCRIPTION column of the question, the end result will pull back all answers for that question. 

Next, find out what student answered what, and there is a column in PA_CBT_SCO_INTERACTION  called PA_STUD_CPNT_ID This is the field where we associated the Student with the Item. Next it will be needed to pull down this column and look in the PA_STUD_CPNT Table to know what the STUD_ID is so the user can be identified. 

This is a very long and manual process and we recommend anytime you need to change the content object, you should revise as to avoid this issue. 

LMS, Data , Missing, scorm, reporting, exam, interactions, answers, questions, 2004 , KBA , LOD-SF-LMS-REP , Reporting Data , Problem