Country: Barbados
You are in the Barbados edition. Type your country to switch.
Nigeria
The Americas
Loading every country…
No country matches. Check the spelling, or choose "Any country" for the Global edition.
You are learning in the Barbados edition, with examples in dollars and from Barbados.
Your learning profile
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.
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: The HR data model, not started
- Step 2: Master data and the downstream systems, not started
- Step 3: Integration patterns in plain words, not started
- Step 4: Single sign-on and the joiner-mover-leaver flow, not started
- Step 5: Reconciliation controls, not started
- Step 6: A worked integration map, not started
About 12 min of reading
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.
Popular this week: Basics: BeginnerStock market: Intermediate