fatimaConsentApi/CLIP.e-Form.Consent.Dfh.Web/Logs/eFormServer.iBATIS.log_2016-10-19

[Logging Date Time: 2016-10-19 08:42:01,153] =====================================================================================
SQL Command - Statement Id: [GetUnfinishedListPerDoctor] PreparedStatement : [select pid,               (select ptbs.hngnm                  from pam.pmcmptbs ptbs                 where ptbs.pid = a.pid                       and ptbs.instcd = '111') as hngnm,               (select v.FORM_CD                  from cmr.v_eform_formdoc v                 where v.FORM_RID = a.form_rid) as formcd,               (select v.FORM_NAME                  from cmr.v_eform_formdoc v                 where v.FORM_RID = a.form_rid) as formnm,               (select v.PRINT_ONLY                  from cmr.v_eform_formdoc v                 where v.FORM_RID = a.form_rid) as printonly,               a.order_date as orderdate          from cmr.consent_mst a         where a.cosign_dc_id =  :param0                and a.consent_state in ( :param1 , :param2 , :param3 , :param4 , :param5 , :param6 )]

[Logging Date Time: 2016-10-19 08:42:01,153] =====================================================================================
SQL Command - Statement Id: [GetUnfinishedListPerDoctor] PreparedStatement : [select pid,               (select ptbs.hngnm                  from pam.pmcmptbs ptbs                 where ptbs.pid = a.pid                       and ptbs.instcd = '111') as hngnm,               (select v.FORM_CD                  from cmr.v_eform_formdoc v                 where v.FORM_RID = a.form_rid) as formcd,               (select v.FORM_NAME                  from cmr.v_eform_formdoc v                 where v.FORM_RID = a.form_rid) as formnm,               (select v.PRINT_ONLY                  from cmr.v_eform_formdoc v                 where v.FORM_RID = a.form_rid) as printonly,               a.order_date as orderdate          from cmr.consent_mst a         where a.cosign_dc_id =  :param0                and a.consent_state in ( :param1 , :param2 , :param3 , :param4 , :param5 , :param6 )]

[Logging Date Time: 2016-10-19 08:42:01,262] =====================================================================================
SQL Command - Statement Id: [GetUnfinishedListPerDoctor] Parameters: [param0=[userid,104796], param1=[unfinish,UNFINISHED], param2=[temp,TEMP], param3=[verbal,], param4=[paper,], param5=[electr,], param6=[certify,]]

[Logging Date Time: 2016-10-19 08:42:01,262] =====================================================================================
SQL Command - Statement Id: [GetUnfinishedListPerDoctor] Parameters: [param0=[userid,104796], param1=[unfinish,UNFINISHED], param2=[temp,TEMP], param3=[verbal,], param4=[paper,], param5=[electr,], param6=[certify,]]

[Logging Date Time: 2016-10-19 08:42:01,263] =====================================================================================
SQL Command - Statement Id: [GetUnfinishedListPerDoctor] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String], param5=[AnsiString, System.String], param6=[AnsiString, System.String]]

[Logging Date Time: 2016-10-19 08:42:01,263] =====================================================================================
SQL Command - Statement Id: [GetUnfinishedListPerDoctor] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String], param5=[AnsiString, System.String], param6=[AnsiString, System.String]]

[Logging Date Time: 2016-10-19 08:46:56,094] =====================================================================================
SQL Command - Statement Id: [GET_CONSENT_LIST] PreparedStatement : [SELECT CM.CONSENT_MST_RID                , DECODE(CM.CONSENT_STATE, 'TEMP' ,'임시저장', 'ELECTR_CMP', '서명', 'PAPER_OUT', '출력' , 'CERTIFY_CMP', '인증', 'UNFINISHED', '미작성', 'VERBAL', '구두') AS CONSENT_STATE_DISP                , VEF.FORM_NAME AS CONSENT_NAME                , CM.HOS_TYPE                , CM.PID                , CM.VISIT_TYPE                , CM.ORDER_NO                , CM.ORDER_CD                , CM.ORDER_NAME                , CM.CLN_DEPT_CD                , (SELECT DEPTHNGNM FROM COM.ZSDDDEPT WHERE DEPTCD = CM.CLN_DEPT_CD and valitodd = '99991231' and instcd = '111') AS CLN_DEPT_NM                , COM.FN_ZS_GETDEPTNAME('111', CM.WARDCD,  :param0 ) as WARDCD                , CM.ROOMCD                , CM.FORM_RID                , VEF.FORM_CD                , VEF.FORM_GUID                , C.PRNTCNT                , CM.CONSENT_STATE                , CM.OCR_NUMBER                 , CM.COSIGN_DC_ID                , CM.COSIGN_DC_NAME                , CM.CREATE_USER_ID                , CM.CREATE_USER_NAME                , CM.CREATE_DATETIME                , CM.CLN_DATE                , CM.CRETNO            FROM  CONSENT_MST CM           INNER  JOIN EFORM_DOCUMENT VEF ON VEF.FORM_RID = CM.FORM_RID,                  EMR.MRFMFORM C           WHERE  CM.USE_YN = 'Y'              AND  CM.PID =  :param1                AND  TO_CHAR(TO_DATE(CM.CREATE_DATETIME, 'YYYY-MM-DD HH24:MI:SS'), 'YYYYMMDD') BETWEEN  :param2  and  :param0              AND  VEF.FORM_CD = C.FORMCD             AND  C.instcd = '111'             AND  C.formprogflag LIKE 'OCR%'             AND  C.formlevlcd != '-'             AND  SUBSTR (C.formtodt, 1, 8) = '99991231'                    AND vef.category_rid in (select cate.category_rid          from cmr.eform_category cate          where cate.p_category_rid = '147')                   ORDER  BY CM.CONSENT_STATE DESC, CM.CREATE_DATETIME DESC]

[Logging Date Time: 2016-10-19 08:46:56,094] =====================================================================================
SQL Command - Statement Id: [GET_CONSENT_LIST] PreparedStatement : [SELECT CM.CONSENT_MST_RID                , DECODE(CM.CONSENT_STATE, 'TEMP' ,'임시저장', 'ELECTR_CMP', '서명', 'PAPER_OUT', '출력' , 'CERTIFY_CMP', '인증', 'UNFINISHED', '미작성', 'VERBAL', '구두') AS CONSENT_STATE_DISP                , VEF.FORM_NAME AS CONSENT_NAME                , CM.HOS_TYPE                , CM.PID                , CM.VISIT_TYPE                , CM.ORDER_NO                , CM.ORDER_CD                , CM.ORDER_NAME                , CM.CLN_DEPT_CD                , (SELECT DEPTHNGNM FROM COM.ZSDDDEPT WHERE DEPTCD = CM.CLN_DEPT_CD and valitodd = '99991231' and instcd = '111') AS CLN_DEPT_NM                , COM.FN_ZS_GETDEPTNAME('111', CM.WARDCD,  :param0 ) as WARDCD                , CM.ROOMCD                , CM.FORM_RID                , VEF.FORM_CD                , VEF.FORM_GUID                , C.PRNTCNT                , CM.CONSENT_STATE                , CM.OCR_NUMBER                 , CM.COSIGN_DC_ID                , CM.COSIGN_DC_NAME                , CM.CREATE_USER_ID                , CM.CREATE_USER_NAME                , CM.CREATE_DATETIME                , CM.CLN_DATE                , CM.CRETNO            FROM  CONSENT_MST CM           INNER  JOIN EFORM_DOCUMENT VEF ON VEF.FORM_RID = CM.FORM_RID,                  EMR.MRFMFORM C           WHERE  CM.USE_YN = 'Y'              AND  CM.PID =  :param1                AND  TO_CHAR(TO_DATE(CM.CREATE_DATETIME, 'YYYY-MM-DD HH24:MI:SS'), 'YYYYMMDD') BETWEEN  :param2  and  :param0              AND  VEF.FORM_CD = C.FORMCD             AND  C.instcd = '111'             AND  C.formprogflag LIKE 'OCR%'             AND  C.formlevlcd != '-'             AND  SUBSTR (C.formtodt, 1, 8) = '99991231'                    AND vef.category_rid in (select cate.category_rid          from cmr.eform_category cate          where cate.p_category_rid = '147')                   ORDER  BY CM.CONSENT_STATE DESC, CM.CREATE_DATETIME DESC]

[Logging Date Time: 2016-10-19 08:46:56,171] =====================================================================================
SQL Command - Statement Id: [GET_CONSENT_LIST] Parameters: [param0=[endDt,20161017], param1=[patientCode,2059387], param2=[startDt,20161017]]

[Logging Date Time: 2016-10-19 08:46:56,171] =====================================================================================
SQL Command - Statement Id: [GET_CONSENT_LIST] Parameters: [param0=[endDt,20161017], param1=[patientCode,2059387], param2=[startDt,20161017]]

[Logging Date Time: 2016-10-19 08:46:56,171] =====================================================================================
SQL Command - Statement Id: [GET_CONSENT_LIST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]]

[Logging Date Time: 2016-10-19 08:46:56,171] =====================================================================================
SQL Command - Statement Id: [GET_CONSENT_LIST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]]

[Logging Date Time: 2016-10-19 09:09:24,960] =====================================================================================
SQL Command - Statement Id: [GET_CONSENT_LIST] PreparedStatement : [SELECT CM.CONSENT_MST_RID                , DECODE(CM.CONSENT_STATE, 'TEMP' ,'임시저장', 'ELECTR_CMP', '서명', 'PAPER_OUT', '출력' , 'CERTIFY_CMP', '인증', 'UNFINISHED', '미작성', 'VERBAL', '구두') AS CONSENT_STATE_DISP                , VEF.FORM_NAME AS CONSENT_NAME                , CM.HOS_TYPE                , CM.PID                , CM.VISIT_TYPE                , CM.ORDER_NO                , CM.ORDER_CD                , CM.ORDER_NAME                , CM.CLN_DEPT_CD                , (SELECT DEPTHNGNM FROM COM.ZSDDDEPT WHERE DEPTCD = CM.CLN_DEPT_CD and valitodd = '99991231' and instcd = '111') AS CLN_DEPT_NM                , COM.FN_ZS_GETDEPTNAME('111', CM.WARDCD,  :param0 ) as WARDCD                , CM.ROOMCD                , CM.FORM_RID                , VEF.FORM_CD                , VEF.FORM_GUID                , C.PRNTCNT                , CM.CONSENT_STATE                , CM.OCR_NUMBER                 , CM.COSIGN_DC_ID                , CM.COSIGN_DC_NAME                , CM.CREATE_USER_ID                , CM.CREATE_USER_NAME                , CM.CREATE_DATETIME                , CM.CLN_DATE                , CM.CRETNO            FROM  CONSENT_MST CM           INNER  JOIN EFORM_DOCUMENT VEF ON VEF.FORM_RID = CM.FORM_RID,                  EMR.MRFMFORM C           WHERE  CM.USE_YN = 'Y'              AND  CM.PID =  :param1                AND  TO_CHAR(TO_DATE(CM.CREATE_DATETIME, 'YYYY-MM-DD HH24:MI:SS'), 'YYYYMMDD') BETWEEN  :param2  and  :param0              AND  VEF.FORM_CD = C.FORMCD             AND  C.instcd = '111'             AND  C.formprogflag LIKE 'OCR%'             AND  C.formlevlcd != '-'             AND  SUBSTR (C.formtodt, 1, 8) = '99991231'                       AND  CM.CONSENT_STATE IN (UNFINISHED)                          AND vef.category_rid in (select cate.category_rid            from cmr.eform_category cate            where cate.p_category_rid = '147')                     ORDER  BY CM.CONSENT_STATE DESC, CM.CREATE_DATETIME DESC]

[Logging Date Time: 2016-10-19 09:09:24,960] =====================================================================================
SQL Command - Statement Id: [GET_CONSENT_LIST] PreparedStatement : [SELECT CM.CONSENT_MST_RID                , DECODE(CM.CONSENT_STATE, 'TEMP' ,'임시저장', 'ELECTR_CMP', '서명', 'PAPER_OUT', '출력' , 'CERTIFY_CMP', '인증', 'UNFINISHED', '미작성', 'VERBAL', '구두') AS CONSENT_STATE_DISP                , VEF.FORM_NAME AS CONSENT_NAME                , CM.HOS_TYPE                , CM.PID                , CM.VISIT_TYPE                , CM.ORDER_NO                , CM.ORDER_CD                , CM.ORDER_NAME                , CM.CLN_DEPT_CD                , (SELECT DEPTHNGNM FROM COM.ZSDDDEPT WHERE DEPTCD = CM.CLN_DEPT_CD and valitodd = '99991231' and instcd = '111') AS CLN_DEPT_NM                , COM.FN_ZS_GETDEPTNAME('111', CM.WARDCD,  :param0 ) as WARDCD                , CM.ROOMCD                , CM.FORM_RID                , VEF.FORM_CD                , VEF.FORM_GUID                , C.PRNTCNT                , CM.CONSENT_STATE                , CM.OCR_NUMBER                 , CM.COSIGN_DC_ID                , CM.COSIGN_DC_NAME                , CM.CREATE_USER_ID                , CM.CREATE_USER_NAME                , CM.CREATE_DATETIME                , CM.CLN_DATE                , CM.CRETNO            FROM  CONSENT_MST CM           INNER  JOIN EFORM_DOCUMENT VEF ON VEF.FORM_RID = CM.FORM_RID,                  EMR.MRFMFORM C           WHERE  CM.USE_YN = 'Y'              AND  CM.PID =  :param1                AND  TO_CHAR(TO_DATE(CM.CREATE_DATETIME, 'YYYY-MM-DD HH24:MI:SS'), 'YYYYMMDD') BETWEEN  :param2  and  :param0              AND  VEF.FORM_CD = C.FORMCD             AND  C.instcd = '111'             AND  C.formprogflag LIKE 'OCR%'             AND  C.formlevlcd != '-'             AND  SUBSTR (C.formtodt, 1, 8) = '99991231'                       AND  CM.CONSENT_STATE IN (UNFINISHED)                          AND vef.category_rid in (select cate.category_rid            from cmr.eform_category cate            where cate.p_category_rid = '147')                     ORDER  BY CM.CONSENT_STATE DESC, CM.CREATE_DATETIME DESC]

[Logging Date Time: 2016-10-19 09:09:25,026] =====================================================================================
SQL Command - Statement Id: [GET_CONSENT_LIST] Parameters: [param0=[endDt,20161019], param1=[patientCode,2213299], param2=[startDt,20161018]]

[Logging Date Time: 2016-10-19 09:09:25,026] =====================================================================================
SQL Command - Statement Id: [GET_CONSENT_LIST] Parameters: [param0=[endDt,20161019], param1=[patientCode,2213299], param2=[startDt,20161018]]

[Logging Date Time: 2016-10-19 09:09:25,026] =====================================================================================
SQL Command - Statement Id: [GET_CONSENT_LIST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]]

[Logging Date Time: 2016-10-19 09:09:25,026] =====================================================================================
SQL Command - Statement Id: [GET_CONSENT_LIST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]]

[Logging Date Time: 2016-10-19 09:10:53,527] =====================================================================================
SQL Command - Statement Id: [GET_CONSENT_LIST] PreparedStatement : [SELECT CM.CONSENT_MST_RID                , DECODE(CM.CONSENT_STATE, 'TEMP' ,'임시저장', 'ELECTR_CMP', '서명', 'PAPER_OUT', '출력' , 'CERTIFY_CMP', '인증', 'UNFINISHED', '미작성', 'VERBAL', '구두') AS CONSENT_STATE_DISP                , VEF.FORM_NAME AS CONSENT_NAME                , CM.HOS_TYPE                , CM.PID                , CM.VISIT_TYPE                , CM.ORDER_NO                , CM.ORDER_CD                , CM.ORDER_NAME                , CM.CLN_DEPT_CD                , (SELECT DEPTHNGNM FROM COM.ZSDDDEPT WHERE DEPTCD = CM.CLN_DEPT_CD and valitodd = '99991231' and instcd = '111') AS CLN_DEPT_NM                , COM.FN_ZS_GETDEPTNAME('111', CM.WARDCD,  :param0 ) as WARDCD                , CM.ROOMCD                , CM.FORM_RID                , VEF.FORM_CD                , VEF.FORM_GUID                , C.PRNTCNT                , CM.CONSENT_STATE                , CM.OCR_NUMBER                 , CM.COSIGN_DC_ID                , CM.COSIGN_DC_NAME                , CM.CREATE_USER_ID                , CM.CREATE_USER_NAME                , CM.CREATE_DATETIME                , CM.CLN_DATE                , CM.CRETNO            FROM  CONSENT_MST CM           INNER  JOIN EFORM_DOCUMENT VEF ON VEF.FORM_RID = CM.FORM_RID,                  EMR.MRFMFORM C           WHERE  CM.USE_YN = 'Y'              AND  CM.PID =  :param1                AND  TO_CHAR(TO_DATE(CM.CREATE_DATETIME, 'YYYY-MM-DD HH24:MI:SS'), 'YYYYMMDD') BETWEEN  :param2  and  :param0              AND  VEF.FORM_CD = C.FORMCD             AND  C.instcd = '111'             AND  C.formprogflag LIKE 'OCR%'             AND  C.formlevlcd != '-'             AND  SUBSTR (C.formtodt, 1, 8) = '99991231'                       AND  CM.CONSENT_STATE IN ('UNFINISHED')                      ORDER  BY CM.CONSENT_STATE DESC, CM.CREATE_DATETIME DESC]

[Logging Date Time: 2016-10-19 09:10:53,527] =====================================================================================
SQL Command - Statement Id: [GET_CONSENT_LIST] PreparedStatement : [SELECT CM.CONSENT_MST_RID                , DECODE(CM.CONSENT_STATE, 'TEMP' ,'임시저장', 'ELECTR_CMP', '서명', 'PAPER_OUT', '출력' , 'CERTIFY_CMP', '인증', 'UNFINISHED', '미작성', 'VERBAL', '구두') AS CONSENT_STATE_DISP                , VEF.FORM_NAME AS CONSENT_NAME                , CM.HOS_TYPE                , CM.PID                , CM.VISIT_TYPE                , CM.ORDER_NO                , CM.ORDER_CD                , CM.ORDER_NAME                , CM.CLN_DEPT_CD                , (SELECT DEPTHNGNM FROM COM.ZSDDDEPT WHERE DEPTCD = CM.CLN_DEPT_CD and valitodd = '99991231' and instcd = '111') AS CLN_DEPT_NM                , COM.FN_ZS_GETDEPTNAME('111', CM.WARDCD,  :param0 ) as WARDCD                , CM.ROOMCD                , CM.FORM_RID                , VEF.FORM_CD                , VEF.FORM_GUID                , C.PRNTCNT                , CM.CONSENT_STATE                , CM.OCR_NUMBER                 , CM.COSIGN_DC_ID                , CM.COSIGN_DC_NAME                , CM.CREATE_USER_ID                , CM.CREATE_USER_NAME                , CM.CREATE_DATETIME                , CM.CLN_DATE                , CM.CRETNO            FROM  CONSENT_MST CM           INNER  JOIN EFORM_DOCUMENT VEF ON VEF.FORM_RID = CM.FORM_RID,                  EMR.MRFMFORM C           WHERE  CM.USE_YN = 'Y'              AND  CM.PID =  :param1                AND  TO_CHAR(TO_DATE(CM.CREATE_DATETIME, 'YYYY-MM-DD HH24:MI:SS'), 'YYYYMMDD') BETWEEN  :param2  and  :param0              AND  VEF.FORM_CD = C.FORMCD             AND  C.instcd = '111'             AND  C.formprogflag LIKE 'OCR%'             AND  C.formlevlcd != '-'             AND  SUBSTR (C.formtodt, 1, 8) = '99991231'                       AND  CM.CONSENT_STATE IN ('UNFINISHED')                      ORDER  BY CM.CONSENT_STATE DESC, CM.CREATE_DATETIME DESC]

[Logging Date Time: 2016-10-19 09:10:53,528] =====================================================================================
SQL Command - Statement Id: [GET_CONSENT_LIST] Parameters: [param0=[endDt,20161019], param1=[patientCode,2213299], param2=[startDt,20161018]]

[Logging Date Time: 2016-10-19 09:10:53,528] =====================================================================================
SQL Command - Statement Id: [GET_CONSENT_LIST] Parameters: [param0=[endDt,20161019], param1=[patientCode,2213299], param2=[startDt,20161018]]

[Logging Date Time: 2016-10-19 09:10:53,528] =====================================================================================
SQL Command - Statement Id: [GET_CONSENT_LIST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]]

[Logging Date Time: 2016-10-19 09:10:53,528] =====================================================================================
SQL Command - Statement Id: [GET_CONSENT_LIST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]]

[Logging Date Time: 2016-10-19 09:12:17,235] =====================================================================================
SQL Command - Statement Id: [GET_CONSENT_LIST] PreparedStatement : [SELECT CM.CONSENT_MST_RID                , DECODE(CM.CONSENT_STATE, 'TEMP' ,'임시저장', 'ELECTR_CMP', '서명', 'PAPER_OUT', '출력' , 'CERTIFY_CMP', '인증', 'UNFINISHED', '미작성', 'VERBAL', '구두') AS CONSENT_STATE_DISP                , VEF.FORM_NAME AS CONSENT_NAME                , CM.HOS_TYPE                , CM.PID                , CM.VISIT_TYPE                , CM.ORDER_NO                , CM.ORDER_CD                , CM.ORDER_NAME                , CM.CLN_DEPT_CD                , (SELECT DEPTHNGNM FROM COM.ZSDDDEPT WHERE DEPTCD = CM.CLN_DEPT_CD and valitodd = '99991231' and instcd = '111') AS CLN_DEPT_NM                , COM.FN_ZS_GETDEPTNAME('111', CM.WARDCD,  :param0 ) as WARDCD                , CM.ROOMCD                , CM.FORM_RID                , VEF.FORM_CD                , VEF.FORM_GUID                , C.PRNTCNT                , CM.CONSENT_STATE                , CM.OCR_NUMBER                 , CM.COSIGN_DC_ID                , CM.COSIGN_DC_NAME                , CM.CREATE_USER_ID                , CM.CREATE_USER_NAME                , CM.CREATE_DATETIME                , CM.CLN_DATE                , CM.CRETNO            FROM  CONSENT_MST CM           INNER  JOIN EFORM_DOCUMENT VEF ON VEF.FORM_RID = CM.FORM_RID,                  EMR.MRFMFORM C           WHERE  CM.USE_YN = 'Y'              AND  CM.PID =  :param1                AND  TO_CHAR(TO_DATE(CM.CREATE_DATETIME, 'YYYY-MM-DD HH24:MI:SS'), 'YYYYMMDD') BETWEEN  :param2  and  :param0              AND  VEF.FORM_CD = C.FORMCD             AND  C.instcd = '111'             AND  C.formprogflag LIKE 'OCR%'             AND  C.formlevlcd != '-'             AND  SUBSTR (C.formtodt, 1, 8) = '99991231'                       AND  CM.CONSENT_STATE IN ('UNFINISHED')                          AND vef.category_rid in (select cate.category_rid            from cmr.eform_category cate            where cate.p_category_rid = '147')                     ORDER  BY CM.CONSENT_STATE DESC, CM.CREATE_DATETIME DESC]

[Logging Date Time: 2016-10-19 09:12:17,235] =====================================================================================
SQL Command - Statement Id: [GET_CONSENT_LIST] PreparedStatement : [SELECT CM.CONSENT_MST_RID                , DECODE(CM.CONSENT_STATE, 'TEMP' ,'임시저장', 'ELECTR_CMP', '서명', 'PAPER_OUT', '출력' , 'CERTIFY_CMP', '인증', 'UNFINISHED', '미작성', 'VERBAL', '구두') AS CONSENT_STATE_DISP                , VEF.FORM_NAME AS CONSENT_NAME                , CM.HOS_TYPE                , CM.PID                , CM.VISIT_TYPE                , CM.ORDER_NO                , CM.ORDER_CD                , CM.ORDER_NAME                , CM.CLN_DEPT_CD                , (SELECT DEPTHNGNM FROM COM.ZSDDDEPT WHERE DEPTCD = CM.CLN_DEPT_CD and valitodd = '99991231' and instcd = '111') AS CLN_DEPT_NM                , COM.FN_ZS_GETDEPTNAME('111', CM.WARDCD,  :param0 ) as WARDCD                , CM.ROOMCD                , CM.FORM_RID                , VEF.FORM_CD                , VEF.FORM_GUID                , C.PRNTCNT                , CM.CONSENT_STATE                , CM.OCR_NUMBER                 , CM.COSIGN_DC_ID                , CM.COSIGN_DC_NAME                , CM.CREATE_USER_ID                , CM.CREATE_USER_NAME                , CM.CREATE_DATETIME                , CM.CLN_DATE                , CM.CRETNO            FROM  CONSENT_MST CM           INNER  JOIN EFORM_DOCUMENT VEF ON VEF.FORM_RID = CM.FORM_RID,                  EMR.MRFMFORM C           WHERE  CM.USE_YN = 'Y'              AND  CM.PID =  :param1                AND  TO_CHAR(TO_DATE(CM.CREATE_DATETIME, 'YYYY-MM-DD HH24:MI:SS'), 'YYYYMMDD') BETWEEN  :param2  and  :param0              AND  VEF.FORM_CD = C.FORMCD             AND  C.instcd = '111'             AND  C.formprogflag LIKE 'OCR%'             AND  C.formlevlcd != '-'             AND  SUBSTR (C.formtodt, 1, 8) = '99991231'                       AND  CM.CONSENT_STATE IN ('UNFINISHED')                          AND vef.category_rid in (select cate.category_rid            from cmr.eform_category cate            where cate.p_category_rid = '147')                     ORDER  BY CM.CONSENT_STATE DESC, CM.CREATE_DATETIME DESC]

[Logging Date Time: 2016-10-19 09:12:17,235] =====================================================================================
SQL Command - Statement Id: [GET_CONSENT_LIST] Parameters: [param0=[endDt,20161019], param1=[patientCode,2213299], param2=[startDt,20161018]]

[Logging Date Time: 2016-10-19 09:12:17,235] =====================================================================================
SQL Command - Statement Id: [GET_CONSENT_LIST] Parameters: [param0=[endDt,20161019], param1=[patientCode,2213299], param2=[startDt,20161018]]

[Logging Date Time: 2016-10-19 09:12:17,235] =====================================================================================
SQL Command - Statement Id: [GET_CONSENT_LIST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]]

[Logging Date Time: 2016-10-19 09:12:17,235] =====================================================================================
SQL Command - Statement Id: [GET_CONSENT_LIST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]]

[Logging Date Time: 2016-10-19 09:26:08,373] =====================================================================================
SQL Command - Statement Id: [GetUnfinishedListPerDoctor] PreparedStatement : [select pid,               (select ptbs.hngnm                  from pam.pmcmptbs ptbs                 where ptbs.pid = a.pid                       and ptbs.instcd = '111') as hngnm,               (select v.FORM_CD                  from cmr.v_eform_formdoc v                 where v.FORM_RID = a.form_rid) as formcd,               (select v.FORM_NAME                  from cmr.v_eform_formdoc v                 where v.FORM_RID = a.form_rid) as formnm,               (select v.PRINT_ONLY                  from cmr.v_eform_formdoc v                 where v.FORM_RID = a.form_rid) as printonly,               a.order_date as orderdate          from cmr.consent_mst a         where a.cosign_dc_id =  :param0                and a.consent_state in ('UNFINISHED','TEMP')]

[Logging Date Time: 2016-10-19 09:26:08,373] =====================================================================================
SQL Command - Statement Id: [GetUnfinishedListPerDoctor] PreparedStatement : [select pid,               (select ptbs.hngnm                  from pam.pmcmptbs ptbs                 where ptbs.pid = a.pid                       and ptbs.instcd = '111') as hngnm,               (select v.FORM_CD                  from cmr.v_eform_formdoc v                 where v.FORM_RID = a.form_rid) as formcd,               (select v.FORM_NAME                  from cmr.v_eform_formdoc v                 where v.FORM_RID = a.form_rid) as formnm,               (select v.PRINT_ONLY                  from cmr.v_eform_formdoc v                 where v.FORM_RID = a.form_rid) as printonly,               a.order_date as orderdate          from cmr.consent_mst a         where a.cosign_dc_id =  :param0                and a.consent_state in ('UNFINISHED','TEMP')]

[Logging Date Time: 2016-10-19 09:26:08,438] =====================================================================================
SQL Command - Statement Id: [GetUnfinishedListPerDoctor] Parameters: [param0=[userid,104796]]

[Logging Date Time: 2016-10-19 09:26:08,438] =====================================================================================
SQL Command - Statement Id: [GetUnfinishedListPerDoctor] Parameters: [param0=[userid,104796]]

[Logging Date Time: 2016-10-19 09:26:08,438] =====================================================================================
SQL Command - Statement Id: [GetUnfinishedListPerDoctor] Types: [param0=[AnsiString, System.String]]

[Logging Date Time: 2016-10-19 09:26:08,438] =====================================================================================
SQL Command - Statement Id: [GetUnfinishedListPerDoctor] Types: [param0=[AnsiString, System.String]]