goci
goci copied to clipboard
Integrated table for harmonisation status
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:
- GCST - PMID
- 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.