1.UPDATE `raw_file_data_stack` set instr_sub_type =' ' WHERE instr_id ='' ;

2.UPDATE `collection_records`  set instr_sub_type ='' WHERE instr_id =''  ;

3.UPDATE `summary` set subtype1 ='' WHERE instr_id ='' ;

4.UPDATE `instrum` set subtype1 ='',object_ID= WHERE instr_id =''  ;instrum table need to update object_ID too,will get from raw_instr_typestbl

5.UPDATE `instrum_history` set subtype1 ='' WHERE instr_id ='' ;