Utility description: Longitudinal Result Review Builder
Longitudinal Result Review Builder — Integrated Patient Longitudinal Review Generation
ℹ️ Utility performs automatic aggregation and synthesis of heterogeneous clinical data into a timeline according to ESMO, ASCO, CAP recommendations and CDISC ADaM standards:
EVENT TYPES: Molecular Tests (NGS/cfDNA/ddPCR with VAF, interpretation, new variants), Imaging Studies (CT/MRI/PET with RECIST/RANO), Lab Markers (CEA, CA-125, PSA), Therapy Changes (start/switch/discontinuation), Clinical Assessments (ECOG, toxicity, surgery).
AUTOMATED ANALYSIS: Timeline construction, event counting by type, new variant detection, chronological consistency check, baseline verification, data verification rate assessment.
OUTPUT: Structured JSON report with timeline metadata, completeness classification (COMPLETE/INCOMPLETE), detailed issue list, MDT/Tumor Board platform integration readiness.
⚠️ IMPORTANT:
• Missing baseline makes any trend analysis meaningless.
• Unverified data must not be used for clinical decisions.
• Chronological inconsistencies indicate data entry or integration errors.
• New variants may appear BEFORE radiological progression — monitor molecular data.
• Longitudinal review ≠ clinical conclusion. It is a DECISION SUPPORT TOOL.
Usage:
LongitudinalResultReviewBuilder.exe → demo mode (console output)
LongitudinalResultReviewBuilder.exe input.csv output.json → evaluate your data
📍 Scope: MDT/Tumor Boards, clinical trials, molecular tumor boards, regulatory inspections, real-world evidence studies.
⚠️ CRITICAL:
• Baseline Present = True | Molecular Tests ≥ 1 | Imaging Studies ≥ 1
• Verification Rate = 100% | Chronological Consistency maintained
• New Variants explicitly tracked at each event
Key features: Multi-modal aggregation, automatic key event/new variant detection, completeness/verification/chronology checks, standardized JSON output, ESMO/ASCO/CAP/CDISC compliance.
💡 Tips: Automate data import from LIMS/EDC/PACS. Define clear baseline marking rules. Implement double-verification workflow. Run before every MDT. Archive each generated review as medical record.
⚠️ Note: Generates STRUCTURED DATA OVERVIEW. Does NOT perform clinical interpretation or make decisions. Interpretation remains responsibility of treating team. Utility provides informational foundation for evidence-based clinical decisions.input.csv
PatientID,StudyOrCaseID,EventDate,EventType,EventSubtype,ResultSummary,NumericValue,Units,Interpretation,TherapyName,NewVariantsDetected,IsBaseline,DataSource,DataVerified
PAT-2026-001,CASE-LUNG-042,2026-01-15,Molecular_Test,cfDNA_NGS,EGFR L858R detected,12.5,% VAF,Baseline,,EGFR:c.2573T>G,true,LIMS,true
PAT-2026-001,CASE-LUNG-042,2026-01-18,Imaging,CT_Chest,Right upper lobe mass 3.2cm,32.0,mm,Baseline,,,true,PACS,true
PAT-2026-001,CASE-LUNG-042,2026-01-22,Therapy_Change,Targeted_Therapy_Start,Osimertinib 80mg daily initiated,0,,Treatment_Start,Osimertinib,,false,EDC,true
PAT-2026-001,CASE-LUNG-042,2026-02-20,Molecular_Test,cfDNA_NGS,EGFR L858R decreased,1.8,% VAF,Molecular_Response,Osimertinib,,false,LIMS,true
PAT-2026-001,CASE-LUNG-042,2026-02-25,Imaging,CT_Chest,Mass reduced to 2.1cm,21.0,mm,PR,Osimertinib,,false,PACS,true
PAT-2026-001,CASE-LUNG-042,2026-05-10,Molecular_Test,cfDNA_NGS,EGFR L858R rising + new MET amp,4.5,% VAF,Molecular_Progression,Osimertinib,MET_amplification,false,LIMS,true
PAT-2026-001,CASE-LUNG-042,2026-05-15,Imaging,CT_Chest,Mass increased to 3.8cm + pleural effusion,38.0,mm,PD,Osimertinib,,false,PACS,true
PAT-2026-001,CASE-LUNG-042,2026-05-22,Therapy_Change,Combination_Therapy_Start,Osimertinib + Capmatinib initiated,0,,Treatment_Change,Osimertinib+Capmatinib,,false,EDC,true
URS & FS — User Requirements and Functional Specification
This document describes the controlled interface and behaviour of LongitudinalResultReviewBuilder for Longitudinal Result Review Builder.
Domain limits and critical parameters
Key fragments from the source description are shown below. Before production use, limits must be verified against the approved specification, registration dossier and local SOPs.
- • Unverified data must not be used for clinical decisions.
- ⚠️ CRITICAL:
- • Baseline Present = True | Molecular Tests ≥ 1 | Imaging Studies ≥ 1
URS — User Requirements Specification
| ID | Requirement | Criticality | Acceptance criterion |
|---|
| URS-001 | The utility shall accept an input.csv file for Longitudinal Result Review Builder with headers defined in the data contract. | High | The file is processed without manual header editing. |
| URS-002 | The utility shall perform deterministic QC evaluation without machine learning and without probabilistic conformance decisions. | High | Identical input data, rule version and configuration produce reproducible results. |
| URS-003 | The utility shall validate mandatory fields, data types, ranges, units and domain plausibility. | High | Schema, conversion and range errors are explicitly reported. |
| URS-004 | The utility shall apply domain limits and rules from the description, approved specification, registration dossier and local SOPs. | High | Each check has PASS/WARNING/FAIL and a clear message. |
| URS-005 | The utility shall generate output.json with machine-readable results, source values, warnings, failures and critical findings. | High | JSON is suitable for LIMS/ELN/MES integration and QA/QC review. |
| URS-006 | The utility shall preserve traceability between batch/sample, input file, applied rules and final status. | High | Output contains identifiers, checked parameters and audit metadata. |
| URS-007 | The documentation shall support IQ/OQ/PQ, CSV/CSA and review by internal QA or inspectors. | Medium | URS, FS, input/output contract and test scenarios are supplied with the utility. |
| URS-008 | The utility shall be used as a QC decision-support tool and not as a substitute for approved specifications and QA/QP release decision. | Medium | Documentation states change control and limit-verification expectations. |
input.csv contract
| # | Field | Type | Sample | Purpose |
|---|
| 1 | PatientID | string / controlled vocabulary | PAT-2026-001 | Controlled input parameter for deterministic QC rules. |
| 2 | StudyOrCaseID | string / controlled vocabulary | CASE-LUNG-042 | Controlled input parameter for deterministic QC rules. |
| 3 | EventDate | string / controlled vocabulary | 2026-01-15 | Controlled input parameter for deterministic QC rules. |
| 4 | EventType | string / controlled vocabulary | Molecular_Test | Controlled input parameter for deterministic QC rules. |
| 5 | EventSubtype | string / controlled vocabulary | cfDNA_NGS | Controlled input parameter for deterministic QC rules. |
| 6 | ResultSummary | string / controlled vocabulary | EGFR L858R detected | Result/status used in final classification. |
| 7 | NumericValue | decimal | 12.5 | Controlled input parameter for deterministic QC rules. |
| 8 | Units | string / controlled vocabulary | % VAF | Controlled input parameter for deterministic QC rules. |
| 9 | Interpretation | string / controlled vocabulary | Baseline | Controlled input parameter for deterministic QC rules. |
| 10 | TherapyName | string / controlled vocabulary | | Controlled input parameter for deterministic QC rules. |
| 11 | NewVariantsDetected | string / controlled vocabulary | EGFR:c.2573T>G | Controlled input parameter for deterministic QC rules. |
| 12 | IsBaseline | string / controlled vocabulary | true | Controlled input parameter for deterministic QC rules. |
| 13 | DataSource | string / controlled vocabulary | LIMS | Controlled input parameter for deterministic QC rules. |
| 14 | DataVerified | string / controlled vocabulary | true | Controlled input parameter for deterministic QC rules. |
PatientID,StudyOrCaseID,EventDate,EventType,EventSubtype,ResultSummary,NumericValue,Units,Interpretation,TherapyName,NewVariantsDetected,IsBaseline,DataSource,DataVerified
PAT-2026-001,CASE-LUNG-042,2026-01-15,Molecular_Test,cfDNA_NGS,EGFR L858R detected,12.5,% VAF,Baseline,,EGFR:c.2573T>G,true,LIMS,true
PAT-2026-001,CASE-LUNG-042,2026-01-18,Imaging,CT_Chest,Right upper lobe mass 3.2cm,32.0,mm,Baseline,,,true,PACS,true
PAT-2026-001,CASE-LUNG-042,2026-01-22,Therapy_Change,Targeted_Therapy_Start,Osimertinib 80mg daily initiated,0,,Treatment_Start,Osimertinib,,false,EDC,true
Input validation rules
| ID | Field | Rule | Criticality |
|---|
| VR-001 | PatientID | The field shall match an approved dictionary or accepted string representation. | High |
| VR-002 | StudyOrCaseID | The field shall match an approved dictionary or accepted string representation. | High |
| VR-003 | EventDate | The field shall match an approved dictionary or accepted string representation. | High |
| VR-004 | EventType | The field shall match an approved dictionary or accepted string representation. | Medium |
| VR-005 | EventSubtype | The field shall match an approved dictionary or accepted string representation. | Medium |
| VR-006 | ResultSummary | The field shall match an approved dictionary or accepted string representation. | Medium |
| VR-007 | NumericValue | The field shall match an approved dictionary or accepted string representation. | Medium |
| VR-008 | Units | The field shall match an approved dictionary or accepted string representation. | Medium |
| VR-009 | Interpretation | The field shall match an approved dictionary or accepted string representation. | Medium |
| VR-010 | TherapyName | The field shall match an approved dictionary or accepted string representation. | Medium |
| VR-011 | NewVariantsDetected | The field shall match an approved dictionary or accepted string representation. | Medium |
| VR-012 | IsBaseline | The field shall match an approved dictionary or accepted string representation. | Medium |
| VR-013 | DataSource | The field shall match an approved dictionary or accepted string representation. | Medium |
| VR-014 | DataVerified | The field shall match an approved dictionary or accepted string representation. | Medium |
FS — Functional Specification
| ID | Function | Implementation |
|---|
| FS-001 | CLI execution | Support execution modes: demo mode without arguments and production mode input.csv output.json. |
| FS-002 | CSV import | Read input.csv in UTF-8/CSV-compatible format and validate header and expected columns. |
| FS-003 | Schema validation | Check mandatory fields, column count, unknown key fields and empty mandatory values. |
| FS-004 | Type conversion | Convert numeric, flag and text values; invalid format is recorded as a row-level error. |
| FS-005 | Domain rule engine | Apply rules for Longitudinal Result Review Builder, including critical limits from the description and approved specification. |
| FS-006 | Status aggregation | Produce final status: FAIL for critical failure, WARNING for non-critical deviation, PASS for conformance. |
| FS-007 | JSON export | Write output.json with detailed checks, source values, warnings, failures and critical findings. |
| FS-008 | Audit support | Keep result structure suitable for review, deviation investigation and calculation reproduction. |
| FS-009 | Integration contract | Support the scenario LIMS/ELN/MES → input.csv → utility → output.json → portal/admin review. |
| FS-010 | Error handling | Return explicit messages for missing file, empty CSV, invalid schema, output write failure and invalid format. |
Example output.json
{
"utilityId": "longitudinalresultreviewbuilder",
"utilityFolder": "LongitudinalResultReviewBuilder",
"package": "LiquidBiopsy",
"overallStatus": "PASS|WARNING|FAIL",
"sourceFile": "input.csv",
"processedAtUtc": "2026-06-10T00:00:00Z",
"checks": [
{
"parameter": "PatientID",
"value": "PAT-2026-001",
"status": "PASS|WARNING|FAIL",
"message": "Deterministic rule-based check result",
"ruleReference": "FS-RULE-001"
},
{
"parameter": "StudyOrCaseID",
"value": "CASE-LUNG-042",
"status": "PASS|WARNING|FAIL",
"message": "Deterministic rule-based check result",
"ruleReference": "FS-RULE-002"
},
{
"parameter": "EventDate",
"value": "2026-01-15",
"status": "PASS|WARNING|FAIL",
"message": "Deterministic rule-based check result",
"ruleReference": "FS-RULE-003"
},
{
"parameter": "EventType",
"value": "Molecular_Test",
"status": "PASS|WARNING|FAIL",
"message": "Deterministic rule-based check result",
"ruleReference": "FS-RULE-004"
},
{
"parameter": "EventSubtype",
"value": "cfDNA_NGS",
"status": "PASS|WARNING|FAIL",
"message": "Deterministic rule-based check result",
"ruleReference": "FS-RULE-005"
},
{
"parameter": "ResultSummary",
"value": "EGFR L858R detected",
"status": "PASS|WARNING|FAIL",
"message": "Deterministic rule-based check result",
"ruleReference": "FS-RULE-006"
},
{
"parameter": "NumericValue",
"value": "12.5",
"status": "PASS|WARNING|FAIL",
"message": "Deterministic rule-based check result",
"ruleReference": "FS-RULE-007"
},
{
"parameter": "Units",
"value": "% VAF",
"status": "PASS|WARNING|FAIL",
"message": "Deterministic rule-based check result",
"ruleReference": "FS-RULE-008"
},
{
"parameter": "Interpretation",
"value": "Baseline",
"status": "PASS|WARNING|FAIL",
"message": "Deterministic rule-based check result",
"ruleReference": "FS-RULE-009"
},
{
"parameter": "TherapyName",
"value": "",
"status": "PASS|WARNING|FAIL",
"message": "Deterministic rule-based check result",
"ruleReference": "FS-RULE-010"
},
{
"parameter": "NewVariantsDetected",
"value": "EGFR:c.2573T>G",
"status": "PASS|WARNING|FAIL",
"message": "Deterministic rule-based check result",
"ruleReference": "FS-RULE-011"
},
{
"parameter": "IsBaseline",
"value": "true",
"status": "PASS|WARNING|FAIL",
"message": "Deterministic rule-based check result",
"ruleReference": "FS-RULE-012"
}
],
"criticalFindings": [],
"warnings": [],
"audit": {
"inputHash": "sha256:<calculated at runtime>",
"rulesVersion": "<utility executable version>",
"documentation": "LongitudinalResultReviewBuilder.documentation.html"
}
}
Traceability matrix
| URS | FS | Test | Evidence |
|---|
| URS-001 | FS-001, FS-002 | OQ-001 | Verify execution and import of valid input.csv. |
| URS-002 | FS-005, FS-006 | OQ-004 | Repeat the same dataset and compare output.json. |
| URS-003 | FS-003, FS-004, FS-010 | OQ-002, OQ-003 | Verify missing columns and invalid types. |
| URS-004 | FS-005, FS-006 | OQ-004, PQ-001 | Verify critical deviations on real/boundary data. |
| URS-005 | FS-007, FS-009 | OQ-005 | Verify JSON schema and downstream-system suitability. |
| URS-006 | FS-008 | OQ-006 | Verify identifiers and audit metadata. |
| URS-007 | FS-008, FS-010 | IQ-001, OQ-007 | Verify documentation completeness and control evidence. |
| URS-008 | FS-005, FS-008 | PQ-002 | Verify review workflow and no replacement of QA decision. |
IQ/OQ/PQ test scenarios
| ID | Scenario | Expected result |
|---|
| IQ-001 | Verify executable, input.csv, documentation and checksum availability. | Delivery set is complete; version is recorded. |
| OQ-001 | Valid sample row from input.csv. | PASS or acceptable WARNING according to rules. |
| OQ-002 | Remove a mandatory CSV column. | Schema error or FAIL with missing-column reference. |
| OQ-003 | Place a non-numeric value into a numeric field. | Type-conversion error with row/field reference. |
| OQ-004 | Set a critical parameter outside the limit. | FAIL and critical finding. |
| OQ-005 | Verify output.json structure. | All mandatory sections are present and JSON is valid. |
| OQ-006 | Verify batch/sample traceability. | Input and result identifiers match. |
| PQ-001 | Verify 3–5 real user batches/samples. | Result is confirmed by QC/QA review. |
| PQ-002 | Verify deviation workflow and manual QA decision. | Utility supports review but does not replace approved decision. |
QA/QC and change control
- Do not rename columns without updating validator, documentation and test set.
- Retain
input.csv, output.json, executable version and checksum. - Before production use, perform IQ/OQ/PQ or equivalent CSV/CSA verification.
- Critical limits shall be verified against the approved specification, registration dossier and local SOPs.
- The utility provides structured QC decision support; final release decision remains with QA/QP and approved procedures.