goci icon indicating copy to clipboard operation
goci copied to clipboard

Integrated table for harmonisation status

Open jiyue1214 opened this issue 5 months ago • 0 comments

The queueing table (hq.db) we are using includes the information about: GCST - format - harmonisation status - in prog status - priority

Based on this, we want to have a table including full information with additional columns:

  1. GCST - PMID
  2. harmonisation status (0/1) - in prog status (0/1) - date set the inProg=1- Error (failed reason message) Logic 1: harm=1 - jump harm=0, in prog status=0, waiting to be queue -> set harm=0, in prog status=1 harm=0, in prog status=1, date set the inProg=1 =< 10 days -> keep it harm=0, in prog status=1, date set the inProg=1 > 10 days, Error !=NA -> keep it harm=0, in prog status=1, date set the inProg=1 > 10 days, Error ==NA -> set harm=0, in prog status=0, (date set the inProg=1) =NA

Setp1: set the table Step 2: Post it as a UI that all group members can access it.

jiyue1214 avatar Sep 11 '24 18:09 jiyue1214