Try UiPath Free

Back Industry: Public Sector

Automating collation of COVID-19 patient data for State Government

COVID-19 Challenge

As the testing was ramped up, so was the collation of patient data

State authorities have been carrying out vigorous COVID-19 testing of patients throughout the state on a large scale. The ground staff and healthcare workers collect data of patients being tested as well as past test samples. This patient data goes directly into a centralized repository via the National Authority portal. With the State Government planning to ramp up the COVID-19 testing, it became a large task of collating the State’s data from the National Authority website and then adding to the State Governments database. As the number of patient testing increased beyond 2000 per day, the manual task of collating the daily patient data after downloading it as an excel sheet from the National Authority portal became too time-consuming.

The State Authorities team wanted to have a quick process automation in place where the COVID-19 patient testing data would be downloaded from the National Authority portal and then collated on the State Government  portal to the database almost real-time. The data collated in the State Government's database would then help the State to make quick real-time decisions and dynamically change the course of action depending on the patient's test results.

Solution

The tested patients’ data could be downloaded from the National Authority website in the form of an excel sheet. The State Authority had created an online web form and an API to fill in the patient data, which included new patient data and old patient data to be updated. All the latest patient data needed to be collated multiple times in the day. The amount of patient data was proportional to the testing volume in the state.

the team at Auxiliobits Technologies Pvt Ltd quickly created this process automation through which the UiPath software robot downloads the patient data from the National Authority portal, then picks up the records of tested patients and sends those patient data records to the respective State Government portal through an API. This helps the State Authorities deliver updated data and to be ready for actionable insights.