Datacall Annex 4 to 8 integration and checks

step 0 : Data check


                  

                  

                    

                    

                  

                

                

                
step 1 : Compare with database

                

                  

                    

                      
                    

                    

                      
                    

                  

                  

                    

                      

                        

                          
                        

                      

                      

                        

                          

                            
Duplicated data

                            

                            

                            
Updated data

                            

                            

                            
Deleted data

                            

                            

                          

                          

                            
New values

                            

                            

                          

                        

                        

                          

                            
Summary modifications

                            

                          

                          

                            
summary still missing

                            

                          

                        

                      

                    

                  

                

                

                
step 2.1 Integrate/ proceed duplicates rows

                

                  

                    

                      
                      

                        
                        
                      

                      

                        

                      

                    

                  

                  

                    
                  

                  

                    

                      
                      
                    

                    

                    

                  

                

                
step 2.2 Integrate new rows

                

                  

                    

                      
                      

                        
                        
                      

                      

                        

                      

                    

                  

                  

                    
                  

                  

                    

                      
                      
                    

                    

                    

                  

                

                
step 2.3 Updated values

                

                  

                    

                      
                      

                        
                        
                      

                      

                        

                      

                    

                  

                  

                    
                  

                  

                    

                      
                      
                    

                    

                    

                  

                

                
step 2.4 Delete values

                

                  

                    

                      
                      

                        
                        
                      

                      

                        

                      

                    

                  

                  

                    
                  

                  

                    

                      
                      
                    

                    

                    

                  

                

              

              

                
Datacall time series (glass / yellow / silver) integration

                
step 0 : Data check

                

                  
                  

                    

                      

                        

                          
load excel file

                        

                        

                          
load already imported file

                        

                      

                      

                        

                          

                            
                            

                              
                              
                            

                            

                              

                            

                          

                          
                        

                        

                          

                            
                            

                              

                                
                              

                              

                                
                              

                              

                                
                              

                            

                          

                        

                        

                          

                            
                            
                          

                          
                        

                      

                      

                        

                          

                          

                        

                        

                          

                          

                        

                      

                    

                    

                      

                        

                        

                      

                    

                  

                

                

                
step 1 : Compare with database

                

                  

                    

                      
                    

                    

                      
                    

                  

                  

                    

                      

                        

                          
                        

                      

                      

                        

                          
                          

                            

                              

                                

                                  
new series

                                  

                                  

                                  
modified series

                                  

                                  

                                

                                

                                  
modified series : what changed at series level ?

                                  

                                

                              

                            

                            

                              

                                

                                  
new data

                                  

                                  

                                  
modified data

                                  

                                  

                                

                                

                                  
modified data : what changed for new_data and updated_data ?

                                  

                                  
deleted data

                                  

                                

                              

                            

                            

                              

                                

                                  
new group metrics

                                  

                                  

                                  
deleted group metrics

                                  

                                

                                

                                  
modified group metrics

                                  

                                  

                                  
modified group metrics : what changed ?

                                  

                                

                              

                            

                            

                              

                                

                                  
new individual metrics

                                  

                                  

                                  

                                  
deleted individual metrics

                                  

                                  

                                

                                

                                  
modified individual metrics

                                  

                                  

                                  
modified individual metrics : what changed ?

                                  

                                

                              

                            

                          

                        

                      

                    

                  

                

                

                
                

                  
                  

                    

                      
step 2.1.1 Integrate new series

                      

                        

                          

                            
                            

                              
                              
                            

                            

                              

                            

                          

                        

                        

                          
                        

                        

                          

                            
                            
                          

                          

                          

                        

                      

                      
step 2.1.2 Update modified series

                      

                        

                          

                            
                            

                              
                              
                            

                            

                              

                            

                          

                        

                        

                          
                        

                        

                          

                            
                            
                          

                          

                          

                        

                      

                    

                    

                      
step 2.2.1 Delete from data

                      

                        

                          

                            
                            

                              
                              
                            

                            

                              

                            

                          

                        

                        

                          
                        

                        

                          

                            
                            
                          

                          

                          

                        

                      

                      
step 2.2.2 Integrate new data

                      

                        

                          

                            
                            

                              
                              
                            

                            

                              

                            

                          

                        

                        

                          
                        

                        

                          

                            
                            
                          

                          

                          

                        

                      

                      
step 2.2.3 Update modified data

                      

                        

                          

                            
                            

                              
                              
                            

                            

                              

                            

                          

                        

                        

                          
                        

                        

                          

                            
                            
                          

                          

                          

                        

                      

                    

                    

                      
step 2.3.1 Delete from group metrics

                      

                        

                          

                            
                            

                              
                              
                            

                            

                              

                            

                          

                        

                        

                          
                        

                        

                          

                            
                            
                          

                          

                          

                        

                      

                      
step 2.3.2 Integrate new group metrics

                      

                        

                          

                            
                            

                              
                              
                            

                            

                              

                            

                          

                        

                        

                          
                        

                        

                          

                            
                            
                          

                          

                          

                        

                      

                      
step 2.3.3 Update group metrics

                      

                        

                          

                            
                            

                              
                              
                            

                            

                              

                            

                          

                        

                        

                          
                        

                        

                          

                            
                            
                          

                          

                          

                        

                      

                    

                    

                      
step 2.4.1 Delete from individual metrics

                      

                        

                          

                            
                            

                              
                              
                            

                            

                              

                            

                          

                        

                        

                          
                        

                        

                          

                            
                            
                          

                          

                          

                        

                      

                      
step 2.4.2 Integrate new individual metrics

                      

                        

                          

                            
                            

                              
                              
                            

                            

                              

                            

                          

                        

                        

                          
                        

                        

                          

                            
                            
                          

                          

                          

                        

                      

                      
step 2.4.3 Update individual metrics

                      

                        

                          

                            
                            

                              
                              
                            

                            

                              

                            

                          

                        

                        

                          
                        

                        

                          

                            
                            
                          

                          

                          

                        

                      

                    

                  

                

              

              

                
Data correction table

                

                  

                

                

                

                  

                    

                      
                      
                    

                  

                  

                    

                      
                      
                    

                  

                  

                    

                      
                      
                    

                  

                  

                    

                      
                      
                    

                  

                  

                    

                      
                      
                    

                  

                

                

                  

                    
                  

                

                

                

              

              

                
Datacall DCF and other sampling data - quality - biometry integration

                
step 0 : Data check

                

                  
                  

                    

                      

                        

                          

                            
                            

                              
                              
                            

                            

                              

                            

                          

                        

                        

                          
                        

                      

                      

                        

                          

                          

                        

                        

                          

                          

                        

                      

                    

                    

                      

                        

                        

                      

                    

                  

                

                

                
step 1 : Compare with database

                

                  

                    

                      
                    

                    

                      
                    

                  

                  

                    

                      

                        

                          
                        

                      

                      

                        

                          
                          

                            

                              

                                

                                  
new sampling

                                  

                                  

                                  
modified sampling

                                  

                                  

                                

                                

                                  
modified sampling : what changed ?

                                  

                                

                              

                            

                            

                              

                                

                                  
new group metrics

                                  

                                  

                                  
deleted group metrics

                                  

                                  

                                

                                

                                  
modified group metrics

                                  

                                  

                                  
modified group metrics : what changed ?

                                  

                                

                              

                            

                            

                              

                                

                                  
new individual metrics

                                  

                                  

                                  

                                  
deleted individual metrics

                                  

                                  

                                  

                                

                                

                                  
modified individual metrics

                                  

                                  

                                  
modified individual metrics : what changed ?

                                  

                                

                              

                            

                          

                        

                      

                    

                  

                

                

                

                  
                  

                    

                      
step 2.1.1 Integrate new sampling

                      

                        

                          

                            
                            

                              
                              
                            

                            

                              

                            

                          

                        

                        

                          
                        

                        

                          

                            
                            
                          

                          

                          

                        

                      

                      
step 2.1.2 Update sampling

                      

                        

                          

                            
                            

                              
                              
                            

                            

                              

                            

                          

                        

                        

                          
                        

                        

                          

                            
                            
                          

                          

                          

                        

                      

                    

                    

                      
step 2.2.1 Delete from group metrics

                      

                        

                          

                            
                            

                              
                              
                            

                            

                              

                            

                          

                        

                        

                          
                        

                        

                          

                            
                            
                          

                          

                          

                        

                      

                      
step 2.2.2 Integrate new group metrics

                      

                        

                          

                            
                            

                              
                              
                            

                            

                              

                            

                          

                        

                        

                          
                        

                        

                          

                            
                            
                          

                          

                          

                        

                      

                      
step 2.2.3 Update group metrics

                      

                        

                          

                            
                            

                              
                              
                            

                            

                              

                            

                          

                        

                        

                          
                        

                        

                          

                            
                            
                          

                          

                          

                        

                      

                    

                    

                      
step 2.3.1 Delete from individual metrics

                      

                        

                          

                            
                            

                              
                              
                            

                            

                              

                            

                          

                        

                        

                          
                        

                        

                          

                            
                            
                          

                          

                          

                        

                      

                      
step 2.3.2 Integrate new individual metrics

                      

                        

                          

                            
                            

                              
                              
                            

                            

                              

                            

                          

                        

                        

                          
                        

                        

                          

                            
                            
                          

                          

                          

                        

                      

                      
step 2.3.3 Update individual metrics

                      

                        

                          

                            
                            

                              
                              
                            

                            

                              

                            

                          

                        

                        

                          
                        

                        

                          

                            
                            
                          

                          

                          

                        

                      

                    

                  

                

              

              

                
Enter the name of a new participant

                

                  

                    

                      
                      
                    

                  

                  

                    
                  

                

                

                  

                    

                  

                

              

              

                

                  

                    

                      
Data exploration tab

                    

                    

                      

                        

                          

                            
                            
                          

                        

                        

                          

                            
                            
                          

                        

                        

                          

                            
                            
                          

                        

                      

                    

                  

                

                

                  

                    

                  

                  

                    

                  

                

                

              

              

                

                  

                    

                      
Time series exploration tab