fatimaConsentApi/CLIP.e-Form.Consent.Dfh.Web/Logs/eFormServer.iBATIS.log_2016-11-25

[Logging Date Time: 2016-11-25 17:49:56,192] =====================================================================================
SQL Command - Statement Id: [UPDATE_SEQUENCE] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:49:56,192] =====================================================================================
SQL Command - Statement Id: [UPDATE_SEQUENCE] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:49:56,375] =====================================================================================
SQL Command - Statement Id: [INSERT_CONSENT_MST] PreparedStatement : [insert into CONSENT_MST          (            CONSENT_MST_RID,            HOS_TYPE,             PID,            VISIT_TYPE,            OCR_NUMBER,            CLN_DEPT_CD,            CLN_DATE,            CRETNO,            WARDCD,            ROOMCD,            FORM_RID,            CONSENT_STATE,            COMPLETE_YN,            COMPLETE_DATETIME,            PAPER_YN,            REISSUE_YN,            REISSUE_CONSENT_MST_RID,            REWRITE_YN,            REWRITE_CONSENT_MST_RID,            USE_YN,            MAIN_DR_ID,            CREATE_USER_ID,            CREATE_DATETIME,            MODIFY_USER_ID,            MODIFY_DATETIME,            CREATE_USER_NAME,            MODIFY_USER_NAME          )          values          (             :param0 ,             :param1 ,             :param2 ,             :param3 ,             :param4 ,             :param5 ,             :param6 ,             :param7 ,             :param8 ,             :param9 ,             :param10 ,             :param11 ,             :param12 ,            '',             :param13 ,             :param14 ,             :param15 ,             :param16 ,             :param17 ,            'Y',             :param18 ,             :param19 ,            TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'),             :param19 ,            TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'),             :param20 ,             :param21           )]

[Logging Date Time: 2016-11-25 17:49:56,375] =====================================================================================
SQL Command - Statement Id: [INSERT_CONSENT_MST] PreparedStatement : [insert into CONSENT_MST          (            CONSENT_MST_RID,            HOS_TYPE,             PID,            VISIT_TYPE,            OCR_NUMBER,            CLN_DEPT_CD,            CLN_DATE,            CRETNO,            WARDCD,            ROOMCD,            FORM_RID,            CONSENT_STATE,            COMPLETE_YN,            COMPLETE_DATETIME,            PAPER_YN,            REISSUE_YN,            REISSUE_CONSENT_MST_RID,            REWRITE_YN,            REWRITE_CONSENT_MST_RID,            USE_YN,            MAIN_DR_ID,            CREATE_USER_ID,            CREATE_DATETIME,            MODIFY_USER_ID,            MODIFY_DATETIME,            CREATE_USER_NAME,            MODIFY_USER_NAME          )          values          (             :param0 ,             :param1 ,             :param2 ,             :param3 ,             :param4 ,             :param5 ,             :param6 ,             :param7 ,             :param8 ,             :param9 ,             :param10 ,             :param11 ,             :param12 ,            '',             :param13 ,             :param14 ,             :param15 ,             :param16 ,             :param17 ,            'Y',             :param18 ,             :param19 ,            TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'),             :param19 ,            TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'),             :param20 ,             :param21           )]

[Logging Date Time: 2016-11-25 17:49:56,376] =====================================================================================
SQL Command - Statement Id: [INSERT_CONSENT_MST] Parameters: [param0=[consentMstRid,2366], param1=[hosType,111], param2=[patientCode,1938395], param3=[vistType,O], param4=[ocrCode,2016112564616], param5=[clnDeptCd,2010400000], param6=[clnDate,20161125], param7=[cretno,1], param8=[ward,null], param9=[roomcd,null], param10=[formRid,1062], param11=[consentState,PAPER_OUT], param12=[completeYn,N], param13=[paperYn,Y], param14=[reissueYn,N], param15=[reissueConsentMstRid,0], param16=[rewriteYn,N], param17=[rewriteConsentMstRid,0], param18=[mainDrId,107945], param19=[userId,107945], param20=[createUserName,±èÀçÈñ], param21=[modifyUserName,±èÀçÈñ]]

[Logging Date Time: 2016-11-25 17:49:56,376] =====================================================================================
SQL Command - Statement Id: [INSERT_CONSENT_MST] Parameters: [param0=[consentMstRid,2366], param1=[hosType,111], param2=[patientCode,1938395], param3=[vistType,O], param4=[ocrCode,2016112564616], param5=[clnDeptCd,2010400000], param6=[clnDate,20161125], param7=[cretno,1], param8=[ward,null], param9=[roomcd,null], param10=[formRid,1062], param11=[consentState,PAPER_OUT], param12=[completeYn,N], param13=[paperYn,Y], param14=[reissueYn,N], param15=[reissueConsentMstRid,0], param16=[rewriteYn,N], param17=[rewriteConsentMstRid,0], param18=[mainDrId,107945], param19=[userId,107945], param20=[createUserName,±èÀçÈñ], param21=[modifyUserName,±èÀçÈñ]]

[Logging Date Time: 2016-11-25 17:49:56,376] =====================================================================================
SQL Command - Statement Id: [INSERT_CONSENT_MST] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String], param5=[AnsiString, System.String], param6=[AnsiString, System.String], param7=[Int32, System.Int32], param8=[System.DBNull, null], param9=[System.DBNull, null], param10=[Int32, System.Int32], param11=[AnsiString, System.String], param12=[AnsiString, System.String], param13=[AnsiString, System.String], param14=[AnsiString, System.String], param15=[Int32, System.Int32], param16=[AnsiString, System.String], param17=[Int32, System.Int32], param18=[AnsiString, System.String], param19=[AnsiString, System.String], param20=[AnsiString, System.String], param21=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:49:56,376] =====================================================================================
SQL Command - Statement Id: [INSERT_CONSENT_MST] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String], param5=[AnsiString, System.String], param6=[AnsiString, System.String], param7=[Int32, System.Int32], param8=[System.DBNull, null], param9=[System.DBNull, null], param10=[Int32, System.Int32], param11=[AnsiString, System.String], param12=[AnsiString, System.String], param13=[AnsiString, System.String], param14=[AnsiString, System.String], param15=[Int32, System.Int32], param16=[AnsiString, System.String], param17=[Int32, System.Int32], param18=[AnsiString, System.String], param19=[AnsiString, System.String], param20=[AnsiString, System.String], param21=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:49:56,443] =====================================================================================
SQL Command - Statement Id: [getPatientInfoOut] PreparedStatement : [SELECT a.orddeptcd,               a.pid as IO_Pt_ID,               to_char(a.cretno) as IO_CretNo,               ( ptbs.sex || '/' ||                       com.fn_zz_getageas(ptbs.rrgstno1,                                          ptbs.rrgstno2,                                          TO_CHAR(SYSDATE, 'YYYYMMDD'),                                          'A',                                          ptbs.brthdd)) as IO_sex_age_y_m,               ptbs.hngnm as IO_Pt_Name,               (ptbs.rrgstno1 || '-' || substr(ptbs.rrgstno2, 1, 1) ||'******') IO_JuminNo,           ptbs.zipcdaddr as IO_Zipcdaddr,               ptbs.mpphontel as IO_Tel,           (select cdnm from com.zbcmcode where cdgrupid='P0008' and cdid =a.insukind) as IO_Insukind,               '' as IO_Ward,               '' as IO_roomNO,               a.orddd as IO_ADdate,               a.orddd as IO_Dschdd,               a.ordtype as IO_VisitType,               a.orddeptcd as IO_DeptCd,               (select dept.deptengabbr                  from com.zsdddept dept                 where dept.deptcd = a.orddeptcd                       and dept.instcd = a.instcd                       and dept.valitodd >= a.orddd                       and dept.valifromdd <= a.orddd) as IO_DeptNm,               COM.FN_ZS_GETDEPTNAME(a.instcd, a.orddeptcd, a.orddd) AS IO_Dept2,               '' AS IO_OPdeptCd,               '' AS IO_OPdeptNm,               '' AS IO_OPdrNm,               '' AS IO_OPdrId,               (SELECT diag.diagcd                  FROM emr.mmohdiag diag                 WHERE diag.pid = a.pid                       AND diag.orddd = a.orddd                       AND diag.cretno = a.cretno                       AND diag.diaghistcd = 'O'                       AND diag.diagtypecd = 'D'                       AND diag.diagkindcdflag = 'M'                       AND diag.genrflagcd = a.ordtype                       and diag.orddeptcd = a.orddeptcd                       AND diag.diaghistno = (select max(diagh.diaghistno)                                          from emr.mmohdiag diagh                                         where diagh.pid = a.pid                                               AND diagh.orddd = a.orddd                                               AND diagh.cretno = a.cretno                                               AND diagh.instcd = '111'                                               AND diagh.diaghistcd = 'O'                                                              AND diagh.diagkindcdflag = 'M'                                                              AND diagh.genrflagcd = a.ordtype                                               and diagh.orddeptcd = a.orddeptcd                                         group by pid)) as IO_DxCd,               (SELECT term.diaghngnm                  FROM emr.mmohdiag diag,                       emr.mmbvdiag term                 WHERE diag.pid = a.pid                       AND diag.orddd = a.orddd                       AND diag.cretno = a.cretno                       AND diag.instcd = term.instcd                       AND diag.diagcd = term.orgdiagcd                       AND diag.diaghistcd = 'O'                       AND diag.diagtypecd = 'D'                       AND diag.diagkindcdflag = 'M'                       AND diag.diagdd >= term.termfromdd                       AND diag.diagdd <= term.termtodd                       AND diag.diagdd >= term.diagattrfromdd                       AND diag.diagdd <= term.diagattrtodd                       AND diag.genrflagcd = a.ordtype                       and diag.orddeptcd = a.orddeptcd                       AND diag.diaghistno = (select max(diagh.diaghistno)                                          from emr.mmohdiag diagh                                         where diagh.pid = a.pid                                               AND diagh.orddd = a.orddd                                               AND diagh.cretno = a.cretno                                               AND diagh.instcd = '111'                                               AND diagh.diaghistcd = 'O'                                                              AND diagh.diagkindcdflag = 'M'                                                              AND diagh.genrflagcd = a.ordtype                                               and diagh.orddeptcd = a.orddeptcd                                         group by pid)) as IO_DxNm,               COM.FN_ZS_GETUSERNM(a.orddrid, a.orddd) as IO_MaindrNm,               '111' as IO_HosType,               case when ex.bp is null then null else ex.bp end as IO_bp,               case when ex.dm is null then null else ex.dm end as IO_dm,               case when ex.heart is null then null else ex.heart end as IO_heart,               case when ex.kidney is null then null else ex.kidney end as IO_kidney,               case when ex.respiration is null then null else ex.respiration end as IO_respiration,               case when ex.hx is null then null else ex.hx end as  IO_hx,               case when ex.allergy is null then null else ex.allergy end as  IO_allergy,               case when ex.drug is null then null else ex.drug end as  IO_drug,               case when ex.smoking is null then null else ex.smoking end as  IO_smoking,               case when ex.idio is null then null else ex.idio end as  IO_idio,               case when ex.nacrotics is null then null else ex.nacrotics end as  IO_nacrotics,               case when ex.airway is null then null else ex.airway end as  IO_airway,               case when ex.hemorrhage is null then null else ex.hemorrhage end as  IO_hemorrhage,               ex.etc IO_status_etc,               '111' as IO_OrderNo,               '111' as IO_PrintTime,               a.ORDDRID as IO_MaindrId,               '' as IO_ErdrNm,               COM.FN_ZS_GETUSERNM(a.ORDDRID, a.orddd) as IO_MaindrNm,               '111' as IO_OcrCd,               a.ORDDRID as IO_InputId,               COM.FN_ZS_GETUSERNM(a.ORDDRID, a.orddd) as IO_InputNm,               '111' as IO_SignImg          FROM pam.pmohotpt a            left outer join cmr.consent_data_ex ex              on (ex.pid = a.pid and ex.cln_date = a.orddd)            left outer join pam.pmcmptbs ptbs              on (ptbs.pid = a.pid and ptbs.instcd = a.instcd)          WHERE a.instcd =  :param0               AND a.pid =  :param1               AND a.orddd =  :param2               AND A.HISTSTAT IN ('R', 'T')              AND A.MSKIND = 'M'                          AND a.cretno =  :param3                     AND a.orddeptcd =  :param4]

[Logging Date Time: 2016-11-25 17:49:56,443] =====================================================================================
SQL Command - Statement Id: [getPatientInfoOut] PreparedStatement : [SELECT a.orddeptcd,               a.pid as IO_Pt_ID,               to_char(a.cretno) as IO_CretNo,               ( ptbs.sex || '/' ||                       com.fn_zz_getageas(ptbs.rrgstno1,                                          ptbs.rrgstno2,                                          TO_CHAR(SYSDATE, 'YYYYMMDD'),                                          'A',                                          ptbs.brthdd)) as IO_sex_age_y_m,               ptbs.hngnm as IO_Pt_Name,               (ptbs.rrgstno1 || '-' || substr(ptbs.rrgstno2, 1, 1) ||'******') IO_JuminNo,           ptbs.zipcdaddr as IO_Zipcdaddr,               ptbs.mpphontel as IO_Tel,           (select cdnm from com.zbcmcode where cdgrupid='P0008' and cdid =a.insukind) as IO_Insukind,               '' as IO_Ward,               '' as IO_roomNO,               a.orddd as IO_ADdate,               a.orddd as IO_Dschdd,               a.ordtype as IO_VisitType,               a.orddeptcd as IO_DeptCd,               (select dept.deptengabbr                  from com.zsdddept dept                 where dept.deptcd = a.orddeptcd                       and dept.instcd = a.instcd                       and dept.valitodd >= a.orddd                       and dept.valifromdd <= a.orddd) as IO_DeptNm,               COM.FN_ZS_GETDEPTNAME(a.instcd, a.orddeptcd, a.orddd) AS IO_Dept2,               '' AS IO_OPdeptCd,               '' AS IO_OPdeptNm,               '' AS IO_OPdrNm,               '' AS IO_OPdrId,               (SELECT diag.diagcd                  FROM emr.mmohdiag diag                 WHERE diag.pid = a.pid                       AND diag.orddd = a.orddd                       AND diag.cretno = a.cretno                       AND diag.diaghistcd = 'O'                       AND diag.diagtypecd = 'D'                       AND diag.diagkindcdflag = 'M'                       AND diag.genrflagcd = a.ordtype                       and diag.orddeptcd = a.orddeptcd                       AND diag.diaghistno = (select max(diagh.diaghistno)                                          from emr.mmohdiag diagh                                         where diagh.pid = a.pid                                               AND diagh.orddd = a.orddd                                               AND diagh.cretno = a.cretno                                               AND diagh.instcd = '111'                                               AND diagh.diaghistcd = 'O'                                                              AND diagh.diagkindcdflag = 'M'                                                              AND diagh.genrflagcd = a.ordtype                                               and diagh.orddeptcd = a.orddeptcd                                         group by pid)) as IO_DxCd,               (SELECT term.diaghngnm                  FROM emr.mmohdiag diag,                       emr.mmbvdiag term                 WHERE diag.pid = a.pid                       AND diag.orddd = a.orddd                       AND diag.cretno = a.cretno                       AND diag.instcd = term.instcd                       AND diag.diagcd = term.orgdiagcd                       AND diag.diaghistcd = 'O'                       AND diag.diagtypecd = 'D'                       AND diag.diagkindcdflag = 'M'                       AND diag.diagdd >= term.termfromdd                       AND diag.diagdd <= term.termtodd                       AND diag.diagdd >= term.diagattrfromdd                       AND diag.diagdd <= term.diagattrtodd                       AND diag.genrflagcd = a.ordtype                       and diag.orddeptcd = a.orddeptcd                       AND diag.diaghistno = (select max(diagh.diaghistno)                                          from emr.mmohdiag diagh                                         where diagh.pid = a.pid                                               AND diagh.orddd = a.orddd                                               AND diagh.cretno = a.cretno                                               AND diagh.instcd = '111'                                               AND diagh.diaghistcd = 'O'                                                              AND diagh.diagkindcdflag = 'M'                                                              AND diagh.genrflagcd = a.ordtype                                               and diagh.orddeptcd = a.orddeptcd                                         group by pid)) as IO_DxNm,               COM.FN_ZS_GETUSERNM(a.orddrid, a.orddd) as IO_MaindrNm,               '111' as IO_HosType,               case when ex.bp is null then null else ex.bp end as IO_bp,               case when ex.dm is null then null else ex.dm end as IO_dm,               case when ex.heart is null then null else ex.heart end as IO_heart,               case when ex.kidney is null then null else ex.kidney end as IO_kidney,               case when ex.respiration is null then null else ex.respiration end as IO_respiration,               case when ex.hx is null then null else ex.hx end as  IO_hx,               case when ex.allergy is null then null else ex.allergy end as  IO_allergy,               case when ex.drug is null then null else ex.drug end as  IO_drug,               case when ex.smoking is null then null else ex.smoking end as  IO_smoking,               case when ex.idio is null then null else ex.idio end as  IO_idio,               case when ex.nacrotics is null then null else ex.nacrotics end as  IO_nacrotics,               case when ex.airway is null then null else ex.airway end as  IO_airway,               case when ex.hemorrhage is null then null else ex.hemorrhage end as  IO_hemorrhage,               ex.etc IO_status_etc,               '111' as IO_OrderNo,               '111' as IO_PrintTime,               a.ORDDRID as IO_MaindrId,               '' as IO_ErdrNm,               COM.FN_ZS_GETUSERNM(a.ORDDRID, a.orddd) as IO_MaindrNm,               '111' as IO_OcrCd,               a.ORDDRID as IO_InputId,               COM.FN_ZS_GETUSERNM(a.ORDDRID, a.orddd) as IO_InputNm,               '111' as IO_SignImg          FROM pam.pmohotpt a            left outer join cmr.consent_data_ex ex              on (ex.pid = a.pid and ex.cln_date = a.orddd)            left outer join pam.pmcmptbs ptbs              on (ptbs.pid = a.pid and ptbs.instcd = a.instcd)          WHERE a.instcd =  :param0               AND a.pid =  :param1               AND a.orddd =  :param2               AND A.HISTSTAT IN ('R', 'T')              AND A.MSKIND = 'M'                          AND a.cretno =  :param3                     AND a.orddeptcd =  :param4]

[Logging Date Time: 2016-11-25 17:49:56,444] =====================================================================================
SQL Command - Statement Id: [getPatientInfoOut] Parameters: [param0=[instcd,111], param1=[pid,0656166], param2=[orddd,20161125], param3=[cretno,1], param4=[orddeptcd,2010400000]]

[Logging Date Time: 2016-11-25 17:49:56,444] =====================================================================================
SQL Command - Statement Id: [getPatientInfoOut] Parameters: [param0=[instcd,111], param1=[pid,0656166], param2=[orddd,20161125], param3=[cretno,1], param4=[orddeptcd,2010400000]]

[Logging Date Time: 2016-11-25 17:49:56,444] =====================================================================================
SQL Command - Statement Id: [getPatientInfoOut] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:49:56,444] =====================================================================================
SQL Command - Statement Id: [getPatientInfoOut] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:49:56,555] =====================================================================================
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-25 17:49:56,555] =====================================================================================
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-25 17:49:56,556] =====================================================================================
SQL Command - Statement Id: [GET_SEQUENCE] Parameters: [param0=[sub_cd,CONSENT_MST]]

[Logging Date Time: 2016-11-25 17:49:56,556] =====================================================================================
SQL Command - Statement Id: [GET_SEQUENCE] Parameters: [param0=[sub_cd,CONSENT_MST]]

[Logging Date Time: 2016-11-25 17:49:56,556] =====================================================================================
SQL Command - Statement Id: [GET_SEQUENCE] Types: [param0=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:49:56,556] =====================================================================================
SQL Command - Statement Id: [GET_SEQUENCE] Types: [param0=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:49:56,564] =====================================================================================
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-25 17:49:56,564] =====================================================================================
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-25 17:49:56,565] =====================================================================================
SQL Command - Statement Id: [UPDATE_SEQUENCE] Parameters: [param0=[ud1_num,2367], param1=[sub_cd,CONSENT_MST]]

[Logging Date Time: 2016-11-25 17:49:56,565] =====================================================================================
SQL Command - Statement Id: [UPDATE_SEQUENCE] Parameters: [param0=[ud1_num,2367], param1=[sub_cd,CONSENT_MST]]

[Logging Date Time: 2016-11-25 17:49:56,565] =====================================================================================
SQL Command - Statement Id: [UPDATE_SEQUENCE] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:49:56,565] =====================================================================================
SQL Command - Statement Id: [UPDATE_SEQUENCE] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:49:56,569] =====================================================================================
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-25 17:49:56,569] =====================================================================================
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-25 17:49:56,569] =====================================================================================
SQL Command - Statement Id: [GET_SEQUENCE] Parameters: [param0=[sub_cd,CONSENT_DATA]]

[Logging Date Time: 2016-11-25 17:49:56,569] =====================================================================================
SQL Command - Statement Id: [GET_SEQUENCE] Parameters: [param0=[sub_cd,CONSENT_DATA]]

[Logging Date Time: 2016-11-25 17:49:56,569] =====================================================================================
SQL Command - Statement Id: [GET_SEQUENCE] Types: [param0=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:49:56,569] =====================================================================================
SQL Command - Statement Id: [GET_SEQUENCE] Types: [param0=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:49:56,574] =====================================================================================
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-25 17:49:56,574] =====================================================================================
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-25 17:49:56,574] =====================================================================================
SQL Command - Statement Id: [UPDATE_SEQUENCE] Parameters: [param0=[ud1_num,2256], param1=[sub_cd,CONSENT_DATA]]

[Logging Date Time: 2016-11-25 17:49:56,574] =====================================================================================
SQL Command - Statement Id: [UPDATE_SEQUENCE] Parameters: [param0=[ud1_num,2256], param1=[sub_cd,CONSENT_DATA]]

[Logging Date Time: 2016-11-25 17:49:56,574] =====================================================================================
SQL Command - Statement Id: [UPDATE_SEQUENCE] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:49:56,574] =====================================================================================
SQL Command - Statement Id: [UPDATE_SEQUENCE] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:49:56,577] =====================================================================================
SQL Command - Statement Id: [INSERT_CONSENT_MST] PreparedStatement : [insert into CONSENT_MST          (            CONSENT_MST_RID,            HOS_TYPE,             PID,            VISIT_TYPE,            OCR_NUMBER,            CLN_DEPT_CD,            CLN_DATE,            CRETNO,            WARDCD,            ROOMCD,            FORM_RID,            CONSENT_STATE,            COMPLETE_YN,            COMPLETE_DATETIME,            PAPER_YN,            REISSUE_YN,            REISSUE_CONSENT_MST_RID,            REWRITE_YN,            REWRITE_CONSENT_MST_RID,            USE_YN,            MAIN_DR_ID,            CREATE_USER_ID,            CREATE_DATETIME,            MODIFY_USER_ID,            MODIFY_DATETIME,            CREATE_USER_NAME,            MODIFY_USER_NAME          )          values          (             :param0 ,             :param1 ,             :param2 ,             :param3 ,             :param4 ,             :param5 ,             :param6 ,             :param7 ,             :param8 ,             :param9 ,             :param10 ,             :param11 ,             :param12 ,            '',             :param13 ,             :param14 ,             :param15 ,             :param16 ,             :param17 ,            'Y',             :param18 ,             :param19 ,            TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'),             :param19 ,            TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'),             :param20 ,             :param21           )]

[Logging Date Time: 2016-11-25 17:49:56,577] =====================================================================================
SQL Command - Statement Id: [INSERT_CONSENT_MST] PreparedStatement : [insert into CONSENT_MST          (            CONSENT_MST_RID,            HOS_TYPE,             PID,            VISIT_TYPE,            OCR_NUMBER,            CLN_DEPT_CD,            CLN_DATE,            CRETNO,            WARDCD,            ROOMCD,            FORM_RID,            CONSENT_STATE,            COMPLETE_YN,            COMPLETE_DATETIME,            PAPER_YN,            REISSUE_YN,            REISSUE_CONSENT_MST_RID,            REWRITE_YN,            REWRITE_CONSENT_MST_RID,            USE_YN,            MAIN_DR_ID,            CREATE_USER_ID,            CREATE_DATETIME,            MODIFY_USER_ID,            MODIFY_DATETIME,            CREATE_USER_NAME,            MODIFY_USER_NAME          )          values          (             :param0 ,             :param1 ,             :param2 ,             :param3 ,             :param4 ,             :param5 ,             :param6 ,             :param7 ,             :param8 ,             :param9 ,             :param10 ,             :param11 ,             :param12 ,            '',             :param13 ,             :param14 ,             :param15 ,             :param16 ,             :param17 ,            'Y',             :param18 ,             :param19 ,            TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'),             :param19 ,            TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'),             :param20 ,             :param21           )]

[Logging Date Time: 2016-11-25 17:49:56,577] =====================================================================================
SQL Command - Statement Id: [INSERT_CONSENT_MST] Parameters: [param0=[consentMstRid,2367], param1=[hosType,111], param2=[patientCode,0656166], param3=[vistType,O], param4=[ocrCode,2016112564617], param5=[clnDeptCd,2010400000], param6=[clnDate,20161125], param7=[cretno,1], param8=[ward,null], param9=[roomcd,null], param10=[formRid,1062], param11=[consentState,PAPER_OUT], param12=[completeYn,N], param13=[paperYn,Y], param14=[reissueYn,N], param15=[reissueConsentMstRid,0], param16=[rewriteYn,N], param17=[rewriteConsentMstRid,0], param18=[mainDrId,107945], param19=[userId,107945], param20=[createUserName,±èÀçÈñ], param21=[modifyUserName,±èÀçÈñ]]

[Logging Date Time: 2016-11-25 17:49:56,577] =====================================================================================
SQL Command - Statement Id: [INSERT_CONSENT_MST] Parameters: [param0=[consentMstRid,2367], param1=[hosType,111], param2=[patientCode,0656166], param3=[vistType,O], param4=[ocrCode,2016112564617], param5=[clnDeptCd,2010400000], param6=[clnDate,20161125], param7=[cretno,1], param8=[ward,null], param9=[roomcd,null], param10=[formRid,1062], param11=[consentState,PAPER_OUT], param12=[completeYn,N], param13=[paperYn,Y], param14=[reissueYn,N], param15=[reissueConsentMstRid,0], param16=[rewriteYn,N], param17=[rewriteConsentMstRid,0], param18=[mainDrId,107945], param19=[userId,107945], param20=[createUserName,±èÀçÈñ], param21=[modifyUserName,±èÀçÈñ]]

[Logging Date Time: 2016-11-25 17:49:56,577] =====================================================================================
SQL Command - Statement Id: [INSERT_CONSENT_MST] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String], param5=[AnsiString, System.String], param6=[AnsiString, System.String], param7=[Int32, System.Int32], param8=[System.DBNull, null], param9=[System.DBNull, null], param10=[Int32, System.Int32], param11=[AnsiString, System.String], param12=[AnsiString, System.String], param13=[AnsiString, System.String], param14=[AnsiString, System.String], param15=[Int32, System.Int32], param16=[AnsiString, System.String], param17=[Int32, System.Int32], param18=[AnsiString, System.String], param19=[AnsiString, System.String], param20=[AnsiString, System.String], param21=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:49:56,577] =====================================================================================
SQL Command - Statement Id: [INSERT_CONSENT_MST] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String], param5=[AnsiString, System.String], param6=[AnsiString, System.String], param7=[Int32, System.Int32], param8=[System.DBNull, null], param9=[System.DBNull, null], param10=[Int32, System.Int32], param11=[AnsiString, System.String], param12=[AnsiString, System.String], param13=[AnsiString, System.String], param14=[AnsiString, System.String], param15=[Int32, System.Int32], param16=[AnsiString, System.String], param17=[Int32, System.Int32], param18=[AnsiString, System.String], param19=[AnsiString, System.String], param20=[AnsiString, System.String], param21=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:52:02,549] =====================================================================================
SQL Command - Statement Id: [getUserSignImage] PreparedStatement : [SELECT  signdata            FROM  emr.mrfmsignimge           WHERE  userid =  :param0              and  repryn = 'Y']

[Logging Date Time: 2016-11-25 17:52:02,549] =====================================================================================
SQL Command - Statement Id: [getUserSignImage] PreparedStatement : [SELECT  signdata            FROM  emr.mrfmsignimge           WHERE  userid =  :param0              and  repryn = 'Y']

[Logging Date Time: 2016-11-25 17:52:02,550] =====================================================================================
SQL Command - Statement Id: [getUserSignImage] Parameters: [param0=[userid,107945]]

[Logging Date Time: 2016-11-25 17:52:02,550] =====================================================================================
SQL Command - Statement Id: [getUserSignImage] Parameters: [param0=[userid,107945]]

[Logging Date Time: 2016-11-25 17:52:02,550] =====================================================================================
SQL Command - Statement Id: [getUserSignImage] Types: [param0=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:52:02,550] =====================================================================================
SQL Command - Statement Id: [getUserSignImage] Types: [param0=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:52:04,296] =====================================================================================
SQL Command - Statement Id: [getOcrTag] PreparedStatement : [SELECT to_char(sysdate,'YYYYMMDD') || SUBSTR(LPAD((EMR.SQ_MRFMOCRP_01.NEXTVAL), 10, '0'), 6, 5) AS ocrtag        FROM dual]

[Logging Date Time: 2016-11-25 17:52:04,296] =====================================================================================
SQL Command - Statement Id: [getOcrTag] PreparedStatement : [SELECT to_char(sysdate,'YYYYMMDD') || SUBSTR(LPAD((EMR.SQ_MRFMOCRP_01.NEXTVAL), 10, '0'), 6, 5) AS ocrtag        FROM dual]

[Logging Date Time: 2016-11-25 17:52:24,183] =====================================================================================
SQL Command - Statement Id: [getPatientInfoOut] PreparedStatement : [SELECT a.orddeptcd,               a.pid as IO_Pt_ID,               to_char(a.cretno) as IO_CretNo,               ( ptbs.sex || '/' ||                       com.fn_zz_getageas(ptbs.rrgstno1,                                          ptbs.rrgstno2,                                          TO_CHAR(SYSDATE, 'YYYYMMDD'),                                          'A',                                          ptbs.brthdd)) as IO_sex_age_y_m,               ptbs.hngnm as IO_Pt_Name,               (ptbs.rrgstno1 || '-' || substr(ptbs.rrgstno2, 1, 1) ||'******') IO_JuminNo,           ptbs.zipcdaddr as IO_Zipcdaddr,               ptbs.mpphontel as IO_Tel,           (select cdnm from com.zbcmcode where cdgrupid='P0008' and cdid =a.insukind) as IO_Insukind,               '' as IO_Ward,               '' as IO_roomNO,               a.orddd as IO_ADdate,               a.orddd as IO_Dschdd,               a.ordtype as IO_VisitType,               a.orddeptcd as IO_DeptCd,               (select dept.deptengabbr                  from com.zsdddept dept                 where dept.deptcd = a.orddeptcd                       and dept.instcd = a.instcd                       and dept.valitodd >= a.orddd                       and dept.valifromdd <= a.orddd) as IO_DeptNm,               COM.FN_ZS_GETDEPTNAME(a.instcd, a.orddeptcd, a.orddd) AS IO_Dept2,               '' AS IO_OPdeptCd,               '' AS IO_OPdeptNm,               '' AS IO_OPdrNm,               '' AS IO_OPdrId,               (SELECT diag.diagcd                  FROM emr.mmohdiag diag                 WHERE diag.pid = a.pid                       AND diag.orddd = a.orddd                       AND diag.cretno = a.cretno                       AND diag.diaghistcd = 'O'                       AND diag.diagtypecd = 'D'                       AND diag.diagkindcdflag = 'M'                       AND diag.genrflagcd = a.ordtype                       and diag.orddeptcd = a.orddeptcd                       AND diag.diaghistno = (select max(diagh.diaghistno)                                          from emr.mmohdiag diagh                                         where diagh.pid = a.pid                                               AND diagh.orddd = a.orddd                                               AND diagh.cretno = a.cretno                                               AND diagh.instcd = '111'                                               AND diagh.diaghistcd = 'O'                                                              AND diagh.diagkindcdflag = 'M'                                                              AND diagh.genrflagcd = a.ordtype                                               and diagh.orddeptcd = a.orddeptcd                                         group by pid)) as IO_DxCd,               (SELECT term.diaghngnm                  FROM emr.mmohdiag diag,                       emr.mmbvdiag term                 WHERE diag.pid = a.pid                       AND diag.orddd = a.orddd                       AND diag.cretno = a.cretno                       AND diag.instcd = term.instcd                       AND diag.diagcd = term.orgdiagcd                       AND diag.diaghistcd = 'O'                       AND diag.diagtypecd = 'D'                       AND diag.diagkindcdflag = 'M'                       AND diag.diagdd >= term.termfromdd                       AND diag.diagdd <= term.termtodd                       AND diag.diagdd >= term.diagattrfromdd                       AND diag.diagdd <= term.diagattrtodd                       AND diag.genrflagcd = a.ordtype                       and diag.orddeptcd = a.orddeptcd                       AND diag.diaghistno = (select max(diagh.diaghistno)                                          from emr.mmohdiag diagh                                         where diagh.pid = a.pid                                               AND diagh.orddd = a.orddd                                               AND diagh.cretno = a.cretno                                               AND diagh.instcd = '111'                                               AND diagh.diaghistcd = 'O'                                                              AND diagh.diagkindcdflag = 'M'                                                              AND diagh.genrflagcd = a.ordtype                                               and diagh.orddeptcd = a.orddeptcd                                         group by pid)) as IO_DxNm,               COM.FN_ZS_GETUSERNM(a.orddrid, a.orddd) as IO_MaindrNm,               '111' as IO_HosType,               case when ex.bp is null then null else ex.bp end as IO_bp,               case when ex.dm is null then null else ex.dm end as IO_dm,               case when ex.heart is null then null else ex.heart end as IO_heart,               case when ex.kidney is null then null else ex.kidney end as IO_kidney,               case when ex.respiration is null then null else ex.respiration end as IO_respiration,               case when ex.hx is null then null else ex.hx end as  IO_hx,               case when ex.allergy is null then null else ex.allergy end as  IO_allergy,               case when ex.drug is null then null else ex.drug end as  IO_drug,               case when ex.smoking is null then null else ex.smoking end as  IO_smoking,               case when ex.idio is null then null else ex.idio end as  IO_idio,               case when ex.nacrotics is null then null else ex.nacrotics end as  IO_nacrotics,               case when ex.airway is null then null else ex.airway end as  IO_airway,               case when ex.hemorrhage is null then null else ex.hemorrhage end as  IO_hemorrhage,               ex.etc IO_status_etc,               '111' as IO_OrderNo,               '111' as IO_PrintTime,               a.ORDDRID as IO_MaindrId,               '' as IO_ErdrNm,               COM.FN_ZS_GETUSERNM(a.ORDDRID, a.orddd) as IO_MaindrNm,               '111' as IO_OcrCd,               a.ORDDRID as IO_InputId,               COM.FN_ZS_GETUSERNM(a.ORDDRID, a.orddd) as IO_InputNm,               '111' as IO_SignImg          FROM pam.pmohotpt a            left outer join cmr.consent_data_ex ex              on (ex.pid = a.pid and ex.cln_date = a.orddd)            left outer join pam.pmcmptbs ptbs              on (ptbs.pid = a.pid and ptbs.instcd = a.instcd)          WHERE a.instcd =  :param0               AND a.pid =  :param1               AND a.orddd =  :param2               AND A.HISTSTAT IN ('R', 'T')              AND A.MSKIND = 'M'                          AND a.cretno =  :param3                     AND a.orddeptcd =  :param4]

[Logging Date Time: 2016-11-25 17:52:24,183] =====================================================================================
SQL Command - Statement Id: [getPatientInfoOut] PreparedStatement : [SELECT a.orddeptcd,               a.pid as IO_Pt_ID,               to_char(a.cretno) as IO_CretNo,               ( ptbs.sex || '/' ||                       com.fn_zz_getageas(ptbs.rrgstno1,                                          ptbs.rrgstno2,                                          TO_CHAR(SYSDATE, 'YYYYMMDD'),                                          'A',                                          ptbs.brthdd)) as IO_sex_age_y_m,               ptbs.hngnm as IO_Pt_Name,               (ptbs.rrgstno1 || '-' || substr(ptbs.rrgstno2, 1, 1) ||'******') IO_JuminNo,           ptbs.zipcdaddr as IO_Zipcdaddr,               ptbs.mpphontel as IO_Tel,           (select cdnm from com.zbcmcode where cdgrupid='P0008' and cdid =a.insukind) as IO_Insukind,               '' as IO_Ward,               '' as IO_roomNO,               a.orddd as IO_ADdate,               a.orddd as IO_Dschdd,               a.ordtype as IO_VisitType,               a.orddeptcd as IO_DeptCd,               (select dept.deptengabbr                  from com.zsdddept dept                 where dept.deptcd = a.orddeptcd                       and dept.instcd = a.instcd                       and dept.valitodd >= a.orddd                       and dept.valifromdd <= a.orddd) as IO_DeptNm,               COM.FN_ZS_GETDEPTNAME(a.instcd, a.orddeptcd, a.orddd) AS IO_Dept2,               '' AS IO_OPdeptCd,               '' AS IO_OPdeptNm,               '' AS IO_OPdrNm,               '' AS IO_OPdrId,               (SELECT diag.diagcd                  FROM emr.mmohdiag diag                 WHERE diag.pid = a.pid                       AND diag.orddd = a.orddd                       AND diag.cretno = a.cretno                       AND diag.diaghistcd = 'O'                       AND diag.diagtypecd = 'D'                       AND diag.diagkindcdflag = 'M'                       AND diag.genrflagcd = a.ordtype                       and diag.orddeptcd = a.orddeptcd                       AND diag.diaghistno = (select max(diagh.diaghistno)                                          from emr.mmohdiag diagh                                         where diagh.pid = a.pid                                               AND diagh.orddd = a.orddd                                               AND diagh.cretno = a.cretno                                               AND diagh.instcd = '111'                                               AND diagh.diaghistcd = 'O'                                                              AND diagh.diagkindcdflag = 'M'                                                              AND diagh.genrflagcd = a.ordtype                                               and diagh.orddeptcd = a.orddeptcd                                         group by pid)) as IO_DxCd,               (SELECT term.diaghngnm                  FROM emr.mmohdiag diag,                       emr.mmbvdiag term                 WHERE diag.pid = a.pid                       AND diag.orddd = a.orddd                       AND diag.cretno = a.cretno                       AND diag.instcd = term.instcd                       AND diag.diagcd = term.orgdiagcd                       AND diag.diaghistcd = 'O'                       AND diag.diagtypecd = 'D'                       AND diag.diagkindcdflag = 'M'                       AND diag.diagdd >= term.termfromdd                       AND diag.diagdd <= term.termtodd                       AND diag.diagdd >= term.diagattrfromdd                       AND diag.diagdd <= term.diagattrtodd                       AND diag.genrflagcd = a.ordtype                       and diag.orddeptcd = a.orddeptcd                       AND diag.diaghistno = (select max(diagh.diaghistno)                                          from emr.mmohdiag diagh                                         where diagh.pid = a.pid                                               AND diagh.orddd = a.orddd                                               AND diagh.cretno = a.cretno                                               AND diagh.instcd = '111'                                               AND diagh.diaghistcd = 'O'                                                              AND diagh.diagkindcdflag = 'M'                                                              AND diagh.genrflagcd = a.ordtype                                               and diagh.orddeptcd = a.orddeptcd                                         group by pid)) as IO_DxNm,               COM.FN_ZS_GETUSERNM(a.orddrid, a.orddd) as IO_MaindrNm,               '111' as IO_HosType,               case when ex.bp is null then null else ex.bp end as IO_bp,               case when ex.dm is null then null else ex.dm end as IO_dm,               case when ex.heart is null then null else ex.heart end as IO_heart,               case when ex.kidney is null then null else ex.kidney end as IO_kidney,               case when ex.respiration is null then null else ex.respiration end as IO_respiration,               case when ex.hx is null then null else ex.hx end as  IO_hx,               case when ex.allergy is null then null else ex.allergy end as  IO_allergy,               case when ex.drug is null then null else ex.drug end as  IO_drug,               case when ex.smoking is null then null else ex.smoking end as  IO_smoking,               case when ex.idio is null then null else ex.idio end as  IO_idio,               case when ex.nacrotics is null then null else ex.nacrotics end as  IO_nacrotics,               case when ex.airway is null then null else ex.airway end as  IO_airway,               case when ex.hemorrhage is null then null else ex.hemorrhage end as  IO_hemorrhage,               ex.etc IO_status_etc,               '111' as IO_OrderNo,               '111' as IO_PrintTime,               a.ORDDRID as IO_MaindrId,               '' as IO_ErdrNm,               COM.FN_ZS_GETUSERNM(a.ORDDRID, a.orddd) as IO_MaindrNm,               '111' as IO_OcrCd,               a.ORDDRID as IO_InputId,               COM.FN_ZS_GETUSERNM(a.ORDDRID, a.orddd) as IO_InputNm,               '111' as IO_SignImg          FROM pam.pmohotpt a            left outer join cmr.consent_data_ex ex              on (ex.pid = a.pid and ex.cln_date = a.orddd)            left outer join pam.pmcmptbs ptbs              on (ptbs.pid = a.pid and ptbs.instcd = a.instcd)          WHERE a.instcd =  :param0               AND a.pid =  :param1               AND a.orddd =  :param2               AND A.HISTSTAT IN ('R', 'T')              AND A.MSKIND = 'M'                          AND a.cretno =  :param3                     AND a.orddeptcd =  :param4]

[Logging Date Time: 2016-11-25 17:52:24,184] =====================================================================================
SQL Command - Statement Id: [getPatientInfoOut] Parameters: [param0=[instcd,111], param1=[pid,0990709], param2=[orddd,20161125], param3=[cretno,1], param4=[orddeptcd,2010400000]]

[Logging Date Time: 2016-11-25 17:52:24,184] =====================================================================================
SQL Command - Statement Id: [getPatientInfoOut] Parameters: [param0=[instcd,111], param1=[pid,0990709], param2=[orddd,20161125], param3=[cretno,1], param4=[orddeptcd,2010400000]]

[Logging Date Time: 2016-11-25 17:52:24,184] =====================================================================================
SQL Command - Statement Id: [getPatientInfoOut] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:52:24,184] =====================================================================================
SQL Command - Statement Id: [getPatientInfoOut] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:52:24,298] =====================================================================================
SQL Command - Statement Id: [getOcrTag] PreparedStatement : [SELECT to_char(sysdate,'YYYYMMDD') || SUBSTR(LPAD((EMR.SQ_MRFMOCRP_01.NEXTVAL), 10, '0'), 6, 5) AS ocrtag        FROM dual]

[Logging Date Time: 2016-11-25 17:52:24,298] =====================================================================================
SQL Command - Statement Id: [getOcrTag] PreparedStatement : [SELECT to_char(sysdate,'YYYYMMDD') || SUBSTR(LPAD((EMR.SQ_MRFMOCRP_01.NEXTVAL), 10, '0'), 6, 5) AS ocrtag        FROM dual]

[Logging Date Time: 2016-11-25 17:52:28,899] =====================================================================================
SQL Command - Statement Id: [getPatientInfoOut] PreparedStatement : [SELECT a.orddeptcd,               a.pid as IO_Pt_ID,               to_char(a.cretno) as IO_CretNo,               ( ptbs.sex || '/' ||                       com.fn_zz_getageas(ptbs.rrgstno1,                                          ptbs.rrgstno2,                                          TO_CHAR(SYSDATE, 'YYYYMMDD'),                                          'A',                                          ptbs.brthdd)) as IO_sex_age_y_m,               ptbs.hngnm as IO_Pt_Name,               (ptbs.rrgstno1 || '-' || substr(ptbs.rrgstno2, 1, 1) ||'******') IO_JuminNo,           ptbs.zipcdaddr as IO_Zipcdaddr,               ptbs.mpphontel as IO_Tel,           (select cdnm from com.zbcmcode where cdgrupid='P0008' and cdid =a.insukind) as IO_Insukind,               '' as IO_Ward,               '' as IO_roomNO,               a.orddd as IO_ADdate,               a.orddd as IO_Dschdd,               a.ordtype as IO_VisitType,               a.orddeptcd as IO_DeptCd,               (select dept.deptengabbr                  from com.zsdddept dept                 where dept.deptcd = a.orddeptcd                       and dept.instcd = a.instcd                       and dept.valitodd >= a.orddd                       and dept.valifromdd <= a.orddd) as IO_DeptNm,               COM.FN_ZS_GETDEPTNAME(a.instcd, a.orddeptcd, a.orddd) AS IO_Dept2,               '' AS IO_OPdeptCd,               '' AS IO_OPdeptNm,               '' AS IO_OPdrNm,               '' AS IO_OPdrId,               (SELECT diag.diagcd                  FROM emr.mmohdiag diag                 WHERE diag.pid = a.pid                       AND diag.orddd = a.orddd                       AND diag.cretno = a.cretno                       AND diag.diaghistcd = 'O'                       AND diag.diagtypecd = 'D'                       AND diag.diagkindcdflag = 'M'                       AND diag.genrflagcd = a.ordtype                       and diag.orddeptcd = a.orddeptcd                       AND diag.diaghistno = (select max(diagh.diaghistno)                                          from emr.mmohdiag diagh                                         where diagh.pid = a.pid                                               AND diagh.orddd = a.orddd                                               AND diagh.cretno = a.cretno                                               AND diagh.instcd = '111'                                               AND diagh.diaghistcd = 'O'                                                              AND diagh.diagkindcdflag = 'M'                                                              AND diagh.genrflagcd = a.ordtype                                               and diagh.orddeptcd = a.orddeptcd                                         group by pid)) as IO_DxCd,               (SELECT term.diaghngnm                  FROM emr.mmohdiag diag,                       emr.mmbvdiag term                 WHERE diag.pid = a.pid                       AND diag.orddd = a.orddd                       AND diag.cretno = a.cretno                       AND diag.instcd = term.instcd                       AND diag.diagcd = term.orgdiagcd                       AND diag.diaghistcd = 'O'                       AND diag.diagtypecd = 'D'                       AND diag.diagkindcdflag = 'M'                       AND diag.diagdd >= term.termfromdd                       AND diag.diagdd <= term.termtodd                       AND diag.diagdd >= term.diagattrfromdd                       AND diag.diagdd <= term.diagattrtodd                       AND diag.genrflagcd = a.ordtype                       and diag.orddeptcd = a.orddeptcd                       AND diag.diaghistno = (select max(diagh.diaghistno)                                          from emr.mmohdiag diagh                                         where diagh.pid = a.pid                                               AND diagh.orddd = a.orddd                                               AND diagh.cretno = a.cretno                                               AND diagh.instcd = '111'                                               AND diagh.diaghistcd = 'O'                                                              AND diagh.diagkindcdflag = 'M'                                                              AND diagh.genrflagcd = a.ordtype                                               and diagh.orddeptcd = a.orddeptcd                                         group by pid)) as IO_DxNm,               COM.FN_ZS_GETUSERNM(a.orddrid, a.orddd) as IO_MaindrNm,               '111' as IO_HosType,               case when ex.bp is null then null else ex.bp end as IO_bp,               case when ex.dm is null then null else ex.dm end as IO_dm,               case when ex.heart is null then null else ex.heart end as IO_heart,               case when ex.kidney is null then null else ex.kidney end as IO_kidney,               case when ex.respiration is null then null else ex.respiration end as IO_respiration,               case when ex.hx is null then null else ex.hx end as  IO_hx,               case when ex.allergy is null then null else ex.allergy end as  IO_allergy,               case when ex.drug is null then null else ex.drug end as  IO_drug,               case when ex.smoking is null then null else ex.smoking end as  IO_smoking,               case when ex.idio is null then null else ex.idio end as  IO_idio,               case when ex.nacrotics is null then null else ex.nacrotics end as  IO_nacrotics,               case when ex.airway is null then null else ex.airway end as  IO_airway,               case when ex.hemorrhage is null then null else ex.hemorrhage end as  IO_hemorrhage,               ex.etc IO_status_etc,               '111' as IO_OrderNo,               '111' as IO_PrintTime,               a.ORDDRID as IO_MaindrId,               '' as IO_ErdrNm,               COM.FN_ZS_GETUSERNM(a.ORDDRID, a.orddd) as IO_MaindrNm,               '111' as IO_OcrCd,               a.ORDDRID as IO_InputId,               COM.FN_ZS_GETUSERNM(a.ORDDRID, a.orddd) as IO_InputNm,               '111' as IO_SignImg          FROM pam.pmohotpt a            left outer join cmr.consent_data_ex ex              on (ex.pid = a.pid and ex.cln_date = a.orddd)            left outer join pam.pmcmptbs ptbs              on (ptbs.pid = a.pid and ptbs.instcd = a.instcd)          WHERE a.instcd =  :param0               AND a.pid =  :param1               AND a.orddd =  :param2               AND A.HISTSTAT IN ('R', 'T')              AND A.MSKIND = 'M'                          AND a.cretno =  :param3                     AND a.orddeptcd =  :param4]

[Logging Date Time: 2016-11-25 17:52:28,899] =====================================================================================
SQL Command - Statement Id: [getPatientInfoOut] PreparedStatement : [SELECT a.orddeptcd,               a.pid as IO_Pt_ID,               to_char(a.cretno) as IO_CretNo,               ( ptbs.sex || '/' ||                       com.fn_zz_getageas(ptbs.rrgstno1,                                          ptbs.rrgstno2,                                          TO_CHAR(SYSDATE, 'YYYYMMDD'),                                          'A',                                          ptbs.brthdd)) as IO_sex_age_y_m,               ptbs.hngnm as IO_Pt_Name,               (ptbs.rrgstno1 || '-' || substr(ptbs.rrgstno2, 1, 1) ||'******') IO_JuminNo,           ptbs.zipcdaddr as IO_Zipcdaddr,               ptbs.mpphontel as IO_Tel,           (select cdnm from com.zbcmcode where cdgrupid='P0008' and cdid =a.insukind) as IO_Insukind,               '' as IO_Ward,               '' as IO_roomNO,               a.orddd as IO_ADdate,               a.orddd as IO_Dschdd,               a.ordtype as IO_VisitType,               a.orddeptcd as IO_DeptCd,               (select dept.deptengabbr                  from com.zsdddept dept                 where dept.deptcd = a.orddeptcd                       and dept.instcd = a.instcd                       and dept.valitodd >= a.orddd                       and dept.valifromdd <= a.orddd) as IO_DeptNm,               COM.FN_ZS_GETDEPTNAME(a.instcd, a.orddeptcd, a.orddd) AS IO_Dept2,               '' AS IO_OPdeptCd,               '' AS IO_OPdeptNm,               '' AS IO_OPdrNm,               '' AS IO_OPdrId,               (SELECT diag.diagcd                  FROM emr.mmohdiag diag                 WHERE diag.pid = a.pid                       AND diag.orddd = a.orddd                       AND diag.cretno = a.cretno                       AND diag.diaghistcd = 'O'                       AND diag.diagtypecd = 'D'                       AND diag.diagkindcdflag = 'M'                       AND diag.genrflagcd = a.ordtype                       and diag.orddeptcd = a.orddeptcd                       AND diag.diaghistno = (select max(diagh.diaghistno)                                          from emr.mmohdiag diagh                                         where diagh.pid = a.pid                                               AND diagh.orddd = a.orddd                                               AND diagh.cretno = a.cretno                                               AND diagh.instcd = '111'                                               AND diagh.diaghistcd = 'O'                                                              AND diagh.diagkindcdflag = 'M'                                                              AND diagh.genrflagcd = a.ordtype                                               and diagh.orddeptcd = a.orddeptcd                                         group by pid)) as IO_DxCd,               (SELECT term.diaghngnm                  FROM emr.mmohdiag diag,                       emr.mmbvdiag term                 WHERE diag.pid = a.pid                       AND diag.orddd = a.orddd                       AND diag.cretno = a.cretno                       AND diag.instcd = term.instcd                       AND diag.diagcd = term.orgdiagcd                       AND diag.diaghistcd = 'O'                       AND diag.diagtypecd = 'D'                       AND diag.diagkindcdflag = 'M'                       AND diag.diagdd >= term.termfromdd                       AND diag.diagdd <= term.termtodd                       AND diag.diagdd >= term.diagattrfromdd                       AND diag.diagdd <= term.diagattrtodd                       AND diag.genrflagcd = a.ordtype                       and diag.orddeptcd = a.orddeptcd                       AND diag.diaghistno = (select max(diagh.diaghistno)                                          from emr.mmohdiag diagh                                         where diagh.pid = a.pid                                               AND diagh.orddd = a.orddd                                               AND diagh.cretno = a.cretno                                               AND diagh.instcd = '111'                                               AND diagh.diaghistcd = 'O'                                                              AND diagh.diagkindcdflag = 'M'                                                              AND diagh.genrflagcd = a.ordtype                                               and diagh.orddeptcd = a.orddeptcd                                         group by pid)) as IO_DxNm,               COM.FN_ZS_GETUSERNM(a.orddrid, a.orddd) as IO_MaindrNm,               '111' as IO_HosType,               case when ex.bp is null then null else ex.bp end as IO_bp,               case when ex.dm is null then null else ex.dm end as IO_dm,               case when ex.heart is null then null else ex.heart end as IO_heart,               case when ex.kidney is null then null else ex.kidney end as IO_kidney,               case when ex.respiration is null then null else ex.respiration end as IO_respiration,               case when ex.hx is null then null else ex.hx end as  IO_hx,               case when ex.allergy is null then null else ex.allergy end as  IO_allergy,               case when ex.drug is null then null else ex.drug end as  IO_drug,               case when ex.smoking is null then null else ex.smoking end as  IO_smoking,               case when ex.idio is null then null else ex.idio end as  IO_idio,               case when ex.nacrotics is null then null else ex.nacrotics end as  IO_nacrotics,               case when ex.airway is null then null else ex.airway end as  IO_airway,               case when ex.hemorrhage is null then null else ex.hemorrhage end as  IO_hemorrhage,               ex.etc IO_status_etc,               '111' as IO_OrderNo,               '111' as IO_PrintTime,               a.ORDDRID as IO_MaindrId,               '' as IO_ErdrNm,               COM.FN_ZS_GETUSERNM(a.ORDDRID, a.orddd) as IO_MaindrNm,               '111' as IO_OcrCd,               a.ORDDRID as IO_InputId,               COM.FN_ZS_GETUSERNM(a.ORDDRID, a.orddd) as IO_InputNm,               '111' as IO_SignImg          FROM pam.pmohotpt a            left outer join cmr.consent_data_ex ex              on (ex.pid = a.pid and ex.cln_date = a.orddd)            left outer join pam.pmcmptbs ptbs              on (ptbs.pid = a.pid and ptbs.instcd = a.instcd)          WHERE a.instcd =  :param0               AND a.pid =  :param1               AND a.orddd =  :param2               AND A.HISTSTAT IN ('R', 'T')              AND A.MSKIND = 'M'                          AND a.cretno =  :param3                     AND a.orddeptcd =  :param4]

[Logging Date Time: 2016-11-25 17:52:28,900] =====================================================================================
SQL Command - Statement Id: [getPatientInfoOut] Parameters: [param0=[instcd,111], param1=[pid,0656166], param2=[orddd,20161125], param3=[cretno,1], param4=[orddeptcd,2010400000]]

[Logging Date Time: 2016-11-25 17:52:28,900] =====================================================================================
SQL Command - Statement Id: [getPatientInfoOut] Parameters: [param0=[instcd,111], param1=[pid,0656166], param2=[orddd,20161125], param3=[cretno,1], param4=[orddeptcd,2010400000]]

[Logging Date Time: 2016-11-25 17:52:28,901] =====================================================================================
SQL Command - Statement Id: [getPatientInfoOut] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:52:28,901] =====================================================================================
SQL Command - Statement Id: [getPatientInfoOut] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:52:29,058] =====================================================================================
SQL Command - Statement Id: [getOcrTag] PreparedStatement : [SELECT to_char(sysdate,'YYYYMMDD') || SUBSTR(LPAD((EMR.SQ_MRFMOCRP_01.NEXTVAL), 10, '0'), 6, 5) AS ocrtag        FROM dual]

[Logging Date Time: 2016-11-25 17:52:29,058] =====================================================================================
SQL Command - Statement Id: [getOcrTag] PreparedStatement : [SELECT to_char(sysdate,'YYYYMMDD') || SUBSTR(LPAD((EMR.SQ_MRFMOCRP_01.NEXTVAL), 10, '0'), 6, 5) AS ocrtag        FROM dual]

[Logging Date Time: 2016-11-25 17:54:31,123] =====================================================================================
SQL Command - Statement Id: [getPatientInfoOut] PreparedStatement : [SELECT a.orddeptcd,               a.pid as IO_Pt_ID,               to_char(a.cretno) as IO_CretNo,               ( ptbs.sex || '/' ||                       com.fn_zz_getageas(ptbs.rrgstno1,                                          ptbs.rrgstno2,                                          TO_CHAR(SYSDATE, 'YYYYMMDD'),                                          'A',                                          ptbs.brthdd)) as IO_sex_age_y_m,               ptbs.hngnm as IO_Pt_Name,               (ptbs.rrgstno1 || '-' || substr(ptbs.rrgstno2, 1, 1) ||'******') IO_JuminNo,           ptbs.zipcdaddr as IO_Zipcdaddr,               ptbs.mpphontel as IO_Tel,           (select cdnm from com.zbcmcode where cdgrupid='P0008' and cdid =a.insukind) as IO_Insukind,               '' as IO_Ward,               '' as IO_roomNO,               a.orddd as IO_ADdate,               a.orddd as IO_Dschdd,               a.ordtype as IO_VisitType,               a.orddeptcd as IO_DeptCd,               (select dept.deptengabbr                  from com.zsdddept dept                 where dept.deptcd = a.orddeptcd                       and dept.instcd = a.instcd                       and dept.valitodd >= a.orddd                       and dept.valifromdd <= a.orddd) as IO_DeptNm,               COM.FN_ZS_GETDEPTNAME(a.instcd, a.orddeptcd, a.orddd) AS IO_Dept2,               '' AS IO_OPdeptCd,               '' AS IO_OPdeptNm,               '' AS IO_OPdrNm,               '' AS IO_OPdrId,               (SELECT diag.diagcd                  FROM emr.mmohdiag diag                 WHERE diag.pid = a.pid                       AND diag.orddd = a.orddd                       AND diag.cretno = a.cretno                       AND diag.diaghistcd = 'O'                       AND diag.diagtypecd = 'D'                       AND diag.diagkindcdflag = 'M'                       AND diag.genrflagcd = a.ordtype                       and diag.orddeptcd = a.orddeptcd                       AND diag.diaghistno = (select max(diagh.diaghistno)                                          from emr.mmohdiag diagh                                         where diagh.pid = a.pid                                               AND diagh.orddd = a.orddd                                               AND diagh.cretno = a.cretno                                               AND diagh.instcd = '111'                                               AND diagh.diaghistcd = 'O'                                                              AND diagh.diagkindcdflag = 'M'                                                              AND diagh.genrflagcd = a.ordtype                                               and diagh.orddeptcd = a.orddeptcd                                         group by pid)) as IO_DxCd,               (SELECT term.diaghngnm                  FROM emr.mmohdiag diag,                       emr.mmbvdiag term                 WHERE diag.pid = a.pid                       AND diag.orddd = a.orddd                       AND diag.cretno = a.cretno                       AND diag.instcd = term.instcd                       AND diag.diagcd = term.orgdiagcd                       AND diag.diaghistcd = 'O'                       AND diag.diagtypecd = 'D'                       AND diag.diagkindcdflag = 'M'                       AND diag.diagdd >= term.termfromdd                       AND diag.diagdd <= term.termtodd                       AND diag.diagdd >= term.diagattrfromdd                       AND diag.diagdd <= term.diagattrtodd                       AND diag.genrflagcd = a.ordtype                       and diag.orddeptcd = a.orddeptcd                       AND diag.diaghistno = (select max(diagh.diaghistno)                                          from emr.mmohdiag diagh                                         where diagh.pid = a.pid                                               AND diagh.orddd = a.orddd                                               AND diagh.cretno = a.cretno                                               AND diagh.instcd = '111'                                               AND diagh.diaghistcd = 'O'                                                              AND diagh.diagkindcdflag = 'M'                                                              AND diagh.genrflagcd = a.ordtype                                               and diagh.orddeptcd = a.orddeptcd                                         group by pid)) as IO_DxNm,               COM.FN_ZS_GETUSERNM(a.orddrid, a.orddd) as IO_MaindrNm,               '111' as IO_HosType,               case when ex.bp is null then null else ex.bp end as IO_bp,               case when ex.dm is null then null else ex.dm end as IO_dm,               case when ex.heart is null then null else ex.heart end as IO_heart,               case when ex.kidney is null then null else ex.kidney end as IO_kidney,               case when ex.respiration is null then null else ex.respiration end as IO_respiration,               case when ex.hx is null then null else ex.hx end as  IO_hx,               case when ex.allergy is null then null else ex.allergy end as  IO_allergy,               case when ex.drug is null then null else ex.drug end as  IO_drug,               case when ex.smoking is null then null else ex.smoking end as  IO_smoking,               case when ex.idio is null then null else ex.idio end as  IO_idio,               case when ex.nacrotics is null then null else ex.nacrotics end as  IO_nacrotics,               case when ex.airway is null then null else ex.airway end as  IO_airway,               case when ex.hemorrhage is null then null else ex.hemorrhage end as  IO_hemorrhage,               ex.etc IO_status_etc,               '111' as IO_OrderNo,               '111' as IO_PrintTime,               a.ORDDRID as IO_MaindrId,               '' as IO_ErdrNm,               COM.FN_ZS_GETUSERNM(a.ORDDRID, a.orddd) as IO_MaindrNm,               '111' as IO_OcrCd,               a.ORDDRID as IO_InputId,               COM.FN_ZS_GETUSERNM(a.ORDDRID, a.orddd) as IO_InputNm,               '111' as IO_SignImg          FROM pam.pmohotpt a            left outer join cmr.consent_data_ex ex              on (ex.pid = a.pid and ex.cln_date = a.orddd)            left outer join pam.pmcmptbs ptbs              on (ptbs.pid = a.pid and ptbs.instcd = a.instcd)          WHERE a.instcd =  :param0               AND a.pid =  :param1               AND a.orddd =  :param2               AND A.HISTSTAT IN ('R', 'T')              AND A.MSKIND = 'M'                          AND a.cretno =  :param3                     AND a.orddeptcd =  :param4]

[Logging Date Time: 2016-11-25 17:54:31,123] =====================================================================================
SQL Command - Statement Id: [getPatientInfoOut] PreparedStatement : [SELECT a.orddeptcd,               a.pid as IO_Pt_ID,               to_char(a.cretno) as IO_CretNo,               ( ptbs.sex || '/' ||                       com.fn_zz_getageas(ptbs.rrgstno1,                                          ptbs.rrgstno2,                                          TO_CHAR(SYSDATE, 'YYYYMMDD'),                                          'A',                                          ptbs.brthdd)) as IO_sex_age_y_m,               ptbs.hngnm as IO_Pt_Name,               (ptbs.rrgstno1 || '-' || substr(ptbs.rrgstno2, 1, 1) ||'******') IO_JuminNo,           ptbs.zipcdaddr as IO_Zipcdaddr,               ptbs.mpphontel as IO_Tel,           (select cdnm from com.zbcmcode where cdgrupid='P0008' and cdid =a.insukind) as IO_Insukind,               '' as IO_Ward,               '' as IO_roomNO,               a.orddd as IO_ADdate,               a.orddd as IO_Dschdd,               a.ordtype as IO_VisitType,               a.orddeptcd as IO_DeptCd,               (select dept.deptengabbr                  from com.zsdddept dept                 where dept.deptcd = a.orddeptcd                       and dept.instcd = a.instcd                       and dept.valitodd >= a.orddd                       and dept.valifromdd <= a.orddd) as IO_DeptNm,               COM.FN_ZS_GETDEPTNAME(a.instcd, a.orddeptcd, a.orddd) AS IO_Dept2,               '' AS IO_OPdeptCd,               '' AS IO_OPdeptNm,               '' AS IO_OPdrNm,               '' AS IO_OPdrId,               (SELECT diag.diagcd                  FROM emr.mmohdiag diag                 WHERE diag.pid = a.pid                       AND diag.orddd = a.orddd                       AND diag.cretno = a.cretno                       AND diag.diaghistcd = 'O'                       AND diag.diagtypecd = 'D'                       AND diag.diagkindcdflag = 'M'                       AND diag.genrflagcd = a.ordtype                       and diag.orddeptcd = a.orddeptcd                       AND diag.diaghistno = (select max(diagh.diaghistno)                                          from emr.mmohdiag diagh                                         where diagh.pid = a.pid                                               AND diagh.orddd = a.orddd                                               AND diagh.cretno = a.cretno                                               AND diagh.instcd = '111'                                               AND diagh.diaghistcd = 'O'                                                              AND diagh.diagkindcdflag = 'M'                                                              AND diagh.genrflagcd = a.ordtype                                               and diagh.orddeptcd = a.orddeptcd                                         group by pid)) as IO_DxCd,               (SELECT term.diaghngnm                  FROM emr.mmohdiag diag,                       emr.mmbvdiag term                 WHERE diag.pid = a.pid                       AND diag.orddd = a.orddd                       AND diag.cretno = a.cretno                       AND diag.instcd = term.instcd                       AND diag.diagcd = term.orgdiagcd                       AND diag.diaghistcd = 'O'                       AND diag.diagtypecd = 'D'                       AND diag.diagkindcdflag = 'M'                       AND diag.diagdd >= term.termfromdd                       AND diag.diagdd <= term.termtodd                       AND diag.diagdd >= term.diagattrfromdd                       AND diag.diagdd <= term.diagattrtodd                       AND diag.genrflagcd = a.ordtype                       and diag.orddeptcd = a.orddeptcd                       AND diag.diaghistno = (select max(diagh.diaghistno)                                          from emr.mmohdiag diagh                                         where diagh.pid = a.pid                                               AND diagh.orddd = a.orddd                                               AND diagh.cretno = a.cretno                                               AND diagh.instcd = '111'                                               AND diagh.diaghistcd = 'O'                                                              AND diagh.diagkindcdflag = 'M'                                                              AND diagh.genrflagcd = a.ordtype                                               and diagh.orddeptcd = a.orddeptcd                                         group by pid)) as IO_DxNm,               COM.FN_ZS_GETUSERNM(a.orddrid, a.orddd) as IO_MaindrNm,               '111' as IO_HosType,               case when ex.bp is null then null else ex.bp end as IO_bp,               case when ex.dm is null then null else ex.dm end as IO_dm,               case when ex.heart is null then null else ex.heart end as IO_heart,               case when ex.kidney is null then null else ex.kidney end as IO_kidney,               case when ex.respiration is null then null else ex.respiration end as IO_respiration,               case when ex.hx is null then null else ex.hx end as  IO_hx,               case when ex.allergy is null then null else ex.allergy end as  IO_allergy,               case when ex.drug is null then null else ex.drug end as  IO_drug,               case when ex.smoking is null then null else ex.smoking end as  IO_smoking,               case when ex.idio is null then null else ex.idio end as  IO_idio,               case when ex.nacrotics is null then null else ex.nacrotics end as  IO_nacrotics,               case when ex.airway is null then null else ex.airway end as  IO_airway,               case when ex.hemorrhage is null then null else ex.hemorrhage end as  IO_hemorrhage,               ex.etc IO_status_etc,               '111' as IO_OrderNo,               '111' as IO_PrintTime,               a.ORDDRID as IO_MaindrId,               '' as IO_ErdrNm,               COM.FN_ZS_GETUSERNM(a.ORDDRID, a.orddd) as IO_MaindrNm,               '111' as IO_OcrCd,               a.ORDDRID as IO_InputId,               COM.FN_ZS_GETUSERNM(a.ORDDRID, a.orddd) as IO_InputNm,               '111' as IO_SignImg          FROM pam.pmohotpt a            left outer join cmr.consent_data_ex ex              on (ex.pid = a.pid and ex.cln_date = a.orddd)            left outer join pam.pmcmptbs ptbs              on (ptbs.pid = a.pid and ptbs.instcd = a.instcd)          WHERE a.instcd =  :param0               AND a.pid =  :param1               AND a.orddd =  :param2               AND A.HISTSTAT IN ('R', 'T')              AND A.MSKIND = 'M'                          AND a.cretno =  :param3                     AND a.orddeptcd =  :param4]

[Logging Date Time: 2016-11-25 17:54:31,225] =====================================================================================
SQL Command - Statement Id: [getPatientInfoOut] Parameters: [param0=[instcd,111], param1=[pid,0990709], param2=[orddd,20161125], param3=[cretno,1], param4=[orddeptcd,2010400000]]

[Logging Date Time: 2016-11-25 17:54:31,225] =====================================================================================
SQL Command - Statement Id: [getPatientInfoOut] Parameters: [param0=[instcd,111], param1=[pid,0990709], param2=[orddd,20161125], param3=[cretno,1], param4=[orddeptcd,2010400000]]

[Logging Date Time: 2016-11-25 17:54:31,225] =====================================================================================
SQL Command - Statement Id: [getPatientInfoOut] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:54:31,225] =====================================================================================
SQL Command - Statement Id: [getPatientInfoOut] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:54:32,029] =====================================================================================
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-25 17:54:32,029] =====================================================================================
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-25 17:54:32,032] =====================================================================================
SQL Command - Statement Id: [GET_SEQUENCE] Parameters: [param0=[sub_cd,CONSENT_MST]]

[Logging Date Time: 2016-11-25 17:54:32,032] =====================================================================================
SQL Command - Statement Id: [GET_SEQUENCE] Parameters: [param0=[sub_cd,CONSENT_MST]]

[Logging Date Time: 2016-11-25 17:54:32,032] =====================================================================================
SQL Command - Statement Id: [GET_SEQUENCE] Types: [param0=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:54:32,032] =====================================================================================
SQL Command - Statement Id: [GET_SEQUENCE] Types: [param0=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:54:32,063] =====================================================================================
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-25 17:54:32,063] =====================================================================================
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-25 17:54:32,064] =====================================================================================
SQL Command - Statement Id: [UPDATE_SEQUENCE] Parameters: [param0=[ud1_num,2370], param1=[sub_cd,CONSENT_MST]]

[Logging Date Time: 2016-11-25 17:54:32,064] =====================================================================================
SQL Command - Statement Id: [UPDATE_SEQUENCE] Parameters: [param0=[ud1_num,2370], param1=[sub_cd,CONSENT_MST]]

[Logging Date Time: 2016-11-25 17:54:32,064] =====================================================================================
SQL Command - Statement Id: [UPDATE_SEQUENCE] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:54:32,064] =====================================================================================
SQL Command - Statement Id: [UPDATE_SEQUENCE] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:54:32,069] =====================================================================================
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-25 17:54:32,069] =====================================================================================
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-25 17:54:32,069] =====================================================================================
SQL Command - Statement Id: [GET_SEQUENCE] Parameters: [param0=[sub_cd,CONSENT_DATA]]

[Logging Date Time: 2016-11-25 17:54:32,069] =====================================================================================
SQL Command - Statement Id: [GET_SEQUENCE] Parameters: [param0=[sub_cd,CONSENT_DATA]]

[Logging Date Time: 2016-11-25 17:54:32,069] =====================================================================================
SQL Command - Statement Id: [GET_SEQUENCE] Types: [param0=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:54:32,069] =====================================================================================
SQL Command - Statement Id: [GET_SEQUENCE] Types: [param0=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:54:32,074] =====================================================================================
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-25 17:54:32,074] =====================================================================================
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-25 17:54:32,074] =====================================================================================
SQL Command - Statement Id: [UPDATE_SEQUENCE] Parameters: [param0=[ud1_num,2259], param1=[sub_cd,CONSENT_DATA]]

[Logging Date Time: 2016-11-25 17:54:32,074] =====================================================================================
SQL Command - Statement Id: [UPDATE_SEQUENCE] Parameters: [param0=[ud1_num,2259], param1=[sub_cd,CONSENT_DATA]]

[Logging Date Time: 2016-11-25 17:54:32,074] =====================================================================================
SQL Command - Statement Id: [UPDATE_SEQUENCE] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:54:32,074] =====================================================================================
SQL Command - Statement Id: [UPDATE_SEQUENCE] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:54:32,087] =====================================================================================
SQL Command - Statement Id: [INSERT_CONSENT_MST] PreparedStatement : [insert into CONSENT_MST          (            CONSENT_MST_RID,            HOS_TYPE,             PID,            VISIT_TYPE,            OCR_NUMBER,            CLN_DEPT_CD,            CLN_DATE,            CRETNO,            WARDCD,            ROOMCD,            FORM_RID,            CONSENT_STATE,            COMPLETE_YN,            COMPLETE_DATETIME,            PAPER_YN,            REISSUE_YN,            REISSUE_CONSENT_MST_RID,            REWRITE_YN,            REWRITE_CONSENT_MST_RID,            USE_YN,            MAIN_DR_ID,            CREATE_USER_ID,            CREATE_DATETIME,            MODIFY_USER_ID,            MODIFY_DATETIME,            CREATE_USER_NAME,            MODIFY_USER_NAME          )          values          (             :param0 ,             :param1 ,             :param2 ,             :param3 ,             :param4 ,             :param5 ,             :param6 ,             :param7 ,             :param8 ,             :param9 ,             :param10 ,             :param11 ,             :param12 ,            '',             :param13 ,             :param14 ,             :param15 ,             :param16 ,             :param17 ,            'Y',             :param18 ,             :param19 ,            TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'),             :param19 ,            TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'),             :param20 ,             :param21           )]

[Logging Date Time: 2016-11-25 17:54:32,087] =====================================================================================
SQL Command - Statement Id: [INSERT_CONSENT_MST] PreparedStatement : [insert into CONSENT_MST          (            CONSENT_MST_RID,            HOS_TYPE,             PID,            VISIT_TYPE,            OCR_NUMBER,            CLN_DEPT_CD,            CLN_DATE,            CRETNO,            WARDCD,            ROOMCD,            FORM_RID,            CONSENT_STATE,            COMPLETE_YN,            COMPLETE_DATETIME,            PAPER_YN,            REISSUE_YN,            REISSUE_CONSENT_MST_RID,            REWRITE_YN,            REWRITE_CONSENT_MST_RID,            USE_YN,            MAIN_DR_ID,            CREATE_USER_ID,            CREATE_DATETIME,            MODIFY_USER_ID,            MODIFY_DATETIME,            CREATE_USER_NAME,            MODIFY_USER_NAME          )          values          (             :param0 ,             :param1 ,             :param2 ,             :param3 ,             :param4 ,             :param5 ,             :param6 ,             :param7 ,             :param8 ,             :param9 ,             :param10 ,             :param11 ,             :param12 ,            '',             :param13 ,             :param14 ,             :param15 ,             :param16 ,             :param17 ,            'Y',             :param18 ,             :param19 ,            TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'),             :param19 ,            TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'),             :param20 ,             :param21           )]

[Logging Date Time: 2016-11-25 17:54:32,087] =====================================================================================
SQL Command - Statement Id: [INSERT_CONSENT_MST] Parameters: [param0=[consentMstRid,2370], param1=[hosType,111], param2=[patientCode,0990709], param3=[vistType,O], param4=[ocrCode,2016112564622], param5=[clnDeptCd,2010400000], param6=[clnDate,20161125], param7=[cretno,1], param8=[ward,null], param9=[roomcd,null], param10=[formRid,1062], param11=[consentState,PAPER_OUT], param12=[completeYn,N], param13=[paperYn,Y], param14=[reissueYn,N], param15=[reissueConsentMstRid,0], param16=[rewriteYn,N], param17=[rewriteConsentMstRid,0], param18=[mainDrId,107945], param19=[userId,107945], param20=[createUserName,±èÀçÈñ], param21=[modifyUserName,±èÀçÈñ]]

[Logging Date Time: 2016-11-25 17:54:32,087] =====================================================================================
SQL Command - Statement Id: [INSERT_CONSENT_MST] Parameters: [param0=[consentMstRid,2370], param1=[hosType,111], param2=[patientCode,0990709], param3=[vistType,O], param4=[ocrCode,2016112564622], param5=[clnDeptCd,2010400000], param6=[clnDate,20161125], param7=[cretno,1], param8=[ward,null], param9=[roomcd,null], param10=[formRid,1062], param11=[consentState,PAPER_OUT], param12=[completeYn,N], param13=[paperYn,Y], param14=[reissueYn,N], param15=[reissueConsentMstRid,0], param16=[rewriteYn,N], param17=[rewriteConsentMstRid,0], param18=[mainDrId,107945], param19=[userId,107945], param20=[createUserName,±èÀçÈñ], param21=[modifyUserName,±èÀçÈñ]]

[Logging Date Time: 2016-11-25 17:54:32,087] =====================================================================================
SQL Command - Statement Id: [INSERT_CONSENT_MST] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String], param5=[AnsiString, System.String], param6=[AnsiString, System.String], param7=[Int32, System.Int32], param8=[System.DBNull, null], param9=[System.DBNull, null], param10=[Int32, System.Int32], param11=[AnsiString, System.String], param12=[AnsiString, System.String], param13=[AnsiString, System.String], param14=[AnsiString, System.String], param15=[Int32, System.Int32], param16=[AnsiString, System.String], param17=[Int32, System.Int32], param18=[AnsiString, System.String], param19=[AnsiString, System.String], param20=[AnsiString, System.String], param21=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:54:32,087] =====================================================================================
SQL Command - Statement Id: [INSERT_CONSENT_MST] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String], param5=[AnsiString, System.String], param6=[AnsiString, System.String], param7=[Int32, System.Int32], param8=[System.DBNull, null], param9=[System.DBNull, null], param10=[Int32, System.Int32], param11=[AnsiString, System.String], param12=[AnsiString, System.String], param13=[AnsiString, System.String], param14=[AnsiString, System.String], param15=[Int32, System.Int32], param16=[AnsiString, System.String], param17=[Int32, System.Int32], param18=[AnsiString, System.String], param19=[AnsiString, System.String], param20=[AnsiString, System.String], param21=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:54:32,149] =====================================================================================
SQL Command - Statement Id: [getPatientInfoOut] PreparedStatement : [SELECT a.orddeptcd,               a.pid as IO_Pt_ID,               to_char(a.cretno) as IO_CretNo,               ( ptbs.sex || '/' ||                       com.fn_zz_getageas(ptbs.rrgstno1,                                          ptbs.rrgstno2,                                          TO_CHAR(SYSDATE, 'YYYYMMDD'),                                          'A',                                          ptbs.brthdd)) as IO_sex_age_y_m,               ptbs.hngnm as IO_Pt_Name,               (ptbs.rrgstno1 || '-' || substr(ptbs.rrgstno2, 1, 1) ||'******') IO_JuminNo,           ptbs.zipcdaddr as IO_Zipcdaddr,               ptbs.mpphontel as IO_Tel,           (select cdnm from com.zbcmcode where cdgrupid='P0008' and cdid =a.insukind) as IO_Insukind,               '' as IO_Ward,               '' as IO_roomNO,               a.orddd as IO_ADdate,               a.orddd as IO_Dschdd,               a.ordtype as IO_VisitType,               a.orddeptcd as IO_DeptCd,               (select dept.deptengabbr                  from com.zsdddept dept                 where dept.deptcd = a.orddeptcd                       and dept.instcd = a.instcd                       and dept.valitodd >= a.orddd                       and dept.valifromdd <= a.orddd) as IO_DeptNm,               COM.FN_ZS_GETDEPTNAME(a.instcd, a.orddeptcd, a.orddd) AS IO_Dept2,               '' AS IO_OPdeptCd,               '' AS IO_OPdeptNm,               '' AS IO_OPdrNm,               '' AS IO_OPdrId,               (SELECT diag.diagcd                  FROM emr.mmohdiag diag                 WHERE diag.pid = a.pid                       AND diag.orddd = a.orddd                       AND diag.cretno = a.cretno                       AND diag.diaghistcd = 'O'                       AND diag.diagtypecd = 'D'                       AND diag.diagkindcdflag = 'M'                       AND diag.genrflagcd = a.ordtype                       and diag.orddeptcd = a.orddeptcd                       AND diag.diaghistno = (select max(diagh.diaghistno)                                          from emr.mmohdiag diagh                                         where diagh.pid = a.pid                                               AND diagh.orddd = a.orddd                                               AND diagh.cretno = a.cretno                                               AND diagh.instcd = '111'                                               AND diagh.diaghistcd = 'O'                                                              AND diagh.diagkindcdflag = 'M'                                                              AND diagh.genrflagcd = a.ordtype                                               and diagh.orddeptcd = a.orddeptcd                                         group by pid)) as IO_DxCd,               (SELECT term.diaghngnm                  FROM emr.mmohdiag diag,                       emr.mmbvdiag term                 WHERE diag.pid = a.pid                       AND diag.orddd = a.orddd                       AND diag.cretno = a.cretno                       AND diag.instcd = term.instcd                       AND diag.diagcd = term.orgdiagcd                       AND diag.diaghistcd = 'O'                       AND diag.diagtypecd = 'D'                       AND diag.diagkindcdflag = 'M'                       AND diag.diagdd >= term.termfromdd                       AND diag.diagdd <= term.termtodd                       AND diag.diagdd >= term.diagattrfromdd                       AND diag.diagdd <= term.diagattrtodd                       AND diag.genrflagcd = a.ordtype                       and diag.orddeptcd = a.orddeptcd                       AND diag.diaghistno = (select max(diagh.diaghistno)                                          from emr.mmohdiag diagh                                         where diagh.pid = a.pid                                               AND diagh.orddd = a.orddd                                               AND diagh.cretno = a.cretno                                               AND diagh.instcd = '111'                                               AND diagh.diaghistcd = 'O'                                                              AND diagh.diagkindcdflag = 'M'                                                              AND diagh.genrflagcd = a.ordtype                                               and diagh.orddeptcd = a.orddeptcd                                         group by pid)) as IO_DxNm,               COM.FN_ZS_GETUSERNM(a.orddrid, a.orddd) as IO_MaindrNm,               '111' as IO_HosType,               case when ex.bp is null then null else ex.bp end as IO_bp,               case when ex.dm is null then null else ex.dm end as IO_dm,               case when ex.heart is null then null else ex.heart end as IO_heart,               case when ex.kidney is null then null else ex.kidney end as IO_kidney,               case when ex.respiration is null then null else ex.respiration end as IO_respiration,               case when ex.hx is null then null else ex.hx end as  IO_hx,               case when ex.allergy is null then null else ex.allergy end as  IO_allergy,               case when ex.drug is null then null else ex.drug end as  IO_drug,               case when ex.smoking is null then null else ex.smoking end as  IO_smoking,               case when ex.idio is null then null else ex.idio end as  IO_idio,               case when ex.nacrotics is null then null else ex.nacrotics end as  IO_nacrotics,               case when ex.airway is null then null else ex.airway end as  IO_airway,               case when ex.hemorrhage is null then null else ex.hemorrhage end as  IO_hemorrhage,               ex.etc IO_status_etc,               '111' as IO_OrderNo,               '111' as IO_PrintTime,               a.ORDDRID as IO_MaindrId,               '' as IO_ErdrNm,               COM.FN_ZS_GETUSERNM(a.ORDDRID, a.orddd) as IO_MaindrNm,               '111' as IO_OcrCd,               a.ORDDRID as IO_InputId,               COM.FN_ZS_GETUSERNM(a.ORDDRID, a.orddd) as IO_InputNm,               '111' as IO_SignImg          FROM pam.pmohotpt a            left outer join cmr.consent_data_ex ex              on (ex.pid = a.pid and ex.cln_date = a.orddd)            left outer join pam.pmcmptbs ptbs              on (ptbs.pid = a.pid and ptbs.instcd = a.instcd)          WHERE a.instcd =  :param0               AND a.pid =  :param1               AND a.orddd =  :param2               AND A.HISTSTAT IN ('R', 'T')              AND A.MSKIND = 'M'                          AND a.cretno =  :param3                     AND a.orddeptcd =  :param4]

[Logging Date Time: 2016-11-25 17:54:32,149] =====================================================================================
SQL Command - Statement Id: [getPatientInfoOut] PreparedStatement : [SELECT a.orddeptcd,               a.pid as IO_Pt_ID,               to_char(a.cretno) as IO_CretNo,               ( ptbs.sex || '/' ||                       com.fn_zz_getageas(ptbs.rrgstno1,                                          ptbs.rrgstno2,                                          TO_CHAR(SYSDATE, 'YYYYMMDD'),                                          'A',                                          ptbs.brthdd)) as IO_sex_age_y_m,               ptbs.hngnm as IO_Pt_Name,               (ptbs.rrgstno1 || '-' || substr(ptbs.rrgstno2, 1, 1) ||'******') IO_JuminNo,           ptbs.zipcdaddr as IO_Zipcdaddr,               ptbs.mpphontel as IO_Tel,           (select cdnm from com.zbcmcode where cdgrupid='P0008' and cdid =a.insukind) as IO_Insukind,               '' as IO_Ward,               '' as IO_roomNO,               a.orddd as IO_ADdate,               a.orddd as IO_Dschdd,               a.ordtype as IO_VisitType,               a.orddeptcd as IO_DeptCd,               (select dept.deptengabbr                  from com.zsdddept dept                 where dept.deptcd = a.orddeptcd                       and dept.instcd = a.instcd                       and dept.valitodd >= a.orddd                       and dept.valifromdd <= a.orddd) as IO_DeptNm,               COM.FN_ZS_GETDEPTNAME(a.instcd, a.orddeptcd, a.orddd) AS IO_Dept2,               '' AS IO_OPdeptCd,               '' AS IO_OPdeptNm,               '' AS IO_OPdrNm,               '' AS IO_OPdrId,               (SELECT diag.diagcd                  FROM emr.mmohdiag diag                 WHERE diag.pid = a.pid                       AND diag.orddd = a.orddd                       AND diag.cretno = a.cretno                       AND diag.diaghistcd = 'O'                       AND diag.diagtypecd = 'D'                       AND diag.diagkindcdflag = 'M'                       AND diag.genrflagcd = a.ordtype                       and diag.orddeptcd = a.orddeptcd                       AND diag.diaghistno = (select max(diagh.diaghistno)                                          from emr.mmohdiag diagh                                         where diagh.pid = a.pid                                               AND diagh.orddd = a.orddd                                               AND diagh.cretno = a.cretno                                               AND diagh.instcd = '111'                                               AND diagh.diaghistcd = 'O'                                                              AND diagh.diagkindcdflag = 'M'                                                              AND diagh.genrflagcd = a.ordtype                                               and diagh.orddeptcd = a.orddeptcd                                         group by pid)) as IO_DxCd,               (SELECT term.diaghngnm                  FROM emr.mmohdiag diag,                       emr.mmbvdiag term                 WHERE diag.pid = a.pid                       AND diag.orddd = a.orddd                       AND diag.cretno = a.cretno                       AND diag.instcd = term.instcd                       AND diag.diagcd = term.orgdiagcd                       AND diag.diaghistcd = 'O'                       AND diag.diagtypecd = 'D'                       AND diag.diagkindcdflag = 'M'                       AND diag.diagdd >= term.termfromdd                       AND diag.diagdd <= term.termtodd                       AND diag.diagdd >= term.diagattrfromdd                       AND diag.diagdd <= term.diagattrtodd                       AND diag.genrflagcd = a.ordtype                       and diag.orddeptcd = a.orddeptcd                       AND diag.diaghistno = (select max(diagh.diaghistno)                                          from emr.mmohdiag diagh                                         where diagh.pid = a.pid                                               AND diagh.orddd = a.orddd                                               AND diagh.cretno = a.cretno                                               AND diagh.instcd = '111'                                               AND diagh.diaghistcd = 'O'                                                              AND diagh.diagkindcdflag = 'M'                                                              AND diagh.genrflagcd = a.ordtype                                               and diagh.orddeptcd = a.orddeptcd                                         group by pid)) as IO_DxNm,               COM.FN_ZS_GETUSERNM(a.orddrid, a.orddd) as IO_MaindrNm,               '111' as IO_HosType,               case when ex.bp is null then null else ex.bp end as IO_bp,               case when ex.dm is null then null else ex.dm end as IO_dm,               case when ex.heart is null then null else ex.heart end as IO_heart,               case when ex.kidney is null then null else ex.kidney end as IO_kidney,               case when ex.respiration is null then null else ex.respiration end as IO_respiration,               case when ex.hx is null then null else ex.hx end as  IO_hx,               case when ex.allergy is null then null else ex.allergy end as  IO_allergy,               case when ex.drug is null then null else ex.drug end as  IO_drug,               case when ex.smoking is null then null else ex.smoking end as  IO_smoking,               case when ex.idio is null then null else ex.idio end as  IO_idio,               case when ex.nacrotics is null then null else ex.nacrotics end as  IO_nacrotics,               case when ex.airway is null then null else ex.airway end as  IO_airway,               case when ex.hemorrhage is null then null else ex.hemorrhage end as  IO_hemorrhage,               ex.etc IO_status_etc,               '111' as IO_OrderNo,               '111' as IO_PrintTime,               a.ORDDRID as IO_MaindrId,               '' as IO_ErdrNm,               COM.FN_ZS_GETUSERNM(a.ORDDRID, a.orddd) as IO_MaindrNm,               '111' as IO_OcrCd,               a.ORDDRID as IO_InputId,               COM.FN_ZS_GETUSERNM(a.ORDDRID, a.orddd) as IO_InputNm,               '111' as IO_SignImg          FROM pam.pmohotpt a            left outer join cmr.consent_data_ex ex              on (ex.pid = a.pid and ex.cln_date = a.orddd)            left outer join pam.pmcmptbs ptbs              on (ptbs.pid = a.pid and ptbs.instcd = a.instcd)          WHERE a.instcd =  :param0               AND a.pid =  :param1               AND a.orddd =  :param2               AND A.HISTSTAT IN ('R', 'T')              AND A.MSKIND = 'M'                          AND a.cretno =  :param3                     AND a.orddeptcd =  :param4]

[Logging Date Time: 2016-11-25 17:54:32,150] =====================================================================================
SQL Command - Statement Id: [getPatientInfoOut] Parameters: [param0=[instcd,111], param1=[pid,0656166], param2=[orddd,20161125], param3=[cretno,1], param4=[orddeptcd,2010400000]]

[Logging Date Time: 2016-11-25 17:54:32,150] =====================================================================================
SQL Command - Statement Id: [getPatientInfoOut] Parameters: [param0=[instcd,111], param1=[pid,0656166], param2=[orddd,20161125], param3=[cretno,1], param4=[orddeptcd,2010400000]]

[Logging Date Time: 2016-11-25 17:54:32,151] =====================================================================================
SQL Command - Statement Id: [getPatientInfoOut] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:54:32,151] =====================================================================================
SQL Command - Statement Id: [getPatientInfoOut] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:54:32,230] =====================================================================================
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-25 17:54:32,230] =====================================================================================
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-25 17:54:32,232] =====================================================================================
SQL Command - Statement Id: [GET_SEQUENCE] Parameters: [param0=[sub_cd,CONSENT_MST]]

[Logging Date Time: 2016-11-25 17:54:32,232] =====================================================================================
SQL Command - Statement Id: [GET_SEQUENCE] Parameters: [param0=[sub_cd,CONSENT_MST]]

[Logging Date Time: 2016-11-25 17:54:32,232] =====================================================================================
SQL Command - Statement Id: [GET_SEQUENCE] Types: [param0=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:54:32,232] =====================================================================================
SQL Command - Statement Id: [GET_SEQUENCE] Types: [param0=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:54:32,234] =====================================================================================
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-25 17:54:32,234] =====================================================================================
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-25 17:54:32,236] =====================================================================================
SQL Command - Statement Id: [UPDATE_SEQUENCE] Parameters: [param0=[ud1_num,2371], param1=[sub_cd,CONSENT_MST]]

[Logging Date Time: 2016-11-25 17:54:32,236] =====================================================================================
SQL Command - Statement Id: [UPDATE_SEQUENCE] Parameters: [param0=[ud1_num,2371], param1=[sub_cd,CONSENT_MST]]

[Logging Date Time: 2016-11-25 17:54:32,236] =====================================================================================
SQL Command - Statement Id: [UPDATE_SEQUENCE] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:54:32,236] =====================================================================================
SQL Command - Statement Id: [UPDATE_SEQUENCE] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:54:32,237] =====================================================================================
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-25 17:54:32,237] =====================================================================================
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-25 17:54:32,237] =====================================================================================
SQL Command - Statement Id: [GET_SEQUENCE] Parameters: [param0=[sub_cd,CONSENT_DATA]]

[Logging Date Time: 2016-11-25 17:54:32,237] =====================================================================================
SQL Command - Statement Id: [GET_SEQUENCE] Parameters: [param0=[sub_cd,CONSENT_DATA]]

[Logging Date Time: 2016-11-25 17:54:32,238] =====================================================================================
SQL Command - Statement Id: [GET_SEQUENCE] Types: [param0=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:54:32,238] =====================================================================================
SQL Command - Statement Id: [GET_SEQUENCE] Types: [param0=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:54:32,243] =====================================================================================
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-25 17:54:32,243] =====================================================================================
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-25 17:54:32,243] =====================================================================================
SQL Command - Statement Id: [UPDATE_SEQUENCE] Parameters: [param0=[ud1_num,2260], param1=[sub_cd,CONSENT_DATA]]

[Logging Date Time: 2016-11-25 17:54:32,243] =====================================================================================
SQL Command - Statement Id: [UPDATE_SEQUENCE] Parameters: [param0=[ud1_num,2260], param1=[sub_cd,CONSENT_DATA]]

[Logging Date Time: 2016-11-25 17:54:32,244] =====================================================================================
SQL Command - Statement Id: [UPDATE_SEQUENCE] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:54:32,244] =====================================================================================
SQL Command - Statement Id: [UPDATE_SEQUENCE] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:54:32,246] =====================================================================================
SQL Command - Statement Id: [INSERT_CONSENT_MST] PreparedStatement : [insert into CONSENT_MST          (            CONSENT_MST_RID,            HOS_TYPE,             PID,            VISIT_TYPE,            OCR_NUMBER,            CLN_DEPT_CD,            CLN_DATE,            CRETNO,            WARDCD,            ROOMCD,            FORM_RID,            CONSENT_STATE,            COMPLETE_YN,            COMPLETE_DATETIME,            PAPER_YN,            REISSUE_YN,            REISSUE_CONSENT_MST_RID,            REWRITE_YN,            REWRITE_CONSENT_MST_RID,            USE_YN,            MAIN_DR_ID,            CREATE_USER_ID,            CREATE_DATETIME,            MODIFY_USER_ID,            MODIFY_DATETIME,            CREATE_USER_NAME,            MODIFY_USER_NAME          )          values          (             :param0 ,             :param1 ,             :param2 ,             :param3 ,             :param4 ,             :param5 ,             :param6 ,             :param7 ,             :param8 ,             :param9 ,             :param10 ,             :param11 ,             :param12 ,            '',             :param13 ,             :param14 ,             :param15 ,             :param16 ,             :param17 ,            'Y',             :param18 ,             :param19 ,            TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'),             :param19 ,            TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'),             :param20 ,             :param21           )]

[Logging Date Time: 2016-11-25 17:54:32,246] =====================================================================================
SQL Command - Statement Id: [INSERT_CONSENT_MST] PreparedStatement : [insert into CONSENT_MST          (            CONSENT_MST_RID,            HOS_TYPE,             PID,            VISIT_TYPE,            OCR_NUMBER,            CLN_DEPT_CD,            CLN_DATE,            CRETNO,            WARDCD,            ROOMCD,            FORM_RID,            CONSENT_STATE,            COMPLETE_YN,            COMPLETE_DATETIME,            PAPER_YN,            REISSUE_YN,            REISSUE_CONSENT_MST_RID,            REWRITE_YN,            REWRITE_CONSENT_MST_RID,            USE_YN,            MAIN_DR_ID,            CREATE_USER_ID,            CREATE_DATETIME,            MODIFY_USER_ID,            MODIFY_DATETIME,            CREATE_USER_NAME,            MODIFY_USER_NAME          )          values          (             :param0 ,             :param1 ,             :param2 ,             :param3 ,             :param4 ,             :param5 ,             :param6 ,             :param7 ,             :param8 ,             :param9 ,             :param10 ,             :param11 ,             :param12 ,            '',             :param13 ,             :param14 ,             :param15 ,             :param16 ,             :param17 ,            'Y',             :param18 ,             :param19 ,            TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'),             :param19 ,            TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'),             :param20 ,             :param21           )]

[Logging Date Time: 2016-11-25 17:54:32,247] =====================================================================================
SQL Command - Statement Id: [INSERT_CONSENT_MST] Parameters: [param0=[consentMstRid,2371], param1=[hosType,111], param2=[patientCode,0656166], param3=[vistType,O], param4=[ocrCode,2016112564623], param5=[clnDeptCd,2010400000], param6=[clnDate,20161125], param7=[cretno,1], param8=[ward,null], param9=[roomcd,null], param10=[formRid,1062], param11=[consentState,PAPER_OUT], param12=[completeYn,N], param13=[paperYn,Y], param14=[reissueYn,N], param15=[reissueConsentMstRid,0], param16=[rewriteYn,N], param17=[rewriteConsentMstRid,0], param18=[mainDrId,107945], param19=[userId,107945], param20=[createUserName,±èÀçÈñ], param21=[modifyUserName,±èÀçÈñ]]

[Logging Date Time: 2016-11-25 17:54:32,247] =====================================================================================
SQL Command - Statement Id: [INSERT_CONSENT_MST] Parameters: [param0=[consentMstRid,2371], param1=[hosType,111], param2=[patientCode,0656166], param3=[vistType,O], param4=[ocrCode,2016112564623], param5=[clnDeptCd,2010400000], param6=[clnDate,20161125], param7=[cretno,1], param8=[ward,null], param9=[roomcd,null], param10=[formRid,1062], param11=[consentState,PAPER_OUT], param12=[completeYn,N], param13=[paperYn,Y], param14=[reissueYn,N], param15=[reissueConsentMstRid,0], param16=[rewriteYn,N], param17=[rewriteConsentMstRid,0], param18=[mainDrId,107945], param19=[userId,107945], param20=[createUserName,±èÀçÈñ], param21=[modifyUserName,±èÀçÈñ]]

[Logging Date Time: 2016-11-25 17:54:32,247] =====================================================================================
SQL Command - Statement Id: [INSERT_CONSENT_MST] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String], param5=[AnsiString, System.String], param6=[AnsiString, System.String], param7=[Int32, System.Int32], param8=[System.DBNull, null], param9=[System.DBNull, null], param10=[Int32, System.Int32], param11=[AnsiString, System.String], param12=[AnsiString, System.String], param13=[AnsiString, System.String], param14=[AnsiString, System.String], param15=[Int32, System.Int32], param16=[AnsiString, System.String], param17=[Int32, System.Int32], param18=[AnsiString, System.String], param19=[AnsiString, System.String], param20=[AnsiString, System.String], param21=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:54:32,247] =====================================================================================
SQL Command - Statement Id: [INSERT_CONSENT_MST] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String], param5=[AnsiString, System.String], param6=[AnsiString, System.String], param7=[Int32, System.Int32], param8=[System.DBNull, null], param9=[System.DBNull, null], param10=[Int32, System.Int32], param11=[AnsiString, System.String], param12=[AnsiString, System.String], param13=[AnsiString, System.String], param14=[AnsiString, System.String], param15=[Int32, System.Int32], param16=[AnsiString, System.String], param17=[Int32, System.Int32], param18=[AnsiString, System.String], param19=[AnsiString, System.String], param20=[AnsiString, System.String], param21=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:54:54,668] =====================================================================================
SQL Command - Statement Id: [getUserSignImage] PreparedStatement : [SELECT  signdata            FROM  emr.mrfmsignimge           WHERE  userid =  :param0              and  repryn = 'Y']

[Logging Date Time: 2016-11-25 17:54:54,668] =====================================================================================
SQL Command - Statement Id: [getUserSignImage] PreparedStatement : [SELECT  signdata            FROM  emr.mrfmsignimge           WHERE  userid =  :param0              and  repryn = 'Y']

[Logging Date Time: 2016-11-25 17:54:54,668] =====================================================================================
SQL Command - Statement Id: [getUserSignImage] Parameters: [param0=[userid,107945]]

[Logging Date Time: 2016-11-25 17:54:54,668] =====================================================================================
SQL Command - Statement Id: [getUserSignImage] Parameters: [param0=[userid,107945]]

[Logging Date Time: 2016-11-25 17:54:54,668] =====================================================================================
SQL Command - Statement Id: [getUserSignImage] Types: [param0=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:54:54,668] =====================================================================================
SQL Command - Statement Id: [getUserSignImage] Types: [param0=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:55:05,087] =====================================================================================
SQL Command - Statement Id: [getOcrTag] PreparedStatement : [SELECT to_char(sysdate,'YYYYMMDD') || SUBSTR(LPAD((EMR.SQ_MRFMOCRP_01.NEXTVAL), 10, '0'), 6, 5) AS ocrtag        FROM dual]

[Logging Date Time: 2016-11-25 17:55:05,087] =====================================================================================
SQL Command - Statement Id: [getOcrTag] PreparedStatement : [SELECT to_char(sysdate,'YYYYMMDD') || SUBSTR(LPAD((EMR.SQ_MRFMOCRP_01.NEXTVAL), 10, '0'), 6, 5) AS ocrtag        FROM dual]

[Logging Date Time: 2016-11-25 17:55:19,415] =====================================================================================
SQL Command - Statement Id: [getPatientInfoOut] PreparedStatement : [SELECT a.orddeptcd,               a.pid as IO_Pt_ID,               to_char(a.cretno) as IO_CretNo,               ( ptbs.sex || '/' ||                       com.fn_zz_getageas(ptbs.rrgstno1,                                          ptbs.rrgstno2,                                          TO_CHAR(SYSDATE, 'YYYYMMDD'),                                          'A',                                          ptbs.brthdd)) as IO_sex_age_y_m,               ptbs.hngnm as IO_Pt_Name,               (ptbs.rrgstno1 || '-' || substr(ptbs.rrgstno2, 1, 1) ||'******') IO_JuminNo,           ptbs.zipcdaddr as IO_Zipcdaddr,               ptbs.mpphontel as IO_Tel,           (select cdnm from com.zbcmcode where cdgrupid='P0008' and cdid =a.insukind) as IO_Insukind,               '' as IO_Ward,               '' as IO_roomNO,               a.orddd as IO_ADdate,               a.orddd as IO_Dschdd,               a.ordtype as IO_VisitType,               a.orddeptcd as IO_DeptCd,               (select dept.deptengabbr                  from com.zsdddept dept                 where dept.deptcd = a.orddeptcd                       and dept.instcd = a.instcd                       and dept.valitodd >= a.orddd                       and dept.valifromdd <= a.orddd) as IO_DeptNm,               COM.FN_ZS_GETDEPTNAME(a.instcd, a.orddeptcd, a.orddd) AS IO_Dept2,               '' AS IO_OPdeptCd,               '' AS IO_OPdeptNm,               '' AS IO_OPdrNm,               '' AS IO_OPdrId,               (SELECT diag.diagcd                  FROM emr.mmohdiag diag                 WHERE diag.pid = a.pid                       AND diag.orddd = a.orddd                       AND diag.cretno = a.cretno                       AND diag.diaghistcd = 'O'                       AND diag.diagtypecd = 'D'                       AND diag.diagkindcdflag = 'M'                       AND diag.genrflagcd = a.ordtype                       and diag.orddeptcd = a.orddeptcd                       AND diag.diaghistno = (select max(diagh.diaghistno)                                          from emr.mmohdiag diagh                                         where diagh.pid = a.pid                                               AND diagh.orddd = a.orddd                                               AND diagh.cretno = a.cretno                                               AND diagh.instcd = '111'                                               AND diagh.diaghistcd = 'O'                                                              AND diagh.diagkindcdflag = 'M'                                                              AND diagh.genrflagcd = a.ordtype                                               and diagh.orddeptcd = a.orddeptcd                                         group by pid)) as IO_DxCd,               (SELECT term.diaghngnm                  FROM emr.mmohdiag diag,                       emr.mmbvdiag term                 WHERE diag.pid = a.pid                       AND diag.orddd = a.orddd                       AND diag.cretno = a.cretno                       AND diag.instcd = term.instcd                       AND diag.diagcd = term.orgdiagcd                       AND diag.diaghistcd = 'O'                       AND diag.diagtypecd = 'D'                       AND diag.diagkindcdflag = 'M'                       AND diag.diagdd >= term.termfromdd                       AND diag.diagdd <= term.termtodd                       AND diag.diagdd >= term.diagattrfromdd                       AND diag.diagdd <= term.diagattrtodd                       AND diag.genrflagcd = a.ordtype                       and diag.orddeptcd = a.orddeptcd                       AND diag.diaghistno = (select max(diagh.diaghistno)                                          from emr.mmohdiag diagh                                         where diagh.pid = a.pid                                               AND diagh.orddd = a.orddd                                               AND diagh.cretno = a.cretno                                               AND diagh.instcd = '111'                                               AND diagh.diaghistcd = 'O'                                                              AND diagh.diagkindcdflag = 'M'                                                              AND diagh.genrflagcd = a.ordtype                                               and diagh.orddeptcd = a.orddeptcd                                         group by pid)) as IO_DxNm,               COM.FN_ZS_GETUSERNM(a.orddrid, a.orddd) as IO_MaindrNm,               '111' as IO_HosType,               case when ex.bp is null then null else ex.bp end as IO_bp,               case when ex.dm is null then null else ex.dm end as IO_dm,               case when ex.heart is null then null else ex.heart end as IO_heart,               case when ex.kidney is null then null else ex.kidney end as IO_kidney,               case when ex.respiration is null then null else ex.respiration end as IO_respiration,               case when ex.hx is null then null else ex.hx end as  IO_hx,               case when ex.allergy is null then null else ex.allergy end as  IO_allergy,               case when ex.drug is null then null else ex.drug end as  IO_drug,               case when ex.smoking is null then null else ex.smoking end as  IO_smoking,               case when ex.idio is null then null else ex.idio end as  IO_idio,               case when ex.nacrotics is null then null else ex.nacrotics end as  IO_nacrotics,               case when ex.airway is null then null else ex.airway end as  IO_airway,               case when ex.hemorrhage is null then null else ex.hemorrhage end as  IO_hemorrhage,               ex.etc IO_status_etc,               '111' as IO_OrderNo,               '111' as IO_PrintTime,               a.ORDDRID as IO_MaindrId,               '' as IO_ErdrNm,               COM.FN_ZS_GETUSERNM(a.ORDDRID, a.orddd) as IO_MaindrNm,               '111' as IO_OcrCd,               a.ORDDRID as IO_InputId,               COM.FN_ZS_GETUSERNM(a.ORDDRID, a.orddd) as IO_InputNm,               '111' as IO_SignImg          FROM pam.pmohotpt a            left outer join cmr.consent_data_ex ex              on (ex.pid = a.pid and ex.cln_date = a.orddd)            left outer join pam.pmcmptbs ptbs              on (ptbs.pid = a.pid and ptbs.instcd = a.instcd)          WHERE a.instcd =  :param0               AND a.pid =  :param1               AND a.orddd =  :param2               AND A.HISTSTAT IN ('R', 'T')              AND A.MSKIND = 'M'                          AND a.cretno =  :param3                     AND a.orddeptcd =  :param4]

[Logging Date Time: 2016-11-25 17:55:19,415] =====================================================================================
SQL Command - Statement Id: [getPatientInfoOut] PreparedStatement : [SELECT a.orddeptcd,               a.pid as IO_Pt_ID,               to_char(a.cretno) as IO_CretNo,               ( ptbs.sex || '/' ||                       com.fn_zz_getageas(ptbs.rrgstno1,                                          ptbs.rrgstno2,                                          TO_CHAR(SYSDATE, 'YYYYMMDD'),                                          'A',                                          ptbs.brthdd)) as IO_sex_age_y_m,               ptbs.hngnm as IO_Pt_Name,               (ptbs.rrgstno1 || '-' || substr(ptbs.rrgstno2, 1, 1) ||'******') IO_JuminNo,           ptbs.zipcdaddr as IO_Zipcdaddr,               ptbs.mpphontel as IO_Tel,           (select cdnm from com.zbcmcode where cdgrupid='P0008' and cdid =a.insukind) as IO_Insukind,               '' as IO_Ward,               '' as IO_roomNO,               a.orddd as IO_ADdate,               a.orddd as IO_Dschdd,               a.ordtype as IO_VisitType,               a.orddeptcd as IO_DeptCd,               (select dept.deptengabbr                  from com.zsdddept dept                 where dept.deptcd = a.orddeptcd                       and dept.instcd = a.instcd                       and dept.valitodd >= a.orddd                       and dept.valifromdd <= a.orddd) as IO_DeptNm,               COM.FN_ZS_GETDEPTNAME(a.instcd, a.orddeptcd, a.orddd) AS IO_Dept2,               '' AS IO_OPdeptCd,               '' AS IO_OPdeptNm,               '' AS IO_OPdrNm,               '' AS IO_OPdrId,               (SELECT diag.diagcd                  FROM emr.mmohdiag diag                 WHERE diag.pid = a.pid                       AND diag.orddd = a.orddd                       AND diag.cretno = a.cretno                       AND diag.diaghistcd = 'O'                       AND diag.diagtypecd = 'D'                       AND diag.diagkindcdflag = 'M'                       AND diag.genrflagcd = a.ordtype                       and diag.orddeptcd = a.orddeptcd                       AND diag.diaghistno = (select max(diagh.diaghistno)                                          from emr.mmohdiag diagh                                         where diagh.pid = a.pid                                               AND diagh.orddd = a.orddd                                               AND diagh.cretno = a.cretno                                               AND diagh.instcd = '111'                                               AND diagh.diaghistcd = 'O'                                                              AND diagh.diagkindcdflag = 'M'                                                              AND diagh.genrflagcd = a.ordtype                                               and diagh.orddeptcd = a.orddeptcd                                         group by pid)) as IO_DxCd,               (SELECT term.diaghngnm                  FROM emr.mmohdiag diag,                       emr.mmbvdiag term                 WHERE diag.pid = a.pid                       AND diag.orddd = a.orddd                       AND diag.cretno = a.cretno                       AND diag.instcd = term.instcd                       AND diag.diagcd = term.orgdiagcd                       AND diag.diaghistcd = 'O'                       AND diag.diagtypecd = 'D'                       AND diag.diagkindcdflag = 'M'                       AND diag.diagdd >= term.termfromdd                       AND diag.diagdd <= term.termtodd                       AND diag.diagdd >= term.diagattrfromdd                       AND diag.diagdd <= term.diagattrtodd                       AND diag.genrflagcd = a.ordtype                       and diag.orddeptcd = a.orddeptcd                       AND diag.diaghistno = (select max(diagh.diaghistno)                                          from emr.mmohdiag diagh                                         where diagh.pid = a.pid                                               AND diagh.orddd = a.orddd                                               AND diagh.cretno = a.cretno                                               AND diagh.instcd = '111'                                               AND diagh.diaghistcd = 'O'                                                              AND diagh.diagkindcdflag = 'M'                                                              AND diagh.genrflagcd = a.ordtype                                               and diagh.orddeptcd = a.orddeptcd                                         group by pid)) as IO_DxNm,               COM.FN_ZS_GETUSERNM(a.orddrid, a.orddd) as IO_MaindrNm,               '111' as IO_HosType,               case when ex.bp is null then null else ex.bp end as IO_bp,               case when ex.dm is null then null else ex.dm end as IO_dm,               case when ex.heart is null then null else ex.heart end as IO_heart,               case when ex.kidney is null then null else ex.kidney end as IO_kidney,               case when ex.respiration is null then null else ex.respiration end as IO_respiration,               case when ex.hx is null then null else ex.hx end as  IO_hx,               case when ex.allergy is null then null else ex.allergy end as  IO_allergy,               case when ex.drug is null then null else ex.drug end as  IO_drug,               case when ex.smoking is null then null else ex.smoking end as  IO_smoking,               case when ex.idio is null then null else ex.idio end as  IO_idio,               case when ex.nacrotics is null then null else ex.nacrotics end as  IO_nacrotics,               case when ex.airway is null then null else ex.airway end as  IO_airway,               case when ex.hemorrhage is null then null else ex.hemorrhage end as  IO_hemorrhage,               ex.etc IO_status_etc,               '111' as IO_OrderNo,               '111' as IO_PrintTime,               a.ORDDRID as IO_MaindrId,               '' as IO_ErdrNm,               COM.FN_ZS_GETUSERNM(a.ORDDRID, a.orddd) as IO_MaindrNm,               '111' as IO_OcrCd,               a.ORDDRID as IO_InputId,               COM.FN_ZS_GETUSERNM(a.ORDDRID, a.orddd) as IO_InputNm,               '111' as IO_SignImg          FROM pam.pmohotpt a            left outer join cmr.consent_data_ex ex              on (ex.pid = a.pid and ex.cln_date = a.orddd)            left outer join pam.pmcmptbs ptbs              on (ptbs.pid = a.pid and ptbs.instcd = a.instcd)          WHERE a.instcd =  :param0               AND a.pid =  :param1               AND a.orddd =  :param2               AND A.HISTSTAT IN ('R', 'T')              AND A.MSKIND = 'M'                          AND a.cretno =  :param3                     AND a.orddeptcd =  :param4]

[Logging Date Time: 2016-11-25 17:55:19,416] =====================================================================================
SQL Command - Statement Id: [getPatientInfoOut] Parameters: [param0=[instcd,111], param1=[pid,0656166], param2=[orddd,20161125], param3=[cretno,1], param4=[orddeptcd,2010400000]]

[Logging Date Time: 2016-11-25 17:55:19,416] =====================================================================================
SQL Command - Statement Id: [getPatientInfoOut] Parameters: [param0=[instcd,111], param1=[pid,0656166], param2=[orddd,20161125], param3=[cretno,1], param4=[orddeptcd,2010400000]]

[Logging Date Time: 2016-11-25 17:55:19,416] =====================================================================================
SQL Command - Statement Id: [getPatientInfoOut] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:55:19,416] =====================================================================================
SQL Command - Statement Id: [getPatientInfoOut] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:55:19,617] =====================================================================================
SQL Command - Statement Id: [getOcrTag] PreparedStatement : [SELECT to_char(sysdate,'YYYYMMDD') || SUBSTR(LPAD((EMR.SQ_MRFMOCRP_01.NEXTVAL), 10, '0'), 6, 5) AS ocrtag        FROM dual]

[Logging Date Time: 2016-11-25 17:55:19,617] =====================================================================================
SQL Command - Statement Id: [getOcrTag] PreparedStatement : [SELECT to_char(sysdate,'YYYYMMDD') || SUBSTR(LPAD((EMR.SQ_MRFMOCRP_01.NEXTVAL), 10, '0'), 6, 5) AS ocrtag        FROM dual]

[Logging Date Time: 2016-11-25 17:55:19,683] =====================================================================================
SQL Command - Statement Id: [getPatientInfoOut] PreparedStatement : [SELECT a.orddeptcd,               a.pid as IO_Pt_ID,               to_char(a.cretno) as IO_CretNo,               ( ptbs.sex || '/' ||                       com.fn_zz_getageas(ptbs.rrgstno1,                                          ptbs.rrgstno2,                                          TO_CHAR(SYSDATE, 'YYYYMMDD'),                                          'A',                                          ptbs.brthdd)) as IO_sex_age_y_m,               ptbs.hngnm as IO_Pt_Name,               (ptbs.rrgstno1 || '-' || substr(ptbs.rrgstno2, 1, 1) ||'******') IO_JuminNo,           ptbs.zipcdaddr as IO_Zipcdaddr,               ptbs.mpphontel as IO_Tel,           (select cdnm from com.zbcmcode where cdgrupid='P0008' and cdid =a.insukind) as IO_Insukind,               '' as IO_Ward,               '' as IO_roomNO,               a.orddd as IO_ADdate,               a.orddd as IO_Dschdd,               a.ordtype as IO_VisitType,               a.orddeptcd as IO_DeptCd,               (select dept.deptengabbr                  from com.zsdddept dept                 where dept.deptcd = a.orddeptcd                       and dept.instcd = a.instcd                       and dept.valitodd >= a.orddd                       and dept.valifromdd <= a.orddd) as IO_DeptNm,               COM.FN_ZS_GETDEPTNAME(a.instcd, a.orddeptcd, a.orddd) AS IO_Dept2,               '' AS IO_OPdeptCd,               '' AS IO_OPdeptNm,               '' AS IO_OPdrNm,               '' AS IO_OPdrId,               (SELECT diag.diagcd                  FROM emr.mmohdiag diag                 WHERE diag.pid = a.pid                       AND diag.orddd = a.orddd                       AND diag.cretno = a.cretno                       AND diag.diaghistcd = 'O'                       AND diag.diagtypecd = 'D'                       AND diag.diagkindcdflag = 'M'                       AND diag.genrflagcd = a.ordtype                       and diag.orddeptcd = a.orddeptcd                       AND diag.diaghistno = (select max(diagh.diaghistno)                                          from emr.mmohdiag diagh                                         where diagh.pid = a.pid                                               AND diagh.orddd = a.orddd                                               AND diagh.cretno = a.cretno                                               AND diagh.instcd = '111'                                               AND diagh.diaghistcd = 'O'                                                              AND diagh.diagkindcdflag = 'M'                                                              AND diagh.genrflagcd = a.ordtype                                               and diagh.orddeptcd = a.orddeptcd                                         group by pid)) as IO_DxCd,               (SELECT term.diaghngnm                  FROM emr.mmohdiag diag,                       emr.mmbvdiag term                 WHERE diag.pid = a.pid                       AND diag.orddd = a.orddd                       AND diag.cretno = a.cretno                       AND diag.instcd = term.instcd                       AND diag.diagcd = term.orgdiagcd                       AND diag.diaghistcd = 'O'                       AND diag.diagtypecd = 'D'                       AND diag.diagkindcdflag = 'M'                       AND diag.diagdd >= term.termfromdd                       AND diag.diagdd <= term.termtodd                       AND diag.diagdd >= term.diagattrfromdd                       AND diag.diagdd <= term.diagattrtodd                       AND diag.genrflagcd = a.ordtype                       and diag.orddeptcd = a.orddeptcd                       AND diag.diaghistno = (select max(diagh.diaghistno)                                          from emr.mmohdiag diagh                                         where diagh.pid = a.pid                                               AND diagh.orddd = a.orddd                                               AND diagh.cretno = a.cretno                                               AND diagh.instcd = '111'                                               AND diagh.diaghistcd = 'O'                                                              AND diagh.diagkindcdflag = 'M'                                                              AND diagh.genrflagcd = a.ordtype                                               and diagh.orddeptcd = a.orddeptcd                                         group by pid)) as IO_DxNm,               COM.FN_ZS_GETUSERNM(a.orddrid, a.orddd) as IO_MaindrNm,               '111' as IO_HosType,               case when ex.bp is null then null else ex.bp end as IO_bp,               case when ex.dm is null then null else ex.dm end as IO_dm,               case when ex.heart is null then null else ex.heart end as IO_heart,               case when ex.kidney is null then null else ex.kidney end as IO_kidney,               case when ex.respiration is null then null else ex.respiration end as IO_respiration,               case when ex.hx is null then null else ex.hx end as  IO_hx,               case when ex.allergy is null then null else ex.allergy end as  IO_allergy,               case when ex.drug is null then null else ex.drug end as  IO_drug,               case when ex.smoking is null then null else ex.smoking end as  IO_smoking,               case when ex.idio is null then null else ex.idio end as  IO_idio,               case when ex.nacrotics is null then null else ex.nacrotics end as  IO_nacrotics,               case when ex.airway is null then null else ex.airway end as  IO_airway,               case when ex.hemorrhage is null then null else ex.hemorrhage end as  IO_hemorrhage,               ex.etc IO_status_etc,               '111' as IO_OrderNo,               '111' as IO_PrintTime,               a.ORDDRID as IO_MaindrId,               '' as IO_ErdrNm,               COM.FN_ZS_GETUSERNM(a.ORDDRID, a.orddd) as IO_MaindrNm,               '111' as IO_OcrCd,               a.ORDDRID as IO_InputId,               COM.FN_ZS_GETUSERNM(a.ORDDRID, a.orddd) as IO_InputNm,               '111' as IO_SignImg          FROM pam.pmohotpt a            left outer join cmr.consent_data_ex ex              on (ex.pid = a.pid and ex.cln_date = a.orddd)            left outer join pam.pmcmptbs ptbs              on (ptbs.pid = a.pid and ptbs.instcd = a.instcd)          WHERE a.instcd =  :param0               AND a.pid =  :param1               AND a.orddd =  :param2               AND A.HISTSTAT IN ('R', 'T')              AND A.MSKIND = 'M'                          AND a.cretno =  :param3                     AND a.orddeptcd =  :param4]

[Logging Date Time: 2016-11-25 17:55:19,683] =====================================================================================
SQL Command - Statement Id: [getPatientInfoOut] PreparedStatement : [SELECT a.orddeptcd,               a.pid as IO_Pt_ID,               to_char(a.cretno) as IO_CretNo,               ( ptbs.sex || '/' ||                       com.fn_zz_getageas(ptbs.rrgstno1,                                          ptbs.rrgstno2,                                          TO_CHAR(SYSDATE, 'YYYYMMDD'),                                          'A',                                          ptbs.brthdd)) as IO_sex_age_y_m,               ptbs.hngnm as IO_Pt_Name,               (ptbs.rrgstno1 || '-' || substr(ptbs.rrgstno2, 1, 1) ||'******') IO_JuminNo,           ptbs.zipcdaddr as IO_Zipcdaddr,               ptbs.mpphontel as IO_Tel,           (select cdnm from com.zbcmcode where cdgrupid='P0008' and cdid =a.insukind) as IO_Insukind,               '' as IO_Ward,               '' as IO_roomNO,               a.orddd as IO_ADdate,               a.orddd as IO_Dschdd,               a.ordtype as IO_VisitType,               a.orddeptcd as IO_DeptCd,               (select dept.deptengabbr                  from com.zsdddept dept                 where dept.deptcd = a.orddeptcd                       and dept.instcd = a.instcd                       and dept.valitodd >= a.orddd                       and dept.valifromdd <= a.orddd) as IO_DeptNm,               COM.FN_ZS_GETDEPTNAME(a.instcd, a.orddeptcd, a.orddd) AS IO_Dept2,               '' AS IO_OPdeptCd,               '' AS IO_OPdeptNm,               '' AS IO_OPdrNm,               '' AS IO_OPdrId,               (SELECT diag.diagcd                  FROM emr.mmohdiag diag                 WHERE diag.pid = a.pid                       AND diag.orddd = a.orddd                       AND diag.cretno = a.cretno                       AND diag.diaghistcd = 'O'                       AND diag.diagtypecd = 'D'                       AND diag.diagkindcdflag = 'M'                       AND diag.genrflagcd = a.ordtype                       and diag.orddeptcd = a.orddeptcd                       AND diag.diaghistno = (select max(diagh.diaghistno)                                          from emr.mmohdiag diagh                                         where diagh.pid = a.pid                                               AND diagh.orddd = a.orddd                                               AND diagh.cretno = a.cretno                                               AND diagh.instcd = '111'                                               AND diagh.diaghistcd = 'O'                                                              AND diagh.diagkindcdflag = 'M'                                                              AND diagh.genrflagcd = a.ordtype                                               and diagh.orddeptcd = a.orddeptcd                                         group by pid)) as IO_DxCd,               (SELECT term.diaghngnm                  FROM emr.mmohdiag diag,                       emr.mmbvdiag term                 WHERE diag.pid = a.pid                       AND diag.orddd = a.orddd                       AND diag.cretno = a.cretno                       AND diag.instcd = term.instcd                       AND diag.diagcd = term.orgdiagcd                       AND diag.diaghistcd = 'O'                       AND diag.diagtypecd = 'D'                       AND diag.diagkindcdflag = 'M'                       AND diag.diagdd >= term.termfromdd                       AND diag.diagdd <= term.termtodd                       AND diag.diagdd >= term.diagattrfromdd                       AND diag.diagdd <= term.diagattrtodd                       AND diag.genrflagcd = a.ordtype                       and diag.orddeptcd = a.orddeptcd                       AND diag.diaghistno = (select max(diagh.diaghistno)                                          from emr.mmohdiag diagh                                         where diagh.pid = a.pid                                               AND diagh.orddd = a.orddd                                               AND diagh.cretno = a.cretno                                               AND diagh.instcd = '111'                                               AND diagh.diaghistcd = 'O'                                                              AND diagh.diagkindcdflag = 'M'                                                              AND diagh.genrflagcd = a.ordtype                                               and diagh.orddeptcd = a.orddeptcd                                         group by pid)) as IO_DxNm,               COM.FN_ZS_GETUSERNM(a.orddrid, a.orddd) as IO_MaindrNm,               '111' as IO_HosType,               case when ex.bp is null then null else ex.bp end as IO_bp,               case when ex.dm is null then null else ex.dm end as IO_dm,               case when ex.heart is null then null else ex.heart end as IO_heart,               case when ex.kidney is null then null else ex.kidney end as IO_kidney,               case when ex.respiration is null then null else ex.respiration end as IO_respiration,               case when ex.hx is null then null else ex.hx end as  IO_hx,               case when ex.allergy is null then null else ex.allergy end as  IO_allergy,               case when ex.drug is null then null else ex.drug end as  IO_drug,               case when ex.smoking is null then null else ex.smoking end as  IO_smoking,               case when ex.idio is null then null else ex.idio end as  IO_idio,               case when ex.nacrotics is null then null else ex.nacrotics end as  IO_nacrotics,               case when ex.airway is null then null else ex.airway end as  IO_airway,               case when ex.hemorrhage is null then null else ex.hemorrhage end as  IO_hemorrhage,               ex.etc IO_status_etc,               '111' as IO_OrderNo,               '111' as IO_PrintTime,               a.ORDDRID as IO_MaindrId,               '' as IO_ErdrNm,               COM.FN_ZS_GETUSERNM(a.ORDDRID, a.orddd) as IO_MaindrNm,               '111' as IO_OcrCd,               a.ORDDRID as IO_InputId,               COM.FN_ZS_GETUSERNM(a.ORDDRID, a.orddd) as IO_InputNm,               '111' as IO_SignImg          FROM pam.pmohotpt a            left outer join cmr.consent_data_ex ex              on (ex.pid = a.pid and ex.cln_date = a.orddd)            left outer join pam.pmcmptbs ptbs              on (ptbs.pid = a.pid and ptbs.instcd = a.instcd)          WHERE a.instcd =  :param0               AND a.pid =  :param1               AND a.orddd =  :param2               AND A.HISTSTAT IN ('R', 'T')              AND A.MSKIND = 'M'                          AND a.cretno =  :param3                     AND a.orddeptcd =  :param4]

[Logging Date Time: 2016-11-25 17:55:19,684] =====================================================================================
SQL Command - Statement Id: [getPatientInfoOut] Parameters: [param0=[instcd,111], param1=[pid,1113706], param2=[orddd,20161125], param3=[cretno,1], param4=[orddeptcd,2010400000]]

[Logging Date Time: 2016-11-25 17:55:19,684] =====================================================================================
SQL Command - Statement Id: [getPatientInfoOut] Parameters: [param0=[instcd,111], param1=[pid,1113706], param2=[orddd,20161125], param3=[cretno,1], param4=[orddeptcd,2010400000]]

[Logging Date Time: 2016-11-25 17:55:19,684] =====================================================================================
SQL Command - Statement Id: [getPatientInfoOut] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:55:19,684] =====================================================================================
SQL Command - Statement Id: [getPatientInfoOut] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:55:19,791] =====================================================================================
SQL Command - Statement Id: [getOcrTag] PreparedStatement : [SELECT to_char(sysdate,'YYYYMMDD') || SUBSTR(LPAD((EMR.SQ_MRFMOCRP_01.NEXTVAL), 10, '0'), 6, 5) AS ocrtag        FROM dual]

[Logging Date Time: 2016-11-25 17:55:19,791] =====================================================================================
SQL Command - Statement Id: [getOcrTag] PreparedStatement : [SELECT to_char(sysdate,'YYYYMMDD') || SUBSTR(LPAD((EMR.SQ_MRFMOCRP_01.NEXTVAL), 10, '0'), 6, 5) AS ocrtag        FROM dual]

[Logging Date Time: 2016-11-25 17:55:45,092] =====================================================================================
SQL Command - Statement Id: [getPatientInfoOut] PreparedStatement : [SELECT a.orddeptcd,               a.pid as IO_Pt_ID,               to_char(a.cretno) as IO_CretNo,               ( ptbs.sex || '/' ||                       com.fn_zz_getageas(ptbs.rrgstno1,                                          ptbs.rrgstno2,                                          TO_CHAR(SYSDATE, 'YYYYMMDD'),                                          'A',                                          ptbs.brthdd)) as IO_sex_age_y_m,               ptbs.hngnm as IO_Pt_Name,               (ptbs.rrgstno1 || '-' || substr(ptbs.rrgstno2, 1, 1) ||'******') IO_JuminNo,           ptbs.zipcdaddr as IO_Zipcdaddr,               ptbs.mpphontel as IO_Tel,           (select cdnm from com.zbcmcode where cdgrupid='P0008' and cdid =a.insukind) as IO_Insukind,               '' as IO_Ward,               '' as IO_roomNO,               a.orddd as IO_ADdate,               a.orddd as IO_Dschdd,               a.ordtype as IO_VisitType,               a.orddeptcd as IO_DeptCd,               (select dept.deptengabbr                  from com.zsdddept dept                 where dept.deptcd = a.orddeptcd                       and dept.instcd = a.instcd                       and dept.valitodd >= a.orddd                       and dept.valifromdd <= a.orddd) as IO_DeptNm,               COM.FN_ZS_GETDEPTNAME(a.instcd, a.orddeptcd, a.orddd) AS IO_Dept2,               '' AS IO_OPdeptCd,               '' AS IO_OPdeptNm,               '' AS IO_OPdrNm,               '' AS IO_OPdrId,               (SELECT diag.diagcd                  FROM emr.mmohdiag diag                 WHERE diag.pid = a.pid                       AND diag.orddd = a.orddd                       AND diag.cretno = a.cretno                       AND diag.diaghistcd = 'O'                       AND diag.diagtypecd = 'D'                       AND diag.diagkindcdflag = 'M'                       AND diag.genrflagcd = a.ordtype                       and diag.orddeptcd = a.orddeptcd                       AND diag.diaghistno = (select max(diagh.diaghistno)                                          from emr.mmohdiag diagh                                         where diagh.pid = a.pid                                               AND diagh.orddd = a.orddd                                               AND diagh.cretno = a.cretno                                               AND diagh.instcd = '111'                                               AND diagh.diaghistcd = 'O'                                                              AND diagh.diagkindcdflag = 'M'                                                              AND diagh.genrflagcd = a.ordtype                                               and diagh.orddeptcd = a.orddeptcd                                         group by pid)) as IO_DxCd,               (SELECT term.diaghngnm                  FROM emr.mmohdiag diag,                       emr.mmbvdiag term                 WHERE diag.pid = a.pid                       AND diag.orddd = a.orddd                       AND diag.cretno = a.cretno                       AND diag.instcd = term.instcd                       AND diag.diagcd = term.orgdiagcd                       AND diag.diaghistcd = 'O'                       AND diag.diagtypecd = 'D'                       AND diag.diagkindcdflag = 'M'                       AND diag.diagdd >= term.termfromdd                       AND diag.diagdd <= term.termtodd                       AND diag.diagdd >= term.diagattrfromdd                       AND diag.diagdd <= term.diagattrtodd                       AND diag.genrflagcd = a.ordtype                       and diag.orddeptcd = a.orddeptcd                       AND diag.diaghistno = (select max(diagh.diaghistno)                                          from emr.mmohdiag diagh                                         where diagh.pid = a.pid                                               AND diagh.orddd = a.orddd                                               AND diagh.cretno = a.cretno                                               AND diagh.instcd = '111'                                               AND diagh.diaghistcd = 'O'                                                              AND diagh.diagkindcdflag = 'M'                                                              AND diagh.genrflagcd = a.ordtype                                               and diagh.orddeptcd = a.orddeptcd                                         group by pid)) as IO_DxNm,               COM.FN_ZS_GETUSERNM(a.orddrid, a.orddd) as IO_MaindrNm,               '111' as IO_HosType,               case when ex.bp is null then null else ex.bp end as IO_bp,               case when ex.dm is null then null else ex.dm end as IO_dm,               case when ex.heart is null then null else ex.heart end as IO_heart,               case when ex.kidney is null then null else ex.kidney end as IO_kidney,               case when ex.respiration is null then null else ex.respiration end as IO_respiration,               case when ex.hx is null then null else ex.hx end as  IO_hx,               case when ex.allergy is null then null else ex.allergy end as  IO_allergy,               case when ex.drug is null then null else ex.drug end as  IO_drug,               case when ex.smoking is null then null else ex.smoking end as  IO_smoking,               case when ex.idio is null then null else ex.idio end as  IO_idio,               case when ex.nacrotics is null then null else ex.nacrotics end as  IO_nacrotics,               case when ex.airway is null then null else ex.airway end as  IO_airway,               case when ex.hemorrhage is null then null else ex.hemorrhage end as  IO_hemorrhage,               ex.etc IO_status_etc,               '111' as IO_OrderNo,               '111' as IO_PrintTime,               a.ORDDRID as IO_MaindrId,               '' as IO_ErdrNm,               COM.FN_ZS_GETUSERNM(a.ORDDRID, a.orddd) as IO_MaindrNm,               '111' as IO_OcrCd,               a.ORDDRID as IO_InputId,               COM.FN_ZS_GETUSERNM(a.ORDDRID, a.orddd) as IO_InputNm,               '111' as IO_SignImg          FROM pam.pmohotpt a            left outer join cmr.consent_data_ex ex              on (ex.pid = a.pid and ex.cln_date = a.orddd)            left outer join pam.pmcmptbs ptbs              on (ptbs.pid = a.pid and ptbs.instcd = a.instcd)          WHERE a.instcd =  :param0               AND a.pid =  :param1               AND a.orddd =  :param2               AND A.HISTSTAT IN ('R', 'T')              AND A.MSKIND = 'M'                          AND a.cretno =  :param3                     AND a.orddeptcd =  :param4]

[Logging Date Time: 2016-11-25 17:55:45,092] =====================================================================================
SQL Command - Statement Id: [getPatientInfoOut] PreparedStatement : [SELECT a.orddeptcd,               a.pid as IO_Pt_ID,               to_char(a.cretno) as IO_CretNo,               ( ptbs.sex || '/' ||                       com.fn_zz_getageas(ptbs.rrgstno1,                                          ptbs.rrgstno2,                                          TO_CHAR(SYSDATE, 'YYYYMMDD'),                                          'A',                                          ptbs.brthdd)) as IO_sex_age_y_m,               ptbs.hngnm as IO_Pt_Name,               (ptbs.rrgstno1 || '-' || substr(ptbs.rrgstno2, 1, 1) ||'******') IO_JuminNo,           ptbs.zipcdaddr as IO_Zipcdaddr,               ptbs.mpphontel as IO_Tel,           (select cdnm from com.zbcmcode where cdgrupid='P0008' and cdid =a.insukind) as IO_Insukind,               '' as IO_Ward,               '' as IO_roomNO,               a.orddd as IO_ADdate,               a.orddd as IO_Dschdd,               a.ordtype as IO_VisitType,               a.orddeptcd as IO_DeptCd,               (select dept.deptengabbr                  from com.zsdddept dept                 where dept.deptcd = a.orddeptcd                       and dept.instcd = a.instcd                       and dept.valitodd >= a.orddd                       and dept.valifromdd <= a.orddd) as IO_DeptNm,               COM.FN_ZS_GETDEPTNAME(a.instcd, a.orddeptcd, a.orddd) AS IO_Dept2,               '' AS IO_OPdeptCd,               '' AS IO_OPdeptNm,               '' AS IO_OPdrNm,               '' AS IO_OPdrId,               (SELECT diag.diagcd                  FROM emr.mmohdiag diag                 WHERE diag.pid = a.pid                       AND diag.orddd = a.orddd                       AND diag.cretno = a.cretno                       AND diag.diaghistcd = 'O'                       AND diag.diagtypecd = 'D'                       AND diag.diagkindcdflag = 'M'                       AND diag.genrflagcd = a.ordtype                       and diag.orddeptcd = a.orddeptcd                       AND diag.diaghistno = (select max(diagh.diaghistno)                                          from emr.mmohdiag diagh                                         where diagh.pid = a.pid                                               AND diagh.orddd = a.orddd                                               AND diagh.cretno = a.cretno                                               AND diagh.instcd = '111'                                               AND diagh.diaghistcd = 'O'                                                              AND diagh.diagkindcdflag = 'M'                                                              AND diagh.genrflagcd = a.ordtype                                               and diagh.orddeptcd = a.orddeptcd                                         group by pid)) as IO_DxCd,               (SELECT term.diaghngnm                  FROM emr.mmohdiag diag,                       emr.mmbvdiag term                 WHERE diag.pid = a.pid                       AND diag.orddd = a.orddd                       AND diag.cretno = a.cretno                       AND diag.instcd = term.instcd                       AND diag.diagcd = term.orgdiagcd                       AND diag.diaghistcd = 'O'                       AND diag.diagtypecd = 'D'                       AND diag.diagkindcdflag = 'M'                       AND diag.diagdd >= term.termfromdd                       AND diag.diagdd <= term.termtodd                       AND diag.diagdd >= term.diagattrfromdd                       AND diag.diagdd <= term.diagattrtodd                       AND diag.genrflagcd = a.ordtype                       and diag.orddeptcd = a.orddeptcd                       AND diag.diaghistno = (select max(diagh.diaghistno)                                          from emr.mmohdiag diagh                                         where diagh.pid = a.pid                                               AND diagh.orddd = a.orddd                                               AND diagh.cretno = a.cretno                                               AND diagh.instcd = '111'                                               AND diagh.diaghistcd = 'O'                                                              AND diagh.diagkindcdflag = 'M'                                                              AND diagh.genrflagcd = a.ordtype                                               and diagh.orddeptcd = a.orddeptcd                                         group by pid)) as IO_DxNm,               COM.FN_ZS_GETUSERNM(a.orddrid, a.orddd) as IO_MaindrNm,               '111' as IO_HosType,               case when ex.bp is null then null else ex.bp end as IO_bp,               case when ex.dm is null then null else ex.dm end as IO_dm,               case when ex.heart is null then null else ex.heart end as IO_heart,               case when ex.kidney is null then null else ex.kidney end as IO_kidney,               case when ex.respiration is null then null else ex.respiration end as IO_respiration,               case when ex.hx is null then null else ex.hx end as  IO_hx,               case when ex.allergy is null then null else ex.allergy end as  IO_allergy,               case when ex.drug is null then null else ex.drug end as  IO_drug,               case when ex.smoking is null then null else ex.smoking end as  IO_smoking,               case when ex.idio is null then null else ex.idio end as  IO_idio,               case when ex.nacrotics is null then null else ex.nacrotics end as  IO_nacrotics,               case when ex.airway is null then null else ex.airway end as  IO_airway,               case when ex.hemorrhage is null then null else ex.hemorrhage end as  IO_hemorrhage,               ex.etc IO_status_etc,               '111' as IO_OrderNo,               '111' as IO_PrintTime,               a.ORDDRID as IO_MaindrId,               '' as IO_ErdrNm,               COM.FN_ZS_GETUSERNM(a.ORDDRID, a.orddd) as IO_MaindrNm,               '111' as IO_OcrCd,               a.ORDDRID as IO_InputId,               COM.FN_ZS_GETUSERNM(a.ORDDRID, a.orddd) as IO_InputNm,               '111' as IO_SignImg          FROM pam.pmohotpt a            left outer join cmr.consent_data_ex ex              on (ex.pid = a.pid and ex.cln_date = a.orddd)            left outer join pam.pmcmptbs ptbs              on (ptbs.pid = a.pid and ptbs.instcd = a.instcd)          WHERE a.instcd =  :param0               AND a.pid =  :param1               AND a.orddd =  :param2               AND A.HISTSTAT IN ('R', 'T')              AND A.MSKIND = 'M'                          AND a.cretno =  :param3                     AND a.orddeptcd =  :param4]

[Logging Date Time: 2016-11-25 17:55:45,093] =====================================================================================
SQL Command - Statement Id: [getPatientInfoOut] Parameters: [param0=[instcd,111], param1=[pid,0656166], param2=[orddd,20161125], param3=[cretno,1], param4=[orddeptcd,2010400000]]

[Logging Date Time: 2016-11-25 17:55:45,093] =====================================================================================
SQL Command - Statement Id: [getPatientInfoOut] Parameters: [param0=[instcd,111], param1=[pid,0656166], param2=[orddd,20161125], param3=[cretno,1], param4=[orddeptcd,2010400000]]

[Logging Date Time: 2016-11-25 17:55:45,093] =====================================================================================
SQL Command - Statement Id: [getPatientInfoOut] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:55:45,093] =====================================================================================
SQL Command - Statement Id: [getPatientInfoOut] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:55:49,506] =====================================================================================
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-25 17:55:49,506] =====================================================================================
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-25 17:55:49,507] =====================================================================================
SQL Command - Statement Id: [GET_SEQUENCE] Parameters: [param0=[sub_cd,CONSENT_MST]]

[Logging Date Time: 2016-11-25 17:55:49,507] =====================================================================================
SQL Command - Statement Id: [GET_SEQUENCE] Parameters: [param0=[sub_cd,CONSENT_MST]]

[Logging Date Time: 2016-11-25 17:55:49,507] =====================================================================================
SQL Command - Statement Id: [GET_SEQUENCE] Types: [param0=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:55:49,507] =====================================================================================
SQL Command - Statement Id: [GET_SEQUENCE] Types: [param0=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:55:49,510] =====================================================================================
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-25 17:55:49,510] =====================================================================================
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-25 17:55:49,511] =====================================================================================
SQL Command - Statement Id: [UPDATE_SEQUENCE] Parameters: [param0=[ud1_num,2372], param1=[sub_cd,CONSENT_MST]]

[Logging Date Time: 2016-11-25 17:55:49,511] =====================================================================================
SQL Command - Statement Id: [UPDATE_SEQUENCE] Parameters: [param0=[ud1_num,2372], param1=[sub_cd,CONSENT_MST]]

[Logging Date Time: 2016-11-25 17:55:49,511] =====================================================================================
SQL Command - Statement Id: [UPDATE_SEQUENCE] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:55:49,511] =====================================================================================
SQL Command - Statement Id: [UPDATE_SEQUENCE] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:55:49,513] =====================================================================================
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-25 17:55:49,513] =====================================================================================
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-25 17:55:49,513] =====================================================================================
SQL Command - Statement Id: [GET_SEQUENCE] Parameters: [param0=[sub_cd,CONSENT_DATA]]

[Logging Date Time: 2016-11-25 17:55:49,513] =====================================================================================
SQL Command - Statement Id: [GET_SEQUENCE] Parameters: [param0=[sub_cd,CONSENT_DATA]]

[Logging Date Time: 2016-11-25 17:55:49,513] =====================================================================================
SQL Command - Statement Id: [GET_SEQUENCE] Types: [param0=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:55:49,513] =====================================================================================
SQL Command - Statement Id: [GET_SEQUENCE] Types: [param0=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:55:49,515] =====================================================================================
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-25 17:55:49,515] =====================================================================================
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-25 17:55:49,516] =====================================================================================
SQL Command - Statement Id: [UPDATE_SEQUENCE] Parameters: [param0=[ud1_num,2261], param1=[sub_cd,CONSENT_DATA]]

[Logging Date Time: 2016-11-25 17:55:49,516] =====================================================================================
SQL Command - Statement Id: [UPDATE_SEQUENCE] Parameters: [param0=[ud1_num,2261], param1=[sub_cd,CONSENT_DATA]]

[Logging Date Time: 2016-11-25 17:55:49,516] =====================================================================================
SQL Command - Statement Id: [UPDATE_SEQUENCE] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:55:49,516] =====================================================================================
SQL Command - Statement Id: [UPDATE_SEQUENCE] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:55:49,517] =====================================================================================
SQL Command - Statement Id: [INSERT_CONSENT_MST] PreparedStatement : [insert into CONSENT_MST          (            CONSENT_MST_RID,            HOS_TYPE,             PID,            VISIT_TYPE,            OCR_NUMBER,            CLN_DEPT_CD,            CLN_DATE,            CRETNO,            WARDCD,            ROOMCD,            FORM_RID,            CONSENT_STATE,            COMPLETE_YN,            COMPLETE_DATETIME,            PAPER_YN,            REISSUE_YN,            REISSUE_CONSENT_MST_RID,            REWRITE_YN,            REWRITE_CONSENT_MST_RID,            USE_YN,            MAIN_DR_ID,            CREATE_USER_ID,            CREATE_DATETIME,            MODIFY_USER_ID,            MODIFY_DATETIME,            CREATE_USER_NAME,            MODIFY_USER_NAME          )          values          (             :param0 ,             :param1 ,             :param2 ,             :param3 ,             :param4 ,             :param5 ,             :param6 ,             :param7 ,             :param8 ,             :param9 ,             :param10 ,             :param11 ,             :param12 ,            '',             :param13 ,             :param14 ,             :param15 ,             :param16 ,             :param17 ,            'Y',             :param18 ,             :param19 ,            TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'),             :param19 ,            TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'),             :param20 ,             :param21           )]

[Logging Date Time: 2016-11-25 17:55:49,517] =====================================================================================
SQL Command - Statement Id: [INSERT_CONSENT_MST] PreparedStatement : [insert into CONSENT_MST          (            CONSENT_MST_RID,            HOS_TYPE,             PID,            VISIT_TYPE,            OCR_NUMBER,            CLN_DEPT_CD,            CLN_DATE,            CRETNO,            WARDCD,            ROOMCD,            FORM_RID,            CONSENT_STATE,            COMPLETE_YN,            COMPLETE_DATETIME,            PAPER_YN,            REISSUE_YN,            REISSUE_CONSENT_MST_RID,            REWRITE_YN,            REWRITE_CONSENT_MST_RID,            USE_YN,            MAIN_DR_ID,            CREATE_USER_ID,            CREATE_DATETIME,            MODIFY_USER_ID,            MODIFY_DATETIME,            CREATE_USER_NAME,            MODIFY_USER_NAME          )          values          (             :param0 ,             :param1 ,             :param2 ,             :param3 ,             :param4 ,             :param5 ,             :param6 ,             :param7 ,             :param8 ,             :param9 ,             :param10 ,             :param11 ,             :param12 ,            '',             :param13 ,             :param14 ,             :param15 ,             :param16 ,             :param17 ,            'Y',             :param18 ,             :param19 ,            TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'),             :param19 ,            TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'),             :param20 ,             :param21           )]

[Logging Date Time: 2016-11-25 17:55:49,518] =====================================================================================
SQL Command - Statement Id: [INSERT_CONSENT_MST] Parameters: [param0=[consentMstRid,2372], param1=[hosType,111], param2=[patientCode,0656166], param3=[vistType,O], param4=[ocrCode,2016112564625], param5=[clnDeptCd,2010400000], param6=[clnDate,20161125], param7=[cretno,1], param8=[ward,null], param9=[roomcd,null], param10=[formRid,1062], param11=[consentState,PAPER_OUT], param12=[completeYn,N], param13=[paperYn,Y], param14=[reissueYn,N], param15=[reissueConsentMstRid,0], param16=[rewriteYn,N], param17=[rewriteConsentMstRid,0], param18=[mainDrId,107945], param19=[userId,107945], param20=[createUserName,±èÀçÈñ], param21=[modifyUserName,±èÀçÈñ]]

[Logging Date Time: 2016-11-25 17:55:49,518] =====================================================================================
SQL Command - Statement Id: [INSERT_CONSENT_MST] Parameters: [param0=[consentMstRid,2372], param1=[hosType,111], param2=[patientCode,0656166], param3=[vistType,O], param4=[ocrCode,2016112564625], param5=[clnDeptCd,2010400000], param6=[clnDate,20161125], param7=[cretno,1], param8=[ward,null], param9=[roomcd,null], param10=[formRid,1062], param11=[consentState,PAPER_OUT], param12=[completeYn,N], param13=[paperYn,Y], param14=[reissueYn,N], param15=[reissueConsentMstRid,0], param16=[rewriteYn,N], param17=[rewriteConsentMstRid,0], param18=[mainDrId,107945], param19=[userId,107945], param20=[createUserName,±èÀçÈñ], param21=[modifyUserName,±èÀçÈñ]]

[Logging Date Time: 2016-11-25 17:55:49,518] =====================================================================================
SQL Command - Statement Id: [INSERT_CONSENT_MST] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String], param5=[AnsiString, System.String], param6=[AnsiString, System.String], param7=[Int32, System.Int32], param8=[System.DBNull, null], param9=[System.DBNull, null], param10=[Int32, System.Int32], param11=[AnsiString, System.String], param12=[AnsiString, System.String], param13=[AnsiString, System.String], param14=[AnsiString, System.String], param15=[Int32, System.Int32], param16=[AnsiString, System.String], param17=[Int32, System.Int32], param18=[AnsiString, System.String], param19=[AnsiString, System.String], param20=[AnsiString, System.String], param21=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:55:49,518] =====================================================================================
SQL Command - Statement Id: [INSERT_CONSENT_MST] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String], param5=[AnsiString, System.String], param6=[AnsiString, System.String], param7=[Int32, System.Int32], param8=[System.DBNull, null], param9=[System.DBNull, null], param10=[Int32, System.Int32], param11=[AnsiString, System.String], param12=[AnsiString, System.String], param13=[AnsiString, System.String], param14=[AnsiString, System.String], param15=[Int32, System.Int32], param16=[AnsiString, System.String], param17=[Int32, System.Int32], param18=[AnsiString, System.String], param19=[AnsiString, System.String], param20=[AnsiString, System.String], param21=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:56:09,721] =====================================================================================
SQL Command - Statement Id: [getPatientInfoOut] PreparedStatement : [SELECT a.orddeptcd,               a.pid as IO_Pt_ID,               to_char(a.cretno) as IO_CretNo,               ( ptbs.sex || '/' ||                       com.fn_zz_getageas(ptbs.rrgstno1,                                          ptbs.rrgstno2,                                          TO_CHAR(SYSDATE, 'YYYYMMDD'),                                          'A',                                          ptbs.brthdd)) as IO_sex_age_y_m,               ptbs.hngnm as IO_Pt_Name,               (ptbs.rrgstno1 || '-' || substr(ptbs.rrgstno2, 1, 1) ||'******') IO_JuminNo,           ptbs.zipcdaddr as IO_Zipcdaddr,               ptbs.mpphontel as IO_Tel,           (select cdnm from com.zbcmcode where cdgrupid='P0008' and cdid =a.insukind) as IO_Insukind,               '' as IO_Ward,               '' as IO_roomNO,               a.orddd as IO_ADdate,               a.orddd as IO_Dschdd,               a.ordtype as IO_VisitType,               a.orddeptcd as IO_DeptCd,               (select dept.deptengabbr                  from com.zsdddept dept                 where dept.deptcd = a.orddeptcd                       and dept.instcd = a.instcd                       and dept.valitodd >= a.orddd                       and dept.valifromdd <= a.orddd) as IO_DeptNm,               COM.FN_ZS_GETDEPTNAME(a.instcd, a.orddeptcd, a.orddd) AS IO_Dept2,               '' AS IO_OPdeptCd,               '' AS IO_OPdeptNm,               '' AS IO_OPdrNm,               '' AS IO_OPdrId,               (SELECT diag.diagcd                  FROM emr.mmohdiag diag                 WHERE diag.pid = a.pid                       AND diag.orddd = a.orddd                       AND diag.cretno = a.cretno                       AND diag.diaghistcd = 'O'                       AND diag.diagtypecd = 'D'                       AND diag.diagkindcdflag = 'M'                       AND diag.genrflagcd = a.ordtype                       and diag.orddeptcd = a.orddeptcd                       AND diag.diaghistno = (select max(diagh.diaghistno)                                          from emr.mmohdiag diagh                                         where diagh.pid = a.pid                                               AND diagh.orddd = a.orddd                                               AND diagh.cretno = a.cretno                                               AND diagh.instcd = '111'                                               AND diagh.diaghistcd = 'O'                                                              AND diagh.diagkindcdflag = 'M'                                                              AND diagh.genrflagcd = a.ordtype                                               and diagh.orddeptcd = a.orddeptcd                                         group by pid)) as IO_DxCd,               (SELECT term.diaghngnm                  FROM emr.mmohdiag diag,                       emr.mmbvdiag term                 WHERE diag.pid = a.pid                       AND diag.orddd = a.orddd                       AND diag.cretno = a.cretno                       AND diag.instcd = term.instcd                       AND diag.diagcd = term.orgdiagcd                       AND diag.diaghistcd = 'O'                       AND diag.diagtypecd = 'D'                       AND diag.diagkindcdflag = 'M'                       AND diag.diagdd >= term.termfromdd                       AND diag.diagdd <= term.termtodd                       AND diag.diagdd >= term.diagattrfromdd                       AND diag.diagdd <= term.diagattrtodd                       AND diag.genrflagcd = a.ordtype                       and diag.orddeptcd = a.orddeptcd                       AND diag.diaghistno = (select max(diagh.diaghistno)                                          from emr.mmohdiag diagh                                         where diagh.pid = a.pid                                               AND diagh.orddd = a.orddd                                               AND diagh.cretno = a.cretno                                               AND diagh.instcd = '111'                                               AND diagh.diaghistcd = 'O'                                                              AND diagh.diagkindcdflag = 'M'                                                              AND diagh.genrflagcd = a.ordtype                                               and diagh.orddeptcd = a.orddeptcd                                         group by pid)) as IO_DxNm,               COM.FN_ZS_GETUSERNM(a.orddrid, a.orddd) as IO_MaindrNm,               '111' as IO_HosType,               case when ex.bp is null then null else ex.bp end as IO_bp,               case when ex.dm is null then null else ex.dm end as IO_dm,               case when ex.heart is null then null else ex.heart end as IO_heart,               case when ex.kidney is null then null else ex.kidney end as IO_kidney,               case when ex.respiration is null then null else ex.respiration end as IO_respiration,               case when ex.hx is null then null else ex.hx end as  IO_hx,               case when ex.allergy is null then null else ex.allergy end as  IO_allergy,               case when ex.drug is null then null else ex.drug end as  IO_drug,               case when ex.smoking is null then null else ex.smoking end as  IO_smoking,               case when ex.idio is null then null else ex.idio end as  IO_idio,               case when ex.nacrotics is null then null else ex.nacrotics end as  IO_nacrotics,               case when ex.airway is null then null else ex.airway end as  IO_airway,               case when ex.hemorrhage is null then null else ex.hemorrhage end as  IO_hemorrhage,               ex.etc IO_status_etc,               '111' as IO_OrderNo,               '111' as IO_PrintTime,               a.ORDDRID as IO_MaindrId,               '' as IO_ErdrNm,               COM.FN_ZS_GETUSERNM(a.ORDDRID, a.orddd) as IO_MaindrNm,               '111' as IO_OcrCd,               a.ORDDRID as IO_InputId,               COM.FN_ZS_GETUSERNM(a.ORDDRID, a.orddd) as IO_InputNm,               '111' as IO_SignImg          FROM pam.pmohotpt a            left outer join cmr.consent_data_ex ex              on (ex.pid = a.pid and ex.cln_date = a.orddd)            left outer join pam.pmcmptbs ptbs              on (ptbs.pid = a.pid and ptbs.instcd = a.instcd)          WHERE a.instcd =  :param0               AND a.pid =  :param1               AND a.orddd =  :param2               AND A.HISTSTAT IN ('R', 'T')              AND A.MSKIND = 'M'                          AND a.cretno =  :param3                     AND a.orddeptcd =  :param4]

[Logging Date Time: 2016-11-25 17:56:09,721] =====================================================================================
SQL Command - Statement Id: [getPatientInfoOut] PreparedStatement : [SELECT a.orddeptcd,               a.pid as IO_Pt_ID,               to_char(a.cretno) as IO_CretNo,               ( ptbs.sex || '/' ||                       com.fn_zz_getageas(ptbs.rrgstno1,                                          ptbs.rrgstno2,                                          TO_CHAR(SYSDATE, 'YYYYMMDD'),                                          'A',                                          ptbs.brthdd)) as IO_sex_age_y_m,               ptbs.hngnm as IO_Pt_Name,               (ptbs.rrgstno1 || '-' || substr(ptbs.rrgstno2, 1, 1) ||'******') IO_JuminNo,           ptbs.zipcdaddr as IO_Zipcdaddr,               ptbs.mpphontel as IO_Tel,           (select cdnm from com.zbcmcode where cdgrupid='P0008' and cdid =a.insukind) as IO_Insukind,               '' as IO_Ward,               '' as IO_roomNO,               a.orddd as IO_ADdate,               a.orddd as IO_Dschdd,               a.ordtype as IO_VisitType,               a.orddeptcd as IO_DeptCd,               (select dept.deptengabbr                  from com.zsdddept dept                 where dept.deptcd = a.orddeptcd                       and dept.instcd = a.instcd                       and dept.valitodd >= a.orddd                       and dept.valifromdd <= a.orddd) as IO_DeptNm,               COM.FN_ZS_GETDEPTNAME(a.instcd, a.orddeptcd, a.orddd) AS IO_Dept2,               '' AS IO_OPdeptCd,               '' AS IO_OPdeptNm,               '' AS IO_OPdrNm,               '' AS IO_OPdrId,               (SELECT diag.diagcd                  FROM emr.mmohdiag diag                 WHERE diag.pid = a.pid                       AND diag.orddd = a.orddd                       AND diag.cretno = a.cretno                       AND diag.diaghistcd = 'O'                       AND diag.diagtypecd = 'D'                       AND diag.diagkindcdflag = 'M'                       AND diag.genrflagcd = a.ordtype                       and diag.orddeptcd = a.orddeptcd                       AND diag.diaghistno = (select max(diagh.diaghistno)                                          from emr.mmohdiag diagh                                         where diagh.pid = a.pid                                               AND diagh.orddd = a.orddd                                               AND diagh.cretno = a.cretno                                               AND diagh.instcd = '111'                                               AND diagh.diaghistcd = 'O'                                                              AND diagh.diagkindcdflag = 'M'                                                              AND diagh.genrflagcd = a.ordtype                                               and diagh.orddeptcd = a.orddeptcd                                         group by pid)) as IO_DxCd,               (SELECT term.diaghngnm                  FROM emr.mmohdiag diag,                       emr.mmbvdiag term                 WHERE diag.pid = a.pid                       AND diag.orddd = a.orddd                       AND diag.cretno = a.cretno                       AND diag.instcd = term.instcd                       AND diag.diagcd = term.orgdiagcd                       AND diag.diaghistcd = 'O'                       AND diag.diagtypecd = 'D'                       AND diag.diagkindcdflag = 'M'                       AND diag.diagdd >= term.termfromdd                       AND diag.diagdd <= term.termtodd                       AND diag.diagdd >= term.diagattrfromdd                       AND diag.diagdd <= term.diagattrtodd                       AND diag.genrflagcd = a.ordtype                       and diag.orddeptcd = a.orddeptcd                       AND diag.diaghistno = (select max(diagh.diaghistno)                                          from emr.mmohdiag diagh                                         where diagh.pid = a.pid                                               AND diagh.orddd = a.orddd                                               AND diagh.cretno = a.cretno                                               AND diagh.instcd = '111'                                               AND diagh.diaghistcd = 'O'                                                              AND diagh.diagkindcdflag = 'M'                                                              AND diagh.genrflagcd = a.ordtype                                               and diagh.orddeptcd = a.orddeptcd                                         group by pid)) as IO_DxNm,               COM.FN_ZS_GETUSERNM(a.orddrid, a.orddd) as IO_MaindrNm,               '111' as IO_HosType,               case when ex.bp is null then null else ex.bp end as IO_bp,               case when ex.dm is null then null else ex.dm end as IO_dm,               case when ex.heart is null then null else ex.heart end as IO_heart,               case when ex.kidney is null then null else ex.kidney end as IO_kidney,               case when ex.respiration is null then null else ex.respiration end as IO_respiration,               case when ex.hx is null then null else ex.hx end as  IO_hx,               case when ex.allergy is null then null else ex.allergy end as  IO_allergy,               case when ex.drug is null then null else ex.drug end as  IO_drug,               case when ex.smoking is null then null else ex.smoking end as  IO_smoking,               case when ex.idio is null then null else ex.idio end as  IO_idio,               case when ex.nacrotics is null then null else ex.nacrotics end as  IO_nacrotics,               case when ex.airway is null then null else ex.airway end as  IO_airway,               case when ex.hemorrhage is null then null else ex.hemorrhage end as  IO_hemorrhage,               ex.etc IO_status_etc,               '111' as IO_OrderNo,               '111' as IO_PrintTime,               a.ORDDRID as IO_MaindrId,               '' as IO_ErdrNm,               COM.FN_ZS_GETUSERNM(a.ORDDRID, a.orddd) as IO_MaindrNm,               '111' as IO_OcrCd,               a.ORDDRID as IO_InputId,               COM.FN_ZS_GETUSERNM(a.ORDDRID, a.orddd) as IO_InputNm,               '111' as IO_SignImg          FROM pam.pmohotpt a            left outer join cmr.consent_data_ex ex              on (ex.pid = a.pid and ex.cln_date = a.orddd)            left outer join pam.pmcmptbs ptbs              on (ptbs.pid = a.pid and ptbs.instcd = a.instcd)          WHERE a.instcd =  :param0               AND a.pid =  :param1               AND a.orddd =  :param2               AND A.HISTSTAT IN ('R', 'T')              AND A.MSKIND = 'M'                          AND a.cretno =  :param3                     AND a.orddeptcd =  :param4]

[Logging Date Time: 2016-11-25 17:56:09,722] =====================================================================================
SQL Command - Statement Id: [getPatientInfoOut] Parameters: [param0=[instcd,111], param1=[pid,1113706], param2=[orddd,20161125], param3=[cretno,1], param4=[orddeptcd,2010400000]]

[Logging Date Time: 2016-11-25 17:56:09,722] =====================================================================================
SQL Command - Statement Id: [getPatientInfoOut] Parameters: [param0=[instcd,111], param1=[pid,1113706], param2=[orddd,20161125], param3=[cretno,1], param4=[orddeptcd,2010400000]]

[Logging Date Time: 2016-11-25 17:56:09,722] =====================================================================================
SQL Command - Statement Id: [getPatientInfoOut] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:56:09,722] =====================================================================================
SQL Command - Statement Id: [getPatientInfoOut] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:56:13,936] =====================================================================================
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-25 17:56:13,936] =====================================================================================
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-25 17:56:13,938] =====================================================================================
SQL Command - Statement Id: [GET_SEQUENCE] Parameters: [param0=[sub_cd,CONSENT_MST]]

[Logging Date Time: 2016-11-25 17:56:13,938] =====================================================================================
SQL Command - Statement Id: [GET_SEQUENCE] Parameters: [param0=[sub_cd,CONSENT_MST]]

[Logging Date Time: 2016-11-25 17:56:13,938] =====================================================================================
SQL Command - Statement Id: [GET_SEQUENCE] Types: [param0=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:56:13,938] =====================================================================================
SQL Command - Statement Id: [GET_SEQUENCE] Types: [param0=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:56:13,941] =====================================================================================
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-25 17:56:13,941] =====================================================================================
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-25 17:56:13,942] =====================================================================================
SQL Command - Statement Id: [UPDATE_SEQUENCE] Parameters: [param0=[ud1_num,2373], param1=[sub_cd,CONSENT_MST]]

[Logging Date Time: 2016-11-25 17:56:13,942] =====================================================================================
SQL Command - Statement Id: [UPDATE_SEQUENCE] Parameters: [param0=[ud1_num,2373], param1=[sub_cd,CONSENT_MST]]

[Logging Date Time: 2016-11-25 17:56:13,942] =====================================================================================
SQL Command - Statement Id: [UPDATE_SEQUENCE] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:56:13,942] =====================================================================================
SQL Command - Statement Id: [UPDATE_SEQUENCE] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:56:13,945] =====================================================================================
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-25 17:56:13,945] =====================================================================================
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-25 17:56:13,945] =====================================================================================
SQL Command - Statement Id: [GET_SEQUENCE] Parameters: [param0=[sub_cd,CONSENT_DATA]]

[Logging Date Time: 2016-11-25 17:56:13,945] =====================================================================================
SQL Command - Statement Id: [GET_SEQUENCE] Parameters: [param0=[sub_cd,CONSENT_DATA]]

[Logging Date Time: 2016-11-25 17:56:13,945] =====================================================================================
SQL Command - Statement Id: [GET_SEQUENCE] Types: [param0=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:56:13,945] =====================================================================================
SQL Command - Statement Id: [GET_SEQUENCE] Types: [param0=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:56:13,956] =====================================================================================
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-25 17:56:13,956] =====================================================================================
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-25 17:56:13,956] =====================================================================================
SQL Command - Statement Id: [UPDATE_SEQUENCE] Parameters: [param0=[ud1_num,2262], param1=[sub_cd,CONSENT_DATA]]

[Logging Date Time: 2016-11-25 17:56:13,956] =====================================================================================
SQL Command - Statement Id: [UPDATE_SEQUENCE] Parameters: [param0=[ud1_num,2262], param1=[sub_cd,CONSENT_DATA]]

[Logging Date Time: 2016-11-25 17:56:13,956] =====================================================================================
SQL Command - Statement Id: [UPDATE_SEQUENCE] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:56:13,956] =====================================================================================
SQL Command - Statement Id: [UPDATE_SEQUENCE] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:56:13,960] =====================================================================================
SQL Command - Statement Id: [INSERT_CONSENT_MST] PreparedStatement : [insert into CONSENT_MST          (            CONSENT_MST_RID,            HOS_TYPE,             PID,            VISIT_TYPE,            OCR_NUMBER,            CLN_DEPT_CD,            CLN_DATE,            CRETNO,            WARDCD,            ROOMCD,            FORM_RID,            CONSENT_STATE,            COMPLETE_YN,            COMPLETE_DATETIME,            PAPER_YN,            REISSUE_YN,            REISSUE_CONSENT_MST_RID,            REWRITE_YN,            REWRITE_CONSENT_MST_RID,            USE_YN,            MAIN_DR_ID,            CREATE_USER_ID,            CREATE_DATETIME,            MODIFY_USER_ID,            MODIFY_DATETIME,            CREATE_USER_NAME,            MODIFY_USER_NAME          )          values          (             :param0 ,             :param1 ,             :param2 ,             :param3 ,             :param4 ,             :param5 ,             :param6 ,             :param7 ,             :param8 ,             :param9 ,             :param10 ,             :param11 ,             :param12 ,            '',             :param13 ,             :param14 ,             :param15 ,             :param16 ,             :param17 ,            'Y',             :param18 ,             :param19 ,            TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'),             :param19 ,            TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'),             :param20 ,             :param21           )]

[Logging Date Time: 2016-11-25 17:56:13,960] =====================================================================================
SQL Command - Statement Id: [INSERT_CONSENT_MST] PreparedStatement : [insert into CONSENT_MST          (            CONSENT_MST_RID,            HOS_TYPE,             PID,            VISIT_TYPE,            OCR_NUMBER,            CLN_DEPT_CD,            CLN_DATE,            CRETNO,            WARDCD,            ROOMCD,            FORM_RID,            CONSENT_STATE,            COMPLETE_YN,            COMPLETE_DATETIME,            PAPER_YN,            REISSUE_YN,            REISSUE_CONSENT_MST_RID,            REWRITE_YN,            REWRITE_CONSENT_MST_RID,            USE_YN,            MAIN_DR_ID,            CREATE_USER_ID,            CREATE_DATETIME,            MODIFY_USER_ID,            MODIFY_DATETIME,            CREATE_USER_NAME,            MODIFY_USER_NAME          )          values          (             :param0 ,             :param1 ,             :param2 ,             :param3 ,             :param4 ,             :param5 ,             :param6 ,             :param7 ,             :param8 ,             :param9 ,             :param10 ,             :param11 ,             :param12 ,            '',             :param13 ,             :param14 ,             :param15 ,             :param16 ,             :param17 ,            'Y',             :param18 ,             :param19 ,            TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'),             :param19 ,            TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'),             :param20 ,             :param21           )]

[Logging Date Time: 2016-11-25 17:56:13,960] =====================================================================================
SQL Command - Statement Id: [INSERT_CONSENT_MST] Parameters: [param0=[consentMstRid,2373], param1=[hosType,111], param2=[patientCode,1113706], param3=[vistType,O], param4=[ocrCode,2016112564626], param5=[clnDeptCd,2010400000], param6=[clnDate,20161125], param7=[cretno,1], param8=[ward,null], param9=[roomcd,null], param10=[formRid,1062], param11=[consentState,PAPER_OUT], param12=[completeYn,N], param13=[paperYn,Y], param14=[reissueYn,N], param15=[reissueConsentMstRid,0], param16=[rewriteYn,N], param17=[rewriteConsentMstRid,0], param18=[mainDrId,107945], param19=[userId,107945], param20=[createUserName,±èÀçÈñ], param21=[modifyUserName,±èÀçÈñ]]

[Logging Date Time: 2016-11-25 17:56:13,960] =====================================================================================
SQL Command - Statement Id: [INSERT_CONSENT_MST] Parameters: [param0=[consentMstRid,2373], param1=[hosType,111], param2=[patientCode,1113706], param3=[vistType,O], param4=[ocrCode,2016112564626], param5=[clnDeptCd,2010400000], param6=[clnDate,20161125], param7=[cretno,1], param8=[ward,null], param9=[roomcd,null], param10=[formRid,1062], param11=[consentState,PAPER_OUT], param12=[completeYn,N], param13=[paperYn,Y], param14=[reissueYn,N], param15=[reissueConsentMstRid,0], param16=[rewriteYn,N], param17=[rewriteConsentMstRid,0], param18=[mainDrId,107945], param19=[userId,107945], param20=[createUserName,±èÀçÈñ], param21=[modifyUserName,±èÀçÈñ]]

[Logging Date Time: 2016-11-25 17:56:13,961] =====================================================================================
SQL Command - Statement Id: [INSERT_CONSENT_MST] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String], param5=[AnsiString, System.String], param6=[AnsiString, System.String], param7=[Int32, System.Int32], param8=[System.DBNull, null], param9=[System.DBNull, null], param10=[Int32, System.Int32], param11=[AnsiString, System.String], param12=[AnsiString, System.String], param13=[AnsiString, System.String], param14=[AnsiString, System.String], param15=[Int32, System.Int32], param16=[AnsiString, System.String], param17=[Int32, System.Int32], param18=[AnsiString, System.String], param19=[AnsiString, System.String], param20=[AnsiString, System.String], param21=[AnsiString, System.String]]

[Logging Date Time: 2016-11-25 17:56:13,961] =====================================================================================
SQL Command - Statement Id: [INSERT_CONSENT_MST] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String], param5=[AnsiString, System.String], param6=[AnsiString, System.String], param7=[Int32, System.Int32], param8=[System.DBNull, null], param9=[System.DBNull, null], param10=[Int32, System.Int32], param11=[AnsiString, System.String], param12=[AnsiString, System.String], param13=[AnsiString, System.String], param14=[AnsiString, System.String], param15=[Int32, System.Int32], param16=[AnsiString, System.String], param17=[Int32, System.Int32], param18=[AnsiString, System.String], param19=[AnsiString, System.String], param20=[AnsiString, System.String], param21=[AnsiString, System.String]]