Esta página muestra la estructura de los archivos de investigación exportados (.json y .csv) generados al finalizar una evaluación. Estos archivos garantizan una interfaz estable: la estructura y los nombres de las columnas están versionados para que los equipos de investigación externos puedan integrarlos de forma fiable en sus bases de datos.

Versión actual de la estructura: v3.4

Descargar un .json vacío (estructura) Descargar un .csv vacío (estructura) Descargar el libro de códigos (Excel)

  • Se proporcionan dos formatos: .json (estructura anidada completa) y .csv (estructura aplanada, una fila por evaluación).
  • El CSV está codificado en UTF-8 con BOM y utiliza el punto y coma (;) como delimitador, para una compatibilidad directa con Excel y REDCap.
  • En el CSV, las rutas anidadas se aplanan en nombres de columna unidos por guiones bajos (p. ej., operative_report.incision.approach → operative_report_incision_approach). Las listas de valores simples se unen con comas en una sola columna.
  • Los archivos se nombran CRS-Data-<TYPE>-<date>.json (exportación JSON) y CRS-Report_Data-<TYPE>-<date>.csv (exportación CSV).
  • Las etiquetas se proporcionan en francés (campos _fr) e inglés (campos _en) para los ítems clínicos. Este diccionario es, en sí mismo, bilingüe: se muestra según el idioma del sitio.

0. File metadata

Nombre de la columna Tipo de dato Descripción Valores posibles / Ejemplo
meta_generated_at ISO 8601 datetime Date and time the export file was generated (ISO 8601 format) e.g. "2026-06-08T14:32:05+02:00"
meta_version Text Version of the export file structure (see the Changelog tab of the Developers page) e.g. "2.11"
meta_language_codes List of strings Language codes present in the bilingual labels (fr, en) — in CSV: values joined by commas in a single column ["fr", "en"]

1. Evaluation metadata

Nombre de la columna Tipo de dato Descripción Valores posibles / Ejemplo
evaluation_meta_evaluation_type Single choice (Radio) Evaluation type
ct, petct, fapipetct, spectraltdm, mri, surgery, pathology
evaluation_meta_evaluation_date Date Evaluation date YYYY-MM-DD
evaluation_meta_hospital Text Hospital name free text
evaluation_meta_hospital_service Text Hospital department name free text
evaluation_meta_practitioner Text Surgeon / practitioner name free text
evaluation_meta_patient_name Text Patient name or identifier free text
evaluation_meta_patient_sex Single choice (Radio) Patient sex male, female
evaluation_meta_primary_tumor Single choice (Radio) Primary tumour
colorectalCancer, ovarianCancer, appendixCancer, gastricCancer, pseudomyxomaPeritonei, mesothelioma, other
evaluation_meta_primary_tumor_other Text Specification when tumour = "other" free text
evaluation_meta_primary_tumor_grade Single choice (Radio) Tumour histotype / grade — shown only for ovarian cancer serous, mucinous, clearCell, granulosa, others
evaluation_meta_ecog_status Single choice (Radio) Preoperative ECOG/WHO performance status score 0, 1, 2, 3, 4
evaluation_meta_ca125_preop Numeric Preoperative CA-125 dosage in UI/mL — shown only for ovarian cancer decimal (UI/mL)
evaluation_meta_procedure_title Single choice (Radio) Type of procedure performed surgery_alone, surgery_hipec, laparoscopy_pipac
evaluation_meta_procedure_duration Numeric Total duration of the procedure in minutes integer (minutes)
evaluation_meta_aim_of_surgery JSON array (multi-choice) Aim(s) of the surgery (multiple values possible) — shown except for a laparoscopy procedure (procedure_title = laparoscopy_pipac) cytoreduction, diagnosis, recidive, staging, emergency, palliative
evaluation_meta_aim_of_surgery_details Long text Free-text details on the aim of the surgery free text
evaluation_meta_indication Text Free text describing the surgical indication free text
evaluation_meta_laparoscopy_aim_of_surgery Single choice (Radio) Aim of the exploratory laparoscopy — shown only for a laparoscopy procedure (procedure_title = laparoscopy_pipac) diagnostic_biopsies, evaluation_chemo_neoadjuvant, emergency, pipac, other
evaluation_meta_laparoscopy_aim_other Text Specification when laparoscopy aim = "other" free text
evaluation_meta_laparoscopy_chemo_cycles Numeric Number of chemotherapy cycles received before the laparoscopy — shown only if laparoscopy_aim_of_surgery = evaluation_chemo_neoadjuvant integer
evaluation_meta_laparoscopy_chemo_name Text Name / protocol of neoadjuvant chemotherapy before the laparoscopy (e.g. FOLFOX, FOLFIRI, carboplatin-paclitaxel) — shown only if laparoscopy_aim_of_surgery = evaluation_chemo_neoadjuvant free text
evaluation_meta_laparoscopy_pipac_number Numeric Number of the PIPAC cycle performed during this procedure — shown only if laparoscopy_aim_of_surgery = pipac integer
comment Text Free-text summary comment entered by the practitioner free text

2. Global scores

Nombre de la columna Tipo de dato Descripción Valores posibles / Ejemplo
scores_pci_total Numeric Total PCI score (0 to 39) 0 to 39
scores_pci_max Numeric Maximum evaluable PCI score given the non-evaluable regions (0 to 39) 0 to 39
scores_pci_regions_vector List (13) Vector of PCI scores per region R0 to R12 (values 0 to 3, or "X" if non-evaluable) — in CSV: values joined by commas in a single column [0, 3, 1, 0, 2, "X", 0, 0, 1, 0, 0, 0, 0]
scores_fagotti Numeric Total Fagotti score (0 to 14) 0 to 14
scores_fagotti_modified Numeric Total Modified Fagotti score (0 to 10) 0 to 10
scores_figo Text FIGO classification
IA, IB, IC, IC1, IC2, IC3, IIA, IIB, IIIA, IIIA1, IIIA2, IIIB, IIIC, IVA, IVB
scores_figo_stage_iv_reason Text Justification for FIGO stage IV classification, where applicable free text
scores_cc_score Single choice (Radio) CC Score (Completeness of Cytoreduction) — available only for surgery-type evaluations cc0, cc1, cc2, cc3
scores_pci_residual_applicable Boolean Whether a residual PCI applies (incomplete cytoreduction CC-1/2/3) true, false
scores_pci_residual_total Numeric Total residual PCI score after an incomplete cytoreduction (0 if not applicable) 0 to 39
scores_pci_residual_max Numeric Theoretical maximum residual PCI score (39) 0 to 39
scores_pci_residual_regions_vector List (13) Vector of residual PCI scores per region R0 to R12 after an incomplete cytoreduction [0, 1, 0, 0, "NE", 0, 0, 0, 0, 0, 0, 0, 0]

2b. Aletti Surgical Complexity Score

Nombre de la columna Tipo de dato Descripción Valores posibles / Ejemplo
scores_aletti_total Numeric Total Aletti Surgical Complexity Score (SCS) — ovarian cancer evaluations only integer
scores_aletti_complexity_class Numeric (1-3) Aletti complexity class: 1 = low, 2 = intermediate, 3 = high 1, 2, 3
scores_aletti_complexity_label Text Aletti complexity class label (Low, Intermediate, High) Low, Intermediate, High
aletti_details_X_label_key Text Translation key of the Aletti complexity category free text
aletti_details_X_points Numeric Aletti points awarded for this category (0 if not triggered) integer
aletti_details_X_max_points Numeric Maximum possible Aletti points for this category integer
aletti_details_X_triggered Boolean Whether the Aletti category was triggered by at least one performed procedure true, false
aletti_details_X_triggering_procedures List of strings Identifiers (slugs) of the procedures that triggered this Aletti category ["splenectomy", "diaphragm_stripping"]

3. PCI (R0–R12 matrix)

Nombre de la columna Tipo de dato Descripción Valores posibles / Ejemplo
pci_details_X_region_id Numeric (0-12) PCI region identifier (R0 to R12) 0 to 12
pci_details_X_is_evaluable Boolean Region X evaluable — 1 (Yes), 0 (No). X = 0 to 12. true, false
pci_details_X_non_evaluable_reason Text Reason why region X is non-evaluable free text
pci_details_X_nodules_count Numeric Number of nodules observed in region X integer
pci_details_X_nodules_size_mm Numeric Size of region X nodules in millimetres numeric (mm)
pci_details_X_nodules_morpheus2 List of strings MORPHEUS 2 morphological features selected for the region nodules — in CSV: values joined by commas in a single column. Surgery: nodule, plaque, thickening, adhesion, scar, discolouration, normal_appearing. Imaging: nodule, thickening_plaque, fat_infiltration ["nodule", "fat_infiltration"]
pci_details_X_nodules_morpheus_extras List of strings Additional MORPHEUS 2 sub-features (qualifiers as <term>_q_*, complementary descriptions as <term>_c_*) of the region nodules. Imaging: nodule_q_{micronodule,nodule,mass}, nodule_c_{calcified,mucinous,cystic,scalloping}, thickening_plaque_q_{focal,diffuse}, thickening_plaque_c_{calcified,mucinous}, fat_infiltration_q_{focal,diffuse}, fat_infiltration_c_{calcified,mucinous} ["nodule_q_mass", "fat_infiltration_q_diffuse"]
pci_details_X_nodules_morpheus_details JSON object Grouping of morpheus_extras by parent MORPHEUS 2 term (dynamic keys = selected terms) {"fat_infiltration": ["fat_infiltration_q_diffuse"]}
pci_details_X_ascites_minimal_volume Boolean Minimal-volume ascites in region X — 1 (Yes), 0 (No) true, false
pci_details_X_ascites_significant_volume Boolean Significant-volume ascites (> 50 cc) in region X — 1 (Yes), 0 (No) true, false
pci_details_X_ascites_free Boolean Free ascitic fluid in region X — 1 (Yes), 0 (No) true, false
pci_details_X_ascites_loculated Boolean Loculated ascitic fluid in region X — 1 (Yes), 0 (No) true, false
pci_details_X_involved_structures_Y_name_fr Text Name of anatomical structure Y of region X (French) free text
pci_details_X_involved_structures_Y_name_en Text Name of anatomical structure Y of region X (English) free text
pci_details_X_involved_structures_Y_is_involved Boolean Anatomical structure Y involved in region X — 1 (Yes), 0 (No) true, false
pci_details_X_involved_structures_Y_diaphragm_score Numeric Diaphragmatic involvement score for structure Y (0 to 3) — applicable only to diaphragmatic structures 0 to 3, null

4. Resectability criteria & Fagotti

Nombre de la columna Tipo de dato Descripción Valores posibles / Ejemplo
criteria_0_key Text Criteria category key (0 = non-resectability, 1 = lymph nodes, 2 = extra-peritoneal locations, 3 = occult lesions) non_resecability_reasons, abdominal_lymph_nodes, extra_peritoneal_locations, occult_lesions
criteria_0_items_Y_name_fr Text Name of non-resectability criterion Y (French) free text
criteria_0_items_Y_name_en Text Name of non-resectability criterion Y (English) free text
criteria_0_items_Y_is_involved Boolean Non-resectability criterion Y present — 1 (Yes), 0 (No) true, false
criteria_0_items_Y_precision Text Precision or comment associated with criterion Y free text
criteria_0_items_Y_laterality string (enum) or null Laterality of the criterion, for criteria that support it (ureter invasion, arterial/venous infiltration, massive diaphragm involvement): null when not applicable or unset, otherwise one of "right", "left" or "bilateral".
criteria_0_items_Y_options list of strings or null Selected options for criterion Y, for criteria that declare an option set (pancreas head/body/tail, ureter thirds, vessels, abdominal-wall side, small-bowel segments, duodenum parts): null when the criterion declares no option set or none is selected, otherwise the list of selected option keys.
criteria_1_items_Y_is_involved Boolean Lymph node Y involved — 1 (Yes), 0 (No) true, false
criteria_2_items_Y_is_involved Boolean Extra-peritoneal location Y involved — 1 (Yes), 0 (No) true, false
criteria_3_key Text Occult criteria category key (3 = occult lesions) occult_lesions
criteria_3_items_Y_is_involved Boolean Occult-lesion criterion Y present — 1 (Yes), 0 (No) true, false
fagotti_details_X_key Text Fagotti criterion identifier omentalCake, peritonealCarcinomatosis, diaphragmaticCarcinomatosis, mesentericRetraction, bowelInfiltration, stomachInfiltration, liverMetastases
fagotti_details_X_name_fr Text Name of Fagotti criterion X (French) free text
fagotti_details_X_name_en Text Name of Fagotti criterion X (English) free text
fagotti_details_X_score Numeric Score of Fagotti criterion X — 0 or 2 0, 2
fagotti_modified_details_X_key Text Modified Fagotti criterion identifier diaphragmaticCarcinomatosis, mesentericRetraction, stomachInfiltration, liverMetastases
fagotti_modified_details_X_name_fr Text Name of Modified Fagotti criterion X (French) free text
fagotti_modified_details_X_name_en Text Name of Modified Fagotti criterion X (English) free text
fagotti_modified_details_X_score Numeric Score of Modified Fagotti criterion X — 0 or 2 0, 2

5. Operative report — Free text

Nombre de la columna Tipo de dato Descripción Valores posibles / Ejemplo
operative_report_anamnesis Long text Relevant context, history and background (free text) free text
operative_report_remarks Long text End-of-procedure remarks and particularities (free text) free text

5. Operative report — Incision

Nombre de la columna Tipo de dato Descripción Valores posibles / Ejemplo
operative_report_incision_approach Single choice (Radio) Surgical access route: 'open' (laparotomy) or 'laparoscopy'. open, laparoscopy
operative_report_incision_approach_fr Free text French label of the surgical access route.
operative_report_incision_approach_en Free text English label of the surgical access route.
operative_report_incision_type Single choice (Radio) Laparotomy incision type (open approach): median, pfannenstiel, subcostal, paramedian, other.
operative_report_incision_type_fr Free text French label of the laparotomy type.
operative_report_incision_type_en Free text English label of the laparotomy type.
operative_report_incision_laterality Single choice (Radio) Side of a subcostal or paramedian incision: 'left' or 'right'.
operative_report_incision_laterality_fr Free text French label of the laterality.
operative_report_incision_laterality_en Free text English label of the laterality.
operative_report_incision_midline_details List Extension segments of a median laparotomy: sus_ombilical, sub_ombilical, xyphopubien.
operative_report_incision_port_sites List Laparoscopic trocar/port site positions: median, lateral_r, lateral_l, other.
operative_report_incision_port_site_other Free text Free-text detail when the 'other' port site is selected.
operative_report_incision_trocar_config Single choice (Radio) Trocar configuration (laparoscopy): 'multiport' or 'monotrocar'.
operative_report_incision_trocar_config_fr Free text French label of the trocar configuration.
operative_report_incision_trocar_config_en Free text English label of the trocar configuration.
operative_report_incision_trocar_count Number Number of trocars (populated only in multiport configuration).
operative_report_incision_mini_laparotomy Boolean A mini-laparotomy was performed (laparoscopy).
operative_report_incision_mini_laparotomy_details Free text Free-text description of the mini-laparotomy.
operative_report_incision_robot_assisted Boolean The procedure was robot-assisted. true, false
operative_report_incision_robot_details Free text Free-text details about the robotic assistance.
operative_report_incision_other_description Free text Free-text description when the laparotomy type is 'other'.
operative_report_incision_pre_peritoneal Boolean A pre-peritoneal approach was used. true, false
operative_report_incision_adhesiolysis Boolean Adhesiolysis was performed at opening. true, false
operative_report_incision_ascites_at_opening Boolean Ascites present at abdominal opening. true, false
operative_report_incision_ascites_quantity Number Ascites volume in cc (populated only when ascites is present). numeric (cc)
operative_report_incision_comment Free text General free-text comment on the incision section.

5. Operative report — Visceral resections

Nombre de la columna Tipo de dato Descripción Valores posibles / Ejemplo
operative_report_visceral_resections_organs_X_organ_key Free text General free-text comment on the incision section.
pancreas, spleen, gall_bladder, liver, stomach, right_diaphragmatic, left_diaphragmatic, appendix, ascending_colon, caecum, transverse_colon, descending_colon, sigmoid_colon, colon_global, rectum, kidneys, ureters, bladder, uterus_vagina, adnexa, male_reproductive, lungs, pleural, testicle
operative_report_visceral_resections_organs_X_label_fr Free text General free-text comment on the incision section. free text
operative_report_visceral_resections_organs_X_label_en Free text General free-text comment on the incision section. free text
operative_report_visceral_resections_organs_X_comment Free text General free-text comment on the incision section. free text
operative_report_visceral_resections_organs_X_items_Y_key Free text General free-text comment on the incision section.
distal_pancreatectomy, pancreatectomie_totale, duodenopancreatectomie_cephalique, splenectomy, cholecystectomy, wedge_resection, multiple_wedge, segment_resection, right_hepatectomy, left_hepatectomy, radiofrequency_ablation, microwave_ablation, wedge_resection_stomach, distal_gastrectomy, subtotal_gastrectomy, total_gastrectomy, tendinous_right, muscle_right, tendinous_left, muscle_left, appendicectomy, right_hemicolectomy, caecectomy, partial_caecectomy, transverse_colectomy, segmental_resection_trans, extended_right_hemi, extended_left_hemi, left_hemicolectomy, sigmoid_colectomy, subtotal_colectomy, total_colectomy, anterior_resection, low_anterior_resection, abdomino_perineal, right_nephrectomy, right_partial_nephrectomy, left_nephrectomy, left_partial_nephrectomy, right_ureter_proximal, right_ureter_mid, right_ureter_distal, left_ureter_proximal, left_ureter_mid, left_ureter_distal, partial_cystectomy, total_cystectomy, total_hysterectomy, subtotal_hysterectomy, vaginectomy, right_oophorectomy, right_salpingectomy, left_oophorectomy, left_salpingectomy, bilateral_salpingo_ovariectomies, prostatectomy, right_seminal_vesicle, left_seminal_vesicle, right_spermatic_cord, left_spermatic_cord, solitary_wedge_right, solitary_wedge_left, multiple_wedge_right, multiple_wedge_left, right_diaphragmatic, right_anterior, right_lateral, right_apical, right_costophrenic, left_diaphragmatic, left_anterior, left_lateral, left_apical, left_costophrenic, right_testicle, left_testicle
operative_report_visceral_resections_organs_X_items_Y_label_fr Free text General free-text comment on the incision section. free text
operative_report_visceral_resections_organs_X_items_Y_label_en Free text General free-text comment on the incision section. free text
operative_report_visceral_resections_organs_X_items_Y_is_performed Free text General free-text comment on the incision section. true, false
operative_report_visceral_resections_organs_X_items_Y_segments Free text General free-text comment on the incision section. e.g. "2,3,4b"
operative_report_visceral_resections_organs_X_items_Y_sub_option Free text General free-text comment on the incision section. free text
operative_report_visceral_resections_organs_X_items_Y_measure Free text General free-text comment on the incision section.
operative_report_visceral_resections_organs_X_items_Y_lymph_dredging Free text General free-text comment on the incision section. true, false
operative_report_visceral_resections_organs_X_items_Y_comment Free text General free-text comment on the incision section. free text
operative_report_visceral_resections_small_bowel_details JSON Small bowel resection details (length, mesentery, anastomosis, stoma...)
operative_report_visceral_resections_section_comments_c1 Text Comment for the supramesocolic visceral section (c1) free text
operative_report_visceral_resections_section_comments_c2 Text Comment for the inframesocolic visceral section (c2) free text
operative_report_visceral_resections_section_comments_c3 Text Comment for the urinary section (c3) free text
operative_report_visceral_resections_section_comments_c4 Text Comment for the genital organs section (c4) free text
operative_report_visceral_resections_section_comments_c5 Text Comment for the extra-abdominal section (c5) free text
operative_report_visceral_resections_section_comments_visceral_perito Text Comment for the visceral peritoneum section free text

5. Operative report — Abdominal wall

Nombre de la columna Tipo de dato Descripción Valores posibles / Ejemplo
operative_report_abdominal_wall_X_category_key Text Parietal resection category X identifier scar, port_site, rectus_muscle, posterior_sheath
operative_report_abdominal_wall_X_label_fr Text Parietal resection category X name (French) free text
operative_report_abdominal_wall_X_label_en Text Parietal resection category X name (English) free text
operative_report_abdominal_wall_X_items_Y_key Text Parietal resection Y identifier in category X
midline, paramedian, subcostal, pfannenstiel, lateral, right, left
operative_report_abdominal_wall_X_items_Y_label_fr Text Parietal resection Y name (French) free text
operative_report_abdominal_wall_X_items_Y_label_en Text Parietal resection Y name (English) free text
operative_report_abdominal_wall_X_items_Y_is_resected Boolean Parietal resection Y performed — 1 (Yes), 0 (No) true, false
operative_report_abdominal_wall_X_items_Y_comment Text Details / comment of parietal resection Y free text

5. Operative report — Reconstruction

Nombre de la columna Tipo de dato Descripción Valores posibles / Ejemplo
operative_report_reconstructive_matrix_X_site Single choice (Radio) Anatomical site of the diaphragm/wall reconstruction: diaphragm_r (right diaphragm), diaphragm_l (left diaphragm), wall_r (right wall), wall_l (left wall).
operative_report_reconstructive_matrix_X_site_fr Free text French label of the reconstruction site.
operative_report_reconstructive_matrix_X_site_en Free text English label of the reconstruction site.
operative_report_reconstructive_matrix_X_technique Single choice (Radio) Reconstruction technique at the site: direct (direct closure), pedicled (pedicled flap), free_flap (free microvascular flap), prosthetic (prosthetic material).
operative_report_reconstructive_matrix_X_technique_fr Free text French label of the reconstruction technique.
operative_report_reconstructive_matrix_X_technique_en Free text English label of the reconstruction technique.
operative_report_reconstructive_matrix_X_prosthetic_type Free text Type/name of the prosthetic material used (only present when technique is prosthetic).
operative_report_reconstructive_matrix_X_prosthetic_size Number Size in centimetres of the prosthetic material used (only present when technique is prosthetic).
operative_report_reconstructive_anastomoses_X_type Free text Digestive anastomosis type, stored as the localized label entered or picked from the list (e.g. Colorectal, Ileocolic). free text
operative_report_reconstructive_anastomoses_X_method Single choice (Radio) Anastomosis suture method: mechanical (stapled) or manual (hand-sewn). manual, mechanical
operative_report_reconstructive_anastomoses_X_method_fr Free text French label of the suture method.
operative_report_reconstructive_anastomoses_X_method_en Free text English label of the suture method.
operative_report_reconstructive_anastomoses_X_configuration Single choice (Radio) Anastomosis configuration: TT (end-to-end), TL (end-to-side), LT (side-to-end), LL (side-to-side).
operative_report_reconstructive_anastomoses_X_configuration_fr Free text French label of the anastomosis configuration.
operative_report_reconstructive_anastomoses_X_configuration_en Free text English label of the anastomosis configuration.
operative_report_reconstructive_anastomoses_X_peristalsis Single choice (Radio) Peristaltic orientation of the anastomosis: iso (isoperistaltic) or aniso (anisoperistaltic).
operative_report_reconstructive_anastomoses_X_peristalsis_fr Free text French label of the peristaltic orientation.
operative_report_reconstructive_anastomoses_X_peristalsis_en Free text English label of the peristaltic orientation.
operative_report_reconstructive_anastomoses_X_comment Free text Free-text note about the anastomosis.
operative_report_reconstructive_stomas_X_type Single choice (Radio) Type of stoma created: ileostomy, colostomy, jejunostomy, gastrostomy. free text
operative_report_reconstructive_stomas_X_type_fr Free text French label of the stoma type.
operative_report_reconstructive_stomas_X_type_en Free text English label of the stoma type.
operative_report_reconstructive_stomas_X_duration Single choice (Radio) Nature of the stoma: temporary or permanent for enterostomies; feeding or decompression for gastrostomy. temporary, permanent
operative_report_reconstructive_stomas_X_duration_fr Free text French label of the stoma nature.
operative_report_reconstructive_stomas_X_duration_en Free text English label of the stoma nature.
operative_report_reconstructive_stomas_X_comment Free text Free-text note about the stoma.
operative_report_reconstructive_urinary_X_type Single choice (Radio) Type of urinary reconstruction: ureteroplasty, reimplantation (ureteral reimplantation), neobladder, bladder_suture, jj_stent, nephrostomy, catheter (urinary catheter). free text
operative_report_reconstructive_urinary_X_type_fr Free text French label of the urinary reconstruction type.
operative_report_reconstructive_urinary_X_type_en Free text English label of the urinary reconstruction type.
operative_report_reconstructive_urinary_X_side Single choice (Radio) Laterality of the urinary procedure: left, right or bilateral; present only for side-bearing types (ureteroplasty, reimplantation, jj_stent, nephrostomy).
operative_report_reconstructive_urinary_X_side_fr Free text French label of the urinary procedure laterality.
operative_report_reconstructive_urinary_X_side_en Free text English label of the urinary procedure laterality.
operative_report_reconstructive_urinary_X_comment Free text Free-text note about the urinary reconstruction. free text
operative_report_reconstructive_vascular_comment Free text Free-text description of any vascular reconstruction performed.
operative_report_reconstructive_global_comment Free text Overall free-text comment for the reconstructive section.

5. Operative report — Peritonectomies

Nombre de la columna Tipo de dato Descripción Valores posibles / Ejemplo
operative_report_peritonectomy_groups_X_category_key Free text Overall free-text comment for the reconstructive section.
right_antero_parietal, left_antero_parietal, right_upper_quadrant, left_upper_quadrant, ancillary, pelvic_peritonectomy, glisson_capsulectomy, greater_omentectomy, lesser_sac, mesocolic, small_bowel
operative_report_peritonectomy_groups_X_label_fr Free text Overall free-text comment for the reconstructive section. free text
operative_report_peritonectomy_groups_X_label_en Free text Overall free-text comment for the reconstructive section. free text
operative_report_peritonectomy_groups_X_items_Y_key Free text Overall free-text comment for the reconstructive section.
right_anterior_ventral, right_paracolic, left_anterior_ventral, left_paracolic, right_subphrenic, morrisons_pouch, winslow_anterior, winslow_posterior, left_subphrenic, falciform_ligament, umbilical_round_ligament, left_gastric_vessels, right_inguinal, left_inguinal, treitz, bladder, pouch_of_douglas, right_pararectal, left_pararectal, right_iliac_fossa, left_iliac_fossa, false_pelvis, right_lobe_total, right_lobe_subtotal, left_lobe_total, left_lobe_subtotal, left_caudate_lobe, infracolic, supracolic_arch_preserving, supracolic_gastroepiploic, gastrosplenic_ligament, lesser_omentectomy, hepatoduodenal_ligament, total_pancreatic, subpyloric_space, ascending, transverse, descending, sigmoid, partial_sb, subtotal_sb, total_sb, focal_atypical
operative_report_peritonectomy_groups_X_items_Y_label_fr Free text Overall free-text comment for the reconstructive section. free text
operative_report_peritonectomy_groups_X_items_Y_label_en Free text Overall free-text comment for the reconstructive section. free text
operative_report_peritonectomy_groups_X_items_Y_status Free text Overall free-text comment for the reconstructive section. complete, partial, not_performed
operative_report_peritonectomy_comments_parietal Text Comment on anterior parietal peritonectomies free text
operative_report_peritonectomy_comments_pelvis Text Comment on pelvic peritonectomies free text
operative_report_peritonectomy_comments_glisson Text Comment on Glisson's capsulectomies free text
operative_report_peritonectomy_comments_meso Text Comment on mesenteric / mesocolic peritonectomies free text

5. Operative report — Nodules & visceral peritoneum (A7)

Nombre de la columna Tipo de dato Descripción Valores posibles / Ejemplo
operative_report_visceral_peritoneum_nodules_groups_X_group_key Text Visceral peritoneum resection group X identifier resection_nodules, resection_peritoneum
operative_report_visceral_peritoneum_nodules_groups_X_label_fr Text Group X name (French) free text
operative_report_visceral_peritoneum_nodules_groups_X_label_en Text Group X name (English) free text
operative_report_visceral_peritoneum_nodules_groups_X_items_Y_key Text Procedure Y identifier in group X
nodule_parietal, nodule_liver, nodule_small_bowel, nodule_colon, nodule_spleen, nodule_gastric, nodule_wall, perito_stomach, perito_ascending, perito_rectosigmoid
operative_report_visceral_peritoneum_nodules_groups_X_items_Y_label_fr Text Procedure Y name (French) free text
operative_report_visceral_peritoneum_nodules_groups_X_items_Y_label_en Text Procedure Y name (English) free text
operative_report_visceral_peritoneum_nodules_groups_X_items_Y_is_selected Boolean Procedure Y selected in group X — 1 (Yes), 0 (No) true, false
operative_report_visceral_peritoneum_nodules_groups_X_items_Y_comment Text Precision / comment of procedure Y free text
operative_report_visceral_peritoneum_nodules_global_comment Text Global comment of the visceral peritoneum & nodules section (section A7) free text

5. Operative report — Lymphadenectomies

Nombre de la columna Tipo de dato Descripción Valores posibles / Ejemplo
operative_report_lymphadenectomy_regions_X_region_key Text Lymph node region X identifier
right_pelvic, left_pelvic, retro_infra, retro_supra, celiac_axis, sup_mesenteric, porta_hepatis, omenta, left_gastric, splenic_hilum, para_cardiac, inguinal, supradiaphragmatic, mediastinal, cervical, axillary
operative_report_lymphadenectomy_regions_X_label_fr Text Lymph node region X name (French) free text
operative_report_lymphadenectomy_regions_X_label_en Text Lymph node region X name (English) free text
operative_report_lymphadenectomy_regions_X_items_Y_key Text Lymph node group Y identifier in region X
ext_iliac_r, int_iliac_r, obturator_r, common_iliac_r, ext_iliac_l, int_iliac_l, obturator_l, common_iliac_l, paraaortic, paracaval, interaortocaval, retrocaval, retro_supra_global, celiac_global, sup_mesenteric_global, common_bile_duct, common_hepatic_artery, hepatic_hilar, greater_omental, lesser_omental, left_gastric_global, splenic_hilum_global, para_cardiac_r, para_cardiac_l, inguinal_r, inguinal_l, cardiophrenic_r, cardiophrenic_l, subxiphoid, mediastinal_global, cervical_r, cervical_l, axillary_r, axillary_l
operative_report_lymphadenectomy_regions_X_items_Y_label_fr Text Lymph node group Y name (French) free text
operative_report_lymphadenectomy_regions_X_items_Y_label_en Text Lymph node group Y name (English) free text
operative_report_lymphadenectomy_regions_X_items_Y_enlarged Boolean Enlarged lymph node in group Y of region X — 1 (Yes), 0 (No) true, false
operative_report_lymphadenectomy_regions_X_items_Y_template Boolean Systematic (template) lymph node dissection performed in group Y — 1 (Yes), 0 (No) true, false
operative_report_lymphadenectomy_global_comment Text Global comment of the lymphadenectomy section free text

5. Operative report — Occult peritoneal spaces

Nombre de la columna Tipo de dato Descripción Valores posibles / Ejemplo
operative_report_occult_spaces_groups_X_category_key Text Occult spaces category X identifier natural_spaces, tunnels, difficult_sites
operative_report_occult_spaces_groups_X_label_fr Text Category X name (French) free text
operative_report_occult_spaces_groups_X_label_en Text Category X name (English) free text
operative_report_occult_spaces_groups_X_items_Y_key Text Occult space Y identifier in category X
sup_paraduodenal, inf_paraduodenal, right_subhepatic, sup_recess_lesser, subpyloric, hepatocaval, liver_scissurae, inguinal_canal, hepatic_bridge, winslow, splenic_hilum, post_edge_spleen, ileocaecal, sigmoid_recess, small_bowel_folds, greater_omental, right_psoas
operative_report_occult_spaces_groups_X_items_Y_label_fr Text Occult space Y name (French) free text
operative_report_occult_spaces_groups_X_items_Y_label_en Text Occult space Y name (English) free text
operative_report_occult_spaces_groups_X_items_Y_status Single choice (Radio) Occult space Y check status — yes (involved), no (clear) yes, no
operative_report_occult_spaces_previous_planes_X_name Text Previous surgical plane X name (free text entered by the practitioner) free text
operative_report_occult_spaces_previous_planes_X_status Single choice (Radio) Previous surgical plane X status — yes (recurrence), no (clear) yes, no
operative_report_occult_spaces_global_comment Text Global comment of the occult peritoneal spaces section free text

5. Operative report — Drains

Nombre de la columna Tipo de dato Descripción Valores posibles / Ejemplo
operative_report_drains_X_type Single choice (Radio) Drain X type — lame, redon, drain_plat, drain_aspiration, sonde, autre
blake, chest, kehr, lame, multi_perf, penrose, pezzer, redon
operative_report_drains_X_type_fr Text Drain X type label (French) free text
operative_report_drains_X_type_en Text Drain X type label (English) free text
operative_report_drains_X_location Single choice (Radio) Drain X location — right_subphrenic, left_subphrenic, pelvis, other...
right_thoracic, left_thoracic, right_hypochondrium, left_hypochondrium, stomach, pancreatic, subhepatic, right_flank, left_flank, lomboaortic, right_fossa, left_fossa, pelvic, subcutaneous, other
operative_report_drains_X_location_fr Text Drain X location label (French) free text
operative_report_drains_X_location_en Text Drain X location label (English) free text
operative_report_drains_X_location_other Text Location specification when location = "other" free text
operative_report_drains_X_comment Text Free-text comment associated with drain X free text

5. Operative report — Biopsies & cytologies

Nombre de la columna Tipo de dato Descripción Valores posibles / Ejemplo
operative_report_biopsies_X_region Single choice (Radio) Sugarbaker PCI region (coded 0 to 12, e.g. 0=Central, 6=Pelvis) where the biopsy was taken. 0 to 12
operative_report_biopsies_X_region_fr Free text French label of the biopsy site PCI region (translation of evaluation.region.<n>.name).
operative_report_biopsies_X_region_en Free text English label of the biopsy site PCI region.
operative_report_biopsies_X_count Number Number of samples taken at this biopsy site. integer
operative_report_biopsies_X_comment Free text Free-text note specific to this biopsy site.
operative_report_biopsies_cytologies_X_type Single choice (Radio) Cytology specimen type: 'on_ascites' (on ascites) or 'on_lavage' (on lavage fluid). on_ascites, on_lavage
operative_report_biopsies_cytologies_X_type_fr Free text French label of the cytology type (Sur ascite / Sur liquide de lavage).
operative_report_biopsies_cytologies_X_type_en Free text English label of the cytology type (On ascites / On lavage fluid).
operative_report_biopsies_cytologies_X_comment Free text Free-text note attached to the cytology sample. free text
operative_report_biopsies_comment Free text Section-level free-text comment for the biopsies/cytology block.
operative_report_biopsies_laparo_items_X_site Single choice (Radio) Site of the biopsy sampled during laparoscopy, coded values: 'omentum', 'carcinosis', 'other'.
operative_report_biopsies_laparo_items_X_site_fr Free text French display label of the biopsy site matching the 'site' code.
operative_report_biopsies_laparo_items_X_site_en Free text English display label of the biopsy site matching the 'site' code.
operative_report_biopsies_laparo_items_X_site_other Free text Free-text description of the site when 'site' is 'other'.
operative_report_biopsies_laparo_items_X_count Number Number of samples taken at this biopsy site.
operative_report_biopsies_laparo_items_X_item_comment Free text Free-text comment specific to this biopsy site.
operative_report_biopsies_laparo_cytologies_X_type Single choice (Radio) Type of cytological examination performed during laparoscopy, coded values: 'on_ascites', 'on_lavage'. on_ascites, on_lavage
operative_report_biopsies_laparo_cytologies_X_type_fr Free text French display label of the cytology type matching the 'type' code.
operative_report_biopsies_laparo_cytologies_X_type_en Free text English display label of the cytology type matching the 'type' code.
operative_report_biopsies_laparo_cytologies_X_comment Free text Free-text comment on the cytological examination. free text
operative_report_biopsies_laparo_comment Free text Global free-text comment on the laparoscopy biopsies/cytology block.

5. Operative report — HIPEC

Nombre de la columna Tipo de dato Descripción Valores posibles / Ejemplo
operative_report_hipec_performed Boolean HIPEC performed — 1 (Yes), 0 (No) true, false
operative_report_hipec_technique Single choice (Radio) Perfusion technique — open (open abdomen), closed (closed abdomen) open, closed
operative_report_hipec_protocol Text Selected HIPEC protocol code (e.g. oxaliplatin, folfox, cisplatindoxo...)
CHIP1, CHIP2, CHIP3, CHIP4, CHIP5, CHIP6, CHIP7, CHIP8
operative_report_hipec_protocol_label_fr Text Full HIPEC protocol label (French) free text
operative_report_hipec_protocol_label_en Text Full HIPEC protocol label (English) free text
operative_report_hipec_details_pathology Free text Pathology or indication targeted by the HIPEC protocol (e.g. "Ovary", "Pseudomyxoma"); pre-filled from the chosen protocol and editable by the surgeon.
operative_report_hipec_details_surgery Free text Surgical context or line of treatment the HIPEC protocol applies to (e.g. "Standard – 1st line and platinum-sensitive recurrence"); protocol default, editable.
operative_report_hipec_details_chemo Free text Chemotherapy agent(s) and dosage of the HIPEC perfusion (e.g. "CISPLATIN 100 MG/M²"); entered in uppercase by the UI, protocol default, editable.
operative_report_hipec_details_temp Free text HIPEC perfusion temperature, free text with units or range (e.g. "41–43 °C"); protocol default, editable. numeric (°C)
operative_report_hipec_details_duration Free text HIPEC perfusion duration, free text with units (e.g. "90 minutes"); protocol default, editable. numeric (minutes)
operative_report_hipec_details_flow Free text HIPEC perfusate flow rate, free text with units (e.g. "750 ml/min"); protocol default, editable.
operative_report_hipec_details_volume Free text HIPEC perfusate volume, free text with units (e.g. "2 liters/m²"); protocol default, editable.
operative_report_hipec_comment Text Free-text comment on the HIPEC free text

5. Operative report — PIPAC

Nombre de la columna Tipo de dato Descripción Valores posibles / Ejemplo
operative_report_pipac_performed Boolean PIPAC performed — 1 (Yes), 0 (No) true, false
operative_report_pipac_context Text PIPAC context: alone or alternating with systemic chemotherapy alone, alternating
operative_report_pipac_chemo_details Text Details of the associated systemic chemotherapy (free text), when context = alternating free text
operative_report_pipac_protocol Text Selected PIPAC protocol code (pipac1, pipac2, pipac3...) pipac1, pipac2, pipac3, pipac4
operative_report_pipac_protocol_label_fr Text PIPAC protocol label (French) free text
operative_report_pipac_drug Text Chemotherapy drug(s) administered during the PIPAC (free text, e.g. CISPLATIN + DOXORUBICIN) free text
operative_report_pipac_dose Numeric Total dose administered during the PIPAC numeric
operative_report_pipac_duration Numeric PIPAC duration in minutes numeric (min)
operative_report_pipac_comment Text Free-text comment on the PIPAC free text

5. Operative report — Laparoscopy

Nombre de la columna Tipo de dato Descripción Valores posibles / Ejemplo
operative_report_surgical_procedures_laparo_annexectomy Boolean Indicates whether an annexectomy (removal of an ovary / fallopian tube) was performed during the laparoscopy; true = yes, false = no, null if not specified.
operative_report_surgical_procedures_laparo_frozen_material Boolean Indicates whether frozen material (tissue) was collected during the procedure; true = yes, false = no, null if not specified.
operative_report_surgical_procedures_laparo_frozen_details Free text Free-text details about the frozen material collected (only filled when frozen material is present).
operative_report_surgical_procedures_laparo_extemporaneous Boolean Indicates whether an extemporaneous (intra-operative frozen-section) examination was performed; true = yes, false = no, null if not specified.
operative_report_surgical_procedures_laparo_other_procedures Free text Free-text description of any other surgical procedures performed during the laparoscopy.
operative_report_surgical_procedures_laparo_global_comment Free text General free-text comment for the laparoscopy surgical-procedures section.
operative_report_planned_treatment_laparo_crs_planned Boolean Whether cytoreductive surgery (CRS) is the planned treatment after the diagnostic laparoscopy (true = yes, false = no, null = unspecified).
operative_report_planned_treatment_laparo_crs_details Free text Free-text details about the planned cytoreductive surgery.
operative_report_planned_treatment_laparo_chemotherapy_planned Boolean Whether systemic chemotherapy is the planned treatment (true = yes, false = no, null = unspecified).
operative_report_planned_treatment_laparo_chemotherapy_details Free text Free-text details about the planned chemotherapy.
operative_report_planned_treatment_laparo_pipac_planned Boolean Whether PIPAC (Pressurized IntraPeritoneal Aerosol Chemotherapy) is the planned treatment (true = yes, false = no, null = unspecified).
operative_report_planned_treatment_laparo_pipac_details Free text Free-text details about the planned PIPAC.
operative_report_planned_treatment_laparo_other_planned Boolean Whether some other treatment is planned (true = yes, false = no, null = unspecified).
operative_report_planned_treatment_laparo_other_details Free text Free-text description of the other planned treatment.
operative_report_planned_treatment_laparo_global_comment Free text Section-level free comment on the overall planned treatment after laparoscopy.

5. Operative report — Complications

Nombre de la columna Tipo de dato Descripción Valores posibles / Ejemplo
operative_report_complications_text Long text Description of intraoperative complications (free text) free text
operative_report_complications_blood_loss Numeric Intraoperative blood loss in cc numeric (cc)
v3.4 current 2026-07-13

Six CRO sections that were exported as a raw client passthrough (incision, reconstructive, biopsies, biopsies_laparo, surgical_procedures_laparo, planned_treatment_laparo) plus hipec.details are now stable whitelisted structures: they always emit the same documented columns (null when absent) and match ExportSchemaRegistry::SCHEMA one-to-one. This removes the silent drift where real exports carried undocumented columns, omitted documented ones, and varied the column set from one patient to the next.

  • operative_report.incision.* — full incision geometry now documented (was only 6 keys): approach/type/laterality with _fr/_en labels, midline_details, port_sites, port_site_other, trocar_config (+labels), trocar_count, mini_laparotomy(+details), robot_assisted(+details), other_description, pre_peritoneal, adhesiolysis, ascites_at_opening, ascites_quantity, comment.
  • operative_report.reconstructive.* — anastomoses.[X], stomas.[X], urinary.[X] and matrix.[X] (prosthetic mesh) are now whitelisted object lists with bilingual labels; vascular_comment and global_comment added; UI-only DOM ids are no longer exported.
  • operative_report.biopsies.* and operative_report.biopsies_laparo.* — biopsy sites and cytologies are emitted as stable structures; the scalar biopsies_laparo column becomes a structured object.
  • operative_report.surgical_procedures_laparo.* and operative_report.planned_treatment_laparo.* — the two laparoscopy scalar columns are replaced by their documented field sets.
  • operative_report.hipec.details.* — the HIPEC details sub-object is now a fixed whitelist (pathology, surgery, chemo, temp, duration, flow, volume) instead of a raw passthrough (only temp and duration were declared before).
v3.3 2026-07-05

Unresectability criteria fully rebuilt to the final surgical reference document: 30 criteria across peritoneal disease/organ resections, bulky nodes, distant/extra-peritoneal metastases and occult lesions. Criteria can now carry multi-option enumerations (pancreas head/body/tail, ureter thirds, vessel list, abdominal-wall side, small-bowel segments, duodenum parts), exported per item. The occult-lesions column is now emitted in its own criteria group.

  • criteria.[].items.[].options — new per-item field: null when the criterion declares no option set, otherwise the list of selected option keys.
  • criteria.[3] (occult_lesions) — the occult-lesions criteria group is now emitted in its own bucket (previously silently folded into non_resecability_reasons); criteria.[].key gains the value occult_lesions.
  • Criteria set/grouping changed (data, not schema): the whole unresectability criteria set was rebuilt to the final medical document (22 peritoneal-disease / 5 nodal / 2 metastatic / 1 occult).
v3.2 2026-06-30

Unresectability criteria reworked: right/left laterality is now captured for the criteria that support it (ureter invasion, arterial/venous infiltration, massive diaphragm involvement) and exported as a per-item scalar enum. A "second, third and fourth part of duodenum" criterion is added and "Ureter(s) invasion" moves to the peritoneal-disease column.

  • criteria.[].items.[].laterality — new per-item field: null when not applicable, otherwise one of right | left | bilateral.
  • Criteria set/grouping changed (data, not schema): new "second, third and fourth part of duodenum" criterion; "Ureter(s) invasion" moved from the extra-peritoneal to the peritoneal-disease group.
v3.1 2026-06-24

PIPAC and HIPEC export now match their documented contract: hipec.performed is emitted (was stored but dropped), and the PIPAC section is a stable, documented structure (was passed through raw) enriched with the computed protocol label.

  • operative_report.hipec.performed — now emitted (yes/no); previously documented but never produced.
  • operative_report.pipac.* — PIPAC is no longer a raw passthrough. Documented keys: performed, context, chemo_details, protocol, protocol_label_fr, drug, dose, duration, comment. Newly exported: context, chemo_details, drug, duration; protocol_label_fr is now computed (was absent from the raw payload).
v3.0 2026-06-24

Imaging PCI morphology aligned with the "Lexicon of morphological terms on imaging": three MORPHEUS 2 terms (nodule, thickening_plaque, fat_infiltration) whose qualifier/complementary extras now drive auto-scoring. Infiltration is merged into the fat_infiltration term and the dedicated infiltration block is removed (BREAKING).

  • pci_details.[X].infiltration.{present,retractile,diffuse_retractile} — REMOVED. Fat infiltration is now reported as the "fat_infiltration" term inside pci_details.[X].nodules.morpheus2 / morpheus_extras / morpheus_details (qualifiers fat_infiltration_q_focal | fat_infiltration_q_diffuse).
  • pci_details.[X].nodules.morpheus2 — imaging value set replaced: the 9 legacy imaging terms give way to nodule, thickening_plaque, fat_infiltration. (Surgery terms unchanged.)
  • pci_details.[X].nodules.morpheus_extras — new imaging qualifier/complementary values: nodule_q_{micronodule,nodule,mass}, nodule_c_{calcified,mucinous,cystic,scalloping}, thickening_plaque_q_{focal,diffuse}, thickening_plaque_c_{calcified,mucinous}, fat_infiltration_q_{focal,diffuse}, fat_infiltration_c_{calcified,mucinous}.
v2.11 2026-06-08

Residual PCI for incomplete cytoreductions, Aletti Surgical Complexity Score for ovarian cancer, and formal documentation of file metadata.

  • scores.pci.residual.{applicable,total,max,regions_vector} — residual PCI after an incomplete cytoreduction (CC-1/2/3).
  • scores.aletti_total, scores.aletti_complexity_class, scores.aletti_complexity_label — Aletti SCS (ovarian cancer evaluations only).
  • aletti_details[] — per-category Aletti breakdown (ovarian cancer evaluations only).
  • meta.generated_at, meta.version, meta.language_codes — file metadata now formally documented in the codebook.
v2.10 2026-05-04

Laparoscopy (PIPAC) workflow fields and patient sex.

  • evaluation_meta.patient_sex, evaluation_meta.laparoscopy_chemo_name and related laparoscopy fields.
  • operative_report.biopsies_laparo, surgical_procedures_laparo, planned_treatment_laparo.

Reconstructed schema (this version predates the machine-readable schema; rebuilt from the change history).

v2.0 2026-03-23

First versioned codebook of the structured surgery/imaging export.

  • Initial published structure: evaluation_meta, scores, pci_details, fagotti, criteria and the full operative_report tree.

Downloads unavailable: this version predates the machine-readable schema and cannot be reliably reconstructed.