[Logging Date Time: 2016-10-21 18:56:16,610] ===================================================================================== SQL Command - Statement Id: [getPatientInfoIn] Parameters: [param0=[ordtype,I], param1=[instcd,111], param2=[pid,0764061], param3=[orddd,20161021], param4=[cretno,1]] [Logging Date Time: 2016-10-21 18:56:16,610] ===================================================================================== SQL Command - Statement Id: [getPatientInfoIn] Parameters: [param0=[ordtype,I], param1=[instcd,111], param2=[pid,0764061], param3=[orddd,20161021], param4=[cretno,1]] [Logging Date Time: 2016-10-21 18:56:16,781] ===================================================================================== 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-10-21 18:56:16,781] ===================================================================================== 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-10-21 18:56:16,888] ===================================================================================== SQL Command - Statement Id: [getPatientInfoIn] PreparedStatement : [SELECT a.orddeptcd, a.pid as IO_Pt_ID, to_char(a.cretno) as IO_CretNo, (select ptbs.sex || '/' || com.fn_zz_getageas(ptbs.rrgstno1, ptbs.rrgstno2, TO_CHAR(SYSDATE, 'YYYYMMDD'), 'A', ptbs.brthdd) from pam.pmcmptbs ptbs where ptbs.instcd = a.instcd and ptbs.pid = a.pid) as IO_sex_age_y_m, (select ptbs.hngnm from pam.pmcmptbs ptbs where ptbs.instcd = a.instcd and ptbs.pid = a.pid) as IO_Pt_Name, (select ptbs.rrgstno1 || '-' || substr(ptbs.rrgstno2, 1, 1) || '******' from pam.pmcmptbs ptbs where ptbs.instcd = a.instcd and ptbs.pid = a.pid) IO_JuminNo, (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, oprs.perfdeptcd AS IO_OPdeptCd, COM.FN_ZS_GETDEPTNAME(a.instcd, oprs.perfdeptcd, a.indd) AS IO_OPdeptNm, COM.FN_ZS_GETUSERNM(oprs.perfdrid, a.indd) AS IO_OPdrNm, oprs.perfdrid 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 = :param0 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 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 = :param0 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 group by pid)) as IO_DxNm, a.MEDISPCLID as IO_MaindrId, COM.FN_ZS_GETUSERNM(a.MEDISPCLID, a.indd) as IO_MaindrNm, '111' as IO_HosType, case when ex.bp is null then '02' else ex.bp end as IO_bp, case when ex.dm is null then '02' else ex.dm end as IO_dm, case when ex.heart is null then '02' else ex.heart end as IO_heart, case when ex.kidney is null then '02' else ex.kidney end as IO_kidney, case when ex.respiration is null then '02' else ex.respiration end as IO_respiration, case when ex.hx is null then '02' else ex.hx end as IO_hx, case when ex.allergy is null then '02' else ex.allergy end as IO_allergy, case when ex.drug is null then '02' else ex.drug end as IO_drug, case when ex.smoking is null then '02' else ex.smoking end as IO_smoking, case when ex.idio is null then '02' else ex.idio end as IO_idio, case when ex.nacrotics is null then '02' else ex.nacrotics end as IO_nacrotics, case when ex.airway is null then '02' else ex.airway end as IO_airway, case when ex.hemorrhage is null then '02' else ex.hemorrhage end as IO_hemorrhage, ex.etc IO_status_etc, '111' as IO_OrderNo, '111' as IO_PrintTime, '111' as IO_MaindrId, '111' 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 emr.mmohoprs oprs on (oprs.pid = a.pid and oprs.ophistcd = 'O' and opcnfmdd >= a.indd ) left outer join cmr.consent_data_ex ex on (ex.pid = a.pid and ex.cln_date = a.indd) WHERE a.instcd = :param1 AND a.pid = :param2 AND a.indd = :param3 AND a.histstat = 'Y' AND a.mskind = 'M' AND a.cretno = :param4 order by a.fstrgstdt desc] [Logging Date Time: 2016-10-21 18:56:16,888] ===================================================================================== SQL Command - Statement Id: [getPatientInfoIn] PreparedStatement : [SELECT a.orddeptcd, a.pid as IO_Pt_ID, to_char(a.cretno) as IO_CretNo, (select ptbs.sex || '/' || com.fn_zz_getageas(ptbs.rrgstno1, ptbs.rrgstno2, TO_CHAR(SYSDATE, 'YYYYMMDD'), 'A', ptbs.brthdd) from pam.pmcmptbs ptbs where ptbs.instcd = a.instcd and ptbs.pid = a.pid) as IO_sex_age_y_m, (select ptbs.hngnm from pam.pmcmptbs ptbs where ptbs.instcd = a.instcd and ptbs.pid = a.pid) as IO_Pt_Name, (select ptbs.rrgstno1 || '-' || substr(ptbs.rrgstno2, 1, 1) || '******' from pam.pmcmptbs ptbs where ptbs.instcd = a.instcd and ptbs.pid = a.pid) IO_JuminNo, (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, oprs.perfdeptcd AS IO_OPdeptCd, COM.FN_ZS_GETDEPTNAME(a.instcd, oprs.perfdeptcd, a.indd) AS IO_OPdeptNm, COM.FN_ZS_GETUSERNM(oprs.perfdrid, a.indd) AS IO_OPdrNm, oprs.perfdrid 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 = :param0 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 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 = :param0 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 group by pid)) as IO_DxNm, a.MEDISPCLID as IO_MaindrId, COM.FN_ZS_GETUSERNM(a.MEDISPCLID, a.indd) as IO_MaindrNm, '111' as IO_HosType, case when ex.bp is null then '02' else ex.bp end as IO_bp, case when ex.dm is null then '02' else ex.dm end as IO_dm, case when ex.heart is null then '02' else ex.heart end as IO_heart, case when ex.kidney is null then '02' else ex.kidney end as IO_kidney, case when ex.respiration is null then '02' else ex.respiration end as IO_respiration, case when ex.hx is null then '02' else ex.hx end as IO_hx, case when ex.allergy is null then '02' else ex.allergy end as IO_allergy, case when ex.drug is null then '02' else ex.drug end as IO_drug, case when ex.smoking is null then '02' else ex.smoking end as IO_smoking, case when ex.idio is null then '02' else ex.idio end as IO_idio, case when ex.nacrotics is null then '02' else ex.nacrotics end as IO_nacrotics, case when ex.airway is null then '02' else ex.airway end as IO_airway, case when ex.hemorrhage is null then '02' else ex.hemorrhage end as IO_hemorrhage, ex.etc IO_status_etc, '111' as IO_OrderNo, '111' as IO_PrintTime, '111' as IO_MaindrId, '111' 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 emr.mmohoprs oprs on (oprs.pid = a.pid and oprs.ophistcd = 'O' and opcnfmdd >= a.indd ) left outer join cmr.consent_data_ex ex on (ex.pid = a.pid and ex.cln_date = a.indd) WHERE a.instcd = :param1 AND a.pid = :param2 AND a.indd = :param3 AND a.histstat = 'Y' AND a.mskind = 'M' AND a.cretno = :param4 order by a.fstrgstdt desc] [Logging Date Time: 2016-10-21 18:56:16,888] ===================================================================================== SQL Command - Statement Id: [getPatientInfoIn] Parameters: [param0=[ordtype,I], param1=[instcd,111], param2=[pid,0764061], param3=[orddd,20161021], param4=[cretno,1]] [Logging Date Time: 2016-10-21 18:56:16,888] ===================================================================================== SQL Command - Statement Id: [getPatientInfoIn] Parameters: [param0=[ordtype,I], param1=[instcd,111], param2=[pid,0764061], param3=[orddd,20161021], param4=[cretno,1]] [Logging Date Time: 2016-10-21 18:56:16,888] ===================================================================================== 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-10-21 18:56:16,888] ===================================================================================== 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-10-21 18:56:17,449] ===================================================================================== 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', CM.WARDCD, :param0 ) as WARDCD , CM.ROOMCD , CM.FORM_RID , VEF.FORM_CD , VEF.FORM_GUID , C.PRNTCNT , CM.CONSENT_STATE , CM.OCR_NUMBER , CM.COSIGN_DC_ID , CM.COSIGN_DC_NAME , CM.CREATE_USER_ID , CM.CREATE_USER_NAME , CM.CREATE_DATETIME , CM.CLN_DATE , CM.CRETNO 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 = :param1 AND TO_CHAR(TO_DATE(CM.CREATE_DATETIME, 'YYYY-MM-DD HH24:MI:SS'), 'YYYYMMDD') BETWEEN :param2 and :param0 AND VEF.FORM_CD = C.FORMCD AND C.instcd = '111' AND C.formprogflag LIKE 'OCR%' AND C.formlevlcd != '-' AND SUBSTR (C.formtodt, 1, 8) = '99991231' AND CM.CONSENT_STATE IN ('UNFINISHED','TEMP') ORDER BY CM.CONSENT_STATE DESC, CM.CREATE_DATETIME DESC] [Logging Date Time: 2016-10-21 18:56:17,449] ===================================================================================== 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', CM.WARDCD, :param0 ) as WARDCD , CM.ROOMCD , CM.FORM_RID , VEF.FORM_CD , VEF.FORM_GUID , C.PRNTCNT , CM.CONSENT_STATE , CM.OCR_NUMBER , CM.COSIGN_DC_ID , CM.COSIGN_DC_NAME , CM.CREATE_USER_ID , CM.CREATE_USER_NAME , CM.CREATE_DATETIME , CM.CLN_DATE , CM.CRETNO 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 = :param1 AND TO_CHAR(TO_DATE(CM.CREATE_DATETIME, 'YYYY-MM-DD HH24:MI:SS'), 'YYYYMMDD') BETWEEN :param2 and :param0 AND VEF.FORM_CD = C.FORMCD AND C.instcd = '111' AND C.formprogflag LIKE 'OCR%' AND C.formlevlcd != '-' AND SUBSTR (C.formtodt, 1, 8) = '99991231' AND CM.CONSENT_STATE IN ('UNFINISHED','TEMP') ORDER BY CM.CONSENT_STATE DESC, CM.CREATE_DATETIME DESC] [Logging Date Time: 2016-10-21 18:56:17,449] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_LIST] Parameters: [param0=[endDt,20161021], param1=[patientCode,0764061], param2=[startDt,20010601]] [Logging Date Time: 2016-10-21 18:56:17,449] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_LIST] Parameters: [param0=[endDt,20161021], param1=[patientCode,0764061], param2=[startDt,20010601]] [Logging Date Time: 2016-10-21 18:56:17,450] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_LIST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]] [Logging Date Time: 2016-10-21 18:56:17,450] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_LIST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]] [Logging Date Time: 2016-10-21 18:56:17,560] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] PreparedStatement : [SELECT signdata FROM emr.mrfmsignimge WHERE userid = :param0 and repryn = 'Y'] [Logging Date Time: 2016-10-21 18:56:17,560] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] PreparedStatement : [SELECT signdata FROM emr.mrfmsignimge WHERE userid = :param0 and repryn = 'Y'] [Logging Date Time: 2016-10-21 18:56:17,560] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] Parameters: [param0=[userid,104806]] [Logging Date Time: 2016-10-21 18:56:17,560] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] Parameters: [param0=[userid,104806]] [Logging Date Time: 2016-10-21 18:56:17,560] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-10-21 18:56:17,560] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-10-21 18:56:27,632] ===================================================================================== 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-10-21 18:56:27,632] ===================================================================================== 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-10-21 18:56:27,635] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Parameters: [param0=[sub_cd,CONSENT_DATA]] [Logging Date Time: 2016-10-21 18:56:27,635] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Parameters: [param0=[sub_cd,CONSENT_DATA]] [Logging Date Time: 2016-10-21 18:56:27,635] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-10-21 18:56:27,635] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-10-21 18:56:27,662] ===================================================================================== 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-10-21 18:56:27,662] ===================================================================================== 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-10-21 18:56:27,663] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Parameters: [param0=[ud1_num,737], param1=[sub_cd,CONSENT_DATA]] [Logging Date Time: 2016-10-21 18:56:27,663] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Parameters: [param0=[ud1_num,737], param1=[sub_cd,CONSENT_DATA]] [Logging Date Time: 2016-10-21 18:56:27,663] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String]] [Logging Date Time: 2016-10-21 18:56:27,663] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String]] [Logging Date Time: 2016-10-21 18:56:27,668] ===================================================================================== SQL Command - Statement Id: [UPDATE_CONSENT_MST] PreparedStatement : [UPDATE CONSENT_MST SET CONSENT_STATE = :param0 , COMPLETE_YN = :param1 , COMPLETE_DATETIME = '', PAPER_YN = :param2 , MODIFY_USER_ID = :param3 , MODIFY_DATETIME = TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'), MODIFY_USER_NAME = COM.FN_ZS_GETUSERNM( :param3 , TO_CHAR(SYSDATE, 'YYYYMMDD')) WHERE CONSENT_MST_RID = :param4] [Logging Date Time: 2016-10-21 18:56:27,668] ===================================================================================== SQL Command - Statement Id: [UPDATE_CONSENT_MST] PreparedStatement : [UPDATE CONSENT_MST SET CONSENT_STATE = :param0 , COMPLETE_YN = :param1 , COMPLETE_DATETIME = '', PAPER_YN = :param2 , MODIFY_USER_ID = :param3 , MODIFY_DATETIME = TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'), MODIFY_USER_NAME = COM.FN_ZS_GETUSERNM( :param3 , TO_CHAR(SYSDATE, 'YYYYMMDD')) WHERE CONSENT_MST_RID = :param4] [Logging Date Time: 2016-10-21 18:56:27,669] ===================================================================================== SQL Command - Statement Id: [UPDATE_CONSENT_MST] Parameters: [param0=[consentState,PAPER_OUT], param1=[completeYn,N], param2=[paperYn,Y], param3=[userId,104806], param4=[consentMstRid,797]] [Logging Date Time: 2016-10-21 18:56:27,669] ===================================================================================== SQL Command - Statement Id: [UPDATE_CONSENT_MST] Parameters: [param0=[consentState,PAPER_OUT], param1=[completeYn,N], param2=[paperYn,Y], param3=[userId,104806], param4=[consentMstRid,797]] [Logging Date Time: 2016-10-21 18:56:27,669] ===================================================================================== SQL Command - Statement Id: [UPDATE_CONSENT_MST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[Int32, System.Int32]] [Logging Date Time: 2016-10-21 18:56:27,669] ===================================================================================== SQL Command - Statement Id: [UPDATE_CONSENT_MST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[Int32, System.Int32]] [Logging Date Time: 2016-10-21 18:56:27,734] ===================================================================================== 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', CM.WARDCD, :param0 ) as WARDCD , CM.ROOMCD , CM.FORM_RID , VEF.FORM_CD , VEF.FORM_GUID , C.PRNTCNT , CM.CONSENT_STATE , CM.OCR_NUMBER , CM.COSIGN_DC_ID , CM.COSIGN_DC_NAME , CM.CREATE_USER_ID , CM.CREATE_USER_NAME , CM.CREATE_DATETIME , CM.CLN_DATE , CM.CRETNO 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 = :param1 AND TO_CHAR(TO_DATE(CM.CREATE_DATETIME, 'YYYY-MM-DD HH24:MI:SS'), 'YYYYMMDD') BETWEEN :param2 and :param0 AND VEF.FORM_CD = C.FORMCD AND C.instcd = '111' AND C.formprogflag LIKE 'OCR%' AND C.formlevlcd != '-' AND SUBSTR (C.formtodt, 1, 8) = '99991231' AND CM.CONSENT_STATE IN ('UNFINISHED','TEMP') ORDER BY CM.CONSENT_STATE DESC, CM.CREATE_DATETIME DESC] [Logging Date Time: 2016-10-21 18:56:27,734] ===================================================================================== 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', CM.WARDCD, :param0 ) as WARDCD , CM.ROOMCD , CM.FORM_RID , VEF.FORM_CD , VEF.FORM_GUID , C.PRNTCNT , CM.CONSENT_STATE , CM.OCR_NUMBER , CM.COSIGN_DC_ID , CM.COSIGN_DC_NAME , CM.CREATE_USER_ID , CM.CREATE_USER_NAME , CM.CREATE_DATETIME , CM.CLN_DATE , CM.CRETNO 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 = :param1 AND TO_CHAR(TO_DATE(CM.CREATE_DATETIME, 'YYYY-MM-DD HH24:MI:SS'), 'YYYYMMDD') BETWEEN :param2 and :param0 AND VEF.FORM_CD = C.FORMCD AND C.instcd = '111' AND C.formprogflag LIKE 'OCR%' AND C.formlevlcd != '-' AND SUBSTR (C.formtodt, 1, 8) = '99991231' AND CM.CONSENT_STATE IN ('UNFINISHED','TEMP') ORDER BY CM.CONSENT_STATE DESC, CM.CREATE_DATETIME DESC] [Logging Date Time: 2016-10-21 18:56:27,735] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_LIST] Parameters: [param0=[endDt,20161021], param1=[patientCode,0764061], param2=[startDt,20010601]] [Logging Date Time: 2016-10-21 18:56:27,735] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_LIST] Parameters: [param0=[endDt,20161021], param1=[patientCode,0764061], param2=[startDt,20010601]] [Logging Date Time: 2016-10-21 18:56:27,735] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_LIST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]] [Logging Date Time: 2016-10-21 18:56:27,735] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_LIST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]] [Logging Date Time: 2016-10-21 18:56:27,808] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] PreparedStatement : [SELECT signdata FROM emr.mrfmsignimge WHERE userid = :param0 and repryn = 'Y'] [Logging Date Time: 2016-10-21 18:56:27,808] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] PreparedStatement : [SELECT signdata FROM emr.mrfmsignimge WHERE userid = :param0 and repryn = 'Y'] [Logging Date Time: 2016-10-21 18:56:27,809] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] Parameters: [param0=[userid,104806]] [Logging Date Time: 2016-10-21 18:56:27,809] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] Parameters: [param0=[userid,104806]] [Logging Date Time: 2016-10-21 18:56:27,809] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-10-21 18:56:27,809] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-10-21 18:56:28,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 b.psnworkyn = 'Y' and a.usertodd = '99991231' and b.userid = :param0] [Logging Date Time: 2016-10-21 18:56:28,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 b.psnworkyn = 'Y' and a.usertodd = '99991231' and b.userid = :param0] [Logging Date Time: 2016-10-21 18:56:28,773] ===================================================================================== SQL Command - Statement Id: [GET_USER_INFO] Parameters: [param0=[userid,104806]] [Logging Date Time: 2016-10-21 18:56:28,773] ===================================================================================== SQL Command - Statement Id: [GET_USER_INFO] Parameters: [param0=[userid,104806]] [Logging Date Time: 2016-10-21 18:56:28,773] ===================================================================================== SQL Command - Statement Id: [GET_USER_INFO] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-10-21 18:56:28,773] ===================================================================================== SQL Command - Statement Id: [GET_USER_INFO] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-10-21 18:56:28,828] ===================================================================================== SQL Command - Statement Id: [getPatientInfoIn] PreparedStatement : [SELECT a.orddeptcd, a.pid as IO_Pt_ID, to_char(a.cretno) as IO_CretNo, (select ptbs.sex || '/' || com.fn_zz_getageas(ptbs.rrgstno1, ptbs.rrgstno2, TO_CHAR(SYSDATE, 'YYYYMMDD'), 'A', ptbs.brthdd) from pam.pmcmptbs ptbs where ptbs.instcd = a.instcd and ptbs.pid = a.pid) as IO_sex_age_y_m, (select ptbs.hngnm from pam.pmcmptbs ptbs where ptbs.instcd = a.instcd and ptbs.pid = a.pid) as IO_Pt_Name, (select ptbs.rrgstno1 || '-' || substr(ptbs.rrgstno2, 1, 1) || '******' from pam.pmcmptbs ptbs where ptbs.instcd = a.instcd and ptbs.pid = a.pid) IO_JuminNo, (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, oprs.perfdeptcd AS IO_OPdeptCd, COM.FN_ZS_GETDEPTNAME(a.instcd, oprs.perfdeptcd, a.indd) AS IO_OPdeptNm, COM.FN_ZS_GETUSERNM(oprs.perfdrid, a.indd) AS IO_OPdrNm, oprs.perfdrid 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 = :param0 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 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 = :param0 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 group by pid)) as IO_DxNm, a.MEDISPCLID as IO_MaindrId, COM.FN_ZS_GETUSERNM(a.MEDISPCLID, a.indd) as IO_MaindrNm, '111' as IO_HosType, case when ex.bp is null then '02' else ex.bp end as IO_bp, case when ex.dm is null then '02' else ex.dm end as IO_dm, case when ex.heart is null then '02' else ex.heart end as IO_heart, case when ex.kidney is null then '02' else ex.kidney end as IO_kidney, case when ex.respiration is null then '02' else ex.respiration end as IO_respiration, case when ex.hx is null then '02' else ex.hx end as IO_hx, case when ex.allergy is null then '02' else ex.allergy end as IO_allergy, case when ex.drug is null then '02' else ex.drug end as IO_drug, case when ex.smoking is null then '02' else ex.smoking end as IO_smoking, case when ex.idio is null then '02' else ex.idio end as IO_idio, case when ex.nacrotics is null then '02' else ex.nacrotics end as IO_nacrotics, case when ex.airway is null then '02' else ex.airway end as IO_airway, case when ex.hemorrhage is null then '02' else ex.hemorrhage end as IO_hemorrhage, ex.etc IO_status_etc, '111' as IO_OrderNo, '111' as IO_PrintTime, '111' as IO_MaindrId, '111' 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 emr.mmohoprs oprs on (oprs.pid = a.pid and oprs.ophistcd = 'O' and opcnfmdd >= a.indd ) left outer join cmr.consent_data_ex ex on (ex.pid = a.pid and ex.cln_date = a.indd) WHERE a.instcd = :param1 AND a.pid = :param2 AND a.indd = :param3 AND a.histstat = 'Y' AND a.mskind = 'M' AND a.cretno = :param4 order by a.fstrgstdt desc] [Logging Date Time: 2016-10-21 18:56:28,828] ===================================================================================== SQL Command - Statement Id: [getPatientInfoIn] PreparedStatement : [SELECT a.orddeptcd, a.pid as IO_Pt_ID, to_char(a.cretno) as IO_CretNo, (select ptbs.sex || '/' || com.fn_zz_getageas(ptbs.rrgstno1, ptbs.rrgstno2, TO_CHAR(SYSDATE, 'YYYYMMDD'), 'A', ptbs.brthdd) from pam.pmcmptbs ptbs where ptbs.instcd = a.instcd and ptbs.pid = a.pid) as IO_sex_age_y_m, (select ptbs.hngnm from pam.pmcmptbs ptbs where ptbs.instcd = a.instcd and ptbs.pid = a.pid) as IO_Pt_Name, (select ptbs.rrgstno1 || '-' || substr(ptbs.rrgstno2, 1, 1) || '******' from pam.pmcmptbs ptbs where ptbs.instcd = a.instcd and ptbs.pid = a.pid) IO_JuminNo, (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, oprs.perfdeptcd AS IO_OPdeptCd, COM.FN_ZS_GETDEPTNAME(a.instcd, oprs.perfdeptcd, a.indd) AS IO_OPdeptNm, COM.FN_ZS_GETUSERNM(oprs.perfdrid, a.indd) AS IO_OPdrNm, oprs.perfdrid 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 = :param0 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 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 = :param0 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 group by pid)) as IO_DxNm, a.MEDISPCLID as IO_MaindrId, COM.FN_ZS_GETUSERNM(a.MEDISPCLID, a.indd) as IO_MaindrNm, '111' as IO_HosType, case when ex.bp is null then '02' else ex.bp end as IO_bp, case when ex.dm is null then '02' else ex.dm end as IO_dm, case when ex.heart is null then '02' else ex.heart end as IO_heart, case when ex.kidney is null then '02' else ex.kidney end as IO_kidney, case when ex.respiration is null then '02' else ex.respiration end as IO_respiration, case when ex.hx is null then '02' else ex.hx end as IO_hx, case when ex.allergy is null then '02' else ex.allergy end as IO_allergy, case when ex.drug is null then '02' else ex.drug end as IO_drug, case when ex.smoking is null then '02' else ex.smoking end as IO_smoking, case when ex.idio is null then '02' else ex.idio end as IO_idio, case when ex.nacrotics is null then '02' else ex.nacrotics end as IO_nacrotics, case when ex.airway is null then '02' else ex.airway end as IO_airway, case when ex.hemorrhage is null then '02' else ex.hemorrhage end as IO_hemorrhage, ex.etc IO_status_etc, '111' as IO_OrderNo, '111' as IO_PrintTime, '111' as IO_MaindrId, '111' 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 emr.mmohoprs oprs on (oprs.pid = a.pid and oprs.ophistcd = 'O' and opcnfmdd >= a.indd ) left outer join cmr.consent_data_ex ex on (ex.pid = a.pid and ex.cln_date = a.indd) WHERE a.instcd = :param1 AND a.pid = :param2 AND a.indd = :param3 AND a.histstat = 'Y' AND a.mskind = 'M' AND a.cretno = :param4 order by a.fstrgstdt desc] [Logging Date Time: 2016-10-21 18:56:28,829] ===================================================================================== SQL Command - Statement Id: [getPatientInfoIn] Parameters: [param0=[ordtype,I], param1=[instcd,111], param2=[pid,0764061], param3=[orddd,20161021], param4=[cretno,1]] [Logging Date Time: 2016-10-21 18:56:28,829] ===================================================================================== SQL Command - Statement Id: [getPatientInfoIn] Parameters: [param0=[ordtype,I], param1=[instcd,111], param2=[pid,0764061], param3=[orddd,20161021], param4=[cretno,1]] [Logging Date Time: 2016-10-21 18:56:28,829] ===================================================================================== 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-10-21 18:56:28,829] ===================================================================================== 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-10-21 18:56:28,938] ===================================================================================== SQL Command - Statement Id: [GET_TRMT_DATE_LIST] PreparedStatement : [SELECT 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, inpt.cretno 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' union all SELECT 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, otpt.cretno 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] [Logging Date Time: 2016-10-21 18:56:28,938] ===================================================================================== SQL Command - Statement Id: [GET_TRMT_DATE_LIST] PreparedStatement : [SELECT 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, inpt.cretno 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' union all SELECT 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, otpt.cretno 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] [Logging Date Time: 2016-10-21 18:56:28,938] ===================================================================================== SQL Command - Statement Id: [GET_TRMT_DATE_LIST] Parameters: [param0=[instcd,111], param1=[pid,0764061], param2=[searchClnDate,20161021]] [Logging Date Time: 2016-10-21 18:56:28,938] ===================================================================================== SQL Command - Statement Id: [GET_TRMT_DATE_LIST] Parameters: [param0=[instcd,111], param1=[pid,0764061], param2=[searchClnDate,20161021]] [Logging Date Time: 2016-10-21 18:56:28,938] ===================================================================================== SQL Command - Statement Id: [GET_TRMT_DATE_LIST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]] [Logging Date Time: 2016-10-21 18:56:28,938] ===================================================================================== SQL Command - Statement Id: [GET_TRMT_DATE_LIST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]] [Logging Date Time: 2016-10-21 18:56:28,998] ===================================================================================== SQL Command - Statement Id: [getPatientInfoIn] PreparedStatement : [SELECT a.orddeptcd, a.pid as IO_Pt_ID, to_char(a.cretno) as IO_CretNo, (select ptbs.sex || '/' || com.fn_zz_getageas(ptbs.rrgstno1, ptbs.rrgstno2, TO_CHAR(SYSDATE, 'YYYYMMDD'), 'A', ptbs.brthdd) from pam.pmcmptbs ptbs where ptbs.instcd = a.instcd and ptbs.pid = a.pid) as IO_sex_age_y_m, (select ptbs.hngnm from pam.pmcmptbs ptbs where ptbs.instcd = a.instcd and ptbs.pid = a.pid) as IO_Pt_Name, (select ptbs.rrgstno1 || '-' || substr(ptbs.rrgstno2, 1, 1) || '******' from pam.pmcmptbs ptbs where ptbs.instcd = a.instcd and ptbs.pid = a.pid) IO_JuminNo, (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, oprs.perfdeptcd AS IO_OPdeptCd, COM.FN_ZS_GETDEPTNAME(a.instcd, oprs.perfdeptcd, a.indd) AS IO_OPdeptNm, COM.FN_ZS_GETUSERNM(oprs.perfdrid, a.indd) AS IO_OPdrNm, oprs.perfdrid 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 = :param0 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 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 = :param0 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 group by pid)) as IO_DxNm, a.MEDISPCLID as IO_MaindrId, COM.FN_ZS_GETUSERNM(a.MEDISPCLID, a.indd) as IO_MaindrNm, '111' as IO_HosType, case when ex.bp is null then '02' else ex.bp end as IO_bp, case when ex.dm is null then '02' else ex.dm end as IO_dm, case when ex.heart is null then '02' else ex.heart end as IO_heart, case when ex.kidney is null then '02' else ex.kidney end as IO_kidney, case when ex.respiration is null then '02' else ex.respiration end as IO_respiration, case when ex.hx is null then '02' else ex.hx end as IO_hx, case when ex.allergy is null then '02' else ex.allergy end as IO_allergy, case when ex.drug is null then '02' else ex.drug end as IO_drug, case when ex.smoking is null then '02' else ex.smoking end as IO_smoking, case when ex.idio is null then '02' else ex.idio end as IO_idio, case when ex.nacrotics is null then '02' else ex.nacrotics end as IO_nacrotics, case when ex.airway is null then '02' else ex.airway end as IO_airway, case when ex.hemorrhage is null then '02' else ex.hemorrhage end as IO_hemorrhage, ex.etc IO_status_etc, '111' as IO_OrderNo, '111' as IO_PrintTime, '111' as IO_MaindrId, '111' 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 emr.mmohoprs oprs on (oprs.pid = a.pid and oprs.ophistcd = 'O' and opcnfmdd >= a.indd ) left outer join cmr.consent_data_ex ex on (ex.pid = a.pid and ex.cln_date = a.indd) WHERE a.instcd = :param1 AND a.pid = :param2 AND a.indd = :param3 AND a.histstat = 'Y' AND a.mskind = 'M' AND a.cretno = :param4 order by a.fstrgstdt desc] [Logging Date Time: 2016-10-21 18:56:28,998] ===================================================================================== SQL Command - Statement Id: [getPatientInfoIn] PreparedStatement : [SELECT a.orddeptcd, a.pid as IO_Pt_ID, to_char(a.cretno) as IO_CretNo, (select ptbs.sex || '/' || com.fn_zz_getageas(ptbs.rrgstno1, ptbs.rrgstno2, TO_CHAR(SYSDATE, 'YYYYMMDD'), 'A', ptbs.brthdd) from pam.pmcmptbs ptbs where ptbs.instcd = a.instcd and ptbs.pid = a.pid) as IO_sex_age_y_m, (select ptbs.hngnm from pam.pmcmptbs ptbs where ptbs.instcd = a.instcd and ptbs.pid = a.pid) as IO_Pt_Name, (select ptbs.rrgstno1 || '-' || substr(ptbs.rrgstno2, 1, 1) || '******' from pam.pmcmptbs ptbs where ptbs.instcd = a.instcd and ptbs.pid = a.pid) IO_JuminNo, (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, oprs.perfdeptcd AS IO_OPdeptCd, COM.FN_ZS_GETDEPTNAME(a.instcd, oprs.perfdeptcd, a.indd) AS IO_OPdeptNm, COM.FN_ZS_GETUSERNM(oprs.perfdrid, a.indd) AS IO_OPdrNm, oprs.perfdrid 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 = :param0 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 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 = :param0 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 group by pid)) as IO_DxNm, a.MEDISPCLID as IO_MaindrId, COM.FN_ZS_GETUSERNM(a.MEDISPCLID, a.indd) as IO_MaindrNm, '111' as IO_HosType, case when ex.bp is null then '02' else ex.bp end as IO_bp, case when ex.dm is null then '02' else ex.dm end as IO_dm, case when ex.heart is null then '02' else ex.heart end as IO_heart, case when ex.kidney is null then '02' else ex.kidney end as IO_kidney, case when ex.respiration is null then '02' else ex.respiration end as IO_respiration, case when ex.hx is null then '02' else ex.hx end as IO_hx, case when ex.allergy is null then '02' else ex.allergy end as IO_allergy, case when ex.drug is null then '02' else ex.drug end as IO_drug, case when ex.smoking is null then '02' else ex.smoking end as IO_smoking, case when ex.idio is null then '02' else ex.idio end as IO_idio, case when ex.nacrotics is null then '02' else ex.nacrotics end as IO_nacrotics, case when ex.airway is null then '02' else ex.airway end as IO_airway, case when ex.hemorrhage is null then '02' else ex.hemorrhage end as IO_hemorrhage, ex.etc IO_status_etc, '111' as IO_OrderNo, '111' as IO_PrintTime, '111' as IO_MaindrId, '111' 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 emr.mmohoprs oprs on (oprs.pid = a.pid and oprs.ophistcd = 'O' and opcnfmdd >= a.indd ) left outer join cmr.consent_data_ex ex on (ex.pid = a.pid and ex.cln_date = a.indd) WHERE a.instcd = :param1 AND a.pid = :param2 AND a.indd = :param3 AND a.histstat = 'Y' AND a.mskind = 'M' AND a.cretno = :param4 order by a.fstrgstdt desc] [Logging Date Time: 2016-10-21 18:56:28,999] ===================================================================================== SQL Command - Statement Id: [getPatientInfoIn] Parameters: [param0=[ordtype,I], param1=[instcd,111], param2=[pid,0764061], param3=[orddd,20161021], param4=[cretno,1]] [Logging Date Time: 2016-10-21 18:56:28,999] ===================================================================================== SQL Command - Statement Id: [getPatientInfoIn] Parameters: [param0=[ordtype,I], param1=[instcd,111], param2=[pid,0764061], param3=[orddd,20161021], param4=[cretno,1]] [Logging Date Time: 2016-10-21 18:56:28,999] ===================================================================================== 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-10-21 18:56:28,999] ===================================================================================== 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-10-21 18:56:29,097] ===================================================================================== SQL Command - Statement Id: [getPatientInfoIn] PreparedStatement : [SELECT a.orddeptcd, a.pid as IO_Pt_ID, to_char(a.cretno) as IO_CretNo, (select ptbs.sex || '/' || com.fn_zz_getageas(ptbs.rrgstno1, ptbs.rrgstno2, TO_CHAR(SYSDATE, 'YYYYMMDD'), 'A', ptbs.brthdd) from pam.pmcmptbs ptbs where ptbs.instcd = a.instcd and ptbs.pid = a.pid) as IO_sex_age_y_m, (select ptbs.hngnm from pam.pmcmptbs ptbs where ptbs.instcd = a.instcd and ptbs.pid = a.pid) as IO_Pt_Name, (select ptbs.rrgstno1 || '-' || substr(ptbs.rrgstno2, 1, 1) || '******' from pam.pmcmptbs ptbs where ptbs.instcd = a.instcd and ptbs.pid = a.pid) IO_JuminNo, (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, oprs.perfdeptcd AS IO_OPdeptCd, COM.FN_ZS_GETDEPTNAME(a.instcd, oprs.perfdeptcd, a.indd) AS IO_OPdeptNm, COM.FN_ZS_GETUSERNM(oprs.perfdrid, a.indd) AS IO_OPdrNm, oprs.perfdrid 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 = :param0 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 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 = :param0 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 group by pid)) as IO_DxNm, a.MEDISPCLID as IO_MaindrId, COM.FN_ZS_GETUSERNM(a.MEDISPCLID, a.indd) as IO_MaindrNm, '111' as IO_HosType, case when ex.bp is null then '02' else ex.bp end as IO_bp, case when ex.dm is null then '02' else ex.dm end as IO_dm, case when ex.heart is null then '02' else ex.heart end as IO_heart, case when ex.kidney is null then '02' else ex.kidney end as IO_kidney, case when ex.respiration is null then '02' else ex.respiration end as IO_respiration, case when ex.hx is null then '02' else ex.hx end as IO_hx, case when ex.allergy is null then '02' else ex.allergy end as IO_allergy, case when ex.drug is null then '02' else ex.drug end as IO_drug, case when ex.smoking is null then '02' else ex.smoking end as IO_smoking, case when ex.idio is null then '02' else ex.idio end as IO_idio, case when ex.nacrotics is null then '02' else ex.nacrotics end as IO_nacrotics, case when ex.airway is null then '02' else ex.airway end as IO_airway, case when ex.hemorrhage is null then '02' else ex.hemorrhage end as IO_hemorrhage, ex.etc IO_status_etc, '111' as IO_OrderNo, '111' as IO_PrintTime, '111' as IO_MaindrId, '111' 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 emr.mmohoprs oprs on (oprs.pid = a.pid and oprs.ophistcd = 'O' and opcnfmdd >= a.indd ) left outer join cmr.consent_data_ex ex on (ex.pid = a.pid and ex.cln_date = a.indd) WHERE a.instcd = :param1 AND a.pid = :param2 AND a.indd = :param3 AND a.histstat = 'Y' AND a.mskind = 'M' AND a.cretno = :param4 order by a.fstrgstdt desc] [Logging Date Time: 2016-10-21 18:56:29,097] ===================================================================================== SQL Command - Statement Id: [getPatientInfoIn] PreparedStatement : [SELECT a.orddeptcd, a.pid as IO_Pt_ID, to_char(a.cretno) as IO_CretNo, (select ptbs.sex || '/' || com.fn_zz_getageas(ptbs.rrgstno1, ptbs.rrgstno2, TO_CHAR(SYSDATE, 'YYYYMMDD'), 'A', ptbs.brthdd) from pam.pmcmptbs ptbs where ptbs.instcd = a.instcd and ptbs.pid = a.pid) as IO_sex_age_y_m, (select ptbs.hngnm from pam.pmcmptbs ptbs where ptbs.instcd = a.instcd and ptbs.pid = a.pid) as IO_Pt_Name, (select ptbs.rrgstno1 || '-' || substr(ptbs.rrgstno2, 1, 1) || '******' from pam.pmcmptbs ptbs where ptbs.instcd = a.instcd and ptbs.pid = a.pid) IO_JuminNo, (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, oprs.perfdeptcd AS IO_OPdeptCd, COM.FN_ZS_GETDEPTNAME(a.instcd, oprs.perfdeptcd, a.indd) AS IO_OPdeptNm, COM.FN_ZS_GETUSERNM(oprs.perfdrid, a.indd) AS IO_OPdrNm, oprs.perfdrid 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 = :param0 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 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 = :param0 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 group by pid)) as IO_DxNm, a.MEDISPCLID as IO_MaindrId, COM.FN_ZS_GETUSERNM(a.MEDISPCLID, a.indd) as IO_MaindrNm, '111' as IO_HosType, case when ex.bp is null then '02' else ex.bp end as IO_bp, case when ex.dm is null then '02' else ex.dm end as IO_dm, case when ex.heart is null then '02' else ex.heart end as IO_heart, case when ex.kidney is null then '02' else ex.kidney end as IO_kidney, case when ex.respiration is null then '02' else ex.respiration end as IO_respiration, case when ex.hx is null then '02' else ex.hx end as IO_hx, case when ex.allergy is null then '02' else ex.allergy end as IO_allergy, case when ex.drug is null then '02' else ex.drug end as IO_drug, case when ex.smoking is null then '02' else ex.smoking end as IO_smoking, case when ex.idio is null then '02' else ex.idio end as IO_idio, case when ex.nacrotics is null then '02' else ex.nacrotics end as IO_nacrotics, case when ex.airway is null then '02' else ex.airway end as IO_airway, case when ex.hemorrhage is null then '02' else ex.hemorrhage end as IO_hemorrhage, ex.etc IO_status_etc, '111' as IO_OrderNo, '111' as IO_PrintTime, '111' as IO_MaindrId, '111' 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 emr.mmohoprs oprs on (oprs.pid = a.pid and oprs.ophistcd = 'O' and opcnfmdd >= a.indd ) left outer join cmr.consent_data_ex ex on (ex.pid = a.pid and ex.cln_date = a.indd) WHERE a.instcd = :param1 AND a.pid = :param2 AND a.indd = :param3 AND a.histstat = 'Y' AND a.mskind = 'M' AND a.cretno = :param4 order by a.fstrgstdt desc] [Logging Date Time: 2016-10-21 18:56:29,099] ===================================================================================== SQL Command - Statement Id: [getPatientInfoIn] Parameters: [param0=[ordtype,I], param1=[instcd,111], param2=[pid,0764061], param3=[orddd,20161021], param4=[cretno,1]] [Logging Date Time: 2016-10-21 18:56:29,099] ===================================================================================== SQL Command - Statement Id: [getPatientInfoIn] Parameters: [param0=[ordtype,I], param1=[instcd,111], param2=[pid,0764061], param3=[orddd,20161021], param4=[cretno,1]] [Logging Date Time: 2016-10-21 18:56:29,099] ===================================================================================== 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-10-21 18:56:29,099] ===================================================================================== 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-10-21 18:56:29,347] ===================================================================================== 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', CM.WARDCD, :param0 ) as WARDCD , CM.ROOMCD , CM.FORM_RID , VEF.FORM_CD , VEF.FORM_GUID , C.PRNTCNT , CM.CONSENT_STATE , CM.OCR_NUMBER , CM.COSIGN_DC_ID , CM.COSIGN_DC_NAME , CM.CREATE_USER_ID , CM.CREATE_USER_NAME , CM.CREATE_DATETIME , CM.CLN_DATE , CM.CRETNO 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 = :param1 AND TO_CHAR(TO_DATE(CM.CREATE_DATETIME, 'YYYY-MM-DD HH24:MI:SS'), 'YYYYMMDD') BETWEEN :param2 and :param0 AND VEF.FORM_CD = C.FORMCD AND C.instcd = '111' AND C.formprogflag LIKE 'OCR%' AND C.formlevlcd != '-' AND SUBSTR (C.formtodt, 1, 8) = '99991231' AND CM.CONSENT_STATE IN ('UNFINISHED','TEMP') ORDER BY CM.CONSENT_STATE DESC, CM.CREATE_DATETIME DESC] [Logging Date Time: 2016-10-21 18:56:29,347] ===================================================================================== 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', CM.WARDCD, :param0 ) as WARDCD , CM.ROOMCD , CM.FORM_RID , VEF.FORM_CD , VEF.FORM_GUID , C.PRNTCNT , CM.CONSENT_STATE , CM.OCR_NUMBER , CM.COSIGN_DC_ID , CM.COSIGN_DC_NAME , CM.CREATE_USER_ID , CM.CREATE_USER_NAME , CM.CREATE_DATETIME , CM.CLN_DATE , CM.CRETNO 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 = :param1 AND TO_CHAR(TO_DATE(CM.CREATE_DATETIME, 'YYYY-MM-DD HH24:MI:SS'), 'YYYYMMDD') BETWEEN :param2 and :param0 AND VEF.FORM_CD = C.FORMCD AND C.instcd = '111' AND C.formprogflag LIKE 'OCR%' AND C.formlevlcd != '-' AND SUBSTR (C.formtodt, 1, 8) = '99991231' AND CM.CONSENT_STATE IN ('UNFINISHED','TEMP') ORDER BY CM.CONSENT_STATE DESC, CM.CREATE_DATETIME DESC] [Logging Date Time: 2016-10-21 18:56:29,348] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_LIST] Parameters: [param0=[endDt,20161021], param1=[patientCode,0764061], param2=[startDt,20010601]] [Logging Date Time: 2016-10-21 18:56:29,348] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_LIST] Parameters: [param0=[endDt,20161021], param1=[patientCode,0764061], param2=[startDt,20010601]] [Logging Date Time: 2016-10-21 18:56:29,348] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_LIST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]] [Logging Date Time: 2016-10-21 18:56:29,348] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_LIST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]] [Logging Date Time: 2016-10-21 18:56:29,464] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] PreparedStatement : [SELECT signdata FROM emr.mrfmsignimge WHERE userid = :param0 and repryn = 'Y'] [Logging Date Time: 2016-10-21 18:56:29,464] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] PreparedStatement : [SELECT signdata FROM emr.mrfmsignimge WHERE userid = :param0 and repryn = 'Y'] [Logging Date Time: 2016-10-21 18:56:29,464] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] Parameters: [param0=[userid,104806]] [Logging Date Time: 2016-10-21 18:56:29,464] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] Parameters: [param0=[userid,104806]] [Logging Date Time: 2016-10-21 18:56:29,464] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-10-21 18:56:29,464] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-10-21 18:56:39,971] ===================================================================================== 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-10-21 18:56:39,971] ===================================================================================== 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-10-21 18:56:39,972] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Parameters: [param0=[sub_cd,CONSENT_DATA]] [Logging Date Time: 2016-10-21 18:56:39,972] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Parameters: [param0=[sub_cd,CONSENT_DATA]] [Logging Date Time: 2016-10-21 18:56:39,972] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-10-21 18:56:39,972] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-10-21 18:56:39,974] ===================================================================================== 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-10-21 18:56:39,974] ===================================================================================== 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-10-21 18:56:39,975] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Parameters: [param0=[ud1_num,738], param1=[sub_cd,CONSENT_DATA]] [Logging Date Time: 2016-10-21 18:56:39,975] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Parameters: [param0=[ud1_num,738], param1=[sub_cd,CONSENT_DATA]] [Logging Date Time: 2016-10-21 18:56:39,975] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String]] [Logging Date Time: 2016-10-21 18:56:39,975] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String]] [Logging Date Time: 2016-10-21 18:56:39,977] ===================================================================================== SQL Command - Statement Id: [UPDATE_CONSENT_MST] PreparedStatement : [UPDATE CONSENT_MST SET CONSENT_STATE = :param0 , COMPLETE_YN = :param1 , COMPLETE_DATETIME = '', PAPER_YN = :param2 , MODIFY_USER_ID = :param3 , MODIFY_DATETIME = TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'), MODIFY_USER_NAME = COM.FN_ZS_GETUSERNM( :param3 , TO_CHAR(SYSDATE, 'YYYYMMDD')) WHERE CONSENT_MST_RID = :param4] [Logging Date Time: 2016-10-21 18:56:39,977] ===================================================================================== SQL Command - Statement Id: [UPDATE_CONSENT_MST] PreparedStatement : [UPDATE CONSENT_MST SET CONSENT_STATE = :param0 , COMPLETE_YN = :param1 , COMPLETE_DATETIME = '', PAPER_YN = :param2 , MODIFY_USER_ID = :param3 , MODIFY_DATETIME = TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'), MODIFY_USER_NAME = COM.FN_ZS_GETUSERNM( :param3 , TO_CHAR(SYSDATE, 'YYYYMMDD')) WHERE CONSENT_MST_RID = :param4] [Logging Date Time: 2016-10-21 18:56:39,977] ===================================================================================== SQL Command - Statement Id: [UPDATE_CONSENT_MST] Parameters: [param0=[consentState,PAPER_OUT], param1=[completeYn,N], param2=[paperYn,Y], param3=[userId,104806], param4=[consentMstRid,799]] [Logging Date Time: 2016-10-21 18:56:39,977] ===================================================================================== SQL Command - Statement Id: [UPDATE_CONSENT_MST] Parameters: [param0=[consentState,PAPER_OUT], param1=[completeYn,N], param2=[paperYn,Y], param3=[userId,104806], param4=[consentMstRid,799]] [Logging Date Time: 2016-10-21 18:56:39,977] ===================================================================================== SQL Command - Statement Id: [UPDATE_CONSENT_MST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[Int32, System.Int32]] [Logging Date Time: 2016-10-21 18:56:39,977] ===================================================================================== SQL Command - Statement Id: [UPDATE_CONSENT_MST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[Int32, System.Int32]] [Logging Date Time: 2016-10-21 18:56:40,015] ===================================================================================== 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', CM.WARDCD, :param0 ) as WARDCD , CM.ROOMCD , CM.FORM_RID , VEF.FORM_CD , VEF.FORM_GUID , C.PRNTCNT , CM.CONSENT_STATE , CM.OCR_NUMBER , CM.COSIGN_DC_ID , CM.COSIGN_DC_NAME , CM.CREATE_USER_ID , CM.CREATE_USER_NAME , CM.CREATE_DATETIME , CM.CLN_DATE , CM.CRETNO 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 = :param1 AND TO_CHAR(TO_DATE(CM.CREATE_DATETIME, 'YYYY-MM-DD HH24:MI:SS'), 'YYYYMMDD') BETWEEN :param2 and :param0 AND VEF.FORM_CD = C.FORMCD AND C.instcd = '111' AND C.formprogflag LIKE 'OCR%' AND C.formlevlcd != '-' AND SUBSTR (C.formtodt, 1, 8) = '99991231' AND CM.CONSENT_STATE IN ('UNFINISHED','TEMP') ORDER BY CM.CONSENT_STATE DESC, CM.CREATE_DATETIME DESC] [Logging Date Time: 2016-10-21 18:56:40,015] ===================================================================================== 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', CM.WARDCD, :param0 ) as WARDCD , CM.ROOMCD , CM.FORM_RID , VEF.FORM_CD , VEF.FORM_GUID , C.PRNTCNT , CM.CONSENT_STATE , CM.OCR_NUMBER , CM.COSIGN_DC_ID , CM.COSIGN_DC_NAME , CM.CREATE_USER_ID , CM.CREATE_USER_NAME , CM.CREATE_DATETIME , CM.CLN_DATE , CM.CRETNO 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 = :param1 AND TO_CHAR(TO_DATE(CM.CREATE_DATETIME, 'YYYY-MM-DD HH24:MI:SS'), 'YYYYMMDD') BETWEEN :param2 and :param0 AND VEF.FORM_CD = C.FORMCD AND C.instcd = '111' AND C.formprogflag LIKE 'OCR%' AND C.formlevlcd != '-' AND SUBSTR (C.formtodt, 1, 8) = '99991231' AND CM.CONSENT_STATE IN ('UNFINISHED','TEMP') ORDER BY CM.CONSENT_STATE DESC, CM.CREATE_DATETIME DESC] [Logging Date Time: 2016-10-21 18:56:40,015] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_LIST] Parameters: [param0=[endDt,20161021], param1=[patientCode,0764061], param2=[startDt,20010601]] [Logging Date Time: 2016-10-21 18:56:40,015] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_LIST] Parameters: [param0=[endDt,20161021], param1=[patientCode,0764061], param2=[startDt,20010601]] [Logging Date Time: 2016-10-21 18:56:40,015] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_LIST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]] [Logging Date Time: 2016-10-21 18:56:40,015] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_LIST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]] [Logging Date Time: 2016-10-21 18:56:40,089] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] PreparedStatement : [SELECT signdata FROM emr.mrfmsignimge WHERE userid = :param0 and repryn = 'Y'] [Logging Date Time: 2016-10-21 18:56:40,089] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] PreparedStatement : [SELECT signdata FROM emr.mrfmsignimge WHERE userid = :param0 and repryn = 'Y'] [Logging Date Time: 2016-10-21 18:56:40,090] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] Parameters: [param0=[userid,104806]] [Logging Date Time: 2016-10-21 18:56:40,090] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] Parameters: [param0=[userid,104806]] [Logging Date Time: 2016-10-21 18:56:40,090] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-10-21 18:56:40,090] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-10-21 18:56:41,325] ===================================================================================== 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 b.psnworkyn = 'Y' and a.usertodd = '99991231' and b.userid = :param0] [Logging Date Time: 2016-10-21 18:56:41,325] ===================================================================================== 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 b.psnworkyn = 'Y' and a.usertodd = '99991231' and b.userid = :param0] [Logging Date Time: 2016-10-21 18:56:41,326] ===================================================================================== SQL Command - Statement Id: [GET_USER_INFO] Parameters: [param0=[userid,104806]] [Logging Date Time: 2016-10-21 18:56:41,326] ===================================================================================== SQL Command - Statement Id: [GET_USER_INFO] Parameters: [param0=[userid,104806]] [Logging Date Time: 2016-10-21 18:56:41,326] ===================================================================================== SQL Command - Statement Id: [GET_USER_INFO] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-10-21 18:56:41,326] ===================================================================================== SQL Command - Statement Id: [GET_USER_INFO] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-10-21 18:56:41,400] ===================================================================================== SQL Command - Statement Id: [getPatientInfoIn] PreparedStatement : [SELECT a.orddeptcd, a.pid as IO_Pt_ID, to_char(a.cretno) as IO_CretNo, (select ptbs.sex || '/' || com.fn_zz_getageas(ptbs.rrgstno1, ptbs.rrgstno2, TO_CHAR(SYSDATE, 'YYYYMMDD'), 'A', ptbs.brthdd) from pam.pmcmptbs ptbs where ptbs.instcd = a.instcd and ptbs.pid = a.pid) as IO_sex_age_y_m, (select ptbs.hngnm from pam.pmcmptbs ptbs where ptbs.instcd = a.instcd and ptbs.pid = a.pid) as IO_Pt_Name, (select ptbs.rrgstno1 || '-' || substr(ptbs.rrgstno2, 1, 1) || '******' from pam.pmcmptbs ptbs where ptbs.instcd = a.instcd and ptbs.pid = a.pid) IO_JuminNo, (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, oprs.perfdeptcd AS IO_OPdeptCd, COM.FN_ZS_GETDEPTNAME(a.instcd, oprs.perfdeptcd, a.indd) AS IO_OPdeptNm, COM.FN_ZS_GETUSERNM(oprs.perfdrid, a.indd) AS IO_OPdrNm, oprs.perfdrid 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 = :param0 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 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 = :param0 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 group by pid)) as IO_DxNm, a.MEDISPCLID as IO_MaindrId, COM.FN_ZS_GETUSERNM(a.MEDISPCLID, a.indd) as IO_MaindrNm, '111' as IO_HosType, case when ex.bp is null then '02' else ex.bp end as IO_bp, case when ex.dm is null then '02' else ex.dm end as IO_dm, case when ex.heart is null then '02' else ex.heart end as IO_heart, case when ex.kidney is null then '02' else ex.kidney end as IO_kidney, case when ex.respiration is null then '02' else ex.respiration end as IO_respiration, case when ex.hx is null then '02' else ex.hx end as IO_hx, case when ex.allergy is null then '02' else ex.allergy end as IO_allergy, case when ex.drug is null then '02' else ex.drug end as IO_drug, case when ex.smoking is null then '02' else ex.smoking end as IO_smoking, case when ex.idio is null then '02' else ex.idio end as IO_idio, case when ex.nacrotics is null then '02' else ex.nacrotics end as IO_nacrotics, case when ex.airway is null then '02' else ex.airway end as IO_airway, case when ex.hemorrhage is null then '02' else ex.hemorrhage end as IO_hemorrhage, ex.etc IO_status_etc, '111' as IO_OrderNo, '111' as IO_PrintTime, '111' as IO_MaindrId, '111' 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 emr.mmohoprs oprs on (oprs.pid = a.pid and oprs.ophistcd = 'O' and opcnfmdd >= a.indd ) left outer join cmr.consent_data_ex ex on (ex.pid = a.pid and ex.cln_date = a.indd) WHERE a.instcd = :param1 AND a.pid = :param2 AND a.indd = :param3 AND a.histstat = 'Y' AND a.mskind = 'M' AND a.cretno = :param4 order by a.fstrgstdt desc] [Logging Date Time: 2016-10-21 18:56:41,400] ===================================================================================== SQL Command - Statement Id: [getPatientInfoIn] PreparedStatement : [SELECT a.orddeptcd, a.pid as IO_Pt_ID, to_char(a.cretno) as IO_CretNo, (select ptbs.sex || '/' || com.fn_zz_getageas(ptbs.rrgstno1, ptbs.rrgstno2, TO_CHAR(SYSDATE, 'YYYYMMDD'), 'A', ptbs.brthdd) from pam.pmcmptbs ptbs where ptbs.instcd = a.instcd and ptbs.pid = a.pid) as IO_sex_age_y_m, (select ptbs.hngnm from pam.pmcmptbs ptbs where ptbs.instcd = a.instcd and ptbs.pid = a.pid) as IO_Pt_Name, (select ptbs.rrgstno1 || '-' || substr(ptbs.rrgstno2, 1, 1) || '******' from pam.pmcmptbs ptbs where ptbs.instcd = a.instcd and ptbs.pid = a.pid) IO_JuminNo, (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, oprs.perfdeptcd AS IO_OPdeptCd, COM.FN_ZS_GETDEPTNAME(a.instcd, oprs.perfdeptcd, a.indd) AS IO_OPdeptNm, COM.FN_ZS_GETUSERNM(oprs.perfdrid, a.indd) AS IO_OPdrNm, oprs.perfdrid 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 = :param0 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 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 = :param0 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 group by pid)) as IO_DxNm, a.MEDISPCLID as IO_MaindrId, COM.FN_ZS_GETUSERNM(a.MEDISPCLID, a.indd) as IO_MaindrNm, '111' as IO_HosType, case when ex.bp is null then '02' else ex.bp end as IO_bp, case when ex.dm is null then '02' else ex.dm end as IO_dm, case when ex.heart is null then '02' else ex.heart end as IO_heart, case when ex.kidney is null then '02' else ex.kidney end as IO_kidney, case when ex.respiration is null then '02' else ex.respiration end as IO_respiration, case when ex.hx is null then '02' else ex.hx end as IO_hx, case when ex.allergy is null then '02' else ex.allergy end as IO_allergy, case when ex.drug is null then '02' else ex.drug end as IO_drug, case when ex.smoking is null then '02' else ex.smoking end as IO_smoking, case when ex.idio is null then '02' else ex.idio end as IO_idio, case when ex.nacrotics is null then '02' else ex.nacrotics end as IO_nacrotics, case when ex.airway is null then '02' else ex.airway end as IO_airway, case when ex.hemorrhage is null then '02' else ex.hemorrhage end as IO_hemorrhage, ex.etc IO_status_etc, '111' as IO_OrderNo, '111' as IO_PrintTime, '111' as IO_MaindrId, '111' 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 emr.mmohoprs oprs on (oprs.pid = a.pid and oprs.ophistcd = 'O' and opcnfmdd >= a.indd ) left outer join cmr.consent_data_ex ex on (ex.pid = a.pid and ex.cln_date = a.indd) WHERE a.instcd = :param1 AND a.pid = :param2 AND a.indd = :param3 AND a.histstat = 'Y' AND a.mskind = 'M' AND a.cretno = :param4 order by a.fstrgstdt desc] [Logging Date Time: 2016-10-21 18:56:41,401] ===================================================================================== SQL Command - Statement Id: [getPatientInfoIn] Parameters: [param0=[ordtype,I], param1=[instcd,111], param2=[pid,0764061], param3=[orddd,20161021], param4=[cretno,1]] [Logging Date Time: 2016-10-21 18:56:41,401] ===================================================================================== SQL Command - Statement Id: [getPatientInfoIn] Parameters: [param0=[ordtype,I], param1=[instcd,111], param2=[pid,0764061], param3=[orddd,20161021], param4=[cretno,1]] [Logging Date Time: 2016-10-21 18:56:41,401] ===================================================================================== 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-10-21 18:56:41,401] ===================================================================================== 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-10-21 18:56:41,494] ===================================================================================== SQL Command - Statement Id: [GET_TRMT_DATE_LIST] PreparedStatement : [SELECT 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, inpt.cretno 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' union all SELECT 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, otpt.cretno 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] [Logging Date Time: 2016-10-21 18:56:41,494] ===================================================================================== SQL Command - Statement Id: [GET_TRMT_DATE_LIST] PreparedStatement : [SELECT 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, inpt.cretno 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' union all SELECT 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, otpt.cretno 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] [Logging Date Time: 2016-10-21 18:56:41,494] ===================================================================================== SQL Command - Statement Id: [GET_TRMT_DATE_LIST] Parameters: [param0=[instcd,111], param1=[pid,0764061], param2=[searchClnDate,20161021]] [Logging Date Time: 2016-10-21 18:56:41,494] ===================================================================================== SQL Command - Statement Id: [GET_TRMT_DATE_LIST] Parameters: [param0=[instcd,111], param1=[pid,0764061], param2=[searchClnDate,20161021]] [Logging Date Time: 2016-10-21 18:56:41,494] ===================================================================================== SQL Command - Statement Id: [GET_TRMT_DATE_LIST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]] [Logging Date Time: 2016-10-21 18:56:41,494] ===================================================================================== SQL Command - Statement Id: [GET_TRMT_DATE_LIST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]] [Logging Date Time: 2016-10-21 18:56:41,556] ===================================================================================== SQL Command - Statement Id: [getPatientInfoIn] PreparedStatement : [SELECT a.orddeptcd, a.pid as IO_Pt_ID, to_char(a.cretno) as IO_CretNo, (select ptbs.sex || '/' || com.fn_zz_getageas(ptbs.rrgstno1, ptbs.rrgstno2, TO_CHAR(SYSDATE, 'YYYYMMDD'), 'A', ptbs.brthdd) from pam.pmcmptbs ptbs where ptbs.instcd = a.instcd and ptbs.pid = a.pid) as IO_sex_age_y_m, (select ptbs.hngnm from pam.pmcmptbs ptbs where ptbs.instcd = a.instcd and ptbs.pid = a.pid) as IO_Pt_Name, (select ptbs.rrgstno1 || '-' || substr(ptbs.rrgstno2, 1, 1) || '******' from pam.pmcmptbs ptbs where ptbs.instcd = a.instcd and ptbs.pid = a.pid) IO_JuminNo, (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, oprs.perfdeptcd AS IO_OPdeptCd, COM.FN_ZS_GETDEPTNAME(a.instcd, oprs.perfdeptcd, a.indd) AS IO_OPdeptNm, COM.FN_ZS_GETUSERNM(oprs.perfdrid, a.indd) AS IO_OPdrNm, oprs.perfdrid 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 = :param0 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 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 = :param0 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 group by pid)) as IO_DxNm, a.MEDISPCLID as IO_MaindrId, COM.FN_ZS_GETUSERNM(a.MEDISPCLID, a.indd) as IO_MaindrNm, '111' as IO_HosType, case when ex.bp is null then '02' else ex.bp end as IO_bp, case when ex.dm is null then '02' else ex.dm end as IO_dm, case when ex.heart is null then '02' else ex.heart end as IO_heart, case when ex.kidney is null then '02' else ex.kidney end as IO_kidney, case when ex.respiration is null then '02' else ex.respiration end as IO_respiration, case when ex.hx is null then '02' else ex.hx end as IO_hx, case when ex.allergy is null then '02' else ex.allergy end as IO_allergy, case when ex.drug is null then '02' else ex.drug end as IO_drug, case when ex.smoking is null then '02' else ex.smoking end as IO_smoking, case when ex.idio is null then '02' else ex.idio end as IO_idio, case when ex.nacrotics is null then '02' else ex.nacrotics end as IO_nacrotics, case when ex.airway is null then '02' else ex.airway end as IO_airway, case when ex.hemorrhage is null then '02' else ex.hemorrhage end as IO_hemorrhage, ex.etc IO_status_etc, '111' as IO_OrderNo, '111' as IO_PrintTime, '111' as IO_MaindrId, '111' 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 emr.mmohoprs oprs on (oprs.pid = a.pid and oprs.ophistcd = 'O' and opcnfmdd >= a.indd ) left outer join cmr.consent_data_ex ex on (ex.pid = a.pid and ex.cln_date = a.indd) WHERE a.instcd = :param1 AND a.pid = :param2 AND a.indd = :param3 AND a.histstat = 'Y' AND a.mskind = 'M' AND a.cretno = :param4 order by a.fstrgstdt desc] [Logging Date Time: 2016-10-21 18:56:41,556] ===================================================================================== SQL Command - Statement Id: [getPatientInfoIn] PreparedStatement : [SELECT a.orddeptcd, a.pid as IO_Pt_ID, to_char(a.cretno) as IO_CretNo, (select ptbs.sex || '/' || com.fn_zz_getageas(ptbs.rrgstno1, ptbs.rrgstno2, TO_CHAR(SYSDATE, 'YYYYMMDD'), 'A', ptbs.brthdd) from pam.pmcmptbs ptbs where ptbs.instcd = a.instcd and ptbs.pid = a.pid) as IO_sex_age_y_m, (select ptbs.hngnm from pam.pmcmptbs ptbs where ptbs.instcd = a.instcd and ptbs.pid = a.pid) as IO_Pt_Name, (select ptbs.rrgstno1 || '-' || substr(ptbs.rrgstno2, 1, 1) || '******' from pam.pmcmptbs ptbs where ptbs.instcd = a.instcd and ptbs.pid = a.pid) IO_JuminNo, (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, oprs.perfdeptcd AS IO_OPdeptCd, COM.FN_ZS_GETDEPTNAME(a.instcd, oprs.perfdeptcd, a.indd) AS IO_OPdeptNm, COM.FN_ZS_GETUSERNM(oprs.perfdrid, a.indd) AS IO_OPdrNm, oprs.perfdrid 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 = :param0 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 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 = :param0 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 group by pid)) as IO_DxNm, a.MEDISPCLID as IO_MaindrId, COM.FN_ZS_GETUSERNM(a.MEDISPCLID, a.indd) as IO_MaindrNm, '111' as IO_HosType, case when ex.bp is null then '02' else ex.bp end as IO_bp, case when ex.dm is null then '02' else ex.dm end as IO_dm, case when ex.heart is null then '02' else ex.heart end as IO_heart, case when ex.kidney is null then '02' else ex.kidney end as IO_kidney, case when ex.respiration is null then '02' else ex.respiration end as IO_respiration, case when ex.hx is null then '02' else ex.hx end as IO_hx, case when ex.allergy is null then '02' else ex.allergy end as IO_allergy, case when ex.drug is null then '02' else ex.drug end as IO_drug, case when ex.smoking is null then '02' else ex.smoking end as IO_smoking, case when ex.idio is null then '02' else ex.idio end as IO_idio, case when ex.nacrotics is null then '02' else ex.nacrotics end as IO_nacrotics, case when ex.airway is null then '02' else ex.airway end as IO_airway, case when ex.hemorrhage is null then '02' else ex.hemorrhage end as IO_hemorrhage, ex.etc IO_status_etc, '111' as IO_OrderNo, '111' as IO_PrintTime, '111' as IO_MaindrId, '111' 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 emr.mmohoprs oprs on (oprs.pid = a.pid and oprs.ophistcd = 'O' and opcnfmdd >= a.indd ) left outer join cmr.consent_data_ex ex on (ex.pid = a.pid and ex.cln_date = a.indd) WHERE a.instcd = :param1 AND a.pid = :param2 AND a.indd = :param3 AND a.histstat = 'Y' AND a.mskind = 'M' AND a.cretno = :param4 order by a.fstrgstdt desc] [Logging Date Time: 2016-10-21 18:56:41,557] ===================================================================================== SQL Command - Statement Id: [getPatientInfoIn] Parameters: [param0=[ordtype,I], param1=[instcd,111], param2=[pid,0764061], param3=[orddd,20161021], param4=[cretno,1]] [Logging Date Time: 2016-10-21 18:56:41,557] ===================================================================================== SQL Command - Statement Id: [getPatientInfoIn] Parameters: [param0=[ordtype,I], param1=[instcd,111], param2=[pid,0764061], param3=[orddd,20161021], param4=[cretno,1]] [Logging Date Time: 2016-10-21 18:56:41,557] ===================================================================================== 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-10-21 18:56:41,557] ===================================================================================== 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-10-21 18:56:41,653] ===================================================================================== SQL Command - Statement Id: [getPatientInfoIn] PreparedStatement : [SELECT a.orddeptcd, a.pid as IO_Pt_ID, to_char(a.cretno) as IO_CretNo, (select ptbs.sex || '/' || com.fn_zz_getageas(ptbs.rrgstno1, ptbs.rrgstno2, TO_CHAR(SYSDATE, 'YYYYMMDD'), 'A', ptbs.brthdd) from pam.pmcmptbs ptbs where ptbs.instcd = a.instcd and ptbs.pid = a.pid) as IO_sex_age_y_m, (select ptbs.hngnm from pam.pmcmptbs ptbs where ptbs.instcd = a.instcd and ptbs.pid = a.pid) as IO_Pt_Name, (select ptbs.rrgstno1 || '-' || substr(ptbs.rrgstno2, 1, 1) || '******' from pam.pmcmptbs ptbs where ptbs.instcd = a.instcd and ptbs.pid = a.pid) IO_JuminNo, (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, oprs.perfdeptcd AS IO_OPdeptCd, COM.FN_ZS_GETDEPTNAME(a.instcd, oprs.perfdeptcd, a.indd) AS IO_OPdeptNm, COM.FN_ZS_GETUSERNM(oprs.perfdrid, a.indd) AS IO_OPdrNm, oprs.perfdrid 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 = :param0 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 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 = :param0 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 group by pid)) as IO_DxNm, a.MEDISPCLID as IO_MaindrId, COM.FN_ZS_GETUSERNM(a.MEDISPCLID, a.indd) as IO_MaindrNm, '111' as IO_HosType, case when ex.bp is null then '02' else ex.bp end as IO_bp, case when ex.dm is null then '02' else ex.dm end as IO_dm, case when ex.heart is null then '02' else ex.heart end as IO_heart, case when ex.kidney is null then '02' else ex.kidney end as IO_kidney, case when ex.respiration is null then '02' else ex.respiration end as IO_respiration, case when ex.hx is null then '02' else ex.hx end as IO_hx, case when ex.allergy is null then '02' else ex.allergy end as IO_allergy, case when ex.drug is null then '02' else ex.drug end as IO_drug, case when ex.smoking is null then '02' else ex.smoking end as IO_smoking, case when ex.idio is null then '02' else ex.idio end as IO_idio, case when ex.nacrotics is null then '02' else ex.nacrotics end as IO_nacrotics, case when ex.airway is null then '02' else ex.airway end as IO_airway, case when ex.hemorrhage is null then '02' else ex.hemorrhage end as IO_hemorrhage, ex.etc IO_status_etc, '111' as IO_OrderNo, '111' as IO_PrintTime, '111' as IO_MaindrId, '111' 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 emr.mmohoprs oprs on (oprs.pid = a.pid and oprs.ophistcd = 'O' and opcnfmdd >= a.indd ) left outer join cmr.consent_data_ex ex on (ex.pid = a.pid and ex.cln_date = a.indd) WHERE a.instcd = :param1 AND a.pid = :param2 AND a.indd = :param3 AND a.histstat = 'Y' AND a.mskind = 'M' AND a.cretno = :param4 order by a.fstrgstdt desc] [Logging Date Time: 2016-10-21 18:56:41,653] ===================================================================================== SQL Command - Statement Id: [getPatientInfoIn] PreparedStatement : [SELECT a.orddeptcd, a.pid as IO_Pt_ID, to_char(a.cretno) as IO_CretNo, (select ptbs.sex || '/' || com.fn_zz_getageas(ptbs.rrgstno1, ptbs.rrgstno2, TO_CHAR(SYSDATE, 'YYYYMMDD'), 'A', ptbs.brthdd) from pam.pmcmptbs ptbs where ptbs.instcd = a.instcd and ptbs.pid = a.pid) as IO_sex_age_y_m, (select ptbs.hngnm from pam.pmcmptbs ptbs where ptbs.instcd = a.instcd and ptbs.pid = a.pid) as IO_Pt_Name, (select ptbs.rrgstno1 || '-' || substr(ptbs.rrgstno2, 1, 1) || '******' from pam.pmcmptbs ptbs where ptbs.instcd = a.instcd and ptbs.pid = a.pid) IO_JuminNo, (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, oprs.perfdeptcd AS IO_OPdeptCd, COM.FN_ZS_GETDEPTNAME(a.instcd, oprs.perfdeptcd, a.indd) AS IO_OPdeptNm, COM.FN_ZS_GETUSERNM(oprs.perfdrid, a.indd) AS IO_OPdrNm, oprs.perfdrid 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 = :param0 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 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 = :param0 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 group by pid)) as IO_DxNm, a.MEDISPCLID as IO_MaindrId, COM.FN_ZS_GETUSERNM(a.MEDISPCLID, a.indd) as IO_MaindrNm, '111' as IO_HosType, case when ex.bp is null then '02' else ex.bp end as IO_bp, case when ex.dm is null then '02' else ex.dm end as IO_dm, case when ex.heart is null then '02' else ex.heart end as IO_heart, case when ex.kidney is null then '02' else ex.kidney end as IO_kidney, case when ex.respiration is null then '02' else ex.respiration end as IO_respiration, case when ex.hx is null then '02' else ex.hx end as IO_hx, case when ex.allergy is null then '02' else ex.allergy end as IO_allergy, case when ex.drug is null then '02' else ex.drug end as IO_drug, case when ex.smoking is null then '02' else ex.smoking end as IO_smoking, case when ex.idio is null then '02' else ex.idio end as IO_idio, case when ex.nacrotics is null then '02' else ex.nacrotics end as IO_nacrotics, case when ex.airway is null then '02' else ex.airway end as IO_airway, case when ex.hemorrhage is null then '02' else ex.hemorrhage end as IO_hemorrhage, ex.etc IO_status_etc, '111' as IO_OrderNo, '111' as IO_PrintTime, '111' as IO_MaindrId, '111' 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 emr.mmohoprs oprs on (oprs.pid = a.pid and oprs.ophistcd = 'O' and opcnfmdd >= a.indd ) left outer join cmr.consent_data_ex ex on (ex.pid = a.pid and ex.cln_date = a.indd) WHERE a.instcd = :param1 AND a.pid = :param2 AND a.indd = :param3 AND a.histstat = 'Y' AND a.mskind = 'M' AND a.cretno = :param4 order by a.fstrgstdt desc] [Logging Date Time: 2016-10-21 18:56:41,654] ===================================================================================== SQL Command - Statement Id: [getPatientInfoIn] Parameters: [param0=[ordtype,I], param1=[instcd,111], param2=[pid,0764061], param3=[orddd,20161021], param4=[cretno,1]] [Logging Date Time: 2016-10-21 18:56:41,654] ===================================================================================== SQL Command - Statement Id: [getPatientInfoIn] Parameters: [param0=[ordtype,I], param1=[instcd,111], param2=[pid,0764061], param3=[orddd,20161021], param4=[cretno,1]] [Logging Date Time: 2016-10-21 18:56:41,654] ===================================================================================== 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-10-21 18:56:41,654] ===================================================================================== 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-10-21 18:56:41,799] ===================================================================================== 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', CM.WARDCD, :param0 ) as WARDCD , CM.ROOMCD , CM.FORM_RID , VEF.FORM_CD , VEF.FORM_GUID , C.PRNTCNT , CM.CONSENT_STATE , CM.OCR_NUMBER , CM.COSIGN_DC_ID , CM.COSIGN_DC_NAME , CM.CREATE_USER_ID , CM.CREATE_USER_NAME , CM.CREATE_DATETIME , CM.CLN_DATE , CM.CRETNO 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 = :param1 AND TO_CHAR(TO_DATE(CM.CREATE_DATETIME, 'YYYY-MM-DD HH24:MI:SS'), 'YYYYMMDD') BETWEEN :param2 and :param0 AND VEF.FORM_CD = C.FORMCD AND C.instcd = '111' AND C.formprogflag LIKE 'OCR%' AND C.formlevlcd != '-' AND SUBSTR (C.formtodt, 1, 8) = '99991231' AND CM.CONSENT_STATE IN ('UNFINISHED','TEMP') ORDER BY CM.CONSENT_STATE DESC, CM.CREATE_DATETIME DESC] [Logging Date Time: 2016-10-21 18:56:41,799] ===================================================================================== 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', CM.WARDCD, :param0 ) as WARDCD , CM.ROOMCD , CM.FORM_RID , VEF.FORM_CD , VEF.FORM_GUID , C.PRNTCNT , CM.CONSENT_STATE , CM.OCR_NUMBER , CM.COSIGN_DC_ID , CM.COSIGN_DC_NAME , CM.CREATE_USER_ID , CM.CREATE_USER_NAME , CM.CREATE_DATETIME , CM.CLN_DATE , CM.CRETNO 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 = :param1 AND TO_CHAR(TO_DATE(CM.CREATE_DATETIME, 'YYYY-MM-DD HH24:MI:SS'), 'YYYYMMDD') BETWEEN :param2 and :param0 AND VEF.FORM_CD = C.FORMCD AND C.instcd = '111' AND C.formprogflag LIKE 'OCR%' AND C.formlevlcd != '-' AND SUBSTR (C.formtodt, 1, 8) = '99991231' AND CM.CONSENT_STATE IN ('UNFINISHED','TEMP') ORDER BY CM.CONSENT_STATE DESC, CM.CREATE_DATETIME DESC] [Logging Date Time: 2016-10-21 18:56:41,799] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_LIST] Parameters: [param0=[endDt,20161021], param1=[patientCode,0764061], param2=[startDt,20010601]] [Logging Date Time: 2016-10-21 18:56:41,799] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_LIST] Parameters: [param0=[endDt,20161021], param1=[patientCode,0764061], param2=[startDt,20010601]] [Logging Date Time: 2016-10-21 18:56:41,799] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_LIST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]] [Logging Date Time: 2016-10-21 18:56:41,799] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_LIST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]] [Logging Date Time: 2016-10-21 18:56:41,903] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] PreparedStatement : [SELECT signdata FROM emr.mrfmsignimge WHERE userid = :param0 and repryn = 'Y'] [Logging Date Time: 2016-10-21 18:56:41,903] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] PreparedStatement : [SELECT signdata FROM emr.mrfmsignimge WHERE userid = :param0 and repryn = 'Y'] [Logging Date Time: 2016-10-21 18:56:41,904] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] Parameters: [param0=[userid,104806]] [Logging Date Time: 2016-10-21 18:56:41,904] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] Parameters: [param0=[userid,104806]] [Logging Date Time: 2016-10-21 18:56:41,904] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-10-21 18:56:41,904] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-10-21 18:56:47,587] ===================================================================================== 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-10-21 18:56:47,587] ===================================================================================== 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-10-21 18:56:47,588] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Parameters: [param0=[sub_cd,CONSENT_DATA]] [Logging Date Time: 2016-10-21 18:56:47,588] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Parameters: [param0=[sub_cd,CONSENT_DATA]] [Logging Date Time: 2016-10-21 18:56:47,589] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-10-21 18:56:47,589] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-10-21 18:56:47,591] ===================================================================================== 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-10-21 18:56:47,591] ===================================================================================== 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-10-21 18:56:47,593] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Parameters: [param0=[ud1_num,739], param1=[sub_cd,CONSENT_DATA]] [Logging Date Time: 2016-10-21 18:56:47,593] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Parameters: [param0=[ud1_num,739], param1=[sub_cd,CONSENT_DATA]] [Logging Date Time: 2016-10-21 18:56:47,593] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String]] [Logging Date Time: 2016-10-21 18:56:47,593] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String]] [Logging Date Time: 2016-10-21 18:56:47,594] ===================================================================================== SQL Command - Statement Id: [UPDATE_CONSENT_MST] PreparedStatement : [UPDATE CONSENT_MST SET CONSENT_STATE = :param0 , COMPLETE_YN = :param1 , COMPLETE_DATETIME = '', PAPER_YN = :param2 , MODIFY_USER_ID = :param3 , MODIFY_DATETIME = TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'), MODIFY_USER_NAME = COM.FN_ZS_GETUSERNM( :param3 , TO_CHAR(SYSDATE, 'YYYYMMDD')) WHERE CONSENT_MST_RID = :param4] [Logging Date Time: 2016-10-21 18:56:47,594] ===================================================================================== SQL Command - Statement Id: [UPDATE_CONSENT_MST] PreparedStatement : [UPDATE CONSENT_MST SET CONSENT_STATE = :param0 , COMPLETE_YN = :param1 , COMPLETE_DATETIME = '', PAPER_YN = :param2 , MODIFY_USER_ID = :param3 , MODIFY_DATETIME = TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'), MODIFY_USER_NAME = COM.FN_ZS_GETUSERNM( :param3 , TO_CHAR(SYSDATE, 'YYYYMMDD')) WHERE CONSENT_MST_RID = :param4] [Logging Date Time: 2016-10-21 18:56:47,595] ===================================================================================== SQL Command - Statement Id: [UPDATE_CONSENT_MST] Parameters: [param0=[consentState,PAPER_OUT], param1=[completeYn,N], param2=[paperYn,Y], param3=[userId,104806], param4=[consentMstRid,801]] [Logging Date Time: 2016-10-21 18:56:47,595] ===================================================================================== SQL Command - Statement Id: [UPDATE_CONSENT_MST] Parameters: [param0=[consentState,PAPER_OUT], param1=[completeYn,N], param2=[paperYn,Y], param3=[userId,104806], param4=[consentMstRid,801]] [Logging Date Time: 2016-10-21 18:56:47,595] ===================================================================================== SQL Command - Statement Id: [UPDATE_CONSENT_MST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[Int32, System.Int32]] [Logging Date Time: 2016-10-21 18:56:47,595] ===================================================================================== SQL Command - Statement Id: [UPDATE_CONSENT_MST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[Int32, System.Int32]] [Logging Date Time: 2016-10-21 18:56:47,644] ===================================================================================== 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', CM.WARDCD, :param0 ) as WARDCD , CM.ROOMCD , CM.FORM_RID , VEF.FORM_CD , VEF.FORM_GUID , C.PRNTCNT , CM.CONSENT_STATE , CM.OCR_NUMBER , CM.COSIGN_DC_ID , CM.COSIGN_DC_NAME , CM.CREATE_USER_ID , CM.CREATE_USER_NAME , CM.CREATE_DATETIME , CM.CLN_DATE , CM.CRETNO 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 = :param1 AND TO_CHAR(TO_DATE(CM.CREATE_DATETIME, 'YYYY-MM-DD HH24:MI:SS'), 'YYYYMMDD') BETWEEN :param2 and :param0 AND VEF.FORM_CD = C.FORMCD AND C.instcd = '111' AND C.formprogflag LIKE 'OCR%' AND C.formlevlcd != '-' AND SUBSTR (C.formtodt, 1, 8) = '99991231' AND CM.CONSENT_STATE IN ('UNFINISHED','TEMP') ORDER BY CM.CONSENT_STATE DESC, CM.CREATE_DATETIME DESC] [Logging Date Time: 2016-10-21 18:56:47,644] ===================================================================================== 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', CM.WARDCD, :param0 ) as WARDCD , CM.ROOMCD , CM.FORM_RID , VEF.FORM_CD , VEF.FORM_GUID , C.PRNTCNT , CM.CONSENT_STATE , CM.OCR_NUMBER , CM.COSIGN_DC_ID , CM.COSIGN_DC_NAME , CM.CREATE_USER_ID , CM.CREATE_USER_NAME , CM.CREATE_DATETIME , CM.CLN_DATE , CM.CRETNO 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 = :param1 AND TO_CHAR(TO_DATE(CM.CREATE_DATETIME, 'YYYY-MM-DD HH24:MI:SS'), 'YYYYMMDD') BETWEEN :param2 and :param0 AND VEF.FORM_CD = C.FORMCD AND C.instcd = '111' AND C.formprogflag LIKE 'OCR%' AND C.formlevlcd != '-' AND SUBSTR (C.formtodt, 1, 8) = '99991231' AND CM.CONSENT_STATE IN ('UNFINISHED','TEMP') ORDER BY CM.CONSENT_STATE DESC, CM.CREATE_DATETIME DESC] [Logging Date Time: 2016-10-21 18:56:47,645] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_LIST] Parameters: [param0=[endDt,20161021], param1=[patientCode,0764061], param2=[startDt,20010601]] [Logging Date Time: 2016-10-21 18:56:47,645] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_LIST] Parameters: [param0=[endDt,20161021], param1=[patientCode,0764061], param2=[startDt,20010601]] [Logging Date Time: 2016-10-21 18:56:47,645] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_LIST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]] [Logging Date Time: 2016-10-21 18:56:47,645] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_LIST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]] [Logging Date Time: 2016-10-21 18:56:47,734] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] PreparedStatement : [SELECT signdata FROM emr.mrfmsignimge WHERE userid = :param0 and repryn = 'Y'] [Logging Date Time: 2016-10-21 18:56:47,734] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] PreparedStatement : [SELECT signdata FROM emr.mrfmsignimge WHERE userid = :param0 and repryn = 'Y'] [Logging Date Time: 2016-10-21 18:56:47,735] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] Parameters: [param0=[userid,104806]] [Logging Date Time: 2016-10-21 18:56:47,735] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] Parameters: [param0=[userid,104806]] [Logging Date Time: 2016-10-21 18:56:47,735] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-10-21 18:56:47,735] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] Types: [param0=[AnsiString, System.String]]