Chapter 290: Audit Trail

The time in the lower right corner of the screen jumped to 10:14. In the terminal window, the clustering script’s progress bar was stuck at 37%. Lin Chen stared at the warning line: [WARN] Ambiguous match: 'Compound Licorice Tablets' vs 'Licorice Tablets'. He rubbed the space between his brows, his fingertips picking up the fine dust that had settled in the gaps of the keyboard. The medication records from the old HIS were like a ledger soaked in water: the handwriting blurred outward, dosage units jumbled together as “bottle/box/ampoule/bag,” and manufacturer abbreviations came in every strange form imaginable. Before 2005, in the old hospital campus, nurses and pharmacy staff had entered everything by hand. Typos, omissions, and homophone substitutions were routine. The system did not recognize “approximately.” It recognized only exact characters.

He could not rely on a ready-made national pharmacopoeia dictionary. It was too clean; it had no room for these historical records burnished by time. He created a temporary mapping table and split generic names, dosage forms, and specifications into three separate fields. Regular expressions handled fuzzy matching, with the threshold set at 0.85. Anything below the threshold went into the manual review queue. Anything above it was labeled automatically. He pressed Enter, and the script continued to scroll. The log file swelled at more than a dozen entries per second, while the terminal fan gave off a low hum.

Su Man pushed the door open and came in, setting down a cup of warm water. Beads of condensation slid down the cup and dripped onto the desk, spreading into a small dark ring. “The Medical Affairs Office just sent an email,” she said, keeping her voice level. “The inspection team has moved up the schedule. They’ll arrive at the Information Department server room at one-thirty. Section Chief Liu wants you to package the desensitization logs and mapping table, and create a separate read-only directory. The audit company is bringing a traceability tool. They’ll run a replay on-site.”

Lin Chen nodded without stopping. One-thirty. Half an hour earlier than planned. He quickly estimated the remaining data volume: about nine hundred entries. At the current processing speed, plus the twenty exceptions requiring manual review, they could just make it. But the risk was that if the clustering algorithm grouped two drugs with different pharmacological effects into the same category, clinical medication traceability would have a hole in it. Classified protection audits did not accept “logically self-consistent.” They accepted only “traceable line by line.”

He pulled out his error notebook and turned to a blank page. His pen moved quickly: 10:20 Adjust threshold to 0.88. Increase dosage-form weighting. Prioritize antibiotics and cardiovascular drugs in review queue. Note: Chinese patent medicines to be reverse-checked by pinyin initials; manual intervention required. He closed the notebook and returned his fingers to the keyboard. Modify parameters, reload the script, clear the cache. The progress bar restarted from 37%. This time it moved more steadily, but more slowly.

11:05. The progress bar broke past 60%. Numbness in his left knee began to spread upward, and the muscles in his calf twitched faintly beyond his control. He stood up and paced slowly with one hand on the edge of the desk. The office air conditioner was set very low; it blew against the sweat-damp nape of his neck and raised a fine shiver. He walked to the window and opened it a crack. Downstairs, the ginkgo leaves had already turned yellow. When the wind passed, they fell with a dry rustle. In the parking lot, two black government cars were slowly pulling in, their license plates bright in the sun. The inspection team’s advance vehicles.

“We’re out of coffee.” Su Man’s voice came from behind him. She was sorting the printed log inventory, a thick stack of paper held together with binder clips. “Section Chief Liu says the inspection team will focus on the data traceability chain. Our offline script logs have to correspond to every original record’s modification timestamp and operator. They don’t care how you cleaned it. They only care whether, after cleaning, you can trace it back.”

“The timestamps are generated automatically.” Lin Chen returned to his seat, trying to keep his left foot suspended as he sat down to reduce the load on his knee. “For operator, write ‘system automatic mapping.’ What the audit wants is an audit trail, not a culprit. As long as the logic closes the loop and can be reproduced, it’s compliant.”

Su Man looked at him and did not argue. She knew Lin Chen’s bottom line: no gray areas, no falsified data. Every cleaning rule was written in the open; every fallback logic path was recorded. It was a clumsy kind of work, but in medical data migration, where the tolerance for error was zero, clumsy work was often the hardest moat. Capital liked to talk about “one-click cleaning” and “direct cloud connection,” but inside a hospital’s old systems were lives and disputes.

12:40. The progress bar stopped at 98%. The final thirty records were stuck in the “Chinese patent medicine” category. In the old system, the field names for these medicines used pinyin initials: for example, “XYKJ” corresponded to Xuefu Zhuyu Capsules. But the same manufacturer wrote batch numbers differently in different years. Some included “National Drug Approval Number”; some had only internal serial numbers. The script could not align them automatically.

Lin Chen took a deep breath. He opened the raw data preview and checked them one by one. Xuefu Zhuyu Capsules, Compound Danshen Dripping Pills, Naoxintong Capsules... Relying on what he remembered from the Chinese Materia Medica textbooks he had leafed through in the university library, and cross-checking dosage forms and specifications, he built temporary mappings line by line. His fingers struck the keyboard faster and faster, like a silent sprint. The cold light of the screen reflected the dark circles beneath his eyes, and his breathing gradually shallowed. 13:15. The final mapping was complete. He pressed Enter.

[INFO] Mapping complete. 1398/1400 records processed. 2 queued for manual review. Confidence: 99.86%. False positive interception rate: 100%.

He exported the logs, generated the read-only directory, and compressed the package. Filename: HIS_Legacy_Mapping_2005_Audit_Log_v3.zip. He uploaded it to the designated intranet path. The time showed 13:28. Two minutes remained before the inspection team arrived.

He leaned back in his chair and closed his eyes. The hum of the air conditioner suddenly became clear in his ears. His left foot had gone completely numb, like a block of wood that no longer belonged to his body. But he did not move. He waited.

13:30. Footsteps came from the corridor. Leather soles struck the terrazzo floor in an orderly rhythm. Section Chief Liu’s voice sounded outside the door: “Engineer Lin? The inspection team is here.”

Lin Chen opened his eyes and stood up. When his left foot touched the floor, he staggered slightly, but quickly steadied himself. He picked up the error notebook from the desk, slipped it into the drawer, straightened the hem of his shirt, and pushed the door open.

The conference room was already full. White coats, dark suits, audit company badges. The air carried the mixed smell of disinfectant and old paper. Lin Chen did not take the main seat. He stood beside the projection screen and handed the USB drive to Section Chief Liu. The screen lit up, and the mapping table unfolded page by page. The audit expert put on reading glasses and checked each line: timestamps, operation logic, fallback rules, exception queue handling records. Page after page.

“For this entry, ‘Amoxicillin 0.25g,’ the original record says ‘Amo 0.25.’ How did you determine it was the same specification?” the expert asked, pointing at the screen.

“By combining the dosage-form field, ‘capsule,’ with manufacturer code ‘0412,’” Lin Chen said in a low, steady voice. “The old system’s entry habit was to omit the suffix of the generic name. We cross-validated it against historical prescription frequency. Match score, 0.91. It has been added to the manual review whitelist and does not block the main process.”

The expert nodded and made a mark in his notebook. “Clear logic, complete audit trail. For the compliance explanation of the custom mapping pool, add an internal stamped filing document and submit it next week.” He paused, then looked toward Section Chief Liu. “The underlying architecture for the historical data migration is more solid than expected. Zhineng’s direct cloud connection plan really isn’t suitable for the old campus. Data isn’t running water. It’s an account book. Every entry has to be reconciled one by one.”

Section Chief Liu let out a breath and turned to look at Lin Chen, his gaze carrying a new weight of respect.

Lin Chen gave a slight nod and said nothing. He retreated to the Information Department office and closed the door. Leaning against the door panel, he slowly slid into the chair. Only then did the cold sweat belatedly soak through his undershirt. He took out his phone, and the screen lit up. Three unread messages.

The first was from Su Man: “The clinical director signed off. The pilot passed. Next step is hospital-wide rollout.” The second was an automated reminder from the finance system: “This month’s server rental fee has been deducted. Account balance: 12,400.00 yuan.” The third was from Zhao Qiming. Only one short line: “Three o’clock this afternoon, usual place. Let’s talk about the supplemental agreement for the Series A valuation adjustment mechanism. Zhineng is out, but capital won’t wait.”

Lin Chen stared at the last message. The light from the screen reflected in his eyes without a ripple. He locked the phone, opened the drawer, and turned his error notebook to a new page. He wrote: 14:15 Pilot passed. Remaining issue: hospital-wide rollout requires expanded computing capacity; budget gap approximately 800,000 yuan. Zhao Qiming requested meeting.

The pen tip paused. He added one final sentence: Note: Do not sign valuation adjustment. Find alternative plan.

Outside the window, the wind had stopped. A ginkgo leaf lay on the sill, its edges already curled. Lin Chen closed the notebook and tapped the desktop lightly with his finger. The next hard battle had only just begun.