Master Data and Interface Governance — The Foundation of a Digital Quality System as the "Single Source of Truth"
1. Chaotic Master Data, Chaotic Quality System
Typical conversation:
- Quality Department: "The inspection plan version is incorrect."
- IT: "The BOM in ERP was just updated yesterday."
- Production: "The process route on MES is still from last week."
- Laboratory: "The LIMS sample name doesn't match the customer's terminology."
Four systems, four versions — when auditors ask, "Which is the effective version?" no one can answer within a minute. This is the daily cost of master data (Master Data) and interface governance failures.
In a digital quality system, master data serves as the foundation of the "single source of truth"; interfaces are the vessels for transmitting facts between systems. If the foundation is skewed or the vessels are blocked, QMS, MES, SPC, and supplier portals will become expensive silos.
2. Quality-Related Master Data: Scope and Owner
| Master Data Object | Typical Content | Suggested Owner | Role of Quality Department |
|---|---|---|---|
| Material / Part Number | Raw materials, semi-finished products, finished products, customer-supplied parts | Supply Chain / Engineering | Define quality attributes, inspection types |
| BOM | Parent-child relationships, quantities, alternative materials | Engineering / Manufacturing Engineering | ECN implementation, breakpoints |
| Process Route / Operation | Sequence of operations, work centers | Manufacturing Engineering | Control plan, special characteristics association |
| Inspection Plan / Specification | Items, sampling, limits | Quality | Primary maintenance |
| Customer / Supplier | Codes, qualifications, requirements | Sales / Procurement | Admission, special requirements |
| Equipment / Measuring Instruments | Numbers, calibration cycles, capabilities | Equipment / Metrology | MSA, inspection association |
| Personnel Authorization | Positions, operations, approval authorities | Quality + HR | Primary or joint responsibility |
Golden Rule: Each master data object has and only has one Data Owner; other departments consume (Consumer) rather than privately modify copies.
3. Master Data Governance: Five Gates
3.1 Creation Gate
- New part numbers, new operations, new inspection items — must have application forms + approval workflows
- Prohibit "using temporary codes in production first, then updating later"; if necessary, the validity of temporary codes ≤ 30 days and automatic alerts must be set.
3.2 Change Gate
- Linked with ECN: BOM/process/inspection plan changes must not bypass the change procedure
- Three elements of effective date + breakpoint: when it takes effect, how to handle WIP, when the old version is retired
3.3 Quality Gate
Example of a pre-release checklist:
- Have special characteristics been identified and associated with CP/FMEA?
- Is the inspection plan consistent with the latest customer specifications?
- Are there equivalent alternative materials that need to be updated simultaneously?
3.4 Distribution Gate
- Owner system writes once, downstream subscribes to receive — prohibit manual Excel transfers
- Distribution logs: who, when, which version received
3.5 Retirement Gate
- Obsolete part numbers, phased-out suppliers, old specifications — change status to Inactive, preventing new orders from referencing them
- Historical records are read-only retained to meet traceability and audit requirements
4. Interface Governance: From "Point-to-Point" to "Manageable and Auditable"
4.1 Interface Inventory
Each interface should at least record:
| Field | Example |
|---|---|
| Interface ID | IF-ERP-MES-001 |
| Source / Target | ERP → MES |
| Data Object | BOM, process route |
| Frequency | Real-time / hourly / batch |
| Trigger | ECN implementation, order release |
| Exception Handling | Retry, alert, manual queue |
| Business Owner | Manufacturing IT + Quality |
| Last Verification Date | CSV/OQ record |
4.2 Integration Mode Selection
| Mode | Applicable | Note |
|---|---|---|
| Master-Slave Replication | BOM, process one-time issuance | Version conflict detection |
| Event-Driven | ECN implementation, inspection completion | Message loss monitoring |
| Query API | QMS pulls ERP orders | Performance and permissions |
| File Batch Processing | Legacy systems | Most prone to errors, plan for retirement |
Quality Focus: Inspection results, release status, deviation status — prioritize event-driven + audit trail to avoid overnight batch processing leading to "released yesterday, system shows today."
4.3 Exception and Reconciliation
- Dead Letter Queue: Failed messages must not be silently lost
- Daily Reconciliation: ERP released orders vs MES received; QMS inspected vs ERP inventory status
- Difference SLA: Must be claimed and handled within 24 hours
5. Version and Consistency: The Three Most Common Questions from Auditors
"Please show the BOM version in effect for this batch during production." → There should be a point-in-time version (As-built BOM) or production snapshot, not just the "current latest version"
"Which version of the specification was the inspection based on?" → Inspection records must reference the specification version number, and it must be consistent with the version provided to the customer
"Are the systems and the shop floor consistent?" → Sampling comparison: MES process parameters vs on-site PLC/paper; QMS sampling vs actual samples
As-built / As-tested records are the crown jewels of master data governance — many disputes are not about "whether it is correct now," but "whether it was correct at the time."
6. Organization and Process: Who Meets, What to Discuss
It is recommended that the Master Data Governance Committee (MDM Steering) meet once a month for 30-60 minutes:
- Approval of new master data object types
- Review of major interface changes
- Clearing open issues (Open Issues)
- KPI review: interface failure rate, reconciliation differences, number of temporary codes
The Quality Department should permanently attend — this is not just an "IT matter."
7. Intersections with CSV, Security, and Permissions
- Computerized System Validation (CSV): Interface changes = change control, requiring impact assessment and re-validation
- Permissions: Who can modify the BOM in ERP? Who can change inspection limits in QMS? Consistent with job authorization matrix
- Audit Trail: Master data changes must be traceable (old value, new value, person, time, reason)
8. Common Failure Modes
| Phenomenon | Root Cause | Countermeasure |
|---|---|---|
| Dual BOM: Excel vs ERP | No single Owner | Disable unauthorized copies, Excel read-only export |
| Occasional Interface Message Loss | No monitoring | Reconciliation + alerts + runbook |
| Inspection Plans Always Lag Behind | ECN and QMS not linked | ECN implementation automatically triggers inspection plan revision tasks |
| Three Different Ways to Write Customer Names | Customer master data not unified | Golden record + alias table |
| No One Understands Interfaces After Implementation Consultant Leaves | Lack of documentation | Interface inventory + architecture diagrams in the knowledge base |
9. 90-Day Improvement Path
| Week | Action |
|---|---|
| 1-2 | Inventory quality-related master data objects, designate Owners, publish RACI |
| 3-4 | Establish interface inventory v1.0; select one critical interface (e.g., BOM→MES) for end-to-end mapping |
| 5-8 | Initiate daily reconciliation (at least orders + inspection status); close the top 3 root causes of differences |
| 9-12 | Improve ECN and inspection plan linkage; conduct a "point-in-time version" traceability drill |
10. KPI Suggestions
- Percentage of NCRs / deviations related to master data (trend should decrease)
- Number of interface failures and average recovery time
- Number and age of open items in reconciliation differences
- Number of temporary part numbers / temporary processes
- Number of "version inconsistency" observations during audits
11. Implementation Toolkit (Ready to Use)
It is recommended to maintain the following templates in the QMS or IT knowledge base to reduce cross-departmental collaboration costs:
- Master Data RACI Matrix: Fill in Owner/Approver/Consumer for materials, BOM, processes, inspection plans, customers, and suppliers
- Master Data Change Request Form: Includes ECN number, breakpoint explanation, WIP handling, and downstream system confirmation fields
- Interface Runbook: One page per critical interface — failure alert contact, rerun steps, temporary manual business solutions (emergency only)
- Monthly Reconciliation Report Template: Categorize differences (master data errors / interface delays / business non-compliance)
- New System Launch Checklist: Before launch, complete "master data migration verification + interface parallel reconciliation ≥ 1 full cycle"
The Quality Department can reference these templates in supplier admission, NPI stage gates, internal audit plans to transform master data governance from an "IT project" into a routine discipline across the entire value chain.
Master data and interface governance may sound like IT topics, but they are fundamentally about whether the quality evidence chain is credible. Strengthening the foundation ensures that digital quality transformation (see knowledge number 12.3.2) does not result in "two sets of evidence after system implementation."
Simplified Inspection with a Single Source of Truth: For the same part number, are the name, version, and critical limits aligned to a single version number at any point in time across ERP, MES, QMS, inspection reports, and packaging labels?
Knowledge Number: 12.3.2
Version: v20260630
Author: Quality Excellence Think Tank The Quality Excellence Think Tank is dedicated to providing systematic professional knowledge, methodologies, and practical tools for quality management practitioners, helping companies continuously improve their quality capabilities.