2015-05-21 15:24:50 yIPz 172.17.64.118 y INFOz SELECT KJ.NAME /*[0]NAME Ҏ*/ ,KJ.KANA_NAME /*[1]KANA_NAME Ji*/ ,FUNC_GET_WAREKI(KJ.BIRTH_DATE) BIRTH_DATE /*[2]BIRTH_DATE N(a)*/ ,FUNC_GET_KANJA_AGE_STR(KJ.BIRTH_DATE,SYSDATE) AGE /*[3]AGE N*/ ,KJ.JITAKU_ZIP /*[4]X֔ԍ*/ ,TO_CHAR(KJ.NYUIN_DATETIME,'YYYY/mm/dd') NYUIN_DATE /*[5]NYUIN_DATE @*/ ,KJ.BYOTO_CODE /*[6]BYOTO_CODE aR[h*/ ,NVL2(KJ.BYOTO_CODE, CM1.NAME, '') BYOTO_NAME /*[7]BYOTO_NAME a*/ ,KJ.ROOM_NO_STR /*[8]ROOM_NO_STR */ ,KJ.SECTION_CODE /*[9]SECTION_CODE fÉȃR[h*/ ,NVL2(KJ.SECTION_CODE, CM2.NAME, '') SECTION_NAME /*[10]SECTION_NAME fÉȖ*/ ,NYUIN_NO /*[11]NYUIN_NO @ԍ*/ ,KJ.JITAKU_JUSHO_01 || KJ.JITAKU_JUSHO_02 JUSHO /*[12]JUSHO Z*/ ,KJ.JITAKU_JUSHO_01 JUSHO_01 /*[13]JUSHO_01 Z1*/ ,KJ.JITAKU_JUSHO_02 JUSHO_02 /*[14]JUSHO_02 Z2*/ FROM KANJA KJ ,COMMON CM1 ,COMMON CM2 WHERE KJ.KANJA_ID = :KANJA_ID AND KJ.CONDITION_FLG = 0 AND KJ.LAST_FLG = 1 AND CM1.CODE(+) = KJ.BYOTO_CODE AND CM1.MASTER_CODE_STR(+) = '00010002' AND CM1.CONDITION_FLG(+) = 0 AND CM1.LAST_FLG(+) = 1 AND CM2.CODE(+) = KJ.SECTION_CODE AND CM2.MASTER_CODE_STR(+) = '00010001' AND CM2.CONDITION_FLG(+) = 0 AND CM2.LAST_FLG(+) = 1 2015-05-21 15:24:50 yIPz 172.17.64.118 y INFOz [:KANJA_ID]:90000108 2015-05-21 15:24:50 yIPz 172.17.64.118 y INFOz SELECT BD.SHINDAN_NAME SHINDAN_NAME /*[0] SHINDAN_NAME ff*/ ,BD.KIMITSU_FLG KIMITSU_FLG /*[1] KIMITSU_FLG @tO*/ ,BD.ICD_CODE_STR ICD_CODE_STR /*[2] ICD_CODE_STR ICDR[h*/ ,BD.KANRI_NO_STR KANRI_NO_STR /*[3] KANRI_NO_STR Ǘԍ*/ FROM BYOMEI_DENPYO BD WHERE BD.KANJA_ID = :KANJA_ID AND BD.LAST_FLG = 1 AND BD.CONDITION_FLG = 0 AND BD.START_DATETIME >= TRUNC(SYSDATE - 7) AND BD.START_DATETIME <= TRUNC(SYSDATE) AND BD.SECTION_CODE = :SECTION_CODE ORDER BY BD.START_DATETIME DESC 2015-05-21 15:24:50 yIPz 172.17.64.118 y INFOz [:KANJA_ID]:90000108 2015-05-21 15:24:50 yIPz 172.17.64.118 y INFOz [:SECTION_CODE]:77 2015-05-21 15:24:50 yIPz 172.17.64.118 y INFOz SELECT CODE /*[0]CODE*/ ,NAME /*[1]NAME*/ ,DISP_ORDER /*[2]DISP_ORDER*/ FROM COMMON WHERE MASTER_CODE_STR = '00010043' AND CONDITION_FLG = 0 AND LAST_FLG = 1 ORDER BY DISP_ORDER 2015-05-21 15:24:50 yIPz 172.17.64.118 y INFOz SELECT CODE /*[0]CODE*/ ,NAME /*[1]NAME*/ ,CODE_01 /*[2]CODE_01*/ ,DISP_ORDER /*[3]DISP_ORDER*/ FROM COMMON WHERE MASTER_CODE_STR = '00010044' AND CONDITION_FLG = 0 AND LAST_FLG = 1 ORDER BY DISP_ORDER 2015-05-21 15:24:50 yIPz 172.17.64.118 y INFOz SELECT CODE /*[0]CODE*/ ,NAME /*[1]NAME*/ ,CODE_01 /*[2]CODE_01*/ ,DISP_ORDER /*[3]DISP_ORDER*/ FROM COMMON WHERE MASTER_CODE_STR = '00010046' AND CONDITION_FLG = 0 AND LAST_FLG = 1 ORDER BY DISP_ORDER 2015-05-21 15:24:50 yIPz 172.17.64.118 y INFOz SELECT CODE /*[0]CODE*/ ,NAME /*[1]NAME*/ FROM COMMON WHERE MASTER_CODE_STR = '00010061' AND CONDITION_FLG = 0 AND LAST_FLG = 1 ORDER BY DISP_ORDER 2015-05-21 15:24:53 yIPz 172.17.64.118 y INFOz SELECT SEQ_KANJA_ER.NEXTVAL FROM DUAL 2015-05-21 15:24:53 yIPz 172.17.64.118 y INFOz INSERT INTO KANJA_ER( POINTER_NO ,HANTEI_DATE ,RAIIN_DATETIME ,KANJA_ID ,KANJA_NAME ,CONDITION_FLG ,DOCTOR_UID ,DOCTOR_UNAME ,TENKI_CODE ,TENKI_NAME ,RAIIN_CODE ,RAIIN_NAME ,RAIIN_SECTION_CODE ,RAIIN_SECTION_NAME ,SHOKAI_FLG ,SHOKAI_MOTO_CODE ,SHOKAI_MOTO_DOCTOR_UNAME ,SHOKAI_MOTO_BYOIN_NAME ,SHOSHIN_FLG ,UPDATE_TIMESTAMP ,UPDATE_UID ,UPDATE_UNAME ,BYOMEI_TEXT ,BIKO_TEXT ,SHOCHI_FLGTBL ,TENKI_STR ,CODE_01 ,DATE_01 ,FLG_01 ,STR_01 ,CODE_02 ,STR_02 ,TEXT_01 ,TEXT_02 ,TEXT_04 ,STR_05 ,TEXT_05 ,STR_06 ,TEXT_06 ,STR_07 ,TEXT_07 ,NYUIN_SECTION_CODE ,NYUIN_SECTION_NAME ,CODE_06 ,STR_10 ,TEXT_10 ,CODE_03 ,STR_03 ,TEXT_03 ,CODE_04 ,STR_04 ,CODE_DBL_01 ,STR_08 ,TEXT_08 ,TEXT_09 ,FLG_07 ,CODE_07 ,STR_11 ,STR_12 ,SHOKAI_FLGTBL ) VALUES( :POINTER_NO ,:HANTEI_DATE ,TO_DATE(TO_CHAR(:RAIIN_DATETIME), 'YYYY/MM/DD HH24:MI:SS') ,:KANJA_ID ,:KANJA_NAME ,0 ,:DOCTOR_UID ,:DOCTOR_UNAME ,:TENKI_CODE ,:TENKI_NAME ,:RAIIN_CODE ,:RAIIN_NAME ,:RAIIN_SECTION_CODE ,:RAIIN_SECTION_NAME ,:SHOKAI_FLG ,:SHOKAI_MOTO_BYOIN_CODE ,:SHOKAI_MOTO_DOCTOR_UNAME ,:SHOKAI_MOTO_BYOIN_NAME ,:SHOSHIN_FLG ,SYSDATE ,:UPDATE_UID ,:UPDATE_UNAME ,:BYOMEI_TEXT ,:BIKO_TEXT ,:SHOCHI_FLGTBL ,:TENKI_STR ,:SHOKAI_SAKI_BYOIN_CODE ,TO_DATE(TO_CHAR(:END_DATETIME), 'YYYY/MM/DD HH24:MI:SS') ,:JUTOKU_FLG ,:SHOKAI_SAKI_BYOIN_NAME ,:KYUKYUTAI_CODE ,:KYUKYUTAI_TEXT ,:SHOKAI_SAKI_DOCTOR_UNAME ,:SHOCHI_STR_ALL ,:SHOCHI_STR_OTHER ,:DOCTOR_ALL_ID ,:DOCTOR_ALL_NAME ,:SECTION_ALL_CODE ,:SECTION_ALL_NAME ,:BYOMEI_ALL_CODE ,:BYOMEI_ALL_STR ,:NYUIN_SECTION_CODE ,:NYUIN_SECTION_NAME ,:BYOTO_CODE ,:BYOTO_NAME ,:KANJA_ZIP_ADDRESS ,:HOKEN_CODE ,:HOKEN_NAME ,:HOKEN_STR ,:JIKANGAI_KASAN_CODE ,:JIKANGAI_KASAN_NAME ,:UKETSUKE_POINTER_NO ,:JUSHO_KITEN_FLGTBL ,:JUSHO_KITEN_STR_ALL ,:JUSHO_KITEN_STR_OTHER ,:FILM_FLG ,:FILM_SHOZAI_CODE ,:KINKYU_ADULT_STR ,:KINKYU_CHILD_STR ,:SHOKAI_FLGTBL ) 2015-05-21 15:24:53 yIPz 172.17.64.118 y INFOz [:KANJA_ID]:90000108 2015-05-21 15:24:53 yIPz 172.17.64.118 y INFOz [:KANJA_NAME]:eXg@ 2015-05-21 15:24:53 yIPz 172.17.64.118 y INFOz [:POINTER_NO]:12 2015-05-21 15:24:53 yIPz 172.17.64.118 y INFOz [:RAIIN_DATETIME]:2015/05/21 14:28:00 2015-05-21 15:24:53 yIPz 172.17.64.118 y INFOz [:END_DATETIME]: 2015-05-21 15:24:53 yIPz 172.17.64.118 y INFOz [:RAIIN_CODE]:3 2015-05-21 15:24:53 yIPz 172.17.64.118 y INFOz [:RAIIN_NAME]:ƕ 2015-05-21 15:24:53 yIPz 172.17.64.118 y INFOz [:SHOSHIN_FLG]:0 2015-05-21 15:24:53 yIPz 172.17.64.118 y INFOz [:KYUKYUTAI_CODE]:0 2015-05-21 15:24:53 yIPz 172.17.64.118 y INFOz [:KYUKYUTAI_TEXT]: 2015-05-21 15:24:53 yIPz 172.17.64.118 y INFOz [:JUTOKU_FLG]: 2015-05-21 15:24:53 yIPz 172.17.64.118 y INFOz [:BYOMEI_TEXT]: 2015-05-21 15:24:53 yIPz 172.17.64.118 y INFOz [:BIKO_TEXT]: 2015-05-21 15:24:53 yIPz 172.17.64.118 y INFOz [:TENKI_CODE]:2 2015-05-21 15:24:53 yIPz 172.17.64.118 y INFOz [:TENKI_NAME]:@ 2015-05-21 15:24:53 yIPz 172.17.64.118 y INFOz [:TENKI_STR]: 2015-05-21 15:24:53 yIPz 172.17.64.118 y INFOz [:DOCTOR_UID]: 2015-05-21 15:24:53 yIPz 172.17.64.118 y INFOz [:DOCTOR_UNAME]: 2015-05-21 15:24:53 yIPz 172.17.64.118 y INFOz [:RAIIN_SECTION_CODE]:0 2015-05-21 15:24:53 yIPz 172.17.64.118 y INFOz [:RAIIN_SECTION_NAME]: 2015-05-21 15:24:53 yIPz 172.17.64.118 y INFOz [:SHOKAI_FLG]:0 2015-05-21 15:24:53 yIPz 172.17.64.118 y INFOz [:SHOKAI_MOTO_BYOIN_CODE]:0 2015-05-21 15:24:53 yIPz 172.17.64.118 y INFOz [:SHOKAI_MOTO_BYOIN_NAME]: 2015-05-21 15:24:53 yIPz 172.17.64.118 y INFOz [:SHOKAI_MOTO_DOCTOR_UNAME]: 2015-05-21 15:24:53 yIPz 172.17.64.118 y INFOz [:SHOKAI_SAKI_BYOIN_CODE]:0 2015-05-21 15:24:53 yIPz 172.17.64.118 y INFOz [:SHOKAI_SAKI_BYOIN_NAME]: 2015-05-21 15:24:53 yIPz 172.17.64.118 y INFOz [:SHOKAI_SAKI_DOCTOR_UNAME]: 2015-05-21 15:24:53 yIPz 172.17.64.118 y INFOz [:SHOCHI_FLGTBL]:000000000 2015-05-21 15:24:53 yIPz 172.17.64.118 y INFOz [:SHOCHI_STR_ALL]: 2015-05-21 15:24:53 yIPz 172.17.64.118 y INFOz [:SHOCHI_STR_OTHER]: 2015-05-21 15:24:53 yIPz 172.17.64.118 y INFOz [:DOCTOR_ALL_ID]:@@@@@@@@ 2015-05-21 15:24:53 yIPz 172.17.64.118 y INFOz [:DOCTOR_ALL_NAME]:@@@@@@@@ 2015-05-21 15:24:53 yIPz 172.17.64.118 y INFOz [:SECTION_ALL_CODE]:@@@@@@@@ 2015-05-21 15:24:53 yIPz 172.17.64.118 y INFOz [:SECTION_ALL_NAME]:@@@@@@@@ 2015-05-21 15:24:53 yIPz 172.17.64.118 y INFOz [:BYOMEI_ALL_CODE]:0@@0@@0@@0@@0 2015-05-21 15:24:53 yIPz 172.17.64.118 y INFOz [:BYOMEI_ALL_STR]:@@@@@@@@ 2015-05-21 15:24:53 yIPz 172.17.64.118 y INFOz [:NYUIN_SECTION_CODE]:0 2015-05-21 15:24:53 yIPz 172.17.64.118 y INFOz [:NYUIN_SECTION_NAME]: 2015-05-21 15:24:53 yIPz 172.17.64.118 y INFOz [:BYOTO_CODE]:0 2015-05-21 15:24:53 yIPz 172.17.64.118 y INFOz [:BYOTO_NAME]: 2015-05-21 15:24:53 yIPz 172.17.64.118 y INFOz [:KANJA_ZIP_ADDRESS]:950-0916 2015-05-21 15:24:53 yIPz 172.17.64.118 y INFOz [:HOKEN_CODE]:0 2015-05-21 15:24:53 yIPz 172.17.64.118 y INFOz [:HOKEN_NAME]:ݒ 2015-05-21 15:24:53 yIPz 172.17.64.118 y INFOz [:HOKEN_STR]: 2015-05-21 15:24:53 yIPz 172.17.64.118 y INFOz [:JIKANGAI_KASAN_CODE]:0 2015-05-21 15:24:53 yIPz 172.17.64.118 y INFOz [:JIKANGAI_KASAN_NAME]:ݒ 2015-05-21 15:24:53 yIPz 172.17.64.118 y INFOz [:JUSHO_KITEN_FLGTBL]:0000000000000000000 2015-05-21 15:24:53 yIPz 172.17.64.118 y INFOz [:JUSHO_KITEN_STR_ALL]: 2015-05-21 15:24:53 yIPz 172.17.64.118 y INFOz [:JUSHO_KITEN_STR_OTHER]: 2015-05-21 15:24:53 yIPz 172.17.64.118 y INFOz [:FILM_FLG]: 2015-05-21 15:24:53 yIPz 172.17.64.118 y INFOz [:FILM_SHOZAI_CODE]:0 2015-05-21 15:24:53 yIPz 172.17.64.118 y INFOz [:KINKYU_ADULT_STR]: 2015-05-21 15:24:53 yIPz 172.17.64.118 y INFOz [:KINKYU_CHILD_STR]: 2015-05-21 15:24:53 yIPz 172.17.64.118 y INFOz [:SHOKAI_FLGTBL]:00000000000000000000000000000000000000000000000000 2015-05-21 15:24:53 yIPz 172.17.64.118 y INFOz [:HANTEI_DATE]:2015/05/21 2015-05-21 15:24:53 yIPz 172.17.64.118 y INFOz [:UKETSUKE_POINTER_NO]:3454 2015-05-21 15:24:53 yIPz 172.17.64.118 y INFOz [:UPDATE_UID]:001 2015-05-21 15:24:53 yIPz 172.17.64.118 y INFOz [:UPDATE_UNAME]:armtif@Pj 2015-05-21 15:24:53 yIPz 172.17.64.118 y INFOz Commit 2015-05-21 15:25:55 yIPz 172.17.64.118 y INFOz UPDATE KANJA_ER SET RAIIN_DATETIME = TO_DATE(TO_CHAR(:RAIIN_DATETIME), 'YYYY/MM/DD HH24:MI:SS') ,DATE_01 = TO_DATE(TO_CHAR(:END_DATETIME), 'YYYY/MM/DD HH24:MI:SS') ,KANJA_NAME = :KANJA_NAME ,RAIIN_CODE = :RAIIN_CODE ,RAIIN_NAME = :RAIIN_NAME ,SHOSHIN_FLG = :SHOSHIN_FLG ,STR_02 = :KYUKYUTAI_TEXT ,CODE_02 = :KYUKYUTAI_CODE ,FLG_01 = :JUTOKU_FLG ,BYOMEI_TEXT = :BYOMEI_TEXT ,BIKO_TEXT = :BIKO_TEXT ,TENKI_CODE = :TENKI_CODE ,TENKI_NAME = :TENKI_NAME ,TENKI_STR = :TENKI_STR ,DOCTOR_UID = :DOCTOR_UID ,DOCTOR_UNAME = :DOCTOR_UNAME ,RAIIN_SECTION_CODE = :RAIIN_SECTION_CODE ,RAIIN_SECTION_NAME = :RAIIN_SECTION_NAME ,SHOKAI_FLG = :SHOKAI_FLG ,SHOKAI_MOTO_CODE = :SHOKAI_MOTO_BYOIN_CODE ,SHOKAI_MOTO_BYOIN_NAME = :SHOKAI_MOTO_BYOIN_NAME ,SHOKAI_MOTO_DOCTOR_UNAME = :SHOKAI_MOTO_DOCTOR_UNAME ,CODE_01 = :SHOKAI_SAKI_BYOIN_CODE ,STR_01 = :SHOKAI_SAKI_BYOIN_NAME ,TEXT_01 = :SHOKAI_SAKI_DOCTOR_UNAME ,SHOCHI_FLGTBL = :SHOCHI_FLGTBL ,TEXT_02 = :SHOCHI_STR_ALL ,TEXT_04 = :SHOCHI_STR_OTHER ,UPDATE_TIMESTAMP = SYSDATE ,UPDATE_UID = :UPDATE_UID ,UPDATE_UNAME = :UPDATE_UNAME ,CONDITION_FLG = 0 ,STR_05 = :DOCTOR_ALL_ID ,TEXT_05 = :DOCTOR_ALL_NAME ,STR_06 = :SECTION_ALL_CODE ,TEXT_06 = :SECTION_ALL_NAME ,STR_07 = :BYOMEI_ALL_CODE ,TEXT_07 = :BYOMEI_ALL_STR ,NYUIN_SECTION_CODE = :NYUIN_SECTION_CODE ,NYUIN_SECTION_NAME = :NYUIN_SECTION_NAME ,CODE_06 = :BYOTO_CODE ,STR_10 = :BYOTO_NAME ,TEXT_10 = :KANJA_ZIP_ADDRESS ,CODE_03 = :HOKEN_CODE ,STR_03 = :HOKEN_NAME ,TEXT_03 = :HOKEN_STR ,CODE_04 = :JIKANGAI_KASAN_CODE ,STR_04 = :JIKANGAI_KASAN_NAME ,STR_08 = :JUSHO_KITEN_FLGTBL ,TEXT_08 = :JUSHO_KITEN_STR_ALL ,TEXT_09 = :JUSHO_KITEN_STR_OTHER ,FLG_07 = :FILM_FLG ,CODE_07 = :FILM_SHOZAI_CODE ,STR_11 = :KINKYU_ADULT_STR ,STR_12 = :KINKYU_CHILD_STR ,SHOKAI_FLGTBL = :SHOKAI_FLGTBL WHERE KANJA_ID = :KANJA_ID AND POINTER_NO = :POINTER_NO 2015-05-21 15:25:55 yIPz 172.17.64.118 y INFOz [:KANJA_ID]:90000108 2015-05-21 15:25:55 yIPz 172.17.64.118 y INFOz [:KANJA_NAME]:eXg@ 2015-05-21 15:25:55 yIPz 172.17.64.118 y INFOz [:POINTER_NO]:12 2015-05-21 15:25:55 yIPz 172.17.64.118 y INFOz [:RAIIN_DATETIME]:2015/05/21 14:28:00 2015-05-21 15:25:55 yIPz 172.17.64.118 y INFOz [:END_DATETIME]: 2015-05-21 15:25:55 yIPz 172.17.64.118 y INFOz [:RAIIN_CODE]:3 2015-05-21 15:25:55 yIPz 172.17.64.118 y INFOz [:RAIIN_NAME]:ƕ 2015-05-21 15:25:55 yIPz 172.17.64.118 y INFOz [:SHOSHIN_FLG]:0 2015-05-21 15:25:55 yIPz 172.17.64.118 y INFOz [:KYUKYUTAI_CODE]:0 2015-05-21 15:25:55 yIPz 172.17.64.118 y INFOz [:KYUKYUTAI_TEXT]: 2015-05-21 15:25:55 yIPz 172.17.64.118 y INFOz [:JUTOKU_FLG]: 2015-05-21 15:25:55 yIPz 172.17.64.118 y INFOz [:BYOMEI_TEXT]: 2015-05-21 15:25:55 yIPz 172.17.64.118 y INFOz [:BIKO_TEXT]:~} 2015-05-21 15:25:55 yIPz 172.17.64.118 y INFOz [:TENKI_CODE]:2 2015-05-21 15:25:55 yIPz 172.17.64.118 y INFOz [:TENKI_NAME]:@ 2015-05-21 15:25:55 yIPz 172.17.64.118 y INFOz [:TENKI_STR]: 2015-05-21 15:25:55 yIPz 172.17.64.118 y INFOz [:DOCTOR_UID]: 2015-05-21 15:25:55 yIPz 172.17.64.118 y INFOz [:DOCTOR_UNAME]: 2015-05-21 15:25:55 yIPz 172.17.64.118 y INFOz [:RAIIN_SECTION_CODE]:0 2015-05-21 15:25:55 yIPz 172.17.64.118 y INFOz [:RAIIN_SECTION_NAME]: 2015-05-21 15:25:55 yIPz 172.17.64.118 y INFOz [:SHOKAI_FLG]:0 2015-05-21 15:25:55 yIPz 172.17.64.118 y INFOz [:SHOKAI_MOTO_BYOIN_CODE]:0 2015-05-21 15:25:55 yIPz 172.17.64.118 y INFOz [:SHOKAI_MOTO_BYOIN_NAME]: 2015-05-21 15:25:55 yIPz 172.17.64.118 y INFOz [:SHOKAI_MOTO_DOCTOR_UNAME]: 2015-05-21 15:25:55 yIPz 172.17.64.118 y INFOz [:SHOKAI_SAKI_BYOIN_CODE]:0 2015-05-21 15:25:55 yIPz 172.17.64.118 y INFOz [:SHOKAI_SAKI_BYOIN_NAME]: 2015-05-21 15:25:55 yIPz 172.17.64.118 y INFOz [:SHOKAI_SAKI_DOCTOR_UNAME]: 2015-05-21 15:25:55 yIPz 172.17.64.118 y INFOz [:SHOCHI_FLGTBL]:000000000 2015-05-21 15:25:55 yIPz 172.17.64.118 y INFOz [:SHOCHI_STR_ALL]: 2015-05-21 15:25:55 yIPz 172.17.64.118 y INFOz [:SHOCHI_STR_OTHER]: 2015-05-21 15:25:55 yIPz 172.17.64.118 y INFOz [:DOCTOR_ALL_ID]:@@@@@@@@ 2015-05-21 15:25:55 yIPz 172.17.64.118 y INFOz [:DOCTOR_ALL_NAME]:@@@@@@@@ 2015-05-21 15:25:55 yIPz 172.17.64.118 y INFOz [:SECTION_ALL_CODE]:@@@@@@@@ 2015-05-21 15:25:55 yIPz 172.17.64.118 y INFOz [:SECTION_ALL_NAME]:@@@@@@@@ 2015-05-21 15:25:55 yIPz 172.17.64.118 y INFOz [:BYOMEI_ALL_CODE]:0@@0@@0@@0@@0 2015-05-21 15:25:55 yIPz 172.17.64.118 y INFOz [:BYOMEI_ALL_STR]:@@@@@@@@ 2015-05-21 15:25:55 yIPz 172.17.64.118 y INFOz [:NYUIN_SECTION_CODE]:0 2015-05-21 15:25:55 yIPz 172.17.64.118 y INFOz [:NYUIN_SECTION_NAME]: 2015-05-21 15:25:55 yIPz 172.17.64.118 y INFOz [:BYOTO_CODE]:0 2015-05-21 15:25:55 yIPz 172.17.64.118 y INFOz [:BYOTO_NAME]: 2015-05-21 15:25:55 yIPz 172.17.64.118 y INFOz [:KANJA_ZIP_ADDRESS]:950-0916 2015-05-21 15:25:55 yIPz 172.17.64.118 y INFOz [:HOKEN_CODE]:0 2015-05-21 15:25:55 yIPz 172.17.64.118 y INFOz [:HOKEN_NAME]:ݒ 2015-05-21 15:25:55 yIPz 172.17.64.118 y INFOz [:HOKEN_STR]: 2015-05-21 15:25:55 yIPz 172.17.64.118 y INFOz [:JIKANGAI_KASAN_CODE]:0 2015-05-21 15:25:55 yIPz 172.17.64.118 y INFOz [:JIKANGAI_KASAN_NAME]:ݒ 2015-05-21 15:25:55 yIPz 172.17.64.118 y INFOz [:JUSHO_KITEN_FLGTBL]:0000000000000000000 2015-05-21 15:25:55 yIPz 172.17.64.118 y INFOz [:JUSHO_KITEN_STR_ALL]: 2015-05-21 15:25:55 yIPz 172.17.64.118 y INFOz [:JUSHO_KITEN_STR_OTHER]: 2015-05-21 15:25:55 yIPz 172.17.64.118 y INFOz [:FILM_FLG]: 2015-05-21 15:25:55 yIPz 172.17.64.118 y INFOz [:FILM_SHOZAI_CODE]:0 2015-05-21 15:25:55 yIPz 172.17.64.118 y INFOz [:KINKYU_ADULT_STR]: 2015-05-21 15:25:55 yIPz 172.17.64.118 y INFOz [:KINKYU_CHILD_STR]: 2015-05-21 15:25:55 yIPz 172.17.64.118 y INFOz [:SHOKAI_FLGTBL]:00000000000000000000000000000000000000000000000000 2015-05-21 15:25:55 yIPz 172.17.64.118 y INFOz [:UPDATE_UID]:001 2015-05-21 15:25:55 yIPz 172.17.64.118 y INFOz [:UPDATE_UNAME]:armtif@Pj 2015-05-21 15:25:55 yIPz 172.17.64.118 y INFOz Commit 2015-05-21 15:26:10 yIPz 172.17.64.118 y INFOz SELECT CODE /*[0]CODE*/ ,NAME /*[1]NAME*/ ,CODE_01 /*[2]CODE_01*/ ,FLG_01 /*[3]FLG_01*/ ,FLG_02 /*[4]FLG_02*/ ,FLG_03 /*[5]FLG_03*/ ,FLG_04 /*[6]FLG_04*/ FROM COMMON WHERE MASTER_CODE_STR = '00010047' AND CONDITION_FLG = 0 AND LAST_FLG = 1 AND KIND = 0 ORDER BY DISP_ORDER ,CODE 2015-05-21 15:26:10 yIPz 172.17.64.118 y INFOz SELECT TE.POINTER_NO ,TE.ER_KIND ,TE.ER_KIND_NAME ,TE.ROW_NO ,TE.TANTO_UID ,TE.TANTO_UNAME ,CM.FLG_04 FROM TANTO_ER TE ,COMMON CM WHERE TE.YYYY = :YYYY AND TE.MM = :MM AND TE.DD = :DD AND TE.TIME_ZONE_FLG = :JIKANTAI_KIND AND TE.CONDITION_FLG = 0 AND TE.ER_KIND = CM.CODE AND CM.MASTER_CODE_STR = '00010047' ORDER BY ER_KIND, ROW_NO 2015-05-21 15:26:10 yIPz 172.17.64.118 y INFOz [:YYYY]:2015 2015-05-21 15:26:10 yIPz 172.17.64.118 y INFOz [:MM]:5 2015-05-21 15:26:10 yIPz 172.17.64.118 y INFOz [:DD]:21 2015-05-21 15:26:10 yIPz 172.17.64.118 y INFOz [:JIKANTAI_KIND]:1 2015-05-21 15:26:10 yIPz 172.17.64.118 y INFOz SELECT YYYY /*[0]YYYY*/ ,MM /*[1]MM*/ ,DD /*[2]DD*/ ,WEEK_FLG /*[3]WEEK_FLG*/ ,WEEK_STR /*[4]WEEK_STR*/ ,COMMENT_STR /*[5]COMMENT_STR*/ ,HOLIDAY_FLG /*[6]HOLIDAY_FLG*/ ,TIME_ZONE_FLG /*[7]TIME_ZONE_FLG*/ ,TO_CHAR(START_DATETIME, 'YYYY/MM/DD HH24:MI:SS') /*[8]START_DATETIME*/ ,TO_CHAR(END_DATETIME, 'YYYY/MM/DD HH24:MI:SS') /*[9]END_DATETIME*/ ,COMMENT_TEXT /*[10]COMMENT_TEXT*/ ,WEATHER_CODE /*[11]WEATHER_CODE*/ ,WEATHER_STR /*[12]WEATHER_STR*/ FROM CALENDAR_ER WHERE CALENDAR_DATE = :CALENDAR_DATE AND TIME_ZONE_FLG = :JIKANTAI_KIND 2015-05-21 15:26:10 yIPz 172.17.64.118 y INFOz [:CALENDAR_DATE]:2015/05/21 2015-05-21 15:26:10 yIPz 172.17.64.118 y INFOz [:JIKANTAI_KIND]:1 2015-05-21 15:26:10 yIPz 172.17.64.118 y INFOz SELECT TO_CHAR(NVL(KE.RAIIN_DATETIME, UT.UKETSUKE_DATETIME), 'YYYY/MM/DD HH24:MI:SS') RAIIN_DATETIME /*[0]RAIIN_DATETIME @*/ ,UT.KANJA_ID KANJA_ID /*[1]KANJA_ID ID*/ ,KJ.NAME KANJA_NAME /*[2]KANJA_NAME Ҏ*/ ,FUNC_GET_KANJA_AGE(KJ.BIRTH_DATE,SYSDATE) AGE /*[3]AGE N*/ ,KJ.SEX /*[4]SEX */ ,KE.RAIIN_SECTION_NAME /*[5]SECTION_NAME fÉȖ*/ ,KE.RAIIN_CODE /*[6]RAIIN_CODE @*/ ,KE.RAIIN_NAME /*[7]RAIIN_NAME @ʖ*/ ,KE.TENKI_CODE /*[8]TENKI_CODE ]A*/ ,KE.TENKI_NAME /*[9]TENKI_NAME ]Aʖ*/ ,KE.TENKI_STR /*[10]TENKI_STR ]A*/ ,KE.POINTER_NO /*[11]POINTER_NO |C^ԍ*/ ,KE.CONDITION_FLG /*[12]CONDITION_FLG RfBVtO*/ ,TO_CHAR(UT.UKETSUKE_DATETIME,'YYYY/MM/DD HH24:MI:SS') UKETSUKE_DATETIME /*[13]UKETSUKE_DATETIME t*/ ,TO_CHAR(UT.HANTEI_DATE, 'YYYY/MM/DD') HANTEI_DATE /*[14]HANTEI_DATE */ ,DECODE(KE.CONDITION_FLG, 2, 'ݒ', NVL2(KE.STR_03, KE.STR_03, 'ݒ') || NVL2(KE.TEXT_03, '(' || KE.TEXT_03 || ')', '')) HOKEN_STR /*[15]HOKEN_STR ی*/ ,KE.STR_04 JIKANGAI_KASAN_STR /*[16]JIKANGAI_KASAN_STR ԊOZ*/ ,DECODE(NVL2(KE.DATE_01, TO_CHAR(KE.DATE_01, 'YYYY/MM/DD'), '0001/01/01'), '0001/01/01', '', TO_CHAR(KE.DATE_01, 'HH24:MI')) END_TIME /*[17]END_TIME I*/ ,KE.STR_02 KYUKYUTAI /*[18]KYUKYUTAI ~}*/ ,KE.STR_10 BYOTO_NAME /*[19]BYOTO_NAME a*/ ,KE.SHOKAI_MOTO_BYOIN_NAME SHOKAI_MOTO /*[20]SHOKAI_MOTO Љa@*/ ,KE.SHOKAI_MOTO_DOCTOR_UNAME SHOKAI_MOTO_DOC /*[21]SHOKAI_MOTO_DOC Љt*/ ,KE.STR_01 SHOKAI_SAKI /*[22]SHOKAI_SAKI Љa@*/ ,KE.TEXT_01 SHOKAI_SAKI_DOC /*[23]SHOKAI_SAKI_DOC Љt*/ ,KJ.JITAKU_JUSHO_01 || KJ.JITAKU_JUSHO_02 JUSHO /*[24]JUSHO Z*/ ,KJ.JITAKU_JUSHO_01 JUSHO_01 /*[25]JUSHO_01 Z1*/ ,KJ.JITAKU_JUSHO_02 JUSHO_02 /*[26]JUSHO_02 Z2*/ ,KE.TEXT_08 JUSHO_KITEN_STR /*[27]JUSHO_KITEN_STR 󏝋@]*/ ,KE.BIKO_TEXT BIKO_STR /*[28]BIKO_STR l2*/ ,KE.TEXT_09 JUSHO_KITEN_STR2 /*[29]JUSHO_KITEN_STR2 󏝋@]*/ ,KE.TEXT_07 BYOMEI_ALL_STR /*[30]BYOMEI_ALL_STR aS*/ ,KE.SHOSHIN_FLG /*[31]SHOSHIN_FLG f*/ ,KE.STR_10 /*[32]BYOTO_NAME a*/ ,KE.SHOKAI_FLG /*[33]SHOKAI_FLG ЉtO*/ ,KE.SHOCHI_FLGTBL /*[34]SHOCHI_FLGTBL utOe[u*/ ,KE.STR_08 JUSHO_KITEN_FLGTBL /*[35]JUSHO_KITEN_FLGTBL dNj@]tOe[u*/ ,KE.CODE_03 HOKEN_CODE /*[36]HOKEN_CODE یR[h*/ ,DECODE(KE.FLG_05, 1, 0, 1) TOKEI_FLG /*[37]TOKEI_FLG vtO*/ ,TO_CHAR(KJ.BIRTH_DATE, 'yyyy/mm/dd') AS BIRTH_DATE /*[38]BIRTH_DATE a*/ ,KE.TEXT_02 /*[39]KENSA_SHOCHI u*/ ,KE.DOCTOR_UNAME /*[40]DOCTOR_UNAME t*/ ,KE.TEXT_05 /*[41]DOCTOR_All_UNAME tS*/ ,KE.TEXT_06 /*[42]SECCTION_ALL_NAME fÉȖS*/ FROM KANJA_ER KE ,KANJA KJ ,UKETSUKE UT WHERE UT.HANTEI_DATE BETWEEN :UKETSUKE_START_DATE AND :UKETSUKE_END_DATE AND UT.CONDITION_FLG = 0 AND UT.KANJA_ID = KJ.KANJA_ID AND KJ.CONDITION_FLG = 0 AND KJ.LAST_FLG = 1 AND UT.POINTER_NO = KE.CODE_DBL_01(+) AND UT.KANJA_ID = KE.KANJA_ID(+) AND UT.YOYAKU_SECTION_CODE = :KYUKYU_GAIRAI_SECTION_CODE ORDER BY RAIIN_DATETIME ,KANJA_ID 2015-05-21 15:26:10 yIPz 172.17.64.118 y INFOz [:UKETSUKE_START_DATE]:2015/05/21 2015-05-21 15:26:10 yIPz 172.17.64.118 y INFOz [:UKETSUKE_END_DATE]:2015/05/21 2015-05-21 15:26:10 yIPz 172.17.64.118 y INFOz [:KYUKYU_GAIRAI_SECTION_CODE]:77 2015-05-21 15:26:10 yIPz 172.17.64.118 y INFOz SELECT COMMENT_TEXT ,WEATHER_CODE ,WEATHER_STR ,NAIKA_TOBAN_FLG ,GEKA_TOBAN_FLG ,SHONIKA_TOBAN_FLG ,NAIKA_TOBAN_STR ,GEKA_TOBAN_STR ,SHONIKA_TOBAN_STR FROM CALENDAR_ER WHERE YYYY = :YYYY AND MM = :MM AND DD = :DD AND TIME_ZONE_FLG = :JIKANTAI_KIND AND CTRL_FLG = 0 2015-05-21 15:26:10 yIPz 172.17.64.118 y INFOz [:YYYY]:2015 2015-05-21 15:26:10 yIPz 172.17.64.118 y INFOz [:MM]:5 2015-05-21 15:26:10 yIPz 172.17.64.118 y INFOz [:DD]:21 2015-05-21 15:26:10 yIPz 172.17.64.118 y INFOz [:JIKANTAI_KIND]:1 2015-05-21 15:26:10 yIPz 172.17.64.118 y INFOz SELECT YYYY /*[0]YYYY*/ ,MM /*[1]MM*/ ,DD /*[2]DD*/ ,WEEK_FLG /*[3]WEEK_FLG*/ ,WEEK_STR /*[4]WEEK_STR*/ ,COMMENT_STR /*[5]COMMENT_STR*/ ,HOLIDAY_FLG /*[6]HOLIDAY_FLG*/ ,TIME_ZONE_FLG /*[7]TIME_ZONE_FLG*/ ,TO_CHAR(START_DATETIME, 'YYYY/MM/DD HH24:MI:SS') /*[8]START_DATETIME*/ ,TO_CHAR(END_DATETIME, 'YYYY/MM/DD HH24:MI:SS') /*[9]END_DATETIME*/ ,COMMENT_TEXT /*[10]COMMENT_TEXT*/ ,WEATHER_CODE /*[11]WEATHER_CODE*/ ,WEATHER_STR /*[12]WEATHER_STR*/ FROM CALENDAR_ER WHERE CALENDAR_DATE = :CALENDAR_DATE AND TIME_ZONE_FLG = :JIKANTAI_KIND 2015-05-21 15:26:10 yIPz 172.17.64.118 y INFOz [:CALENDAR_DATE]:2015/05/21 2015-05-21 15:26:10 yIPz 172.17.64.118 y INFOz [:JIKANTAI_KIND]:1