Qualification matrix: mapping qualifications in shift planning

A qualification matrix is an overview that records which employees are permitted to perform which tasks, operate which facilities or fill which functions. Each assignment comes with a level, a validity period and proof, such as a certificate or a documented safety instruction. In shift and staff planning, the matrix is the basis for checking every staffing assignment: a plan is only complete when every facility and every function is staffed with people whose qualification is valid at the time of deployment.

What a qualification matrix contains

In its simplest form, the matrix is a table. The rows list the employees, and the columns list the tasks, facilities and functions for which a qualification is required. Each cell contains more than a yes or no:

• Level: how independently a person performs the task
• Validity: from when and until when the qualification applies
• Proof: certificate, training record, safety instruction or written authorization

There should be only a few levels, each clearly described, for example:

Level	Meaning for planning
0	not qualified, not scheduled
1	in training, only together with a qualified person
2	works independently
3	works independently and can train others

The matrix also includes the requirements side. For each facility, function and shift, it specifies the minimum number of people who must be scheduled and at which level. Only matching the available qualifications against demand turns the matrix into a planning tool.

Why valid qualifications matter for safety and quality

At many workplaces, a valid qualification is a prerequisite for deployment. The German Occupational Safety and Health Act (Arbeitsschutzgesetz) requires employers, when assigning tasks, to take into account whether employees are capable of complying with the provisions and measures for safety and health protection (Section 7 ArbSchG). Instruction is given before employees start work, also when their area of responsibility changes and when new work equipment is introduced, and it is repeated regularly where necessary (Section 12 ArbSchG).

For work equipment, the German Ordinance on Industrial Safety and Health (Betriebssicherheitsverordnung) requires further instruction at regular intervals, at least once a year, with the date and the names of those instructed recorded in writing. Work equipment whose use involves particular hazards may only be used by employees specifically authorized to do so (Section 12 BetrSichV).

For planning, this means that a qualification only supports a staffing assignment as long as its proof is valid. The regulations mentioned are examples from German occupational safety and health law. Which obligations apply in your company depends on your risk assessment and the requirements of your industry.

Quality also depends on staffing, for example when certain inspection or setup steps require experience on a particular facility. The matrix also shows where a qualification is held by only a few people and a single absence puts staffing at risk.

Keeping the matrix up to date

A matrix is only as reliable as its latest version. Three points determine how well it is maintained:

• Expiry dates: Every time-limited qualification is given an expiry date, and refresher training is scheduled so that it takes place before the qualification expires.
• Training: Training and onboarding times belong in the shift schedule, because people in training are not available for staffing.
• Responsibilities: For each qualification, it is defined who confirms it and who records the proof, for example the line managers together with the occupational safety specialist or HR development.

How shift and staff planning uses the matrix

In planning, the matrix becomes a rule. A person is only eligible for a deployment if their qualification for the facility and function is valid at the time of deployment and the other rules are met, for example on working hours and absences.

Hawk IVO Plan plans your team according to qualifications and in step with your customer orders. The platform’s scope of services to date includes a qualification matrix and qualification-based matching. Master data and personnel movements can be imported from SAP and other ERP systems. We will clarify the right scope for you in a conversation.

The process remains traceable:

1. Create the plan: Hawk IVO Plan proposes a staffing plan based on rules and qualifications.
2. Clarify deviations: The people responsible review the proposal. Hawk IVO Force can support this step with agents, with an agent summarizing conflicts and preparing options.
3. Decide and execute: The people responsible approve the plan. Only then are changes implemented in the connected systems.

The decision stays with people. The article Shift planning with AI explains how proposal and approval work together.

Qualification-based workforce scheduling is also a research topic. According to the project description (opens in a new tab), the BMBF research consortium agileASSEMBLY, in which we were a partner, developed a digital workforce scheduling system consisting of a planning board and a mobile app that assigns employees dynamically and based on their qualifications. The project also describes rotation concepts and cross-training strategies that allow employees to be deployed flexibly. The article Self-organization on the shop floor describes how teams can organize their deployments themselves based on their skills.

Practical example: qualifications in a chemical plant

At OXEA’s Werk Ruhrchemie site in Oberhausen, hundreds of complex facilities stand on 1.2 km². The plant operates 24/7. Shift planning there is the foundation of plant safety, because exact qualifications determine safe operation. As complexity grew, isolated Excel spreadsheets became an incalculable risk. The plant therefore switched to a professional planning tool that matches the requirements of the facilities with employees’ valid certificates and handles nested qualification matrices.

This is how a public video case study from March 26, 2026 describes it. The video still shows Hawk IVO Plan under its former name, HAWK AI Planning. At the Oberhausen plant, Hawk IVO Plan has been in use since at least 2023 in several plant areas, including the plant fire department, the security service, logistics and the power plant. The topics include qualification management and safety pass, attendance at the plant, time tracking and shift accounts. Read more in the OXEA case study.

Common mistakes

• Only yes or no: Without a level and an expiry date, it remains unclear who may work independently and whether proof is still valid.
• Multiple versions: Departments maintain their own copies, and planning draws on an outdated version. The article When Excel is no longer enough for shift planning describes how the limits of a spreadsheet become apparent.
• Missing requirements side: The matrix describes people, but not which qualifications each facility and shift needs as a minimum.
• Dependence on individuals: A qualification is held by very few people, and cross-training is not planned.
• Training outside the plan: Training dates clash with staffing or are postponed until the validity expires.
• Short-notice changes without checks: When shifts are swapped or someone stands in, the qualification is not checked again.

Checklist for getting started

1. Define mandatory qualifications: for which tasks, facilities and functions a qualification is required, based on the risk assessment, operating instructions and quality requirements.
2. Describe levels: a few levels that everyone involved understands in the same way.
3. Determine minimum staffing: for each facility, function and shift.
4. Record proof: proof and expiry date for every qualification.
5. Assign responsibilities: who confirms qualifications and who maintains the matrix.
6. Define a single source of truth: one matrix whose master data comes from the HR system.
7. Carry out a first check: check a current shift schedule against the matrix. Gaps and bottlenecks show where training or cross-training is needed.

If you would like to bring qualifications into your shift planning, get in touch.