If you have a measurement in your OSCAR called “OCBL” (ocult blood, so to flag as normal or abnormal) mapped per LOINC to FIT, you can run the SQL script below to update the OCBL to measurements (it updates the FOBT prevention by querying the OCBL measurement).
/* correct FIT feb 2020 */
update measurements, measurementsExt SET measurements.type = "OCBL" where measurements.id = measurementsExt.measurement_id and measurementsExt.keyval = "name" and measurementsExt.val = "FECAL IMMUNOCHEMICAL TEST";
update measurements, measurementsExt SET measurements.measuringInstruction = "FIT stool test" where measurements.id = measurementsExt.measurement_id and measurementsExt.keyval = "name" and measurementsExt.val = "FECAL IMMUNOCHEMICAL TEST";
update measurements, measurementsExt SET measurements.comments = "FIT stool test" where measurements.id = measurementsExt.measurement_id and measurementsExt.keyval = "name" and measurementsExt.val = "FECAL IMMUNOCHEMICAL TEST";