UPDATE t_tctb_yhs_entry SET feffectivedate = fstartdate WHERE feffectivedate IS NULL AND fstartdate IS NOT NULL;

UPDATE t_tctb_yhs_entry SET fexpirydate = fenddate WHERE fexpirydate IS NULL AND fenddate IS NOT NULL;

UPDATE t_tctb_yhs_entry SET fisverify = '1' WHERE fisverify IS NULL OR fisverify = '';