CREATE TABLE `hr_asg_mst` ( `EMP_ID` DECIMAL(22,0) NOT NULL COMMENT '사원ID', `EFFCT_STRT_DATE` VARCHAR(8) NOT NULL COMMENT '유효시작일자' COLLATE 'utf8mb4_bin', `EFFCT_END_DATE` VARCHAR(8) NOT NULL COMMENT '유효종료일자' COLLATE 'utf8mb4_bin', `EMP_NO` VARCHAR(30) NULL DEFAULT NULL COMMENT '사원번호' COLLATE 'utf8mb4_bin', `EMP_STAT_CD` VARCHAR(30) NULL DEFAULT NULL COMMENT '재직상태' COLLATE 'utf8mb4_bin', `EMP_TYPE` VARCHAR(30) NULL DEFAULT NULL COMMENT '사원유형' COLLATE 'utf8mb4_bin', `HR_BIZPLC_CD` VARCHAR(30) NULL DEFAULT NULL COMMENT '인사사업장코드' COLLATE 'utf8mb4_bin', `ORG_ID` DECIMAL(22,0) NULL DEFAULT NULL COMMENT '조직ID', `JOB_TITLE_CD` VARCHAR(30) NULL DEFAULT NULL COMMENT '직위코드' COLLATE 'utf8mb4_bin', `JOB_TITLE_SENIORITY` DECIMAL(10,0) NULL DEFAULT NULL COMMENT '직위년차', `JOB_GRADE_CD` VARCHAR(30) NULL DEFAULT NULL COMMENT '직급코드' COLLATE 'utf8mb4_bin', `JOB_GRADE_SENIORITY` DECIMAL(10,0) NULL DEFAULT NULL COMMENT '직급년차', `POSITION_CD` VARCHAR(30) NULL DEFAULT NULL COMMENT '직책코드' COLLATE 'utf8mb4_bin', `JOB_ID` DECIMAL(22,0) NULL DEFAULT NULL COMMENT 'JOB_ID', `JOB_GRP_CD` VARCHAR(30) NULL DEFAULT NULL COMMENT '직군코드' COLLATE 'utf8mb4_bin', `JOB_SRS_CD` VARCHAR(30) NULL DEFAULT NULL COMMENT '직렬코드' COLLATE 'utf8mb4_bin', `JOB_CD` VARCHAR(30) NULL DEFAULT NULL COMMENT '직무코드' COLLATE 'utf8mb4_bin', `PRBTNR_YN` VARCHAR(30) NULL DEFAULT NULL COMMENT '수습여부' COLLATE 'utf8mb4_bin', `FSE_YN` VARCHAR(1) NULL DEFAULT NULL COMMENT '주재원여부' COLLATE 'utf8mb4_bin', `ORIG_ORG_ID` DECIMAL(22,0) NULL DEFAULT NULL COMMENT '파견조직ID', `AU_CD` VARCHAR(22) NULL DEFAULT NULL COMMENT '회계단위코드' COLLATE 'utf8mb4_bin', `DEPT_CD` VARCHAR(22) NULL DEFAULT NULL COMMENT '부서코드' COLLATE 'utf8mb4_bin', `LCTN_CD` VARCHAR(30) NULL DEFAULT NULL COMMENT '위치코드' COLLATE 'utf8mb4_bin', `COMP_CD` VARCHAR(30) NOT NULL COMMENT '회사코드' COLLATE 'utf8mb4_bin', `CRT_ID` DECIMAL(22,0) NOT NULL COMMENT '생성자ID', `CRT_DT` VARCHAR(14) NOT NULL COMMENT '생성일시' COLLATE 'utf8mb4_bin', `UPDT_ID` DECIMAL(22,0) NOT NULL COMMENT '수정자ID', `UPDT_DT` VARCHAR(14) NOT NULL COMMENT '수정일시' COLLATE 'utf8mb4_bin', `LOCK_SEQ` DECIMAL(10,0) NOT NULL COMMENT 'LOCK_SEQ', `FAC_TYPE` VARCHAR(30) NULL DEFAULT NULL COMMENT 'FAC_유형' COLLATE 'utf8mb4_bin', `ATTR1` VARCHAR(300) NULL DEFAULT NULL COMMENT '예비속성1' COLLATE 'utf8mb4_bin', `ATTR2` VARCHAR(300) NULL DEFAULT NULL COMMENT '예비속성2' COLLATE 'utf8mb4_bin', `ATTR3` VARCHAR(300) NULL DEFAULT NULL COMMENT '예비속성3' COLLATE 'utf8mb4_bin', `ATTR4` VARCHAR(300) NULL DEFAULT NULL COMMENT '예비속성4' COLLATE 'utf8mb4_bin', `ATTR5` VARCHAR(300) NULL DEFAULT NULL COMMENT '예비속성5' COLLATE 'utf8mb4_bin', `ATTR6` VARCHAR(300) NULL DEFAULT NULL COMMENT '예비속성6' COLLATE 'utf8mb4_bin', `ATTR7` VARCHAR(300) NULL DEFAULT NULL COMMENT '예비속성7' COLLATE 'utf8mb4_bin', `ATTR8` VARCHAR(300) NULL DEFAULT NULL COMMENT '예비속성8' COLLATE 'utf8mb4_bin', `ATTR9` VARCHAR(300) NULL DEFAULT NULL COMMENT '예비속성9' COLLATE 'utf8mb4_bin', `ATTR10` VARCHAR(300) NULL DEFAULT NULL COMMENT '예비속성10' COLLATE 'utf8mb4_bin', `ATTR11` VARCHAR(300) NULL DEFAULT NULL COMMENT '예비속성11' COLLATE 'utf8mb4_bin', `ATTR12` VARCHAR(300) NULL DEFAULT NULL COMMENT '예비속성12' COLLATE 'utf8mb4_bin', `ATTR13` VARCHAR(300) NULL DEFAULT NULL COMMENT '예비속성13' COLLATE 'utf8mb4_bin', `ATTR14` VARCHAR(300) NULL DEFAULT NULL COMMENT '예비속성14' COLLATE 'utf8mb4_bin', `ATTR15` VARCHAR(300) NULL DEFAULT NULL COMMENT '예비속성15' COLLATE 'utf8mb4_bin', `ATTR16` VARCHAR(300) NULL DEFAULT NULL COMMENT '예비속성16' COLLATE 'utf8mb4_bin', `ATTR17` VARCHAR(300) NULL DEFAULT NULL COMMENT '예비속성17' COLLATE 'utf8mb4_bin', `ATTR18` VARCHAR(300) NULL DEFAULT NULL COMMENT '예비속성18' COLLATE 'utf8mb4_bin', `ATTR19` VARCHAR(300) NULL DEFAULT NULL COMMENT '예비속성19' COLLATE 'utf8mb4_bin', `ATTR20` VARCHAR(300) NULL DEFAULT NULL COMMENT '예비속성20' COLLATE 'utf8mb4_bin', `ATTR21` VARCHAR(300) NULL DEFAULT NULL COMMENT '예비속성21' COLLATE 'utf8mb4_bin', `ATTR22` VARCHAR(300) NULL DEFAULT NULL COMMENT '예비속성22' COLLATE 'utf8mb4_bin', `ATTR23` VARCHAR(300) NULL DEFAULT NULL COMMENT '예비속성23' COLLATE 'utf8mb4_bin', `ATTR24` VARCHAR(300) NULL DEFAULT NULL COMMENT '예비속성24' COLLATE 'utf8mb4_bin', `ATTR25` VARCHAR(300) NULL DEFAULT NULL COMMENT '예비속성25' COLLATE 'utf8mb4_bin', `ATTR26` VARCHAR(300) NULL DEFAULT NULL COMMENT '예비속성26' COLLATE 'utf8mb4_bin', `ATTR27` VARCHAR(300) NULL DEFAULT NULL COMMENT '예비속성27' COLLATE 'utf8mb4_bin', `ATTR28` VARCHAR(300) NULL DEFAULT NULL COMMENT '예비속성28' COLLATE 'utf8mb4_bin', `ATTR29` VARCHAR(300) NULL DEFAULT NULL COMMENT '예비속성29' COLLATE 'utf8mb4_bin', `ATTR30` VARCHAR(300) NULL DEFAULT NULL COMMENT '예비속성30' COLLATE 'utf8mb4_bin', PRIMARY KEY (`EMP_ID`, `EFFCT_STRT_DATE`), INDEX `HR_ASG_MST_N01` (`COMP_CD`, `ORG_ID`) ) COLLATE='utf8mb4_bin' ENGINE=InnoDB ; INSERT INTO `hr_asg_mst` (`EMP_ID`, `EFFCT_STRT_DATE`, `EFFCT_END_DATE`, `EMP_NO`, `EMP_STAT_CD`, `EMP_TYPE`, `HR_BIZPLC_CD`, `ORG_ID`, `JOB_TITLE_CD`, `JOB_TITLE_SENIORITY`, `JOB_GRADE_CD`, `JOB_GRADE_SENIORITY`, `POSITION_CD`, `JOB_ID`, `JOB_GRP_CD`, `JOB_SRS_CD`, `JOB_CD`, `PRBTNR_YN`, `FSE_YN`, `ORIG_ORG_ID`, `AU_CD`, `DEPT_CD`, `LCTN_CD`, `COMP_CD`, `CRT_ID`, `CRT_DT`, `UPDT_ID`, `UPDT_DT`, `LOCK_SEQ`, `FAC_TYPE`) VALUES (1, '20100726', '99991231', '10001', 'C', 'STAFF', 'A01', 95, 'BBA', NULL, 'BBA', NULL, 'F10', NULL, 'ADM', NULL, NULL, 'N', 'N', NULL, NULL, NULL, 'K001', '1000', 0, '20160302000000', 0, '20160302000000', 0, NULL); INSERT INTO `hr_asg_mst` (`EMP_ID`, `EFFCT_STRT_DATE`, `EFFCT_END_DATE`, `EMP_NO`, `EMP_STAT_CD`, `EMP_TYPE`, `HR_BIZPLC_CD`, `ORG_ID`, `JOB_TITLE_CD`, `JOB_TITLE_SENIORITY`, `JOB_GRADE_CD`, `JOB_GRADE_SENIORITY`, `POSITION_CD`, `JOB_ID`, `JOB_GRP_CD`, `JOB_SRS_CD`, `JOB_CD`, `PRBTNR_YN`, `FSE_YN`, `ORIG_ORG_ID`, `AU_CD`, `DEPT_CD`, `LCTN_CD`, `COMP_CD`, `CRT_ID`, `CRT_DT`, `UPDT_ID`, `UPDT_DT`, `LOCK_SEQ`, `FAC_TYPE`) VALUES (9006, '20151201', '99991231', '619000', 'C', 'EXEC', 'A01', 94, 'ACA', NULL, 'ACA', NULL, 'A00', NULL, NULL, NULL, NULL, 'N', 'N', NULL, NULL, NULL, 'K001', '1000', 1, '20160810000000', 1, '2016081000000', 1, NULL); INSERT INTO `hr_asg_mst` (`EMP_ID`, `EFFCT_STRT_DATE`, `EFFCT_END_DATE`, `EMP_NO`, `EMP_STAT_CD`, `EMP_TYPE`, `HR_BIZPLC_CD`, `ORG_ID`, `JOB_TITLE_CD`, `JOB_TITLE_SENIORITY`, `JOB_GRADE_CD`, `JOB_GRADE_SENIORITY`, `POSITION_CD`, `JOB_ID`, `JOB_GRP_CD`, `JOB_SRS_CD`, `JOB_CD`, `PRBTNR_YN`, `FSE_YN`, `ORIG_ORG_ID`, `AU_CD`, `DEPT_CD`, `LCTN_CD`, `COMP_CD`, `CRT_ID`, `CRT_DT`, `UPDT_ID`, `UPDT_DT`, `LOCK_SEQ`, `FAC_TYPE`) VALUES (9025, '20160801', '99991231', '938400', 'C', 'STAFF', 'A01', 503, NULL, NULL, 'BBA', NULL, 'F10', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1200', '21000', NULL, '1000', 99999, '20160817150645', 99999, '20160817150645', 1, NULL); INSERT INTO `hr_asg_mst` (`EMP_ID`, `EFFCT_STRT_DATE`, `EFFCT_END_DATE`, `EMP_NO`, `EMP_STAT_CD`, `EMP_TYPE`, `HR_BIZPLC_CD`, `ORG_ID`, `JOB_TITLE_CD`, `JOB_TITLE_SENIORITY`, `JOB_GRADE_CD`, `JOB_GRADE_SENIORITY`, `POSITION_CD`, `JOB_ID`, `JOB_GRP_CD`, `JOB_SRS_CD`, `JOB_CD`, `PRBTNR_YN`, `FSE_YN`, `ORIG_ORG_ID`, `AU_CD`, `DEPT_CD`, `LCTN_CD`, `COMP_CD`, `CRT_ID`, `CRT_DT`, `UPDT_ID`, `UPDT_DT`, `LOCK_SEQ`, `FAC_TYPE`) VALUES (9026, '20160101', '20160909', '123456', 'T', 'STAFF', 'A01', 503, NULL, NULL, 'BBA', NULL, 'F10', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1200', '21000', NULL, '1000', 99999, '20160817152035', 99999, '20160909211035', 5, NULL); INSERT INTO `hr_asg_mst` (`EMP_ID`, `EFFCT_STRT_DATE`, `EFFCT_END_DATE`, `EMP_NO`, `EMP_STAT_CD`, `EMP_TYPE`, `HR_BIZPLC_CD`, `ORG_ID`, `JOB_TITLE_CD`, `JOB_TITLE_SENIORITY`, `JOB_GRADE_CD`, `JOB_GRADE_SENIORITY`, `POSITION_CD`, `JOB_ID`, `JOB_GRP_CD`, `JOB_SRS_CD`, `JOB_CD`, `PRBTNR_YN`, `FSE_YN`, `ORIG_ORG_ID`, `AU_CD`, `DEPT_CD`, `LCTN_CD`, `COMP_CD`, `CRT_ID`, `CRT_DT`, `UPDT_ID`, `UPDT_DT`, `LOCK_SEQ`, `FAC_TYPE`) VALUES (9028, '20160101', '99991231', '100002', 'C', 'STAFF', 'A01', 503, NULL, NULL, 'BBA', NULL, 'F10', NULL, NULL, NULL, 'JR200', NULL, NULL, NULL, '1200', '21000', NULL, '1000', 99999, '20160818105113', 99999, '20160818105113', 1, NULL); INSERT INTO `hr_asg_mst` (`EMP_ID`, `EFFCT_STRT_DATE`, `EFFCT_END_DATE`, `EMP_NO`, `EMP_STAT_CD`, `EMP_TYPE`, `HR_BIZPLC_CD`, `ORG_ID`, `JOB_TITLE_CD`, `JOB_TITLE_SENIORITY`, `JOB_GRADE_CD`, `JOB_GRADE_SENIORITY`, `POSITION_CD`, `JOB_ID`, `JOB_GRP_CD`, `JOB_SRS_CD`, `JOB_CD`, `PRBTNR_YN`, `FSE_YN`, `ORIG_ORG_ID`, `AU_CD`, `DEPT_CD`, `LCTN_CD`, `COMP_CD`, `CRT_ID`, `CRT_DT`, `UPDT_ID`, `UPDT_DT`, `LOCK_SEQ`, `FAC_TYPE`) VALUES (9050, '20160822', '99991231', '100024', 'C', NULL, NULL, 94, NULL, NULL, 'BBA', NULL, 'F10', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1000', 1, '20160822104632', 1, '20160822104632', 1, NULL); INSERT INTO `hr_asg_mst` (`EMP_ID`, `EFFCT_STRT_DATE`, `EFFCT_END_DATE`, `EMP_NO`, `EMP_STAT_CD`, `EMP_TYPE`, `HR_BIZPLC_CD`, `ORG_ID`, `JOB_TITLE_CD`, `JOB_TITLE_SENIORITY`, `JOB_GRADE_CD`, `JOB_GRADE_SENIORITY`, `POSITION_CD`, `JOB_ID`, `JOB_GRP_CD`, `JOB_SRS_CD`, `JOB_CD`, `PRBTNR_YN`, `FSE_YN`, `ORIG_ORG_ID`, `AU_CD`, `DEPT_CD`, `LCTN_CD`, `COMP_CD`, `CRT_ID`, `CRT_DT`, `UPDT_ID`, `UPDT_DT`, `LOCK_SEQ`, `FAC_TYPE`) VALUES (9057, '19950101', '20160516', '100031', 'T', 'STAFF', 'A01', 97, 'BBA', 20, 'BBA', 20, NULL, NULL, NULL, NULL, NULL, 'N', 'N', NULL, NULL, NULL, NULL, '1000', 99999, '20160822151708', 99999, '20160822152429', 2, NULL); INSERT INTO `hr_asg_mst` (`EMP_ID`, `EFFCT_STRT_DATE`, `EFFCT_END_DATE`, `EMP_NO`, `EMP_STAT_CD`, `EMP_TYPE`, `HR_BIZPLC_CD`, `ORG_ID`, `JOB_TITLE_CD`, `JOB_TITLE_SENIORITY`, `JOB_GRADE_CD`, `JOB_GRADE_SENIORITY`, `POSITION_CD`, `JOB_ID`, `JOB_GRP_CD`, `JOB_SRS_CD`, `JOB_CD`, `PRBTNR_YN`, `FSE_YN`, `ORIG_ORG_ID`, `AU_CD`, `DEPT_CD`, `LCTN_CD`, `COMP_CD`, `CRT_ID`, `CRT_DT`, `UPDT_ID`, `UPDT_DT`, `LOCK_SEQ`, `FAC_TYPE`) VALUES (9058, '20160801', '20160909', '100032', 'T', 'STAFF', 'A01', 509, 'BBA', NULL, 'BBA', NULL, 'F10', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1000', 1, '20160822151945', 99999, '20160909165850', 2, NULL); INSERT INTO `hr_asg_mst` (`EMP_ID`, `EFFCT_STRT_DATE`, `EFFCT_END_DATE`, `EMP_NO`, `EMP_STAT_CD`, `EMP_TYPE`, `HR_BIZPLC_CD`, `ORG_ID`, `JOB_TITLE_CD`, `JOB_TITLE_SENIORITY`, `JOB_GRADE_CD`, `JOB_GRADE_SENIORITY`, `POSITION_CD`, `JOB_ID`, `JOB_GRP_CD`, `JOB_SRS_CD`, `JOB_CD`, `PRBTNR_YN`, `FSE_YN`, `ORIG_ORG_ID`, `AU_CD`, `DEPT_CD`, `LCTN_CD`, `COMP_CD`, `CRT_ID`, `CRT_DT`, `UPDT_ID`, `UPDT_DT`, `LOCK_SEQ`, `FAC_TYPE`) VALUES (9059, '20160801', '99991231', '100033', 'C', 'STAFF', 'A01', 102, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1000', 1, '20160822152103', 1, '20160822152103', 1, NULL); INSERT INTO `hr_asg_mst` (`EMP_ID`, `EFFCT_STRT_DATE`, `EFFCT_END_DATE`, `EMP_NO`, `EMP_STAT_CD`, `EMP_TYPE`, `HR_BIZPLC_CD`, `ORG_ID`, `JOB_TITLE_CD`, `JOB_TITLE_SENIORITY`, `JOB_GRADE_CD`, `JOB_GRADE_SENIORITY`, `POSITION_CD`, `JOB_ID`, `JOB_GRP_CD`, `JOB_SRS_CD`, `JOB_CD`, `PRBTNR_YN`, `FSE_YN`, `ORIG_ORG_ID`, `AU_CD`, `DEPT_CD`, `LCTN_CD`, `COMP_CD`, `CRT_ID`, `CRT_DT`, `UPDT_ID`, `UPDT_DT`, `LOCK_SEQ`, `FAC_TYPE`) VALUES (9065, '20160801', '99991231', '100039', 'C', 'STAFF', 'A01', 503, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1200', '21000', NULL, '1000', 99999, '20160823190533', 99999, '20160823190533', 1, NULL); INSERT INTO `hr_asg_mst` (`EMP_ID`, `EFFCT_STRT_DATE`, `EFFCT_END_DATE`, `EMP_NO`, `EMP_STAT_CD`, `EMP_TYPE`, `HR_BIZPLC_CD`, `ORG_ID`, `JOB_TITLE_CD`, `JOB_TITLE_SENIORITY`, `JOB_GRADE_CD`, `JOB_GRADE_SENIORITY`, `POSITION_CD`, `JOB_ID`, `JOB_GRP_CD`, `JOB_SRS_CD`, `JOB_CD`, `PRBTNR_YN`, `FSE_YN`, `ORIG_ORG_ID`, `AU_CD`, `DEPT_CD`, `LCTN_CD`, `COMP_CD`, `CRT_ID`, `CRT_DT`, `UPDT_ID`, `UPDT_DT`, `LOCK_SEQ`, `FAC_TYPE`) VALUES (9069, '20160101', '99991231', '100043', 'C', 'STAFF', 'A01', 503, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1200', '21000', NULL, '1000', 99999, '20160823192023', 99999, '20160823192023', 1, NULL); INSERT INTO `hr_asg_mst` (`EMP_ID`, `EFFCT_STRT_DATE`, `EFFCT_END_DATE`, `EMP_NO`, `EMP_STAT_CD`, `EMP_TYPE`, `HR_BIZPLC_CD`, `ORG_ID`, `JOB_TITLE_CD`, `JOB_TITLE_SENIORITY`, `JOB_GRADE_CD`, `JOB_GRADE_SENIORITY`, `POSITION_CD`, `JOB_ID`, `JOB_GRP_CD`, `JOB_SRS_CD`, `JOB_CD`, `PRBTNR_YN`, `FSE_YN`, `ORIG_ORG_ID`, `AU_CD`, `DEPT_CD`, `LCTN_CD`, `COMP_CD`, `CRT_ID`, `CRT_DT`, `UPDT_ID`, `UPDT_DT`, `LOCK_SEQ`, `FAC_TYPE`) VALUES (9072, '20160801', '99991231', '100046', 'C', 'STAFF', 'A01', 102, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1000', 1, '20160824133148', 1, '20160824133148', 1, NULL); INSERT INTO `hr_asg_mst` (`EMP_ID`, `EFFCT_STRT_DATE`, `EFFCT_END_DATE`, `EMP_NO`, `EMP_STAT_CD`, `EMP_TYPE`, `HR_BIZPLC_CD`, `ORG_ID`, `JOB_TITLE_CD`, `JOB_TITLE_SENIORITY`, `JOB_GRADE_CD`, `JOB_GRADE_SENIORITY`, `POSITION_CD`, `JOB_ID`, `JOB_GRP_CD`, `JOB_SRS_CD`, `JOB_CD`, `PRBTNR_YN`, `FSE_YN`, `ORIG_ORG_ID`, `AU_CD`, `DEPT_CD`, `LCTN_CD`, `COMP_CD`, `CRT_ID`, `CRT_DT`, `UPDT_ID`, `UPDT_DT`, `LOCK_SEQ`, `FAC_TYPE`) VALUES (9087, '20160801', '99991231', '100061', 'C', 'STAFF', 'A01', 102, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1000', 1, '20160824141516', 1, '20160824141516', 1, NULL); INSERT INTO `hr_asg_mst` (`EMP_ID`, `EFFCT_STRT_DATE`, `EFFCT_END_DATE`, `EMP_NO`, `EMP_STAT_CD`, `EMP_TYPE`, `HR_BIZPLC_CD`, `ORG_ID`, `JOB_TITLE_CD`, `JOB_TITLE_SENIORITY`, `JOB_GRADE_CD`, `JOB_GRADE_SENIORITY`, `POSITION_CD`, `JOB_ID`, `JOB_GRP_CD`, `JOB_SRS_CD`, `JOB_CD`, `PRBTNR_YN`, `FSE_YN`, `ORIG_ORG_ID`, `AU_CD`, `DEPT_CD`, `LCTN_CD`, `COMP_CD`, `CRT_ID`, `CRT_DT`, `UPDT_ID`, `UPDT_DT`, `LOCK_SEQ`, `FAC_TYPE`) VALUES (9097, '20160101', '99991231', '100071', 'C', 'STAFF', 'A01', 503, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1200', '21000', NULL, '1000', 99999, '20160824165408', 99999, '20160824165408', 1, NULL); INSERT INTO `hr_asg_mst` (`EMP_ID`, `EFFCT_STRT_DATE`, `EFFCT_END_DATE`, `EMP_NO`, `EMP_STAT_CD`, `EMP_TYPE`, `HR_BIZPLC_CD`, `ORG_ID`, `JOB_TITLE_CD`, `JOB_TITLE_SENIORITY`, `JOB_GRADE_CD`, `JOB_GRADE_SENIORITY`, `POSITION_CD`, `JOB_ID`, `JOB_GRP_CD`, `JOB_SRS_CD`, `JOB_CD`, `PRBTNR_YN`, `FSE_YN`, `ORIG_ORG_ID`, `AU_CD`, `DEPT_CD`, `LCTN_CD`, `COMP_CD`, `CRT_ID`, `CRT_DT`, `UPDT_ID`, `UPDT_DT`, `LOCK_SEQ`, `FAC_TYPE`) VALUES (9098, '20160101', '99991231', '100072', 'C', 'STAFF', 'A01', 503, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1200', '21000', NULL, '1000', 99999, '20160824165747', 99999, '20160824165747', 1, NULL); INSERT INTO `hr_asg_mst` (`EMP_ID`, `EFFCT_STRT_DATE`, `EFFCT_END_DATE`, `EMP_NO`, `EMP_STAT_CD`, `EMP_TYPE`, `HR_BIZPLC_CD`, `ORG_ID`, `JOB_TITLE_CD`, `JOB_TITLE_SENIORITY`, `JOB_GRADE_CD`, `JOB_GRADE_SENIORITY`, `POSITION_CD`, `JOB_ID`, `JOB_GRP_CD`, `JOB_SRS_CD`, `JOB_CD`, `PRBTNR_YN`, `FSE_YN`, `ORIG_ORG_ID`, `AU_CD`, `DEPT_CD`, `LCTN_CD`, `COMP_CD`, `CRT_ID`, `CRT_DT`, `UPDT_ID`, `UPDT_DT`, `LOCK_SEQ`, `FAC_TYPE`) VALUES (9115, '20160101', '99991231', '100089', 'C', 'STAFF', 'A01', 503, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1200', '21000', NULL, '1000', 99999, '20160825163815', 99999, '20160825163815', 1, NULL); INSERT INTO `hr_asg_mst` (`EMP_ID`, `EFFCT_STRT_DATE`, `EFFCT_END_DATE`, `EMP_NO`, `EMP_STAT_CD`, `EMP_TYPE`, `HR_BIZPLC_CD`, `ORG_ID`, `JOB_TITLE_CD`, `JOB_TITLE_SENIORITY`, `JOB_GRADE_CD`, `JOB_GRADE_SENIORITY`, `POSITION_CD`, `JOB_ID`, `JOB_GRP_CD`, `JOB_SRS_CD`, `JOB_CD`, `PRBTNR_YN`, `FSE_YN`, `ORIG_ORG_ID`, `AU_CD`, `DEPT_CD`, `LCTN_CD`, `COMP_CD`, `CRT_ID`, `CRT_DT`, `UPDT_ID`, `UPDT_DT`, `LOCK_SEQ`, `FAC_TYPE`) VALUES (9124, '20160829', '99991231', '100098', 'C', NULL, 'A01', 95, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '13110', NULL, '1000', 1, '20160829110231', 1, '20160829110231', 1, NULL); INSERT INTO `hr_asg_mst` (`EMP_ID`, `EFFCT_STRT_DATE`, `EFFCT_END_DATE`, `EMP_NO`, `EMP_STAT_CD`, `EMP_TYPE`, `HR_BIZPLC_CD`, `ORG_ID`, `JOB_TITLE_CD`, `JOB_TITLE_SENIORITY`, `JOB_GRADE_CD`, `JOB_GRADE_SENIORITY`, `POSITION_CD`, `JOB_ID`, `JOB_GRP_CD`, `JOB_SRS_CD`, `JOB_CD`, `PRBTNR_YN`, `FSE_YN`, `ORIG_ORG_ID`, `AU_CD`, `DEPT_CD`, `LCTN_CD`, `COMP_CD`, `CRT_ID`, `CRT_DT`, `UPDT_ID`, `UPDT_DT`, `LOCK_SEQ`, `FAC_TYPE`) VALUES (9165, '20160829', '20160908', '100139', 'O', 'STAFF', 'A01', 510, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '13110', NULL, '1000', 1, '20160831094718', 3, '20160912095053', 2, NULL); INSERT INTO `hr_asg_mst` (`EMP_ID`, `EFFCT_STRT_DATE`, `EFFCT_END_DATE`, `EMP_NO`, `EMP_STAT_CD`, `EMP_TYPE`, `HR_BIZPLC_CD`, `ORG_ID`, `JOB_TITLE_CD`, `JOB_TITLE_SENIORITY`, `JOB_GRADE_CD`, `JOB_GRADE_SENIORITY`, `POSITION_CD`, `JOB_ID`, `JOB_GRP_CD`, `JOB_SRS_CD`, `JOB_CD`, `PRBTNR_YN`, `FSE_YN`, `ORIG_ORG_ID`, `AU_CD`, `DEPT_CD`, `LCTN_CD`, `COMP_CD`, `CRT_ID`, `CRT_DT`, `UPDT_ID`, `UPDT_DT`, `LOCK_SEQ`, `FAC_TYPE`) VALUES (9165, '20160909', '99991231', '100139', 'P', 'STAFF', 'A01', 510, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '13110', NULL, '1000', 1, '20160101000000', 1, '20160912094633', 2, NULL); select * from HR_ASG_MST WHERE EMP_ID = 9165 AND (( '20160901' >= EFFCT_STRT_DATE and '20160901' <= EFFCT_END_DATE ) or ( EFFCT_STRT_DATE > '20160901' )); => 2 rows seleted; UPDATE HR_ASG_MST SET EMP_STAT_CD = 'L', UPDT_ID = '1', UPDT_DT = date_format( now() , '%Y%m%d%H%i%s'), LOCK_SEQ = 2 WHERE EMP_ID = 9165 AND (( '20160901' >= EFFCT_STRT_DATE and '20160901' <= EFFCT_END_DATE ) or ( EFFCT_STRT_DATE > '20160901' ) ) ; => same where clause but just 1 rows update what is problem?