Skip to content
Edition NigeriaGlobal
Country: Barbados

You are in the Barbados edition. Type your country to switch.

Set up your profile

You are learning in the Barbados edition, with examples in dollars and from Barbados.

Human resources and technology · Lesson 6 of 9

Integration and data flows

HR systems are only useful when data moves between them correctly. This lesson sets out the HR data model and the downstream systems that depend on it, explains file transfer, APIs and middleware in plain words, links single sign-on to the joiner, mover and leaver flow, and builds reconciliation controls and a worked integration map.

Intermediate13 min read6 steps

This lesson is complete in writing. A video for it is on its way.

What you will learn

  • By the end you can describe the HR data model and say which data is master data and which is transactional.
  • You can name the main downstream systems that depend on HR data and what each one needs.
  • You can explain file transfer, APIs and middleware in plain words and choose between them for a given flow.
  • You can design reconciliation controls for an integration and draw a simple integration map.

Key terms in this lesson

Master data
The slowly changing core facts that many systems copy, such as who a person is, their position, manager, location and pay, created once in the system of record.
Downstream system
Any system that receives data from the core HR record and depends on it being correct, such as payroll, learning, expenses or a benefits provider.
API
Application programming interface: a standard, secure connection through which one computer system shares specific data or functions with another.
Middleware
Software that sits between systems, receiving, transforming and delivering data, so that each system connects once to the hub rather than to every other system.
Point-to-point integration
A direct link built between two systems for one data flow; simple for a few systems but hard to maintain as their number grows.
Single sign-on
An arrangement in which a person logs in once with one identity and can then reach every connected system they are entitled to without signing in again.
Reconciliation
Checking a firm's own records of client money and assets against bank and custodian records, and fixing any difference.
Integration map
A single document listing every data flow between the core record and other systems, with source, target, data, pattern, frequency, owner and reconciliation.

Step 1 of 6

The HR data model

Opening this step…

Step 2 of 6

Master data and the downstream systems

This step opens when you finish the one above.

Step 3 of 6

Integration patterns in plain words

This step opens when you finish the one above.

Step 4 of 6

Single sign-on and the joiner-mover-leaver flow

This step opens when you finish the one above.

Step 5 of 6

Reconciliation controls

This step opens when you finish the one above.

Step 6 of 6

A worked integration map

This step opens when you finish the one above.

Key takeaways

The key takeaways open when you finish every step.

Lesson quiz

5 questions. You need 85% to pass.

The quiz opens when you finish every step.

Read first

Stockertim Learn is education. It explains how investing works and never recommends buying or selling anything.

Up next

Human resourcesSelf-service, employee experienc…Read nowSelf-service, employee experience and adoptionHuman resources · Intermediate · 15 minHuman resourcesSecurity, access and resilience …Read nowSecurity, access and resilience in HR systemsHuman resources · Intermediate · 15 minHuman resourcesThe business case and return on …Read nowThe business case and return on HR technologyHuman resources · Intermediate · 15 minHuman resourcesAI across the employee lifecycleRead nowAI across the employee lifecycleHuman resources · Advanced · 15 minBasicsmarket capitalisationRead nowWhat is market capitalisation?Basics · Beginner · 5 minHuman resourcesCore HR and the employee recordRead nowCore HR and the employee recordHuman resources · Intermediate · 15 minProjects, consulting & analysisProcess modelling: as-is and to-beRead nowProcess modelling: as-is and to-beProjects, consulting & analysis · Intermediate · 15 minHuman resourcesCross-border transfers and globa…Read nowCross-border transfers and global HR systemsHuman resources · Advanced · 15 minHuman resourcesData breaches in HRRead nowData breaches in HRHuman resources · Advanced · 15 minHuman resourcesData protection impact assessmen…Read nowData protection impact assessments and privacy by designHuman resources · Advanced · 15 minHuman resourcesRetention and deleting employee …Read nowRetention and deleting employee dataHuman resources · Advanced · 15 minHuman resourcesEmployee personal data across th…Read nowEmployee personal data across the lifecycleHuman resources · Advanced · 15 min
English