 (16, 2);
 
  -- assign both on library side and flowcell side
-update state set status = "ASSIGNED" where name like '%Assign Library%' and status != 'FINAL';
+update state set status = "COMPLETED" where name like '%Assign Library%' and status != 'FINALIZED';
 
 
 -- BREAK POINT --

-- --
-- simulate illumina qc screen ok

update state set status = "APPROVED" where name like '%Qc Appr%';


-- BREAK POINT --


-- --
-- receive flowcell?
update state set status = "COMPLETED" where name like '%Receiv%' and status != 'FINALIZED';


-- --
