Training and certificates
YouForce to Cornerstone integration: employees, units and managers through the Learning API
With an integration between Visma Raet YouForce and Cornerstone OnDemand, every employee from YouForce automatically appears in Cornerstone, with their manager from the role assignments and with unit, job, cost centre and location as organisational units. After the last employment ends the user becomes inactive, so Cornerstone no longer assigns training to former employees.
What the integration does
Organisations that process payroll and HR in YouForce and deliver compliance training in Cornerstone often send Cornerstone a user file assembled by hand from YouForce reports. A new manager then only sees their team's training after the next delivery, and the cost centre in Cornerstone lags behind.
- HR processes the change in YouForce, as today.
- KoppelHet retrieves persons, employments, units, jobs, cost allocation and role assignments processed since the previous round.
- New organisational units, managers and employees go to Cornerstone together in one job.
- KoppelHet reads the job result and reports rejected records to HR.
- When the last employment ends, the user becomes inactive in Cornerstone.
What to watch for with Visma Raet YouForce and Cornerstone OnDemand
- YouForce records who manages a unit in separate role assignments with a validity period. KoppelHet reads which role applies today and sets that person as manager. Cornerstone only accepts a manager who already exists or is in the same job, so a new manager is included in that job.
- In YouForce a salary can be split over several cost centres, while a Cornerstone user is attached to one Cost Center unit. KoppelHet picks the cost centre with the largest share of the allocation, so reports on training costs per cost centre add up.
- A person can have several employments in YouForce, for example with two employers in the same tenant. Cornerstone has one Legal Entity per user. KoppelHet creates one user on the person number and takes the employer and unit of the employment with the most hours; another rule is possible per customer.
- The Learning API only delivers data HR Core has already processed, and deleted records for only about seven days. KoppelHet therefore runs daily and corrects an employment removed in YouForce in Cornerstone within that term.
- Cornerstone limits creating and polling jobs to five per minute per environment. A daily YouForce round easily fits into one job with imports for all organisational units and employees, so the integration does not hit that limit, not even after a large reorganisation.
- Cornerstone keeps an import result for thirty days and allows only five downloads. KoppelHet fetches it once, stores the rejected records in the KoppelHet platform and links them back to the person number in YouForce, so HR knows who it went wrong for.
- YouForce has its own table of locations. Every location becomes a Location unit in Cornerstone, so a training that is mandatory for one site only, such as an emergency response instruction, only reaches employees of that site.
How we build and run it
- The integration runs on the KoppelHet platform, hosted in a data centre in the EU.
- Every sync and every error is visible in the functional log; on an error your administrator is notified.
- A change that cannot go through is not half-applied but queued for another attempt.
- KoppelHet is ISO 27001 certified. Data travels encrypted and stays on the platform no longer than needed.
- After go-live we manage the integration and adjust it when your process changes.
- The integration fits next to your existing integration layer. Only the fields in the design are transferred; the platform keeps no register of its own.
Implementation and price
This is not an app you switch on. We build the integration for your organisation on our platform, with building blocks we reuse on every project. So it is custom work that does not start from scratch.
A consultant prepares the intake and analyses both systems. We then record the mapping and exceptions field by field, test in the test or acceptance environment and go live at a moment you choose. Costs are a one-off amount for the setup and a monthly amount for platform, monitoring and support.
Frequently asked questions
Does completed training come back to YouForce?
Not in the first version. The Learning API can put a certificate as a document in the file; that can be added later as an extension, if your Cornerstone produces certificate files.
Are there costs on the Cornerstone side?
Yes. For production Cornerstone charges an annual fee for the Bulk API based on the number of licensed users; in pilot and stage environments it is free.
What do we need to arrange with Visma Raet?
You give the KoppelHet application access to the Learning API of your tenant, only with the basic scope for employee and organisation data.
Technical details for IT
For those who want to know how it works under the hood: APIs, fields and sources used.
- YouForce is read through the Youforce Learning API (api.youforce.com/learning) with OAuth 2.0 via Visma Connect, read-only - persons, employments, organizationUnits, jobProfiles, locations, costAllocations and roleAssignments, with from and to on latestSync and validOn for roles.
- Cornerstone is written through the Bulk API (OAuth 2.0, asynchronous) - one job with imports for Legal Entity, Division, Location, Cost Center, Position and Employee. Throttling five calls per minute on jobs; results through report, warnings and errors, thirty days and five downloads. The Data Load Wizard for HR must be switched off permanently.
Which fields are transferred
The key fields. The full mapping is agreed per customer.
| Field in Visma Raet YouForce | Field in Cornerstone OnDemand | Notes |
|---|---|---|
Persoonsnummer (personCode) | User ID | One user per person |
Roepnaam, Voorvoegsel + Achternaam | Voornaam en achternaam | |
Zakelijk e-mailadres | E-mail | |
Rolverdeling leidinggevende (roleAssignments) | Manager (User ID) | |
Organisatie-eenheid | Division-OU | With the parent unit as parent |
Functie (jobProfile) | Position-OU | |
Kostenverdeling (costAllocations) | Cost Center-OU | The cost centre with the largest share |
Locatie | Location-OU | |
Werkgever (company) | Legal Entity-OU | |
Einddatum laatste dienstverband | Status inactief |
Related
ADP Workforce Now → Visma Raet YouForce
ADP Workforce Now to YouForce integration: requests for new Dutch hires and contract changes
Bullhorn → Visma Raet YouForce
Bullhorn to YouForce integration: a placement becomes a hire request
Carerix → Visma Raet YouForce
Carerix to YouForce integration: a placed candidate starts the hire workflow in YouForce
Darwinbox → Visma Raet YouForce
Darwinbox to YouForce integration: hires and pay changes from Darwinbox as a request in YouForce