Integrating Training Data from Learning Management

This section discusses how to integrate Time and Labor with Learning Management.

To use the ELM training data for display in the Manage Schedules and Manager Calendar pages, and the Workforce Availability pagelet, these steps should be considered:

  • The learners are enrolled in the Job data record in HCM and the personal information has been messaged from HCM to ELM.

  • Activate the Scheduled Time Fullsync message in the HCM and ELM database.

  • Ensure Scheduled Time FullSync is run first, to get all activities and sessions over to HCM before starting to use the Scheduled Time Sync message.

  • The Scheduled Time Fullsync should only be run once for initial setup. If the Scheduled Time Fullsync is run more than once, no rows will be deleted from the SCH_EXT_DTL table first. Any rows that are duplicate rows will be inserted into the SCH_EXT_REJ table.

  • Activate the Scheduled Time Sync message in the HCM and ELM Database.

Note: When the Scheduled Time Fullsync message flows in from Enterprise Learning Management, it triggers the SCH_EXT_VALID Application Engine program in the HCM database. This program moves data from the SCH_EXT_STG table to the SCH_EXT_DTL table.

Note: The Enterprise Learning Management field on the Products page (Set Up HCM, Install, Installation Table), needs to be checked, in order for the user to view ELM training data icons in Manage Schedules, Monthly Schedules and Calendars.

Scheduled Time Sync Message

The Scheduled Time Sync message in ELM is triggered by:

  • Activity pages trigger a sync message. This includes session changes or additions, trainer changes, session date or time changes, dropping a learner from a session or adding a learner to a session.

  • Enrollment modifications trigger a sync message. This includes the Manager Enrollment, Employee Enrollment and Administrator Enrollment components.

ELM Data Display

A training icon will appear on a day that an employee is enrolled in training for both the Manage Schedule and Monthly Schedule pages.

The training data that is displayed in the Schedule Daily Detail section of the Manage Schedules page includes:

  • The catalog item of the activity (that is the Course Code Description).

  • Session Start Date and Start Time per day (that is, if training spans more than one day, there would be multiple sessions).

ELM data is derived to count employees who are reported as training for the Manager Calendar Views and the Workforce Availability pagelet.

The SCH_EXT_DTL and AUDIT_SCH_TBL records are updated for every training data change triggered from the Scheduled Time Sync message.

See the product documentation for PeopleSoft Enterprise Learning Management PeopleBook