Canonical Data Model (Parsed Data Block)

A Canonical Data Model defines “What is Canon”, and lays out a structure of how all data is represented and perceived.  Our Canonical Model, known as the “Parsed Data Block” is a well-defined XML based structure, that allows us to map any known data point for a given patient message (i.e. CCD/CDA, HL7, FHIR, CSV) to a specific spot in the Canonical Model. 

For instance, when looking at a message with our Parsed Data Block, the name of a patient will always be found at the XML Path: /Document/Patient/Name and having possible attributes like @first,@last, @full and so on, regardless of what type of message was given.  Paths like this exist for each and every possible piece of patient data.

After years of working with the various healthcare standards, we have mapped most every data source type into and back out of our Canonical Model. We have packaged these libraries and several tools into our Alchemy system, “turning your healthcare data into gold.”

This allows us to immediately convert ANY source data from its original state INTO our model, perform any work we want on it, and send it back out either as the original format, or even as a different one. 

The beauty of this design is that once it is in the Canonical Model, any developer that understands basic XML can then work with the data, and either build triggers, modifiers, or analysis tools. 

SQL Data Model

The SQL Data Model is a third-normal-form based model, with nearly all tables using large integer Identity based keys, providing performance and referential integrity.  The Data Model began with our Clinical Data Repository (CDR-Web), focusing on the primary portions of a patient record: Demographics, Procedures, Diagnoses, Lab Results and so on.  In CDR-Web’s product evolution, this expanded to include Order Entry, Medications, Pharmacy Order Entry, and Scanned Documents. 

During our partnership with HFHS for EXR/CPNG, our data model was chosen for the basis of the new product, and was enhanced to support Teams, Work Queues, Clinical Documentation, Pathways/Protocols, and much more.  At one point, out of curiosity, one of the HFHS data model team printed the entire logical model. It took up his entire wall.

We continued to expand EXR to be certified as a complete Inpatient and Outpatient EHR, and the Data Model was further enhanced to support some of the feature points, and encryption methods required for certification.

When we created Arcana, we enhanced the Data Model for all of our external sourced data tables and expanded them to fully accept any sourced data. This allows us to accept data from any combination of source systems, and be properly aggregated, preserving the original while at the same time being able to easily map it to any known Point-of-Truth (i.e. CPT, ICD and similar codesets).  With it, Arcana is able to assess patients realtime and have reaction situations for any number of use cases, including aiding in insurance reporting of HEDIS matching patients and their related data points.

Awards and Accolades

Metro Detroit’s 101 Best and Brightest Companies to Work For
Issued by 101 Best and Brightest Companies to Work For
Jan 2010

For a second year, RelWare was honored as an organization that displays a commitment to excellence in their human resource practices and employee enrichment.For a second year, RelWare was honored as an organization that displays a commitment to excellence in their human resource practices and employee enrichment.

Inc. 5,000 Fastest Growing Companies in America
Issued by Inc. Magazine
Jan 2009

RelWare was acknowledged for a third year as one of America’s 5,000 Fastest Growing Companies.RelWare was acknowledged for a third year as one of America’s 5,000 Fastest Growing Companies.

Metro Detroit’s 101 Best and Brightest Companies to Work For
Issued by 101 Best and Brightest Companies to Work For
Jan 2009

RelWare was honored as an organization that displays a commitment to excellence in their human resource practices and employee enrichment.RelWare was honored as an organization that displays a commitment to excellence in their human resource practices and employee enrichment.

Inc. 5,000 Fastest Growing Companies in America
Issued by Inc. Magazine
Jan 2008

For a second year, RelWare was acknowledged as one of the Fastest Growing Companies in America.

Inc. 5,000 Fastest Growing Companies in America
Issued by Inc. Magazine
Jan 2007

RelWare was selected as one of the Fastest Growing Companies in America by Inc. Magazine.RelWare was selected as one of the Fastest Growing Companies in America by Inc. Magazine.

Michigan Top 50 Companies to Watch
Issued by Michigan Celebrates Small Business
Jan 2007

Michigan 50 Companies to Watch is an awards program that discovers and celebrates the second-stage companies that make an impact in their markets, in their communities and in the state. They award companies known for their marketplace performance, innovation, philanthropy and corporate culture.

PhysBeeMD ADT Notification System (PAN)

The PhysBeeMD ADT Notification (PAN) application supports the State-wide ADT Notification Service, as well as any entity which has access to one or more hospital ADT feeds. The PAN converts ADT events and data into useful, readable clinical information so health care professionals can make decisions with a more complete view of their patients.

SSA E-Disability CCD Exchange 

In a joint partnership with the South East Michigan Health Information Exchange (SEMHIE), we brought our expertise on the CCD format to assist in being the first in the country to complete the Social Security Administration’s (SSA) E-Disability CCD Exchange. In this project, we and our partners, worked with local hospitals, including Henry Ford Health Systems and the Beaumont Health System, to obtain a CCD Summary of Care document from each for a given patient, and then generate a single aggregated CCD to be submitted to the SSA. This endeavor was proposed to reduce the overall approval process from an average of over 450 days of obtaining and reviewing paper charts and billing statements, to approximately 6 hours of requesting and reviewing a single CCD.

Read more about it here.

X2Shell

Code named ”BRANDON” (Batch Runner and Network Diagnositics tool), this is a .Net application engine that allows for building complex command-line executables using simple XML configuration files and leveraging the multiple extensions available, including HTTP, SQL, and simple File based operations, as well as leveraging X2TL and the overall X2A2 architecture.

X2TL

An XML-safe templating language created for manipulating blocks of XML using string-based templates.

X2TL is an XML-safe “mustache” templating language, written in C# .Net. It was written as a software development tool, now being offered open-source. This library has been tested and used in several enterprise production applications.

Made open source by the author, August 2016 under the MIT License. Now available at: https://github.com/openAirWare/X2TL and https://bitbucket.org/openAirWare/x2tl

PhysBee

Our take on a Universal Health Record (UHR), or more popularly as a Patient Health Record (PHR).

Based on 20 year fortified CDR-Web base data model

Facebook like user-interface for ease-of-access and entry