Tikehau – Polynesia

Software development

Software design:

Dr. Michaël SAUTHIER , MD, PhD, MBI

michael.sauthier@umontreal.ca

Version 2.2 • The RMTQ database that we developed on Filemaker was released under a free license (AGPL v3) in 2019 for free sharing nationally and internationally (https://www.gnu.org/licenses/agpl-3.0.fr.html). Everyone will be able to access it under these conditions (AGPL v3) to draw inspiration and develop the new RMTQ database: https://github.com/sauthiem/Tropho/

2015. Quebec Trophoblastic Disease Registry: How to Make an Easy-To-Use Dynamic Database. Philippe Sauthier, MD, Magali Breguet, Alexandre Rozenholc, MD, and Michael Sauthier, MD. 2015 May;25(4):729-33.

Version 2.1 • Change of name to “Quebec Trophoblastic Patients Network (RMTQ). • Correction of all folder names and all mentions of UMT by RMTQ • Implementation of the temporary logo • Correction of the display of the summary sheet printing (at the expense of other models, which will not be printed) • Correction of the display of the stage in the summary sheet • Addition of biochemical parameters (urinary β-hCG +/-, FSH/LH (UI/L) • Addition of a hospital (Cité de la santé de Laval (CSL) • Modification of the logo and titles • Insertion of text in the comments of the summary sheet

Version 2.0 • Final and fully operational version.

Version 1.5 • Verification of the “Life” and “DCD” date as being the oldest date recorded in the database. • Kohorn 2007 staging, with automatic calculation engine. • Plan to replace “status of file” with a summary of the different stages (0c:3 -> I:4 -> …) • Addition of thyroid status standards in tooltip • Tobacco: SMOKING and NON-SMOKING (only). • Move “phantom ß-hCG” to demography • Delete PE-hCG –> will go in remarks. • Change of logo. • Kalel Graph: ⁃ Add days to the abscissa of the graph. ⁃ Provide graph scripts up to 120 possible values. ⁃ Improve tab integration for ß-hCG values. ⁃ Plan an export script in Excel of the graph data. • Statistics: ⁃ Display of mole percentage (complete, partial or NOS) • Staging (scripts) ⁃ Staging: automatic calculation of age, pregnancy delay index and ß-hCG pre-tx elements for the FIGO 2002 stage ⁃ Calculation assistance of the index pregnancy delay. • New fields ⁃ + Patient consent date ⁃ Create UMT file number (AA-NUM), create automatically (suggest) ⁃ Referring physician ⁃ + Link with CMQ site practice permit ⁃ + Email and Fax ⁃ File ⁃ CHUM /Ext ⁃ Alphanumeric (N, S, H)+folder ⁃ + Abortus ⁃ Delete lab date ⁃ McGill search ⁃ Telephone • Reparator (automatic data correction) ⁃ Uppercase last name ⁃ Capital in first name ⁃ Remove space in the postal code ⁃ RAMQ in uppercase ⁃ All dates are in DD-MM-YYYY format, without zeros in the prefix of months and days • Change in the distribution of fields in the tabs • Graphic: ⁃ Legend at the bottom and in line ⁃ Other is no longer displayed in the legend, but still present in the curves, if applicable ⁃ Choice of the period to display, with adaptive calculation of logarithms and date scales • Summary sheet ⁃ Integrated graph, adjustable over time ⁃ Data demographics ⁃ Display of last treatment ⁃ Add clinician name • Display of diseases in the form MiNi where i is the number of each disease/neoplasia

Version 1.4 • Improvement of the lists of values ​​with simplifications of diagnoses (international standardization) • Addition of the origin of the patient • Addition in the thyroid hormones of the TSI (Thyroid stimulating immunoglobulins) • Calculation of age in tooltip on the date of birth according to the last date (life or DCD). If no field is completed, the current age is entered. • Age calculation in tooltip on diagnosis dates • Age calculation in week of product of conception (MGT and NGT1) • Selected stage explained in more detail by tooltip • Adjustment of prognosis (in case of stage IV, prognosis at “high risk” whatever the score) • Creation of a “table” model and a “Statistics” model ⁃ “Life_DCD” section which displays either the date of life or the date of death with a symbol (✝) ⁃ Added a thin horizontal red line at 5 IU/L ß-hCG ⁃ Increased precision of graph scales

Version 1.3 • Various small fixes depending on use • Improvement according to information provided by the Lyon MGT Center • Addition of the referring doctor + practice number • DDM + age calculation in weeks of the MGT [not yet functional] • Adjustment of the lists of “clinical presentation” and “diagnosis” values ​​[MGT and NGTs], corrections of the files accordingly • Calculation of prognosis according to the FIGO score [high risk vs. low risk]

Version 1.2 • Reorganization of demographic data • Adaptation of the database to the disease diagram with new tabs (Presentation, Evolution1/2/3/4) • Multiplication of fields accordingly to the disease diagram • Addition of a tab for monitoring of ß-hCG • Addition of the Kalel Graph script which makes it possible to make a semi-logarithmic curve of the follow-up of ß-hCG according to dates. • Addition of two-color graphic markers indicating a medical intervention (surgery/chemotherapy) • Addition of a field to memorize the generated graphic.

Version 1.1 • Modification of the lists of values; • Added date for lab information; • Addition of tooltips as a help method for using the database instead of a help page; • Added “file status” field for later BBD review; • Addition of fields for the result of radiological examinations;

Version 1.0 • Complete overhaul; • Graphic appearance.

Modified on 12/22/2023