Allegan County Granicus #1054-26

Medical Record Database Extraction from NetSmart Insight for Allegan County

Allegan County Health Department is seeking a contractor for Medical Record Database Extraction Services to migrate legacy health records. - Government Buyer: - Allegan County Health Department (local government agency) - OEMs and Vendors: - NetSmart (OEM of the legacy Insight solution) - Patagonia Health (current EHR platform) - Upland (Filebound Document Management Solution) - Products/Services Requested: - Extraction of approximately 20,000 client records from the unsupported NetSmart Insight SQL database - Assembly of each client record into a logically structured PDF report (one per client, using client ID as filename) - Creation of a CSV index file with key client fields - Secure, encrypted delivery of all files for import into Upland Filebound - Data validation, quality assurance, and compliance with privacy, security, and confidentiality requirements - Destruction of all client data after project completion - Unique/Notable Requirements: - Legacy system is unsupported and runs on an outdated operating system - Strict requirements for data validation, privacy, and secure data transfer - Contractor must ensure all data is destroyed after delivery - Project is focused on one-time extraction and secure delivery, not ongoing support or subscription

Description

Allegan County is seeking services to extract medical record data from an older SQL database used by its Health Department. The project involves extracting approximately 20,000 client records from the Insight solution's SQL database, assembling them into complete, logically structured PDF reports, and exporting a CSV client index. The County will import these into its document management system for long-term retention and infrequent access. The contractor must ensure data validation, security, and confidentiality throughout the process.

View original listing