Using Pre-registration QR Codes for Nucleic Acid Testing to Enhance Efficiency During the Beijing Winter Olympics

Original: https://cli.im/article/detail/1838

Basic Information

Company Name: Weizhifeng (Beijing) Network Technology Co., Ltd.
A nucleic acid testing institution currently responsible for the daily nucleic acid testing of residents in Chaoyang District, Beijing. Also undertook part of the nucleic acid testing work for the 2022 Winter Olympics.

System Setup Period: 4 days

Person in Charge: Manager Wang

Position: Project Manager (Non-technical role and background)

Project Background

Before the opening of the Winter Olympics, Chaoyang District in Beijing, as the main venue for this Winter Olympics, required a large amount of nucleic acid testing for residents. The testing was conducted using a 10-in-1 mixed sample method, requiring the recording of one reagent number and the corresponding information of the 10 tested citizens. This was to ensure that if a positive result was detected, the citizen information could be traced through the reagent number.

To achieve contactless testing and improve registration efficiency, residents were required to scan a pre-registration QR code in advance to register their detailed personal information. After registration, they received a pre-registration number and a corresponding QR code, which they saved.

At the nucleic acid testing site, residents presented their pre-registration QR code to complete the test. Staff needed to manually record the nucleic acid reagent number and the 10 pre-registration numbers (using the 10-in-1 mixed sample method). Subsequently, staff exported the pre-registration information from the system and manually associated it with the recorded reagent numbers to compile a testing information table for each individual. If a positive nucleic acid result was found, the corresponding information of the 10 individuals could be retrieved.

Problems Encountered

1. Insufficient Efficiency

On-site staff had to manually record reagent numbers and pre-registration numbers, and also export pre-registration data daily and associate it manually. This slowed down on-site operations, causing large crowds to wait in long queues in the cold.

2. Data Not Timely

Data had to be periodically exported from the backend and processed offline locally, making real-time retrieval impossible.

Implementation Method

Specific Implementation Process

1. Create a Nucleic Acid Pre-registration QR Code and Enable Submission Number Function

2. Residents Save the Pre-registration Number QR Code After Successful Registration

Residents save the pre-registration number QR code and present it at the testing site for staff to scan and register.

3. Create a Reagent Registration QR Code

Used to register the reagent number and the 10 pre-registration numbers. Both numbers are input by scanning QR codes to improve speed and accuracy.

4. Enable API Interface to Obtain Form Data Table

Find the "Data API" under "Advanced Features" in the CaoLiao platform.

5. Process Data and Display Collection Information in Real Time

Merge the nucleic acid pre-registration form and the reagent registration form to generate a complete resident nucleic acid testing information table, including resident information and nucleic acid numbers. The entire process is automated.

Two Implementation Methods:

• Self-developed Data Viewing Platform

A technical team was engaged to create a data display and retrieval page, which took 2 days.

• BI Tool for Creating Data Dashboards

For users without development capabilities, using a BI tool is recommended. Connect the data table in the BI tool, create data, and generate reports. This process takes 1 day but requires basic SQL skills. Technical support for this can be provided by CaoLiao.

On-site Photos

Template Sharing

Two registration QR codes were used: one for pre-registration and another for reagent registration.

Resident Information Registration: https://cli.im/share/tYgBVGV

Reagent Registration: https://cli.im/share/QhVaIeB