[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]]