[Logging Date Time: 2016-12-21 14:58:35,055] ===================================================================================== SQL Command - Statement Id: [getPatientInfoOut] PreparedStatement : [SELECT a.orddeptcd, a.pid as IO_Pt_ID, to_char(a.cretno) as IO_CretNo, ( ptbs.sex || '/' || com.fn_zz_getageas(ptbs.rrgstno1, ptbs.rrgstno2, TO_CHAR(SYSDATE, 'YYYYMMDD'), 'A', ptbs.brthdd)) as IO_sex_age_y_m, ptbs.hngnm as IO_Pt_Name, (ptbs.rrgstno1 || '-' || substr(ptbs.rrgstno2, 1, 1) ||'******') IO_JuminNo, ptbs.zipcdaddr as IO_Zipcdaddr, ptbs.mpphontel as IO_Tel, (select cdnm from com.zbcmcode where cdgrupid='P0008' and cdid =a.insukind) as IO_Insukind, '' as IO_Ward, '' as IO_roomNO, a.orddd as IO_ADdate, a.orddd as IO_Dschdd, a.ordtype as IO_VisitType, a.orddeptcd as IO_DeptCd, (select dept.deptengabbr from com.zsdddept dept where dept.deptcd = a.orddeptcd and dept.instcd = a.instcd and dept.valitodd >= a.orddd and dept.valifromdd <= a.orddd) as IO_DeptNm, COM.FN_ZS_GETDEPTNAME(a.instcd, a.orddeptcd, a.orddd) AS IO_Dept2, '' AS IO_OPdeptCd, '' AS IO_OPdeptNm, '' AS IO_OPdrNm, '' AS IO_OPdrId, (SELECT diag.diagcd FROM emr.mmohdiag diag WHERE diag.pid = a.pid AND diag.orddd = a.orddd AND diag.cretno = a.cretno AND diag.diaghistcd = 'O' AND diag.diagtypecd = 'D' AND diag.diagkindcdflag = 'M' AND diag.genrflagcd = a.ordtype and diag.orddeptcd = a.orddeptcd AND diag.diaghistno = (select max(diagh.diaghistno) from emr.mmohdiag diagh where diagh.pid = a.pid AND diagh.orddd = a.orddd AND diagh.cretno = a.cretno AND diagh.instcd = '111' AND diagh.diaghistcd = 'O' AND diagh.diagkindcdflag = 'M' AND diagh.genrflagcd = a.ordtype and diagh.orddeptcd = a.orddeptcd group by pid)) as IO_DxCd, (SELECT term.diaghngnm FROM emr.mmohdiag diag, emr.mmbvdiag term WHERE diag.pid = a.pid AND diag.orddd = a.orddd AND diag.cretno = a.cretno AND diag.instcd = term.instcd AND diag.diagcd = term.orgdiagcd AND diag.diaghistcd = 'O' AND diag.diagtypecd = 'D' AND diag.diagkindcdflag = 'M' AND diag.diagdd >= term.termfromdd AND diag.diagdd <= term.termtodd AND diag.diagdd >= term.diagattrfromdd AND diag.diagdd <= term.diagattrtodd AND diag.genrflagcd = a.ordtype and diag.orddeptcd = a.orddeptcd AND diag.diaghistno = (select max(diagh.diaghistno) from emr.mmohdiag diagh where diagh.pid = a.pid AND diagh.orddd = a.orddd AND diagh.cretno = a.cretno AND diagh.instcd = '111' AND diagh.diaghistcd = 'O' AND diagh.diagkindcdflag = 'M' AND diagh.genrflagcd = a.ordtype and diagh.orddeptcd = a.orddeptcd group by pid)) as IO_DxNm, COM.FN_ZS_GETUSERNM(a.orddrid, a.orddd) as IO_MaindrNm, '111' as IO_HosType, case when ex.bp is null then null else ex.bp end as IO_bp, case when ex.dm is null then null else ex.dm end as IO_dm, case when ex.heart is null then null else ex.heart end as IO_heart, case when ex.kidney is null then null else ex.kidney end as IO_kidney, case when ex.respiration is null then null else ex.respiration end as IO_respiration, case when ex.hx is null then null else ex.hx end as IO_hx, case when ex.allergy is null then null else ex.allergy end as IO_allergy, case when ex.drug is null then null else ex.drug end as IO_drug, case when ex.smoking is null then null else ex.smoking end as IO_smoking, case when ex.idio is null then null else ex.idio end as IO_idio, case when ex.nacrotics is null then null else ex.nacrotics end as IO_nacrotics, case when ex.airway is null then null else ex.airway end as IO_airway, case when ex.hemorrhage is null then null else ex.hemorrhage end as IO_hemorrhage, ex.etc IO_status_etc, '111' as IO_OrderNo, '111' as IO_PrintTime, a.ORDDRID as IO_MaindrId, '' as IO_ErdrNm, COM.FN_ZS_GETUSERNM(a.ORDDRID, a.orddd) as IO_MaindrNm, '111' as IO_OcrCd, a.ORDDRID as IO_InputId, COM.FN_ZS_GETUSERNM(a.ORDDRID, a.orddd) as IO_InputNm, '111' as IO_SignImg FROM pam.pmohotpt a left outer join cmr.consent_data_ex ex on (ex.pid = a.pid and ex.cln_date = a.orddd) left outer join pam.pmcmptbs ptbs on (ptbs.pid = a.pid and ptbs.instcd = a.instcd) WHERE a.instcd = :param0 AND a.pid = :param1 AND a.orddd = :param2 AND A.HISTSTAT IN ('R', 'T') AND A.MSKIND = 'M' AND a.cretno = :param3 AND a.orddeptcd = :param4] [Logging Date Time: 2016-12-21 14:58:35,088] ===================================================================================== SQL Command - Statement Id: [getPatientInfoOut] Parameters: [param0=[instcd,111], param1=[pid,1462723], param2=[orddd,20161221], param3=[cretno,1], param4=[orddeptcd,2040000000]] [Logging Date Time: 2016-12-21 14:58:35,088] ===================================================================================== SQL Command - Statement Id: [getPatientInfoOut] Parameters: [param0=[instcd,111], param1=[pid,1462723], param2=[orddd,20161221], param3=[cretno,1], param4=[orddeptcd,2040000000]] [Logging Date Time: 2016-12-21 14:58:35,088] ===================================================================================== SQL Command - Statement Id: [getPatientInfoOut] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String]] [Logging Date Time: 2016-12-21 14:58:35,088] ===================================================================================== SQL Command - Statement Id: [getPatientInfoOut] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String]] [Logging Date Time: 2016-12-21 14:58:35,184] ===================================================================================== SQL Command - Statement Id: [getPatientInfoOut] PreparedStatement : [SELECT a.orddeptcd, a.pid as IO_Pt_ID, to_char(a.cretno) as IO_CretNo, ( ptbs.sex || '/' || com.fn_zz_getageas(ptbs.rrgstno1, ptbs.rrgstno2, TO_CHAR(SYSDATE, 'YYYYMMDD'), 'A', ptbs.brthdd)) as IO_sex_age_y_m, ptbs.hngnm as IO_Pt_Name, (ptbs.rrgstno1 || '-' || substr(ptbs.rrgstno2, 1, 1) ||'******') IO_JuminNo, ptbs.zipcdaddr as IO_Zipcdaddr, ptbs.mpphontel as IO_Tel, (select cdnm from com.zbcmcode where cdgrupid='P0008' and cdid =a.insukind) as IO_Insukind, '' as IO_Ward, '' as IO_roomNO, a.orddd as IO_ADdate, a.orddd as IO_Dschdd, a.ordtype as IO_VisitType, a.orddeptcd as IO_DeptCd, (select dept.deptengabbr from com.zsdddept dept where dept.deptcd = a.orddeptcd and dept.instcd = a.instcd and dept.valitodd >= a.orddd and dept.valifromdd <= a.orddd) as IO_DeptNm, COM.FN_ZS_GETDEPTNAME(a.instcd, a.orddeptcd, a.orddd) AS IO_Dept2, '' AS IO_OPdeptCd, '' AS IO_OPdeptNm, '' AS IO_OPdrNm, '' AS IO_OPdrId, (SELECT diag.diagcd FROM emr.mmohdiag diag WHERE diag.pid = a.pid AND diag.orddd = a.orddd AND diag.cretno = a.cretno AND diag.diaghistcd = 'O' AND diag.diagtypecd = 'D' AND diag.diagkindcdflag = 'M' AND diag.genrflagcd = a.ordtype and diag.orddeptcd = a.orddeptcd AND diag.diaghistno = (select max(diagh.diaghistno) from emr.mmohdiag diagh where diagh.pid = a.pid AND diagh.orddd = a.orddd AND diagh.cretno = a.cretno AND diagh.instcd = '111' AND diagh.diaghistcd = 'O' AND diagh.diagkindcdflag = 'M' AND diagh.genrflagcd = a.ordtype and diagh.orddeptcd = a.orddeptcd group by pid)) as IO_DxCd, (SELECT term.diaghngnm FROM emr.mmohdiag diag, emr.mmbvdiag term WHERE diag.pid = a.pid AND diag.orddd = a.orddd AND diag.cretno = a.cretno AND diag.instcd = term.instcd AND diag.diagcd = term.orgdiagcd AND diag.diaghistcd = 'O' AND diag.diagtypecd = 'D' AND diag.diagkindcdflag = 'M' AND diag.diagdd >= term.termfromdd AND diag.diagdd <= term.termtodd AND diag.diagdd >= term.diagattrfromdd AND diag.diagdd <= term.diagattrtodd AND diag.genrflagcd = a.ordtype and diag.orddeptcd = a.orddeptcd AND diag.diaghistno = (select max(diagh.diaghistno) from emr.mmohdiag diagh where diagh.pid = a.pid AND diagh.orddd = a.orddd AND diagh.cretno = a.cretno AND diagh.instcd = '111' AND diagh.diaghistcd = 'O' AND diagh.diagkindcdflag = 'M' AND diagh.genrflagcd = a.ordtype and diagh.orddeptcd = a.orddeptcd group by pid)) as IO_DxNm, COM.FN_ZS_GETUSERNM(a.orddrid, a.orddd) as IO_MaindrNm, '111' as IO_HosType, case when ex.bp is null then null else ex.bp end as IO_bp, case when ex.dm is null then null else ex.dm end as IO_dm, case when ex.heart is null then null else ex.heart end as IO_heart, case when ex.kidney is null then null else ex.kidney end as IO_kidney, case when ex.respiration is null then null else ex.respiration end as IO_respiration, case when ex.hx is null then null else ex.hx end as IO_hx, case when ex.allergy is null then null else ex.allergy end as IO_allergy, case when ex.drug is null then null else ex.drug end as IO_drug, case when ex.smoking is null then null else ex.smoking end as IO_smoking, case when ex.idio is null then null else ex.idio end as IO_idio, case when ex.nacrotics is null then null else ex.nacrotics end as IO_nacrotics, case when ex.airway is null then null else ex.airway end as IO_airway, case when ex.hemorrhage is null then null else ex.hemorrhage end as IO_hemorrhage, ex.etc IO_status_etc, '111' as IO_OrderNo, '111' as IO_PrintTime, a.ORDDRID as IO_MaindrId, '' as IO_ErdrNm, COM.FN_ZS_GETUSERNM(a.ORDDRID, a.orddd) as IO_MaindrNm, '111' as IO_OcrCd, a.ORDDRID as IO_InputId, COM.FN_ZS_GETUSERNM(a.ORDDRID, a.orddd) as IO_InputNm, '111' as IO_SignImg FROM pam.pmohotpt a left outer join cmr.consent_data_ex ex on (ex.pid = a.pid and ex.cln_date = a.orddd) left outer join pam.pmcmptbs ptbs on (ptbs.pid = a.pid and ptbs.instcd = a.instcd) WHERE a.instcd = :param0 AND a.pid = :param1 AND a.orddd = :param2 AND A.HISTSTAT IN ('R', 'T') AND A.MSKIND = 'M' AND a.cretno = :param3 AND a.orddeptcd = :param4] [Logging Date Time: 2016-12-21 14:58:35,184] ===================================================================================== SQL Command - Statement Id: [getPatientInfoOut] PreparedStatement : [SELECT a.orddeptcd, a.pid as IO_Pt_ID, to_char(a.cretno) as IO_CretNo, ( ptbs.sex || '/' || com.fn_zz_getageas(ptbs.rrgstno1, ptbs.rrgstno2, TO_CHAR(SYSDATE, 'YYYYMMDD'), 'A', ptbs.brthdd)) as IO_sex_age_y_m, ptbs.hngnm as IO_Pt_Name, (ptbs.rrgstno1 || '-' || substr(ptbs.rrgstno2, 1, 1) ||'******') IO_JuminNo, ptbs.zipcdaddr as IO_Zipcdaddr, ptbs.mpphontel as IO_Tel, (select cdnm from com.zbcmcode where cdgrupid='P0008' and cdid =a.insukind) as IO_Insukind, '' as IO_Ward, '' as IO_roomNO, a.orddd as IO_ADdate, a.orddd as IO_Dschdd, a.ordtype as IO_VisitType, a.orddeptcd as IO_DeptCd, (select dept.deptengabbr from com.zsdddept dept where dept.deptcd = a.orddeptcd and dept.instcd = a.instcd and dept.valitodd >= a.orddd and dept.valifromdd <= a.orddd) as IO_DeptNm, COM.FN_ZS_GETDEPTNAME(a.instcd, a.orddeptcd, a.orddd) AS IO_Dept2, '' AS IO_OPdeptCd, '' AS IO_OPdeptNm, '' AS IO_OPdrNm, '' AS IO_OPdrId, (SELECT diag.diagcd FROM emr.mmohdiag diag WHERE diag.pid = a.pid AND diag.orddd = a.orddd AND diag.cretno = a.cretno AND diag.diaghistcd = 'O' AND diag.diagtypecd = 'D' AND diag.diagkindcdflag = 'M' AND diag.genrflagcd = a.ordtype and diag.orddeptcd = a.orddeptcd AND diag.diaghistno = (select max(diagh.diaghistno) from emr.mmohdiag diagh where diagh.pid = a.pid AND diagh.orddd = a.orddd AND diagh.cretno = a.cretno AND diagh.instcd = '111' AND diagh.diaghistcd = 'O' AND diagh.diagkindcdflag = 'M' AND diagh.genrflagcd = a.ordtype and diagh.orddeptcd = a.orddeptcd group by pid)) as IO_DxCd, (SELECT term.diaghngnm FROM emr.mmohdiag diag, emr.mmbvdiag term WHERE diag.pid = a.pid AND diag.orddd = a.orddd AND diag.cretno = a.cretno AND diag.instcd = term.instcd AND diag.diagcd = term.orgdiagcd AND diag.diaghistcd = 'O' AND diag.diagtypecd = 'D' AND diag.diagkindcdflag = 'M' AND diag.diagdd >= term.termfromdd AND diag.diagdd <= term.termtodd AND diag.diagdd >= term.diagattrfromdd AND diag.diagdd <= term.diagattrtodd AND diag.genrflagcd = a.ordtype and diag.orddeptcd = a.orddeptcd AND diag.diaghistno = (select max(diagh.diaghistno) from emr.mmohdiag diagh where diagh.pid = a.pid AND diagh.orddd = a.orddd AND diagh.cretno = a.cretno AND diagh.instcd = '111' AND diagh.diaghistcd = 'O' AND diagh.diagkindcdflag = 'M' AND diagh.genrflagcd = a.ordtype and diagh.orddeptcd = a.orddeptcd group by pid)) as IO_DxNm, COM.FN_ZS_GETUSERNM(a.orddrid, a.orddd) as IO_MaindrNm, '111' as IO_HosType, case when ex.bp is null then null else ex.bp end as IO_bp, case when ex.dm is null then null else ex.dm end as IO_dm, case when ex.heart is null then null else ex.heart end as IO_heart, case when ex.kidney is null then null else ex.kidney end as IO_kidney, case when ex.respiration is null then null else ex.respiration end as IO_respiration, case when ex.hx is null then null else ex.hx end as IO_hx, case when ex.allergy is null then null else ex.allergy end as IO_allergy, case when ex.drug is null then null else ex.drug end as IO_drug, case when ex.smoking is null then null else ex.smoking end as IO_smoking, case when ex.idio is null then null else ex.idio end as IO_idio, case when ex.nacrotics is null then null else ex.nacrotics end as IO_nacrotics, case when ex.airway is null then null else ex.airway end as IO_airway, case when ex.hemorrhage is null then null else ex.hemorrhage end as IO_hemorrhage, ex.etc IO_status_etc, '111' as IO_OrderNo, '111' as IO_PrintTime, a.ORDDRID as IO_MaindrId, '' as IO_ErdrNm, COM.FN_ZS_GETUSERNM(a.ORDDRID, a.orddd) as IO_MaindrNm, '111' as IO_OcrCd, a.ORDDRID as IO_InputId, COM.FN_ZS_GETUSERNM(a.ORDDRID, a.orddd) as IO_InputNm, '111' as IO_SignImg FROM pam.pmohotpt a left outer join cmr.consent_data_ex ex on (ex.pid = a.pid and ex.cln_date = a.orddd) left outer join pam.pmcmptbs ptbs on (ptbs.pid = a.pid and ptbs.instcd = a.instcd) WHERE a.instcd = :param0 AND a.pid = :param1 AND a.orddd = :param2 AND A.HISTSTAT IN ('R', 'T') AND A.MSKIND = 'M' AND a.cretno = :param3 AND a.orddeptcd = :param4] [Logging Date Time: 2016-12-21 14:58:35,185] ===================================================================================== SQL Command - Statement Id: [getPatientInfoOut] Parameters: [param0=[instcd,111], param1=[pid,1462723], param2=[orddd,20161221], param3=[cretno,1], param4=[orddeptcd,2040000000]] [Logging Date Time: 2016-12-21 14:58:35,185] ===================================================================================== SQL Command - Statement Id: [getPatientInfoOut] Parameters: [param0=[instcd,111], param1=[pid,1462723], param2=[orddd,20161221], param3=[cretno,1], param4=[orddeptcd,2040000000]] [Logging Date Time: 2016-12-21 14:58:35,185] ===================================================================================== SQL Command - Statement Id: [getPatientInfoOut] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String]] [Logging Date Time: 2016-12-21 14:58:35,185] ===================================================================================== SQL Command - Statement Id: [getPatientInfoOut] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String]] [Logging Date Time: 2016-12-21 14:58:35,355] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_LIST] PreparedStatement : [SELECT CM.CONSENT_MST_RID , DECODE(CM.CONSENT_STATE, 'TEMP' ,'ÀÓ½ÃÀúÀå', 'ELECTR_CMP', '¼­¸í', 'PAPER_OUT', 'Ãâ·Â' , 'CERTIFY_CMP', 'ÀÎÁõ', 'UNFINISHED', '¹ÌÀÛ¼º', 'VERBAL', '±¸µÎ') AS CONSENT_STATE_DISP , VEF.FORM_NAME AS CONSENT_NAME , CM.HOS_TYPE , CM.PID , CM.VISIT_TYPE , CM.ORDER_NO , CM.ORDER_CD , CM.ORDER_NAME , CM.CLN_DEPT_CD , (SELECT DEPTHNGNM FROM COM.ZSDDDEPT WHERE DEPTCD = CM.CLN_DEPT_CD and valitodd = '99991231' and instcd = '111') AS CLN_DEPT_NM , COM.FN_ZS_GETDEPTNAME('111', (select dept.deptcd from com.zsdddept dept where dept.instcd = '111' and dept.valitodd = '99991231' and dept.deptengabbr = CM.WARDCD), '99991231') as WARDCD , CM.ROOMCD , CM.FORM_RID , VEF.FORM_CD , VEF.FORM_GUID , C.PRNTCNT , CM.CONSENT_STATE AS CONSENT_STATE , CM.OCR_NUMBER , CM.COSIGN_DC_ID , CM.COSIGN_DC_NAME , CM.MODIFY_USER_ID AS CREATE_USER_ID , CM.MODIFY_USER_NAME AS CREATE_USER_NAME , CM.MODIFY_DATETIME AS CREATE_DATETIME , CM.CLN_DATE , CM.CRETNO , (SELECT OCRTAGPRNTYN FROM V_EFORM_FORMDOC F WHERE F.FORM_RID = CM.FORM_RID ) AS OCRTAGPRNTYN FROM CONSENT_MST CM INNER JOIN EFORM_DOCUMENT VEF ON VEF.FORM_RID = CM.FORM_RID, EMR.MRFMFORM C WHERE CM.USE_YN = 'Y' AND CM.PID = :param0 AND TO_CHAR(TO_DATE(CM.CREATE_DATETIME, 'YYYY-MM-DD HH24:MI:SS'), 'YYYYMMDD') BETWEEN :param1 and :param2 AND VEF.FORM_CD = C.FORMCD AND C.instcd = '111' AND C.formprogflag LIKE 'OCR%' AND C.formlevlcd != '-' AND CM.HOS_TYPE = '111' AND SUBSTR (C.formtodt, 1, 8) = '99991231' AND CM.CONSENT_STATE IN ('UNFINISHED','TEMP') ORDER BY OCR_NUMBER DESC, CONSENT_STATE ASC] [Logging Date Time: 2016-12-21 14:58:35,355] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_LIST] PreparedStatement : [SELECT CM.CONSENT_MST_RID , DECODE(CM.CONSENT_STATE, 'TEMP' ,'ÀÓ½ÃÀúÀå', 'ELECTR_CMP', '¼­¸í', 'PAPER_OUT', 'Ãâ·Â' , 'CERTIFY_CMP', 'ÀÎÁõ', 'UNFINISHED', '¹ÌÀÛ¼º', 'VERBAL', '±¸µÎ') AS CONSENT_STATE_DISP , VEF.FORM_NAME AS CONSENT_NAME , CM.HOS_TYPE , CM.PID , CM.VISIT_TYPE , CM.ORDER_NO , CM.ORDER_CD , CM.ORDER_NAME , CM.CLN_DEPT_CD , (SELECT DEPTHNGNM FROM COM.ZSDDDEPT WHERE DEPTCD = CM.CLN_DEPT_CD and valitodd = '99991231' and instcd = '111') AS CLN_DEPT_NM , COM.FN_ZS_GETDEPTNAME('111', (select dept.deptcd from com.zsdddept dept where dept.instcd = '111' and dept.valitodd = '99991231' and dept.deptengabbr = CM.WARDCD), '99991231') as WARDCD , CM.ROOMCD , CM.FORM_RID , VEF.FORM_CD , VEF.FORM_GUID , C.PRNTCNT , CM.CONSENT_STATE AS CONSENT_STATE , CM.OCR_NUMBER , CM.COSIGN_DC_ID , CM.COSIGN_DC_NAME , CM.MODIFY_USER_ID AS CREATE_USER_ID , CM.MODIFY_USER_NAME AS CREATE_USER_NAME , CM.MODIFY_DATETIME AS CREATE_DATETIME , CM.CLN_DATE , CM.CRETNO , (SELECT OCRTAGPRNTYN FROM V_EFORM_FORMDOC F WHERE F.FORM_RID = CM.FORM_RID ) AS OCRTAGPRNTYN FROM CONSENT_MST CM INNER JOIN EFORM_DOCUMENT VEF ON VEF.FORM_RID = CM.FORM_RID, EMR.MRFMFORM C WHERE CM.USE_YN = 'Y' AND CM.PID = :param0 AND TO_CHAR(TO_DATE(CM.CREATE_DATETIME, 'YYYY-MM-DD HH24:MI:SS'), 'YYYYMMDD') BETWEEN :param1 and :param2 AND VEF.FORM_CD = C.FORMCD AND C.instcd = '111' AND C.formprogflag LIKE 'OCR%' AND C.formlevlcd != '-' AND CM.HOS_TYPE = '111' AND SUBSTR (C.formtodt, 1, 8) = '99991231' AND CM.CONSENT_STATE IN ('UNFINISHED','TEMP') ORDER BY OCR_NUMBER DESC, CONSENT_STATE ASC] [Logging Date Time: 2016-12-21 14:58:35,356] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_LIST] Parameters: [param0=[patientCode,1462723], param1=[startDt,20010601], param2=[endDt,20161221]] [Logging Date Time: 2016-12-21 14:58:35,356] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_LIST] Parameters: [param0=[patientCode,1462723], param1=[startDt,20010601], param2=[endDt,20161221]] [Logging Date Time: 2016-12-21 14:58:35,356] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_LIST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]] [Logging Date Time: 2016-12-21 14:58:35,356] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_LIST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]] [Logging Date Time: 2016-12-21 14:58:35,544] ===================================================================================== SQL Command - Statement Id: [getDeptList] PreparedStatement : [SELECT ' ' as deptcd, 'Áø·á°ú' as deptnm, 0 as clincdeptdispseq, 0 as sort from dual UNION ALL SELECT deptcd, depthngnm as deptnm, clincdeptdispseq, 1 as sort FROM com.zsdddept WHERE instcd = :param0 AND TO_CHAR(CURRENT_DATE,'YYYYMMDD')>=valifromdd AND TO_CHAR(CURRENT_DATE,'YYYYMMDD')<=valitodd AND rcptuseyn = 'Y' ORDER BY clincdeptdispseq ASC] [Logging Date Time: 2016-12-21 14:58:35,544] ===================================================================================== SQL Command - Statement Id: [getDeptList] PreparedStatement : [SELECT ' ' as deptcd, 'Áø·á°ú' as deptnm, 0 as clincdeptdispseq, 0 as sort from dual UNION ALL SELECT deptcd, depthngnm as deptnm, clincdeptdispseq, 1 as sort FROM com.zsdddept WHERE instcd = :param0 AND TO_CHAR(CURRENT_DATE,'YYYYMMDD')>=valifromdd AND TO_CHAR(CURRENT_DATE,'YYYYMMDD')<=valitodd AND rcptuseyn = 'Y' ORDER BY clincdeptdispseq ASC] [Logging Date Time: 2016-12-21 14:58:35,544] ===================================================================================== SQL Command - Statement Id: [getDeptList] Parameters: [param0=[instcd,111]] [Logging Date Time: 2016-12-21 14:58:35,544] ===================================================================================== SQL Command - Statement Id: [getDeptList] Parameters: [param0=[instcd,111]] [Logging Date Time: 2016-12-21 14:58:35,544] ===================================================================================== SQL Command - Statement Id: [getDeptList] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-12-21 14:58:35,544] ===================================================================================== SQL Command - Statement Id: [getDeptList] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-12-21 14:58:35,698] ===================================================================================== SQL Command - Statement Id: [getDocList] PreparedStatement : [SELECT ' ' as doctorid, 'Áø·áÀÇ' as doctornm, 1 as sort from dual UNION ALL SELECT b.userid AS doctorid, b.usernm AS doctornm, 2 as sort FROM com.zsumusrd a INNER JOIN com.zsumusrb b ON a.userid = b.userid WHERE a.psnworkyn = 'N' AND a.dutplceinstcd = :param0 AND a.jobkindcd LIKE '03%' AND a.dutplcecd = :param1 AND :param2 BETWEEN a.fromdd AND a.todd AND :param2 BETWEEN b.userfromdd AND b.usertodd ORDER BY sort, doctorid] [Logging Date Time: 2016-12-21 14:58:35,698] ===================================================================================== SQL Command - Statement Id: [getDocList] PreparedStatement : [SELECT ' ' as doctorid, 'Áø·áÀÇ' as doctornm, 1 as sort from dual UNION ALL SELECT b.userid AS doctorid, b.usernm AS doctornm, 2 as sort FROM com.zsumusrd a INNER JOIN com.zsumusrb b ON a.userid = b.userid WHERE a.psnworkyn = 'N' AND a.dutplceinstcd = :param0 AND a.jobkindcd LIKE '03%' AND a.dutplcecd = :param1 AND :param2 BETWEEN a.fromdd AND a.todd AND :param2 BETWEEN b.userfromdd AND b.usertodd ORDER BY sort, doctorid] [Logging Date Time: 2016-12-21 14:58:35,698] ===================================================================================== SQL Command - Statement Id: [getDocList] Parameters: [param0=[instcd,111], param1=[orddeptcd, ], param2=[srchdd,20161221]] [Logging Date Time: 2016-12-21 14:58:35,698] ===================================================================================== SQL Command - Statement Id: [getDocList] Parameters: [param0=[instcd,111], param1=[orddeptcd, ], param2=[srchdd,20161221]] [Logging Date Time: 2016-12-21 14:58:35,699] ===================================================================================== SQL Command - Statement Id: [getDocList] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]] [Logging Date Time: 2016-12-21 14:58:35,699] ===================================================================================== SQL Command - Statement Id: [getDocList] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]] [Logging Date Time: 2016-12-21 14:58:35,747] ===================================================================================== SQL Command - Statement Id: [getDocList] PreparedStatement : [SELECT ' ' as doctorid, 'Áø·áÀÇ' as doctornm, 1 as sort from dual UNION ALL SELECT b.userid AS doctorid, b.usernm AS doctornm, 2 as sort FROM com.zsumusrd a INNER JOIN com.zsumusrb b ON a.userid = b.userid WHERE a.psnworkyn = 'N' AND a.dutplceinstcd = :param0 AND a.jobkindcd LIKE '03%' AND a.dutplcecd in ('2040000000', '2040400000') AND :param1 BETWEEN a.fromdd AND a.todd AND :param1 BETWEEN b.userfromdd AND b.usertodd ORDER BY sort, doctorid] [Logging Date Time: 2016-12-21 14:58:35,747] ===================================================================================== SQL Command - Statement Id: [getDocList] PreparedStatement : [SELECT ' ' as doctorid, 'Áø·áÀÇ' as doctornm, 1 as sort from dual UNION ALL SELECT b.userid AS doctorid, b.usernm AS doctornm, 2 as sort FROM com.zsumusrd a INNER JOIN com.zsumusrb b ON a.userid = b.userid WHERE a.psnworkyn = 'N' AND a.dutplceinstcd = :param0 AND a.jobkindcd LIKE '03%' AND a.dutplcecd in ('2040000000', '2040400000') AND :param1 BETWEEN a.fromdd AND a.todd AND :param1 BETWEEN b.userfromdd AND b.usertodd ORDER BY sort, doctorid] [Logging Date Time: 2016-12-21 14:58:35,748] ===================================================================================== SQL Command - Statement Id: [getDocList] Parameters: [param0=[instcd,111], param1=[srchdd,20161221]] [Logging Date Time: 2016-12-21 14:58:35,748] ===================================================================================== SQL Command - Statement Id: [getDocList] Parameters: [param0=[instcd,111], param1=[srchdd,20161221]] [Logging Date Time: 2016-12-21 14:58:35,748] ===================================================================================== SQL Command - Statement Id: [getDocList] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String]] [Logging Date Time: 2016-12-21 14:58:35,748] ===================================================================================== SQL Command - Statement Id: [getDocList] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String]] [Logging Date Time: 2016-12-21 14:58:38,974] ===================================================================================== SQL Command - Statement Id: [getWardList] PreparedStatement : [SELECT ' ' as deptcd, 'Àüü' as deptnm, 1 as sort from dual UNION ALL select dept.deptcd as deptcd, dept.depthngnm as deptnm, 2 as sort from com.zsdddept dept where dept.instcd = '111' and dept.orddeptflag = 'W' and dept.orduseyn = 'Y' and dept.valifromdd <= to_char(sysdate,'yyyymmdd') and dept.valitodd >= to_char(sysdate,'yyyymmdd') order by sort, deptnm asc] [Logging Date Time: 2016-12-21 14:58:38,974] ===================================================================================== SQL Command - Statement Id: [getWardList] PreparedStatement : [SELECT ' ' as deptcd, 'Àüü' as deptnm, 1 as sort from dual UNION ALL select dept.deptcd as deptcd, dept.depthngnm as deptnm, 2 as sort from com.zsdddept dept where dept.instcd = '111' and dept.orddeptflag = 'W' and dept.orduseyn = 'Y' and dept.valifromdd <= to_char(sysdate,'yyyymmdd') and dept.valitodd >= to_char(sysdate,'yyyymmdd') order by sort, deptnm asc] [Logging Date Time: 2016-12-21 14:58:39,112] ===================================================================================== SQL Command - Statement Id: [getDeptList] PreparedStatement : [SELECT ' ' as deptcd, 'Áø·á°ú' as deptnm, 0 as clincdeptdispseq, 0 as sort from dual UNION ALL SELECT deptcd, depthngnm as deptnm, clincdeptdispseq, 1 as sort FROM com.zsdddept WHERE instcd = :param0 AND TO_CHAR(CURRENT_DATE,'YYYYMMDD')>=valifromdd AND TO_CHAR(CURRENT_DATE,'YYYYMMDD')<=valitodd AND rcptuseyn = 'Y' ORDER BY clincdeptdispseq ASC] [Logging Date Time: 2016-12-21 14:58:39,112] ===================================================================================== SQL Command - Statement Id: [getDeptList] PreparedStatement : [SELECT ' ' as deptcd, 'Áø·á°ú' as deptnm, 0 as clincdeptdispseq, 0 as sort from dual UNION ALL SELECT deptcd, depthngnm as deptnm, clincdeptdispseq, 1 as sort FROM com.zsdddept WHERE instcd = :param0 AND TO_CHAR(CURRENT_DATE,'YYYYMMDD')>=valifromdd AND TO_CHAR(CURRENT_DATE,'YYYYMMDD')<=valitodd AND rcptuseyn = 'Y' ORDER BY clincdeptdispseq ASC] [Logging Date Time: 2016-12-21 14:58:39,112] ===================================================================================== SQL Command - Statement Id: [getDeptList] Parameters: [param0=[instcd,111]] [Logging Date Time: 2016-12-21 14:58:39,112] ===================================================================================== SQL Command - Statement Id: [getDeptList] Parameters: [param0=[instcd,111]] [Logging Date Time: 2016-12-21 14:58:39,113] ===================================================================================== SQL Command - Statement Id: [getDeptList] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-12-21 14:58:39,113] ===================================================================================== SQL Command - Statement Id: [getDeptList] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-12-21 14:58:39,289] ===================================================================================== SQL Command - Statement Id: [getDocList] PreparedStatement : [SELECT ' ' as doctorid, 'Áø·áÀÇ' as doctornm, 1 as sort from dual UNION ALL SELECT b.userid AS doctorid, b.usernm AS doctornm, 2 as sort FROM com.zsumusrd a INNER JOIN com.zsumusrb b ON a.userid = b.userid WHERE a.psnworkyn = 'N' AND a.dutplceinstcd = :param0 AND a.jobkindcd LIKE '03%' AND a.dutplcecd = :param1 AND :param2 BETWEEN a.fromdd AND a.todd AND :param2 BETWEEN b.userfromdd AND b.usertodd ORDER BY sort, doctorid] [Logging Date Time: 2016-12-21 14:58:39,289] ===================================================================================== SQL Command - Statement Id: [getDocList] PreparedStatement : [SELECT ' ' as doctorid, 'Áø·áÀÇ' as doctornm, 1 as sort from dual UNION ALL SELECT b.userid AS doctorid, b.usernm AS doctornm, 2 as sort FROM com.zsumusrd a INNER JOIN com.zsumusrb b ON a.userid = b.userid WHERE a.psnworkyn = 'N' AND a.dutplceinstcd = :param0 AND a.jobkindcd LIKE '03%' AND a.dutplcecd = :param1 AND :param2 BETWEEN a.fromdd AND a.todd AND :param2 BETWEEN b.userfromdd AND b.usertodd ORDER BY sort, doctorid] [Logging Date Time: 2016-12-21 14:58:39,290] ===================================================================================== SQL Command - Statement Id: [getDocList] Parameters: [param0=[instcd,111], param1=[orddeptcd, ], param2=[srchdd,20161221]] [Logging Date Time: 2016-12-21 14:58:39,290] ===================================================================================== SQL Command - Statement Id: [getDocList] Parameters: [param0=[instcd,111], param1=[orddeptcd, ], param2=[srchdd,20161221]] [Logging Date Time: 2016-12-21 14:58:39,290] ===================================================================================== SQL Command - Statement Id: [getDocList] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]] [Logging Date Time: 2016-12-21 14:58:39,290] ===================================================================================== SQL Command - Statement Id: [getDocList] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]] [Logging Date Time: 2016-12-21 14:58:41,067] ===================================================================================== SQL Command - Statement Id: [getInPatList] PreparedStatement : [SELECT distinct ptbs.pid AS pid, substr(inpt.indd,1,4) || '/' || substr(inpt.indd,5,2) || '/' || substr(inpt.indd,7,2) AS indd, inpt.indd AS orddd, inpt.cretno AS cretno, inpt.seqno AS seqno, inpt.instcd AS instcd, ptbs.hngnm AS hngnm, (select code.cdnm from com.zbcmcode code where code.cdgrupid = 'P0021' and code.valifromdd <= inpt.indd and code.valitodd >= inpt.indd and code.cdid = inpt.fsexamflag) AS fsexamflag, /*+ index_desc(icdr IX_PMIHICDR_03) */ icdr.orddeptcd AS orddeptcd, icdr.medispclid AS doctorid, TO_DATE('20161221') - TO_DATE(inpt.indd) AS hd, TRIM(ptbs.sex || '/' || LPAD(FLOOR(COM.FN_ZZ_GETAGE_EMR2('000000','0000000','20161221', 'B', ptbs.brthdd) / 12), 2, 0) || 'y' || LPAD(MOD(COM.FN_ZZ_GETAGE_EMR2('000000','0000000','20161221', 'B', ptbs.brthdd), 12), 2, 0) || 'm') AS sa, dept.depthngnm AS deptnm, dept.DEPTENGABBR AS deptengabbr, NVL((SELECT usernm FROM com.zsumusrb WHERE userid = icdr.medispclid AND userfromdd <= :param0 AND usertodd >= :param0 ), '-') AS doctornm, (SELECT term.termengnm FROM emr.mmohdiag diag, emr.mrtmterm term WHERE diag.diagcd = term.termcd AND diag.instcd = term.instcd AND diag.diagdd >= term.termfromdd AND diag.diagdd <= term.termtodd AND diag.pid = inpt.pid AND diag.orddd = inpt.indd AND diag.cretno = inpt.cretno AND diag.orddeptcd = icdr.orddeptcd AND diag.instcd = inpt.instcd AND diag.diaghistcd = 'O' AND diag.diagtypecd = 'D' AND diag.diagkindcdflag = 'M' AND ROWNUM = 1) AS diagnm, CASE inpt.indschacptstat WHEN 'D' THEN 'Åð¿ø' WHEN 'T' THEN '°¡Åð¿ø' ELSE (CASE inpt.dschnotiyn WHEN 'Y' THEN 'Åð¿øÅ뺸' ELSE (CASE inpt.dschdclrtyn WHEN 'Y' THEN 'Åð¿ø¿¹°í' ELSE '-' END) END) END AS dschnoti, icdr.roomcd AS roomcd, CASE WHEN (SELECT COUNT(instcd) FROM emr.mmrhcnstinfo WHERE pid = inpt.pid AND orddd = inpt.indd AND cretno = inpt.cretno AND reqdd = :param0 AND chosflag IN ('I','E') AND cnstflag IN ('1','2') AND ROWNUM = 1) > 0 THEN 'Y' ELSE 'N' END AS cnst, icdr.ordtype AS ordtype, (SELECT z.cdnm FROM com.zbcmcode z WHERE inpt.insukind = z.cdid AND z.cdgrupid = 'P0008' AND inpt.indd BETWEEN z.valifromdd AND z.valitodd) AS bostyle, 'N' AS elbulbodstat, 'N' AS ordtm FROM pam.pmihinpt inpt, pam.pmihicdr icdr, com.zsdddept dept, pam.pmcmptbs ptbs WHERE inpt.histstat = 'Y' AND inpt.mskind = 'M' AND icdr.ordtype IN ('I', 'D') AND inpt.instcd = :param1 AND inpt.pid = icdr.pid AND inpt.pid = icdr.pid AND inpt.indd = icdr.indd AND inpt.cretno = icdr.cretno AND inpt.instcd = icdr.instcd AND inpt.histstat = icdr.histstat AND icdr.fromdd <= :param0 AND icdr.todd >= :param0 AND icdr.pid = ptbs.pid AND icdr.instcd = ptbs.instcd AND icdr.instcd = dept.instcd AND icdr.orddeptcd = dept.deptcd AND dept.orddeptflag = 'D' AND dept.orduseyn = 'Y' AND dept.valifromdd <= :param0 AND dept.valitodd >= :param0 AND icdr.wardcd = :param2 AND icdr.indschacptstat IN ('A', 'D', 'T') order by roomcd, hngnm] [Logging Date Time: 2016-12-21 14:58:41,067] ===================================================================================== SQL Command - Statement Id: [getInPatList] PreparedStatement : [SELECT distinct ptbs.pid AS pid, substr(inpt.indd,1,4) || '/' || substr(inpt.indd,5,2) || '/' || substr(inpt.indd,7,2) AS indd, inpt.indd AS orddd, inpt.cretno AS cretno, inpt.seqno AS seqno, inpt.instcd AS instcd, ptbs.hngnm AS hngnm, (select code.cdnm from com.zbcmcode code where code.cdgrupid = 'P0021' and code.valifromdd <= inpt.indd and code.valitodd >= inpt.indd and code.cdid = inpt.fsexamflag) AS fsexamflag, /*+ index_desc(icdr IX_PMIHICDR_03) */ icdr.orddeptcd AS orddeptcd, icdr.medispclid AS doctorid, TO_DATE('20161221') - TO_DATE(inpt.indd) AS hd, TRIM(ptbs.sex || '/' || LPAD(FLOOR(COM.FN_ZZ_GETAGE_EMR2('000000','0000000','20161221', 'B', ptbs.brthdd) / 12), 2, 0) || 'y' || LPAD(MOD(COM.FN_ZZ_GETAGE_EMR2('000000','0000000','20161221', 'B', ptbs.brthdd), 12), 2, 0) || 'm') AS sa, dept.depthngnm AS deptnm, dept.DEPTENGABBR AS deptengabbr, NVL((SELECT usernm FROM com.zsumusrb WHERE userid = icdr.medispclid AND userfromdd <= :param0 AND usertodd >= :param0 ), '-') AS doctornm, (SELECT term.termengnm FROM emr.mmohdiag diag, emr.mrtmterm term WHERE diag.diagcd = term.termcd AND diag.instcd = term.instcd AND diag.diagdd >= term.termfromdd AND diag.diagdd <= term.termtodd AND diag.pid = inpt.pid AND diag.orddd = inpt.indd AND diag.cretno = inpt.cretno AND diag.orddeptcd = icdr.orddeptcd AND diag.instcd = inpt.instcd AND diag.diaghistcd = 'O' AND diag.diagtypecd = 'D' AND diag.diagkindcdflag = 'M' AND ROWNUM = 1) AS diagnm, CASE inpt.indschacptstat WHEN 'D' THEN 'Åð¿ø' WHEN 'T' THEN '°¡Åð¿ø' ELSE (CASE inpt.dschnotiyn WHEN 'Y' THEN 'Åð¿øÅ뺸' ELSE (CASE inpt.dschdclrtyn WHEN 'Y' THEN 'Åð¿ø¿¹°í' ELSE '-' END) END) END AS dschnoti, icdr.roomcd AS roomcd, CASE WHEN (SELECT COUNT(instcd) FROM emr.mmrhcnstinfo WHERE pid = inpt.pid AND orddd = inpt.indd AND cretno = inpt.cretno AND reqdd = :param0 AND chosflag IN ('I','E') AND cnstflag IN ('1','2') AND ROWNUM = 1) > 0 THEN 'Y' ELSE 'N' END AS cnst, icdr.ordtype AS ordtype, (SELECT z.cdnm FROM com.zbcmcode z WHERE inpt.insukind = z.cdid AND z.cdgrupid = 'P0008' AND inpt.indd BETWEEN z.valifromdd AND z.valitodd) AS bostyle, 'N' AS elbulbodstat, 'N' AS ordtm FROM pam.pmihinpt inpt, pam.pmihicdr icdr, com.zsdddept dept, pam.pmcmptbs ptbs WHERE inpt.histstat = 'Y' AND inpt.mskind = 'M' AND icdr.ordtype IN ('I', 'D') AND inpt.instcd = :param1 AND inpt.pid = icdr.pid AND inpt.pid = icdr.pid AND inpt.indd = icdr.indd AND inpt.cretno = icdr.cretno AND inpt.instcd = icdr.instcd AND inpt.histstat = icdr.histstat AND icdr.fromdd <= :param0 AND icdr.todd >= :param0 AND icdr.pid = ptbs.pid AND icdr.instcd = ptbs.instcd AND icdr.instcd = dept.instcd AND icdr.orddeptcd = dept.deptcd AND dept.orddeptflag = 'D' AND dept.orduseyn = 'Y' AND dept.valifromdd <= :param0 AND dept.valitodd >= :param0 AND icdr.wardcd = :param2 AND icdr.indschacptstat IN ('A', 'D', 'T') order by roomcd, hngnm] [Logging Date Time: 2016-12-21 14:58:41,068] ===================================================================================== SQL Command - Statement Id: [getInPatList] Parameters: [param0=[srchdd,20161221], param1=[instcd,111], param2=[wardcd,3041400000]] [Logging Date Time: 2016-12-21 14:58:41,068] ===================================================================================== SQL Command - Statement Id: [getInPatList] Parameters: [param0=[srchdd,20161221], param1=[instcd,111], param2=[wardcd,3041400000]] [Logging Date Time: 2016-12-21 14:58:41,068] ===================================================================================== SQL Command - Statement Id: [getInPatList] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]] [Logging Date Time: 2016-12-21 14:58:41,068] ===================================================================================== SQL Command - Statement Id: [getInPatList] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]] [Logging Date Time: 2016-12-21 14:58:42,772] ===================================================================================== SQL Command - Statement Id: [GET_USER_INFO] PreparedStatement : [select a.userid, a.usernm, b.dutplcecd, dept.depthngnm, dept.deptengabbr, b.jobkindcd, (select cdnm from com.zbcmcode code where code.cdgrupid = 'R0061' and code.cdid = b.jobkindcd and code.valitodd = '99991231') from com.zsumusrb a, com.zsumusrd b, com.zsdddept dept where a.dutinstcd = '111' and a.dutinstcd = b.dutplceinstcd and a.userid = b.userid and a.usertodd = b.todd and dept.instcd = a.dutinstcd and dept.deptcd = b.dutplcecd and dept.valitodd = '99991231' and a.usertodd = '99991231' and b.userid = :param0] [Logging Date Time: 2016-12-21 14:58:42,772] ===================================================================================== SQL Command - Statement Id: [GET_USER_INFO] PreparedStatement : [select a.userid, a.usernm, b.dutplcecd, dept.depthngnm, dept.deptengabbr, b.jobkindcd, (select cdnm from com.zbcmcode code where code.cdgrupid = 'R0061' and code.cdid = b.jobkindcd and code.valitodd = '99991231') from com.zsumusrb a, com.zsumusrd b, com.zsdddept dept where a.dutinstcd = '111' and a.dutinstcd = b.dutplceinstcd and a.userid = b.userid and a.usertodd = b.todd and dept.instcd = a.dutinstcd and dept.deptcd = b.dutplcecd and dept.valitodd = '99991231' and a.usertodd = '99991231' and b.userid = :param0] [Logging Date Time: 2016-12-21 14:58:42,773] ===================================================================================== SQL Command - Statement Id: [GET_USER_INFO] Parameters: [param0=[userid,104876]] [Logging Date Time: 2016-12-21 14:58:42,773] ===================================================================================== SQL Command - Statement Id: [GET_USER_INFO] Parameters: [param0=[userid,104876]] [Logging Date Time: 2016-12-21 14:58:42,773] ===================================================================================== SQL Command - Statement Id: [GET_USER_INFO] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-12-21 14:58:42,773] ===================================================================================== SQL Command - Statement Id: [GET_USER_INFO] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-12-21 14:58:42,827] ===================================================================================== SQL Command - Statement Id: [getPatientInfoIn] PreparedStatement : [SELECT a.orddeptcd, a.pid as IO_Pt_ID, to_char(a.cretno) as IO_CretNo, (ptbs.sex || '/' || com.fn_zz_getageas(ptbs.rrgstno1, ptbs.rrgstno2, TO_CHAR(SYSDATE, 'YYYYMMDD'), 'A', ptbs.brthdd)) as IO_sex_age_y_m, ptbs.hngnm as IO_Pt_Name, (ptbs.rrgstno1 || '-' || substr(ptbs.rrgstno2, 1, 1) || '******') IO_JuminNo, ptbs.zipcdaddr as IO_Zipcdaddr, ptbs.mpphontel as IO_Tel, (select cdnm from com.zbcmcode where cdgrupid = 'P0008' and cdid = a.insukind) as IO_Insukind, (select dept.DEPTENGABBR from com.zsdddept dept where dept.deptcd = a.wardcd and dept.instcd = a.instcd and dept.valitodd >= a.indd and dept.valifromdd <= a.indd) as IO_Ward, a.roomcd as IO_roomNO, a.indd as IO_ADdate, a.dschdd as IO_Dschdd, a.ordtype as IO_VisitType, a.orddeptcd as IO_DeptCd, (select dept.deptengabbr from com.zsdddept dept where dept.deptcd = a.orddeptcd and dept.instcd = a.instcd and dept.valitodd >= a.indd and dept.valifromdd <= a.indd) as IO_DeptNm, COM.FN_ZS_GETDEPTNAME(a.instcd, a.orddeptcd, a.indd) AS IO_Dept2, '' AS IO_OPdeptCd, '' AS IO_OPdeptNm, '' AS IO_OPdrNm, '' AS IO_OPdrId, (SELECT diag.diagcd FROM emr.mmohdiag diag WHERE diag.pid = a.pid AND diag.orddd = a.indd AND diag.cretno = a.cretno AND diag.diaghistcd = 'O' AND diag.diagtypecd = 'D' AND diag.diagkindcdflag = 'M' AND diag.genrflagcd = a.ordtype and diag.orddeptcd = a.orddeptcd AND diag.diaghistno = (select max(diagh.diaghistno) from emr.mmohdiag diagh where diagh.pid = a.pid AND diagh.orddd = a.indd AND diagh.cretno = a.cretno AND diagh.instcd = '111' AND diagh.diaghistcd = 'O' AND diagh.diagkindcdflag = 'M' AND diagh.genrflagcd = a.ordtype and diagh.orddeptcd = a.orddeptcd group by pid)) as IO_DxCd, (SELECT term.diaghngnm FROM emr.mmohdiag diag, emr.mmbvdiag term WHERE diag.pid = a.pid AND diag.orddd = a.indd AND diag.cretno = a.cretno AND diag.instcd = term.instcd AND diag.diagcd = term.orgdiagcd AND diag.diaghistcd = 'O' AND diag.diagtypecd = 'D' AND diag.diagkindcdflag = 'M' AND diag.diagdd >= term.termfromdd AND diag.diagdd <= term.termtodd AND diag.diagdd >= term.diagattrfromdd AND diag.diagdd <= term.diagattrtodd AND diag.genrflagcd = a.ordtype and diag.orddeptcd = a.orddeptcd AND diag.diaghistno = (select max(diagh.diaghistno) from emr.mmohdiag diagh where diagh.pid = a.pid AND diagh.orddd = a.indd AND diagh.cretno = a.cretno AND diagh.instcd = '111' AND diagh.diaghistcd = 'O' AND diagh.diagkindcdflag = 'M' AND diagh.genrflagcd = a.ordtype and diagh.orddeptcd = a.orddeptcd group by pid)) as IO_DxNm, '111' as IO_HosType, case when ex.bp is null then null else ex.bp end as IO_bp, case when ex.dm is null then null else ex.dm end as IO_dm, case when ex.heart is null then null else ex.heart end as IO_heart, case when ex.kidney is null then null else ex.kidney end as IO_kidney, case when ex.respiration is null then null else ex.respiration end as IO_respiration, case when ex.hx is null then null else ex.hx end as IO_hx, case when ex.allergy is null then null else ex.allergy end as IO_allergy, case when ex.drug is null then null else ex.drug end as IO_drug, case when ex.smoking is null then null else ex.smoking end as IO_smoking, case when ex.idio is null then null else ex.idio end as IO_idio, case when ex.nacrotics is null then null else ex.nacrotics end as IO_nacrotics, case when ex.airway is null then null else ex.airway end as IO_airway, case when ex.hemorrhage is null then null else ex.hemorrhage end as IO_hemorrhage, ex.etc IO_status_etc, '' as IO_OrderNo, '111' as IO_PrintTime, a.medispclid as IO_MaindrId, COM.FN_ZS_GETUSERNM(a.ermedispclid, a.indd) as IO_ErdrNm, COM.FN_ZS_GETUSERNM(a.medispclid, a.indd) as IO_MaindrNm, '111' as IO_OcrCd, '111' as IO_InputId, '111' as IO_InputNm, '111' as IO_SignImg, a.fstrgstdt FROM pam.pmihinpt a left outer join cmr.consent_data_ex ex on (ex.pid = a.pid and ex.cln_date = a.indd) left outer join pam.pmcmptbs ptbs on (ptbs.pid = a.pid and ptbs.instcd = a.instcd) WHERE a.instcd = :param0 AND a.pid = :param1 AND a.indd = :param2 AND a.histstat = 'Y' AND a.mskind = 'M' AND a.cretno = :param3 AND a.orddeptcd = :param4 order by a.fstrgstdt desc] [Logging Date Time: 2016-12-21 14:58:42,827] ===================================================================================== SQL Command - Statement Id: [getPatientInfoIn] PreparedStatement : [SELECT a.orddeptcd, a.pid as IO_Pt_ID, to_char(a.cretno) as IO_CretNo, (ptbs.sex || '/' || com.fn_zz_getageas(ptbs.rrgstno1, ptbs.rrgstno2, TO_CHAR(SYSDATE, 'YYYYMMDD'), 'A', ptbs.brthdd)) as IO_sex_age_y_m, ptbs.hngnm as IO_Pt_Name, (ptbs.rrgstno1 || '-' || substr(ptbs.rrgstno2, 1, 1) || '******') IO_JuminNo, ptbs.zipcdaddr as IO_Zipcdaddr, ptbs.mpphontel as IO_Tel, (select cdnm from com.zbcmcode where cdgrupid = 'P0008' and cdid = a.insukind) as IO_Insukind, (select dept.DEPTENGABBR from com.zsdddept dept where dept.deptcd = a.wardcd and dept.instcd = a.instcd and dept.valitodd >= a.indd and dept.valifromdd <= a.indd) as IO_Ward, a.roomcd as IO_roomNO, a.indd as IO_ADdate, a.dschdd as IO_Dschdd, a.ordtype as IO_VisitType, a.orddeptcd as IO_DeptCd, (select dept.deptengabbr from com.zsdddept dept where dept.deptcd = a.orddeptcd and dept.instcd = a.instcd and dept.valitodd >= a.indd and dept.valifromdd <= a.indd) as IO_DeptNm, COM.FN_ZS_GETDEPTNAME(a.instcd, a.orddeptcd, a.indd) AS IO_Dept2, '' AS IO_OPdeptCd, '' AS IO_OPdeptNm, '' AS IO_OPdrNm, '' AS IO_OPdrId, (SELECT diag.diagcd FROM emr.mmohdiag diag WHERE diag.pid = a.pid AND diag.orddd = a.indd AND diag.cretno = a.cretno AND diag.diaghistcd = 'O' AND diag.diagtypecd = 'D' AND diag.diagkindcdflag = 'M' AND diag.genrflagcd = a.ordtype and diag.orddeptcd = a.orddeptcd AND diag.diaghistno = (select max(diagh.diaghistno) from emr.mmohdiag diagh where diagh.pid = a.pid AND diagh.orddd = a.indd AND diagh.cretno = a.cretno AND diagh.instcd = '111' AND diagh.diaghistcd = 'O' AND diagh.diagkindcdflag = 'M' AND diagh.genrflagcd = a.ordtype and diagh.orddeptcd = a.orddeptcd group by pid)) as IO_DxCd, (SELECT term.diaghngnm FROM emr.mmohdiag diag, emr.mmbvdiag term WHERE diag.pid = a.pid AND diag.orddd = a.indd AND diag.cretno = a.cretno AND diag.instcd = term.instcd AND diag.diagcd = term.orgdiagcd AND diag.diaghistcd = 'O' AND diag.diagtypecd = 'D' AND diag.diagkindcdflag = 'M' AND diag.diagdd >= term.termfromdd AND diag.diagdd <= term.termtodd AND diag.diagdd >= term.diagattrfromdd AND diag.diagdd <= term.diagattrtodd AND diag.genrflagcd = a.ordtype and diag.orddeptcd = a.orddeptcd AND diag.diaghistno = (select max(diagh.diaghistno) from emr.mmohdiag diagh where diagh.pid = a.pid AND diagh.orddd = a.indd AND diagh.cretno = a.cretno AND diagh.instcd = '111' AND diagh.diaghistcd = 'O' AND diagh.diagkindcdflag = 'M' AND diagh.genrflagcd = a.ordtype and diagh.orddeptcd = a.orddeptcd group by pid)) as IO_DxNm, '111' as IO_HosType, case when ex.bp is null then null else ex.bp end as IO_bp, case when ex.dm is null then null else ex.dm end as IO_dm, case when ex.heart is null then null else ex.heart end as IO_heart, case when ex.kidney is null then null else ex.kidney end as IO_kidney, case when ex.respiration is null then null else ex.respiration end as IO_respiration, case when ex.hx is null then null else ex.hx end as IO_hx, case when ex.allergy is null then null else ex.allergy end as IO_allergy, case when ex.drug is null then null else ex.drug end as IO_drug, case when ex.smoking is null then null else ex.smoking end as IO_smoking, case when ex.idio is null then null else ex.idio end as IO_idio, case when ex.nacrotics is null then null else ex.nacrotics end as IO_nacrotics, case when ex.airway is null then null else ex.airway end as IO_airway, case when ex.hemorrhage is null then null else ex.hemorrhage end as IO_hemorrhage, ex.etc IO_status_etc, '' as IO_OrderNo, '111' as IO_PrintTime, a.medispclid as IO_MaindrId, COM.FN_ZS_GETUSERNM(a.ermedispclid, a.indd) as IO_ErdrNm, COM.FN_ZS_GETUSERNM(a.medispclid, a.indd) as IO_MaindrNm, '111' as IO_OcrCd, '111' as IO_InputId, '111' as IO_InputNm, '111' as IO_SignImg, a.fstrgstdt FROM pam.pmihinpt a left outer join cmr.consent_data_ex ex on (ex.pid = a.pid and ex.cln_date = a.indd) left outer join pam.pmcmptbs ptbs on (ptbs.pid = a.pid and ptbs.instcd = a.instcd) WHERE a.instcd = :param0 AND a.pid = :param1 AND a.indd = :param2 AND a.histstat = 'Y' AND a.mskind = 'M' AND a.cretno = :param3 AND a.orddeptcd = :param4 order by a.fstrgstdt desc] [Logging Date Time: 2016-12-21 14:58:42,828] ===================================================================================== SQL Command - Statement Id: [getPatientInfoIn] Parameters: [param0=[instcd,111], param1=[pid,0957205], param2=[orddd,20161209], param3=[cretno,1], param4=[orddeptcd,2010300000]] [Logging Date Time: 2016-12-21 14:58:42,828] ===================================================================================== SQL Command - Statement Id: [getPatientInfoIn] Parameters: [param0=[instcd,111], param1=[pid,0957205], param2=[orddd,20161209], param3=[cretno,1], param4=[orddeptcd,2010300000]] [Logging Date Time: 2016-12-21 14:58:42,828] ===================================================================================== SQL Command - Statement Id: [getPatientInfoIn] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String]] [Logging Date Time: 2016-12-21 14:58:42,828] ===================================================================================== SQL Command - Statement Id: [getPatientInfoIn] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String]] [Logging Date Time: 2016-12-21 14:58:42,949] ===================================================================================== SQL Command - Statement Id: [GET_TRMT_DATE_LIST] PreparedStatement : [SELECT '1' AS ORDERBY, indd as ClnDate, substr(indd, 1, 4) || '-' || substr(indd, 5, 2) || '-' || substr(indd, 7, 2) as ClnFormatDate, inpt.ordtype as VisitType, case when ordtype = 'O' then '¿Ü·¡' when ordtype = 'I' then 'ÀÔ¿ø' when ordtype = 'E' then 'ÀÀ±Þ' end as VisitTypeName, dept.deptengabbr as ClnDeptCode, dept.depthngnm as ClnDeptName, dept.deptcd as DeptCd, inpt.cretno, inpt.medispclid as orddrid FROM pam.pmihinpt inpt left outer join com.zsdddept dept on (dept.instcd = inpt.instcd and dept.deptcd = inpt.orddeptcd and dept.valitodd = '99991231') WHERE inpt.instcd = :param0 AND inpt.pid = :param1 AND inpt.indd = :param2 AND inpt.histstat = 'Y' AND inpt.mskind = 'M' AND inpt.ORDDEPTCD = :param3 union all SELECT '1' AS ORDERBY, orddd as ClnDate, substr(orddd, 1, 4) || '-' || substr(orddd, 5, 2) || '-' || substr(orddd, 7, 2) as ClnFormatDate, otpt.ordtype as VisitType, case when ordtype = 'O' then '¿Ü·¡' when ordtype = 'I' then 'ÀÔ¿ø' when ordtype = 'E' then 'ÀÀ±Þ' end as VisitTypeName, dept.deptengabbr as ClnDeptCode, dept.depthngnm as ClnDeptName, dept.deptcd as DeptCd, otpt.cretno, otpt.orddrid as orddrid FROM pam.pmohotpt otpt left outer join com.zsdddept dept on (dept.instcd = otpt.instcd and dept.deptcd = otpt.orddeptcd and dept.valitodd = '99991231') WHERE otpt.instcd = :param0 AND otpt.pid = :param1 AND otpt.orddd = :param2 AND OTPT.ORDDEPTCD = :param3 AND otpt.HISTSTAT IN ('R', 'T') AND otpt.MSKIND = 'M' UNION ALL SELECT '99' AS ORDERBY, indd as ClnDate, substr(indd, 1, 4) || '-' || substr(indd, 5, 2) || '-' || substr(indd, 7, 2) as ClnFormatDate, inpt.ordtype as VisitType, case when ordtype = 'O' then '¿Ü·¡' when ordtype = 'I' then 'ÀÔ¿ø' when ordtype = 'E' then 'ÀÀ±Þ' end as VisitTypeName, dept.deptengabbr as ClnDeptCode, dept.depthngnm as ClnDeptName, dept.deptcd as DeptCd, inpt.cretno, inpt.medispclid as orddrid FROM pam.pmihinpt inpt left outer join com.zsdddept dept on (dept.instcd = inpt.instcd and dept.deptcd = inpt.orddeptcd and dept.valitodd = '99991231') WHERE inpt.instcd = :param0 AND inpt.pid = :param1 AND inpt.indd = :param2 AND inpt.histstat = 'Y' AND inpt.mskind = 'M' AND inpt.ORDDEPTCD != :param3 union all SELECT '99' AS ORDERBY, orddd as ClnDate, substr(orddd, 1, 4) || '-' || substr(orddd, 5, 2) || '-' || substr(orddd, 7, 2) as ClnFormatDate, otpt.ordtype as VisitType, case when ordtype = 'O' then '¿Ü·¡' when ordtype = 'I' then 'ÀÔ¿ø' when ordtype = 'E' then 'ÀÀ±Þ' end as VisitTypeName, dept.deptengabbr as ClnDeptCode, dept.depthngnm as ClnDeptName, dept.deptcd as DeptCd, otpt.cretno, otpt.orddrid as orddrid FROM pam.pmohotpt otpt left outer join com.zsdddept dept on (dept.instcd = otpt.instcd and dept.deptcd = otpt.orddeptcd and dept.valitodd = '99991231') WHERE otpt.instcd = :param0 AND otpt.pid = :param1 AND otpt.orddd = :param2 AND OTPT.ORDDEPTCD != :param3 AND otpt.HISTSTAT IN ('R', 'T') AND otpt.MSKIND = 'M' order by ORDERBY, cretno desc] [Logging Date Time: 2016-12-21 14:58:42,949] ===================================================================================== SQL Command - Statement Id: [GET_TRMT_DATE_LIST] PreparedStatement : [SELECT '1' AS ORDERBY, indd as ClnDate, substr(indd, 1, 4) || '-' || substr(indd, 5, 2) || '-' || substr(indd, 7, 2) as ClnFormatDate, inpt.ordtype as VisitType, case when ordtype = 'O' then '¿Ü·¡' when ordtype = 'I' then 'ÀÔ¿ø' when ordtype = 'E' then 'ÀÀ±Þ' end as VisitTypeName, dept.deptengabbr as ClnDeptCode, dept.depthngnm as ClnDeptName, dept.deptcd as DeptCd, inpt.cretno, inpt.medispclid as orddrid FROM pam.pmihinpt inpt left outer join com.zsdddept dept on (dept.instcd = inpt.instcd and dept.deptcd = inpt.orddeptcd and dept.valitodd = '99991231') WHERE inpt.instcd = :param0 AND inpt.pid = :param1 AND inpt.indd = :param2 AND inpt.histstat = 'Y' AND inpt.mskind = 'M' AND inpt.ORDDEPTCD = :param3 union all SELECT '1' AS ORDERBY, orddd as ClnDate, substr(orddd, 1, 4) || '-' || substr(orddd, 5, 2) || '-' || substr(orddd, 7, 2) as ClnFormatDate, otpt.ordtype as VisitType, case when ordtype = 'O' then '¿Ü·¡' when ordtype = 'I' then 'ÀÔ¿ø' when ordtype = 'E' then 'ÀÀ±Þ' end as VisitTypeName, dept.deptengabbr as ClnDeptCode, dept.depthngnm as ClnDeptName, dept.deptcd as DeptCd, otpt.cretno, otpt.orddrid as orddrid FROM pam.pmohotpt otpt left outer join com.zsdddept dept on (dept.instcd = otpt.instcd and dept.deptcd = otpt.orddeptcd and dept.valitodd = '99991231') WHERE otpt.instcd = :param0 AND otpt.pid = :param1 AND otpt.orddd = :param2 AND OTPT.ORDDEPTCD = :param3 AND otpt.HISTSTAT IN ('R', 'T') AND otpt.MSKIND = 'M' UNION ALL SELECT '99' AS ORDERBY, indd as ClnDate, substr(indd, 1, 4) || '-' || substr(indd, 5, 2) || '-' || substr(indd, 7, 2) as ClnFormatDate, inpt.ordtype as VisitType, case when ordtype = 'O' then '¿Ü·¡' when ordtype = 'I' then 'ÀÔ¿ø' when ordtype = 'E' then 'ÀÀ±Þ' end as VisitTypeName, dept.deptengabbr as ClnDeptCode, dept.depthngnm as ClnDeptName, dept.deptcd as DeptCd, inpt.cretno, inpt.medispclid as orddrid FROM pam.pmihinpt inpt left outer join com.zsdddept dept on (dept.instcd = inpt.instcd and dept.deptcd = inpt.orddeptcd and dept.valitodd = '99991231') WHERE inpt.instcd = :param0 AND inpt.pid = :param1 AND inpt.indd = :param2 AND inpt.histstat = 'Y' AND inpt.mskind = 'M' AND inpt.ORDDEPTCD != :param3 union all SELECT '99' AS ORDERBY, orddd as ClnDate, substr(orddd, 1, 4) || '-' || substr(orddd, 5, 2) || '-' || substr(orddd, 7, 2) as ClnFormatDate, otpt.ordtype as VisitType, case when ordtype = 'O' then '¿Ü·¡' when ordtype = 'I' then 'ÀÔ¿ø' when ordtype = 'E' then 'ÀÀ±Þ' end as VisitTypeName, dept.deptengabbr as ClnDeptCode, dept.depthngnm as ClnDeptName, dept.deptcd as DeptCd, otpt.cretno, otpt.orddrid as orddrid FROM pam.pmohotpt otpt left outer join com.zsdddept dept on (dept.instcd = otpt.instcd and dept.deptcd = otpt.orddeptcd and dept.valitodd = '99991231') WHERE otpt.instcd = :param0 AND otpt.pid = :param1 AND otpt.orddd = :param2 AND OTPT.ORDDEPTCD != :param3 AND otpt.HISTSTAT IN ('R', 'T') AND otpt.MSKIND = 'M' order by ORDERBY, cretno desc] [Logging Date Time: 2016-12-21 14:58:42,950] ===================================================================================== SQL Command - Statement Id: [GET_TRMT_DATE_LIST] Parameters: [param0=[instcd,111], param1=[pid,0957205], param2=[searchClnDate,20161209], param3=[orddeptcd,2010300000]] [Logging Date Time: 2016-12-21 14:58:42,950] ===================================================================================== SQL Command - Statement Id: [GET_TRMT_DATE_LIST] Parameters: [param0=[instcd,111], param1=[pid,0957205], param2=[searchClnDate,20161209], param3=[orddeptcd,2010300000]] [Logging Date Time: 2016-12-21 14:58:42,950] ===================================================================================== SQL Command - Statement Id: [GET_TRMT_DATE_LIST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String]] [Logging Date Time: 2016-12-21 14:58:42,950] ===================================================================================== SQL Command - Statement Id: [GET_TRMT_DATE_LIST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String]] [Logging Date Time: 2016-12-21 14:58:43,054] ===================================================================================== SQL Command - Statement Id: [getPatientInfoIn] PreparedStatement : [SELECT a.orddeptcd, a.pid as IO_Pt_ID, to_char(a.cretno) as IO_CretNo, (ptbs.sex || '/' || com.fn_zz_getageas(ptbs.rrgstno1, ptbs.rrgstno2, TO_CHAR(SYSDATE, 'YYYYMMDD'), 'A', ptbs.brthdd)) as IO_sex_age_y_m, ptbs.hngnm as IO_Pt_Name, (ptbs.rrgstno1 || '-' || substr(ptbs.rrgstno2, 1, 1) || '******') IO_JuminNo, ptbs.zipcdaddr as IO_Zipcdaddr, ptbs.mpphontel as IO_Tel, (select cdnm from com.zbcmcode where cdgrupid = 'P0008' and cdid = a.insukind) as IO_Insukind, (select dept.DEPTENGABBR from com.zsdddept dept where dept.deptcd = a.wardcd and dept.instcd = a.instcd and dept.valitodd >= a.indd and dept.valifromdd <= a.indd) as IO_Ward, a.roomcd as IO_roomNO, a.indd as IO_ADdate, a.dschdd as IO_Dschdd, a.ordtype as IO_VisitType, a.orddeptcd as IO_DeptCd, (select dept.deptengabbr from com.zsdddept dept where dept.deptcd = a.orddeptcd and dept.instcd = a.instcd and dept.valitodd >= a.indd and dept.valifromdd <= a.indd) as IO_DeptNm, COM.FN_ZS_GETDEPTNAME(a.instcd, a.orddeptcd, a.indd) AS IO_Dept2, '' AS IO_OPdeptCd, '' AS IO_OPdeptNm, '' AS IO_OPdrNm, '' AS IO_OPdrId, (SELECT diag.diagcd FROM emr.mmohdiag diag WHERE diag.pid = a.pid AND diag.orddd = a.indd AND diag.cretno = a.cretno AND diag.diaghistcd = 'O' AND diag.diagtypecd = 'D' AND diag.diagkindcdflag = 'M' AND diag.genrflagcd = a.ordtype and diag.orddeptcd = a.orddeptcd AND diag.diaghistno = (select max(diagh.diaghistno) from emr.mmohdiag diagh where diagh.pid = a.pid AND diagh.orddd = a.indd AND diagh.cretno = a.cretno AND diagh.instcd = '111' AND diagh.diaghistcd = 'O' AND diagh.diagkindcdflag = 'M' AND diagh.genrflagcd = a.ordtype and diagh.orddeptcd = a.orddeptcd group by pid)) as IO_DxCd, (SELECT term.diaghngnm FROM emr.mmohdiag diag, emr.mmbvdiag term WHERE diag.pid = a.pid AND diag.orddd = a.indd AND diag.cretno = a.cretno AND diag.instcd = term.instcd AND diag.diagcd = term.orgdiagcd AND diag.diaghistcd = 'O' AND diag.diagtypecd = 'D' AND diag.diagkindcdflag = 'M' AND diag.diagdd >= term.termfromdd AND diag.diagdd <= term.termtodd AND diag.diagdd >= term.diagattrfromdd AND diag.diagdd <= term.diagattrtodd AND diag.genrflagcd = a.ordtype and diag.orddeptcd = a.orddeptcd AND diag.diaghistno = (select max(diagh.diaghistno) from emr.mmohdiag diagh where diagh.pid = a.pid AND diagh.orddd = a.indd AND diagh.cretno = a.cretno AND diagh.instcd = '111' AND diagh.diaghistcd = 'O' AND diagh.diagkindcdflag = 'M' AND diagh.genrflagcd = a.ordtype and diagh.orddeptcd = a.orddeptcd group by pid)) as IO_DxNm, '111' as IO_HosType, case when ex.bp is null then null else ex.bp end as IO_bp, case when ex.dm is null then null else ex.dm end as IO_dm, case when ex.heart is null then null else ex.heart end as IO_heart, case when ex.kidney is null then null else ex.kidney end as IO_kidney, case when ex.respiration is null then null else ex.respiration end as IO_respiration, case when ex.hx is null then null else ex.hx end as IO_hx, case when ex.allergy is null then null else ex.allergy end as IO_allergy, case when ex.drug is null then null else ex.drug end as IO_drug, case when ex.smoking is null then null else ex.smoking end as IO_smoking, case when ex.idio is null then null else ex.idio end as IO_idio, case when ex.nacrotics is null then null else ex.nacrotics end as IO_nacrotics, case when ex.airway is null then null else ex.airway end as IO_airway, case when ex.hemorrhage is null then null else ex.hemorrhage end as IO_hemorrhage, ex.etc IO_status_etc, '' as IO_OrderNo, '111' as IO_PrintTime, a.medispclid as IO_MaindrId, COM.FN_ZS_GETUSERNM(a.ermedispclid, a.indd) as IO_ErdrNm, COM.FN_ZS_GETUSERNM(a.medispclid, a.indd) as IO_MaindrNm, '111' as IO_OcrCd, '111' as IO_InputId, '111' as IO_InputNm, '111' as IO_SignImg, a.fstrgstdt FROM pam.pmihinpt a left outer join cmr.consent_data_ex ex on (ex.pid = a.pid and ex.cln_date = a.indd) left outer join pam.pmcmptbs ptbs on (ptbs.pid = a.pid and ptbs.instcd = a.instcd) WHERE a.instcd = :param0 AND a.pid = :param1 AND a.indd = :param2 AND a.histstat = 'Y' AND a.mskind = 'M' AND a.cretno = :param3 AND a.orddeptcd = :param4 order by a.fstrgstdt desc] [Logging Date Time: 2016-12-21 14:58:43,054] ===================================================================================== SQL Command - Statement Id: [getPatientInfoIn] PreparedStatement : [SELECT a.orddeptcd, a.pid as IO_Pt_ID, to_char(a.cretno) as IO_CretNo, (ptbs.sex || '/' || com.fn_zz_getageas(ptbs.rrgstno1, ptbs.rrgstno2, TO_CHAR(SYSDATE, 'YYYYMMDD'), 'A', ptbs.brthdd)) as IO_sex_age_y_m, ptbs.hngnm as IO_Pt_Name, (ptbs.rrgstno1 || '-' || substr(ptbs.rrgstno2, 1, 1) || '******') IO_JuminNo, ptbs.zipcdaddr as IO_Zipcdaddr, ptbs.mpphontel as IO_Tel, (select cdnm from com.zbcmcode where cdgrupid = 'P0008' and cdid = a.insukind) as IO_Insukind, (select dept.DEPTENGABBR from com.zsdddept dept where dept.deptcd = a.wardcd and dept.instcd = a.instcd and dept.valitodd >= a.indd and dept.valifromdd <= a.indd) as IO_Ward, a.roomcd as IO_roomNO, a.indd as IO_ADdate, a.dschdd as IO_Dschdd, a.ordtype as IO_VisitType, a.orddeptcd as IO_DeptCd, (select dept.deptengabbr from com.zsdddept dept where dept.deptcd = a.orddeptcd and dept.instcd = a.instcd and dept.valitodd >= a.indd and dept.valifromdd <= a.indd) as IO_DeptNm, COM.FN_ZS_GETDEPTNAME(a.instcd, a.orddeptcd, a.indd) AS IO_Dept2, '' AS IO_OPdeptCd, '' AS IO_OPdeptNm, '' AS IO_OPdrNm, '' AS IO_OPdrId, (SELECT diag.diagcd FROM emr.mmohdiag diag WHERE diag.pid = a.pid AND diag.orddd = a.indd AND diag.cretno = a.cretno AND diag.diaghistcd = 'O' AND diag.diagtypecd = 'D' AND diag.diagkindcdflag = 'M' AND diag.genrflagcd = a.ordtype and diag.orddeptcd = a.orddeptcd AND diag.diaghistno = (select max(diagh.diaghistno) from emr.mmohdiag diagh where diagh.pid = a.pid AND diagh.orddd = a.indd AND diagh.cretno = a.cretno AND diagh.instcd = '111' AND diagh.diaghistcd = 'O' AND diagh.diagkindcdflag = 'M' AND diagh.genrflagcd = a.ordtype and diagh.orddeptcd = a.orddeptcd group by pid)) as IO_DxCd, (SELECT term.diaghngnm FROM emr.mmohdiag diag, emr.mmbvdiag term WHERE diag.pid = a.pid AND diag.orddd = a.indd AND diag.cretno = a.cretno AND diag.instcd = term.instcd AND diag.diagcd = term.orgdiagcd AND diag.diaghistcd = 'O' AND diag.diagtypecd = 'D' AND diag.diagkindcdflag = 'M' AND diag.diagdd >= term.termfromdd AND diag.diagdd <= term.termtodd AND diag.diagdd >= term.diagattrfromdd AND diag.diagdd <= term.diagattrtodd AND diag.genrflagcd = a.ordtype and diag.orddeptcd = a.orddeptcd AND diag.diaghistno = (select max(diagh.diaghistno) from emr.mmohdiag diagh where diagh.pid = a.pid AND diagh.orddd = a.indd AND diagh.cretno = a.cretno AND diagh.instcd = '111' AND diagh.diaghistcd = 'O' AND diagh.diagkindcdflag = 'M' AND diagh.genrflagcd = a.ordtype and diagh.orddeptcd = a.orddeptcd group by pid)) as IO_DxNm, '111' as IO_HosType, case when ex.bp is null then null else ex.bp end as IO_bp, case when ex.dm is null then null else ex.dm end as IO_dm, case when ex.heart is null then null else ex.heart end as IO_heart, case when ex.kidney is null then null else ex.kidney end as IO_kidney, case when ex.respiration is null then null else ex.respiration end as IO_respiration, case when ex.hx is null then null else ex.hx end as IO_hx, case when ex.allergy is null then null else ex.allergy end as IO_allergy, case when ex.drug is null then null else ex.drug end as IO_drug, case when ex.smoking is null then null else ex.smoking end as IO_smoking, case when ex.idio is null then null else ex.idio end as IO_idio, case when ex.nacrotics is null then null else ex.nacrotics end as IO_nacrotics, case when ex.airway is null then null else ex.airway end as IO_airway, case when ex.hemorrhage is null then null else ex.hemorrhage end as IO_hemorrhage, ex.etc IO_status_etc, '' as IO_OrderNo, '111' as IO_PrintTime, a.medispclid as IO_MaindrId, COM.FN_ZS_GETUSERNM(a.ermedispclid, a.indd) as IO_ErdrNm, COM.FN_ZS_GETUSERNM(a.medispclid, a.indd) as IO_MaindrNm, '111' as IO_OcrCd, '111' as IO_InputId, '111' as IO_InputNm, '111' as IO_SignImg, a.fstrgstdt FROM pam.pmihinpt a left outer join cmr.consent_data_ex ex on (ex.pid = a.pid and ex.cln_date = a.indd) left outer join pam.pmcmptbs ptbs on (ptbs.pid = a.pid and ptbs.instcd = a.instcd) WHERE a.instcd = :param0 AND a.pid = :param1 AND a.indd = :param2 AND a.histstat = 'Y' AND a.mskind = 'M' AND a.cretno = :param3 AND a.orddeptcd = :param4 order by a.fstrgstdt desc] [Logging Date Time: 2016-12-21 14:58:43,055] ===================================================================================== SQL Command - Statement Id: [getPatientInfoIn] Parameters: [param0=[instcd,111], param1=[pid,0957205], param2=[orddd,20161209], param3=[cretno,1], param4=[orddeptcd,2010300000]] [Logging Date Time: 2016-12-21 14:58:43,055] ===================================================================================== SQL Command - Statement Id: [getPatientInfoIn] Parameters: [param0=[instcd,111], param1=[pid,0957205], param2=[orddd,20161209], param3=[cretno,1], param4=[orddeptcd,2010300000]] [Logging Date Time: 2016-12-21 14:58:43,055] ===================================================================================== SQL Command - Statement Id: [getPatientInfoIn] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String]] [Logging Date Time: 2016-12-21 14:58:43,055] ===================================================================================== SQL Command - Statement Id: [getPatientInfoIn] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String]] [Logging Date Time: 2016-12-21 14:58:43,150] ===================================================================================== SQL Command - Statement Id: [getPatientInfoIn] PreparedStatement : [SELECT a.orddeptcd, a.pid as IO_Pt_ID, to_char(a.cretno) as IO_CretNo, (ptbs.sex || '/' || com.fn_zz_getageas(ptbs.rrgstno1, ptbs.rrgstno2, TO_CHAR(SYSDATE, 'YYYYMMDD'), 'A', ptbs.brthdd)) as IO_sex_age_y_m, ptbs.hngnm as IO_Pt_Name, (ptbs.rrgstno1 || '-' || substr(ptbs.rrgstno2, 1, 1) || '******') IO_JuminNo, ptbs.zipcdaddr as IO_Zipcdaddr, ptbs.mpphontel as IO_Tel, (select cdnm from com.zbcmcode where cdgrupid = 'P0008' and cdid = a.insukind) as IO_Insukind, (select dept.DEPTENGABBR from com.zsdddept dept where dept.deptcd = a.wardcd and dept.instcd = a.instcd and dept.valitodd >= a.indd and dept.valifromdd <= a.indd) as IO_Ward, a.roomcd as IO_roomNO, a.indd as IO_ADdate, a.dschdd as IO_Dschdd, a.ordtype as IO_VisitType, a.orddeptcd as IO_DeptCd, (select dept.deptengabbr from com.zsdddept dept where dept.deptcd = a.orddeptcd and dept.instcd = a.instcd and dept.valitodd >= a.indd and dept.valifromdd <= a.indd) as IO_DeptNm, COM.FN_ZS_GETDEPTNAME(a.instcd, a.orddeptcd, a.indd) AS IO_Dept2, '' AS IO_OPdeptCd, '' AS IO_OPdeptNm, '' AS IO_OPdrNm, '' AS IO_OPdrId, (SELECT diag.diagcd FROM emr.mmohdiag diag WHERE diag.pid = a.pid AND diag.orddd = a.indd AND diag.cretno = a.cretno AND diag.diaghistcd = 'O' AND diag.diagtypecd = 'D' AND diag.diagkindcdflag = 'M' AND diag.genrflagcd = a.ordtype and diag.orddeptcd = a.orddeptcd AND diag.diaghistno = (select max(diagh.diaghistno) from emr.mmohdiag diagh where diagh.pid = a.pid AND diagh.orddd = a.indd AND diagh.cretno = a.cretno AND diagh.instcd = '111' AND diagh.diaghistcd = 'O' AND diagh.diagkindcdflag = 'M' AND diagh.genrflagcd = a.ordtype and diagh.orddeptcd = a.orddeptcd group by pid)) as IO_DxCd, (SELECT term.diaghngnm FROM emr.mmohdiag diag, emr.mmbvdiag term WHERE diag.pid = a.pid AND diag.orddd = a.indd AND diag.cretno = a.cretno AND diag.instcd = term.instcd AND diag.diagcd = term.orgdiagcd AND diag.diaghistcd = 'O' AND diag.diagtypecd = 'D' AND diag.diagkindcdflag = 'M' AND diag.diagdd >= term.termfromdd AND diag.diagdd <= term.termtodd AND diag.diagdd >= term.diagattrfromdd AND diag.diagdd <= term.diagattrtodd AND diag.genrflagcd = a.ordtype and diag.orddeptcd = a.orddeptcd AND diag.diaghistno = (select max(diagh.diaghistno) from emr.mmohdiag diagh where diagh.pid = a.pid AND diagh.orddd = a.indd AND diagh.cretno = a.cretno AND diagh.instcd = '111' AND diagh.diaghistcd = 'O' AND diagh.diagkindcdflag = 'M' AND diagh.genrflagcd = a.ordtype and diagh.orddeptcd = a.orddeptcd group by pid)) as IO_DxNm, '111' as IO_HosType, case when ex.bp is null then null else ex.bp end as IO_bp, case when ex.dm is null then null else ex.dm end as IO_dm, case when ex.heart is null then null else ex.heart end as IO_heart, case when ex.kidney is null then null else ex.kidney end as IO_kidney, case when ex.respiration is null then null else ex.respiration end as IO_respiration, case when ex.hx is null then null else ex.hx end as IO_hx, case when ex.allergy is null then null else ex.allergy end as IO_allergy, case when ex.drug is null then null else ex.drug end as IO_drug, case when ex.smoking is null then null else ex.smoking end as IO_smoking, case when ex.idio is null then null else ex.idio end as IO_idio, case when ex.nacrotics is null then null else ex.nacrotics end as IO_nacrotics, case when ex.airway is null then null else ex.airway end as IO_airway, case when ex.hemorrhage is null then null else ex.hemorrhage end as IO_hemorrhage, ex.etc IO_status_etc, '' as IO_OrderNo, '111' as IO_PrintTime, a.medispclid as IO_MaindrId, COM.FN_ZS_GETUSERNM(a.ermedispclid, a.indd) as IO_ErdrNm, COM.FN_ZS_GETUSERNM(a.medispclid, a.indd) as IO_MaindrNm, '111' as IO_OcrCd, '111' as IO_InputId, '111' as IO_InputNm, '111' as IO_SignImg, a.fstrgstdt FROM pam.pmihinpt a left outer join cmr.consent_data_ex ex on (ex.pid = a.pid and ex.cln_date = a.indd) left outer join pam.pmcmptbs ptbs on (ptbs.pid = a.pid and ptbs.instcd = a.instcd) WHERE a.instcd = :param0 AND a.pid = :param1 AND a.indd = :param2 AND a.histstat = 'Y' AND a.mskind = 'M' AND a.cretno = :param3 AND a.orddeptcd = :param4 order by a.fstrgstdt desc] [Logging Date Time: 2016-12-21 14:58:43,150] ===================================================================================== SQL Command - Statement Id: [getPatientInfoIn] PreparedStatement : [SELECT a.orddeptcd, a.pid as IO_Pt_ID, to_char(a.cretno) as IO_CretNo, (ptbs.sex || '/' || com.fn_zz_getageas(ptbs.rrgstno1, ptbs.rrgstno2, TO_CHAR(SYSDATE, 'YYYYMMDD'), 'A', ptbs.brthdd)) as IO_sex_age_y_m, ptbs.hngnm as IO_Pt_Name, (ptbs.rrgstno1 || '-' || substr(ptbs.rrgstno2, 1, 1) || '******') IO_JuminNo, ptbs.zipcdaddr as IO_Zipcdaddr, ptbs.mpphontel as IO_Tel, (select cdnm from com.zbcmcode where cdgrupid = 'P0008' and cdid = a.insukind) as IO_Insukind, (select dept.DEPTENGABBR from com.zsdddept dept where dept.deptcd = a.wardcd and dept.instcd = a.instcd and dept.valitodd >= a.indd and dept.valifromdd <= a.indd) as IO_Ward, a.roomcd as IO_roomNO, a.indd as IO_ADdate, a.dschdd as IO_Dschdd, a.ordtype as IO_VisitType, a.orddeptcd as IO_DeptCd, (select dept.deptengabbr from com.zsdddept dept where dept.deptcd = a.orddeptcd and dept.instcd = a.instcd and dept.valitodd >= a.indd and dept.valifromdd <= a.indd) as IO_DeptNm, COM.FN_ZS_GETDEPTNAME(a.instcd, a.orddeptcd, a.indd) AS IO_Dept2, '' AS IO_OPdeptCd, '' AS IO_OPdeptNm, '' AS IO_OPdrNm, '' AS IO_OPdrId, (SELECT diag.diagcd FROM emr.mmohdiag diag WHERE diag.pid = a.pid AND diag.orddd = a.indd AND diag.cretno = a.cretno AND diag.diaghistcd = 'O' AND diag.diagtypecd = 'D' AND diag.diagkindcdflag = 'M' AND diag.genrflagcd = a.ordtype and diag.orddeptcd = a.orddeptcd AND diag.diaghistno = (select max(diagh.diaghistno) from emr.mmohdiag diagh where diagh.pid = a.pid AND diagh.orddd = a.indd AND diagh.cretno = a.cretno AND diagh.instcd = '111' AND diagh.diaghistcd = 'O' AND diagh.diagkindcdflag = 'M' AND diagh.genrflagcd = a.ordtype and diagh.orddeptcd = a.orddeptcd group by pid)) as IO_DxCd, (SELECT term.diaghngnm FROM emr.mmohdiag diag, emr.mmbvdiag term WHERE diag.pid = a.pid AND diag.orddd = a.indd AND diag.cretno = a.cretno AND diag.instcd = term.instcd AND diag.diagcd = term.orgdiagcd AND diag.diaghistcd = 'O' AND diag.diagtypecd = 'D' AND diag.diagkindcdflag = 'M' AND diag.diagdd >= term.termfromdd AND diag.diagdd <= term.termtodd AND diag.diagdd >= term.diagattrfromdd AND diag.diagdd <= term.diagattrtodd AND diag.genrflagcd = a.ordtype and diag.orddeptcd = a.orddeptcd AND diag.diaghistno = (select max(diagh.diaghistno) from emr.mmohdiag diagh where diagh.pid = a.pid AND diagh.orddd = a.indd AND diagh.cretno = a.cretno AND diagh.instcd = '111' AND diagh.diaghistcd = 'O' AND diagh.diagkindcdflag = 'M' AND diagh.genrflagcd = a.ordtype and diagh.orddeptcd = a.orddeptcd group by pid)) as IO_DxNm, '111' as IO_HosType, case when ex.bp is null then null else ex.bp end as IO_bp, case when ex.dm is null then null else ex.dm end as IO_dm, case when ex.heart is null then null else ex.heart end as IO_heart, case when ex.kidney is null then null else ex.kidney end as IO_kidney, case when ex.respiration is null then null else ex.respiration end as IO_respiration, case when ex.hx is null then null else ex.hx end as IO_hx, case when ex.allergy is null then null else ex.allergy end as IO_allergy, case when ex.drug is null then null else ex.drug end as IO_drug, case when ex.smoking is null then null else ex.smoking end as IO_smoking, case when ex.idio is null then null else ex.idio end as IO_idio, case when ex.nacrotics is null then null else ex.nacrotics end as IO_nacrotics, case when ex.airway is null then null else ex.airway end as IO_airway, case when ex.hemorrhage is null then null else ex.hemorrhage end as IO_hemorrhage, ex.etc IO_status_etc, '' as IO_OrderNo, '111' as IO_PrintTime, a.medispclid as IO_MaindrId, COM.FN_ZS_GETUSERNM(a.ermedispclid, a.indd) as IO_ErdrNm, COM.FN_ZS_GETUSERNM(a.medispclid, a.indd) as IO_MaindrNm, '111' as IO_OcrCd, '111' as IO_InputId, '111' as IO_InputNm, '111' as IO_SignImg, a.fstrgstdt FROM pam.pmihinpt a left outer join cmr.consent_data_ex ex on (ex.pid = a.pid and ex.cln_date = a.indd) left outer join pam.pmcmptbs ptbs on (ptbs.pid = a.pid and ptbs.instcd = a.instcd) WHERE a.instcd = :param0 AND a.pid = :param1 AND a.indd = :param2 AND a.histstat = 'Y' AND a.mskind = 'M' AND a.cretno = :param3 AND a.orddeptcd = :param4 order by a.fstrgstdt desc] [Logging Date Time: 2016-12-21 14:58:43,151] ===================================================================================== SQL Command - Statement Id: [getPatientInfoIn] Parameters: [param0=[instcd,111], param1=[pid,0957205], param2=[orddd,20161209], param3=[cretno,1], param4=[orddeptcd,2010300000]] [Logging Date Time: 2016-12-21 14:58:43,151] ===================================================================================== SQL Command - Statement Id: [getPatientInfoIn] Parameters: [param0=[instcd,111], param1=[pid,0957205], param2=[orddd,20161209], param3=[cretno,1], param4=[orddeptcd,2010300000]] [Logging Date Time: 2016-12-21 14:58:43,151] ===================================================================================== SQL Command - Statement Id: [getPatientInfoIn] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String]] [Logging Date Time: 2016-12-21 14:58:43,151] ===================================================================================== SQL Command - Statement Id: [getPatientInfoIn] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String]] [Logging Date Time: 2016-12-21 14:58:43,253] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_LIST] PreparedStatement : [SELECT CM.CONSENT_MST_RID , DECODE(CM.CONSENT_STATE, 'TEMP' ,'ÀÓ½ÃÀúÀå', 'ELECTR_CMP', '¼­¸í', 'PAPER_OUT', 'Ãâ·Â' , 'CERTIFY_CMP', 'ÀÎÁõ', 'UNFINISHED', '¹ÌÀÛ¼º', 'VERBAL', '±¸µÎ') AS CONSENT_STATE_DISP , VEF.FORM_NAME AS CONSENT_NAME , CM.HOS_TYPE , CM.PID , CM.VISIT_TYPE , CM.ORDER_NO , CM.ORDER_CD , CM.ORDER_NAME , CM.CLN_DEPT_CD , (SELECT DEPTHNGNM FROM COM.ZSDDDEPT WHERE DEPTCD = CM.CLN_DEPT_CD and valitodd = '99991231' and instcd = '111') AS CLN_DEPT_NM , COM.FN_ZS_GETDEPTNAME('111', (select dept.deptcd from com.zsdddept dept where dept.instcd = '111' and dept.valitodd = '99991231' and dept.deptengabbr = CM.WARDCD), '99991231') as WARDCD , CM.ROOMCD , CM.FORM_RID , VEF.FORM_CD , VEF.FORM_GUID , C.PRNTCNT , CM.CONSENT_STATE AS CONSENT_STATE , CM.OCR_NUMBER , CM.COSIGN_DC_ID , CM.COSIGN_DC_NAME , CM.MODIFY_USER_ID AS CREATE_USER_ID , CM.MODIFY_USER_NAME AS CREATE_USER_NAME , CM.MODIFY_DATETIME AS CREATE_DATETIME , CM.CLN_DATE , CM.CRETNO , (SELECT OCRTAGPRNTYN FROM V_EFORM_FORMDOC F WHERE F.FORM_RID = CM.FORM_RID ) AS OCRTAGPRNTYN FROM CONSENT_MST CM INNER JOIN EFORM_DOCUMENT VEF ON VEF.FORM_RID = CM.FORM_RID, EMR.MRFMFORM C WHERE CM.USE_YN = 'Y' AND CM.PID = :param0 AND TO_CHAR(TO_DATE(CM.CREATE_DATETIME, 'YYYY-MM-DD HH24:MI:SS'), 'YYYYMMDD') BETWEEN :param1 and :param2 AND VEF.FORM_CD = C.FORMCD AND C.instcd = '111' AND C.formprogflag LIKE 'OCR%' AND C.formlevlcd != '-' AND CM.HOS_TYPE = '111' AND SUBSTR (C.formtodt, 1, 8) = '99991231' AND CM.CONSENT_STATE IN ('UNFINISHED','TEMP') ORDER BY OCR_NUMBER DESC, CONSENT_STATE ASC] [Logging Date Time: 2016-12-21 14:58:43,253] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_LIST] PreparedStatement : [SELECT CM.CONSENT_MST_RID , DECODE(CM.CONSENT_STATE, 'TEMP' ,'ÀÓ½ÃÀúÀå', 'ELECTR_CMP', '¼­¸í', 'PAPER_OUT', 'Ãâ·Â' , 'CERTIFY_CMP', 'ÀÎÁõ', 'UNFINISHED', '¹ÌÀÛ¼º', 'VERBAL', '±¸µÎ') AS CONSENT_STATE_DISP , VEF.FORM_NAME AS CONSENT_NAME , CM.HOS_TYPE , CM.PID , CM.VISIT_TYPE , CM.ORDER_NO , CM.ORDER_CD , CM.ORDER_NAME , CM.CLN_DEPT_CD , (SELECT DEPTHNGNM FROM COM.ZSDDDEPT WHERE DEPTCD = CM.CLN_DEPT_CD and valitodd = '99991231' and instcd = '111') AS CLN_DEPT_NM , COM.FN_ZS_GETDEPTNAME('111', (select dept.deptcd from com.zsdddept dept where dept.instcd = '111' and dept.valitodd = '99991231' and dept.deptengabbr = CM.WARDCD), '99991231') as WARDCD , CM.ROOMCD , CM.FORM_RID , VEF.FORM_CD , VEF.FORM_GUID , C.PRNTCNT , CM.CONSENT_STATE AS CONSENT_STATE , CM.OCR_NUMBER , CM.COSIGN_DC_ID , CM.COSIGN_DC_NAME , CM.MODIFY_USER_ID AS CREATE_USER_ID , CM.MODIFY_USER_NAME AS CREATE_USER_NAME , CM.MODIFY_DATETIME AS CREATE_DATETIME , CM.CLN_DATE , CM.CRETNO , (SELECT OCRTAGPRNTYN FROM V_EFORM_FORMDOC F WHERE F.FORM_RID = CM.FORM_RID ) AS OCRTAGPRNTYN FROM CONSENT_MST CM INNER JOIN EFORM_DOCUMENT VEF ON VEF.FORM_RID = CM.FORM_RID, EMR.MRFMFORM C WHERE CM.USE_YN = 'Y' AND CM.PID = :param0 AND TO_CHAR(TO_DATE(CM.CREATE_DATETIME, 'YYYY-MM-DD HH24:MI:SS'), 'YYYYMMDD') BETWEEN :param1 and :param2 AND VEF.FORM_CD = C.FORMCD AND C.instcd = '111' AND C.formprogflag LIKE 'OCR%' AND C.formlevlcd != '-' AND CM.HOS_TYPE = '111' AND SUBSTR (C.formtodt, 1, 8) = '99991231' AND CM.CONSENT_STATE IN ('UNFINISHED','TEMP') ORDER BY OCR_NUMBER DESC, CONSENT_STATE ASC] [Logging Date Time: 2016-12-21 14:58:43,253] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_LIST] Parameters: [param0=[patientCode,0957205], param1=[startDt,20010601], param2=[endDt,20161221]] [Logging Date Time: 2016-12-21 14:58:43,253] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_LIST] Parameters: [param0=[patientCode,0957205], param1=[startDt,20010601], param2=[endDt,20161221]] [Logging Date Time: 2016-12-21 14:58:43,253] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_LIST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]] [Logging Date Time: 2016-12-21 14:58:43,253] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_LIST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]] [Logging Date Time: 2016-12-21 14:58:46,431] ===================================================================================== SQL Command - Statement Id: [GET_CATEGORY_FOR_DROPDOWN] PreparedStatement : [SELECT CATEGORY_TYPE, CATEGORY_ID, CATEGORY_NAME FROM EFORM_CATEGORY WHERE USE_YN = 'Y' AND P_CATEGORY_RID = '1'] [Logging Date Time: 2016-12-21 14:58:46,431] ===================================================================================== SQL Command - Statement Id: [GET_CATEGORY_FOR_DROPDOWN] PreparedStatement : [SELECT CATEGORY_TYPE, CATEGORY_ID, CATEGORY_NAME FROM EFORM_CATEGORY WHERE USE_YN = 'Y' AND P_CATEGORY_RID = '1'] [Logging Date Time: 2016-12-21 14:58:46,558] ===================================================================================== SQL Command - Statement Id: [GET_CATEGORY_FOR_DROPDOWN] PreparedStatement : [SELECT CATEGORY_TYPE, CATEGORY_ID, CATEGORY_NAME FROM EFORM_CATEGORY WHERE USE_YN = 'Y' AND P_CATEGORY_RID = (SELECT CATEGORY_RID FROM EFORM_CATEGORY WHERE CATEGORY_ID = :param0 )] [Logging Date Time: 2016-12-21 14:58:46,558] ===================================================================================== SQL Command - Statement Id: [GET_CATEGORY_FOR_DROPDOWN] PreparedStatement : [SELECT CATEGORY_TYPE, CATEGORY_ID, CATEGORY_NAME FROM EFORM_CATEGORY WHERE USE_YN = 'Y' AND P_CATEGORY_RID = (SELECT CATEGORY_RID FROM EFORM_CATEGORY WHERE CATEGORY_ID = :param0 )] [Logging Date Time: 2016-12-21 14:58:46,558] ===================================================================================== SQL Command - Statement Id: [GET_CATEGORY_FOR_DROPDOWN] Parameters: [param0=[category_id,1CB1B494-1EF0-48BD-84D6-4965A54E6AEA]] [Logging Date Time: 2016-12-21 14:58:46,558] ===================================================================================== SQL Command - Statement Id: [GET_CATEGORY_FOR_DROPDOWN] Parameters: [param0=[category_id,1CB1B494-1EF0-48BD-84D6-4965A54E6AEA]] [Logging Date Time: 2016-12-21 14:58:46,558] ===================================================================================== SQL Command - Statement Id: [GET_CATEGORY_FOR_DROPDOWN] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-12-21 14:58:46,558] ===================================================================================== SQL Command - Statement Id: [GET_CATEGORY_FOR_DROPDOWN] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-12-21 14:58:47,672] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_BY_SEARCH_LIST] PreparedStatement : [SELECT F.FORM_CD, F.FORM_GUID, F.FORM_NAME, F.FULL_CATEGORY_NAME, F.FORM_RID, F.PRNTCNT, F.PRINT_ONLY, F.OCRTAGPRNTYN FROM (SELECT F.FORM_CD, F.FORM_GUID, F.FORM_NAME, N.FULL_CATEGORY_NAME AS FULL_CATEGORY_NAME, F.FORM_RID, F.PRNTCNT, F.PRINT_ONLY, F.OCRTAGPRNTYN FROM V_EFORM_FORMDOC F, ( SELECT CATEGORY_RID, LEVEL FROM EFORM_CATEGORY START WITH CATEGORY_RID = (SELECT CATEGORY_RID FROM EFORM_CATEGORY WHERE CATEGORY_ID = :param0 ) CONNECT BY P_CATEGORY_RID = PRIOR CATEGORY_RID ) C, ( SELECT CATEGORY_RID,CATEGORY_NAME, LTRIM (SYS_CONNECT_BY_PATH (CATEGORY_NAME, '>'), '>') AS FULL_CATEGORY_NAME, LEVEL FROM EFORM_CATEGORY START WITH CATEGORY_RID = '1' CONNECT BY P_CATEGORY_RID = PRIOR CATEGORY_RID ) N WHERE F.CATEGORY_RID = C.CATEGORY_RID AND C.CATEGORY_RID = N.CATEGORY_RID AND (REPLACE(UPPER(F.FORM_NAME),' ','') LIKE REPLACE(UPPER( :param1 ),' ','') OR UPPER(F.FORM_CD) LIKE UPPER( :param1 )) ) F ORDER BY F.FORM_NAME] [Logging Date Time: 2016-12-21 14:58:47,672] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_BY_SEARCH_LIST] PreparedStatement : [SELECT F.FORM_CD, F.FORM_GUID, F.FORM_NAME, F.FULL_CATEGORY_NAME, F.FORM_RID, F.PRNTCNT, F.PRINT_ONLY, F.OCRTAGPRNTYN FROM (SELECT F.FORM_CD, F.FORM_GUID, F.FORM_NAME, N.FULL_CATEGORY_NAME AS FULL_CATEGORY_NAME, F.FORM_RID, F.PRNTCNT, F.PRINT_ONLY, F.OCRTAGPRNTYN FROM V_EFORM_FORMDOC F, ( SELECT CATEGORY_RID, LEVEL FROM EFORM_CATEGORY START WITH CATEGORY_RID = (SELECT CATEGORY_RID FROM EFORM_CATEGORY WHERE CATEGORY_ID = :param0 ) CONNECT BY P_CATEGORY_RID = PRIOR CATEGORY_RID ) C, ( SELECT CATEGORY_RID,CATEGORY_NAME, LTRIM (SYS_CONNECT_BY_PATH (CATEGORY_NAME, '>'), '>') AS FULL_CATEGORY_NAME, LEVEL FROM EFORM_CATEGORY START WITH CATEGORY_RID = '1' CONNECT BY P_CATEGORY_RID = PRIOR CATEGORY_RID ) N WHERE F.CATEGORY_RID = C.CATEGORY_RID AND C.CATEGORY_RID = N.CATEGORY_RID AND (REPLACE(UPPER(F.FORM_NAME),' ','') LIKE REPLACE(UPPER( :param1 ),' ','') OR UPPER(F.FORM_CD) LIKE UPPER( :param1 )) ) F ORDER BY F.FORM_NAME] [Logging Date Time: 2016-12-21 14:58:47,673] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_BY_SEARCH_LIST] Parameters: [param0=[category_id,1CB1B494-1EF0-48BD-84D6-4965A54E6AEA], param1=[key_word,%%%%]] [Logging Date Time: 2016-12-21 14:58:47,673] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_BY_SEARCH_LIST] Parameters: [param0=[category_id,1CB1B494-1EF0-48BD-84D6-4965A54E6AEA], param1=[key_word,%%%%]] [Logging Date Time: 2016-12-21 14:58:47,673] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_BY_SEARCH_LIST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String]] [Logging Date Time: 2016-12-21 14:58:47,673] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_BY_SEARCH_LIST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String]] [Logging Date Time: 2016-12-21 14:58:50,417] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] PreparedStatement : [SELECT signdata FROM emr.mrfmsignimge WHERE userid = :param0 and repryn = 'Y'] [Logging Date Time: 2016-12-21 14:58:50,417] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] PreparedStatement : [SELECT signdata FROM emr.mrfmsignimge WHERE userid = :param0 and repryn = 'Y'] [Logging Date Time: 2016-12-21 14:58:50,417] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] Parameters: [param0=[userid,104876]] [Logging Date Time: 2016-12-21 14:58:50,417] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] Parameters: [param0=[userid,104876]] [Logging Date Time: 2016-12-21 14:58:50,418] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-12-21 14:58:50,418] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-12-21 14:58:50,522] ===================================================================================== SQL Command - Statement Id: [getOcrTag] PreparedStatement : [SELECT to_char(sysdate,'YYYYMMDD') || SUBSTR(LPAD((EMR.SQ_MRFMOCRP_01.NEXTVAL), 10, '0'), 6, 5) AS ocrtag FROM dual] [Logging Date Time: 2016-12-21 14:58:50,522] ===================================================================================== SQL Command - Statement Id: [getOcrTag] PreparedStatement : [SELECT to_char(sysdate,'YYYYMMDD') || SUBSTR(LPAD((EMR.SQ_MRFMOCRP_01.NEXTVAL), 10, '0'), 6, 5) AS ocrtag FROM dual] [Logging Date Time: 2016-12-21 14:58:50,580] ===================================================================================== SQL Command - Statement Id: [GetConsentStateCheck] PreparedStatement : [select mst.consent_state from cmr.consent_mst mst where mst.consent_mst_rid = :param0 and mst.use_yn = 'Y'] [Logging Date Time: 2016-12-21 14:58:50,580] ===================================================================================== SQL Command - Statement Id: [GetConsentStateCheck] PreparedStatement : [select mst.consent_state from cmr.consent_mst mst where mst.consent_mst_rid = :param0 and mst.use_yn = 'Y'] [Logging Date Time: 2016-12-21 14:58:50,580] ===================================================================================== SQL Command - Statement Id: [GetConsentStateCheck] Parameters: [param0=[consentmstrid,-1]] [Logging Date Time: 2016-12-21 14:58:50,580] ===================================================================================== SQL Command - Statement Id: [GetConsentStateCheck] Parameters: [param0=[consentmstrid,-1]] [Logging Date Time: 2016-12-21 14:58:50,580] ===================================================================================== SQL Command - Statement Id: [GetConsentStateCheck] Types: [param0=[Int32, System.Int32]] [Logging Date Time: 2016-12-21 14:58:50,580] ===================================================================================== SQL Command - Statement Id: [GetConsentStateCheck] Types: [param0=[Int32, System.Int32]] [Logging Date Time: 2016-12-21 14:58:55,009] ===================================================================================== SQL Command - Statement Id: [GetConsentStateCheck] PreparedStatement : [select mst.consent_state from cmr.consent_mst mst where mst.consent_mst_rid = :param0 and mst.use_yn = 'Y'] [Logging Date Time: 2016-12-21 14:58:55,009] ===================================================================================== SQL Command - Statement Id: [GetConsentStateCheck] PreparedStatement : [select mst.consent_state from cmr.consent_mst mst where mst.consent_mst_rid = :param0 and mst.use_yn = 'Y'] [Logging Date Time: 2016-12-21 14:58:55,009] ===================================================================================== SQL Command - Statement Id: [GetConsentStateCheck] Parameters: [param0=[consentmstrid,-1]] [Logging Date Time: 2016-12-21 14:58:55,009] ===================================================================================== SQL Command - Statement Id: [GetConsentStateCheck] Parameters: [param0=[consentmstrid,-1]] [Logging Date Time: 2016-12-21 14:58:55,009] ===================================================================================== SQL Command - Statement Id: [GetConsentStateCheck] Types: [param0=[Int32, System.Int32]] [Logging Date Time: 2016-12-21 14:58:55,009] ===================================================================================== SQL Command - Statement Id: [GetConsentStateCheck] Types: [param0=[Int32, System.Int32]] [Logging Date Time: 2016-12-21 14:59:04,468] ===================================================================================== SQL Command - Statement Id: [GetConsentStateCheck] PreparedStatement : [select mst.consent_state from cmr.consent_mst mst where mst.consent_mst_rid = :param0 and mst.use_yn = 'Y'] [Logging Date Time: 2016-12-21 14:59:04,468] ===================================================================================== SQL Command - Statement Id: [GetConsentStateCheck] PreparedStatement : [select mst.consent_state from cmr.consent_mst mst where mst.consent_mst_rid = :param0 and mst.use_yn = 'Y'] [Logging Date Time: 2016-12-21 14:59:04,468] ===================================================================================== SQL Command - Statement Id: [GetConsentStateCheck] Parameters: [param0=[consentmstrid,-1]] [Logging Date Time: 2016-12-21 14:59:04,468] ===================================================================================== SQL Command - Statement Id: [GetConsentStateCheck] Parameters: [param0=[consentmstrid,-1]] [Logging Date Time: 2016-12-21 14:59:04,468] ===================================================================================== SQL Command - Statement Id: [GetConsentStateCheck] Types: [param0=[Int32, System.Int32]] [Logging Date Time: 2016-12-21 14:59:04,468] ===================================================================================== SQL Command - Statement Id: [GetConsentStateCheck] Types: [param0=[Int32, System.Int32]] [Logging Date Time: 2016-12-21 14:59:04,678] ===================================================================================== SQL Command - CLIP.eForm SaveTempData param : clnDept[104876]patientCode[0957205]clnDeptCode[2010300000]formRid[2209]formCd[1300009890]consentMstRid[-1]rewriteConsentMstRid[0]deviceType[WIN]vistType[I]hosType[111]clnDate[20161209]ward[101]roomcd[1001]orderNo[0]orderName[]orderCd[]ocrCode[2016122124225]cretno[1]createUserName[¹ÚÁ¾ÈÆ]modifyUserName[¹ÚÁ¾ÈÆ]deviceIdentNo[16-101-33]mainDrId[104796]dataXml[]formXml[
] [Logging Date Time: 2016-12-21 14:59:04,750] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] PreparedStatement : [select ud1_num as seq from EFORM_CODE where main_cd = 'SEQUENCE' and sub_cd = :param0 for update] [Logging Date Time: 2016-12-21 14:59:04,750] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] PreparedStatement : [select ud1_num as seq from EFORM_CODE where main_cd = 'SEQUENCE' and sub_cd = :param0 for update] [Logging Date Time: 2016-12-21 14:59:04,751] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Parameters: [param0=[sub_cd,CONSENT_MST]] [Logging Date Time: 2016-12-21 14:59:04,751] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Parameters: [param0=[sub_cd,CONSENT_MST]] [Logging Date Time: 2016-12-21 14:59:04,751] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-12-21 14:59:04,751] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-12-21 14:59:04,753] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] PreparedStatement : [update EFORM_CODE set ud1_num = :param0 where main_cd = 'SEQUENCE' and sub_cd = :param1] [Logging Date Time: 2016-12-21 14:59:04,753] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] PreparedStatement : [update EFORM_CODE set ud1_num = :param0 where main_cd = 'SEQUENCE' and sub_cd = :param1] [Logging Date Time: 2016-12-21 14:59:04,754] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Parameters: [param0=[ud1_num,15832], param1=[sub_cd,CONSENT_MST]] [Logging Date Time: 2016-12-21 14:59:04,754] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Parameters: [param0=[ud1_num,15832], param1=[sub_cd,CONSENT_MST]] [Logging Date Time: 2016-12-21 14:59:04,754] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String]] [Logging Date Time: 2016-12-21 14:59:04,754] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String]] [Logging Date Time: 2016-12-21 14:59:04,757] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] PreparedStatement : [select ud1_num as seq from EFORM_CODE where main_cd = 'SEQUENCE' and sub_cd = :param0 for update] [Logging Date Time: 2016-12-21 14:59:04,757] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] PreparedStatement : [select ud1_num as seq from EFORM_CODE where main_cd = 'SEQUENCE' and sub_cd = :param0 for update] [Logging Date Time: 2016-12-21 14:59:04,757] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Parameters: [param0=[sub_cd,CONSENT_DATA]] [Logging Date Time: 2016-12-21 14:59:04,757] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Parameters: [param0=[sub_cd,CONSENT_DATA]] [Logging Date Time: 2016-12-21 14:59:04,757] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-12-21 14:59:04,757] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-12-21 14:59:04,762] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] PreparedStatement : [update EFORM_CODE set ud1_num = :param0 where main_cd = 'SEQUENCE' and sub_cd = :param1] [Logging Date Time: 2016-12-21 14:59:04,762] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] PreparedStatement : [update EFORM_CODE set ud1_num = :param0 where main_cd = 'SEQUENCE' and sub_cd = :param1] [Logging Date Time: 2016-12-21 14:59:04,762] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Parameters: [param0=[ud1_num,15201], param1=[sub_cd,CONSENT_DATA]] [Logging Date Time: 2016-12-21 14:59:04,762] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Parameters: [param0=[ud1_num,15201], param1=[sub_cd,CONSENT_DATA]] [Logging Date Time: 2016-12-21 14:59:04,762] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String]] [Logging Date Time: 2016-12-21 14:59:04,762] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String]] [Logging Date Time: 2016-12-21 14:59:04,771] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_MST] PreparedStatement : [insert into CONSENT_MST ( CONSENT_MST_RID, HOS_TYPE, PID, VISIT_TYPE, OCR_NUMBER, CLN_DEPT_CD, CLN_DATE, CRETNO, WARDCD, ROOMCD, FORM_RID, CONSENT_STATE, COMPLETE_YN, COMPLETE_DATETIME, PAPER_YN, REISSUE_YN, REISSUE_CONSENT_MST_RID, REWRITE_YN, REWRITE_CONSENT_MST_RID, USE_YN, MAIN_DR_ID, CREATE_USER_ID, CREATE_DATETIME, MODIFY_USER_ID, MODIFY_DATETIME, CREATE_USER_NAME, MODIFY_USER_NAME ) values ( :param0 , :param1 , :param2 , :param3 , :param4 , :param5 , :param6 , :param7 , :param8 , :param9 , :param10 , :param11 , :param12 , '', :param13 , :param14 , :param15 , :param16 , :param17 , 'Y', :param18 , :param19 , TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'), :param19 , TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'), :param20 , :param21 )] [Logging Date Time: 2016-12-21 14:59:04,771] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_MST] PreparedStatement : [insert into CONSENT_MST ( CONSENT_MST_RID, HOS_TYPE, PID, VISIT_TYPE, OCR_NUMBER, CLN_DEPT_CD, CLN_DATE, CRETNO, WARDCD, ROOMCD, FORM_RID, CONSENT_STATE, COMPLETE_YN, COMPLETE_DATETIME, PAPER_YN, REISSUE_YN, REISSUE_CONSENT_MST_RID, REWRITE_YN, REWRITE_CONSENT_MST_RID, USE_YN, MAIN_DR_ID, CREATE_USER_ID, CREATE_DATETIME, MODIFY_USER_ID, MODIFY_DATETIME, CREATE_USER_NAME, MODIFY_USER_NAME ) values ( :param0 , :param1 , :param2 , :param3 , :param4 , :param5 , :param6 , :param7 , :param8 , :param9 , :param10 , :param11 , :param12 , '', :param13 , :param14 , :param15 , :param16 , :param17 , 'Y', :param18 , :param19 , TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'), :param19 , TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'), :param20 , :param21 )] [Logging Date Time: 2016-12-21 14:59:04,771] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_MST] Parameters: [param0=[consentMstRid,15832], param1=[hosType,111], param2=[patientCode,0957205], param3=[vistType,I], param4=[ocrCode,2016122124225], param5=[clnDeptCd,2010300000], param6=[clnDate,20161209], param7=[cretno,1], param8=[ward,101], param9=[roomcd,1001], param10=[formRid,2209], param11=[consentState,TEMP], param12=[completeYn,N], param13=[paperYn,N], param14=[reissueYn,N], param15=[reissueConsentMstRid,0], param16=[rewriteYn,N], param17=[rewriteConsentMstRid,0], param18=[mainDrId,104796], param19=[userId,104876], param20=[createUserName,¹ÚÁ¾ÈÆ], param21=[modifyUserName,¹ÚÁ¾ÈÆ]] [Logging Date Time: 2016-12-21 14:59:04,771] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_MST] Parameters: [param0=[consentMstRid,15832], param1=[hosType,111], param2=[patientCode,0957205], param3=[vistType,I], param4=[ocrCode,2016122124225], param5=[clnDeptCd,2010300000], param6=[clnDate,20161209], param7=[cretno,1], param8=[ward,101], param9=[roomcd,1001], param10=[formRid,2209], param11=[consentState,TEMP], param12=[completeYn,N], param13=[paperYn,N], param14=[reissueYn,N], param15=[reissueConsentMstRid,0], param16=[rewriteYn,N], param17=[rewriteConsentMstRid,0], param18=[mainDrId,104796], param19=[userId,104876], param20=[createUserName,¹ÚÁ¾ÈÆ], param21=[modifyUserName,¹ÚÁ¾ÈÆ]] [Logging Date Time: 2016-12-21 14:59:04,771] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_MST] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String], param5=[AnsiString, System.String], param6=[AnsiString, System.String], param7=[Int32, System.Int32], param8=[AnsiString, System.String], param9=[AnsiString, System.String], param10=[Int32, System.Int32], param11=[AnsiString, System.String], param12=[AnsiString, System.String], param13=[AnsiString, System.String], param14=[AnsiString, System.String], param15=[Int32, System.Int32], param16=[AnsiString, System.String], param17=[Int32, System.Int32], param18=[AnsiString, System.String], param19=[AnsiString, System.String], param20=[AnsiString, System.String], param21=[AnsiString, System.String]] [Logging Date Time: 2016-12-21 14:59:04,771] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_MST] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String], param5=[AnsiString, System.String], param6=[AnsiString, System.String], param7=[Int32, System.Int32], param8=[AnsiString, System.String], param9=[AnsiString, System.String], param10=[Int32, System.Int32], param11=[AnsiString, System.String], param12=[AnsiString, System.String], param13=[AnsiString, System.String], param14=[AnsiString, System.String], param15=[Int32, System.Int32], param16=[AnsiString, System.String], param17=[Int32, System.Int32], param18=[AnsiString, System.String], param19=[AnsiString, System.String], param20=[AnsiString, System.String], param21=[AnsiString, System.String]] [Logging Date Time: 2016-12-21 14:59:04,775] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_DATA] PreparedStatement : [insert into CONSENT_DATA ( CONSENT_DATA_RID, CONSENT_MST_RID, FORM_RID, DEVICE_TYPE, DEVICE_IDENT_NO, COMPLETE_YN, CREATE_USER_ID, CREATE_DATETIME, FORM_XML, DATA_XML ) values ( :param0 , :param1 , :param2 , :param3 , :param4 , :param5 , :param6 , TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'), :param7 , :param8 )] [Logging Date Time: 2016-12-21 14:59:04,775] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_DATA] PreparedStatement : [insert into CONSENT_DATA ( CONSENT_DATA_RID, CONSENT_MST_RID, FORM_RID, DEVICE_TYPE, DEVICE_IDENT_NO, COMPLETE_YN, CREATE_USER_ID, CREATE_DATETIME, FORM_XML, DATA_XML ) values ( :param0 , :param1 , :param2 , :param3 , :param4 , :param5 , :param6 , TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'), :param7 , :param8 )] [Logging Date Time: 2016-12-21 14:59:04,775] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_DATA] Parameters: [param0=[consentDataRid,15201], param1=[consentMstRid,15832], param2=[formRid,2209], param3=[deviceType,WIN], param4=[deviceIdentNo,16-101-33], param5=[completeYn,N], param6=[userId,104876], param7=[formXml,System.Byte[]], param8=[dataXml,System.Byte[]]] [Logging Date Time: 2016-12-21 14:59:04,775] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_DATA] Parameters: [param0=[consentDataRid,15201], param1=[consentMstRid,15832], param2=[formRid,2209], param3=[deviceType,WIN], param4=[deviceIdentNo,16-101-33], param5=[completeYn,N], param6=[userId,104876], param7=[formXml,System.Byte[]], param8=[dataXml,System.Byte[]]] [Logging Date Time: 2016-12-21 14:59:04,775] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_DATA] Types: [param0=[Int32, System.Int32], param1=[Int32, System.Int32], param2=[Int32, System.Int32], param3=[AnsiString, System.String], param4=[AnsiString, System.String], param5=[AnsiString, System.String], param6=[AnsiString, System.String], param7=[Binary, System.Byte[]], param8=[Binary, System.Byte[]]] [Logging Date Time: 2016-12-21 14:59:04,775] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_DATA] Types: [param0=[Int32, System.Int32], param1=[Int32, System.Int32], param2=[Int32, System.Int32], param3=[AnsiString, System.String], param4=[AnsiString, System.String], param5=[AnsiString, System.String], param6=[AnsiString, System.String], param7=[Binary, System.Byte[]], param8=[Binary, System.Byte[]]] [Logging Date Time: 2016-12-21 14:59:05,452] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/IO_device [Logging Date Time: 2016-12-21 14:59:05,452] ===================================================================================== SQL Command - DataXmlToDictionary 1 : IO_device/ [Logging Date Time: 2016-12-21 14:59:05,453] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/O_device_ID [Logging Date Time: 2016-12-21 14:59:05,453] ===================================================================================== SQL Command - DataXmlToDictionary 1 : O_device_ID/16-101-33 [Logging Date Time: 2016-12-21 14:59:05,453] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/IO_ocr_cd [Logging Date Time: 2016-12-21 14:59:05,453] ===================================================================================== SQL Command - DataXmlToDictionary 1 : IO_ocr_cd/2016122124225 [Logging Date Time: 2016-12-21 14:59:05,453] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/IO_Pt_ID [Logging Date Time: 2016-12-21 14:59:05,453] ===================================================================================== SQL Command - DataXmlToDictionary 1 : IO_Pt_ID/ [Logging Date Time: 2016-12-21 14:59:05,453] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/IO_sex_age_y_m [Logging Date Time: 2016-12-21 14:59:05,453] ===================================================================================== SQL Command - DataXmlToDictionary 1 : IO_sex_age_y_m/ [Logging Date Time: 2016-12-21 14:59:05,453] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/IO_Pt_name [Logging Date Time: 2016-12-21 14:59:05,453] ===================================================================================== SQL Command - DataXmlToDictionary 1 : IO_Pt_name/ [Logging Date Time: 2016-12-21 14:59:05,454] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/IO_JuminNo [Logging Date Time: 2016-12-21 14:59:05,454] ===================================================================================== SQL Command - DataXmlToDictionary 1 : IO_JuminNo/ [Logging Date Time: 2016-12-21 14:59:05,454] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/IO_roomNo [Logging Date Time: 2016-12-21 14:59:05,454] ===================================================================================== SQL Command - DataXmlToDictionary 1 : IO_roomNo/ [Logging Date Time: 2016-12-21 14:59:05,454] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/IO_ADdate [Logging Date Time: 2016-12-21 14:59:05,454] ===================================================================================== SQL Command - DataXmlToDictionary 1 : IO_ADdate/ [Logging Date Time: 2016-12-21 14:59:05,454] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/IO_Dept [Logging Date Time: 2016-12-21 14:59:05,454] ===================================================================================== SQL Command - DataXmlToDictionary 1 : IO_Dept/ [Logging Date Time: 2016-12-21 14:59:05,454] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/IO_formname [Logging Date Time: 2016-12-21 14:59:05,454] ===================================================================================== SQL Command - DataXmlToDictionary 1 : IO_formname/ [Logging Date Time: 2016-12-21 14:59:05,454] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/IO_OPdept [Logging Date Time: 2016-12-21 14:59:05,454] ===================================================================================== SQL Command - DataXmlToDictionary 1 : IO_OPdept/ [Logging Date Time: 2016-12-21 14:59:05,454] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/IO_OPdr [Logging Date Time: 2016-12-21 14:59:05,455] ===================================================================================== SQL Command - DataXmlToDictionary 1 : IO_OPdr/ [Logging Date Time: 2016-12-21 14:59:05,455] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/IO_Dx [Logging Date Time: 2016-12-21 14:59:05,455] ===================================================================================== SQL Command - DataXmlToDictionary 1 : IO_Dx/ [Logging Date Time: 2016-12-21 14:59:05,455] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/IO_maindr [Logging Date Time: 2016-12-21 14:59:05,455] ===================================================================================== SQL Command - DataXmlToDictionary 1 : IO_maindr/±èÇö¼ö [Logging Date Time: 2016-12-21 14:59:05,455] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/IO_signdate [Logging Date Time: 2016-12-21 14:59:05,455] ===================================================================================== SQL Command - DataXmlToDictionary 1 : IO_signdate/ [Logging Date Time: 2016-12-21 14:59:05,455] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/IO_signtime [Logging Date Time: 2016-12-21 14:59:05,455] ===================================================================================== SQL Command - DataXmlToDictionary 1 : IO_signtime/ [Logging Date Time: 2016-12-21 14:59:05,455] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/IO_printtime [Logging Date Time: 2016-12-21 14:59:05,455] ===================================================================================== SQL Command - DataXmlToDictionary 1 : IO_printtime/2016-12-21 14:58:50 [Logging Date Time: 2016-12-21 14:59:05,455] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/O_Pt_rel [Logging Date Time: 2016-12-21 14:59:05,455] ===================================================================================== SQL Command - DataXmlToDictionary 1 : O_Pt_rel/ [Logging Date Time: 2016-12-21 14:59:05,456] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/O_sign_cause [Logging Date Time: 2016-12-21 14:59:05,456] ===================================================================================== SQL Command - DataXmlToDictionary 1 : O_sign_cause/ [Logging Date Time: 2016-12-21 14:59:05,456] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/O_Ptname_write [Logging Date Time: 2016-12-21 14:59:05,456] ===================================================================================== SQL Command - DataXmlToDictionary 1 : O_Ptname_write/ [Logging Date Time: 2016-12-21 14:59:05,456] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/O_Ptsign [Logging Date Time: 2016-12-21 14:59:05,456] ===================================================================================== SQL Command - DataXmlToDictionary 1 : O_Ptsign/ [Logging Date Time: 2016-12-21 14:59:05,456] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/O_JuminNo [Logging Date Time: 2016-12-21 14:59:05,456] ===================================================================================== SQL Command - DataXmlToDictionary 1 : O_JuminNo/ [Logging Date Time: 2016-12-21 14:59:05,456] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/O_Drname_write [Logging Date Time: 2016-12-21 14:59:05,456] ===================================================================================== SQL Command - DataXmlToDictionary 1 : O_Drname_write/ [Logging Date Time: 2016-12-21 14:59:05,456] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/O_drsign [Logging Date Time: 2016-12-21 14:59:05,456] ===================================================================================== SQL Command - DataXmlToDictionary 1 : O_drsign/ [Logging Date Time: 2016-12-21 14:59:05,456] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/IO_INPUTNM [Logging Date Time: 2016-12-21 14:59:05,457] ===================================================================================== SQL Command - DataXmlToDictionary 1 : IO_INPUTNM/ [Logging Date Time: 2016-12-21 14:59:05,457] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 8/base_info [Logging Date Time: 2016-12-21 14:59:05,457] ===================================================================================== SQL Command - DataXmlToDictionary : IO_Pt_ID [Logging Date Time: 2016-12-21 14:59:05,457] ===================================================================================== SQL Command - DataXmlToDictionary : 1 [Logging Date Time: 2016-12-21 14:59:05,457] ===================================================================================== SQL Command - DataXmlToDictionary 2 : IO_Pt_ID/0957205 [Logging Date Time: 2016-12-21 14:59:05,457] ===================================================================================== SQL Command - DataXmlToDictionary : IO_sex_age_y_m [Logging Date Time: 2016-12-21 14:59:05,457] ===================================================================================== SQL Command - DataXmlToDictionary : 1 [Logging Date Time: 2016-12-21 14:59:05,457] ===================================================================================== SQL Command - DataXmlToDictionary 2 : IO_sex_age_y_m/F/72 [Logging Date Time: 2016-12-21 14:59:05,457] ===================================================================================== SQL Command - DataXmlToDictionary : IO_formname [Logging Date Time: 2016-12-21 14:59:05,457] ===================================================================================== SQL Command - DataXmlToDictionary : 1 [Logging Date Time: 2016-12-21 14:59:05,457] ===================================================================================== SQL Command - DataXmlToDictionary 2 : IO_formname/CTÀ¯µµ °æÇÇÀû ħ»ý°Ë ¼³¸í ¹× µ¿ÀǼ­ [Logging Date Time: 2016-12-21 14:59:05,457] ===================================================================================== SQL Command - DataXmlToDictionary : IO_Pt_name [Logging Date Time: 2016-12-21 14:59:05,457] ===================================================================================== SQL Command - DataXmlToDictionary : 1 [Logging Date Time: 2016-12-21 14:59:05,458] ===================================================================================== SQL Command - DataXmlToDictionary 2 : IO_Pt_name/±èÈñÀÚ [Logging Date Time: 2016-12-21 14:59:05,458] ===================================================================================== SQL Command - DataXmlToDictionary : IO_JuminNo [Logging Date Time: 2016-12-21 14:59:05,458] ===================================================================================== SQL Command - DataXmlToDictionary : 1 [Logging Date Time: 2016-12-21 14:59:05,458] ===================================================================================== SQL Command - DataXmlToDictionary 2 : IO_JuminNo/440505-2****** [Logging Date Time: 2016-12-21 14:59:05,458] ===================================================================================== SQL Command - DataXmlToDictionary : IO_roomNo [Logging Date Time: 2016-12-21 14:59:05,458] ===================================================================================== SQL Command - DataXmlToDictionary : 1 [Logging Date Time: 2016-12-21 14:59:05,458] ===================================================================================== SQL Command - DataXmlToDictionary 2 : IO_roomNo/101/1001 [Logging Date Time: 2016-12-21 14:59:05,458] ===================================================================================== SQL Command - DataXmlToDictionary : IO_ADdate [Logging Date Time: 2016-12-21 14:59:05,458] ===================================================================================== SQL Command - DataXmlToDictionary : 1 [Logging Date Time: 2016-12-21 14:59:05,458] ===================================================================================== SQL Command - DataXmlToDictionary 2 : IO_ADdate/2016/12/09 [Logging Date Time: 2016-12-21 14:59:05,458] ===================================================================================== SQL Command - DataXmlToDictionary : IO_Dept [Logging Date Time: 2016-12-21 14:59:05,458] ===================================================================================== SQL Command - DataXmlToDictionary : 1 [Logging Date Time: 2016-12-21 14:59:05,458] ===================================================================================== SQL Command - DataXmlToDictionary 2 : IO_Dept/IG [Logging Date Time: 2016-12-21 14:59:05,458] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/IO_bp [Logging Date Time: 2016-12-21 14:59:05,459] ===================================================================================== SQL Command - DataXmlToDictionary 1 : IO_bp/ [Logging Date Time: 2016-12-21 14:59:05,459] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/IO_dm [Logging Date Time: 2016-12-21 14:59:05,459] ===================================================================================== SQL Command - DataXmlToDictionary 1 : IO_dm/ [Logging Date Time: 2016-12-21 14:59:05,459] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/IO_heart [Logging Date Time: 2016-12-21 14:59:05,459] ===================================================================================== SQL Command - DataXmlToDictionary 1 : IO_heart/ [Logging Date Time: 2016-12-21 14:59:05,459] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/IO_kidney [Logging Date Time: 2016-12-21 14:59:05,459] ===================================================================================== SQL Command - DataXmlToDictionary 1 : IO_kidney/ [Logging Date Time: 2016-12-21 14:59:05,459] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/IO_respiration [Logging Date Time: 2016-12-21 14:59:05,459] ===================================================================================== SQL Command - DataXmlToDictionary 1 : IO_respiration/ [Logging Date Time: 2016-12-21 14:59:05,459] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/IO_hx [Logging Date Time: 2016-12-21 14:59:05,459] ===================================================================================== SQL Command - DataXmlToDictionary 1 : IO_hx/ [Logging Date Time: 2016-12-21 14:59:05,459] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/IO_allergy [Logging Date Time: 2016-12-21 14:59:05,459] ===================================================================================== SQL Command - DataXmlToDictionary 1 : IO_allergy/ [Logging Date Time: 2016-12-21 14:59:05,460] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/IO_drug [Logging Date Time: 2016-12-21 14:59:05,460] ===================================================================================== SQL Command - DataXmlToDictionary 1 : IO_drug/ [Logging Date Time: 2016-12-21 14:59:05,460] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/IO_smoking [Logging Date Time: 2016-12-21 14:59:05,460] ===================================================================================== SQL Command - DataXmlToDictionary 1 : IO_smoking/ [Logging Date Time: 2016-12-21 14:59:05,460] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/IO_idio [Logging Date Time: 2016-12-21 14:59:05,460] ===================================================================================== SQL Command - DataXmlToDictionary 1 : IO_idio/ [Logging Date Time: 2016-12-21 14:59:05,460] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/IO_nacrotics [Logging Date Time: 2016-12-21 14:59:05,460] ===================================================================================== SQL Command - DataXmlToDictionary 1 : IO_nacrotics/ [Logging Date Time: 2016-12-21 14:59:05,460] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/IO_airway [Logging Date Time: 2016-12-21 14:59:05,460] ===================================================================================== SQL Command - DataXmlToDictionary 1 : IO_airway/ [Logging Date Time: 2016-12-21 14:59:05,460] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/IO_hemorrhage [Logging Date Time: 2016-12-21 14:59:05,460] ===================================================================================== SQL Command - DataXmlToDictionary 1 : IO_hemorrhage/ [Logging Date Time: 2016-12-21 14:59:05,460] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/IO_status_etc [Logging Date Time: 2016-12-21 14:59:05,461] ===================================================================================== SQL Command - DataXmlToDictionary 1 : IO_status_etc/ [Logging Date Time: 2016-12-21 14:59:05,461] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/prodr_info [Logging Date Time: 2016-12-21 14:59:05,461] ===================================================================================== SQL Command - DataXmlToDictionary 1 : prodr_info/ [Logging Date Time: 2016-12-21 14:59:05,461] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 14/state [Logging Date Time: 2016-12-21 14:59:05,461] ===================================================================================== SQL Command - DataXmlToDictionary : IO_bp [Logging Date Time: 2016-12-21 14:59:05,461] ===================================================================================== SQL Command - DataXmlToDictionary : 1 [Logging Date Time: 2016-12-21 14:59:05,461] ===================================================================================== SQL Command - DataXmlToDictionary 2 : IO_bp/ [Logging Date Time: 2016-12-21 14:59:05,461] ===================================================================================== SQL Command - DataXmlToDictionary : IO_hx [Logging Date Time: 2016-12-21 14:59:05,461] ===================================================================================== SQL Command - DataXmlToDictionary : 1 [Logging Date Time: 2016-12-21 14:59:05,461] ===================================================================================== SQL Command - DataXmlToDictionary 2 : IO_hx/ [Logging Date Time: 2016-12-21 14:59:05,461] ===================================================================================== SQL Command - DataXmlToDictionary : IO_idio [Logging Date Time: 2016-12-21 14:59:05,461] ===================================================================================== SQL Command - DataXmlToDictionary : 1 [Logging Date Time: 2016-12-21 14:59:05,461] ===================================================================================== SQL Command - DataXmlToDictionary 2 : IO_idio/ [Logging Date Time: 2016-12-21 14:59:05,462] ===================================================================================== SQL Command - DataXmlToDictionary : IO_dm [Logging Date Time: 2016-12-21 14:59:05,462] ===================================================================================== SQL Command - DataXmlToDictionary : 1 [Logging Date Time: 2016-12-21 14:59:05,462] ===================================================================================== SQL Command - DataXmlToDictionary 2 : IO_dm/ [Logging Date Time: 2016-12-21 14:59:05,462] ===================================================================================== SQL Command - DataXmlToDictionary : IO_allergy [Logging Date Time: 2016-12-21 14:59:05,462] ===================================================================================== SQL Command - DataXmlToDictionary : 1 [Logging Date Time: 2016-12-21 14:59:05,462] ===================================================================================== SQL Command - DataXmlToDictionary 2 : IO_allergy/ [Logging Date Time: 2016-12-21 14:59:05,462] ===================================================================================== SQL Command - DataXmlToDictionary : IO_nacrotics [Logging Date Time: 2016-12-21 14:59:05,462] ===================================================================================== SQL Command - DataXmlToDictionary : 1 [Logging Date Time: 2016-12-21 14:59:05,462] ===================================================================================== SQL Command - DataXmlToDictionary 2 : IO_nacrotics/ [Logging Date Time: 2016-12-21 14:59:05,462] ===================================================================================== SQL Command - DataXmlToDictionary : IO_heart [Logging Date Time: 2016-12-21 14:59:05,462] ===================================================================================== SQL Command - DataXmlToDictionary : 1 [Logging Date Time: 2016-12-21 14:59:05,462] ===================================================================================== SQL Command - DataXmlToDictionary 2 : IO_heart/ [Logging Date Time: 2016-12-21 14:59:05,462] ===================================================================================== SQL Command - DataXmlToDictionary : IO_drug [Logging Date Time: 2016-12-21 14:59:05,462] ===================================================================================== SQL Command - DataXmlToDictionary : 1 [Logging Date Time: 2016-12-21 14:59:05,463] ===================================================================================== SQL Command - DataXmlToDictionary 2 : IO_drug/ [Logging Date Time: 2016-12-21 14:59:05,463] ===================================================================================== SQL Command - DataXmlToDictionary : IO_airway [Logging Date Time: 2016-12-21 14:59:05,463] ===================================================================================== SQL Command - DataXmlToDictionary : 1 [Logging Date Time: 2016-12-21 14:59:05,463] ===================================================================================== SQL Command - DataXmlToDictionary 2 : IO_airway/ [Logging Date Time: 2016-12-21 14:59:05,463] ===================================================================================== SQL Command - DataXmlToDictionary : IO_kidney [Logging Date Time: 2016-12-21 14:59:05,463] ===================================================================================== SQL Command - DataXmlToDictionary : 1 [Logging Date Time: 2016-12-21 14:59:05,463] ===================================================================================== SQL Command - DataXmlToDictionary 2 : IO_kidney/ [Logging Date Time: 2016-12-21 14:59:05,463] ===================================================================================== SQL Command - DataXmlToDictionary : IO_smoking [Logging Date Time: 2016-12-21 14:59:05,463] ===================================================================================== SQL Command - DataXmlToDictionary : 1 [Logging Date Time: 2016-12-21 14:59:05,463] ===================================================================================== SQL Command - DataXmlToDictionary 2 : IO_smoking/ [Logging Date Time: 2016-12-21 14:59:05,463] ===================================================================================== SQL Command - DataXmlToDictionary : IO_hemorrhage [Logging Date Time: 2016-12-21 14:59:05,463] ===================================================================================== SQL Command - DataXmlToDictionary : 1 [Logging Date Time: 2016-12-21 14:59:05,463] ===================================================================================== SQL Command - DataXmlToDictionary 2 : IO_hemorrhage/ [Logging Date Time: 2016-12-21 14:59:05,464] ===================================================================================== SQL Command - DataXmlToDictionary : IO_respiration [Logging Date Time: 2016-12-21 14:59:05,464] ===================================================================================== SQL Command - DataXmlToDictionary : 1 [Logging Date Time: 2016-12-21 14:59:05,464] ===================================================================================== SQL Command - DataXmlToDictionary 2 : IO_respiration/ [Logging Date Time: 2016-12-21 14:59:05,464] ===================================================================================== SQL Command - DataXmlToDictionary : IO_status_etc [Logging Date Time: 2016-12-21 14:59:05,464] ===================================================================================== SQL Command - DataXmlToDictionary : 1 [Logging Date Time: 2016-12-21 14:59:05,464] ===================================================================================== SQL Command - DataXmlToDictionary 2 : IO_status_etc/ [Logging Date Time: 2016-12-21 14:59:05,464] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/Prometh_change [Logging Date Time: 2016-12-21 14:59:05,464] ===================================================================================== SQL Command - DataXmlToDictionary 1 : Prometh_change/ [Logging Date Time: 2016-12-21 14:59:05,464] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 10/consent [Logging Date Time: 2016-12-21 14:59:05,464] ===================================================================================== SQL Command - DataXmlToDictionary : O_sign_cause [Logging Date Time: 2016-12-21 14:59:05,464] ===================================================================================== SQL Command - DataXmlToDictionary : 1 [Logging Date Time: 2016-12-21 14:59:05,464] ===================================================================================== SQL Command - DataXmlToDictionary 2 : O_sign_cause/ [Logging Date Time: 2016-12-21 14:59:05,464] ===================================================================================== SQL Command - DataXmlToDictionary : O_Pt_rel [Logging Date Time: 2016-12-21 14:59:05,464] ===================================================================================== SQL Command - DataXmlToDictionary : 1 [Logging Date Time: 2016-12-21 14:59:05,465] ===================================================================================== SQL Command - DataXmlToDictionary 2 : O_Pt_rel/ [Logging Date Time: 2016-12-21 14:59:05,465] ===================================================================================== SQL Command - DataXmlToDictionary : IO_signdate [Logging Date Time: 2016-12-21 14:59:05,465] ===================================================================================== SQL Command - DataXmlToDictionary : 1 [Logging Date Time: 2016-12-21 14:59:05,465] ===================================================================================== SQL Command - DataXmlToDictionary 2 : IO_signdate/2016-12-21 14:58:50 [Logging Date Time: 2016-12-21 14:59:05,465] ===================================================================================== SQL Command - DataXmlToDictionary : IO_signtime [Logging Date Time: 2016-12-21 14:59:05,465] ===================================================================================== SQL Command - DataXmlToDictionary : 1 [Logging Date Time: 2016-12-21 14:59:05,465] ===================================================================================== SQL Command - DataXmlToDictionary 2 : IO_signtime/2016-12-21 14:58:50 [Logging Date Time: 2016-12-21 14:59:05,465] ===================================================================================== SQL Command - DataXmlToDictionary : O_Ptname_write [Logging Date Time: 2016-12-21 14:59:05,465] ===================================================================================== SQL Command - DataXmlToDictionary : 1 [Logging Date Time: 2016-12-21 14:59:05,465] ===================================================================================== SQL Command - DataXmlToDictionary 2 : O_Ptname_write/ [Logging Date Time: 2016-12-21 14:59:05,465] ===================================================================================== SQL Command - DataXmlToDictionary : O_Ptsign [Logging Date Time: 2016-12-21 14:59:05,465] ===================================================================================== SQL Command - DataXmlToDictionary : 1 [Logging Date Time: 2016-12-21 14:59:05,466] ===================================================================================== SQL Command - DataXmlToDictionary 2 : O_Ptsign/ [Logging Date Time: 2016-12-21 14:59:05,466] ===================================================================================== SQL Command - DataXmlToDictionary : O_JuminNo [Logging Date Time: 2016-12-21 14:59:05,466] ===================================================================================== SQL Command - DataXmlToDictionary : 1 [Logging Date Time: 2016-12-21 14:59:05,466] ===================================================================================== SQL Command - DataXmlToDictionary 2 : O_JuminNo/440505 [Logging Date Time: 2016-12-21 14:59:05,466] ===================================================================================== SQL Command - DataXmlToDictionary : IO_INPUTNM [Logging Date Time: 2016-12-21 14:59:05,466] ===================================================================================== SQL Command - DataXmlToDictionary : 1 [Logging Date Time: 2016-12-21 14:59:05,466] ===================================================================================== SQL Command - DataXmlToDictionary 2 : IO_INPUTNM/¹ÚÁ¾ÈÆ [Logging Date Time: 2016-12-21 14:59:05,466] ===================================================================================== SQL Command - DataXmlToDictionary : O_Verbal [Logging Date Time: 2016-12-21 14:59:05,466] ===================================================================================== SQL Command - DataXmlToDictionary : 1 [Logging Date Time: 2016-12-21 14:59:05,466] ===================================================================================== SQL Command - DataXmlToDictionary 2 : O_Verbal/ [Logging Date Time: 2016-12-21 14:59:05,466] ===================================================================================== SQL Command - DataXmlToDictionary : IO_verbal [Logging Date Time: 2016-12-21 14:59:05,466] ===================================================================================== SQL Command - DataXmlToDictionary : 1 [Logging Date Time: 2016-12-21 14:59:05,466] ===================================================================================== SQL Command - DataXmlToDictionary 2 : IO_verbal/ [Logging Date Time: 2016-12-21 14:59:05,467] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/Baseword [Logging Date Time: 2016-12-21 14:59:05,467] ===================================================================================== SQL Command - DataXmlToDictionary 1 : Baseword/ [Logging Date Time: 2016-12-21 14:59:05,467] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 0/page-template-data [Logging Date Time: 2016-12-21 14:59:05,467] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 3/pen-drawing [Logging Date Time: 2016-12-21 14:59:05,467] ===================================================================================== SQL Command - DataXmlToDictionary : page [Logging Date Time: 2016-12-21 14:59:05,467] ===================================================================================== SQL Command - DataXmlToDictionary : 0 [Logging Date Time: 2016-12-21 14:59:05,467] ===================================================================================== SQL Command - DataXmlToDictionary : page [Logging Date Time: 2016-12-21 14:59:05,467] ===================================================================================== SQL Command - DataXmlToDictionary : 0 [Logging Date Time: 2016-12-21 14:59:05,467] ===================================================================================== SQL Command - DataXmlToDictionary : page [Logging Date Time: 2016-12-21 14:59:05,467] ===================================================================================== SQL Command - DataXmlToDictionary : 0 [Logging Date Time: 2016-12-21 14:59:05,467] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 4/changed-form [Logging Date Time: 2016-12-21 14:59:05,467] ===================================================================================== SQL Command - DataXmlToDictionary : attach-page [Logging Date Time: 2016-12-21 14:59:05,468] ===================================================================================== SQL Command - DataXmlToDictionary : 2 [Logging Date Time: 2016-12-21 14:59:05,468] ===================================================================================== SQL Command - DataXmlToDictionary : pagetemplates [Logging Date Time: 2016-12-21 14:59:05,468] ===================================================================================== SQL Command - DataXmlToDictionary : 0 [Logging Date Time: 2016-12-21 14:59:05,468] ===================================================================================== SQL Command - DataXmlToDictionary : externalgroups [Logging Date Time: 2016-12-21 14:59:05,468] ===================================================================================== SQL Command - DataXmlToDictionary : 6 [Logging Date Time: 2016-12-21 14:59:05,468] ===================================================================================== SQL Command - DataXmlToDictionary : changed [Logging Date Time: 2016-12-21 14:59:05,468] ===================================================================================== SQL Command - DataXmlToDictionary : 0 [Logging Date Time: 2016-12-21 14:59:05,468] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 0/viewer-info [Logging Date Time: 2016-12-21 14:59:05,468] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 0/form-info [Logging Date Time: 2016-12-21 14:59:05,469] ===================================================================================== SQL Command - Statement Id: [SET_MEDI_HISTORY] PreparedStatement : [DECLARE v_cnt NUMBER:=0; BEGIN SELECT COUNT(*) INTO V_CNT FROM CONSENT_DATA_EX WHERE PID = :param0 AND CLN_DATE = :param1 ; IF v_cnt = 0 THEN insert into consent_data_ex (pid, cln_date, use_yn, bp, dm, heart, kidney, respiration, hx, allergy, drug, smoking, idio, nacrotics, airway, hemorrhage, etc, create_user_id, create_datetime, modify_user_id, modify_datetime) values ( :param0 , :param1 ,'Y', :param2 , :param3 , :param4 , :param5 , :param6 , :param7 , :param8 , :param9 , :param10 , :param11 , :param12 , :param13 , :param14 , :param15 , :param16 , TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'), :param16 , TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss')); ELSE update consent_data_ex set bp = :param2 , dm = :param3 , heart = :param4 , kidney = :param5 , respiration = :param6 , hx = :param7 , allergy = :param8 , drug = :param9 , smoking = :param10 , idio = :param11 , nacrotics = :param12 , airway = :param13 , hemorrhage = :param14 , etc = :param15 , modify_user_id = :param16 , modify_datetime = TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss') where PID = :param0 AND CLN_DATE = :param1 ; END IF; END;] [Logging Date Time: 2016-12-21 14:59:05,469] ===================================================================================== SQL Command - Statement Id: [SET_MEDI_HISTORY] PreparedStatement : [DECLARE v_cnt NUMBER:=0; BEGIN SELECT COUNT(*) INTO V_CNT FROM CONSENT_DATA_EX WHERE PID = :param0 AND CLN_DATE = :param1 ; IF v_cnt = 0 THEN insert into consent_data_ex (pid, cln_date, use_yn, bp, dm, heart, kidney, respiration, hx, allergy, drug, smoking, idio, nacrotics, airway, hemorrhage, etc, create_user_id, create_datetime, modify_user_id, modify_datetime) values ( :param0 , :param1 ,'Y', :param2 , :param3 , :param4 , :param5 , :param6 , :param7 , :param8 , :param9 , :param10 , :param11 , :param12 , :param13 , :param14 , :param15 , :param16 , TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'), :param16 , TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss')); ELSE update consent_data_ex set bp = :param2 , dm = :param3 , heart = :param4 , kidney = :param5 , respiration = :param6 , hx = :param7 , allergy = :param8 , drug = :param9 , smoking = :param10 , idio = :param11 , nacrotics = :param12 , airway = :param13 , hemorrhage = :param14 , etc = :param15 , modify_user_id = :param16 , modify_datetime = TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss') where PID = :param0 AND CLN_DATE = :param1 ; END IF; END;] [Logging Date Time: 2016-12-21 14:59:05,470] ===================================================================================== SQL Command - Statement Id: [SET_MEDI_HISTORY] Parameters: [param0=[patientCode,0957205], param1=[clnDate,20161209], param2=[bp,], param3=[dm,], param4=[heart,], param5=[kidney,], param6=[respiration,], param7=[hx,], param8=[allergy,], param9=[drug,], param10=[smoking,], param11=[idio,], param12=[nacrotics,], param13=[airway,], param14=[hemorrhage,], param15=[status_etc,], param16=[userId,104876]] [Logging Date Time: 2016-12-21 14:59:05,470] ===================================================================================== SQL Command - Statement Id: [SET_MEDI_HISTORY] Parameters: [param0=[patientCode,0957205], param1=[clnDate,20161209], param2=[bp,], param3=[dm,], param4=[heart,], param5=[kidney,], param6=[respiration,], param7=[hx,], param8=[allergy,], param9=[drug,], param10=[smoking,], param11=[idio,], param12=[nacrotics,], param13=[airway,], param14=[hemorrhage,], param15=[status_etc,], param16=[userId,104876]]