we are using CourseLab for creating courses and tests and export them into SCORM 2004. What data is passed and saved to the Oracle iLearning database from the SCORM 2004 content? Are the questions and answers of the test being saved? What are the tables to look for? Does the description of Oracle ilearning DB tables exist somewhere?
As iLearning is SCORM 2004 (edition 3) compliant it saves the data described by the SCORM 2004 standard. So if you want to know all the details of what is being communicated between the content and iLearning you should study the SCORM 2004 manual (can be downloaded from adlnet.gov).
But in short: The results from the tests are saved, but not the individual answers.
Thank You Scott so much. I checked the query that You ‘ve provided, although some tables are named differently in our Oracle iLearning (v. 5.2.1) DB. It is really difficult to figure out what data is saved in what tables; what views are used for particular pages. Could You point out any source of definition for tables/views and data used in Oracle iLearning? It Would be very helpful.
The sql I gave is what you would create as a custom report within the iLearning application (which uses the ILEARN_RPT schema). This probably is why some of the table names look different (if you are looking at the base tables in the ILEARN schema).
There is an old data dictionary (up to version 5.0) I believe on My Oracle Support knowledgebase but it doesn't include updates for some of the newer tables. It can get you started however. We maintain our own version with updates as necessary for our internal use :)
Also, within iLearning you can access the custom report views information for table/columns used in custom reporting at: