Learning Management Collection Refresh Schedule

The Learning Management data collection is refreshed every night in the Data Warehouse. There are two kinds of scheduled batch jobs that refresh the data collection: delta jobs and full jobs.

The jobs for the LMS Delta Staging Load and the LMS Collection Load (Delta) run Saturday night through Thursday night (actually, Sunday through Friday from about 2:30 a.m. until about 3:30 a.m.). The delta jobs load records that were added or changed in Knowledge Link in the previous 24 hours that ended at 9:00 p.m. For example, the delta jobs that run on Tuesday night (early Wednesday morning) load records that were added or changed in Knowledge Link between 9:00 p.m. on Monday and 9:00 p.m. on Tuesday.

The jobs for the LMS Full Staging Load and the LMS Collection Load (Full) run Friday night (actually, Saturday from about 4:30 a.m. until about 7:00 a.m.). The full jobs synchronize the data in the Warehouse with the data as it was in Knowledge Link on Friday at about 10:30 p.m. In addition to adding and updating records, the full jobs delete records from the Warehouse if they have been deleted from Knowledge Link.

Note: the Learning Management collection is not available for querying while the data is being refreshed. To see whether the jobs that refresh the Learning Management System (LMS) data in the Warehouse are in progress, check the Data Warehouse Update/Load Status.

Source of the Data
The data in the Learning Management data collection comes from Knowledge Link, the learning management system used by the University and by the University of Pennsylvania Health System, running on the SuccessFactors platform that has been in use since October 9, 2012. The Business Objects Knowledge Link LMS Universe facilitates access to the Learning Management data collection, as well as to reference tables with data on University orgs. (from the BEN Financials General Ledger system, in the General Ledger data collection), and on University employees and job classes (from the Payroll system, in the Salary Management data collection).

Time Span Covered
Knowledge Link has been in use since March, 2005. (It moved from the Gen21 platform to the SuccessFactors platform in October, 2012.) For some trainees and items, learning history data is available for training that was completed before March, 2005. (An item is an assignable unit whose assignment and completion can be tracked in Knowledge Link.  In most cases, an item is a course, but it may be a non-learning activity.)  There is a learning history record for each time that a trainee concluded an item or external event. If, for example, Jane Doe took Respiratory Protection Training- EHRS three times (completing it twice and leaving it incomplete once), she would have three learning history records for it. However, Knowledge Link stores only the latest information about everything else. For example, if John Smith originally was assigned Shop Safety - EHRS as a required item, but never took it, and it is no longer assigned to him, there is no way to tell that he was ever required to take it. Likewise, if the title of an item is changed from A to B, there is no way to tell that it was ever A.