[Logging Date Time: 2016-08-26 16:31:15,703] ===================================================================================== 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-08-26 16:31:15,723] ===================================================================================== SQL Command - Statement Id: [GET_TRMT_DATE_LIST] Parameters: [param0=[instcd,111], param1=[pid,0586244], param2=[searchClnDate,20150615]] [Logging Date Time: 2016-08-26 16:31:15,723] ===================================================================================== SQL Command - Statement Id: [GET_TRMT_DATE_LIST] Parameters: [param0=[instcd,111], param1=[pid,0586244], param2=[searchClnDate,20150615]] [Logging Date Time: 2016-08-26 16:31:15,723] ===================================================================================== 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-08-26 16:31:15,723] ===================================================================================== 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-08-26 16:31:15,824] ===================================================================================== 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-08-26 16:31:15,824] ===================================================================================== 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-08-26 16:31:15,825] ===================================================================================== SQL Command - Statement Id: [getPatientInfoIn] Parameters: [param0=[ordtype,I], param1=[instcd,111], param2=[pid,0586244], param3=[orddd,20150615], param4=[cretno,1]] [Logging Date Time: 2016-08-26 16:31:15,825] ===================================================================================== SQL Command - Statement Id: [getPatientInfoIn] Parameters: [param0=[ordtype,I], param1=[instcd,111], param2=[pid,0586244], param3=[orddd,20150615], param4=[cretno,1]] [Logging Date Time: 2016-08-26 16:31:15,825] ===================================================================================== 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-08-26 16:31:15,825] ===================================================================================== 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-08-26 16:31:15,934] ===================================================================================== 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-08-26 16:31:15,934] ===================================================================================== 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-08-26 16:31:15,934] ===================================================================================== SQL Command - Statement Id: [getPatientInfoIn] Parameters: [param0=[ordtype,I], param1=[instcd,111], param2=[pid,0586244], param3=[orddd,20150615], param4=[cretno,1]] [Logging Date Time: 2016-08-26 16:31:15,934] ===================================================================================== SQL Command - Statement Id: [getPatientInfoIn] Parameters: [param0=[ordtype,I], param1=[instcd,111], param2=[pid,0586244], param3=[orddd,20150615], param4=[cretno,1]] [Logging Date Time: 2016-08-26 16:31:15,934] ===================================================================================== 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-08-26 16:31:15,934] ===================================================================================== 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-08-26 16:31:16,230] ===================================================================================== 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', '미작성') 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) AS CLN_DEPT_NM , CM.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 = :param0 AND TO_CHAR(TO_DATE(CM.CREATE_DATETIME, 'YYYY-MM-DD HH24:MI:SS'), 'YYYYMMDD') BETWEEN :param1 and :param2 AND VEF.FORM_CD = C.FORMCD AND C.instcd = '111' AND C.formprogflag LIKE 'OCR%' AND C.formlevlcd != '-' AND 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-08-26 16:31:16,230] ===================================================================================== 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', '미작성') 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) AS CLN_DEPT_NM , CM.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 = :param0 AND TO_CHAR(TO_DATE(CM.CREATE_DATETIME, 'YYYY-MM-DD HH24:MI:SS'), 'YYYYMMDD') BETWEEN :param1 and :param2 AND VEF.FORM_CD = C.FORMCD AND C.instcd = '111' AND C.formprogflag LIKE 'OCR%' AND C.formlevlcd != '-' AND 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-08-26 16:31:16,231] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_LIST] Parameters: [param0=[patientCode,0586244], param1=[startDt,20010601], param2=[endDt,20160826]] [Logging Date Time: 2016-08-26 16:31:16,231] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_LIST] Parameters: [param0=[patientCode,0586244], param1=[startDt,20010601], param2=[endDt,20160826]] [Logging Date Time: 2016-08-26 16:31:16,231] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_LIST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]] [Logging Date Time: 2016-08-26 16:31:16,231] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_LIST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]] [Logging Date Time: 2016-08-26 16:31:16,536] ===================================================================================== SQL Command - Statement Id: [getDeptList] PreparedStatement : [SELECT ' ' as deptcd, '전체' as deptnm, 0 as clincdeptdispseq, 0 as sort from dual UNION ALL SELECT deptcd, depthngnm as deptnm, clincdeptdispseq, 1 as sort FROM com.zsdddept WHERE instcd = :param0 AND TO_CHAR(CURRENT_DATE,'YYYYMMDD')>=valifromdd AND TO_CHAR(CURRENT_DATE,'YYYYMMDD')<=valitodd AND rcptuseyn = 'Y' ORDER BY clincdeptdispseq ASC] [Logging Date Time: 2016-08-26 16:31:16,536] ===================================================================================== SQL Command - Statement Id: [getDeptList] PreparedStatement : [SELECT ' ' as deptcd, '전체' as deptnm, 0 as clincdeptdispseq, 0 as sort from dual UNION ALL SELECT deptcd, depthngnm as deptnm, clincdeptdispseq, 1 as sort FROM com.zsdddept WHERE instcd = :param0 AND TO_CHAR(CURRENT_DATE,'YYYYMMDD')>=valifromdd AND TO_CHAR(CURRENT_DATE,'YYYYMMDD')<=valitodd AND rcptuseyn = 'Y' ORDER BY clincdeptdispseq ASC] [Logging Date Time: 2016-08-26 16:31:16,536] ===================================================================================== SQL Command - Statement Id: [getDeptList] Parameters: [param0=[instcd,111]] [Logging Date Time: 2016-08-26 16:31:16,536] ===================================================================================== SQL Command - Statement Id: [getDeptList] Parameters: [param0=[instcd,111]] [Logging Date Time: 2016-08-26 16:31:16,536] ===================================================================================== SQL Command - Statement Id: [getDeptList] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-08-26 16:31:16,536] ===================================================================================== SQL Command - Statement Id: [getDeptList] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-08-26 16:31:16,603] ===================================================================================== SQL Command - Statement Id: [getDocList] PreparedStatement : [SELECT ' ' as doctorid, '전체' as doctornm, 1 as sort from dual UNION ALL SELECT b.userid AS doctorid, b.usernm AS doctornm, 2 as sort FROM com.zsumusrd a INNER JOIN com.zsumusrb b ON a.userid = b.userid WHERE a.psnworkyn = 'N' AND a.dutplceinstcd = :param0 AND a.jobkindcd LIKE '03%' AND a.dutplcecd = :param1 AND :param2 BETWEEN a.fromdd AND a.todd AND :param2 BETWEEN b.userfromdd AND b.usertodd ORDER BY sort, doctorid] [Logging Date Time: 2016-08-26 16:31:16,603] ===================================================================================== SQL Command - Statement Id: [getDocList] PreparedStatement : [SELECT ' ' as doctorid, '전체' as doctornm, 1 as sort from dual UNION ALL SELECT b.userid AS doctorid, b.usernm AS doctornm, 2 as sort FROM com.zsumusrd a INNER JOIN com.zsumusrb b ON a.userid = b.userid WHERE a.psnworkyn = 'N' AND a.dutplceinstcd = :param0 AND a.jobkindcd LIKE '03%' AND a.dutplcecd = :param1 AND :param2 BETWEEN a.fromdd AND a.todd AND :param2 BETWEEN b.userfromdd AND b.usertodd ORDER BY sort, doctorid] [Logging Date Time: 2016-08-26 16:31:16,603] ===================================================================================== SQL Command - Statement Id: [getDocList] Parameters: [param0=[instcd,111], param1=[orddeptcd, ], param2=[srchdd,20160826]] [Logging Date Time: 2016-08-26 16:31:16,603] ===================================================================================== SQL Command - Statement Id: [getDocList] Parameters: [param0=[instcd,111], param1=[orddeptcd, ], param2=[srchdd,20160826]] [Logging Date Time: 2016-08-26 16:31:16,603] ===================================================================================== SQL Command - Statement Id: [getDocList] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]] [Logging Date Time: 2016-08-26 16:31:16,603] ===================================================================================== SQL Command - Statement Id: [getDocList] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]] [Logging Date Time: 2016-08-26 16:31:31,809] ===================================================================================== SQL Command - Statement Id: [GET_CATEGORY_FOR_DROPDOWN] PreparedStatement : [SELECT CATEGORY_TYPE, CATEGORY_ID, CATEGORY_NAME FROM EFORM_CATEGORY WHERE USE_YN = 'Y' AND P_CATEGORY_RID = '1'] [Logging Date Time: 2016-08-26 16:31:31,809] ===================================================================================== SQL Command - Statement Id: [GET_CATEGORY_FOR_DROPDOWN] PreparedStatement : [SELECT CATEGORY_TYPE, CATEGORY_ID, CATEGORY_NAME FROM EFORM_CATEGORY WHERE USE_YN = 'Y' AND P_CATEGORY_RID = '1'] [Logging Date Time: 2016-08-26 16:31:32,071] ===================================================================================== SQL Command - Statement Id: [GET_CATEGORY_FOR_DROPDOWN] PreparedStatement : [SELECT CATEGORY_TYPE, CATEGORY_ID, CATEGORY_NAME FROM EFORM_CATEGORY WHERE USE_YN = 'Y' AND P_CATEGORY_RID = (SELECT CATEGORY_RID FROM EFORM_CATEGORY WHERE CATEGORY_ID = :param0 )] [Logging Date Time: 2016-08-26 16:31:32,071] ===================================================================================== SQL Command - Statement Id: [GET_CATEGORY_FOR_DROPDOWN] PreparedStatement : [SELECT CATEGORY_TYPE, CATEGORY_ID, CATEGORY_NAME FROM EFORM_CATEGORY WHERE USE_YN = 'Y' AND P_CATEGORY_RID = (SELECT CATEGORY_RID FROM EFORM_CATEGORY WHERE CATEGORY_ID = :param0 )] [Logging Date Time: 2016-08-26 16:31:32,071] ===================================================================================== SQL Command - Statement Id: [GET_CATEGORY_FOR_DROPDOWN] Parameters: [param0=[category_id,1CB1B494-1EF0-48BD-84D6-4965A54E6AEA]] [Logging Date Time: 2016-08-26 16:31:32,071] ===================================================================================== SQL Command - Statement Id: [GET_CATEGORY_FOR_DROPDOWN] Parameters: [param0=[category_id,1CB1B494-1EF0-48BD-84D6-4965A54E6AEA]] [Logging Date Time: 2016-08-26 16:31:32,071] ===================================================================================== SQL Command - Statement Id: [GET_CATEGORY_FOR_DROPDOWN] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-08-26 16:31:32,071] ===================================================================================== SQL Command - Statement Id: [GET_CATEGORY_FOR_DROPDOWN] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-08-26 16:33:37,791] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_BY_SEARCH_LIST] PreparedStatement : [SELECT F.FORM_CD, F.FORM_GUID, F.FORM_NAME, F.FULL_CATEGORY_NAME, F.FORM_RID, F.PRNTCNT FROM ( SELECT F.FORM_CD, F.FORM_GUID, F.FORM_NAME, N.FULL_CATEGORY_NAME AS FULL_CATEGORY_NAME, F.FORM_RID, F.PRNTCNT FROM V_EFORM_FORMDOC F, ( SELECT CATEGORY_RID, LEVEL FROM EFORM_CATEGORY START WITH CATEGORY_RID = (SELECT CATEGORY_RID FROM EFORM_CATEGORY WHERE CATEGORY_ID = :param0 ) CONNECT BY P_CATEGORY_RID = PRIOR CATEGORY_RID ) C, ( SELECT CATEGORY_RID,CATEGORY_NAME, LTRIM (SYS_CONNECT_BY_PATH (CATEGORY_NAME, '>'), '>') AS FULL_CATEGORY_NAME, LEVEL FROM EFORM_CATEGORY START WITH CATEGORY_RID = '1' CONNECT BY P_CATEGORY_RID = PRIOR CATEGORY_RID ) N WHERE F.CATEGORY_RID = C.CATEGORY_RID AND C.CATEGORY_RID = N.CATEGORY_RID AND (REPLACE(UPPER(F.FORM_NAME),' ','') LIKE REPLACE(UPPER( :param1 ),' ','') OR UPPER(F.FORM_CD) LIKE UPPER( :param1 )) ) F ORDER BY F.FORM_NAME] [Logging Date Time: 2016-08-26 16:33:37,791] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_BY_SEARCH_LIST] PreparedStatement : [SELECT F.FORM_CD, F.FORM_GUID, F.FORM_NAME, F.FULL_CATEGORY_NAME, F.FORM_RID, F.PRNTCNT FROM ( SELECT F.FORM_CD, F.FORM_GUID, F.FORM_NAME, N.FULL_CATEGORY_NAME AS FULL_CATEGORY_NAME, F.FORM_RID, F.PRNTCNT FROM V_EFORM_FORMDOC F, ( SELECT CATEGORY_RID, LEVEL FROM EFORM_CATEGORY START WITH CATEGORY_RID = (SELECT CATEGORY_RID FROM EFORM_CATEGORY WHERE CATEGORY_ID = :param0 ) CONNECT BY P_CATEGORY_RID = PRIOR CATEGORY_RID ) C, ( SELECT CATEGORY_RID,CATEGORY_NAME, LTRIM (SYS_CONNECT_BY_PATH (CATEGORY_NAME, '>'), '>') AS FULL_CATEGORY_NAME, LEVEL FROM EFORM_CATEGORY START WITH CATEGORY_RID = '1' CONNECT BY P_CATEGORY_RID = PRIOR CATEGORY_RID ) N WHERE F.CATEGORY_RID = C.CATEGORY_RID AND C.CATEGORY_RID = N.CATEGORY_RID AND (REPLACE(UPPER(F.FORM_NAME),' ','') LIKE REPLACE(UPPER( :param1 ),' ','') OR UPPER(F.FORM_CD) LIKE UPPER( :param1 )) ) F ORDER BY F.FORM_NAME] [Logging Date Time: 2016-08-26 16:33:37,835] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_BY_SEARCH_LIST] Parameters: [param0=[category_id,1CB1B494-1EF0-48BD-84D6-4965A54E6AEA], param1=[key_word,%%%%]] [Logging Date Time: 2016-08-26 16:33:37,835] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_BY_SEARCH_LIST] Parameters: [param0=[category_id,1CB1B494-1EF0-48BD-84D6-4965A54E6AEA], param1=[key_word,%%%%]] [Logging Date Time: 2016-08-26 16:33:37,835] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_BY_SEARCH_LIST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String]] [Logging Date Time: 2016-08-26 16:33:37,835] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_BY_SEARCH_LIST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String]] [Logging Date Time: 2016-08-26 16:33:40,437] ===================================================================================== 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-08-26 16:33:40,437] ===================================================================================== 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-08-26 16:33:40,438] ===================================================================================== SQL Command - Statement Id: [getPatientInfoIn] Parameters: [param0=[ordtype,I], param1=[instcd,111], param2=[pid,0586244], param3=[orddd,20150615], param4=[cretno,1]] [Logging Date Time: 2016-08-26 16:33:40,438] ===================================================================================== SQL Command - Statement Id: [getPatientInfoIn] Parameters: [param0=[ordtype,I], param1=[instcd,111], param2=[pid,0586244], param3=[orddd,20150615], param4=[cretno,1]] [Logging Date Time: 2016-08-26 16:33:40,438] ===================================================================================== 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-08-26 16:33:40,438] ===================================================================================== 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-08-26 16:33:40,508] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] PreparedStatement : [SELECT signdata FROM emr.mrfmsignimge WHERE userid = :param0 and repryn = 'Y'] [Logging Date Time: 2016-08-26 16:33:40,508] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] PreparedStatement : [SELECT signdata FROM emr.mrfmsignimge WHERE userid = :param0 and repryn = 'Y'] [Logging Date Time: 2016-08-26 16:33:40,508] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] Parameters: [param0=[userid,103043]] [Logging Date Time: 2016-08-26 16:33:40,508] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] Parameters: [param0=[userid,103043]] [Logging Date Time: 2016-08-26 16:33:40,508] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-08-26 16:33:40,508] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-08-26 16:33:46,548] ===================================================================================== 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-08-26 16:33:46,548] ===================================================================================== 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-08-26 16:33:46,548] ===================================================================================== SQL Command - Statement Id: [getPatientInfoIn] Parameters: [param0=[ordtype,I], param1=[instcd,111], param2=[pid,0586244], param3=[orddd,20150615], param4=[cretno,1]] [Logging Date Time: 2016-08-26 16:33:46,548] ===================================================================================== SQL Command - Statement Id: [getPatientInfoIn] Parameters: [param0=[ordtype,I], param1=[instcd,111], param2=[pid,0586244], param3=[orddd,20150615], param4=[cretno,1]] [Logging Date Time: 2016-08-26 16:33:46,548] ===================================================================================== 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-08-26 16:33:46,548] ===================================================================================== 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-08-26 16:33:46,595] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] PreparedStatement : [SELECT signdata FROM emr.mrfmsignimge WHERE userid = :param0 and repryn = 'Y'] [Logging Date Time: 2016-08-26 16:33:46,595] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] PreparedStatement : [SELECT signdata FROM emr.mrfmsignimge WHERE userid = :param0 and repryn = 'Y'] [Logging Date Time: 2016-08-26 16:33:46,595] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] Parameters: [param0=[userid,103043]] [Logging Date Time: 2016-08-26 16:33:46,595] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] Parameters: [param0=[userid,103043]] [Logging Date Time: 2016-08-26 16:33:46,595] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-08-26 16:33:46,595] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-08-26 16:33:57,880] ===================================================================================== 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-08-26 16:33:57,880] ===================================================================================== 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-08-26 16:33:57,959] ===================================================================================== 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-08-26 16:33:57,959] ===================================================================================== 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-08-26 16:33:57,960] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Parameters: [param0=[sub_cd,CONSENT_MST]] [Logging Date Time: 2016-08-26 16:33:57,960] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Parameters: [param0=[sub_cd,CONSENT_MST]] [Logging Date Time: 2016-08-26 16:33:57,960] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-08-26 16:33:57,960] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-08-26 16:33:57,966] ===================================================================================== 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-08-26 16:33:57,966] ===================================================================================== 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-08-26 16:33:57,967] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Parameters: [param0=[ud1_num,129], param1=[sub_cd,CONSENT_MST]] [Logging Date Time: 2016-08-26 16:33:57,967] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Parameters: [param0=[ud1_num,129], param1=[sub_cd,CONSENT_MST]] [Logging Date Time: 2016-08-26 16:33:57,967] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String]] [Logging Date Time: 2016-08-26 16:33:57,967] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String]] [Logging Date Time: 2016-08-26 16:33:57,968] ===================================================================================== 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-08-26 16:33:57,968] ===================================================================================== 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-08-26 16:33:57,969] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Parameters: [param0=[sub_cd,CONSENT_DATA]] [Logging Date Time: 2016-08-26 16:33:57,969] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Parameters: [param0=[sub_cd,CONSENT_DATA]] [Logging Date Time: 2016-08-26 16:33:57,969] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-08-26 16:33:57,969] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-08-26 16:33:57,973] ===================================================================================== 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-08-26 16:33:57,973] ===================================================================================== 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-08-26 16:33:57,973] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Parameters: [param0=[ud1_num,165], param1=[sub_cd,CONSENT_DATA]] [Logging Date Time: 2016-08-26 16:33:57,973] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Parameters: [param0=[ud1_num,165], param1=[sub_cd,CONSENT_DATA]] [Logging Date Time: 2016-08-26 16:33:57,973] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String]] [Logging Date Time: 2016-08-26 16:33:57,973] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String]] [Logging Date Time: 2016-08-26 16:33:57,990] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_MST] PreparedStatement : [insert into CONSENT_MST ( CONSENT_MST_RID, HOS_TYPE, PID, VISIT_TYPE, ORDER_NO, ORDER_NAME, ORDER_CD, 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, CREATE_USER_ID, CREATE_DATETIME, MODIFY_USER_ID, MODIFY_DATETIME, CREATE_USER_NAME, MODIFY_USER_NAME ) values ( :param0 , :param1 , :param2 , :param3 , :param4 , :param5 , :param6 , :param7 , :param8 , :param9 , :param10 , :param11 , :param12 , :param13 , :param14 , :param15 , TO_CHAR(SYSDATE,'YYYY-MM-DD hh24:mi:ss'), :param16 , :param17 , :param18 , :param19 , :param20 , 'Y', :param21 , TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'), :param21 , TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'), :param22 , :param23 )] [Logging Date Time: 2016-08-26 16:33:57,990] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_MST] PreparedStatement : [insert into CONSENT_MST ( CONSENT_MST_RID, HOS_TYPE, PID, VISIT_TYPE, ORDER_NO, ORDER_NAME, ORDER_CD, 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, CREATE_USER_ID, CREATE_DATETIME, MODIFY_USER_ID, MODIFY_DATETIME, CREATE_USER_NAME, MODIFY_USER_NAME ) values ( :param0 , :param1 , :param2 , :param3 , :param4 , :param5 , :param6 , :param7 , :param8 , :param9 , :param10 , :param11 , :param12 , :param13 , :param14 , :param15 , TO_CHAR(SYSDATE,'YYYY-MM-DD hh24:mi:ss'), :param16 , :param17 , :param18 , :param19 , :param20 , 'Y', :param21 , TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'), :param21 , TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'), :param22 , :param23 )] [Logging Date Time: 2016-08-26 16:33:57,990] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_MST] Parameters: [param0=[consentMstRid,129], param1=[hosType,111], param2=[patientCode,0586244], param3=[vistType,I], param4=[orderNo,111], param5=[orderName,null], param6=[orderCd,null], param7=[ocrCode,2016082689390], param8=[clnDeptCd,2040000000], param9=[clnDate,20150615], param10=[cretno,1], param11=[ward,82], param12=[roomcd,832], param13=[formRid,184], param14=[consentState,ELECTR_CMP], param15=[completeYn,Y], param16=[paperYn,N], param17=[reissueYn,N], param18=[reissueConsentMstRid,0], param19=[rewriteYn,N], param20=[rewriteConsentMstRid,0], param21=[userId,103043], param22=[createUserName,이중기], param23=[modifyUserName,이중기]] [Logging Date Time: 2016-08-26 16:33:57,990] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_MST] Parameters: [param0=[consentMstRid,129], param1=[hosType,111], param2=[patientCode,0586244], param3=[vistType,I], param4=[orderNo,111], param5=[orderName,null], param6=[orderCd,null], param7=[ocrCode,2016082689390], param8=[clnDeptCd,2040000000], param9=[clnDate,20150615], param10=[cretno,1], param11=[ward,82], param12=[roomcd,832], param13=[formRid,184], param14=[consentState,ELECTR_CMP], param15=[completeYn,Y], param16=[paperYn,N], param17=[reissueYn,N], param18=[reissueConsentMstRid,0], param19=[rewriteYn,N], param20=[rewriteConsentMstRid,0], param21=[userId,103043], param22=[createUserName,이중기], param23=[modifyUserName,이중기]] [Logging Date Time: 2016-08-26 16:33:57,991] ===================================================================================== 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=[Int32, System.Int32], param5=[System.DBNull, null], param6=[System.DBNull, null], param7=[AnsiString, System.String], param8=[AnsiString, System.String], param9=[AnsiString, System.String], param10=[Int32, System.Int32], param11=[AnsiString, System.String], param12=[AnsiString, System.String], param13=[Int32, System.Int32], param14=[AnsiString, System.String], param15=[AnsiString, System.String], param16=[AnsiString, System.String], param17=[AnsiString, System.String], param18=[Int32, System.Int32], param19=[AnsiString, System.String], param20=[Int32, System.Int32], param21=[AnsiString, System.String], param22=[AnsiString, System.String], param23=[AnsiString, System.String]] [Logging Date Time: 2016-08-26 16:33:57,991] ===================================================================================== 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=[Int32, System.Int32], param5=[System.DBNull, null], param6=[System.DBNull, null], param7=[AnsiString, System.String], param8=[AnsiString, System.String], param9=[AnsiString, System.String], param10=[Int32, System.Int32], param11=[AnsiString, System.String], param12=[AnsiString, System.String], param13=[Int32, System.Int32], param14=[AnsiString, System.String], param15=[AnsiString, System.String], param16=[AnsiString, System.String], param17=[AnsiString, System.String], param18=[Int32, System.Int32], param19=[AnsiString, System.String], param20=[Int32, System.Int32], param21=[AnsiString, System.String], param22=[AnsiString, System.String], param23=[AnsiString, System.String]] [Logging Date Time: 2016-08-26 16:33:58,052] ===================================================================================== 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-08-26 16:33:58,052] ===================================================================================== 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-08-26 16:33:58,052] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_DATA] Parameters: [param0=[consentDataRid,165], param1=[consentMstRid,129], param2=[formRid,184], param3=[deviceType,WIN], param4=[deviceIdentNo,CHLEE-PC], param5=[completeYn,Y], param6=[userId,103043], param7=[formXml,System.Byte[]], param8=[dataXml,System.Byte[]]] [Logging Date Time: 2016-08-26 16:33:58,052] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_DATA] Parameters: [param0=[consentDataRid,165], param1=[consentMstRid,129], param2=[formRid,184], param3=[deviceType,WIN], param4=[deviceIdentNo,CHLEE-PC], param5=[completeYn,Y], param6=[userId,103043], param7=[formXml,System.Byte[]], param8=[dataXml,System.Byte[]]] [Logging Date Time: 2016-08-26 16:33:58,052] ===================================================================================== 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-08-26 16:33:58,052] ===================================================================================== 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-08-26 16:33:58,178] ===================================================================================== SQL Command - Statement Id: [SET_MEDI_HISTORY] PreparedStatement : [DECLARE v_cnt NUMBER:=0; BEGIN SELECT COUNT(*) INTO V_CNT FROM CONSENT_DATA_EX WHERE PID = :param0 AND CLN_DATE = :param1 ; IF v_cnt = 0 THEN insert into consent_data_ex (pid, cln_date, use_yn, bp, dm, heart, kidney, respiration, hx, allergy, drug, smoking, idio, nacrotics, airway, hemorrhage, etc, create_user_id, create_datetime, modify_user_id, modify_datetime) values ( :param0 , :param1 ,'Y', :param2 , :param3 , :param4 , :param5 , :param6 , :param7 , :param8 , :param9 , :param10 , :param11 , :param12 , :param13 , :param14 , :param15 , :param16 , TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'), :param16 , TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss')); ELSE update consent_data_ex set bp = :param2 , dm = :param3 , heart = :param4 , kidney = :param5 , respiration = :param6 , hx = :param7 , allergy = :param8 , drug = :param9 , smoking = :param10 , idio = :param11 , nacrotics = :param12 , airway = :param13 , hemorrhage = :param14 , etc = :param15 , modify_user_id = :param16 , modify_datetime = TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss') where PID = :param0 AND CLN_DATE = :param1 ; END IF; END;] [Logging Date Time: 2016-08-26 16:33:58,178] ===================================================================================== SQL Command - Statement Id: [SET_MEDI_HISTORY] PreparedStatement : [DECLARE v_cnt NUMBER:=0; BEGIN SELECT COUNT(*) INTO V_CNT FROM CONSENT_DATA_EX WHERE PID = :param0 AND CLN_DATE = :param1 ; IF v_cnt = 0 THEN insert into consent_data_ex (pid, cln_date, use_yn, bp, dm, heart, kidney, respiration, hx, allergy, drug, smoking, idio, nacrotics, airway, hemorrhage, etc, create_user_id, create_datetime, modify_user_id, modify_datetime) values ( :param0 , :param1 ,'Y', :param2 , :param3 , :param4 , :param5 , :param6 , :param7 , :param8 , :param9 , :param10 , :param11 , :param12 , :param13 , :param14 , :param15 , :param16 , TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'), :param16 , TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss')); ELSE update consent_data_ex set bp = :param2 , dm = :param3 , heart = :param4 , kidney = :param5 , respiration = :param6 , hx = :param7 , allergy = :param8 , drug = :param9 , smoking = :param10 , idio = :param11 , nacrotics = :param12 , airway = :param13 , hemorrhage = :param14 , etc = :param15 , modify_user_id = :param16 , modify_datetime = TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss') where PID = :param0 AND CLN_DATE = :param1 ; END IF; END;] [Logging Date Time: 2016-08-26 16:33:58,179] ===================================================================================== SQL Command - Statement Id: [SET_MEDI_HISTORY] Parameters: [param0=[patientCode,0586244], param1=[clnDate,20150615], param2=[bp,01], param3=[dm,01], param4=[heart,01], param5=[kidney,01], param6=[respiration,02], param7=[hx,02], param8=[allergy,02], param9=[drug,02], param10=[smoking,02], param11=[idio,02], param12=[nacrotics,02], param13=[airway,02], param14=[hemorrhage,02], param15=[status_etc,어쩌구], param16=[userId,103043]]