The Medicator Code
A single string that encodes identity, risk class and regulatory obligations of a medical device — filterable via SQL in any third-party system.
Why a dedicated code?
UDI-DI, EMDN or GMDN identify medical devices at the manufacturer level — but they do not help the operator who needs to know in their inventory: Which devices are radiation-relevant? Which need safety checks every 12 months? Which fall under critical infrastructure (KRITIS / NIS2)?
The Medicator Code answers exactly these questions. It is deliberately human-readable, greppable and SQL-filterable. A single column in the ERP, CMMS or maintenance system is enough to run all relevant queries without joins.
Structure
The code consists of two logical blocks, separated by hyphens:
- Stem (3 segments, stable):
DOMAIN–GROUP–MODEL - Compliance suffix (variable, derived from EUDAMED/MDR/local regulations): risk class, radiation protection, inspection interval, critical infrastructure, metrology control
Example: GE Discovery MI — Nuclear medicine / PET-CT / Discovery MI, Class IIb, radiation protection required, inspection every 24 months
Stem — the first three segments
| Segment | Meaning | Example |
|---|---|---|
| L1 — Domain | Medical speciality or environment | MED, LAB, HNO, DEN, NUK, RAD |
| L2 — Group | Functional device group within the domain | ATM, IMG, INF, KAR, AUD |
| L3 — Model | Concrete device model or subtype | LZB, CT, ULT, DEF, HG |
Compliance suffixes
| Suffix | Meaning | Legal basis |
|---|---|---|
I, IIA, IIB, III | MDR risk class | EU 2017/745 (MDR), Annex VIII |
R | Radiation protection (X-ray, CT, nuclear) | StrlSchV / EU BSS Directive 2013/59 |
S12, S24, S36 | Safety check interval in months | § 11 MPBetreibV / national operator rules |
M | Metrology control required | § 14 MPBetreibV |
K | Critical infrastructure (KRITIS / NIS2) | BSI-KritisV / NIS2 Directive |
REH-MOB-RST-I) has no safety check suffix, no radiation flag. A pacemaker
(MED-KAR-PAC-III-S12) on the other hand has class III and annual inspection.
Real-world examples
Practical use
1. Inventory filtering in ERP or CMMS
The code lives in a single column of the equipment master. Every filter is a LIKE or regex match.
-- All ventilators (domain Medical / group Respiration)
SELECT * FROM devices WHERE code LIKE 'MED-ATM-%';
-- All class IIb devices with radiation protection
SELECT * FROM devices WHERE code ~ '-IIB-.*R';
2. Safety inspection planning
Which devices must be inspected every 12 months? A single regex on the code is enough.
SELECT code, serial, last_inspection FROM devices
WHERE code ~ '-S12(-|$)'
AND last_inspection < NOW() - INTERVAL '11 months';
3. Critical infrastructure reporting
For regulators (BSI / NIS2): all critical-infrastructure devices in the hospital with their status.
SELECT code, count, location FROM devices_view
WHERE code ~ 'K(-|$)'
ORDER BY code;
4. Radiation protection audit
The radiation protection officer needs a list of all devices falling under the radiation protection regulation — regardless of the domain (radiology, dental, nuclear medicine, OR).
SELECT * FROM devices WHERE code ~ '-R(-|$)';
5. Metrology control scheduling
Metrology controls are only mandatory for certain devices (blood pressure, infusion pumps, scales). The code marks them directly.
SELECT * FROM devices WHERE code LIKE '%-M' OR code LIKE '%-M-%';
6. Replacement procurement
When a defective device is replaced by an equivalent one, the code stem stays the same. Replacement candidates can be compared directly.
-- All active devices of the same kind as the failed one
SELECT * FROM devices
WHERE code LIKE 'MED-ATM-LZB-%'
AND status = 'active';
Advantages over UDI/EMDN
| Aspect | UDI-DI | EMDN | Medicator Code |
|---|---|---|---|
| Unique product identification | Yes | Partially | At model level |
| Human-readable | No (14-digit number) | Partially | Yes |
| Encodes risk class | No | No | Yes |
| Encodes inspection interval | No | No | Yes |
| Encodes radiation protection | No | No | Yes |
| Encodes critical infrastructure | No | No | Yes |
| SQL/regex filterable | Exact match only | Hierarchical | Freely combinable |
Integration with existing systems
The code is a simple VARCHAR field and can be inserted into almost any third-party system:
- SAP: as a characteristic or free-text field on the equipment master (IE03)
- Odoo Maintenance: as a tag or custom field on
maintenance.equipment - CMMS / IWMS: as an asset type, maintenance plan key or classification
- Custom databases: as an indexed
VARCHAR(40)with B-tree for prefix search and GIN for regex