Electronic Health Records (EHR) is to store the data (medical Records, electrocardiogram, medical images, etc.) generated by patients in all medical institutions in an Electronic way. Through sharing among different medical institutions, EHR enables patients to face different doctors and live in different hospitals and clinics. Good medical care is even available in different countries.

Development status of EHR in China

In China, EHR is still in a period of rapid development. In 2012, 35 cities, 2,406 community health service centers and 9,726 community health service stations had set up health records for community residents. In 2017, 76.4 percent of Chinese residents had electronic health records.

Due to the nature of EHR data sharing, future medical information systems must be able to share and receive EHR from other providers outside the system. Therefore, the biggest challenge for healthcare organizations is how to connect technology and work collaboratively through a strong data-sharing infrastructure.

In order to ensure the accuracy of EHR data and security, and allow them to interact between different health care providers, needed a SaaS, chain blocks, or API components to build on a group of emerging technologies such as a variety of public and private data collection system, complete the health survey, administrative registration, billing records and electronic medical records and other data collection work.

EHR solutions based on cloud and API components

Today, more and more healthcare organizations are considering migrating their healthcare IT solutions to cloud-based software-as-a-Service (SaaS) models, and some have even started deploying SaaS applications in hospitals for EMR (electronic Medical Records), EHR, PACS, telemedicine, and non-clinical systems applications. Such as RCM, billing and supply chain.

If you are considering moving from standalone software to cloud-based SaaS applications, API components can play a key role in this situation, not only simplifying the migration effort, but also improving the existing workflow of the IT team. For years, the healthcare industry has been used to Excel (.xlsx) files for information management, such as scheduling doctors, cataloging contacts, and configuring medications and prescriptions. While Excel is a great tool, it helps users filter, find, and analyze data faster. However, Excel’s degree of customization has been its biggest drawback, limited by the application itself. Using Excel to manage data inevitably affects workflow, creates security risks for shared files, and document versioning issues.

Based on this feature, the first consideration when migrating to a cloud-based SaaS healthcare application is how to maintain the Excel like interface and features that users are accustomed to, such as:

  • Excel – like menu bar and tool panel
  • Calculation formulas and functions consistent with Excel logic
  • Secondary modification operation after data is exported to Excel file
  • Excel file data can be directly imported without manual input

The above four points can be completed with the help of a table control.

Optimize SaaS solutions for the healthcare industry with SpreadJS

SpreadJS is a pure front end spreadsheet control based on HTML5, which is compatible with more than 450 Excel formulas and features “high performance, cross-platform and highly Compatible with Excel”. It can be directly used in various front-end development frameworks and back-end servers.

SpreadJS is similar to Excel in terms of interface and functions, and offers a more open API interface that enables efficient report template design, online editing and data binding across multiple platforms and frameworks. In this way, the enterprise information system can provide support for application scenarios such as collaborative editing of forms and documents, data filling and Excel report design, and greatly reduce enterprise r&d costs and project delivery risks.

With the help of health data kanban developed by SpreadJS

Here are the strengths of SpreadJS when developing healthcare SaaS applications:

1. User experience and accessibility advantages

Embed SpreadJS table controls in SaaS healthcare applications to perfectly reproduce Excel’s UI. In addition to continuing to use the Excel like client interface that users are most familiar with, the application can also use charts, mini graphs, shapes and other data visualization interaction. Meanwhile, with SpreadJS’s worksheet protection and cell locking capabilities, developers can more easily control end-user actions such as editing.

In terms of accessibility, SpreadJS offers support for assistive technologies and is independent of the following browsers and platforms: Windows, Linux, Mac, Android and iOS.

2. Advantages of document versioning

Document versioning keeps document versions organized and consistent to ensure accurate data.

SpreadJS provides apis that can be used to help solve document versioning problems. Embedding SpreadJS into the application not only provides users with a way to interact directly with the workbook, but also provides event connections that trigger the workbook to save any changes, which can then be stored in a back-end database once acquired. Once the changed/updated data is sent to your back end, when another user accesses the data, they can see the latest information.

The technical advantages of SpreadJS in document versioning scenarios

3. Data security advantages

Security is Paramount when handling personal and medical information!

According to the Verizon Business 2020 Data breach Investigation report, about 90% of data breaches are caused by office files (such as Excel, etc.) that contain malicious software attached to emails. For the healthcare industry, as the healthcare industry opens more doors to patients and uses more and more new technological ways to interact with patients, web application attacks will become more common and data interaction using Excel will become more dangerous.

Since SpreadJS is a pure front-end control, it does not save or record any information displayed in the UI. As a result, SpreadJS eliminates the sending and receiving of Excel files from external emails and minimizes the risk of malware entering your company’s systems. SpreadJS also has a built-in data security interface that allows users to import and export Password-protected and encrypted Excel files.

conclusion

Through the introduction of this paper, we have a general understanding of the development status of EHR in China, and can see that most healthcare organizations are completing the reform of healthcare system informatization through SaaS and cloud service platform. In this process of reform, it is very important to keep the original usage habits and data interaction mode of users.

With SpreadJS, the healthcare system’S IT team can easily optimize SaaS solutions and provide users with a highly Excel-like experience with more personalized options such as version control, online submission, and multidimensional perspective analytics. In addition to the medical industry, grape City’s various development controls and software development technologies also gradually shine in SaaS products in other fields, such as NetEase Linxi documents in the field of online office and Yonyou Chang Jietong T+Cloud in the field of financial statements.