Electronic Record Routing System for Split Data Reconciliation
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Distributed systems for managing medical supply orders face complexities due to data compatibility and integrity issues, leading to data mismatches, duplication, and violations of data rules, as well as increased processing and resource demands from handling rejected and split orders.
Innovation Solution
An apparatus and method that receive electronic records from various systems, reformulate them to include additional entity information, and route them through a routing system that determines the appropriate systems for processing, thereby identifying and managing split records and reducing resource consumption.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Productivity
If electronic records are routed through multiple systems in a distributed system, then data processing capability and system functionality are improved, but data integrity and compatibility deteriorate due to format mismatches and rule violations
Solution Approach 1:
The patent implements an intermediary system that acts as a mediator between different systems in the distributed network. This intermediary receives electronic records, validates them against a centralized set of rules, and ensures compatibility before routing to destination systems. The intermediary resolves format mismatches and prevents rule violations while maintaining the benefits of multi-system processing.
Solution Approach 2:
The system dynamically changes data parameters (formats, structures, validation rules) based on the destination system's requirements. Before routing electronic records, the system transforms them to match the target system's expected format and validates them against that system's specific rules, ensuring compatibility without losing processing capability.
2Adaptability or versatility
If additional systems are integrated into the distributed system over time, then system versatility and functionality are improved, but data compatibility and integration complexity worsen
Solution Approach 1:
The patent creates a universal intermediary layer that handles all data routing and validation tasks centrally. This single multi-functional component can adapt to any new system integration without requiring changes to existing integration logic. The intermediary maintains a centralized rule set that can accommodate diverse system requirements, reducing integration complexity while preserving versatility.
Solution Approach 2:
The system segments the integration complexity by separating concerns: the intermediary handles all format conversion, validation, and routing logic, while individual systems maintain their own simple, specialized functions. This segmentation allows new systems to be added without increasing overall integration complexity, as the intermediary absorbs the adaptation burden.
3Manufacturing precision
If rejected orders are corrected and resubmitted through various systems, then order accuracy is improved, but processing resources and memory resources are consumed
Solution Approach 1:
The system performs preliminary validation and error detection at the point of order entry, before the order is routed through multiple systems. By identifying and correcting potential issues early, the system prevents the need for repeated corrections and resubmissions later in the process, significantly reducing processing resource consumption while maintaining high order accuracy.
Solution Approach 2:
The intermediary implements a feedback mechanism that tracks order status and validation results throughout the routing process. When errors are detected, the system provides targeted feedback to the originating system for correction, and automatically re-validates upon resubmission. This efficient feedback loop reduces unnecessary processing cycles and resource consumption compared to blind reprocessing.
4Reliability
If claims and orders are rejected and returned to various systems, then data rule compliance is improved, but computer processing resources and memory resources are burdened
Solution Approach 1:
The system performs preliminary validation against all relevant data rules before routing orders to destination systems. By checking compliance upfront, the intermediary prevents rejections and returns that would consume processing resources. Orders are only routed when they meet all validation criteria, ensuring rule compliance without burdening the system with repeated processing of non-compliant data.
Data Source
AI summary
A method, apparatus and computer program product provide identification of split electronic records, and temporarily preventing electronic records from being transmitted. Electronic records may be split by a separate system for transmission to various systems and are identified and reconciled. Certain electronic records may be temporarily prevented from being transmitted, to allow for review and/or modification prior to further processing. New electronic records that are unmatched to original electronic records, as well as rejected electronic records, can therefore be reduced, and the related systems are improved accordingly.