[Logging Date Time: 2016-11-10 13:30:57,963] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_BY_SEARCH_LIST] Parameters: [param0=[category_id,e61d4877-6371-45db-90e2-9de365f6f375], param1=[key_word,%%%%]] [Logging Date Time: 2016-11-10 13:30:58,138] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_BY_SEARCH_LIST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 13:30:58,138] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_BY_SEARCH_LIST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 13:30:59,986] ===================================================================================== SQL Command - Statement Id: [getPatientInfoOut] 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, '' as IO_Ward, '' as IO_roomNO, a.orddd as IO_ADdate, a.orddd as IO_Dschdd, a.ordtype as IO_VisitType, a.orddeptcd as IO_DeptCd, (select dept.deptengabbr from com.zsdddept dept where dept.deptcd = a.orddeptcd and dept.instcd = a.instcd and dept.valitodd >= a.orddd and dept.valifromdd <= a.orddd) as IO_DeptNm, COM.FN_ZS_GETDEPTNAME(a.instcd, a.orddeptcd, a.orddd) AS IO_Dept2, '' AS IO_OPdeptCd, '' AS IO_OPdeptNm, '' AS IO_OPdrNm, '' AS IO_OPdrId, (SELECT diag.diagcd FROM emr.mmohdiag diag WHERE diag.pid = a.pid AND diag.orddd = a.orddd AND diag.cretno = a.cretno AND diag.diaghistcd = 'O' AND diag.diagtypecd = 'D' AND diag.diagkindcdflag = 'M' AND diag.genrflagcd = a.ordtype and diag.orddeptcd = a.orddeptcd AND diag.diaghistno = (select max(diagh.diaghistno) from emr.mmohdiag diagh where diagh.pid = a.pid AND diagh.orddd = a.orddd AND diagh.cretno = a.cretno AND diagh.instcd = '111' AND diagh.diaghistcd = 'O' AND diagh.diagkindcdflag = 'M' AND diagh.genrflagcd = a.ordtype and diagh.orddeptcd = a.orddeptcd group by pid)) as IO_DxCd, (SELECT term.diaghngnm FROM emr.mmohdiag diag, emr.mmbvdiag term WHERE diag.pid = a.pid AND diag.orddd = a.orddd AND diag.cretno = a.cretno AND diag.instcd = term.instcd AND diag.diagcd = term.orgdiagcd AND diag.diaghistcd = 'O' AND diag.diagtypecd = 'D' AND diag.diagkindcdflag = 'M' AND diag.diagdd >= term.termfromdd AND diag.diagdd <= term.termtodd AND diag.diagdd >= term.diagattrfromdd AND diag.diagdd <= term.diagattrtodd AND diag.genrflagcd = a.ordtype and diag.orddeptcd = a.orddeptcd AND diag.diaghistno = (select max(diagh.diaghistno) from emr.mmohdiag diagh where diagh.pid = a.pid AND diagh.orddd = a.orddd AND diagh.cretno = a.cretno AND diagh.instcd = '111' AND diagh.diaghistcd = 'O' AND diagh.diagkindcdflag = 'M' AND diagh.genrflagcd = a.ordtype and diagh.orddeptcd = a.orddeptcd group by pid)) as IO_DxNm, COM.FN_ZS_GETUSERNM(a.orddrid, a.orddd) as IO_MaindrNm, '111' as IO_HosType, case when ex.bp is null then null else ex.bp end as IO_bp, case when ex.dm is null then null else ex.dm end as IO_dm, case when ex.heart is null then null else ex.heart end as IO_heart, case when ex.kidney is null then null else ex.kidney end as IO_kidney, case when ex.respiration is null then null else ex.respiration end as IO_respiration, case when ex.hx is null then null else ex.hx end as IO_hx, case when ex.allergy is null then null else ex.allergy end as IO_allergy, case when ex.drug is null then null else ex.drug end as IO_drug, case when ex.smoking is null then null else ex.smoking end as IO_smoking, case when ex.idio is null then null else ex.idio end as IO_idio, case when ex.nacrotics is null then null else ex.nacrotics end as IO_nacrotics, case when ex.airway is null then null else ex.airway end as IO_airway, case when ex.hemorrhage is null then null else ex.hemorrhage end as IO_hemorrhage, ex.etc IO_status_etc, '111' as IO_OrderNo, '111' as IO_PrintTime, a.ORDDRID as IO_MaindrId, COM.FN_ZS_GETUSERNM(a.ORDDRID, a.orddd) as IO_MaindrNm, '111' as IO_OcrCd, a.ORDDRID as IO_InputId, COM.FN_ZS_GETUSERNM(a.ORDDRID, a.orddd) as IO_InputNm, '111' as IO_SignImg FROM pam.pmohotpt a left outer join cmr.consent_data_ex ex on (ex.pid = a.pid and ex.cln_date = a.orddd) WHERE a.instcd = :param0 AND a.pid = :param1 AND a.orddd = :param2 AND a.cretno = :param3] [Logging Date Time: 2016-11-10 13:30:59,986] ===================================================================================== SQL Command - Statement Id: [getPatientInfoOut] 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, '' as IO_Ward, '' as IO_roomNO, a.orddd as IO_ADdate, a.orddd as IO_Dschdd, a.ordtype as IO_VisitType, a.orddeptcd as IO_DeptCd, (select dept.deptengabbr from com.zsdddept dept where dept.deptcd = a.orddeptcd and dept.instcd = a.instcd and dept.valitodd >= a.orddd and dept.valifromdd <= a.orddd) as IO_DeptNm, COM.FN_ZS_GETDEPTNAME(a.instcd, a.orddeptcd, a.orddd) AS IO_Dept2, '' AS IO_OPdeptCd, '' AS IO_OPdeptNm, '' AS IO_OPdrNm, '' AS IO_OPdrId, (SELECT diag.diagcd FROM emr.mmohdiag diag WHERE diag.pid = a.pid AND diag.orddd = a.orddd AND diag.cretno = a.cretno AND diag.diaghistcd = 'O' AND diag.diagtypecd = 'D' AND diag.diagkindcdflag = 'M' AND diag.genrflagcd = a.ordtype and diag.orddeptcd = a.orddeptcd AND diag.diaghistno = (select max(diagh.diaghistno) from emr.mmohdiag diagh where diagh.pid = a.pid AND diagh.orddd = a.orddd AND diagh.cretno = a.cretno AND diagh.instcd = '111' AND diagh.diaghistcd = 'O' AND diagh.diagkindcdflag = 'M' AND diagh.genrflagcd = a.ordtype and diagh.orddeptcd = a.orddeptcd group by pid)) as IO_DxCd, (SELECT term.diaghngnm FROM emr.mmohdiag diag, emr.mmbvdiag term WHERE diag.pid = a.pid AND diag.orddd = a.orddd AND diag.cretno = a.cretno AND diag.instcd = term.instcd AND diag.diagcd = term.orgdiagcd AND diag.diaghistcd = 'O' AND diag.diagtypecd = 'D' AND diag.diagkindcdflag = 'M' AND diag.diagdd >= term.termfromdd AND diag.diagdd <= term.termtodd AND diag.diagdd >= term.diagattrfromdd AND diag.diagdd <= term.diagattrtodd AND diag.genrflagcd = a.ordtype and diag.orddeptcd = a.orddeptcd AND diag.diaghistno = (select max(diagh.diaghistno) from emr.mmohdiag diagh where diagh.pid = a.pid AND diagh.orddd = a.orddd AND diagh.cretno = a.cretno AND diagh.instcd = '111' AND diagh.diaghistcd = 'O' AND diagh.diagkindcdflag = 'M' AND diagh.genrflagcd = a.ordtype and diagh.orddeptcd = a.orddeptcd group by pid)) as IO_DxNm, COM.FN_ZS_GETUSERNM(a.orddrid, a.orddd) as IO_MaindrNm, '111' as IO_HosType, case when ex.bp is null then null else ex.bp end as IO_bp, case when ex.dm is null then null else ex.dm end as IO_dm, case when ex.heart is null then null else ex.heart end as IO_heart, case when ex.kidney is null then null else ex.kidney end as IO_kidney, case when ex.respiration is null then null else ex.respiration end as IO_respiration, case when ex.hx is null then null else ex.hx end as IO_hx, case when ex.allergy is null then null else ex.allergy end as IO_allergy, case when ex.drug is null then null else ex.drug end as IO_drug, case when ex.smoking is null then null else ex.smoking end as IO_smoking, case when ex.idio is null then null else ex.idio end as IO_idio, case when ex.nacrotics is null then null else ex.nacrotics end as IO_nacrotics, case when ex.airway is null then null else ex.airway end as IO_airway, case when ex.hemorrhage is null then null else ex.hemorrhage end as IO_hemorrhage, ex.etc IO_status_etc, '111' as IO_OrderNo, '111' as IO_PrintTime, a.ORDDRID as IO_MaindrId, COM.FN_ZS_GETUSERNM(a.ORDDRID, a.orddd) as IO_MaindrNm, '111' as IO_OcrCd, a.ORDDRID as IO_InputId, COM.FN_ZS_GETUSERNM(a.ORDDRID, a.orddd) as IO_InputNm, '111' as IO_SignImg FROM pam.pmohotpt a left outer join cmr.consent_data_ex ex on (ex.pid = a.pid and ex.cln_date = a.orddd) WHERE a.instcd = :param0 AND a.pid = :param1 AND a.orddd = :param2 AND a.cretno = :param3] [Logging Date Time: 2016-11-10 13:30:59,987] ===================================================================================== SQL Command - Statement Id: [getPatientInfoOut] Parameters: [param0=[instcd,111], param1=[pid,1715813], param2=[orddd,20161110], param3=[cretno,1]] [Logging Date Time: 2016-11-10 13:30:59,987] ===================================================================================== SQL Command - Statement Id: [getPatientInfoOut] Parameters: [param0=[instcd,111], param1=[pid,1715813], param2=[orddd,20161110], param3=[cretno,1]] [Logging Date Time: 2016-11-10 13:30:59,987] ===================================================================================== SQL Command - Statement Id: [getPatientInfoOut] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 13:30:59,987] ===================================================================================== SQL Command - Statement Id: [getPatientInfoOut] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 13:31:00,184] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] PreparedStatement : [SELECT signdata FROM emr.mrfmsignimge WHERE userid = :param0 and repryn = 'Y'] [Logging Date Time: 2016-11-10 13:31:00,184] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] PreparedStatement : [SELECT signdata FROM emr.mrfmsignimge WHERE userid = :param0 and repryn = 'Y'] [Logging Date Time: 2016-11-10 13:31:00,184] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] Parameters: [param0=[userid,105066]] [Logging Date Time: 2016-11-10 13:31:00,184] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] Parameters: [param0=[userid,105066]] [Logging Date Time: 2016-11-10 13:31:00,184] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 13:31:00,184] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 13:31:00,339] ===================================================================================== SQL Command - Statement Id: [getOcrTag] PreparedStatement : [SELECT to_char(sysdate,'YYYYMMDD') || SUBSTR(LPAD((EMR.SQ_MRFMOCRP_01.NEXTVAL), 10, '0'), 6, 5) AS ocrtag FROM dual] [Logging Date Time: 2016-11-10 13:31:00,339] ===================================================================================== SQL Command - Statement Id: [getOcrTag] PreparedStatement : [SELECT to_char(sysdate,'YYYYMMDD') || SUBSTR(LPAD((EMR.SQ_MRFMOCRP_01.NEXTVAL), 10, '0'), 6, 5) AS ocrtag FROM dual] [Logging Date Time: 2016-11-10 13:32:01,895] ===================================================================================== SQL Command - Statement Id: [getPatientInfoOut] 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, '' as IO_Ward, '' as IO_roomNO, a.orddd as IO_ADdate, a.orddd as IO_Dschdd, a.ordtype as IO_VisitType, a.orddeptcd as IO_DeptCd, (select dept.deptengabbr from com.zsdddept dept where dept.deptcd = a.orddeptcd and dept.instcd = a.instcd and dept.valitodd >= a.orddd and dept.valifromdd <= a.orddd) as IO_DeptNm, COM.FN_ZS_GETDEPTNAME(a.instcd, a.orddeptcd, a.orddd) AS IO_Dept2, '' AS IO_OPdeptCd, '' AS IO_OPdeptNm, '' AS IO_OPdrNm, '' AS IO_OPdrId, (SELECT diag.diagcd FROM emr.mmohdiag diag WHERE diag.pid = a.pid AND diag.orddd = a.orddd AND diag.cretno = a.cretno AND diag.diaghistcd = 'O' AND diag.diagtypecd = 'D' AND diag.diagkindcdflag = 'M' AND diag.genrflagcd = a.ordtype and diag.orddeptcd = a.orddeptcd AND diag.diaghistno = (select max(diagh.diaghistno) from emr.mmohdiag diagh where diagh.pid = a.pid AND diagh.orddd = a.orddd AND diagh.cretno = a.cretno AND diagh.instcd = '111' AND diagh.diaghistcd = 'O' AND diagh.diagkindcdflag = 'M' AND diagh.genrflagcd = a.ordtype and diagh.orddeptcd = a.orddeptcd group by pid)) as IO_DxCd, (SELECT term.diaghngnm FROM emr.mmohdiag diag, emr.mmbvdiag term WHERE diag.pid = a.pid AND diag.orddd = a.orddd AND diag.cretno = a.cretno AND diag.instcd = term.instcd AND diag.diagcd = term.orgdiagcd AND diag.diaghistcd = 'O' AND diag.diagtypecd = 'D' AND diag.diagkindcdflag = 'M' AND diag.diagdd >= term.termfromdd AND diag.diagdd <= term.termtodd AND diag.diagdd >= term.diagattrfromdd AND diag.diagdd <= term.diagattrtodd AND diag.genrflagcd = a.ordtype and diag.orddeptcd = a.orddeptcd AND diag.diaghistno = (select max(diagh.diaghistno) from emr.mmohdiag diagh where diagh.pid = a.pid AND diagh.orddd = a.orddd AND diagh.cretno = a.cretno AND diagh.instcd = '111' AND diagh.diaghistcd = 'O' AND diagh.diagkindcdflag = 'M' AND diagh.genrflagcd = a.ordtype and diagh.orddeptcd = a.orddeptcd group by pid)) as IO_DxNm, COM.FN_ZS_GETUSERNM(a.orddrid, a.orddd) as IO_MaindrNm, '111' as IO_HosType, case when ex.bp is null then null else ex.bp end as IO_bp, case when ex.dm is null then null else ex.dm end as IO_dm, case when ex.heart is null then null else ex.heart end as IO_heart, case when ex.kidney is null then null else ex.kidney end as IO_kidney, case when ex.respiration is null then null else ex.respiration end as IO_respiration, case when ex.hx is null then null else ex.hx end as IO_hx, case when ex.allergy is null then null else ex.allergy end as IO_allergy, case when ex.drug is null then null else ex.drug end as IO_drug, case when ex.smoking is null then null else ex.smoking end as IO_smoking, case when ex.idio is null then null else ex.idio end as IO_idio, case when ex.nacrotics is null then null else ex.nacrotics end as IO_nacrotics, case when ex.airway is null then null else ex.airway end as IO_airway, case when ex.hemorrhage is null then null else ex.hemorrhage end as IO_hemorrhage, ex.etc IO_status_etc, '111' as IO_OrderNo, '111' as IO_PrintTime, a.ORDDRID as IO_MaindrId, COM.FN_ZS_GETUSERNM(a.ORDDRID, a.orddd) as IO_MaindrNm, '111' as IO_OcrCd, a.ORDDRID as IO_InputId, COM.FN_ZS_GETUSERNM(a.ORDDRID, a.orddd) as IO_InputNm, '111' as IO_SignImg FROM pam.pmohotpt a left outer join cmr.consent_data_ex ex on (ex.pid = a.pid and ex.cln_date = a.orddd) WHERE a.instcd = :param0 AND a.pid = :param1 AND a.orddd = :param2 AND a.cretno = :param3] [Logging Date Time: 2016-11-10 13:32:01,895] ===================================================================================== SQL Command - Statement Id: [getPatientInfoOut] 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, '' as IO_Ward, '' as IO_roomNO, a.orddd as IO_ADdate, a.orddd as IO_Dschdd, a.ordtype as IO_VisitType, a.orddeptcd as IO_DeptCd, (select dept.deptengabbr from com.zsdddept dept where dept.deptcd = a.orddeptcd and dept.instcd = a.instcd and dept.valitodd >= a.orddd and dept.valifromdd <= a.orddd) as IO_DeptNm, COM.FN_ZS_GETDEPTNAME(a.instcd, a.orddeptcd, a.orddd) AS IO_Dept2, '' AS IO_OPdeptCd, '' AS IO_OPdeptNm, '' AS IO_OPdrNm, '' AS IO_OPdrId, (SELECT diag.diagcd FROM emr.mmohdiag diag WHERE diag.pid = a.pid AND diag.orddd = a.orddd AND diag.cretno = a.cretno AND diag.diaghistcd = 'O' AND diag.diagtypecd = 'D' AND diag.diagkindcdflag = 'M' AND diag.genrflagcd = a.ordtype and diag.orddeptcd = a.orddeptcd AND diag.diaghistno = (select max(diagh.diaghistno) from emr.mmohdiag diagh where diagh.pid = a.pid AND diagh.orddd = a.orddd AND diagh.cretno = a.cretno AND diagh.instcd = '111' AND diagh.diaghistcd = 'O' AND diagh.diagkindcdflag = 'M' AND diagh.genrflagcd = a.ordtype and diagh.orddeptcd = a.orddeptcd group by pid)) as IO_DxCd, (SELECT term.diaghngnm FROM emr.mmohdiag diag, emr.mmbvdiag term WHERE diag.pid = a.pid AND diag.orddd = a.orddd AND diag.cretno = a.cretno AND diag.instcd = term.instcd AND diag.diagcd = term.orgdiagcd AND diag.diaghistcd = 'O' AND diag.diagtypecd = 'D' AND diag.diagkindcdflag = 'M' AND diag.diagdd >= term.termfromdd AND diag.diagdd <= term.termtodd AND diag.diagdd >= term.diagattrfromdd AND diag.diagdd <= term.diagattrtodd AND diag.genrflagcd = a.ordtype and diag.orddeptcd = a.orddeptcd AND diag.diaghistno = (select max(diagh.diaghistno) from emr.mmohdiag diagh where diagh.pid = a.pid AND diagh.orddd = a.orddd AND diagh.cretno = a.cretno AND diagh.instcd = '111' AND diagh.diaghistcd = 'O' AND diagh.diagkindcdflag = 'M' AND diagh.genrflagcd = a.ordtype and diagh.orddeptcd = a.orddeptcd group by pid)) as IO_DxNm, COM.FN_ZS_GETUSERNM(a.orddrid, a.orddd) as IO_MaindrNm, '111' as IO_HosType, case when ex.bp is null then null else ex.bp end as IO_bp, case when ex.dm is null then null else ex.dm end as IO_dm, case when ex.heart is null then null else ex.heart end as IO_heart, case when ex.kidney is null then null else ex.kidney end as IO_kidney, case when ex.respiration is null then null else ex.respiration end as IO_respiration, case when ex.hx is null then null else ex.hx end as IO_hx, case when ex.allergy is null then null else ex.allergy end as IO_allergy, case when ex.drug is null then null else ex.drug end as IO_drug, case when ex.smoking is null then null else ex.smoking end as IO_smoking, case when ex.idio is null then null else ex.idio end as IO_idio, case when ex.nacrotics is null then null else ex.nacrotics end as IO_nacrotics, case when ex.airway is null then null else ex.airway end as IO_airway, case when ex.hemorrhage is null then null else ex.hemorrhage end as IO_hemorrhage, ex.etc IO_status_etc, '111' as IO_OrderNo, '111' as IO_PrintTime, a.ORDDRID as IO_MaindrId, COM.FN_ZS_GETUSERNM(a.ORDDRID, a.orddd) as IO_MaindrNm, '111' as IO_OcrCd, a.ORDDRID as IO_InputId, COM.FN_ZS_GETUSERNM(a.ORDDRID, a.orddd) as IO_InputNm, '111' as IO_SignImg FROM pam.pmohotpt a left outer join cmr.consent_data_ex ex on (ex.pid = a.pid and ex.cln_date = a.orddd) WHERE a.instcd = :param0 AND a.pid = :param1 AND a.orddd = :param2 AND a.cretno = :param3] [Logging Date Time: 2016-11-10 13:32:01,895] ===================================================================================== SQL Command - Statement Id: [getPatientInfoOut] Parameters: [param0=[instcd,111], param1=[pid,1715813], param2=[orddd,20161110], param3=[cretno,1]] [Logging Date Time: 2016-11-10 13:32:01,895] ===================================================================================== SQL Command - Statement Id: [getPatientInfoOut] Parameters: [param0=[instcd,111], param1=[pid,1715813], param2=[orddd,20161110], param3=[cretno,1]] [Logging Date Time: 2016-11-10 13:32:01,896] ===================================================================================== SQL Command - Statement Id: [getPatientInfoOut] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 13:32:01,896] ===================================================================================== SQL Command - Statement Id: [getPatientInfoOut] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 13:32:02,139] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] PreparedStatement : [SELECT signdata FROM emr.mrfmsignimge WHERE userid = :param0 and repryn = 'Y'] [Logging Date Time: 2016-11-10 13:32:02,139] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] PreparedStatement : [SELECT signdata FROM emr.mrfmsignimge WHERE userid = :param0 and repryn = 'Y'] [Logging Date Time: 2016-11-10 13:32:02,140] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] Parameters: [param0=[userid,105066]] [Logging Date Time: 2016-11-10 13:32:02,140] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] Parameters: [param0=[userid,105066]] [Logging Date Time: 2016-11-10 13:32:02,140] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 13:32:02,140] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 13:32:02,212] ===================================================================================== SQL Command - Statement Id: [getOcrTag] PreparedStatement : [SELECT to_char(sysdate,'YYYYMMDD') || SUBSTR(LPAD((EMR.SQ_MRFMOCRP_01.NEXTVAL), 10, '0'), 6, 5) AS ocrtag FROM dual] [Logging Date Time: 2016-11-10 13:32:02,212] ===================================================================================== SQL Command - Statement Id: [getOcrTag] PreparedStatement : [SELECT to_char(sysdate,'YYYYMMDD') || SUBSTR(LPAD((EMR.SQ_MRFMOCRP_01.NEXTVAL), 10, '0'), 6, 5) AS ocrtag FROM dual] [Logging Date Time: 2016-11-10 13:32:33,715] ===================================================================================== SQL Command - CLIP.eForm SaveCompleteAll param : clnDept[105066]patientCode[1715813]clnDeptCode[2010400000]formRid[601]formCd[1300010314]consentMstRid[-1]rewriteConsentMstRid[0]deviceType[WIN]vistType[O]hosType[111]clnDate[20161110]ward[]roomcd[]orderNo[111]orderName[ÄÚ°¨±â]orderCd[J00.000.08]ocrCode[2016111063827]cretno[1]createUserName[À̺À·Ä]modifyUserName[À̺À·Ä]imageFileJson[{ "imageFile1" : "201611/10/3eb2bdf4b55c4519bc16f64d8a1b04e5_1.jpg", "imageFile2" : "201611/10/3eb2bdf4b55c4519bc16f64d8a1b04e5_2.jpg", "imageFile3" : "201611/10/3eb2bdf4b55c4519bc16f64d8a1b04e5_3.jpg" }]certTarget[a3cc226fa61eb3de23d473523a7e1cd97d4c3b592e3143efdf0ac97bd5374^62cd464796418ad440a5b186aba659ff33c2e701b674b88fa48090436a859^d0bbe2419b2db98dc254d20a01bd163fa7dc913c1249222571f86b123b7b36]dschdd[20161110]consentState[ELECTR_CMP]mainDrId[105066]dataXml[]formXml[
]certResult[] [Logging Date Time: 2016-11-10 13:32:33,827] ===================================================================================== 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-11-10 13:32:33,827] ===================================================================================== 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-11-10 13:32:33,831] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Parameters: [param0=[sub_cd,CONSENT_MST]] [Logging Date Time: 2016-11-10 13:32:33,831] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Parameters: [param0=[sub_cd,CONSENT_MST]] [Logging Date Time: 2016-11-10 13:32:33,831] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 13:32:33,831] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 13:32:33,850] ===================================================================================== 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-11-10 13:32:33,850] ===================================================================================== 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-11-10 13:32:33,851] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Parameters: [param0=[ud1_num,1859], param1=[sub_cd,CONSENT_MST]] [Logging Date Time: 2016-11-10 13:32:33,851] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Parameters: [param0=[ud1_num,1859], param1=[sub_cd,CONSENT_MST]] [Logging Date Time: 2016-11-10 13:32:33,851] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 13:32:33,851] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 13:32:33,855] ===================================================================================== 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-11-10 13:32:33,855] ===================================================================================== 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-11-10 13:32:33,855] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Parameters: [param0=[sub_cd,CONSENT_DATA]] [Logging Date Time: 2016-11-10 13:32:33,855] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Parameters: [param0=[sub_cd,CONSENT_DATA]] [Logging Date Time: 2016-11-10 13:32:33,855] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 13:32:33,855] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 13:32:33,858] ===================================================================================== 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-11-10 13:32:33,858] ===================================================================================== 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-11-10 13:32:33,858] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Parameters: [param0=[ud1_num,1815], param1=[sub_cd,CONSENT_DATA]] [Logging Date Time: 2016-11-10 13:32:33,858] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Parameters: [param0=[ud1_num,1815], param1=[sub_cd,CONSENT_DATA]] [Logging Date Time: 2016-11-10 13:32:33,858] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 13:32:33,858] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 13:32:33,870] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_MST] PreparedStatement : [insert into CONSENT_MST ( CONSENT_MST_RID, HOS_TYPE, PID, VISIT_TYPE, OCR_NUMBER, CLN_DEPT_CD, CLN_DATE, CRETNO, WARDCD, ROOMCD, FORM_RID, CONSENT_STATE, COMPLETE_YN, COMPLETE_DATETIME, PAPER_YN, REISSUE_YN, REISSUE_CONSENT_MST_RID, REWRITE_YN, REWRITE_CONSENT_MST_RID, USE_YN, MAIN_DR_ID, CREATE_USER_ID, CREATE_DATETIME, MODIFY_USER_ID, MODIFY_DATETIME, CREATE_USER_NAME, MODIFY_USER_NAME ) values ( :param0 , :param1 , :param2 , :param3 , :param4 , :param5 , :param6 , :param7 , :param8 , :param9 , :param10 , :param11 , :param12 , TO_CHAR(SYSDATE,'YYYY-MM-DD hh24:mi:ss'), :param13 , :param14 , :param15 , :param16 , :param17 , 'Y', :param18 , :param19 , TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'), :param19 , TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'), :param20 , :param21 )] [Logging Date Time: 2016-11-10 13:32:33,870] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_MST] PreparedStatement : [insert into CONSENT_MST ( CONSENT_MST_RID, HOS_TYPE, PID, VISIT_TYPE, OCR_NUMBER, CLN_DEPT_CD, CLN_DATE, CRETNO, WARDCD, ROOMCD, FORM_RID, CONSENT_STATE, COMPLETE_YN, COMPLETE_DATETIME, PAPER_YN, REISSUE_YN, REISSUE_CONSENT_MST_RID, REWRITE_YN, REWRITE_CONSENT_MST_RID, USE_YN, MAIN_DR_ID, CREATE_USER_ID, CREATE_DATETIME, MODIFY_USER_ID, MODIFY_DATETIME, CREATE_USER_NAME, MODIFY_USER_NAME ) values ( :param0 , :param1 , :param2 , :param3 , :param4 , :param5 , :param6 , :param7 , :param8 , :param9 , :param10 , :param11 , :param12 , TO_CHAR(SYSDATE,'YYYY-MM-DD hh24:mi:ss'), :param13 , :param14 , :param15 , :param16 , :param17 , 'Y', :param18 , :param19 , TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'), :param19 , TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'), :param20 , :param21 )] [Logging Date Time: 2016-11-10 13:32:33,871] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_MST] Parameters: [param0=[consentMstRid,1859], param1=[hosType,111], param2=[patientCode,1715813], param3=[vistType,O], param4=[ocrCode,2016111063827], param5=[clnDeptCd,2010400000], param6=[clnDate,20161110], param7=[cretno,1], param8=[ward,null], param9=[roomcd,null], param10=[formRid,601], param11=[consentState,ELECTR_CMP], param12=[completeYn,Y], param13=[paperYn,N], param14=[reissueYn,N], param15=[reissueConsentMstRid,0], param16=[rewriteYn,N], param17=[rewriteConsentMstRid,0], param18=[mainDrId,105066], param19=[userId,105066], param20=[createUserName,À̺À·Ä], param21=[modifyUserName,À̺À·Ä]] [Logging Date Time: 2016-11-10 13:32:33,871] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_MST] Parameters: [param0=[consentMstRid,1859], param1=[hosType,111], param2=[patientCode,1715813], param3=[vistType,O], param4=[ocrCode,2016111063827], param5=[clnDeptCd,2010400000], param6=[clnDate,20161110], param7=[cretno,1], param8=[ward,null], param9=[roomcd,null], param10=[formRid,601], param11=[consentState,ELECTR_CMP], param12=[completeYn,Y], param13=[paperYn,N], param14=[reissueYn,N], param15=[reissueConsentMstRid,0], param16=[rewriteYn,N], param17=[rewriteConsentMstRid,0], param18=[mainDrId,105066], param19=[userId,105066], param20=[createUserName,À̺À·Ä], param21=[modifyUserName,À̺À·Ä]] [Logging Date Time: 2016-11-10 13:32:33,871] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_MST] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String], param5=[AnsiString, System.String], param6=[AnsiString, System.String], param7=[Int32, System.Int32], param8=[System.DBNull, null], param9=[System.DBNull, null], param10=[Int32, System.Int32], param11=[AnsiString, System.String], param12=[AnsiString, System.String], param13=[AnsiString, System.String], param14=[AnsiString, System.String], param15=[Int32, System.Int32], param16=[AnsiString, System.String], param17=[Int32, System.Int32], param18=[AnsiString, System.String], param19=[AnsiString, System.String], param20=[AnsiString, System.String], param21=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 13:32:33,871] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_MST] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String], param5=[AnsiString, System.String], param6=[AnsiString, System.String], param7=[Int32, System.Int32], param8=[System.DBNull, null], param9=[System.DBNull, null], param10=[Int32, System.Int32], param11=[AnsiString, System.String], param12=[AnsiString, System.String], param13=[AnsiString, System.String], param14=[AnsiString, System.String], param15=[Int32, System.Int32], param16=[AnsiString, System.String], param17=[Int32, System.Int32], param18=[AnsiString, System.String], param19=[AnsiString, System.String], param20=[AnsiString, System.String], param21=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 13:32:33,876] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_DATA] PreparedStatement : [insert into CONSENT_DATA ( CONSENT_DATA_RID, CONSENT_MST_RID, FORM_RID, DEVICE_TYPE, DEVICE_IDENT_NO, COMPLETE_YN, CREATE_USER_ID, CREATE_DATETIME, FORM_XML, DATA_XML ) values ( :param0 , :param1 , :param2 , :param3 , :param4 , :param5 , :param6 , TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'), :param7 , :param8 )] [Logging Date Time: 2016-11-10 13:32:33,876] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_DATA] PreparedStatement : [insert into CONSENT_DATA ( CONSENT_DATA_RID, CONSENT_MST_RID, FORM_RID, DEVICE_TYPE, DEVICE_IDENT_NO, COMPLETE_YN, CREATE_USER_ID, CREATE_DATETIME, FORM_XML, DATA_XML ) values ( :param0 , :param1 , :param2 , :param3 , :param4 , :param5 , :param6 , TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'), :param7 , :param8 )] [Logging Date Time: 2016-11-10 13:32:33,877] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_DATA] Parameters: [param0=[consentDataRid,1815], param1=[consentMstRid,1859], param2=[formRid,601], param3=[deviceType,WIN], param4=[deviceIdentNo,16-101-33], param5=[completeYn,Y], param6=[userId,105066], param7=[formXml,System.Byte[]], param8=[dataXml,System.Byte[]]] [Logging Date Time: 2016-11-10 13:32:33,877] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_DATA] Parameters: [param0=[consentDataRid,1815], param1=[consentMstRid,1859], param2=[formRid,601], param3=[deviceType,WIN], param4=[deviceIdentNo,16-101-33], param5=[completeYn,Y], param6=[userId,105066], param7=[formXml,System.Byte[]], param8=[dataXml,System.Byte[]]] [Logging Date Time: 2016-11-10 13:32:33,877] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_DATA] Types: [param0=[Int32, System.Int32], param1=[Int32, System.Int32], param2=[Int32, System.Int32], param3=[AnsiString, System.String], param4=[AnsiString, System.String], param5=[AnsiString, System.String], param6=[AnsiString, System.String], param7=[Binary, System.Byte[]], param8=[Binary, System.Byte[]]] [Logging Date Time: 2016-11-10 13:32:33,877] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_DATA] Types: [param0=[Int32, System.Int32], param1=[Int32, System.Int32], param2=[Int32, System.Int32], param3=[AnsiString, System.String], param4=[AnsiString, System.String], param5=[AnsiString, System.String], param6=[AnsiString, System.String], param7=[Binary, System.Byte[]], param8=[Binary, System.Byte[]]] [Logging Date Time: 2016-11-10 13:32:34,139] ===================================================================================== SQL Command - CLIP.eForm File Upload imageFileJson[{ "imageFile1" : "201611/10/3eb2bdf4b55c4519bc16f64d8a1b04e5_1.jpg", "imageFile2" : "201611/10/3eb2bdf4b55c4519bc16f64d8a1b04e5_2.jpg", "imageFile3" : "201611/10/3eb2bdf4b55c4519bc16f64d8a1b04e5_3.jpg" }] [Logging Date Time: 2016-11-10 13:32:34,288] ===================================================================================== SQL Command - CLIP.eForm File Upload consentState[ELECTR_CMP] [Logging Date Time: 2016-11-10 13:32:34,288] ===================================================================================== SQL Command - CLIP.eForm File Upload certTarget[a3cc226fa61eb3de23d473523a7e1cd97d4c3b592e3143efdf0ac97bd5374^62cd464796418ad440a5b186aba659ff33c2e701b674b88fa48090436a859^d0bbe2419b2db98dc254d20a01bd163fa7dc913c1249222571f86b123b7b36] [Logging Date Time: 2016-11-10 13:32:34,288] ===================================================================================== SQL Command - CLIP.eForm File Upload paramHashTable[certTarget[a3cc226fa61eb3de23d473523a7e1cd97d4c3b592e3143efdf0ac97bd5374^62cd464796418ad440a5b186aba659ff33c2e701b674b88fa48090436a859^d0bbe2419b2db98dc254d20a01bd163fa7dc913c1249222571f86b123b7b36] [Logging Date Time: 2016-11-10 13:32:34,289] ===================================================================================== SQL Command - CLIP.eForm File Upload certResult[] [Logging Date Time: 2016-11-10 13:32:34,289] ===================================================================================== SQL Command - CLIP.eForm File Upload paramHashTable[certResult[] [Logging Date Time: 2016-11-10 13:32:34,289] ===================================================================================== 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-11-10 13:32:34,289] ===================================================================================== 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-11-10 13:32:34,289] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Parameters: [param0=[sub_cd,CONSENT_IMAGE]] [Logging Date Time: 2016-11-10 13:32:34,289] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Parameters: [param0=[sub_cd,CONSENT_IMAGE]] [Logging Date Time: 2016-11-10 13:32:34,289] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 13:32:34,289] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 13:32:34,297] ===================================================================================== 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-11-10 13:32:34,297] ===================================================================================== 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-11-10 13:32:34,297] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Parameters: [param0=[ud1_num,1385], param1=[sub_cd,CONSENT_IMAGE]] [Logging Date Time: 2016-11-10 13:32:34,297] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Parameters: [param0=[ud1_num,1385], param1=[sub_cd,CONSENT_IMAGE]] [Logging Date Time: 2016-11-10 13:32:34,297] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 13:32:34,297] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 13:32:34,299] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_IMAGE_SIGN] PreparedStatement : [insert into CONSENT_IMAGE_SIGN ( CONSENT_MST_RID, CONSENT_IMAGE_RID, CERT_TARGET, CERT_RESULT, CERT_STATUS, CREATE_USER_ID, CREATE_DATETIME, MODIFY_USER_ID, MODIFY_DATETIME ) values ( :param0 , :param1 , :param2 , :param3 , DECODE( :param3 , '', 'N', 'Y'), :param4 , TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'), :param4 , TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss') )] [Logging Date Time: 2016-11-10 13:32:34,299] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_IMAGE_SIGN] PreparedStatement : [insert into CONSENT_IMAGE_SIGN ( CONSENT_MST_RID, CONSENT_IMAGE_RID, CERT_TARGET, CERT_RESULT, CERT_STATUS, CREATE_USER_ID, CREATE_DATETIME, MODIFY_USER_ID, MODIFY_DATETIME ) values ( :param0 , :param1 , :param2 , :param3 , DECODE( :param3 , '', 'N', 'Y'), :param4 , TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'), :param4 , TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss') )] [Logging Date Time: 2016-11-10 13:32:34,300] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_IMAGE_SIGN] Parameters: [param0=[consentMstRid,1859], param1=[consentImageRid,1385], param2=[certTarget,a3cc226fa61eb3de23d473523a7e1cd97d4c3b592e3143efdf0ac97bd5374^62cd464796418ad440a5b186aba659ff33c2e701b674b88fa48090436a859^d0bbe2419b2db98dc254d20a01bd163fa7dc913c1249222571f86b123b7b36], param3=[certResult,], param4=[userId,105066]] [Logging Date Time: 2016-11-10 13:32:34,300] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_IMAGE_SIGN] Parameters: [param0=[consentMstRid,1859], param1=[consentImageRid,1385], param2=[certTarget,a3cc226fa61eb3de23d473523a7e1cd97d4c3b592e3143efdf0ac97bd5374^62cd464796418ad440a5b186aba659ff33c2e701b674b88fa48090436a859^d0bbe2419b2db98dc254d20a01bd163fa7dc913c1249222571f86b123b7b36], param3=[certResult,], param4=[userId,105066]] [Logging Date Time: 2016-11-10 13:32:34,300] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_IMAGE_SIGN] Types: [param0=[Int32, System.Int32], param1=[Int32, System.Int32], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 13:32:34,300] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_IMAGE_SIGN] Types: [param0=[Int32, System.Int32], param1=[Int32, System.Int32], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 13:33:11,940] ===================================================================================== SQL Command - Statement Id: [setFileName] PreparedStatement : [declare I_PID VARCHAR2(10) := :param0 ; I_IOFLAG VARCHAR2(1) := :param1 ; I_ORDDD VARCHAR2(8) := :param2 ; I_DSCHDD VARCHAR2(8) := :param3 ; I_CRETNO NUMBER(10) := :param4 ; I_FILESIZE NUMBER(18) := :param5 ; I_FORMCD VARCHAR2(10) := :param6 ; I_PAGE NUMBER(18) := :param7 ; I_OCRCODE VARCHAR2(13) := :param8 ; I_USERID VARCHAR2(10) := :param9 ; I_ORDDEPTCD VARCHAR2(10) := :param10 ; begin EMR.LCTECH_PROCESS(I_PID, I_IOFLAG, I_ORDDD, I_DSCHDD, I_CRETNO, I_FILESIZE, I_FORMCD, I_PAGE, I_OCRCODE, I_ORDDEPTCD, I_USERID); end;] [Logging Date Time: 2016-11-10 13:33:11,940] ===================================================================================== SQL Command - Statement Id: [setFileName] PreparedStatement : [declare I_PID VARCHAR2(10) := :param0 ; I_IOFLAG VARCHAR2(1) := :param1 ; I_ORDDD VARCHAR2(8) := :param2 ; I_DSCHDD VARCHAR2(8) := :param3 ; I_CRETNO NUMBER(10) := :param4 ; I_FILESIZE NUMBER(18) := :param5 ; I_FORMCD VARCHAR2(10) := :param6 ; I_PAGE NUMBER(18) := :param7 ; I_OCRCODE VARCHAR2(13) := :param8 ; I_USERID VARCHAR2(10) := :param9 ; I_ORDDEPTCD VARCHAR2(10) := :param10 ; begin EMR.LCTECH_PROCESS(I_PID, I_IOFLAG, I_ORDDD, I_DSCHDD, I_CRETNO, I_FILESIZE, I_FORMCD, I_PAGE, I_OCRCODE, I_ORDDEPTCD, I_USERID); end;] [Logging Date Time: 2016-11-10 13:33:11,941] ===================================================================================== SQL Command - Statement Id: [setFileName] Parameters: [param0=[pid,1715813], param1=[ordtype,O], param2=[orddd,20161110], param3=[dschdd,20161110], param4=[cretno,1], param5=[filesize,500], param6=[formcd,1300010314], param7=[pageno,1], param8=[ocrtag,2016111063827], param9=[userid,105066], param10=[orddeptcd,]] [Logging Date Time: 2016-11-10 13:33:11,941] ===================================================================================== SQL Command - Statement Id: [setFileName] Parameters: [param0=[pid,1715813], param1=[ordtype,O], param2=[orddd,20161110], param3=[dschdd,20161110], param4=[cretno,1], param5=[filesize,500], param6=[formcd,1300010314], param7=[pageno,1], param8=[ocrtag,2016111063827], param9=[userid,105066], param10=[orddeptcd,]] [Logging Date Time: 2016-11-10 13:33:11,941] ===================================================================================== SQL Command - Statement Id: [setFileName] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String], param5=[AnsiString, System.String], param6=[AnsiString, System.String], param7=[AnsiString, System.String], param8=[AnsiString, System.String], param9=[AnsiString, System.String], param10=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 13:33:11,941] ===================================================================================== SQL Command - Statement Id: [setFileName] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String], param5=[AnsiString, System.String], param6=[AnsiString, System.String], param7=[AnsiString, System.String], param8=[AnsiString, System.String], param9=[AnsiString, System.String], param10=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 13:33:12,202] ===================================================================================== SQL Command - Statement Id: [getFileName] PreparedStatement : [SELECT d.alias||'\'||'fnuImage'||'\'||substr(c.cdate,1,6)||'\'||substr(c.cdate,7)||'\'||to_char(c.pageno) AS filename FROM cmr.treatt a, cmr.chartpaget b, cmr.paget c, cmr.patht d WHERE a.patid = :param0 AND a.class = :param1 AND a.indate = :param2 and a.TREATNO = b.TREATNO and b.formcode = :param3 and b.ocrcode = :param4 and b.page = :param5 and b.pageno = c.pageno and d.pathid = c.pathid and d.active = 'Y'] [Logging Date Time: 2016-11-10 13:33:12,202] ===================================================================================== SQL Command - Statement Id: [getFileName] PreparedStatement : [SELECT d.alias||'\'||'fnuImage'||'\'||substr(c.cdate,1,6)||'\'||substr(c.cdate,7)||'\'||to_char(c.pageno) AS filename FROM cmr.treatt a, cmr.chartpaget b, cmr.paget c, cmr.patht d WHERE a.patid = :param0 AND a.class = :param1 AND a.indate = :param2 and a.TREATNO = b.TREATNO and b.formcode = :param3 and b.ocrcode = :param4 and b.page = :param5 and b.pageno = c.pageno and d.pathid = c.pathid and d.active = 'Y'] [Logging Date Time: 2016-11-10 13:33:12,202] ===================================================================================== SQL Command - Statement Id: [getFileName] Parameters: [param0=[pid,1715813], param1=[ordtype,O], param2=[orddd,20161110], param3=[formcd,1300010314], param4=[ocrtag,2016111063827], param5=[pageno,1]] [Logging Date Time: 2016-11-10 13:33:12,202] ===================================================================================== SQL Command - Statement Id: [getFileName] Parameters: [param0=[pid,1715813], param1=[ordtype,O], param2=[orddd,20161110], param3=[formcd,1300010314], param4=[ocrtag,2016111063827], param5=[pageno,1]] [Logging Date Time: 2016-11-10 13:33:12,202] ===================================================================================== SQL Command - Statement Id: [getFileName] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String], param5=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 13:33:12,202] ===================================================================================== SQL Command - Statement Id: [getFileName] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String], param5=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 13:33:12,227] ===================================================================================== SQL Command - CLIP.eForm File Upload localpath[D:\TeamDFH_Consent\DFH-Consent\CLIP.e-Form.Consent.Dfh.Web\UPLOAD\201611\10\3eb2bdf4b55c4519bc16f64d8a1b04e5_1.jpg] [Logging Date Time: 2016-11-10 13:33:12,227] ===================================================================================== SQL Command - CLIP.eForm File Upload uploadFileName[Image3\fnuImage\201611\10\103138580.jpg] [Logging Date Time: 2016-11-10 13:33:12,227] ===================================================================================== SQL Command - CLIP.eForm File Upload uploadFileName[\\192.168.100.32\image_a03\fnuImage\201611\10\103138580.jpg] [Logging Date Time: 2016-11-10 13:33:12,227] ===================================================================================== SQL Command - CLIP.eForm File Upload Impersonate START workemr [Logging Date Time: 2016-11-10 13:33:12,248] ===================================================================================== SQL Command - CLIP.eForm File Upload Impersonate END [Logging Date Time: 2016-11-10 13:33:12,373] ===================================================================================== SQL Command - Statement Id: [delEformData] PreparedStatement : [declare I_PID VARCHAR2(10) := :param0 ; /* µî·Ï¹øÈ£ */ I_IOFLAG VARCHAR2(1) := :param1 ; /* ÀÔ¿ø/¿Ü·¡ ±¸ºÐ */ I_ORDDD VARCHAR2(8) := :param2 ; /* ÀÔ¿øÀÏ ¶Ç´Â Áø·áÀÏ */ I_DSCHDD VARCHAR2(8) := :param3 ; /* ÀÔ¿øÈ¯ÀÚ Åð¿øÀÏ ¿Ü·¡È¯ÀÚ¸é °ªÀÌ '' */ I_CRETNO NUMBER(10) := :param4 ; /* ¿ø¹«Á¤º¸ÀÇ »ý¼º¹øÈ£ */ I_FORMCD VARCHAR2(10) := :param5 ; /* FORMCD */ I_OCRCODE VARCHAR2(13) := :param6 ; /* OCRCODE */ I_USERID VARCHAR2(10) := :param7 ; /* »ç¿ëÀÚ ID ½ÇÁ¦ µ¿ÀǼ­ ±¸µæ ÇàÀ§¸¦ ÇÏ´Â »ç¶÷ */ I_USERNM VARCHAR2(10) := :param8 ; /* »ç¿ëÀÚ À̸§ */ I_CONSENT_MST_RID NUMBER(18) := :param9 ; /* µ¿ÀǼ­ ÀÛ¼º ¸¶½ºÅÍ ID */ I_HOS_TYPE VARCHAR2(10) := :param10 ; /* º´¿ø±¸ºÐ(´ë±¸ÆÄƼ¸¶ - '111') */ I_ORDDEPTCD VARCHAR2(10) := :param11 ; begin EMR.EFORM_DELETE(I_PID, I_IOFLAG, I_ORDDD, I_DSCHDD, I_CRETNO, I_FORMCD, I_OCRCODE, I_USERID, I_USERNM, I_CONSENT_MST_RID, I_ORDDEPTCD, I_HOS_TYPE); end;] [Logging Date Time: 2016-11-10 13:33:12,373] ===================================================================================== SQL Command - Statement Id: [delEformData] PreparedStatement : [declare I_PID VARCHAR2(10) := :param0 ; /* µî·Ï¹øÈ£ */ I_IOFLAG VARCHAR2(1) := :param1 ; /* ÀÔ¿ø/¿Ü·¡ ±¸ºÐ */ I_ORDDD VARCHAR2(8) := :param2 ; /* ÀÔ¿øÀÏ ¶Ç´Â Áø·áÀÏ */ I_DSCHDD VARCHAR2(8) := :param3 ; /* ÀÔ¿øÈ¯ÀÚ Åð¿øÀÏ ¿Ü·¡È¯ÀÚ¸é °ªÀÌ '' */ I_CRETNO NUMBER(10) := :param4 ; /* ¿ø¹«Á¤º¸ÀÇ »ý¼º¹øÈ£ */ I_FORMCD VARCHAR2(10) := :param5 ; /* FORMCD */ I_OCRCODE VARCHAR2(13) := :param6 ; /* OCRCODE */ I_USERID VARCHAR2(10) := :param7 ; /* »ç¿ëÀÚ ID ½ÇÁ¦ µ¿ÀǼ­ ±¸µæ ÇàÀ§¸¦ ÇÏ´Â »ç¶÷ */ I_USERNM VARCHAR2(10) := :param8 ; /* »ç¿ëÀÚ À̸§ */ I_CONSENT_MST_RID NUMBER(18) := :param9 ; /* µ¿ÀǼ­ ÀÛ¼º ¸¶½ºÅÍ ID */ I_HOS_TYPE VARCHAR2(10) := :param10 ; /* º´¿ø±¸ºÐ(´ë±¸ÆÄƼ¸¶ - '111') */ I_ORDDEPTCD VARCHAR2(10) := :param11 ; begin EMR.EFORM_DELETE(I_PID, I_IOFLAG, I_ORDDD, I_DSCHDD, I_CRETNO, I_FORMCD, I_OCRCODE, I_USERID, I_USERNM, I_CONSENT_MST_RID, I_ORDDEPTCD, I_HOS_TYPE); end;] [Logging Date Time: 2016-11-10 13:33:12,373] ===================================================================================== SQL Command - Statement Id: [delEformData] Parameters: [param0=[pid,1715813], param1=[ordtype,O], param2=[orddd,20161110], param3=[dschdd,20161110], param4=[cretno,1], param5=[formcd,1300010314], param6=[ocrtag,2016111063827], param7=[userid,105066], param8=[username,À̺À·Ä], param9=[consentmstrid,1859], param10=[hostype,111], param11=[orddeptcd,]] [Logging Date Time: 2016-11-10 13:33:12,373] ===================================================================================== SQL Command - Statement Id: [delEformData] Parameters: [param0=[pid,1715813], param1=[ordtype,O], param2=[orddd,20161110], param3=[dschdd,20161110], param4=[cretno,1], param5=[formcd,1300010314], param6=[ocrtag,2016111063827], param7=[userid,105066], param8=[username,À̺À·Ä], param9=[consentmstrid,1859], param10=[hostype,111], param11=[orddeptcd,]] [Logging Date Time: 2016-11-10 13:33:12,374] ===================================================================================== SQL Command - Statement Id: [delEformData] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String], param5=[AnsiString, System.String], param6=[AnsiString, System.String], param7=[AnsiString, System.String], param8=[AnsiString, System.String], param9=[AnsiString, System.String], param10=[AnsiString, System.String], param11=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 13:33:12,374] ===================================================================================== SQL Command - Statement Id: [delEformData] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String], param5=[AnsiString, System.String], param6=[AnsiString, System.String], param7=[AnsiString, System.String], param8=[AnsiString, System.String], param9=[AnsiString, System.String], param10=[AnsiString, System.String], param11=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 13:33:12,400] ===================================================================================== SQL Command - CLIP.eForm imageUpload ERROR : [System.IO.DirectoryNotFoundException: 'D:\TeamDFH_Consent\DFH-Consent\CLIP.e-Form.Consent.Dfh.Web\UPLOAD\201611\10\3eb2bdf4b55c4519bc16f64d8a1b04e5_1.jpg' °æ·ÎÀÇ ÀϺθ¦ ãÀ» ¼ö ¾ø½À´Ï´Ù. À§Ä¡: System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) À§Ä¡: System.IO.File.InternalCopy(String sourceFileName, String destFileName, Boolean overwrite) À§Ä¡: System.IO.File.Copy(String sourceFileName, String destFileName) À§Ä¡: CLIP.eForm.Consent.Dfh.WebService.ConsentSvc.imageUpload(SaveConsentDac dac, Hashtable paramHashTable, String userId, String patientCode, String visitType, String clnDate, String Dschdd, Int32 cretno, String ocrcode, Int32 consentMstRid, String consentState, String formCd, Int32 formRid, String dataXml, String imageFileJson, String certTarget, String certResult, String hosType, String createUserName) ÆÄÀÏ D:\TeamDFH_Consent\DFH-Consent\CLIP.e-Form.Consent.Dfh.Web\ConsentSvc.asmx.cs:ÁÙ 1075] [Logging Date Time: 2016-11-10 13:33:15,676] ===================================================================================== SQL Command - CLIP.eForm SaveCompleteAll param : clnDept[105066]patientCode[1715813]clnDeptCode[2010400000]formRid[601]formCd[1300010314]consentMstRid[-1]rewriteConsentMstRid[0]deviceType[WIN]vistType[O]hosType[111]clnDate[20161110]ward[]roomcd[]orderNo[111]orderName[ÄÚ°¨±â]orderCd[J00.000.08]ocrCode[2016111063827]cretno[1]createUserName[À̺À·Ä]modifyUserName[À̺À·Ä]imageFileJson[{ "imageFile1" : "201611/10/4a936427e0ba41baa5092ab16e0a63a8_1.jpg", "imageFile2" : "201611/10/4a936427e0ba41baa5092ab16e0a63a8_2.jpg", "imageFile3" : "201611/10/4a936427e0ba41baa5092ab16e0a63a8_3.jpg" }]certTarget[a3cc226fa61eb3de23d473523a7e1cd97d4c3b592e3143efdf0ac97bd5374^62cd464796418ad440a5b186aba659ff33c2e701b674b88fa48090436a859^d0bbe2419b2db98dc254d20a01bd163fa7dc913c1249222571f86b123b7b36]dschdd[20161110]consentState[ELECTR_CMP]mainDrId[105066]dataXml[]formXml[
]certResult[]