Three ways the record answers a question

Why three layers rather than one report builder

The three audiences for clinical data want different artefacts. A clinic director wants a KPI on screen in five seconds, a patient wants a signed letterhead document, and a quality lead preparing a registry return wants the underlying rows in a spreadsheet. FertiliCore serves each with a purpose-built layer instead of forcing all three through one generic report builder. The dashboards are purely descriptive analytics with no data entry, refreshed on demand, and the rates they present map to the measures a clinic uses for SART and ESHRE-style benchmarking and for statutory returns.

Nine dashboards, one per stage of the pathway

Each dashboard is a read-only screen that pulls its data when opened, renders a row of KPI cards followed by distribution and monthly-trend charts, and offers a manual refresh. Monthly trends cover a rolling window of recent months. Coded values such as cycle type, result and anaesthesia are resolved to readable labels, and unspecified values are shown as unspecified rather than silently dropped. Every chart and table renders an explicit empty state when the underlying data is absent, so a sparse dataset reads as sparse rather than as zero.

• Clinic Statistics: patients, cycles, OPUs, embryos, frozen embryos, transfers, with cycles by type, by month and by status
• OPU Statistics: procedure and patient counts, completions and cancellations, oocytes retrieved and mature, average per OPU, maturity rate, with breakdowns by status, month, sperm source and anaesthesia
• Embryology Statistics: sessions, oocytes, mature and fertilised counts, fertilisation rate, total, frozen and transferred embryos, with insemination method, monthly volume, disposition and final assessment day
• Transfer Statistics: transfers, patients, embryos transferred, average embryos per transfer, average endometrial thickness, cancellations, with distributions by embryo count, month, transfer day and difficulty
• Pregnancy & Birth Outcome Statistics: monitored, clinical and ongoing pregnancies, outcomes, live births, stillbirths, losses, neonates, plus clinical pregnancy, live-birth and multiple-pregnancy rates
• PGT Statistics: tests, patients, embryos tested, resulted tests, normal, abnormal and no-diagnosis counts with normal and abnormal rates, by result, month, PGT type and sample type
• Andrology Statistics: analyses, patients, measured parameters and abnormal parameters, with a per-parameter table carrying unit, counts, average and the WHO 2021 reference range
• Cycle Monitoring Statistics: monitoring records, cycles and patients monitored, hormone and ultrasound coverage, average oestradiol, endometrium and follicle count
• Cryo Statistics: oocyte and sperm freeze sessions, straws frozen, thaw sessions, oocyte and embryo survival rates, active tanks and tank occupancy

Rates computed, never asserted

Every percentage on these screens is derived from the clinic's own records at the moment of the request. Maturity rate is mature oocytes over oocytes retrieved. Fertilisation rate comes from the embryology session data. Clinical pregnancy, live-birth and multiple-pregnancy rates come from the pregnancy and neonatal records described in the pregnancy module. Because they are computed rather than entered, they cannot drift from the underlying record, and they change as the record is completed.

Thirty-three letterhead documents, rendered on demand

Clinical documents are authored as HTML and CSS templates and rendered to PDF by a standalone worker built on WeasyPrint, kept deliberately separate from the clinical API so that document rendering scales independently and the typesetting toolchain stays out of the application services. The clinical API records the request and asks the worker to render synchronously over a message queue; the worker queries the live clinical tables, builds the document, and replies with the bytes. Every document carries the clinic letterhead, a patient and header block, and a signature and footer block.

• Discharge summaries for the IVF file and the full file overview
• Embryology discharge summaries for fresh cycles and for frozen-embryo transfer
• Andrology documents: semen analysis with the WHO 2021 parameter table, IMSI and standalone MSOME
• PGT documents: per-embryo results, array-CGH copy-number drill-down, monogenic and confirmation reports, HLA typing
• Cytogenetic and molecular documents: sperm FISH and aneuploidy, QF-PCR, DNA profile, Y-microdeletion, fragile X, thrombophilia panel
• Operative notes and karyotype and counselling documents, which render today with reduced detail pending schema work

Nothing written to disk

The PDF worker holds no storage. It renders the document into memory, replies with the bytes, and the API streams them straight to the user without writing a file. There is no report archive to secure, no orphaned PDF sitting in a volume containing a named patient's genetic result, and no retention policy to enforce over generated documents. Documents are always regenerated from the current record, which also means a reprint reflects any correction made since the last print rather than reproducing a stale copy. A record of the request itself is kept; the rendered document is not.

Raw data out, without losing the old reports

The Data Export screen downloads raw clinical datasets as Excel workbooks for ad-hoc and offline analysis. These exports are not new inventions: they re-implement long-standing stored-procedure extracts over the current schema, so a centre migrating from a legacy system keeps the reports its staff already trust and its historical reporting continuity survives the migration. Forty-seven legacy procedures were analysed and ported in that work, and twelve are surfaced on the export screen today. Five are whole-clinic dumps that take no parameters; seven are scoped to a patient file or a cycle, entered inline.

• Clinic Raw Data Export: the consolidated clinic-wide clinical extract
• Embryology Raw Data Export: the laboratory dataset
• Transfer & Pregnancy Data: embryo-transfer cycles with their pregnancy data
• Cryopreservation reporting dataset: the structure required by the national health authority's freezing return, one example of statutory reporting
• OPU Procedures List: the oocyte pick-up procedure register
• Per-patient: cycle details, non-IUI cycle count, previous IVF attempts, infertility history, andrology evaluation
• Per-cycle: monitoring hormone values and a monitoring summary