[Logging Date Time: 2016-11-10 10:21:33,520] ===================================================================================== 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-11-10 10:21:33,520] ===================================================================================== 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-11-10 10:21:33,616] ===================================================================================== SQL Command - Statement Id: [getDeptList] Parameters: [param0=[instcd,111]] [Logging Date Time: 2016-11-10 10:21:33,616] ===================================================================================== SQL Command - Statement Id: [getDeptList] Parameters: [param0=[instcd,111]] [Logging Date Time: 2016-11-10 10:21:33,616] ===================================================================================== SQL Command - Statement Id: [getDeptList] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 10:21:33,616] ===================================================================================== SQL Command - Statement Id: [getDeptList] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 10:21:33,901] ===================================================================================== 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-11-10 10:21:33,901] ===================================================================================== 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-11-10 10:21:33,902] ===================================================================================== SQL Command - Statement Id: [getDocList] Parameters: [param0=[instcd,111], param1=[orddeptcd, ], param2=[srchdd,20161110]] [Logging Date Time: 2016-11-10 10:21:33,902] ===================================================================================== SQL Command - Statement Id: [getDocList] Parameters: [param0=[instcd,111], param1=[orddeptcd, ], param2=[srchdd,20161110]] [Logging Date Time: 2016-11-10 10:21:33,902] ===================================================================================== SQL Command - Statement Id: [getDocList] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 10:21:33,902] ===================================================================================== SQL Command - Statement Id: [getDocList] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 10:21:34,643] ===================================================================================== SQL Command - Statement Id: [GET_USER_INFO] PreparedStatement : [select a.userid, a.usernm, b.dutplcecd, dept.depthngnm, dept.deptengabbr, b.jobkindcd, (select cdnm from com.zbcmcode code where code.cdgrupid = 'R0061' and code.cdid = b.jobkindcd and code.valitodd = '99991231') from com.zsumusrb a, com.zsumusrd b, com.zsdddept dept where a.dutinstcd = '111' and a.dutinstcd = b.dutplceinstcd and a.userid = b.userid and a.usertodd = b.todd and dept.instcd = a.dutinstcd and dept.deptcd = b.dutplcecd and dept.valitodd = '99991231' and b.psnworkyn = 'Y' and a.usertodd = '99991231' and b.userid = :param0] [Logging Date Time: 2016-11-10 10:21:34,643] ===================================================================================== SQL Command - Statement Id: [GET_USER_INFO] PreparedStatement : [select a.userid, a.usernm, b.dutplcecd, dept.depthngnm, dept.deptengabbr, b.jobkindcd, (select cdnm from com.zbcmcode code where code.cdgrupid = 'R0061' and code.cdid = b.jobkindcd and code.valitodd = '99991231') from com.zsumusrb a, com.zsumusrd b, com.zsdddept dept where a.dutinstcd = '111' and a.dutinstcd = b.dutplceinstcd and a.userid = b.userid and a.usertodd = b.todd and dept.instcd = a.dutinstcd and dept.deptcd = b.dutplcecd and dept.valitodd = '99991231' and b.psnworkyn = 'Y' and a.usertodd = '99991231' and b.userid = :param0] [Logging Date Time: 2016-11-10 10:21:34,643] ===================================================================================== SQL Command - Statement Id: [GET_USER_INFO] Parameters: [param0=[userid,105066]] [Logging Date Time: 2016-11-10 10:21:34,643] ===================================================================================== SQL Command - Statement Id: [GET_USER_INFO] Parameters: [param0=[userid,105066]] [Logging Date Time: 2016-11-10 10:21:34,643] ===================================================================================== SQL Command - Statement Id: [GET_USER_INFO] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 10:21:34,643] ===================================================================================== SQL Command - Statement Id: [GET_USER_INFO] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 10:21:34,779] ===================================================================================== 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.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 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.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 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 emr.mmohoprs oprs on (oprs.pid = a.pid and oprs.ophistcd = 'O' and opcnfmdd >= a.orddd ) 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 10:21:34,779] ===================================================================================== 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.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 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.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 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 emr.mmohoprs oprs on (oprs.pid = a.pid and oprs.ophistcd = 'O' and opcnfmdd >= a.orddd ) 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 10:21:34,780] ===================================================================================== SQL Command - Statement Id: [getPatientInfoOut] Parameters: [param0=[instcd,111], param1=[pid,1715813], param2=[orddd,20161110], param3=[cretno,1]] [Logging Date Time: 2016-11-10 10:21:34,780] ===================================================================================== SQL Command - Statement Id: [getPatientInfoOut] Parameters: [param0=[instcd,111], param1=[pid,1715813], param2=[orddd,20161110], param3=[cretno,1]] [Logging Date Time: 2016-11-10 10:21:34,780] ===================================================================================== 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 10:21:34,780] ===================================================================================== 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 10:21:35,146] ===================================================================================== 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-11-10 10:21:35,146] ===================================================================================== 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-11-10 10:21:35,146] ===================================================================================== SQL Command - Statement Id: [GET_TRMT_DATE_LIST] Parameters: [param0=[instcd,111], param1=[pid,1715813], param2=[searchClnDate,20161110]] [Logging Date Time: 2016-11-10 10:21:35,146] ===================================================================================== SQL Command - Statement Id: [GET_TRMT_DATE_LIST] Parameters: [param0=[instcd,111], param1=[pid,1715813], param2=[searchClnDate,20161110]] [Logging Date Time: 2016-11-10 10:21:35,146] ===================================================================================== 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-11-10 10:21:35,146] ===================================================================================== 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-11-10 10:21:35,245] ===================================================================================== 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.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 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.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 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 emr.mmohoprs oprs on (oprs.pid = a.pid and oprs.ophistcd = 'O' and opcnfmdd >= a.orddd ) 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 10:21:35,245] ===================================================================================== 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.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 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.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 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 emr.mmohoprs oprs on (oprs.pid = a.pid and oprs.ophistcd = 'O' and opcnfmdd >= a.orddd ) 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 10:21:35,246] ===================================================================================== SQL Command - Statement Id: [getPatientInfoOut] Parameters: [param0=[instcd,111], param1=[pid,1715813], param2=[orddd,20161110], param3=[cretno,1]] [Logging Date Time: 2016-11-10 10:21:35,246] ===================================================================================== SQL Command - Statement Id: [getPatientInfoOut] Parameters: [param0=[instcd,111], param1=[pid,1715813], param2=[orddd,20161110], param3=[cretno,1]] [Logging Date Time: 2016-11-10 10:21:35,246] ===================================================================================== 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 10:21:35,246] ===================================================================================== 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 10:21:35,342] ===================================================================================== 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.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 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.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 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 emr.mmohoprs oprs on (oprs.pid = a.pid and oprs.ophistcd = 'O' and opcnfmdd >= a.orddd ) 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 10:21:35,342] ===================================================================================== 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.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 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.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 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 emr.mmohoprs oprs on (oprs.pid = a.pid and oprs.ophistcd = 'O' and opcnfmdd >= a.orddd ) 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 10:21:35,343] ===================================================================================== SQL Command - Statement Id: [getPatientInfoOut] Parameters: [param0=[instcd,111], param1=[pid,1715813], param2=[orddd,20161110], param3=[cretno,1]] [Logging Date Time: 2016-11-10 10:21:35,343] ===================================================================================== SQL Command - Statement Id: [getPatientInfoOut] Parameters: [param0=[instcd,111], param1=[pid,1715813], param2=[orddd,20161110], param3=[cretno,1]] [Logging Date Time: 2016-11-10 10:21:35,343] ===================================================================================== 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 10:21:35,343] ===================================================================================== 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 10:21:35,432] ===================================================================================== 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.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 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.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 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 emr.mmohoprs oprs on (oprs.pid = a.pid and oprs.ophistcd = 'O' and opcnfmdd >= a.orddd ) 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 10:21:35,432] ===================================================================================== 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.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 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.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 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 emr.mmohoprs oprs on (oprs.pid = a.pid and oprs.ophistcd = 'O' and opcnfmdd >= a.orddd ) 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 10:21:35,433] ===================================================================================== SQL Command - Statement Id: [getPatientInfoOut] Parameters: [param0=[instcd,111], param1=[pid,1715813], param2=[orddd,20161110], param3=[cretno,1]] [Logging Date Time: 2016-11-10 10:21:35,433] ===================================================================================== SQL Command - Statement Id: [getPatientInfoOut] Parameters: [param0=[instcd,111], param1=[pid,1715813], param2=[orddd,20161110], param3=[cretno,1]] [Logging Date Time: 2016-11-10 10:21:35,433] ===================================================================================== 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 10:21:35,433] ===================================================================================== 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 10:21:35,526] ===================================================================================== 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-11-10 10:21:35,526] ===================================================================================== 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-11-10 10:21:35,527] ===================================================================================== SQL Command - Statement Id: [GET_TRMT_DATE_LIST] Parameters: [param0=[instcd,111], param1=[pid,1715813], param2=[searchClnDate,20161110]] [Logging Date Time: 2016-11-10 10:21:35,527] ===================================================================================== SQL Command - Statement Id: [GET_TRMT_DATE_LIST] Parameters: [param0=[instcd,111], param1=[pid,1715813], param2=[searchClnDate,20161110]] [Logging Date Time: 2016-11-10 10:21:35,527] ===================================================================================== 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-11-10 10:21:35,527] ===================================================================================== 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-11-10 10:21:35,584] ===================================================================================== 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.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 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.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 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 emr.mmohoprs oprs on (oprs.pid = a.pid and oprs.ophistcd = 'O' and opcnfmdd >= a.orddd ) 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 10:21:35,584] ===================================================================================== 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.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 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.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 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 emr.mmohoprs oprs on (oprs.pid = a.pid and oprs.ophistcd = 'O' and opcnfmdd >= a.orddd ) 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 10:21:35,584] ===================================================================================== SQL Command - Statement Id: [getPatientInfoOut] Parameters: [param0=[instcd,111], param1=[pid,1715813], param2=[orddd,20161110], param3=[cretno,1]] [Logging Date Time: 2016-11-10 10:21:35,584] ===================================================================================== SQL Command - Statement Id: [getPatientInfoOut] Parameters: [param0=[instcd,111], param1=[pid,1715813], param2=[orddd,20161110], param3=[cretno,1]] [Logging Date Time: 2016-11-10 10:21:35,585] ===================================================================================== 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 10:21:35,585] ===================================================================================== 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 10:21:35,659] ===================================================================================== 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.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 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.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 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 emr.mmohoprs oprs on (oprs.pid = a.pid and oprs.ophistcd = 'O' and opcnfmdd >= a.orddd ) 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 10:21:35,659] ===================================================================================== 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.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 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.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 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 emr.mmohoprs oprs on (oprs.pid = a.pid and oprs.ophistcd = 'O' and opcnfmdd >= a.orddd ) 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 10:21:35,660] ===================================================================================== SQL Command - Statement Id: [getPatientInfoOut] Parameters: [param0=[instcd,111], param1=[pid,1715813], param2=[orddd,20161110], param3=[cretno,1]] [Logging Date Time: 2016-11-10 10:21:35,660] ===================================================================================== SQL Command - Statement Id: [getPatientInfoOut] Parameters: [param0=[instcd,111], param1=[pid,1715813], param2=[orddd,20161110], param3=[cretno,1]] [Logging Date Time: 2016-11-10 10:21:35,660] ===================================================================================== 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 10:21:35,660] ===================================================================================== 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 10:21:36,377] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_LIST] PreparedStatement : [SELECT CM.CONSENT_MST_RID , DECODE(CM.CONSENT_STATE, 'TEMP' ,'임시저장', 'ELECTR_CMP', '서명', 'PAPER_OUT', '출력' , 'CERTIFY_CMP', '인증', 'UNFINISHED', '미작성', 'VERBAL', '구두') AS CONSENT_STATE_DISP , VEF.FORM_NAME AS CONSENT_NAME , CM.HOS_TYPE , CM.PID , CM.VISIT_TYPE , CM.ORDER_NO , CM.ORDER_CD , CM.ORDER_NAME , CM.CLN_DEPT_CD , (SELECT DEPTHNGNM FROM COM.ZSDDDEPT WHERE DEPTCD = CM.CLN_DEPT_CD and valitodd = '99991231' and instcd = '111') AS CLN_DEPT_NM , COM.FN_ZS_GETDEPTNAME('111', (select dept.deptcd from com.zsdddept dept where dept.instcd = '111' and dept.valitodd = '99991231' and dept.deptengabbr = CM.WARDCD), '99991231') as WARDCD , CM.ROOMCD , CM.FORM_RID , VEF.FORM_CD , VEF.FORM_GUID , C.PRNTCNT , CM.CONSENT_STATE AS CONSENT_STATE , CM.OCR_NUMBER , CM.COSIGN_DC_ID , CM.COSIGN_DC_NAME , CM.MODIFY_USER_ID AS CREATE_USER_ID , CM.MODIFY_USER_NAME AS CREATE_USER_NAME , CM.MODIFY_DATETIME AS CREATE_DATETIME , CM.CLN_DATE , CM.CRETNO , (SELECT OCRTAGPRNTYN FROM V_EFORM_FORMDOC F WHERE F.FORM_RID = CM.FORM_RID ) AS OCRTAGPRNTYN FROM CONSENT_MST CM INNER JOIN EFORM_DOCUMENT VEF ON VEF.FORM_RID = CM.FORM_RID, EMR.MRFMFORM C WHERE CM.USE_YN = 'Y' AND CM.PID = :param0 AND TO_CHAR(TO_DATE(CM.CREATE_DATETIME, 'YYYY-MM-DD HH24:MI:SS'), 'YYYYMMDD') BETWEEN :param1 and :param2 AND VEF.FORM_CD = C.FORMCD AND C.instcd = '111' AND C.formprogflag LIKE 'OCR%' AND C.formlevlcd != '-' AND SUBSTR (C.formtodt, 1, 8) = '99991231' AND CM.CONSENT_STATE IN ('UNFINISHED','TEMP') ORDER BY CONSENT_STATE DESC, CREATE_DATETIME DESC] [Logging Date Time: 2016-11-10 10:21:36,377] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_LIST] PreparedStatement : [SELECT CM.CONSENT_MST_RID , DECODE(CM.CONSENT_STATE, 'TEMP' ,'임시저장', 'ELECTR_CMP', '서명', 'PAPER_OUT', '출력' , 'CERTIFY_CMP', '인증', 'UNFINISHED', '미작성', 'VERBAL', '구두') AS CONSENT_STATE_DISP , VEF.FORM_NAME AS CONSENT_NAME , CM.HOS_TYPE , CM.PID , CM.VISIT_TYPE , CM.ORDER_NO , CM.ORDER_CD , CM.ORDER_NAME , CM.CLN_DEPT_CD , (SELECT DEPTHNGNM FROM COM.ZSDDDEPT WHERE DEPTCD = CM.CLN_DEPT_CD and valitodd = '99991231' and instcd = '111') AS CLN_DEPT_NM , COM.FN_ZS_GETDEPTNAME('111', (select dept.deptcd from com.zsdddept dept where dept.instcd = '111' and dept.valitodd = '99991231' and dept.deptengabbr = CM.WARDCD), '99991231') as WARDCD , CM.ROOMCD , CM.FORM_RID , VEF.FORM_CD , VEF.FORM_GUID , C.PRNTCNT , CM.CONSENT_STATE AS CONSENT_STATE , CM.OCR_NUMBER , CM.COSIGN_DC_ID , CM.COSIGN_DC_NAME , CM.MODIFY_USER_ID AS CREATE_USER_ID , CM.MODIFY_USER_NAME AS CREATE_USER_NAME , CM.MODIFY_DATETIME AS CREATE_DATETIME , CM.CLN_DATE , CM.CRETNO , (SELECT OCRTAGPRNTYN FROM V_EFORM_FORMDOC F WHERE F.FORM_RID = CM.FORM_RID ) AS OCRTAGPRNTYN FROM CONSENT_MST CM INNER JOIN EFORM_DOCUMENT VEF ON VEF.FORM_RID = CM.FORM_RID, EMR.MRFMFORM C WHERE CM.USE_YN = 'Y' AND CM.PID = :param0 AND TO_CHAR(TO_DATE(CM.CREATE_DATETIME, 'YYYY-MM-DD HH24:MI:SS'), 'YYYYMMDD') BETWEEN :param1 and :param2 AND VEF.FORM_CD = C.FORMCD AND C.instcd = '111' AND C.formprogflag LIKE 'OCR%' AND C.formlevlcd != '-' AND SUBSTR (C.formtodt, 1, 8) = '99991231' AND CM.CONSENT_STATE IN ('UNFINISHED','TEMP') ORDER BY CONSENT_STATE DESC, CREATE_DATETIME DESC] [Logging Date Time: 2016-11-10 10:21:36,377] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_LIST] Parameters: [param0=[patientCode,1715813], param1=[startDt,20010601], param2=[endDt,20161110]] [Logging Date Time: 2016-11-10 10:21:36,377] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_LIST] Parameters: [param0=[patientCode,1715813], param1=[startDt,20010601], param2=[endDt,20161110]] [Logging Date Time: 2016-11-10 10:21:36,377] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_LIST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 10:21:36,377] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_LIST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 10:21:36,700] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] PreparedStatement : [SELECT signdata FROM emr.mrfmsignimge WHERE userid = :param0 and repryn = 'Y'] [Logging Date Time: 2016-11-10 10:21:36,700] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] PreparedStatement : [SELECT signdata FROM emr.mrfmsignimge WHERE userid = :param0 and repryn = 'Y'] [Logging Date Time: 2016-11-10 10:21:36,700] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] Parameters: [param0=[userid,105066]] [Logging Date Time: 2016-11-10 10:21:36,700] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] Parameters: [param0=[userid,105066]] [Logging Date Time: 2016-11-10 10:21:36,700] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 10:21:36,700] ===================================================================================== SQL Command - Statement Id: [getUserSignImage] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 10:21:41,770] ===================================================================================== 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-11-10 10:21:41,770] ===================================================================================== 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-11-10 10:21:41,770] ===================================================================================== SQL Command - Statement Id: [getDeptList] Parameters: [param0=[instcd,111]] [Logging Date Time: 2016-11-10 10:21:41,770] ===================================================================================== SQL Command - Statement Id: [getDeptList] Parameters: [param0=[instcd,111]] [Logging Date Time: 2016-11-10 10:21:41,770] ===================================================================================== SQL Command - Statement Id: [getDeptList] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 10:21:41,770] ===================================================================================== SQL Command - Statement Id: [getDeptList] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 10:21:41,900] ===================================================================================== 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-11-10 10:21:41,900] ===================================================================================== 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-11-10 10:21:41,901] ===================================================================================== SQL Command - Statement Id: [getDocList] Parameters: [param0=[instcd,111], param1=[orddeptcd, ], param2=[srchdd,20161110]] [Logging Date Time: 2016-11-10 10:21:41,901] ===================================================================================== SQL Command - Statement Id: [getDocList] Parameters: [param0=[instcd,111], param1=[orddeptcd, ], param2=[srchdd,20161110]] [Logging Date Time: 2016-11-10 10:21:41,901] ===================================================================================== SQL Command - Statement Id: [getDocList] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 10:21:41,901] ===================================================================================== SQL Command - Statement Id: [getDocList] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 10:23:15,420] ===================================================================================== SQL Command - CLIP.eForm SaveTempData param : clnDept[105066]patientCode[1715813]clnDeptCode[2010400000]formRid[1307]formCd[1300010589]consentMstRid[1842]rewriteConsentMstRid[0]deviceType[WIN]vistType[O]hosType[111]clnDate[20161110]ward[]roomcd[]orderNo[111]orderName[코감기]orderCd[J00.000.08]ocrCode[2016111063775]cretno[1]createUserName[이봉렬]modifyUserName[이봉렬]deviceIdentNo[16-101-33]mainDrId[105066]dataXml[460,2204,460,2204?455,2204,452,2204?450,2201,447,2201?444,2199,442,2196?442,2191,439,2185?434,2180,434,2172?434,2167,434,2156?439,2148,442,2138?444,2125,450,2111?455,2098,460,2085?471,2069,479,2056?487,2040,500,2027?511,2011,521,1995?532,1982,542,1966?556,1953,564,1939?577,1929,585,1918?593,1908,603,1900?609,1894,614,1894?616,1894,619,1894?622,1900,622,1905?619,1918,619,1929?616,1945,611,1958?609,1976,603,1995?595,2016,590,2040?585,2061,579,2085?577,2109,569,2130?564,2154,561,2172?558,2191,558,2201?558,2209,558,2215?561,2215,564,2212?569,2204,577,2193?582,2180,590,2167?595,2151,606,2138?614,2122,619,2111?627,2098,635,2088?643,2077,648,2072?651,2066,659,2061?664,2058,667,2058?669,2058,672,2058?675,2061,677,2066?677,2069,680,2074?680,2085,680,2093?685,2101,685,2111?685,2119,688,2130?688,2140,691,2148?691,2156,693,2159?696,2167,698,2167?701,2167,704,2159?706,2156,714,2148?717,2140,722,2130?728,2119,730,2111?736,2101,743,2090?749,2085,754,2074?759,2072,762,2066?770,2064,773,2064?773,2061,775,2064?778,2064,778,2066?781,2069,781,2072?783,2074,783,2077?783,2085,786,2088?788,2090,788,2096?791,2098,791,2101?796,2109,799,2111?799,2114,802,2117?804,2117,804,2119?807,2122,807,2122?810,2125,812,2125?812,2125,815,2125?818,2122,823,2119?826,2117,831,2114?833,2111,836,2103?839,2101,841,2098?844,2096466,1254,466,1254?460,1262,458,1265?458,1265,458,1265?458,1265,458,1265?458,1265,458,1265?460,1265,460,1262?468,1254,471,1249?476,1244,484,1236?495,1222,503,1214?508,1206,516,1196?527,1188,534,1180?542,1172,550,1167?556,1159,564,1154?569,1151,572,1143?579,1140,582,1138?582,1138,582,1138?582,1138,582,1138?582,1140,579,1140?579,1146,577,1151?569,1156,566,1162?561,1169,558,1177?556,1185,553,1193?548,1201,548,1212?542,1217,542,1225?542,1233,542,1238?542,1244,542,1246?548,1249,550,1251?553,1251,556,1251?558,1251,561,1251?566,1251,569,1249?569,1249,572,1249?572,1249,577,1246?577,1246,579,1249?579,1249,579,1251?582,1257,582,1262?582,1267,582,1273?582,1275,582,1281669,1217,669,1217?672,1217,675,1214?677,1214,680,1212?680,1212,685,1212?688,1209,691,1209?691,1206,693,1206?696,1201,698,1201?701,1199,701,1199?704,1196640,1601,640,1601?632,1609,624,1619?619,1625,614,1632?609,1638,603,1646?598,1648,598,1648?598,1648,598,1648?598,1648,598,1648?603,1646,609,1638?614,1632,622,1627?632,1619,643,1609?651,1601,661,1593?672,1582,680,1574?691,1566,698,1561?706,1550,714,1548?722,1543,728,1540?730,1535,736,1535?741,1529,743,1529?743,1527,743,1527?743,1527,746,1529?746,1529,746,1535?746,1537,746,1540?746,1543,743,1545?743,1550,743,1553?741,1561,741,1564?741,1572,743,1577?743,1582,743,1593?743,1601,746,1609?746,1619,746,1627?746,1632,749,1643?749,1648,751,1656?754,1662,754,1664?757,1672,759,1675857,1638,857,1638?860,1638,860,1638?863,1635,865,1635?865,1635,868,1635?868,1635,870,1632?870,1632,873,1630?873,1627,878,1625?881,1622,884,1619?884,1617,886,1609?889,1603,892,1601?894,1595,894,1590?897,1580,897,1574?900,1569,900,1566?900,1561,900,1556?900,1553,900,1550?897,1548,897,1548?897,1548,894,1548?892,1548,892,1550?889,1553,886,1556?884,1561,884,1566?881,1569,881,1574?878,1580,878,1585?881,1590,881,1595?884,1601,886,1603?886,1606,892,1606?894,1609,897,1609?905,1606,910,1606?915,1603,921,1598?926,1595,937,1590?942,1585,945,1580?950,1572995,1482,995,1482?995,1479,995,1479?995,1479,995,1474?995,1479,992,1479?992,1482,992,1484?990,1490,987,1495?987,1500,982,1508?982,1513,982,1519?982,1521,982,1527?987,1529,987,1529?990,1535,992,1535?995,1535,1000,1529?1005,1529,1008,1527?1016,1527,1021,1524?1027,1521,1032,1521?1035,1519,1037,1519?1042,1519,1042,1519?1045,1519,1045,1519?1045,1521,1045,1524?1045,1527,1042,1529?1037,1535,1037,1540?1035,1543,1032,1548?1032,1550,1029,1553?1029,1553,1029,15531130,1397,1130,1397?1132,1389,1138,1386?1140,1384,1146,1381?1151,1381,1151,1381?1154,1381,1156,1381?1156,1381,1156,1381?1159,1384,1159,1384?1159,1389,1159,1392?1159,1397,1159,1402?1159,1408,1159,1413?1159,1418,1162,1426?1162,1431,1162,1434?1164,1439,1164,1442?1167,1445,1169,1447?1172,1447,1177,1453?1180,1453,1185,1453?1191,1447,1196,1447?1206,1445,1212,1442?1220,1439,1225,1434?1236,1431,1241,1429?1249,1426,1254,1421?1265,1416,1270,1416?1275,1413,1278,1410?1281,1408,1281,1408?1281,1408,1281,14081159,1460,1159,1460?1156,1463,1154,1466?1154,1466,1154,1468?1154,1468,1154,1468?1156,1466,1162,1463?1167,1460,1172,1458?1180,1455,1188,1447?1193,1445,1199,1439?1209,1437,1214,1431?1220,1429,1225,1426?1233,1421881,2267,881,2267?878,2273,878,2273?878,2273,878,2273?878,2273,878,2273?873,2267,873,2267?878,2265,878,2265?881,2262,884,2257?889,2254,894,2249?900,2241,908,2236?915,2228,923,2220?934,2207,945,2199?955,2185,966,2178?976,2167,990,2154?997,2146,1005,2138?1016,21301024,2103,1024,2103?1019,2109,1013,2114?1003,2117,1000,2122?997,2125,992,2127?990,2133,987,2138?982,2143,979,2148?979,2154,976,2159?976,2170,976,2178?976,2185,976,2199?976,2209,976,2225?979,2238,979,2254?982,2273,987,2289?987,2307,990,2323?992,2342,995,2363?997,2376,1000,2394?1003,2410,1005,2421?1008,2432,1013,2442?1016,2447,1019,2453?1021,2453,1024,24551106,2275,1106,2275?1109,2275,1109,2275?1109,2278,1109,2281?1109,2283,1106,2286?1106,2291,1103,2294?1103,2302,1103,2305?1103,2307,1103,2307?1106,2307,1106,2307?1109,2307,1111,2305?1114,2302,1119,2297?1124,2291,1130,2283?1135,2278,1138,2267?1143,2257,1146,2249?1154,2236,1156,2225?1162,2215,1164,2204?1167,2196,1169,2183?1169,2178,1172,2170?1172,2164,1172,2159?1172,2156,1169,2154?1167,2154,1164,2154?1162,2154,1159,2156?1154,2164,1146,2170?1143,2175,1138,2183?1132,2193,1130,2201?1124,2209,1119,2220?1117,2230,1114,2238?1111,2249,1111,2260?1109,2267,1109,2275?1111,2283,1111,2291?1114,2297,1117,2305?1124,2307,1127,2312?1132,2312,1138,2315?1143,2315,1151,2312?1159,2312,1164,2307?1172,2305,1180,22971315,2119,1315,2119?1315,2119,1315,2119?1315,2117,1315,2119?1310,2122,1310,2125?1304,2130,1302,2138?1296,2146,1291,2156?1283,2167,1278,2175?1273,2185,1270,2196?1265,2207,1262,2215?1257,2222,1257,2228?1262,2230,1262,2233?1265,2233,1270,2230?1275,2228,1281,2225?1291,2220,1296,2212?1304,2207,1310,2201?1320,2199,1326,2193?1331,2191,1334,2191?1336,2191,1339,2191?1344,2193,1344,2196?1344,2199,1344,2204?1339,2209,1336,2215?1334,2225,1328,2233?1323,2241,1318,2252?1310,2260,1304,2267?1299,2281,1291,2289?1283,2297,1278,2305?1273,2310,1267,23151357,2008,1357,2008?1363,1995,1371,1984?1376,1974,1381,1963?1384,1953,1386,1945?1392,1937,1397,1931?1400,1926,1400,1921?1400,1921,1400,1921?1402,1921,1402,1921?1402,1924,1402,1929?1402,1934,1400,1945?1400,1955,1397,1966?1392,1979,1389,1992?1389,2008,1386,2021?1384,2037,1384,2056?1381,2069,1381,2085?1384,2098,1384,2111?1386,2122,1389,2127?1392,2138,1397,2140?1400,2143,1402,2146?1408,2146,1413,2146?1416,2146,1421,2146?1426,2143,1431,2143?1434,2140,1437,2140?1439,2138,1442,2138?1445,2133,1445,2133?1447,2130,1447,2127?1447,2127,1445,2125?1445,2122,1442,2119?1437,2114,1434,2111?1429,2109,1426,2103?1416,2101,1410,2096?1405,2093,1397,2090?1386,2090,1378,2088?1371,2088,1360,2088?1349,2088,1339,2088?1331,2088,1323,2090?1318,2090,1310,20931606,2170,1606,2170?1603,2172,1603,2178?1601,2180,1598,2180?1598,2183,1598,2183?1598,2183,1598,2183?1598,2183,1598,2183?1598,2183,1598,2183?1601,2180,1603,2178?1606,2172,1611,2167?1619,2159,1625,2151?1630,2140,1635,2130?1646,2119,1651,2109?1656,2096,1659,2085?1662,2072,1667,2061?1672,2045,1672,2032?1675,2019,1677,2006?1677,1987,1680,1974?1680,1955,1680,1939?1683,1926,1683,1910?1683,1897,1683,1884?1680,1876,1680,1868?1677,1857,1677,1852?1675,1847,1672,1844?1667,1842,1662,1839?1659,1836,1654,1836?1651,1836,1646,1839?1643,1842,1635,1847?1632,1852,1627,1863?1625,1871,1622,1881?1619,1894,1617,1908?1611,1924,1611,1937?1611,1953,1617,1968?1619,1987,1622,2003?1625,2016,1630,2032?1635,2045,1646,2061?1651,2072,1659,2085?1667,2093,1677,2103?1685,2114,1691,2119?1701,2125,1709,2130?1714,2138,1720,2140?1728,2143,1733,2146?1736,2148,1738,21511550,1995,1550,1995?1550,1995,1550,1995?1550,1995,1553,1992?1564,1990,1572,1984?1582,1976,1598,1966?1617,1958,1632,1947?1651,1934,1675,1924?1693,1908,1717,1897?1741,1884,1765,1873?1786,1863]formXml[
460,2204,460,2204?455,2204,452,2204?450,2201,447,2201?444,2199,442,2196?442,2191,439,2185?434,2180,434,2172?434,2167,434,2156?439,2148,442,2138?444,2125,450,2111?455,2098,460,2085?471,2069,479,2056?487,2040,500,2027?511,2011,521,1995?532,1982,542,1966?556,1953,564,1939?577,1929,585,1918?593,1908,603,1900?609,1894,614,1894?616,1894,619,1894?622,1900,622,1905?619,1918,619,1929?616,1945,611,1958?609,1976,603,1995?595,2016,590,2040?585,2061,579,2085?577,2109,569,2130?564,2154,561,2172?558,2191,558,2201?558,2209,558,2215?561,2215,564,2212?569,2204,577,2193?582,2180,590,2167?595,2151,606,2138?614,2122,619,2111?627,2098,635,2088?643,2077,648,2072?651,2066,659,2061?664,2058,667,2058?669,2058,672,2058?675,2061,677,2066?677,2069,680,2074?680,2085,680,2093?685,2101,685,2111?685,2119,688,2130?688,2140,691,2148?691,2156,693,2159?696,2167,698,2167?701,2167,704,2159?706,2156,714,2148?717,2140,722,2130?728,2119,730,2111?736,2101,743,2090?749,2085,754,2074?759,2072,762,2066?770,2064,773,2064?773,2061,775,2064?778,2064,778,2066?781,2069,781,2072?783,2074,783,2077?783,2085,786,2088?788,2090,788,2096?791,2098,791,2101?796,2109,799,2111?799,2114,802,2117?804,2117,804,2119?807,2122,807,2122?810,2125,812,2125?812,2125,815,2125?818,2122,823,2119?826,2117,831,2114?833,2111,836,2103?839,2101,841,2098?844,2096466,1254,466,1254?460,1262,458,1265?458,1265,458,1265?458,1265,458,1265?458,1265,458,1265?460,1265,460,1262?468,1254,471,1249?476,1244,484,1236?495,1222,503,1214?508,1206,516,1196?527,1188,534,1180?542,1172,550,1167?556,1159,564,1154?569,1151,572,1143?579,1140,582,1138?582,1138,582,1138?582,1138,582,1138?582,1140,579,1140?579,1146,577,1151?569,1156,566,1162?561,1169,558,1177?556,1185,553,1193?548,1201,548,1212?542,1217,542,1225?542,1233,542,1238?542,1244,542,1246?548,1249,550,1251?553,1251,556,1251?558,1251,561,1251?566,1251,569,1249?569,1249,572,1249?572,1249,577,1246?577,1246,579,1249?579,1249,579,1251?582,1257,582,1262?582,1267,582,1273?582,1275,582,1281669,1217,669,1217?672,1217,675,1214?677,1214,680,1212?680,1212,685,1212?688,1209,691,1209?691,1206,693,1206?696,1201,698,1201?701,1199,701,1199?704,1196640,1601,640,1601?632,1609,624,1619?619,1625,614,1632?609,1638,603,1646?598,1648,598,1648?598,1648,598,1648?598,1648,598,1648?603,1646,609,1638?614,1632,622,1627?632,1619,643,1609?651,1601,661,1593?672,1582,680,1574?691,1566,698,1561?706,1550,714,1548?722,1543,728,1540?730,1535,736,1535?741,1529,743,1529?743,1527,743,1527?743,1527,746,1529?746,1529,746,1535?746,1537,746,1540?746,1543,743,1545?743,1550,743,1553?741,1561,741,1564?741,1572,743,1577?743,1582,743,1593?743,1601,746,1609?746,1619,746,1627?746,1632,749,1643?749,1648,751,1656?754,1662,754,1664?757,1672,759,1675857,1638,857,1638?860,1638,860,1638?863,1635,865,1635?865,1635,868,1635?868,1635,870,1632?870,1632,873,1630?873,1627,878,1625?881,1622,884,1619?884,1617,886,1609?889,1603,892,1601?894,1595,894,1590?897,1580,897,1574?900,1569,900,1566?900,1561,900,1556?900,1553,900,1550?897,1548,897,1548?897,1548,894,1548?892,1548,892,1550?889,1553,886,1556?884,1561,884,1566?881,1569,881,1574?878,1580,878,1585?881,1590,881,1595?884,1601,886,1603?886,1606,892,1606?894,1609,897,1609?905,1606,910,1606?915,1603,921,1598?926,1595,937,1590?942,1585,945,1580?950,1572995,1482,995,1482?995,1479,995,1479?995,1479,995,1474?995,1479,992,1479?992,1482,992,1484?990,1490,987,1495?987,1500,982,1508?982,1513,982,1519?982,1521,982,1527?987,1529,987,1529?990,1535,992,1535?995,1535,1000,1529?1005,1529,1008,1527?1016,1527,1021,1524?1027,1521,1032,1521?1035,1519,1037,1519?1042,1519,1042,1519?1045,1519,1045,1519?1045,1521,1045,1524?1045,1527,1042,1529?1037,1535,1037,1540?1035,1543,1032,1548?1032,1550,1029,1553?1029,1553,1029,15531130,1397,1130,1397?1132,1389,1138,1386?1140,1384,1146,1381?1151,1381,1151,1381?1154,1381,1156,1381?1156,1381,1156,1381?1159,1384,1159,1384?1159,1389,1159,1392?1159,1397,1159,1402?1159,1408,1159,1413?1159,1418,1162,1426?1162,1431,1162,1434?1164,1439,1164,1442?1167,1445,1169,1447?1172,1447,1177,1453?1180,1453,1185,1453?1191,1447,1196,1447?1206,1445,1212,1442?1220,1439,1225,1434?1236,1431,1241,1429?1249,1426,1254,1421?1265,1416,1270,1416?1275,1413,1278,1410?1281,1408,1281,1408?1281,1408,1281,14081159,1460,1159,1460?1156,1463,1154,1466?1154,1466,1154,1468?1154,1468,1154,1468?1156,1466,1162,1463?1167,1460,1172,1458?1180,1455,1188,1447?1193,1445,1199,1439?1209,1437,1214,1431?1220,1429,1225,1426?1233,1421881,2267,881,2267?878,2273,878,2273?878,2273,878,2273?878,2273,878,2273?873,2267,873,2267?878,2265,878,2265?881,2262,884,2257?889,2254,894,2249?900,2241,908,2236?915,2228,923,2220?934,2207,945,2199?955,2185,966,2178?976,2167,990,2154?997,2146,1005,2138?1016,21301024,2103,1024,2103?1019,2109,1013,2114?1003,2117,1000,2122?997,2125,992,2127?990,2133,987,2138?982,2143,979,2148?979,2154,976,2159?976,2170,976,2178?976,2185,976,2199?976,2209,976,2225?979,2238,979,2254?982,2273,987,2289?987,2307,990,2323?992,2342,995,2363?997,2376,1000,2394?1003,2410,1005,2421?1008,2432,1013,2442?1016,2447,1019,2453?1021,2453,1024,24551106,2275,1106,2275?1109,2275,1109,2275?1109,2278,1109,2281?1109,2283,1106,2286?1106,2291,1103,2294?1103,2302,1103,2305?1103,2307,1103,2307?1106,2307,1106,2307?1109,2307,1111,2305?1114,2302,1119,2297?1124,2291,1130,2283?1135,2278,1138,2267?1143,2257,1146,2249?1154,2236,1156,2225?1162,2215,1164,2204?1167,2196,1169,2183?1169,2178,1172,2170?1172,2164,1172,2159?1172,2156,1169,2154?1167,2154,1164,2154?1162,2154,1159,2156?1154,2164,1146,2170?1143,2175,1138,2183?1132,2193,1130,2201?1124,2209,1119,2220?1117,2230,1114,2238?1111,2249,1111,2260?1109,2267,1109,2275?1111,2283,1111,2291?1114,2297,1117,2305?1124,2307,1127,2312?1132,2312,1138,2315?1143,2315,1151,2312?1159,2312,1164,2307?1172,2305,1180,22971315,2119,1315,2119?1315,2119,1315,2119?1315,2117,1315,2119?1310,2122,1310,2125?1304,2130,1302,2138?1296,2146,1291,2156?1283,2167,1278,2175?1273,2185,1270,2196?1265,2207,1262,2215?1257,2222,1257,2228?1262,2230,1262,2233?1265,2233,1270,2230?1275,2228,1281,2225?1291,2220,1296,2212?1304,2207,1310,2201?1320,2199,1326,2193?1331,2191,1334,2191?1336,2191,1339,2191?1344,2193,1344,2196?1344,2199,1344,2204?1339,2209,1336,2215?1334,2225,1328,2233?1323,2241,1318,2252?1310,2260,1304,2267?1299,2281,1291,2289?1283,2297,1278,2305?1273,2310,1267,23151357,2008,1357,2008?1363,1995,1371,1984?1376,1974,1381,1963?1384,1953,1386,1945?1392,1937,1397,1931?1400,1926,1400,1921?1400,1921,1400,1921?1402,1921,1402,1921?1402,1924,1402,1929?1402,1934,1400,1945?1400,1955,1397,1966?1392,1979,1389,1992?1389,2008,1386,2021?1384,2037,1384,2056?1381,2069,1381,2085?1384,2098,1384,2111?1386,2122,1389,2127?1392,2138,1397,2140?1400,2143,1402,2146?1408,2146,1413,2146?1416,2146,1421,2146?1426,2143,1431,2143?1434,2140,1437,2140?1439,2138,1442,2138?1445,2133,1445,2133?1447,2130,1447,2127?1447,2127,1445,2125?1445,2122,1442,2119?1437,2114,1434,2111?1429,2109,1426,2103?1416,2101,1410,2096?1405,2093,1397,2090?1386,2090,1378,2088?1371,2088,1360,2088?1349,2088,1339,2088?1331,2088,1323,2090?1318,2090,1310,20931606,2170,1606,2170?1603,2172,1603,2178?1601,2180,1598,2180?1598,2183,1598,2183?1598,2183,1598,2183?1598,2183,1598,2183?1598,2183,1598,2183?1601,2180,1603,2178?1606,2172,1611,2167?1619,2159,1625,2151?1630,2140,1635,2130?1646,2119,1651,2109?1656,2096,1659,2085?1662,2072,1667,2061?1672,2045,1672,2032?1675,2019,1677,2006?1677,1987,1680,1974?1680,1955,1680,1939?1683,1926,1683,1910?1683,1897,1683,1884?1680,1876,1680,1868?1677,1857,1677,1852?1675,1847,1672,1844?1667,1842,1662,1839?1659,1836,1654,1836?1651,1836,1646,1839?1643,1842,1635,1847?1632,1852,1627,1863?1625,1871,1622,1881?1619,1894,1617,1908?1611,1924,1611,1937?1611,1953,1617,1968?1619,1987,1622,2003?1625,2016,1630,2032?1635,2045,1646,2061?1651,2072,1659,2085?1667,2093,1677,2103?1685,2114,1691,2119?1701,2125,1709,2130?1714,2138,1720,2140?1728,2143,1733,2146?1736,2148,1738,21511550,1995,1550,1995?1550,1995,1550,1995?1550,1995,1553,1992?1564,1990,1572,1984?1582,1976,1598,1966?1617,1958,1632,1947?1651,1934,1675,1924?1693,1908,1717,1897?1741,1884,1765,1873?1786,1863
] [Logging Date Time: 2016-11-10 10:23:15,525] ===================================================================================== 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 10:23:15,525] ===================================================================================== 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 10:23:15,527] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Parameters: [param0=[sub_cd,CONSENT_DATA]] [Logging Date Time: 2016-11-10 10:23:15,527] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Parameters: [param0=[sub_cd,CONSENT_DATA]] [Logging Date Time: 2016-11-10 10:23:15,528] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 10:23:15,528] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 10:23:15,553] ===================================================================================== 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 10:23:15,553] ===================================================================================== 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 10:23:15,555] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Parameters: [param0=[ud1_num,1787], param1=[sub_cd,CONSENT_DATA]] [Logging Date Time: 2016-11-10 10:23:15,555] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Parameters: [param0=[ud1_num,1787], param1=[sub_cd,CONSENT_DATA]] [Logging Date Time: 2016-11-10 10:23:15,555] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 10:23:15,555] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 10:23:15,570] ===================================================================================== SQL Command - Statement Id: [UPDATE_CONSENT_MST] PreparedStatement : [UPDATE CONSENT_MST SET CONSENT_STATE = :param0 , COMPLETE_YN = :param1 , COMPLETE_DATETIME = '', PAPER_YN = :param2 , MODIFY_USER_ID = :param3 , MODIFY_DATETIME = TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'), MODIFY_USER_NAME = COM.FN_ZS_GETUSERNM( :param3 , TO_CHAR(SYSDATE, 'YYYYMMDD')) WHERE CONSENT_MST_RID = :param4] [Logging Date Time: 2016-11-10 10:23:15,570] ===================================================================================== SQL Command - Statement Id: [UPDATE_CONSENT_MST] PreparedStatement : [UPDATE CONSENT_MST SET CONSENT_STATE = :param0 , COMPLETE_YN = :param1 , COMPLETE_DATETIME = '', PAPER_YN = :param2 , MODIFY_USER_ID = :param3 , MODIFY_DATETIME = TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'), MODIFY_USER_NAME = COM.FN_ZS_GETUSERNM( :param3 , TO_CHAR(SYSDATE, 'YYYYMMDD')) WHERE CONSENT_MST_RID = :param4] [Logging Date Time: 2016-11-10 10:23:15,571] ===================================================================================== SQL Command - Statement Id: [UPDATE_CONSENT_MST] Parameters: [param0=[consentState,TEMP], param1=[completeYn,N], param2=[paperYn,N], param3=[userId,105066], param4=[consentMstRid,1842]] [Logging Date Time: 2016-11-10 10:23:15,571] ===================================================================================== SQL Command - Statement Id: [UPDATE_CONSENT_MST] Parameters: [param0=[consentState,TEMP], param1=[completeYn,N], param2=[paperYn,N], param3=[userId,105066], param4=[consentMstRid,1842]] [Logging Date Time: 2016-11-10 10:23:15,571] ===================================================================================== SQL Command - Statement Id: [UPDATE_CONSENT_MST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[Int32, System.Int32]] [Logging Date Time: 2016-11-10 10:23:15,571] ===================================================================================== SQL Command - Statement Id: [UPDATE_CONSENT_MST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[Int32, System.Int32]] [Logging Date Time: 2016-11-10 10:23:15,573] ===================================================================================== 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 10:23:15,573] ===================================================================================== 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 10:23:15,574] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_DATA] Parameters: [param0=[consentDataRid,1787], param1=[consentMstRid,1842], param2=[formRid,1307], param3=[deviceType,WIN], param4=[deviceIdentNo,16-101-33], param5=[completeYn,N], param6=[userId,105066], param7=[formXml,System.Byte[]], param8=[dataXml,System.Byte[]]] [Logging Date Time: 2016-11-10 10:23:15,574] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_DATA] Parameters: [param0=[consentDataRid,1787], param1=[consentMstRid,1842], param2=[formRid,1307], param3=[deviceType,WIN], param4=[deviceIdentNo,16-101-33], param5=[completeYn,N], param6=[userId,105066], param7=[formXml,System.Byte[]], param8=[dataXml,System.Byte[]]] [Logging Date Time: 2016-11-10 10:23:15,574] ===================================================================================== 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 10:23:15,574] ===================================================================================== 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 10:23:15,912] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/IO_device [Logging Date Time: 2016-11-10 10:23:15,912] ===================================================================================== SQL Command - DataXmlToDictionary 1 : IO_device/ [Logging Date Time: 2016-11-10 10:23:15,912] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/O_device_ID [Logging Date Time: 2016-11-10 10:23:15,913] ===================================================================================== SQL Command - DataXmlToDictionary 1 : O_device_ID/16-101-33 [Logging Date Time: 2016-11-10 10:23:15,913] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/IO_ocr_cd [Logging Date Time: 2016-11-10 10:23:15,913] ===================================================================================== SQL Command - DataXmlToDictionary 1 : IO_ocr_cd/2016111063775 [Logging Date Time: 2016-11-10 10:23:15,913] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/IO_Pt_ID [Logging Date Time: 2016-11-10 10:23:15,913] ===================================================================================== SQL Command - DataXmlToDictionary 1 : IO_Pt_ID/ [Logging Date Time: 2016-11-10 10:23:15,913] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/IO_sex_age_y_m [Logging Date Time: 2016-11-10 10:23:15,913] ===================================================================================== SQL Command - DataXmlToDictionary 1 : IO_sex_age_y_m/ [Logging Date Time: 2016-11-10 10:23:15,913] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/IO_Pt_name [Logging Date Time: 2016-11-10 10:23:15,913] ===================================================================================== SQL Command - DataXmlToDictionary 1 : IO_Pt_name/ [Logging Date Time: 2016-11-10 10:23:15,913] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/IO_JuminNo [Logging Date Time: 2016-11-10 10:23:15,913] ===================================================================================== SQL Command - DataXmlToDictionary 1 : IO_JuminNo/ [Logging Date Time: 2016-11-10 10:23:15,913] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/IO_roomNo [Logging Date Time: 2016-11-10 10:23:15,913] ===================================================================================== SQL Command - DataXmlToDictionary 1 : IO_roomNo/ [Logging Date Time: 2016-11-10 10:23:15,914] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/IO_ADdate [Logging Date Time: 2016-11-10 10:23:15,914] ===================================================================================== SQL Command - DataXmlToDictionary 1 : IO_ADdate/ [Logging Date Time: 2016-11-10 10:23:15,914] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/IO_Dept [Logging Date Time: 2016-11-10 10:23:15,914] ===================================================================================== SQL Command - DataXmlToDictionary 1 : IO_Dept/ [Logging Date Time: 2016-11-10 10:23:15,914] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/IO_formname [Logging Date Time: 2016-11-10 10:23:15,914] ===================================================================================== SQL Command - DataXmlToDictionary 1 : IO_formname/ [Logging Date Time: 2016-11-10 10:23:15,914] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/IO_OPdept [Logging Date Time: 2016-11-10 10:23:15,914] ===================================================================================== SQL Command - DataXmlToDictionary 1 : IO_OPdept/소화기내과 [Logging Date Time: 2016-11-10 10:23:15,914] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/IO_OPdr [Logging Date Time: 2016-11-10 10:23:15,914] ===================================================================================== SQL Command - DataXmlToDictionary 1 : IO_OPdr/정윤진 [Logging Date Time: 2016-11-10 10:23:15,914] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/IO_Dx [Logging Date Time: 2016-11-10 10:23:15,914] ===================================================================================== SQL Command - DataXmlToDictionary 1 : IO_Dx/코감기 [Logging Date Time: 2016-11-10 10:23:15,914] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/IO_maindr [Logging Date Time: 2016-11-10 10:23:15,915] ===================================================================================== SQL Command - DataXmlToDictionary 1 : IO_maindr/이봉렬 [Logging Date Time: 2016-11-10 10:23:15,915] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/IO_signdate [Logging Date Time: 2016-11-10 10:23:15,915] ===================================================================================== SQL Command - DataXmlToDictionary 1 : IO_signdate/ [Logging Date Time: 2016-11-10 10:23:15,915] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/IO_signtime [Logging Date Time: 2016-11-10 10:23:15,915] ===================================================================================== SQL Command - DataXmlToDictionary 1 : IO_signtime/ [Logging Date Time: 2016-11-10 10:23:15,915] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/IO_printtime [Logging Date Time: 2016-11-10 10:23:15,915] ===================================================================================== SQL Command - DataXmlToDictionary 1 : IO_printtime/2016-11-10 10:21:36 [Logging Date Time: 2016-11-10 10:23:15,915] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/O_Pt_rel [Logging Date Time: 2016-11-10 10:23:15,915] ===================================================================================== SQL Command - DataXmlToDictionary 1 : O_Pt_rel/ [Logging Date Time: 2016-11-10 10:23:15,915] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/O_sign_cause [Logging Date Time: 2016-11-10 10:23:15,915] ===================================================================================== SQL Command - DataXmlToDictionary 1 : O_sign_cause/ [Logging Date Time: 2016-11-10 10:23:15,915] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/O_Ptname_write [Logging Date Time: 2016-11-10 10:23:15,916] ===================================================================================== SQL Command - DataXmlToDictionary 1 : O_Ptname_write/ [Logging Date Time: 2016-11-10 10:23:15,916] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/O_Ptsign [Logging Date Time: 2016-11-10 10:23:15,916] ===================================================================================== SQL Command - DataXmlToDictionary 1 : O_Ptsign/ [Logging Date Time: 2016-11-10 10:23:15,916] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/O_JuminNo [Logging Date Time: 2016-11-10 10:23:15,916] ===================================================================================== SQL Command - DataXmlToDictionary 1 : O_JuminNo/ [Logging Date Time: 2016-11-10 10:23:15,916] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/O_Drname_write [Logging Date Time: 2016-11-10 10:23:15,916] ===================================================================================== SQL Command - DataXmlToDictionary 1 : O_Drname_write/ [Logging Date Time: 2016-11-10 10:23:15,916] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/O_drsign [Logging Date Time: 2016-11-10 10:23:15,916] ===================================================================================== SQL Command - DataXmlToDictionary 1 : O_drsign/ [Logging Date Time: 2016-11-10 10:23:15,916] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/IO_INPUTNM [Logging Date Time: 2016-11-10 10:23:15,916] ===================================================================================== SQL Command - DataXmlToDictionary 1 : IO_INPUTNM/ [Logging Date Time: 2016-11-10 10:23:15,916] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 8/base_info [Logging Date Time: 2016-11-10 10:23:15,916] ===================================================================================== SQL Command - DataXmlToDictionary : IO_Pt_ID [Logging Date Time: 2016-11-10 10:23:15,917] ===================================================================================== SQL Command - DataXmlToDictionary : 1 [Logging Date Time: 2016-11-10 10:23:15,917] ===================================================================================== SQL Command - DataXmlToDictionary 2 : IO_Pt_ID/1715813 [Logging Date Time: 2016-11-10 10:23:15,917] ===================================================================================== SQL Command - DataXmlToDictionary : IO_sex_age_y_m [Logging Date Time: 2016-11-10 10:23:15,917] ===================================================================================== SQL Command - DataXmlToDictionary : 1 [Logging Date Time: 2016-11-10 10:23:15,917] ===================================================================================== SQL Command - DataXmlToDictionary 2 : IO_sex_age_y_m/F/37 [Logging Date Time: 2016-11-10 10:23:15,917] ===================================================================================== SQL Command - DataXmlToDictionary : IO_formname [Logging Date Time: 2016-11-10 10:23:15,917] ===================================================================================== SQL Command - DataXmlToDictionary : 1 [Logging Date Time: 2016-11-10 10:23:15,917] ===================================================================================== SQL Command - DataXmlToDictionary 2 : IO_formname/내시경적 용종절제술(점막절제술) 설명 및 동의서 [Logging Date Time: 2016-11-10 10:23:15,917] ===================================================================================== SQL Command - DataXmlToDictionary : IO_Pt_name [Logging Date Time: 2016-11-10 10:23:15,917] ===================================================================================== SQL Command - DataXmlToDictionary : 1 [Logging Date Time: 2016-11-10 10:23:15,917] ===================================================================================== SQL Command - DataXmlToDictionary 2 : IO_Pt_name/오재은 [Logging Date Time: 2016-11-10 10:23:15,917] ===================================================================================== SQL Command - DataXmlToDictionary : IO_JuminNo [Logging Date Time: 2016-11-10 10:23:15,917] ===================================================================================== SQL Command - DataXmlToDictionary : 1 [Logging Date Time: 2016-11-10 10:23:15,918] ===================================================================================== SQL Command - DataXmlToDictionary 2 : IO_JuminNo/790518-2****** [Logging Date Time: 2016-11-10 10:23:15,918] ===================================================================================== SQL Command - DataXmlToDictionary : IO_roomNo [Logging Date Time: 2016-11-10 10:23:15,918] ===================================================================================== SQL Command - DataXmlToDictionary : 1 [Logging Date Time: 2016-11-10 10:23:15,918] ===================================================================================== SQL Command - DataXmlToDictionary 2 : IO_roomNo// [Logging Date Time: 2016-11-10 10:23:15,918] ===================================================================================== SQL Command - DataXmlToDictionary : IO_ADdate [Logging Date Time: 2016-11-10 10:23:15,918] ===================================================================================== SQL Command - DataXmlToDictionary : 1 [Logging Date Time: 2016-11-10 10:23:15,918] ===================================================================================== SQL Command - DataXmlToDictionary 2 : IO_ADdate/2016/11/10 [Logging Date Time: 2016-11-10 10:23:15,918] ===================================================================================== SQL Command - DataXmlToDictionary : IO_Dept [Logging Date Time: 2016-11-10 10:23:15,918] ===================================================================================== SQL Command - DataXmlToDictionary : 1 [Logging Date Time: 2016-11-10 10:23:15,918] ===================================================================================== SQL Command - DataXmlToDictionary 2 : IO_Dept/IC [Logging Date Time: 2016-11-10 10:23:15,918] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/IO_bp [Logging Date Time: 2016-11-10 10:23:15,919] ===================================================================================== SQL Command - DataXmlToDictionary 1 : IO_bp/ [Logging Date Time: 2016-11-10 10:23:15,919] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/IO_dm [Logging Date Time: 2016-11-10 10:23:15,919] ===================================================================================== SQL Command - DataXmlToDictionary 1 : IO_dm/ [Logging Date Time: 2016-11-10 10:23:15,919] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/IO_heart [Logging Date Time: 2016-11-10 10:23:15,919] ===================================================================================== SQL Command - DataXmlToDictionary 1 : IO_heart/ [Logging Date Time: 2016-11-10 10:23:15,919] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/IO_kidney [Logging Date Time: 2016-11-10 10:23:15,919] ===================================================================================== SQL Command - DataXmlToDictionary 1 : IO_kidney/ [Logging Date Time: 2016-11-10 10:23:15,919] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/IO_respiration [Logging Date Time: 2016-11-10 10:23:15,919] ===================================================================================== SQL Command - DataXmlToDictionary 1 : IO_respiration/ [Logging Date Time: 2016-11-10 10:23:15,919] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/IO_hx [Logging Date Time: 2016-11-10 10:23:15,919] ===================================================================================== SQL Command - DataXmlToDictionary 1 : IO_hx/ [Logging Date Time: 2016-11-10 10:23:15,919] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/IO_allergy [Logging Date Time: 2016-11-10 10:23:15,919] ===================================================================================== SQL Command - DataXmlToDictionary 1 : IO_allergy/ [Logging Date Time: 2016-11-10 10:23:15,919] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/IO_drug [Logging Date Time: 2016-11-10 10:23:15,920] ===================================================================================== SQL Command - DataXmlToDictionary 1 : IO_drug/ [Logging Date Time: 2016-11-10 10:23:15,920] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/IO_smoking [Logging Date Time: 2016-11-10 10:23:15,920] ===================================================================================== SQL Command - DataXmlToDictionary 1 : IO_smoking/ [Logging Date Time: 2016-11-10 10:23:15,920] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/IO_idio [Logging Date Time: 2016-11-10 10:23:15,920] ===================================================================================== SQL Command - DataXmlToDictionary 1 : IO_idio/ [Logging Date Time: 2016-11-10 10:23:15,920] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/IO_nacrotics [Logging Date Time: 2016-11-10 10:23:15,920] ===================================================================================== SQL Command - DataXmlToDictionary 1 : IO_nacrotics/ [Logging Date Time: 2016-11-10 10:23:15,920] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/IO_airway [Logging Date Time: 2016-11-10 10:23:15,920] ===================================================================================== SQL Command - DataXmlToDictionary 1 : IO_airway/ [Logging Date Time: 2016-11-10 10:23:15,920] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/IO_hemorrhage [Logging Date Time: 2016-11-10 10:23:15,920] ===================================================================================== SQL Command - DataXmlToDictionary 1 : IO_hemorrhage/ [Logging Date Time: 2016-11-10 10:23:15,921] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/IO_status_etc [Logging Date Time: 2016-11-10 10:23:15,921] ===================================================================================== SQL Command - DataXmlToDictionary 1 : IO_status_etc/ [Logging Date Time: 2016-11-10 10:23:15,921] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/prodr_info [Logging Date Time: 2016-11-10 10:23:15,921] ===================================================================================== SQL Command - DataXmlToDictionary 1 : prodr_info/ [Logging Date Time: 2016-11-10 10:23:15,921] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 14/state [Logging Date Time: 2016-11-10 10:23:15,921] ===================================================================================== SQL Command - DataXmlToDictionary : IO_bp [Logging Date Time: 2016-11-10 10:23:15,921] ===================================================================================== SQL Command - DataXmlToDictionary : 1 [Logging Date Time: 2016-11-10 10:23:15,921] ===================================================================================== SQL Command - DataXmlToDictionary 2 : IO_bp/02 [Logging Date Time: 2016-11-10 10:23:15,921] ===================================================================================== SQL Command - DataXmlToDictionary : IO_hx [Logging Date Time: 2016-11-10 10:23:15,921] ===================================================================================== SQL Command - DataXmlToDictionary : 1 [Logging Date Time: 2016-11-10 10:23:15,921] ===================================================================================== SQL Command - DataXmlToDictionary 2 : IO_hx/03 [Logging Date Time: 2016-11-10 10:23:15,921] ===================================================================================== SQL Command - DataXmlToDictionary : IO_idio [Logging Date Time: 2016-11-10 10:23:15,921] ===================================================================================== SQL Command - DataXmlToDictionary : 1 [Logging Date Time: 2016-11-10 10:23:15,921] ===================================================================================== SQL Command - DataXmlToDictionary 2 : IO_idio/01 [Logging Date Time: 2016-11-10 10:23:15,922] ===================================================================================== SQL Command - DataXmlToDictionary : IO_dm [Logging Date Time: 2016-11-10 10:23:15,922] ===================================================================================== SQL Command - DataXmlToDictionary : 1 [Logging Date Time: 2016-11-10 10:23:15,922] ===================================================================================== SQL Command - DataXmlToDictionary 2 : IO_dm/02 [Logging Date Time: 2016-11-10 10:23:15,922] ===================================================================================== SQL Command - DataXmlToDictionary : IO_allergy [Logging Date Time: 2016-11-10 10:23:15,922] ===================================================================================== SQL Command - DataXmlToDictionary : 1 [Logging Date Time: 2016-11-10 10:23:15,922] ===================================================================================== SQL Command - DataXmlToDictionary 2 : IO_allergy/03 [Logging Date Time: 2016-11-10 10:23:15,922] ===================================================================================== SQL Command - DataXmlToDictionary : IO_nacrotics [Logging Date Time: 2016-11-10 10:23:15,922] ===================================================================================== SQL Command - DataXmlToDictionary : 1 [Logging Date Time: 2016-11-10 10:23:15,922] ===================================================================================== SQL Command - DataXmlToDictionary 2 : IO_nacrotics/01 [Logging Date Time: 2016-11-10 10:23:15,922] ===================================================================================== SQL Command - DataXmlToDictionary : IO_heart [Logging Date Time: 2016-11-10 10:23:15,922] ===================================================================================== SQL Command - DataXmlToDictionary : 1 [Logging Date Time: 2016-11-10 10:23:15,922] ===================================================================================== SQL Command - DataXmlToDictionary 2 : IO_heart/02 [Logging Date Time: 2016-11-10 10:23:15,922] ===================================================================================== SQL Command - DataXmlToDictionary : IO_drug [Logging Date Time: 2016-11-10 10:23:15,923] ===================================================================================== SQL Command - DataXmlToDictionary : 1 [Logging Date Time: 2016-11-10 10:23:15,923] ===================================================================================== SQL Command - DataXmlToDictionary 2 : IO_drug/03 [Logging Date Time: 2016-11-10 10:23:15,923] ===================================================================================== SQL Command - DataXmlToDictionary : IO_airway [Logging Date Time: 2016-11-10 10:23:15,923] ===================================================================================== SQL Command - DataXmlToDictionary : 1 [Logging Date Time: 2016-11-10 10:23:15,923] ===================================================================================== SQL Command - DataXmlToDictionary 2 : IO_airway/01 [Logging Date Time: 2016-11-10 10:23:15,923] ===================================================================================== SQL Command - DataXmlToDictionary : IO_kidney [Logging Date Time: 2016-11-10 10:23:15,923] ===================================================================================== SQL Command - DataXmlToDictionary : 1 [Logging Date Time: 2016-11-10 10:23:15,923] ===================================================================================== SQL Command - DataXmlToDictionary 2 : IO_kidney/02 [Logging Date Time: 2016-11-10 10:23:15,923] ===================================================================================== SQL Command - DataXmlToDictionary : IO_smoking [Logging Date Time: 2016-11-10 10:23:15,923] ===================================================================================== SQL Command - DataXmlToDictionary : 1 [Logging Date Time: 2016-11-10 10:23:15,923] ===================================================================================== SQL Command - DataXmlToDictionary 2 : IO_smoking/03 [Logging Date Time: 2016-11-10 10:23:15,923] ===================================================================================== SQL Command - DataXmlToDictionary : IO_hemorrhage [Logging Date Time: 2016-11-10 10:23:15,923] ===================================================================================== SQL Command - DataXmlToDictionary : 1 [Logging Date Time: 2016-11-10 10:23:15,923] ===================================================================================== SQL Command - DataXmlToDictionary 2 : IO_hemorrhage/01 [Logging Date Time: 2016-11-10 10:23:15,924] ===================================================================================== SQL Command - DataXmlToDictionary : IO_respiration [Logging Date Time: 2016-11-10 10:23:15,924] ===================================================================================== SQL Command - DataXmlToDictionary : 1 [Logging Date Time: 2016-11-10 10:23:15,924] ===================================================================================== SQL Command - DataXmlToDictionary 2 : IO_respiration/02 [Logging Date Time: 2016-11-10 10:23:15,924] ===================================================================================== SQL Command - DataXmlToDictionary : IO_status_etc [Logging Date Time: 2016-11-10 10:23:15,924] ===================================================================================== SQL Command - DataXmlToDictionary : 1 [Logging Date Time: 2016-11-10 10:23:15,924] ===================================================================================== SQL Command - DataXmlToDictionary 2 : IO_status_etc/ [Logging Date Time: 2016-11-10 10:23:15,924] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 1/Prometh_change [Logging Date Time: 2016-11-10 10:23:15,924] ===================================================================================== SQL Command - DataXmlToDictionary 1 : Prometh_change/ [Logging Date Time: 2016-11-10 10:23:15,924] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 9/consent [Logging Date Time: 2016-11-10 10:23:15,924] ===================================================================================== SQL Command - DataXmlToDictionary : O_sign_cause [Logging Date Time: 2016-11-10 10:23:15,924] ===================================================================================== SQL Command - DataXmlToDictionary : 1 [Logging Date Time: 2016-11-10 10:23:15,924] ===================================================================================== SQL Command - DataXmlToDictionary 2 : O_sign_cause/ [Logging Date Time: 2016-11-10 10:23:15,924] ===================================================================================== SQL Command - DataXmlToDictionary : O_Pt_rel [Logging Date Time: 2016-11-10 10:23:15,925] ===================================================================================== SQL Command - DataXmlToDictionary : 1 [Logging Date Time: 2016-11-10 10:23:15,925] ===================================================================================== SQL Command - DataXmlToDictionary 2 : O_Pt_rel/01 [Logging Date Time: 2016-11-10 10:23:15,925] ===================================================================================== SQL Command - DataXmlToDictionary : IO_signdate [Logging Date Time: 2016-11-10 10:23:15,925] ===================================================================================== SQL Command - DataXmlToDictionary : 1 [Logging Date Time: 2016-11-10 10:23:15,925] ===================================================================================== SQL Command - DataXmlToDictionary 2 : IO_signdate/2016-11-10 10:21:36 [Logging Date Time: 2016-11-10 10:23:15,925] ===================================================================================== SQL Command - DataXmlToDictionary : IO_signtime [Logging Date Time: 2016-11-10 10:23:15,925] ===================================================================================== SQL Command - DataXmlToDictionary : 1 [Logging Date Time: 2016-11-10 10:23:15,925] ===================================================================================== SQL Command - DataXmlToDictionary 2 : IO_signtime/2016-11-10 10:21:36 [Logging Date Time: 2016-11-10 10:23:15,925] ===================================================================================== SQL Command - DataXmlToDictionary : O_Ptname_write [Logging Date Time: 2016-11-10 10:23:15,925] ===================================================================================== SQL Command - DataXmlToDictionary : 1 [Logging Date Time: 2016-11-10 10:23:15,925] ===================================================================================== SQL Command - DataXmlToDictionary 2 : O_Ptname_write/data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAdMAAABPCAYAAACwLS8hAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAAQiSURBVHhe7d2vkyNFGAbglUgkkj8BeRKJRCKRSCQShzyJRCKRSORJJBKJRCKPfu+qq6amOjOTpGd2fjxP1SvuKpvdZKv2zdeT7rwAAAAAAAAAAAAAcDyfl3xb8uPCfF/yaQkAXEqrMH8p+bvk/QP5p+SnktxP7hsATqeW5zOFuTS5f4UKwOFtWZ6tKFQADue1y7MVhQrArr0p+a5kT+XZikIFYBc+K/mm5G3JHyWt0loj/5Xk+93Ku5LW142jUAHYXF2y/bnkr5JWQfXKuDB/K8lWl0y+S3xR8mvJvyWt+6/5vQQAVrPl9c6UZ4rth5KlhblESnWqUFPUANDNGcqzZapQlSkAT8npQGcsz5Y8xtbPpUwBuFudPnMNslUuvZKTh16zPMeUKQAP22L6rFNnjuz7qiTv8t0bZQrAXWqBrjV9vvaS7SOUKQCLrFWgRyzPMWUKQFPKs36ySs8l3DOU51Am9Vv7YpUpwEWlRHtf/zxTeY7lkInWY062LNOUen3xM0x+nwBspGeJZt9lloRzn/kjf2a3lniTNct0XJ5/lrR+hvxOh7dL8sLmkxIAOvm6pEeJ1ukzhxhcxdQSb5az8+7jnoZL77fKcy5r/FwAl5czaVt/dJfkKtNnSx7zVKH1nEp7rRooUoCVZLkvhyC0/vi2kpK4aoEOTV0rTZ4t0zy/vUo0UaQAK5uaTjN9pRgyhX5ZwkdT10qfKa4UaO8tSIoUYAOt6TQFqjzbel8r7T2FDqNIATZUp1MlOu+Z7TApzeE7a9c4CGOYZ5ebAbhDplMluszcdphxYdb0mjyz9P5u9H+tXGEqvfq1e4DDmirTNVNXDfLCJ1uRWrepOXuR1mXxtx/+BcDhbF2mwzd/XblIW9eW81j3+ElCAMzYokzrcvF4GXNuX/DZinTJZ+SaTgEOaM0yndqClFLJUY2tr0vOUKS1PPMcL73GbDoFOKAeZVr37yYp0NYUWmVp99ZWnJqjFmldur2nPFsxnQIcTM4grkWY3JoWh4VZMzV53rLkyMcjFemSpdt7k+vIABxYDvd/tjBvyeQ2d9xjvt+e9Zo+W8nz3eu5BuCEUkJTh+nX7PGTetaYPofp+YIFgJNaUqSPTGUpuNaBEsPkNkuN72+N6TO50mfkAtDBkiKdW9ptlebSksvtxl/byhqlWZM3VF3xM3IB6GTu491SNOOCGZbnmiW3Zmp5vikBgKfMbb3J8u5WE+KasXQLwGp67GPdayzdArCJM5Wp6ROAV7FFmeYNTnP7V+/J8ICKlGcOmjB9AvBqepbpsORq0dXtNOOTnB7J8P4AYDeeKdNankoOgEt7ZGJUngAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAe/Xy8j8NsTKXkfs1tQAAAABJRU5ErkJggg== [Logging Date Time: 2016-11-10 10:23:15,925] ===================================================================================== SQL Command - DataXmlToDictionary : O_Ptsign [Logging Date Time: 2016-11-10 10:23:15,926] ===================================================================================== SQL Command - DataXmlToDictionary : 1 [Logging Date Time: 2016-11-10 10:23:15,926] ===================================================================================== SQL Command - DataXmlToDictionary 2 : O_Ptsign/data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAOkAAABPCAYAAAAOcuIQAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAAISSURBVHhe7duhkhNBFAXQlUgkkk9AIpFIJBKJRCJxSCQSiUQikXwCEolEItl3RVcNqZ7MJnRmM8k5VdftpqYqfed1T5IbAAAAAAAAAAAAAAAAAAAAOMTDyqvKuzvkTSV/DwzwuLJUvi+VvwfmV+V9Zfe1FBgWtFJ+qvys9Ap26uwWONcEV2HfVLzPUi4l15VrNGW5OI8qLyvnXMBD06aswrJZKeXHyo9Kb5FfUmyL2YwszizWLNreYl4732byvdL7+1Fp22KF5Sw8rbyufK30Fuzo/Kn0iteSJ7w57y5tQZ9UPld2/390gZ1jWVU7W36oZEH3FuXopJS5Abyt5IawhmmBf1d613VM8lop64MKDJO7/6nOlnNTMdMwi3mtUu6TwrbrGjVlTVeGGzVN7mMqjtam7KjC5vyesmaXAkc75ps8LZlAWy7lPqO3xXmd9sAp53zF5c5yp+8tqrm0jySu6cnmdFs88hw7Le40Ssw/sgB7C2iabGUzcfNg6dqd4hw7l7kSL0XJL9B0OrSzZd7s5xWfBe6Xrf7I6Toyx5Y8eVbhjORNudSz5RrWnK5rJWsCLlZ76JRdSa8AW4iSchXyxYYXlfz4oE3arRRXSblaveJOcy4lVlKYsVTipYwquZLCifxvyVvyQwYAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAtu/m5hYXpmowrfeFqwAAAABJRU5ErkJggg== [Logging Date Time: 2016-11-10 10:23:15,926] ===================================================================================== SQL Command - DataXmlToDictionary : O_JuminNo [Logging Date Time: 2016-11-10 10:23:15,926] ===================================================================================== SQL Command - DataXmlToDictionary : 1 [Logging Date Time: 2016-11-10 10:23:15,926] ===================================================================================== SQL Command - DataXmlToDictionary 2 : O_JuminNo/790518 [Logging Date Time: 2016-11-10 10:23:15,926] ===================================================================================== SQL Command - DataXmlToDictionary : IO_INPUTNM [Logging Date Time: 2016-11-10 10:23:15,926] ===================================================================================== SQL Command - DataXmlToDictionary : 1 [Logging Date Time: 2016-11-10 10:23:15,926] ===================================================================================== SQL Command - DataXmlToDictionary 2 : IO_INPUTNM/이봉렬 [Logging Date Time: 2016-11-10 10:23:15,926] ===================================================================================== SQL Command - DataXmlToDictionary : IO_verbal [Logging Date Time: 2016-11-10 10:23:15,926] ===================================================================================== SQL Command - DataXmlToDictionary : 1 [Logging Date Time: 2016-11-10 10:23:15,927] ===================================================================================== SQL Command - DataXmlToDictionary 2 : IO_verbal/ [Logging Date Time: 2016-11-10 10:23:15,927] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 0/page-template-data [Logging Date Time: 2016-11-10 10:23:15,927] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 2/pen-drawing [Logging Date Time: 2016-11-10 10:23:15,927] ===================================================================================== SQL Command - DataXmlToDictionary : page [Logging Date Time: 2016-11-10 10:23:15,927] ===================================================================================== SQL Command - DataXmlToDictionary : 15 [Logging Date Time: 2016-11-10 10:23:15,927] ===================================================================================== SQL Command - DataXmlToDictionary : page [Logging Date Time: 2016-11-10 10:23:15,927] ===================================================================================== SQL Command - DataXmlToDictionary : 0 [Logging Date Time: 2016-11-10 10:23:15,927] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 4/changed-form [Logging Date Time: 2016-11-10 10:23:15,927] ===================================================================================== SQL Command - DataXmlToDictionary : attach-page [Logging Date Time: 2016-11-10 10:23:15,927] ===================================================================================== SQL Command - DataXmlToDictionary : 2 [Logging Date Time: 2016-11-10 10:23:15,927] ===================================================================================== SQL Command - DataXmlToDictionary : pagetemplates [Logging Date Time: 2016-11-10 10:23:15,927] ===================================================================================== SQL Command - DataXmlToDictionary : 0 [Logging Date Time: 2016-11-10 10:23:15,927] ===================================================================================== SQL Command - DataXmlToDictionary : externalgroups [Logging Date Time: 2016-11-10 10:23:15,928] ===================================================================================== SQL Command - DataXmlToDictionary : 5 [Logging Date Time: 2016-11-10 10:23:15,928] ===================================================================================== SQL Command - DataXmlToDictionary : changed [Logging Date Time: 2016-11-10 10:23:15,928] ===================================================================================== SQL Command - DataXmlToDictionary : 2 [Logging Date Time: 2016-11-10 10:23:15,928] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 0/viewer-info [Logging Date Time: 2016-11-10 10:23:15,928] ===================================================================================== SQL Command - DataXmlToDictionary 0 : 0/form-info [Logging Date Time: 2016-11-10 10:23:15,929] ===================================================================================== 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-11-10 10:23:15,929] ===================================================================================== 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-11-10 10:23:15,929] ===================================================================================== SQL Command - Statement Id: [SET_MEDI_HISTORY] Parameters: [param0=[patientCode,1715813], param1=[clnDate,20161110], param2=[bp,02], param3=[dm,02], param4=[heart,02], param5=[kidney,02], param6=[respiration,02], param7=[hx,03], param8=[allergy,03], param9=[drug,03], param10=[smoking,03], param11=[idio,01], param12=[nacrotics,01], param13=[airway,01], param14=[hemorrhage,01], param15=[status_etc,], param16=[userId,105066]] [Logging Date Time: 2016-11-10 10:23:15,929] ===================================================================================== SQL Command - Statement Id: [SET_MEDI_HISTORY] Parameters: [param0=[patientCode,1715813], param1=[clnDate,20161110], param2=[bp,02], param3=[dm,02], param4=[heart,02], param5=[kidney,02], param6=[respiration,02], param7=[hx,03], param8=[allergy,03], param9=[drug,03], param10=[smoking,03], param11=[idio,01], param12=[nacrotics,01], param13=[airway,01], param14=[hemorrhage,01], param15=[status_etc,], param16=[userId,105066]] [Logging Date Time: 2016-11-10 10:23:15,930] ===================================================================================== SQL Command - Statement Id: [SET_MEDI_HISTORY] 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], param12=[AnsiString, System.String], param13=[AnsiString, System.String], param14=[AnsiString, System.String], param15=[AnsiString, System.String], param16=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 10:23:15,930] ===================================================================================== SQL Command - Statement Id: [SET_MEDI_HISTORY] 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], param12=[AnsiString, System.String], param13=[AnsiString, System.String], param14=[AnsiString, System.String], param15=[AnsiString, System.String], param16=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 10:23:16,018] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_LIST] PreparedStatement : [SELECT CM.CONSENT_MST_RID , DECODE(CM.CONSENT_STATE, 'TEMP' ,'임시저장', 'ELECTR_CMP', '서명', 'PAPER_OUT', '출력' , 'CERTIFY_CMP', '인증', 'UNFINISHED', '미작성', 'VERBAL', '구두') AS CONSENT_STATE_DISP , VEF.FORM_NAME AS CONSENT_NAME , CM.HOS_TYPE , CM.PID , CM.VISIT_TYPE , CM.ORDER_NO , CM.ORDER_CD , CM.ORDER_NAME , CM.CLN_DEPT_CD , (SELECT DEPTHNGNM FROM COM.ZSDDDEPT WHERE DEPTCD = CM.CLN_DEPT_CD and valitodd = '99991231' and instcd = '111') AS CLN_DEPT_NM , COM.FN_ZS_GETDEPTNAME('111', (select dept.deptcd from com.zsdddept dept where dept.instcd = '111' and dept.valitodd = '99991231' and dept.deptengabbr = CM.WARDCD), '99991231') as WARDCD , CM.ROOMCD , CM.FORM_RID , VEF.FORM_CD , VEF.FORM_GUID , C.PRNTCNT , CM.CONSENT_STATE AS CONSENT_STATE , CM.OCR_NUMBER , CM.COSIGN_DC_ID , CM.COSIGN_DC_NAME , CM.MODIFY_USER_ID AS CREATE_USER_ID , CM.MODIFY_USER_NAME AS CREATE_USER_NAME , CM.MODIFY_DATETIME AS CREATE_DATETIME , CM.CLN_DATE , CM.CRETNO , (SELECT OCRTAGPRNTYN FROM V_EFORM_FORMDOC F WHERE F.FORM_RID = CM.FORM_RID ) AS OCRTAGPRNTYN FROM CONSENT_MST CM INNER JOIN EFORM_DOCUMENT VEF ON VEF.FORM_RID = CM.FORM_RID, EMR.MRFMFORM C WHERE CM.USE_YN = 'Y' AND CM.PID = :param0 AND TO_CHAR(TO_DATE(CM.CREATE_DATETIME, 'YYYY-MM-DD HH24:MI:SS'), 'YYYYMMDD') BETWEEN :param1 and :param2 AND VEF.FORM_CD = C.FORMCD AND C.instcd = '111' AND C.formprogflag LIKE 'OCR%' AND C.formlevlcd != '-' AND SUBSTR (C.formtodt, 1, 8) = '99991231' AND CM.CONSENT_STATE IN ('UNFINISHED','TEMP') ORDER BY CONSENT_STATE DESC, CREATE_DATETIME DESC] [Logging Date Time: 2016-11-10 10:23:16,018] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_LIST] PreparedStatement : [SELECT CM.CONSENT_MST_RID , DECODE(CM.CONSENT_STATE, 'TEMP' ,'임시저장', 'ELECTR_CMP', '서명', 'PAPER_OUT', '출력' , 'CERTIFY_CMP', '인증', 'UNFINISHED', '미작성', 'VERBAL', '구두') AS CONSENT_STATE_DISP , VEF.FORM_NAME AS CONSENT_NAME , CM.HOS_TYPE , CM.PID , CM.VISIT_TYPE , CM.ORDER_NO , CM.ORDER_CD , CM.ORDER_NAME , CM.CLN_DEPT_CD , (SELECT DEPTHNGNM FROM COM.ZSDDDEPT WHERE DEPTCD = CM.CLN_DEPT_CD and valitodd = '99991231' and instcd = '111') AS CLN_DEPT_NM , COM.FN_ZS_GETDEPTNAME('111', (select dept.deptcd from com.zsdddept dept where dept.instcd = '111' and dept.valitodd = '99991231' and dept.deptengabbr = CM.WARDCD), '99991231') as WARDCD , CM.ROOMCD , CM.FORM_RID , VEF.FORM_CD , VEF.FORM_GUID , C.PRNTCNT , CM.CONSENT_STATE AS CONSENT_STATE , CM.OCR_NUMBER , CM.COSIGN_DC_ID , CM.COSIGN_DC_NAME , CM.MODIFY_USER_ID AS CREATE_USER_ID , CM.MODIFY_USER_NAME AS CREATE_USER_NAME , CM.MODIFY_DATETIME AS CREATE_DATETIME , CM.CLN_DATE , CM.CRETNO , (SELECT OCRTAGPRNTYN FROM V_EFORM_FORMDOC F WHERE F.FORM_RID = CM.FORM_RID ) AS OCRTAGPRNTYN FROM CONSENT_MST CM INNER JOIN EFORM_DOCUMENT VEF ON VEF.FORM_RID = CM.FORM_RID, EMR.MRFMFORM C WHERE CM.USE_YN = 'Y' AND CM.PID = :param0 AND TO_CHAR(TO_DATE(CM.CREATE_DATETIME, 'YYYY-MM-DD HH24:MI:SS'), 'YYYYMMDD') BETWEEN :param1 and :param2 AND VEF.FORM_CD = C.FORMCD AND C.instcd = '111' AND C.formprogflag LIKE 'OCR%' AND C.formlevlcd != '-' AND SUBSTR (C.formtodt, 1, 8) = '99991231' AND CM.CONSENT_STATE IN ('UNFINISHED','TEMP') ORDER BY CONSENT_STATE DESC, CREATE_DATETIME DESC] [Logging Date Time: 2016-11-10 10:23:16,018] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_LIST] Parameters: [param0=[patientCode,1715813], param1=[startDt,20010601], param2=[endDt,20161110]] [Logging Date Time: 2016-11-10 10:23:16,018] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_LIST] Parameters: [param0=[patientCode,1715813], param1=[startDt,20010601], param2=[endDt,20161110]] [Logging Date Time: 2016-11-10 10:23:16,018] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_LIST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 10:23:16,018] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_LIST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 10:23:34,803] ===================================================================================== SQL Command - CLIP.eForm SaveCompleteAll param : clnDept[105066]patientCode[1715813]clnDeptCode[2010400000]formRid[1307]formCd[1300010589]consentMstRid[1842]rewriteConsentMstRid[0]deviceType[WIN]vistType[O]hosType[111]clnDate[20161110]ward[]roomcd[]orderNo[111]orderName[코감기]orderCd[J00.000.08]ocrCode[2016111063775]cretno[1]createUserName[이봉렬]modifyUserName[이봉렬]imageFileJson[{ "imageFile1" : "201611/10/2e12fd3d085f40968c078af29fee60c6_1.jpg", "imageFile2" : "201611/10/2e12fd3d085f40968c078af29fee60c6_2.jpg" }]certTarget[278a4c26b11e2327060a0f51ddad21bea5f49f32e035bcd23d468b4cd2fc3^d57fffbbe6132bb57bbd045394b7f79a3ea62f5ad6f890e1f682d91cfc25a2]dschdd[20161110]consentState[ELECTR_CMP]mainDrId[105066]dataXml[460,2204,460,2204?455,2204,452,2204?450,2201,447,2201?444,2199,442,2196?442,2191,439,2185?434,2180,434,2172?434,2167,434,2156?439,2148,442,2138?444,2125,450,2111?455,2098,460,2085?471,2069,479,2056?487,2040,500,2027?511,2011,521,1995?532,1982,542,1966?556,1953,564,1939?577,1929,585,1918?593,1908,603,1900?609,1894,614,1894?616,1894,619,1894?622,1900,622,1905?619,1918,619,1929?616,1945,611,1958?609,1976,603,1995?595,2016,590,2040?585,2061,579,2085?577,2109,569,2130?564,2154,561,2172?558,2191,558,2201?558,2209,558,2215?561,2215,564,2212?569,2204,577,2193?582,2180,590,2167?595,2151,606,2138?614,2122,619,2111?627,2098,635,2088?643,2077,648,2072?651,2066,659,2061?664,2058,667,2058?669,2058,672,2058?675,2061,677,2066?677,2069,680,2074?680,2085,680,2093?685,2101,685,2111?685,2119,688,2130?688,2140,691,2148?691,2156,693,2159?696,2167,698,2167?701,2167,704,2159?706,2156,714,2148?717,2140,722,2130?728,2119,730,2111?736,2101,743,2090?749,2085,754,2074?759,2072,762,2066?770,2064,773,2064?773,2061,775,2064?778,2064,778,2066?781,2069,781,2072?783,2074,783,2077?783,2085,786,2088?788,2090,788,2096?791,2098,791,2101?796,2109,799,2111?799,2114,802,2117?804,2117,804,2119?807,2122,807,2122?810,2125,812,2125?815,2125,818,2122?823,2119,826,2117?831,2114,833,2111?836,2103,839,2101?841,2098,844,2096?844,2096466,1254,466,1254?460,1262,458,1265?458,1265,458,1265?458,1265,460,1265?460,1262,468,1254?471,1249,476,1244?484,1236,495,1222?503,1214,508,1206?516,1196,527,1188?534,1180,542,1172?550,1167,556,1159?564,1154,569,1151?572,1143,579,1140?582,1138,582,1138?582,1138,582,1140?579,1140,579,1146?577,1151,569,1156?566,1162,561,1169?558,1177,556,1185?553,1193,548,1201?548,1212,542,1217?542,1225,542,1233?542,1238,542,1244?542,1246,548,1249?550,1251,553,1251?556,1251,558,1251?561,1251,566,1251?569,1249,572,1249?577,1246,579,1249?579,1251,582,1257?582,1262,582,1267?582,1273,582,1275?582,1281669,1217,669,1217?672,1217,675,1214?677,1214,680,1212?685,1212,688,1209?691,1209,691,1206?693,1206,696,1201?698,1201,701,1199?701,1199,704,1196?704,1196640,1601,640,1601?632,1609,624,1619?619,1625,614,1632?609,1638,603,1646?598,1648,598,1648?598,1648,598,1648?603,1646,609,1638?614,1632,622,1627?632,1619,643,1609?651,1601,661,1593?672,1582,680,1574?691,1566,698,1561?706,1550,714,1548?722,1543,728,1540?730,1535,736,1535?741,1529,743,1529?743,1527,743,1527?746,1529,746,1535?746,1537,746,1540?746,1543,743,1545?743,1550,743,1553?741,1561,741,1564?741,1572,743,1577?743,1582,743,1593?743,1601,746,1609?746,1619,746,1627?746,1632,749,1643?749,1648,751,1656?754,1662,754,1664?757,1672,759,1675857,1638,857,1638?860,1638,860,1638?863,1635,865,1635?868,1635,870,1632?873,1630,873,1627?878,1625,881,1622?884,1619,884,1617?886,1609,889,1603?892,1601,894,1595?894,1590,897,1580?897,1574,900,1569?900,1566,900,1561?900,1556,900,1553?900,1550,897,1548?897,1548,894,1548?892,1548,892,1550?889,1553,886,1556?884,1561,884,1566?881,1569,881,1574?878,1580,878,1585?881,1590,881,1595?884,1601,886,1603?886,1606,892,1606?894,1609,897,1609?905,1606,910,1606?915,1603,921,1598?926,1595,937,1590?942,1585,945,1580?950,1572,950,1572995,1482,995,1482?995,1479,995,1479?995,1474,995,1479?992,1479,992,1482?992,1484,990,1490?987,1495,987,1500?982,1508,982,1513?982,1519,982,1521?982,1527,987,1529?987,1529,990,1535?992,1535,995,1535?1000,1529,1005,1529?1008,1527,1016,1527?1021,1524,1027,1521?1032,1521,1035,1519?1037,1519,1042,1519?1042,1519,1045,1519?1045,1519,1045,1521?1045,1524,1045,1527?1042,1529,1037,1535?1037,1540,1035,1543?1032,1548,1032,1550?1029,1553,1029,15531130,1397,1130,1397?1132,1389,1138,1386?1140,1384,1146,1381?1151,1381,1151,1381?1154,1381,1156,1381?1156,1381,1159,1384?1159,1384,1159,1389?1159,1392,1159,1397?1159,1402,1159,1408?1159,1413,1159,1418?1162,1426,1162,1431?1162,1434,1164,1439?1164,1442,1167,1445?1169,1447,1172,1447?1177,1453,1180,1453?1185,1453,1191,1447?1196,1447,1206,1445?1212,1442,1220,1439?1225,1434,1236,1431?1241,1429,1249,1426?1254,1421,1265,1416?1270,1416,1275,1413?1278,1410,1281,1408?1281,1408,1281,14081159,1460,1159,1460?1156,1463,1154,1466?1154,1468,1154,1468?1156,1466,1162,1463?1167,1460,1172,1458?1180,1455,1188,1447?1193,1445,1199,1439?1209,1437,1214,1431?1220,1429,1225,1426?1233,1421,1233,1421881,2267,881,2267?878,2273,878,2273?878,2273,878,2273?873,2267,873,2267?878,2265,878,2265?881,2262,884,2257?889,2254,894,2249?900,2241,908,2236?915,2228,923,2220?934,2207,945,2199?955,2185,966,2178?976,2167,990,2154?997,2146,1005,2138?1016,2130,1016,21301024,2103,1024,2103?1019,2109,1013,2114?1003,2117,1000,2122?997,2125,992,2127?990,2133,987,2138?982,2143,979,2148?979,2154,976,2159?976,2170,976,2178?976,2185,976,2199?976,2209,976,2225?979,2238,979,2254?982,2273,987,2289?987,2307,990,2323?992,2342,995,2363?997,2376,1000,2394?1003,2410,1005,2421?1008,2432,1013,2442?1016,2447,1019,2453?1021,2453,1024,24551106,2275,1106,2275?1109,2275,1109,2275?1109,2278,1109,2281?1109,2283,1106,2286?1106,2291,1103,2294?1103,2302,1103,2305?1103,2307,1103,2307?1106,2307,1106,2307?1109,2307,1111,2305?1114,2302,1119,2297?1124,2291,1130,2283?1135,2278,1138,2267?1143,2257,1146,2249?1154,2236,1156,2225?1162,2215,1164,2204?1167,2196,1169,2183?1169,2178,1172,2170?1172,2164,1172,2159?1172,2156,1169,2154?1167,2154,1164,2154?1162,2154,1159,2156?1154,2164,1146,2170?1143,2175,1138,2183?1132,2193,1130,2201?1124,2209,1119,2220?1117,2230,1114,2238?1111,2249,1111,2260?1109,2267,1109,2275?1111,2283,1111,2291?1114,2297,1117,2305?1124,2307,1127,2312?1132,2312,1138,2315?1143,2315,1151,2312?1159,2312,1164,2307?1172,2305,1180,22971315,2119,1315,2119?1315,2119,1315,2117?1315,2119,1310,2122?1310,2125,1304,2130?1302,2138,1296,2146?1291,2156,1283,2167?1278,2175,1273,2185?1270,2196,1265,2207?1262,2215,1257,2222?1257,2228,1262,2230?1262,2233,1265,2233?1270,2230,1275,2228?1281,2225,1291,2220?1296,2212,1304,2207?1310,2201,1320,2199?1326,2193,1331,2191?1334,2191,1336,2191?1339,2191,1344,2193?1344,2196,1344,2199?1344,2204,1339,2209?1336,2215,1334,2225?1328,2233,1323,2241?1318,2252,1310,2260?1304,2267,1299,2281?1291,2289,1283,2297?1278,2305,1273,2310?1267,23151357,2008,1357,2008?1363,1995,1371,1984?1376,1974,1381,1963?1384,1953,1386,1945?1392,1937,1397,1931?1400,1926,1400,1921?1400,1921,1402,1921?1402,1921,1402,1924?1402,1929,1402,1934?1400,1945,1400,1955?1397,1966,1392,1979?1389,1992,1389,2008?1386,2021,1384,2037?1384,2056,1381,2069?1381,2085,1384,2098?1384,2111,1386,2122?1389,2127,1392,2138?1397,2140,1400,2143?1402,2146,1408,2146?1413,2146,1416,2146?1421,2146,1426,2143?1431,2143,1434,2140?1437,2140,1439,2138?1442,2138,1445,2133?1445,2133,1447,2130?1447,2127,1445,2125?1445,2122,1442,2119?1437,2114,1434,2111?1429,2109,1426,2103?1416,2101,1410,2096?1405,2093,1397,2090?1386,2090,1378,2088?1371,2088,1360,2088?1349,2088,1339,2088?1331,2088,1323,2090?1318,2090,1310,20931606,2170,1606,2170?1603,2172,1603,2178?1601,2180,1598,2180?1598,2183,1598,2183?1598,2183,1598,2183?1598,2183,1601,2180?1603,2178,1606,2172?1611,2167,1619,2159?1625,2151,1630,2140?1635,2130,1646,2119?1651,2109,1656,2096?1659,2085,1662,2072?1667,2061,1672,2045?1672,2032,1675,2019?1677,2006,1677,1987?1680,1974,1680,1955?1680,1939,1683,1926?1683,1910,1683,1897?1683,1884,1680,1876?1680,1868,1677,1857?1677,1852,1675,1847?1672,1844,1667,1842?1662,1839,1659,1836?1654,1836,1651,1836?1646,1839,1643,1842?1635,1847,1632,1852?1627,1863,1625,1871?1622,1881,1619,1894?1617,1908,1611,1924?1611,1937,1611,1953?1617,1968,1619,1987?1622,2003,1625,2016?1630,2032,1635,2045?1646,2061,1651,2072?1659,2085,1667,2093?1677,2103,1685,2114?1691,2119,1701,2125?1709,2130,1714,2138?1720,2140,1728,2143?1733,2146,1736,2148?1738,21511550,1995,1550,1995?1550,1995,1553,1992?1564,1990,1572,1984?1582,1976,1598,1966?1617,1958,1632,1947?1651,1934,1675,1924?1693,1908,1717,1897?1741,1884,1765,1873?1786,1863,1786,1863]formXml[
460,2204,460,2204?455,2204,452,2204?450,2201,447,2201?444,2199,442,2196?442,2191,439,2185?434,2180,434,2172?434,2167,434,2156?439,2148,442,2138?444,2125,450,2111?455,2098,460,2085?471,2069,479,2056?487,2040,500,2027?511,2011,521,1995?532,1982,542,1966?556,1953,564,1939?577,1929,585,1918?593,1908,603,1900?609,1894,614,1894?616,1894,619,1894?622,1900,622,1905?619,1918,619,1929?616,1945,611,1958?609,1976,603,1995?595,2016,590,2040?585,2061,579,2085?577,2109,569,2130?564,2154,561,2172?558,2191,558,2201?558,2209,558,2215?561,2215,564,2212?569,2204,577,2193?582,2180,590,2167?595,2151,606,2138?614,2122,619,2111?627,2098,635,2088?643,2077,648,2072?651,2066,659,2061?664,2058,667,2058?669,2058,672,2058?675,2061,677,2066?677,2069,680,2074?680,2085,680,2093?685,2101,685,2111?685,2119,688,2130?688,2140,691,2148?691,2156,693,2159?696,2167,698,2167?701,2167,704,2159?706,2156,714,2148?717,2140,722,2130?728,2119,730,2111?736,2101,743,2090?749,2085,754,2074?759,2072,762,2066?770,2064,773,2064?773,2061,775,2064?778,2064,778,2066?781,2069,781,2072?783,2074,783,2077?783,2085,786,2088?788,2090,788,2096?791,2098,791,2101?796,2109,799,2111?799,2114,802,2117?804,2117,804,2119?807,2122,807,2122?810,2125,812,2125?815,2125,818,2122?823,2119,826,2117?831,2114,833,2111?836,2103,839,2101?841,2098,844,2096?844,2096466,1254,466,1254?460,1262,458,1265?458,1265,458,1265?458,1265,460,1265?460,1262,468,1254?471,1249,476,1244?484,1236,495,1222?503,1214,508,1206?516,1196,527,1188?534,1180,542,1172?550,1167,556,1159?564,1154,569,1151?572,1143,579,1140?582,1138,582,1138?582,1138,582,1140?579,1140,579,1146?577,1151,569,1156?566,1162,561,1169?558,1177,556,1185?553,1193,548,1201?548,1212,542,1217?542,1225,542,1233?542,1238,542,1244?542,1246,548,1249?550,1251,553,1251?556,1251,558,1251?561,1251,566,1251?569,1249,572,1249?577,1246,579,1249?579,1251,582,1257?582,1262,582,1267?582,1273,582,1275?582,1281669,1217,669,1217?672,1217,675,1214?677,1214,680,1212?685,1212,688,1209?691,1209,691,1206?693,1206,696,1201?698,1201,701,1199?701,1199,704,1196?704,1196640,1601,640,1601?632,1609,624,1619?619,1625,614,1632?609,1638,603,1646?598,1648,598,1648?598,1648,598,1648?603,1646,609,1638?614,1632,622,1627?632,1619,643,1609?651,1601,661,1593?672,1582,680,1574?691,1566,698,1561?706,1550,714,1548?722,1543,728,1540?730,1535,736,1535?741,1529,743,1529?743,1527,743,1527?746,1529,746,1535?746,1537,746,1540?746,1543,743,1545?743,1550,743,1553?741,1561,741,1564?741,1572,743,1577?743,1582,743,1593?743,1601,746,1609?746,1619,746,1627?746,1632,749,1643?749,1648,751,1656?754,1662,754,1664?757,1672,759,1675857,1638,857,1638?860,1638,860,1638?863,1635,865,1635?868,1635,870,1632?873,1630,873,1627?878,1625,881,1622?884,1619,884,1617?886,1609,889,1603?892,1601,894,1595?894,1590,897,1580?897,1574,900,1569?900,1566,900,1561?900,1556,900,1553?900,1550,897,1548?897,1548,894,1548?892,1548,892,1550?889,1553,886,1556?884,1561,884,1566?881,1569,881,1574?878,1580,878,1585?881,1590,881,1595?884,1601,886,1603?886,1606,892,1606?894,1609,897,1609?905,1606,910,1606?915,1603,921,1598?926,1595,937,1590?942,1585,945,1580?950,1572,950,1572995,1482,995,1482?995,1479,995,1479?995,1474,995,1479?992,1479,992,1482?992,1484,990,1490?987,1495,987,1500?982,1508,982,1513?982,1519,982,1521?982,1527,987,1529?987,1529,990,1535?992,1535,995,1535?1000,1529,1005,1529?1008,1527,1016,1527?1021,1524,1027,1521?1032,1521,1035,1519?1037,1519,1042,1519?1042,1519,1045,1519?1045,1519,1045,1521?1045,1524,1045,1527?1042,1529,1037,1535?1037,1540,1035,1543?1032,1548,1032,1550?1029,1553,1029,15531130,1397,1130,1397?1132,1389,1138,1386?1140,1384,1146,1381?1151,1381,1151,1381?1154,1381,1156,1381?1156,1381,1159,1384?1159,1384,1159,1389?1159,1392,1159,1397?1159,1402,1159,1408?1159,1413,1159,1418?1162,1426,1162,1431?1162,1434,1164,1439?1164,1442,1167,1445?1169,1447,1172,1447?1177,1453,1180,1453?1185,1453,1191,1447?1196,1447,1206,1445?1212,1442,1220,1439?1225,1434,1236,1431?1241,1429,1249,1426?1254,1421,1265,1416?1270,1416,1275,1413?1278,1410,1281,1408?1281,1408,1281,14081159,1460,1159,1460?1156,1463,1154,1466?1154,1468,1154,1468?1156,1466,1162,1463?1167,1460,1172,1458?1180,1455,1188,1447?1193,1445,1199,1439?1209,1437,1214,1431?1220,1429,1225,1426?1233,1421,1233,1421881,2267,881,2267?878,2273,878,2273?878,2273,878,2273?873,2267,873,2267?878,2265,878,2265?881,2262,884,2257?889,2254,894,2249?900,2241,908,2236?915,2228,923,2220?934,2207,945,2199?955,2185,966,2178?976,2167,990,2154?997,2146,1005,2138?1016,2130,1016,21301024,2103,1024,2103?1019,2109,1013,2114?1003,2117,1000,2122?997,2125,992,2127?990,2133,987,2138?982,2143,979,2148?979,2154,976,2159?976,2170,976,2178?976,2185,976,2199?976,2209,976,2225?979,2238,979,2254?982,2273,987,2289?987,2307,990,2323?992,2342,995,2363?997,2376,1000,2394?1003,2410,1005,2421?1008,2432,1013,2442?1016,2447,1019,2453?1021,2453,1024,24551106,2275,1106,2275?1109,2275,1109,2275?1109,2278,1109,2281?1109,2283,1106,2286?1106,2291,1103,2294?1103,2302,1103,2305?1103,2307,1103,2307?1106,2307,1106,2307?1109,2307,1111,2305?1114,2302,1119,2297?1124,2291,1130,2283?1135,2278,1138,2267?1143,2257,1146,2249?1154,2236,1156,2225?1162,2215,1164,2204?1167,2196,1169,2183?1169,2178,1172,2170?1172,2164,1172,2159?1172,2156,1169,2154?1167,2154,1164,2154?1162,2154,1159,2156?1154,2164,1146,2170?1143,2175,1138,2183?1132,2193,1130,2201?1124,2209,1119,2220?1117,2230,1114,2238?1111,2249,1111,2260?1109,2267,1109,2275?1111,2283,1111,2291?1114,2297,1117,2305?1124,2307,1127,2312?1132,2312,1138,2315?1143,2315,1151,2312?1159,2312,1164,2307?1172,2305,1180,22971315,2119,1315,2119?1315,2119,1315,2117?1315,2119,1310,2122?1310,2125,1304,2130?1302,2138,1296,2146?1291,2156,1283,2167?1278,2175,1273,2185?1270,2196,1265,2207?1262,2215,1257,2222?1257,2228,1262,2230?1262,2233,1265,2233?1270,2230,1275,2228?1281,2225,1291,2220?1296,2212,1304,2207?1310,2201,1320,2199?1326,2193,1331,2191?1334,2191,1336,2191?1339,2191,1344,2193?1344,2196,1344,2199?1344,2204,1339,2209?1336,2215,1334,2225?1328,2233,1323,2241?1318,2252,1310,2260?1304,2267,1299,2281?1291,2289,1283,2297?1278,2305,1273,2310?1267,23151357,2008,1357,2008?1363,1995,1371,1984?1376,1974,1381,1963?1384,1953,1386,1945?1392,1937,1397,1931?1400,1926,1400,1921?1400,1921,1402,1921?1402,1921,1402,1924?1402,1929,1402,1934?1400,1945,1400,1955?1397,1966,1392,1979?1389,1992,1389,2008?1386,2021,1384,2037?1384,2056,1381,2069?1381,2085,1384,2098?1384,2111,1386,2122?1389,2127,1392,2138?1397,2140,1400,2143?1402,2146,1408,2146?1413,2146,1416,2146?1421,2146,1426,2143?1431,2143,1434,2140?1437,2140,1439,2138?1442,2138,1445,2133?1445,2133,1447,2130?1447,2127,1445,2125?1445,2122,1442,2119?1437,2114,1434,2111?1429,2109,1426,2103?1416,2101,1410,2096?1405,2093,1397,2090?1386,2090,1378,2088?1371,2088,1360,2088?1349,2088,1339,2088?1331,2088,1323,2090?1318,2090,1310,20931606,2170,1606,2170?1603,2172,1603,2178?1601,2180,1598,2180?1598,2183,1598,2183?1598,2183,1598,2183?1598,2183,1601,2180?1603,2178,1606,2172?1611,2167,1619,2159?1625,2151,1630,2140?1635,2130,1646,2119?1651,2109,1656,2096?1659,2085,1662,2072?1667,2061,1672,2045?1672,2032,1675,2019?1677,2006,1677,1987?1680,1974,1680,1955?1680,1939,1683,1926?1683,1910,1683,1897?1683,1884,1680,1876?1680,1868,1677,1857?1677,1852,1675,1847?1672,1844,1667,1842?1662,1839,1659,1836?1654,1836,1651,1836?1646,1839,1643,1842?1635,1847,1632,1852?1627,1863,1625,1871?1622,1881,1619,1894?1617,1908,1611,1924?1611,1937,1611,1953?1617,1968,1619,1987?1622,2003,1625,2016?1630,2032,1635,2045?1646,2061,1651,2072?1659,2085,1667,2093?1677,2103,1685,2114?1691,2119,1701,2125?1709,2130,1714,2138?1720,2140,1728,2143?1733,2146,1736,2148?1738,21511550,1995,1550,1995?1550,1995,1553,1992?1564,1990,1572,1984?1582,1976,1598,1966?1617,1958,1632,1947?1651,1934,1675,1924?1693,1908,1717,1897?1741,1884,1765,1873?1786,1863,1786,1863
]certResult[]