DELETE FROM "HREMPLOYEE" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("EMP_NO" = :Original_EMP_NO)) INSERT INTO "HREMPLOYEE" ("COOP_ID", "EMP_NO", "EMP_ENAME", "EMP_ESURNAME", "EMP_NICKNAME", "BLOOD_GRP", "WEIGHT", "HEIGHT", "NATION", "RELIGION", "ADN_NO", "ADN_TAMBOL", "ADN_AMPHUR", "ADN_PROVINCE", "ADN_POSTCODE", "ADN_TEL", "ADN_EMAIL", "ADR_NO", "ADR_TAMBOL", "ADR_AMPHUR", "ADR_PROVINCE", "ADR_POSTCODE", "ID_CARD", "BIRTH_DATE", "WORK_DATE", "RESIGN_DATE", "CONTAIN_DATE", "TERM_DATE", "REF_MEMBNO", "EMP_STATUS") VALUES (:COOP_ID, :EMP_NO, :EMP_ENAME, :EMP_ESURNAME, :EMP_NICKNAME, :BLOOD_GRP, :WEIGHT, :HEIGHT, :NATION, :RELIGION, :ADN_NO, :ADN_TAMBOL, :ADN_AMPHUR, :ADN_PROVINCE, :ADN_POSTCODE, :ADN_TEL, :ADN_EMAIL, :ADR_NO, :ADR_TAMBOL, :ADR_AMPHUR, :ADR_PROVINCE, :ADR_POSTCODE, :ID_CARD, :BIRTH_DATE, :WORK_DATE, :RESIGN_DATE, :CONTAIN_DATE, :TERM_DATE, :REF_MEMBNO, :EMP_STATUS) select hremployee.coop_id, hremployee.emp_no, hremployee.emp_ename, hremployee.emp_esurname, hremployee.emp_nickname, hremployee.blood_grp, hremployee.weight, hremployee.height, hremployee.nation, hremployee.religion, hremployee.adn_no, hremployee.adn_tambol, hremployee.adn_amphur, hremployee.adn_province, hremployee.adn_postcode, hremployee.adn_tel, hremployee.adn_email, hremployee.adr_no, hremployee.adr_tambol, hremployee.adr_amphur, hremployee.adr_province, hremployee.adr_postcode, hremployee.id_card, hremployee.birth_date, hremployee.work_date, hremployee.resign_date, hremployee.contain_date, hremployee.term_date, hremployee.ref_membno, hremployee.emp_status from hremployee UPDATE "HREMPLOYEE" SET "COOP_ID" = :COOP_ID, "EMP_NO" = :EMP_NO, "EMP_ENAME" = :EMP_ENAME, "EMP_ESURNAME" = :EMP_ESURNAME, "EMP_NICKNAME" = :EMP_NICKNAME, "BLOOD_GRP" = :BLOOD_GRP, "WEIGHT" = :WEIGHT, "HEIGHT" = :HEIGHT, "NATION" = :NATION, "RELIGION" = :RELIGION, "ADN_NO" = :ADN_NO, "ADN_TAMBOL" = :ADN_TAMBOL, "ADN_AMPHUR" = :ADN_AMPHUR, "ADN_PROVINCE" = :ADN_PROVINCE, "ADN_POSTCODE" = :ADN_POSTCODE, "ADN_TEL" = :ADN_TEL, "ADN_EMAIL" = :ADN_EMAIL, "ADR_NO" = :ADR_NO, "ADR_TAMBOL" = :ADR_TAMBOL, "ADR_AMPHUR" = :ADR_AMPHUR, "ADR_PROVINCE" = :ADR_PROVINCE, "ADR_POSTCODE" = :ADR_POSTCODE, "ID_CARD" = :ID_CARD, "BIRTH_DATE" = :BIRTH_DATE, "WORK_DATE" = :WORK_DATE, "RESIGN_DATE" = :RESIGN_DATE, "CONTAIN_DATE" = :CONTAIN_DATE, "TERM_DATE" = :TERM_DATE, "REF_MEMBNO" = :REF_MEMBNO, "EMP_STATUS" = :EMP_STATUS WHERE (("COOP_ID" = :Original_COOP_ID) AND ("EMP_NO" = :Original_EMP_NO)) DELETE FROM "HREMPLOYEEFAMILY" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("EMP_NO" = :Original_EMP_NO) AND ("SEQ_NO" = :Original_SEQ_NO)) INSERT INTO "HREMPLOYEEFAMILY" ("COOP_ID", "EMP_NO", "SEQ_NO", "F_NAME", "F_RELATION", "BIRTH_DATE", "OCCUPATION") VALUES (:COOP_ID, :EMP_NO, :SEQ_NO, :F_NAME, :F_RELATION, :BIRTH_DATE, :OCCUPATION) select hremployeefamily.coop_id, hremployeefamily.emp_no, hremployeefamily.seq_no, hremployeefamily.f_name, hremployeefamily.f_relation, hremployeefamily.birth_date, hremployeefamily.occupation from hremployeefamily UPDATE "HREMPLOYEEFAMILY" SET "COOP_ID" = :COOP_ID, "EMP_NO" = :EMP_NO, "SEQ_NO" = :SEQ_NO, "F_NAME" = :F_NAME, "F_RELATION" = :F_RELATION, "BIRTH_DATE" = :BIRTH_DATE, "OCCUPATION" = :OCCUPATION WHERE (("COOP_ID" = :Original_COOP_ID) AND ("EMP_NO" = :Original_EMP_NO) AND ("SEQ_NO" = :Original_SEQ_NO)) DELETE FROM "HREMPLOYEEEDU" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("EMP_NO" = :Original_EMP_NO) AND ("SEQ_NO" = :Original_SEQ_NO)) INSERT INTO "HREMPLOYEEEDU" ("COOP_ID", "EMP_NO", "SEQ_NO", "EDU_LEVEL", "EDU_INST", "EDU_DEGREE", "EDU_MAJOR", "EDU_GPA", "EDU_SUCCYEAR") VALUES (:COOP_ID, :EMP_NO, :SEQ_NO, :EDU_LEVEL, :EDU_INST, :EDU_DEGREE, :EDU_MAJOR, :EDU_GPA, :EDU_SUCCYEAR) select hremployeeedu.coop_id, hremployeeedu.emp_no, hremployeeedu.seq_no, hremployeeedu.edu_level, hremployeeedu.edu_inst, hremployeeedu.edu_degree, hremployeeedu.edu_major, hremployeeedu.edu_gpa, hremployeeedu.edu_succyear from hremployeeedu UPDATE "HREMPLOYEEEDU" SET "COOP_ID" = :COOP_ID, "EMP_NO" = :EMP_NO, "SEQ_NO" = :SEQ_NO, "EDU_LEVEL" = :EDU_LEVEL, "EDU_INST" = :EDU_INST, "EDU_DEGREE" = :EDU_DEGREE, "EDU_MAJOR" = :EDU_MAJOR, "EDU_GPA" = :EDU_GPA, "EDU_SUCCYEAR" = :EDU_SUCCYEAR WHERE (("COOP_ID" = :Original_COOP_ID) AND ("EMP_NO" = :Original_EMP_NO) AND ("SEQ_NO" = :Original_SEQ_NO)) DELETE FROM "HREMPLOYEEEXPERIENCE" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("EMP_NO" = :Original_EMP_NO) AND ("SEQ_NO" = :Original_SEQ_NO)) INSERT INTO "HREMPLOYEEEXPERIENCE" ("COOP_ID", "EMP_NO", "SEQ_NO", "CORP_NAME", "POS_NAME", "YEARSTART", "YEAREND", "LAST_SALARY", "JOB_TYPE", "JOB_DESC", "AWAYCAUSE", "REMARK") VALUES (:COOP_ID, :EMP_NO, :SEQ_NO, :CORP_NAME, :POS_NAME, :YEARSTART, :YEAREND, :LAST_SALARY, :JOB_TYPE, :JOB_DESC, :AWAYCAUSE, :REMARK) select hremployeeexperience.coop_id, hremployeeexperience.emp_no, hremployeeexperience.seq_no, hremployeeexperience.corp_name, hremployeeexperience.pos_name, hremployeeexperience.yearstart, hremployeeexperience.yearend, hremployeeexperience.last_salary, hremployeeexperience.job_type, hremployeeexperience.job_desc, hremployeeexperience.awaycause, hremployeeexperience.remark from hremployeeexperience UPDATE "HREMPLOYEEEXPERIENCE" SET "COOP_ID" = :COOP_ID, "EMP_NO" = :EMP_NO, "SEQ_NO" = :SEQ_NO, "CORP_NAME" = :CORP_NAME, "POS_NAME" = :POS_NAME, "YEARSTART" = :YEARSTART, "YEAREND" = :YEAREND, "LAST_SALARY" = :LAST_SALARY, "JOB_TYPE" = :JOB_TYPE, "JOB_DESC" = :JOB_DESC, "AWAYCAUSE" = :AWAYCAUSE, "REMARK" = :REMARK WHERE (("COOP_ID" = :Original_COOP_ID) AND ("EMP_NO" = :Original_EMP_NO) AND ("SEQ_NO" = :Original_SEQ_NO)) DELETE FROM "HREMPLOYEETRAINING" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("EMP_NO" = :Original_EMP_NO) AND ("SEQ_NO" = :Original_SEQ_NO)) INSERT INTO "HREMPLOYEETRAINING" ("COOP_ID", "EMP_NO", "SEQ_NO", "TR_DATE", "TR_CODE", "TR_SUBJECT", "TR_CAUSE", "TR_LOCATION", "TR_INSTITUTION", "TR_FROMDATE", "TR_TODATE", "TR_DAY", "TR_EXPAMT", "TR_CERTDESC", "REMARK") VALUES (:COOP_ID, :EMP_NO, :SEQ_NO, :TR_DATE, :TR_CODE, :TR_SUBJECT, :TR_CAUSE, :TR_LOCATION, :TR_INSTITUTION, :TR_FROMDATE, :TR_TODATE, :TR_DAY, :TR_EXPAMT, :TR_CERTDESC, :REMARK) select hremployeetraining.coop_id, hremployeetraining.emp_no, hremployeetraining.seq_no, hremployeetraining.tr_date, hremployeetraining.tr_code, hremployeetraining.tr_subject, hremployeetraining.tr_cause, hremployeetraining.tr_location, hremployeetraining.tr_institution, hremployeetraining.tr_fromdate, hremployeetraining.tr_todate, hremployeetraining.tr_day, hremployeetraining.tr_expamt, hremployeetraining.tr_certdesc, hremployeetraining.remark from hremployeetraining UPDATE "HREMPLOYEETRAINING" SET "COOP_ID" = :COOP_ID, "EMP_NO" = :EMP_NO, "SEQ_NO" = :SEQ_NO, "TR_DATE" = :TR_DATE, "TR_CODE" = :TR_CODE, "TR_SUBJECT" = :TR_SUBJECT, "TR_CAUSE" = :TR_CAUSE, "TR_LOCATION" = :TR_LOCATION, "TR_INSTITUTION" = :TR_INSTITUTION, "TR_FROMDATE" = :TR_FROMDATE, "TR_TODATE" = :TR_TODATE, "TR_DAY" = :TR_DAY, "TR_EXPAMT" = :TR_EXPAMT, "TR_CERTDESC" = :TR_CERTDESC, "REMARK" = :REMARK WHERE (("COOP_ID" = :Original_COOP_ID) AND ("EMP_NO" = :Original_EMP_NO) AND ("SEQ_NO" = :Original_SEQ_NO)) DELETE FROM "HREMPLOYEEASSIST" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("EMP_NO" = :Original_EMP_NO) AND ("SEQ_NO" = :Original_SEQ_NO)) INSERT INTO "HREMPLOYEEASSIST" ("COOP_ID", "EMP_NO", "SEQ_NO", "ASSIST_CODE", "ASSIST_DATE", "ASSIST_DESC", "ASSIST_AMT", "ASSIST_REMARK") VALUES (:COOP_ID, :EMP_NO, :SEQ_NO, :ASSIST_CODE, :ASSIST_DATE, :ASSIST_DESC, :ASSIST_AMT, :ASSIST_REMARK) select hremployeeassist.coop_id, hremployeeassist.emp_no, hremployeeassist.seq_no, hremployeeassist.assist_code, hremployeeassist.assist_date, hremployeeassist.assist_desc, hremployeeassist.assist_amt, hremployeeassist.assist_remark from hremployeeassist UPDATE "HREMPLOYEEASSIST" SET "COOP_ID" = :COOP_ID, "EMP_NO" = :EMP_NO, "SEQ_NO" = :SEQ_NO, "ASSIST_CODE" = :ASSIST_CODE, "ASSIST_DATE" = :ASSIST_DATE, "ASSIST_DESC" = :ASSIST_DESC, "ASSIST_AMT" = :ASSIST_AMT, "ASSIST_REMARK" = :ASSIST_REMARK WHERE (("COOP_ID" = :Original_COOP_ID) AND ("EMP_NO" = :Original_EMP_NO) AND ("SEQ_NO" = :Original_SEQ_NO)) DELETE FROM "HREMPLOYEE" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("EMP_NO" = :Original_EMP_NO)) INSERT INTO "HREMPLOYEE" ("COOP_ID", "EMP_NO", "SALARY_ID", "EMPTYPE_CODE", "SEX", "POS_CODE", "DEPTGRP_CODE", "PRENAME_CODE", "EMP_NAME", "EMP_SURNAME") VALUES (:COOP_ID, :EMP_NO, :SALARY_ID, :EMPTYPE_CODE, :SEX, :POS_CODE, :DEPTGRP_CODE, :PRENAME_CODE, :EMP_NAME, :EMP_SURNAME) select coop_id ,emp_no ,salary_id ,emptype_code ,sex ,pos_code ,deptgrp_code ,prename_code ,emp_name ,emp_surname from hremployee UPDATE "HREMPLOYEE" SET "COOP_ID" = :COOP_ID, "EMP_NO" = :EMP_NO, "SALARY_ID" = :SALARY_ID, "EMPTYPE_CODE" = :EMPTYPE_CODE, "SEX" = :SEX, "POS_CODE" = :POS_CODE, "DEPTGRP_CODE" = :DEPTGRP_CODE, "PRENAME_CODE" = :PRENAME_CODE, "EMP_NAME" = :EMP_NAME, "EMP_SURNAME" = :EMP_SURNAME WHERE (("COOP_ID" = :Original_COOP_ID) AND ("EMP_NO" = :Original_EMP_NO)) DELETE FROM "HREMPLOYEE" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("EMP_NO" = :Original_EMP_NO)) INSERT INTO "HREMPLOYEE" ("COOP_ID", "EMP_NO", "SALARY_AMT", "SALEXP_CODE", "SALEXP_BANK", "SALEXP_BRANCH", "SALEXP_ACCID", "TAX_CALCODE", "TAX_BFAMT", "SS_STATUS", "SS_APPFIRSTSTS", "SS_BFAMT", "SS_APPDATE", "SS_RATE", "SS_HOSPITAL", "PROVF_STATUS", "PROVF_CORPRATE", "PROVF_EMPRATE", "PROVF_APPDATE", "PROVF_RESIGNDATE", "PROVF_BFAMT") VALUES (:COOP_ID, :EMP_NO, :SALARY_AMT, :SALEXP_CODE, :SALEXP_BANK, :SALEXP_BRANCH, :SALEXP_ACCID, :TAX_CALCODE, :TAX_BFAMT, :SS_STATUS, :SS_APPFIRSTSTS, :SS_BFAMT, :SS_APPDATE, :SS_RATE, :SS_HOSPITAL, :PROVF_STATUS, :PROVF_CORPRATE, :PROVF_EMPRATE, :PROVF_APPDATE, :PROVF_RESIGNDATE, :PROVF_BFAMT) select hremployee.coop_id, hremployee.emp_no, hremployee.salary_amt, hremployee.salexp_code, hremployee.salexp_bank, hremployee.salexp_branch, hremployee.salexp_accid, hremployee.tax_calcode, hremployee.tax_bfamt, hremployee.ss_status, hremployee.ss_appfirststs, hremployee.ss_bfamt, hremployee.ss_appdate, hremployee.ss_rate, hremployee.ss_hospital, hremployee.provf_status, hremployee.provf_corprate, hremployee.provf_emprate, hremployee.provf_appdate, hremployee.provf_resigndate, hremployee.provf_bfamt from hremployee UPDATE "HREMPLOYEE" SET "COOP_ID" = :COOP_ID, "EMP_NO" = :EMP_NO, "SALARY_AMT" = :SALARY_AMT, "SALEXP_CODE" = :SALEXP_CODE, "SALEXP_BANK" = :SALEXP_BANK, "SALEXP_BRANCH" = :SALEXP_BRANCH, "SALEXP_ACCID" = :SALEXP_ACCID, "TAX_CALCODE" = :TAX_CALCODE, "TAX_BFAMT" = :TAX_BFAMT, "SS_STATUS" = :SS_STATUS, "SS_APPFIRSTSTS" = :SS_APPFIRSTSTS, "SS_BFAMT" = :SS_BFAMT, "SS_APPDATE" = :SS_APPDATE, "SS_RATE" = :SS_RATE, "SS_HOSPITAL" = :SS_HOSPITAL, "PROVF_STATUS" = :PROVF_STATUS, "PROVF_CORPRATE" = :PROVF_CORPRATE, "PROVF_EMPRATE" = :PROVF_EMPRATE, "PROVF_APPDATE" = :PROVF_APPDATE, "PROVF_RESIGNDATE" = :PROVF_RESIGNDATE, "PROVF_BFAMT" = :PROVF_BFAMT WHERE (("COOP_ID" = :Original_COOP_ID) AND ("EMP_NO" = :Original_EMP_NO)) INSERT INTO "ISCOGSB"."HRGARANTEE" ("COOP_ID", "EMP_NO", "SEQ_NO", "GARAN_NAME", "GARAN_SURNAME", "GARAN_BIRTH", "GARAN_WORK", "GARAN_TEL", "GARAN_AGE") VALUES (:COOP_ID, :EMP_NO, :SEQ_NO, :GARAN_NAME, :GARAN_SURNAME, :GARAN_BIRTH, :GARAN_WORK, :GARAN_TEL, :GARAN_AGE) SELECT COOP_ID, EMP_NO, SEQ_NO, GARAN_NAME, GARAN_SURNAME, GARAN_BIRTH, GARAN_WORK, GARAN_TEL, GARAN_AGE FROM ISCOGSB.HRGARANTEE INSERT INTO "ISCOGSB"."HRLOGLEAVE" ("COOP_ID", "EMP_NO", "SEQ_NO", "OPERATE_DATE", "LEAVE_CODE", "LEAVE_FROM", "LEAVE_TO", "TOTALDAY", "TOTALTIME", "LEAVE_CAUSE", "LEAVE_TEL", "LEAVE_PLACE", "APV_STATUS", "APV_DATE", "APV_REMARK", "APV_BYCODE", "LAST_TIME", "START_TIME") VALUES (:COOP_ID, :EMP_NO, :SEQ_NO, :OPERATE_DATE, :LEAVE_CODE, :LEAVE_FROM, :LEAVE_TO, :TOTALDAY, :TOTALTIME, :LEAVE_CAUSE, :LEAVE_TEL, :LEAVE_PLACE, :APV_STATUS, :APV_DATE, :APV_REMARK, :APV_BYCODE, :LAST_TIME, :START_TIME) SELECT COOP_ID, EMP_NO, SEQ_NO, OPERATE_DATE, LEAVE_CODE, LEAVE_FROM, LEAVE_TO, TOTALDAY, TOTALTIME, LEAVE_CAUSE, LEAVE_TEL, LEAVE_PLACE, APV_STATUS, APV_DATE, APV_REMARK, APV_BYCODE, LAST_TIME, START_TIME FROM ISCOGSB.HRLOGLEAVE INSERT INTO "ISCOGSB"."HRLOGCHANGEWORK" ("COOP_ID", "EMP_NO", "SEQ_NO", "DEPTGRP_CODE", "POS_CODE", "SALARY_AMT", "OLD_DEPTGRP_CODE", "OLD_POS_CODE", "OLD_SALARY_AMT", "ORDER_DOCNO", "START_DATE", "ORDER_DATE") VALUES (:COOP_ID, :EMP_NO, :SEQ_NO, :DEPTGRP_CODE, :POS_CODE, :SALARY_AMT, :OLD_DEPTGRP_CODE, :OLD_POS_CODE, :OLD_SALARY_AMT, :ORDER_DOCNO, :START_DATE, :ORDER_DATE) SELECT COOP_ID, EMP_NO, SEQ_NO, DEPTGRP_CODE, POS_CODE, SALARY_AMT, OLD_DEPTGRP_CODE, OLD_POS_CODE, OLD_SALARY_AMT, ORDER_DOCNO, START_DATE, ORDER_DATE FROM ISCOGSB.HRLOGCHANGEWORK