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
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.
Business Objects Knowledge Link LMS Universe facilitates access to the Learning
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
the Payroll system, in the Salary
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
tell that it