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

                            

                            

                            
new data

                            

                            

                            
new group metrics

                            

                            

                            
new individual metrics

                            

                            

                            

                            
deleted data

                            

                            
deleted group metrics

                            

                            
deleted individual metrics

                            

                            

                          

                          

                            
modified series

                            

                            

                            
modified series : what changed at series level ?

                            

                            
modified data

                            

                            

                            
modified data : what changed for new_data and updated_data ?

                            

                            
modified group metrics

                            

                            

                            
modified group metrics : what changed ?

                            

                            
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

                            

                            

                            
new group metrics

                            

                            

                            
deleted group metrics

                            

                            

                            
new individual metrics

                            

                            

                            

                            
deleted individual metrics

                            

                            

                            

                          

                          

                            
modified sampling

                            

                            

                            
modified sampling : what changed ?

                            

                            
modified group metrics

                            

                            

                            
modified group metrics : what changed ?

                            

                            
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