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

[Logging Date Time: 2016-11-11 09:57:52,841] =====================================================================================
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-11 09:57:52,857] =====================================================================================
SQL Command - Statement Id: [INSERT_CONSENT_MST] Parameters: [param0=[consentMstRid,1917], param1=[hosType,111], param2=[patientCode,1919234], param3=[vistType,O], param4=[ocrCode,2016111163918], param5=[clnDeptCd,2010400000], param6=[clnDate,20161111], param7=[cretno,1], param8=[ward,null], param9=[roomcd,null], param10=[formRid,1252], param11=[consentState,TEMP], param12=[completeYn,N], param13=[paperYn,N], 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-11 09:57:52,857] =====================================================================================
SQL Command - Statement Id: [INSERT_CONSENT_MST] Parameters: [param0=[consentMstRid,1917], param1=[hosType,111], param2=[patientCode,1919234], param3=[vistType,O], param4=[ocrCode,2016111163918], param5=[clnDeptCd,2010400000], param6=[clnDate,20161111], param7=[cretno,1], param8=[ward,null], param9=[roomcd,null], param10=[formRid,1252], param11=[consentState,TEMP], param12=[completeYn,N], param13=[paperYn,N], 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-11 09:57:52,857] =====================================================================================
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-11 09:57:52,857] =====================================================================================
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-11 09:57:52,861] =====================================================================================
SQL Command - Statement Id: [INSERT_CONSENT_DATA] PreparedStatement : [insert into CONSENT_DATA          (            CONSENT_DATA_RID,            CONSENT_MST_RID,            FORM_RID,            DEVICE_TYPE,            DEVICE_IDENT_NO,            COMPLETE_YN,            CREATE_USER_ID,            CREATE_DATETIME,            FORM_XML,            DATA_XML          )          values          (             :param0 ,             :param1 ,             :param2 ,             :param3 ,             :param4 ,             :param5 ,             :param6 ,            TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'),             :param7 ,             :param8           )]

[Logging Date Time: 2016-11-11 09:57:52,861] =====================================================================================
SQL Command - Statement Id: [INSERT_CONSENT_DATA] PreparedStatement : [insert into CONSENT_DATA          (            CONSENT_DATA_RID,            CONSENT_MST_RID,            FORM_RID,            DEVICE_TYPE,            DEVICE_IDENT_NO,            COMPLETE_YN,            CREATE_USER_ID,            CREATE_DATETIME,            FORM_XML,            DATA_XML          )          values          (             :param0 ,             :param1 ,             :param2 ,             :param3 ,             :param4 ,             :param5 ,             :param6 ,            TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'),             :param7 ,             :param8           )]

[Logging Date Time: 2016-11-11 09:57:52,862] =====================================================================================
SQL Command - Statement Id: [INSERT_CONSENT_DATA] Parameters: [param0=[consentDataRid,1890], param1=[consentMstRid,1917], param2=[formRid,1252], param3=[deviceType,WIN], param4=[deviceIdentNo,16-101-33], param5=[completeYn,N], param6=[userId,107945], param7=[formXml,System.Byte[]], param8=[dataXml,System.Byte[]]]

[Logging Date Time: 2016-11-11 09:57:52,862] =====================================================================================
SQL Command - Statement Id: [INSERT_CONSENT_DATA] Parameters: [param0=[consentDataRid,1890], param1=[consentMstRid,1917], param2=[formRid,1252], param3=[deviceType,WIN], param4=[deviceIdentNo,16-101-33], param5=[completeYn,N], param6=[userId,107945], param7=[formXml,System.Byte[]], param8=[dataXml,System.Byte[]]]

[Logging Date Time: 2016-11-11 09:57:52,862] =====================================================================================
SQL Command - Statement Id: [INSERT_CONSENT_DATA] Types: [param0=[Int32, System.Int32], param1=[Int32, System.Int32], param2=[Int32, System.Int32], param3=[AnsiString, System.String], param4=[AnsiString, System.String], param5=[AnsiString, System.String], param6=[AnsiString, System.String], param7=[Binary, System.Byte[]], param8=[Binary, System.Byte[]]]

[Logging Date Time: 2016-11-11 09:57:52,862] =====================================================================================
SQL Command - Statement Id: [INSERT_CONSENT_DATA] Types: [param0=[Int32, System.Int32], param1=[Int32, System.Int32], param2=[Int32, System.Int32], param3=[AnsiString, System.String], param4=[AnsiString, System.String], param5=[AnsiString, System.String], param6=[AnsiString, System.String], param7=[Binary, System.Byte[]], param8=[Binary, System.Byte[]]]

[Logging Date Time: 2016-11-11 09:57:53,288] =====================================================================================
SQL Command - DataXmlToDictionary 0 : 1/IO_device

[Logging Date Time: 2016-11-11 09:57:53,288] =====================================================================================
SQL Command - DataXmlToDictionary 1 : IO_device/

[Logging Date Time: 2016-11-11 09:57:53,288] =====================================================================================
SQL Command - DataXmlToDictionary 0 : 1/O_device_ID

[Logging Date Time: 2016-11-11 09:57:53,288] =====================================================================================
SQL Command - DataXmlToDictionary 1 : O_device_ID/16-101-33

[Logging Date Time: 2016-11-11 09:57:53,289] =====================================================================================
SQL Command - DataXmlToDictionary 0 : 1/IO_ocr_cd

[Logging Date Time: 2016-11-11 09:57:53,289] =====================================================================================
SQL Command - DataXmlToDictionary 1 : IO_ocr_cd/2016111163918

[Logging Date Time: 2016-11-11 09:57:53,289] =====================================================================================
SQL Command - DataXmlToDictionary 0 : 1/IO_Pt_ID

[Logging Date Time: 2016-11-11 09:57:53,289] =====================================================================================
SQL Command - DataXmlToDictionary 1 : IO_Pt_ID/

[Logging Date Time: 2016-11-11 09:57:53,289] =====================================================================================
SQL Command - DataXmlToDictionary 0 : 1/IO_sex_age_y_m

[Logging Date Time: 2016-11-11 09:57:53,289] =====================================================================================
SQL Command - DataXmlToDictionary 1 : IO_sex_age_y_m/

[Logging Date Time: 2016-11-11 09:57:53,289] =====================================================================================
SQL Command - DataXmlToDictionary 0 : 1/IO_Pt_name

[Logging Date Time: 2016-11-11 09:57:53,289] =====================================================================================
SQL Command - DataXmlToDictionary 1 : IO_Pt_name/

[Logging Date Time: 2016-11-11 09:57:53,289] =====================================================================================
SQL Command - DataXmlToDictionary 0 : 1/IO_JuminNo

[Logging Date Time: 2016-11-11 09:57:53,289] =====================================================================================
SQL Command - DataXmlToDictionary 1 : IO_JuminNo/

[Logging Date Time: 2016-11-11 09:57:53,289] =====================================================================================
SQL Command - DataXmlToDictionary 0 : 1/IO_roomNo

[Logging Date Time: 2016-11-11 09:57:53,289] =====================================================================================
SQL Command - DataXmlToDictionary 1 : IO_roomNo/

[Logging Date Time: 2016-11-11 09:57:53,289] =====================================================================================
SQL Command - DataXmlToDictionary 0 : 1/IO_ADdate

[Logging Date Time: 2016-11-11 09:57:53,290] =====================================================================================
SQL Command - DataXmlToDictionary 1 : IO_ADdate/

[Logging Date Time: 2016-11-11 09:57:53,290] =====================================================================================
SQL Command - DataXmlToDictionary 0 : 1/IO_Dept

[Logging Date Time: 2016-11-11 09:57:53,290] =====================================================================================
SQL Command - DataXmlToDictionary 1 : IO_Dept/

[Logging Date Time: 2016-11-11 09:57:53,290] =====================================================================================
SQL Command - DataXmlToDictionary 0 : 1/IO_formname

[Logging Date Time: 2016-11-11 09:57:53,290] =====================================================================================
SQL Command - DataXmlToDictionary 1 : IO_formname/

[Logging Date Time: 2016-11-11 09:57:53,290] =====================================================================================
SQL Command - DataXmlToDictionary 0 : 1/IO_OPdept

[Logging Date Time: 2016-11-11 09:57:53,290] =====================================================================================
SQL Command - DataXmlToDictionary 1 : IO_OPdept/안과

[Logging Date Time: 2016-11-11 09:57:53,290] =====================================================================================
SQL Command - DataXmlToDictionary 0 : 1/IO_OPdr

[Logging Date Time: 2016-11-11 09:57:53,290] =====================================================================================
SQL Command - DataXmlToDictionary 1 : IO_OPdr/

[Logging Date Time: 2016-11-11 09:57:53,290] =====================================================================================
SQL Command - DataXmlToDictionary 0 : 1/IO_Dx

[Logging Date Time: 2016-11-11 09:57:53,290] =====================================================================================
SQL Command - DataXmlToDictionary 1 : IO_Dx/

[Logging Date Time: 2016-11-11 09:57:53,290] =====================================================================================
SQL Command - DataXmlToDictionary 0 : 1/IO_maindr

[Logging Date Time: 2016-11-11 09:57:53,291] =====================================================================================
SQL Command - DataXmlToDictionary 1 : IO_maindr/김재희

[Logging Date Time: 2016-11-11 09:57:53,291] =====================================================================================
SQL Command - DataXmlToDictionary 0 : 1/IO_signdate

[Logging Date Time: 2016-11-11 09:57:53,291] =====================================================================================
SQL Command - DataXmlToDictionary 1 : IO_signdate/

[Logging Date Time: 2016-11-11 09:57:53,291] =====================================================================================
SQL Command - DataXmlToDictionary 0 : 1/IO_signtime

[Logging Date Time: 2016-11-11 09:57:53,291] =====================================================================================
SQL Command - DataXmlToDictionary 1 : IO_signtime/

[Logging Date Time: 2016-11-11 09:57:53,291] =====================================================================================
SQL Command - DataXmlToDictionary 0 : 1/IO_printtime

[Logging Date Time: 2016-11-11 09:57:53,291] =====================================================================================
SQL Command - DataXmlToDictionary 1 : IO_printtime/2016-11-11 09:57:19

[Logging Date Time: 2016-11-11 09:57:53,291] =====================================================================================
SQL Command - DataXmlToDictionary 0 : 1/O_Pt_rel

[Logging Date Time: 2016-11-11 09:57:53,291] =====================================================================================
SQL Command - DataXmlToDictionary 1 : O_Pt_rel/

[Logging Date Time: 2016-11-11 09:57:53,291] =====================================================================================
SQL Command - DataXmlToDictionary 0 : 1/O_sign_cause

[Logging Date Time: 2016-11-11 09:57:53,291] =====================================================================================
SQL Command - DataXmlToDictionary 1 : O_sign_cause/

[Logging Date Time: 2016-11-11 09:57:53,291] =====================================================================================
SQL Command - DataXmlToDictionary 0 : 1/O_Ptname_write

[Logging Date Time: 2016-11-11 09:57:53,291] =====================================================================================
SQL Command - DataXmlToDictionary 1 : O_Ptname_write/

[Logging Date Time: 2016-11-11 09:57:53,292] =====================================================================================
SQL Command - DataXmlToDictionary 0 : 1/O_Ptsign

[Logging Date Time: 2016-11-11 09:57:53,292] =====================================================================================
SQL Command - DataXmlToDictionary 1 : O_Ptsign/

[Logging Date Time: 2016-11-11 09:57:53,292] =====================================================================================
SQL Command - DataXmlToDictionary 0 : 1/O_JuminNo

[Logging Date Time: 2016-11-11 09:57:53,292] =====================================================================================
SQL Command - DataXmlToDictionary 1 : O_JuminNo/

[Logging Date Time: 2016-11-11 09:57:53,292] =====================================================================================
SQL Command - DataXmlToDictionary 0 : 1/O_Drname_write

[Logging Date Time: 2016-11-11 09:57:53,292] =====================================================================================
SQL Command - DataXmlToDictionary 1 : O_Drname_write/

[Logging Date Time: 2016-11-11 09:57:53,292] =====================================================================================
SQL Command - DataXmlToDictionary 0 : 1/O_drsign

[Logging Date Time: 2016-11-11 09:57:53,292] =====================================================================================
SQL Command - DataXmlToDictionary 1 : O_drsign/

[Logging Date Time: 2016-11-11 09:57:53,292] =====================================================================================
SQL Command - DataXmlToDictionary 0 : 1/IO_INPUTNM

[Logging Date Time: 2016-11-11 09:57:53,292] =====================================================================================
SQL Command - DataXmlToDictionary 1 : IO_INPUTNM/

[Logging Date Time: 2016-11-11 09:57:53,293] =====================================================================================
SQL Command - DataXmlToDictionary 0 : 8/base_info

[Logging Date Time: 2016-11-11 09:57:53,293] =====================================================================================
SQL Command - DataXmlToDictionary : IO_Pt_ID

[Logging Date Time: 2016-11-11 09:57:53,293] =====================================================================================
SQL Command - DataXmlToDictionary : 1

[Logging Date Time: 2016-11-11 09:57:53,293] =====================================================================================
SQL Command - DataXmlToDictionary 2 : IO_Pt_ID/1919234

[Logging Date Time: 2016-11-11 09:57:53,293] =====================================================================================
SQL Command - DataXmlToDictionary : IO_sex_age_y_m

[Logging Date Time: 2016-11-11 09:57:53,293] =====================================================================================
SQL Command - DataXmlToDictionary : 1

[Logging Date Time: 2016-11-11 09:57:53,293] =====================================================================================
SQL Command - DataXmlToDictionary 2 : IO_sex_age_y_m/M/76

[Logging Date Time: 2016-11-11 09:57:53,293] =====================================================================================
SQL Command - DataXmlToDictionary : IO_formname

[Logging Date Time: 2016-11-11 09:57:53,293] =====================================================================================
SQL Command - DataXmlToDictionary : 1

[Logging Date Time: 2016-11-11 09:57:53,293] =====================================================================================
SQL Command - DataXmlToDictionary 2 : IO_formname/각막내 원형 절편 삽입술에 대한 설명 및 동의서

[Logging Date Time: 2016-11-11 09:57:53,293] =====================================================================================
SQL Command - DataXmlToDictionary : IO_Pt_name

[Logging Date Time: 2016-11-11 09:57:53,293] =====================================================================================
SQL Command - DataXmlToDictionary : 1

[Logging Date Time: 2016-11-11 09:57:53,293] =====================================================================================
SQL Command - DataXmlToDictionary 2 : IO_Pt_name/김희곤

[Logging Date Time: 2016-11-11 09:57:53,294] =====================================================================================
SQL Command - DataXmlToDictionary : IO_JuminNo

[Logging Date Time: 2016-11-11 09:57:53,294] =====================================================================================
SQL Command - DataXmlToDictionary : 1

[Logging Date Time: 2016-11-11 09:57:53,294] =====================================================================================
SQL Command - DataXmlToDictionary 2 : IO_JuminNo/400623-1******

[Logging Date Time: 2016-11-11 09:57:53,294] =====================================================================================
SQL Command - DataXmlToDictionary : IO_roomNo

[Logging Date Time: 2016-11-11 09:57:53,294] =====================================================================================
SQL Command - DataXmlToDictionary : 1

[Logging Date Time: 2016-11-11 09:57:53,294] =====================================================================================
SQL Command - DataXmlToDictionary 2 : IO_roomNo//

[Logging Date Time: 2016-11-11 09:57:53,294] =====================================================================================
SQL Command - DataXmlToDictionary : IO_ADdate

[Logging Date Time: 2016-11-11 09:57:53,294] =====================================================================================
SQL Command - DataXmlToDictionary : 1

[Logging Date Time: 2016-11-11 09:57:53,294] =====================================================================================
SQL Command - DataXmlToDictionary 2 : IO_ADdate/2016/11/11

[Logging Date Time: 2016-11-11 09:57:53,294] =====================================================================================
SQL Command - DataXmlToDictionary : IO_Dept

[Logging Date Time: 2016-11-11 09:57:53,294] =====================================================================================
SQL Command - DataXmlToDictionary : 1

[Logging Date Time: 2016-11-11 09:57:53,294] =====================================================================================
SQL Command - DataXmlToDictionary 2 : IO_Dept/IC

[Logging Date Time: 2016-11-11 09:57:53,294] =====================================================================================
SQL Command - DataXmlToDictionary 0 : 1/IO_bp

[Logging Date Time: 2016-11-11 09:57:53,295] =====================================================================================
SQL Command - DataXmlToDictionary 1 : IO_bp/

[Logging Date Time: 2016-11-11 09:57:53,295] =====================================================================================
SQL Command - DataXmlToDictionary 0 : 1/IO_dm

[Logging Date Time: 2016-11-11 09:57:53,295] =====================================================================================
SQL Command - DataXmlToDictionary 1 : IO_dm/

[Logging Date Time: 2016-11-11 09:57:53,295] =====================================================================================
SQL Command - DataXmlToDictionary 0 : 1/IO_heart

[Logging Date Time: 2016-11-11 09:57:53,295] =====================================================================================
SQL Command - DataXmlToDictionary 1 : IO_heart/

[Logging Date Time: 2016-11-11 09:57:53,295] =====================================================================================
SQL Command - DataXmlToDictionary 0 : 1/IO_kidney

[Logging Date Time: 2016-11-11 09:57:53,295] =====================================================================================
SQL Command - DataXmlToDictionary 1 : IO_kidney/

[Logging Date Time: 2016-11-11 09:57:53,295] =====================================================================================
SQL Command - DataXmlToDictionary 0 : 1/IO_respiration

[Logging Date Time: 2016-11-11 09:57:53,295] =====================================================================================
SQL Command - DataXmlToDictionary 1 : IO_respiration/

[Logging Date Time: 2016-11-11 09:57:53,295] =====================================================================================
SQL Command - DataXmlToDictionary 0 : 1/IO_hx

[Logging Date Time: 2016-11-11 09:57:53,295] =====================================================================================
SQL Command - DataXmlToDictionary 1 : IO_hx/

[Logging Date Time: 2016-11-11 09:57:53,295] =====================================================================================
SQL Command - DataXmlToDictionary 0 : 1/IO_allergy

[Logging Date Time: 2016-11-11 09:57:53,297] =====================================================================================
SQL Command - DataXmlToDictionary 1 : IO_allergy/

[Logging Date Time: 2016-11-11 09:57:53,297] =====================================================================================
SQL Command - DataXmlToDictionary 0 : 1/IO_drug

[Logging Date Time: 2016-11-11 09:57:53,297] =====================================================================================
SQL Command - DataXmlToDictionary 1 : IO_drug/

[Logging Date Time: 2016-11-11 09:57:53,297] =====================================================================================
SQL Command - DataXmlToDictionary 0 : 1/IO_smoking

[Logging Date Time: 2016-11-11 09:57:53,297] =====================================================================================
SQL Command - DataXmlToDictionary 1 : IO_smoking/

[Logging Date Time: 2016-11-11 09:57:53,297] =====================================================================================
SQL Command - DataXmlToDictionary 0 : 1/IO_idio

[Logging Date Time: 2016-11-11 09:57:53,297] =====================================================================================
SQL Command - DataXmlToDictionary 1 : IO_idio/

[Logging Date Time: 2016-11-11 09:57:53,297] =====================================================================================
SQL Command - DataXmlToDictionary 0 : 1/IO_nacrotics

[Logging Date Time: 2016-11-11 09:57:53,297] =====================================================================================
SQL Command - DataXmlToDictionary 1 : IO_nacrotics/

[Logging Date Time: 2016-11-11 09:57:53,297] =====================================================================================
SQL Command - DataXmlToDictionary 0 : 1/IO_airway

[Logging Date Time: 2016-11-11 09:57:53,297] =====================================================================================
SQL Command - DataXmlToDictionary 1 : IO_airway/

[Logging Date Time: 2016-11-11 09:57:53,297] =====================================================================================
SQL Command - DataXmlToDictionary 0 : 1/IO_hemorrhage

[Logging Date Time: 2016-11-11 09:57:53,297] =====================================================================================
SQL Command - DataXmlToDictionary 1 : IO_hemorrhage/

[Logging Date Time: 2016-11-11 09:57:53,298] =====================================================================================
SQL Command - DataXmlToDictionary 0 : 1/IO_status_etc

[Logging Date Time: 2016-11-11 09:57:53,298] =====================================================================================
SQL Command - DataXmlToDictionary 1 : IO_status_etc/

[Logging Date Time: 2016-11-11 09:57:53,298] =====================================================================================
SQL Command - DataXmlToDictionary 0 : 1/opdr_info

[Logging Date Time: 2016-11-11 09:57:53,298] =====================================================================================
SQL Command - DataXmlToDictionary 1 : opdr_info/

[Logging Date Time: 2016-11-11 09:57:53,298] =====================================================================================
SQL Command - DataXmlToDictionary 0 : 14/state

[Logging Date Time: 2016-11-11 09:57:53,298] =====================================================================================
SQL Command - DataXmlToDictionary : IO_bp

[Logging Date Time: 2016-11-11 09:57:53,298] =====================================================================================
SQL Command - DataXmlToDictionary : 1

[Logging Date Time: 2016-11-11 09:57:53,298] =====================================================================================
SQL Command - DataXmlToDictionary 2 : IO_bp/01

[Logging Date Time: 2016-11-11 09:57:53,298] =====================================================================================
SQL Command - DataXmlToDictionary : IO_hx

[Logging Date Time: 2016-11-11 09:57:53,298] =====================================================================================
SQL Command - DataXmlToDictionary : 1

[Logging Date Time: 2016-11-11 09:57:53,298] =====================================================================================
SQL Command - DataXmlToDictionary 2 : IO_hx/01

[Logging Date Time: 2016-11-11 09:57:53,298] =====================================================================================
SQL Command - DataXmlToDictionary : IO_idio

[Logging Date Time: 2016-11-11 09:57:53,298] =====================================================================================
SQL Command - DataXmlToDictionary : 1

[Logging Date Time: 2016-11-11 09:57:53,299] =====================================================================================
SQL Command - DataXmlToDictionary 2 : IO_idio/03

[Logging Date Time: 2016-11-11 09:57:53,299] =====================================================================================
SQL Command - DataXmlToDictionary : IO_dm

[Logging Date Time: 2016-11-11 09:57:53,299] =====================================================================================
SQL Command - DataXmlToDictionary : 1

[Logging Date Time: 2016-11-11 09:57:53,299] =====================================================================================
SQL Command - DataXmlToDictionary 2 : IO_dm/02

[Logging Date Time: 2016-11-11 09:57:53,299] =====================================================================================
SQL Command - DataXmlToDictionary : IO_allergy

[Logging Date Time: 2016-11-11 09:57:53,299] =====================================================================================
SQL Command - DataXmlToDictionary : 1

[Logging Date Time: 2016-11-11 09:57:53,299] =====================================================================================
SQL Command - DataXmlToDictionary 2 : IO_allergy/02

[Logging Date Time: 2016-11-11 09:57:53,299] =====================================================================================
SQL Command - DataXmlToDictionary : IO_nacrotics

[Logging Date Time: 2016-11-11 09:57:53,299] =====================================================================================
SQL Command - DataXmlToDictionary : 1

[Logging Date Time: 2016-11-11 09:57:53,299] =====================================================================================
SQL Command - DataXmlToDictionary 2 : IO_nacrotics/02

[Logging Date Time: 2016-11-11 09:57:53,299] =====================================================================================
SQL Command - DataXmlToDictionary : IO_heart

[Logging Date Time: 2016-11-11 09:57:53,299] =====================================================================================
SQL Command - DataXmlToDictionary : 1

[Logging Date Time: 2016-11-11 09:57:53,299] =====================================================================================
SQL Command - DataXmlToDictionary 2 : IO_heart/03

[Logging Date Time: 2016-11-11 09:57:53,300] =====================================================================================
SQL Command - DataXmlToDictionary : IO_drug

[Logging Date Time: 2016-11-11 09:57:53,300] =====================================================================================
SQL Command - DataXmlToDictionary : 1

[Logging Date Time: 2016-11-11 09:57:53,300] =====================================================================================
SQL Command - DataXmlToDictionary 2 : IO_drug/03

[Logging Date Time: 2016-11-11 09:57:53,300] =====================================================================================
SQL Command - DataXmlToDictionary : IO_airway

[Logging Date Time: 2016-11-11 09:57:53,300] =====================================================================================
SQL Command - DataXmlToDictionary : 1

[Logging Date Time: 2016-11-11 09:57:53,300] =====================================================================================
SQL Command - DataXmlToDictionary 2 : IO_airway/01

[Logging Date Time: 2016-11-11 09:57:53,300] =====================================================================================
SQL Command - DataXmlToDictionary : IO_kidney

[Logging Date Time: 2016-11-11 09:57:53,300] =====================================================================================
SQL Command - DataXmlToDictionary : 1

[Logging Date Time: 2016-11-11 09:57:53,300] =====================================================================================
SQL Command - DataXmlToDictionary 2 : IO_kidney/01

[Logging Date Time: 2016-11-11 09:57:53,300] =====================================================================================
SQL Command - DataXmlToDictionary : IO_smoking

[Logging Date Time: 2016-11-11 09:57:53,300] =====================================================================================
SQL Command - DataXmlToDictionary : 1

[Logging Date Time: 2016-11-11 09:57:53,300] =====================================================================================
SQL Command - DataXmlToDictionary 2 : IO_smoking/01

[Logging Date Time: 2016-11-11 09:57:53,301] =====================================================================================
SQL Command - DataXmlToDictionary : IO_hemorrhage

[Logging Date Time: 2016-11-11 09:57:53,301] =====================================================================================
SQL Command - DataXmlToDictionary : 1

[Logging Date Time: 2016-11-11 09:57:53,301] =====================================================================================
SQL Command - DataXmlToDictionary 2 : IO_hemorrhage/03

[Logging Date Time: 2016-11-11 09:57:53,301] =====================================================================================
SQL Command - DataXmlToDictionary : IO_respiration

[Logging Date Time: 2016-11-11 09:57:53,301] =====================================================================================
SQL Command - DataXmlToDictionary : 1

[Logging Date Time: 2016-11-11 09:57:53,301] =====================================================================================
SQL Command - DataXmlToDictionary 2 : IO_respiration/02

[Logging Date Time: 2016-11-11 09:57:53,301] =====================================================================================
SQL Command - DataXmlToDictionary : IO_status_etc

[Logging Date Time: 2016-11-11 09:57:53,301] =====================================================================================
SQL Command - DataXmlToDictionary : 1

[Logging Date Time: 2016-11-11 09:57:53,301] =====================================================================================
SQL Command - DataXmlToDictionary 2 : IO_status_etc/

[Logging Date Time: 2016-11-11 09:57:53,301] =====================================================================================
SQL Command - DataXmlToDictionary 0 : 1/OPmeth_change

[Logging Date Time: 2016-11-11 09:57:53,301] =====================================================================================
SQL Command - DataXmlToDictionary 1 : OPmeth_change/

[Logging Date Time: 2016-11-11 09:57:53,301] =====================================================================================
SQL Command - DataXmlToDictionary 0 : 1/Anesthesia

[Logging Date Time: 2016-11-11 09:57:53,301] =====================================================================================
SQL Command - DataXmlToDictionary 1 : Anesthesia/

[Logging Date Time: 2016-11-11 09:57:53,302] =====================================================================================
SQL Command - DataXmlToDictionary 0 : 10/consent

[Logging Date Time: 2016-11-11 09:57:53,302] =====================================================================================
SQL Command - DataXmlToDictionary : O_sign_cause

[Logging Date Time: 2016-11-11 09:57:53,302] =====================================================================================
SQL Command - DataXmlToDictionary : 1

[Logging Date Time: 2016-11-11 09:57:53,302] =====================================================================================
SQL Command - DataXmlToDictionary 2 : O_sign_cause/

[Logging Date Time: 2016-11-11 09:57:53,302] =====================================================================================
SQL Command - DataXmlToDictionary : O_Pt_rel

[Logging Date Time: 2016-11-11 09:57:53,302] =====================================================================================
SQL Command - DataXmlToDictionary : 1

[Logging Date Time: 2016-11-11 09:57:53,302] =====================================================================================
SQL Command - DataXmlToDictionary 2 : O_Pt_rel/

[Logging Date Time: 2016-11-11 09:57:53,302] =====================================================================================
SQL Command - DataXmlToDictionary : IO_signdate

[Logging Date Time: 2016-11-11 09:57:53,302] =====================================================================================
SQL Command - DataXmlToDictionary : 1

[Logging Date Time: 2016-11-11 09:57:53,302] =====================================================================================
SQL Command - DataXmlToDictionary 2 : IO_signdate/2016-11-11 09:57:19

[Logging Date Time: 2016-11-11 09:57:53,302] =====================================================================================
SQL Command - DataXmlToDictionary : IO_signtime

[Logging Date Time: 2016-11-11 09:57:53,302] =====================================================================================
SQL Command - DataXmlToDictionary : 1

[Logging Date Time: 2016-11-11 09:57:53,302] =====================================================================================
SQL Command - DataXmlToDictionary 2 : IO_signtime/2016-11-11 09:57:19

[Logging Date Time: 2016-11-11 09:57:53,303] =====================================================================================
SQL Command - DataXmlToDictionary : O_Ptname_write

[Logging Date Time: 2016-11-11 09:57:53,303] =====================================================================================
SQL Command - DataXmlToDictionary : 1

[Logging Date Time: 2016-11-11 09:57:53,303] =====================================================================================
SQL Command - DataXmlToDictionary 2 : O_Ptname_write/

[Logging Date Time: 2016-11-11 09:57:53,303] =====================================================================================
SQL Command - DataXmlToDictionary : O_Ptsign

[Logging Date Time: 2016-11-11 09:57:53,303] =====================================================================================
SQL Command - DataXmlToDictionary : 1

[Logging Date Time: 2016-11-11 09:57:53,303] =====================================================================================
SQL Command - DataXmlToDictionary 2 : O_Ptsign/

[Logging Date Time: 2016-11-11 09:57:53,303] =====================================================================================
SQL Command - DataXmlToDictionary : O_JuminNo

[Logging Date Time: 2016-11-11 09:57:53,303] =====================================================================================
SQL Command - DataXmlToDictionary : 1

[Logging Date Time: 2016-11-11 09:57:53,303] =====================================================================================
SQL Command - DataXmlToDictionary 2 : O_JuminNo/400623

[Logging Date Time: 2016-11-11 09:57:53,303] =====================================================================================
SQL Command - DataXmlToDictionary : IO_INPUTNM

[Logging Date Time: 2016-11-11 09:57:53,303] =====================================================================================
SQL Command - DataXmlToDictionary : 1

[Logging Date Time: 2016-11-11 09:57:53,303] =====================================================================================
SQL Command - DataXmlToDictionary 2 : IO_INPUTNM/김재희

[Logging Date Time: 2016-11-11 09:57:53,303] =====================================================================================
SQL Command - DataXmlToDictionary : O_Verbal

[Logging Date Time: 2016-11-11 09:57:53,304] =====================================================================================
SQL Command - DataXmlToDictionary : 1

[Logging Date Time: 2016-11-11 09:57:53,304] =====================================================================================
SQL Command - DataXmlToDictionary 2 : O_Verbal/

[Logging Date Time: 2016-11-11 09:57:53,304] =====================================================================================
SQL Command - DataXmlToDictionary : IO_verbal

[Logging Date Time: 2016-11-11 09:57:53,304] =====================================================================================
SQL Command - DataXmlToDictionary : 1

[Logging Date Time: 2016-11-11 09:57:53,304] =====================================================================================
SQL Command - DataXmlToDictionary 2 : IO_verbal/

[Logging Date Time: 2016-11-11 09:57:53,304] =====================================================================================
SQL Command - DataXmlToDictionary 0 : 1/IO_verbal

[Logging Date Time: 2016-11-11 09:57:53,304] =====================================================================================
SQL Command - DataXmlToDictionary 1 : IO_verbal/

[Logging Date Time: 2016-11-11 09:57:53,304] =====================================================================================
SQL Command - DataXmlToDictionary 0 : 0/page-template-data

[Logging Date Time: 2016-11-11 09:57:53,304] =====================================================================================
SQL Command - DataXmlToDictionary 0 : 4/pen-drawing

[Logging Date Time: 2016-11-11 09:57:53,304] =====================================================================================
SQL Command - DataXmlToDictionary : page

[Logging Date Time: 2016-11-11 09:57:53,304] =====================================================================================
SQL Command - DataXmlToDictionary : 0

[Logging Date Time: 2016-11-11 09:57:53,304] =====================================================================================
SQL Command - DataXmlToDictionary : page

[Logging Date Time: 2016-11-11 09:57:53,305] =====================================================================================
SQL Command - DataXmlToDictionary : 0

[Logging Date Time: 2016-11-11 09:57:53,305] =====================================================================================
SQL Command - DataXmlToDictionary : page

[Logging Date Time: 2016-11-11 09:57:53,305] =====================================================================================
SQL Command - DataXmlToDictionary : 0

[Logging Date Time: 2016-11-11 09:57:53,305] =====================================================================================
SQL Command - DataXmlToDictionary : page

[Logging Date Time: 2016-11-11 09:57:53,305] =====================================================================================
SQL Command - DataXmlToDictionary : 0

[Logging Date Time: 2016-11-11 09:57:53,305] =====================================================================================
SQL Command - DataXmlToDictionary 0 : 4/changed-form

[Logging Date Time: 2016-11-11 09:57:53,305] =====================================================================================
SQL Command - DataXmlToDictionary : attach-page

[Logging Date Time: 2016-11-11 09:57:53,305] =====================================================================================
SQL Command - DataXmlToDictionary : 2

[Logging Date Time: 2016-11-11 09:57:53,305] =====================================================================================
SQL Command - DataXmlToDictionary : pagetemplates

[Logging Date Time: 2016-11-11 09:57:53,305] =====================================================================================
SQL Command - DataXmlToDictionary : 0

[Logging Date Time: 2016-11-11 09:57:53,305] =====================================================================================
SQL Command - DataXmlToDictionary : externalgroups

[Logging Date Time: 2016-11-11 09:57:53,305] =====================================================================================
SQL Command - DataXmlToDictionary : 6

[Logging Date Time: 2016-11-11 09:57:53,305] =====================================================================================
SQL Command - DataXmlToDictionary : changed

[Logging Date Time: 2016-11-11 09:57:53,306] =====================================================================================
SQL Command - DataXmlToDictionary : 1

[Logging Date Time: 2016-11-11 09:57:53,306] =====================================================================================
SQL Command - DataXmlToDictionary 0 : 0/viewer-info

[Logging Date Time: 2016-11-11 09:57:53,306] =====================================================================================
SQL Command - DataXmlToDictionary 0 : 0/form-info

[Logging Date Time: 2016-11-11 09:57:53,307] =====================================================================================
SQL Command - Statement Id: [SET_MEDI_HISTORY] PreparedStatement : [DECLARE                    v_cnt NUMBER:=0;                    BEGIN              SELECT  COUNT(*) INTO V_CNT              FROM  CONSENT_DATA_EX             WHERE  PID =  :param0                 AND  CLN_DATE =  :param1 ;              IF v_cnt = 0 THEN                insert into consent_data_ex                (pid, cln_date, use_yn, bp, dm, heart, kidney, respiration, hx, allergy, drug, smoking, idio, nacrotics, airway, hemorrhage, etc, create_user_id, create_datetime, modify_user_id, modify_datetime)              values                ( :param0 ,  :param1 ,'Y',  :param2 ,  :param3 ,  :param4 ,  :param5 ,  :param6 ,  :param7 ,  :param8 ,  :param9 ,  :param10 ,  :param11 ,  :param12 ,  :param13 ,  :param14 ,  :param15 ,  :param16 , TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'),  :param16 , TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'));                           ELSE                            update consent_data_ex                  set bp =  :param2 ,                      dm =  :param3 ,                      heart =  :param4 ,                      kidney =  :param5 ,                      respiration =  :param6 ,                      hx =  :param7 ,                      allergy =  :param8 ,                      drug =  :param9 ,                      smoking =  :param10 ,                      idio =  :param11 ,                      nacrotics =  :param12 ,                      airway =  :param13 ,                      hemorrhage =  :param14 ,                      etc =  :param15 ,                      modify_user_id =  :param16 ,                      modify_datetime = TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss')                where PID =  :param0                   AND  CLN_DATE =  :param1  ;              END IF;            END;]

[Logging Date Time: 2016-11-11 09:57:53,307] =====================================================================================
SQL Command - Statement Id: [SET_MEDI_HISTORY] PreparedStatement : [DECLARE                    v_cnt NUMBER:=0;                    BEGIN              SELECT  COUNT(*) INTO V_CNT              FROM  CONSENT_DATA_EX             WHERE  PID =  :param0                 AND  CLN_DATE =  :param1 ;              IF v_cnt = 0 THEN                insert into consent_data_ex                (pid, cln_date, use_yn, bp, dm, heart, kidney, respiration, hx, allergy, drug, smoking, idio, nacrotics, airway, hemorrhage, etc, create_user_id, create_datetime, modify_user_id, modify_datetime)              values                ( :param0 ,  :param1 ,'Y',  :param2 ,  :param3 ,  :param4 ,  :param5 ,  :param6 ,  :param7 ,  :param8 ,  :param9 ,  :param10 ,  :param11 ,  :param12 ,  :param13 ,  :param14 ,  :param15 ,  :param16 , TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'),  :param16 , TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'));                           ELSE                            update consent_data_ex                  set bp =  :param2 ,                      dm =  :param3 ,                      heart =  :param4 ,                      kidney =  :param5 ,                      respiration =  :param6 ,                      hx =  :param7 ,                      allergy =  :param8 ,                      drug =  :param9 ,                      smoking =  :param10 ,                      idio =  :param11 ,                      nacrotics =  :param12 ,                      airway =  :param13 ,                      hemorrhage =  :param14 ,                      etc =  :param15 ,                      modify_user_id =  :param16 ,                      modify_datetime = TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss')                where PID =  :param0                   AND  CLN_DATE =  :param1  ;              END IF;            END;]

[Logging Date Time: 2016-11-11 09:57:53,307] =====================================================================================
SQL Command - Statement Id: [SET_MEDI_HISTORY] Parameters: [param0=[patientCode,1919234], param1=[clnDate,20161111], param2=[bp,01], param3=[dm,02], param4=[heart,03], param5=[kidney,01], param6=[respiration,02], param7=[hx,01], param8=[allergy,02], param9=[drug,03], param10=[smoking,01], param11=[idio,03], param12=[nacrotics,02], param13=[airway,01], param14=[hemorrhage,03], param15=[status_etc,], param16=[userId,107945]]

[Logging Date Time: 2016-11-11 09:57:53,307] =====================================================================================
SQL Command - Statement Id: [SET_MEDI_HISTORY] Parameters: [param0=[patientCode,1919234], param1=[clnDate,20161111], param2=[bp,01], param3=[dm,02], param4=[heart,03], param5=[kidney,01], param6=[respiration,02], param7=[hx,01], param8=[allergy,02], param9=[drug,03], param10=[smoking,01], param11=[idio,03], param12=[nacrotics,02], param13=[airway,01], param14=[hemorrhage,03], param15=[status_etc,], param16=[userId,107945]]

[Logging Date Time: 2016-11-11 09:57:53,307] =====================================================================================
SQL Command - Statement Id: [SET_MEDI_HISTORY] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String], param5=[AnsiString, System.String], param6=[AnsiString, System.String], param7=[AnsiString, System.String], param8=[AnsiString, System.String], param9=[AnsiString, System.String], param10=[AnsiString, System.String], param11=[AnsiString, System.String], param12=[AnsiString, System.String], param13=[AnsiString, System.String], param14=[AnsiString, System.String], param15=[AnsiString, System.String], param16=[AnsiString, System.String]]

[Logging Date Time: 2016-11-11 09:57:53,307] =====================================================================================
SQL Command - Statement Id: [SET_MEDI_HISTORY] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String], param5=[AnsiString, System.String], param6=[AnsiString, System.String], param7=[AnsiString, System.String], param8=[AnsiString, System.String], param9=[AnsiString, System.String], param10=[AnsiString, System.String], param11=[AnsiString, System.String], param12=[AnsiString, System.String], param13=[AnsiString, System.String], param14=[AnsiString, System.String], param15=[AnsiString, System.String], param16=[AnsiString, System.String]]

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

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

[Logging Date Time: 2016-11-11 09:57:53,417] =====================================================================================
SQL Command - Statement Id: [GET_CONSENT_LIST] Parameters: [param0=[patientCode,1919234], param1=[startDt,20010601], param2=[endDt,20161111]]

[Logging Date Time: 2016-11-11 09:57:53,417] =====================================================================================
SQL Command - Statement Id: [GET_CONSENT_LIST] Parameters: [param0=[patientCode,1919234], param1=[startDt,20010601], param2=[endDt,20161111]]

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

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

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

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

[Logging Date Time: 2016-11-11 09:57:54,856] =====================================================================================
SQL Command - Statement Id: [GET_CONSENT_LIST] Parameters: [param0=[patientCode,1919234], param1=[startDt,20010601], param2=[endDt,20161111]]

[Logging Date Time: 2016-11-11 09:57:54,856] =====================================================================================
SQL Command - Statement Id: [GET_CONSENT_LIST] Parameters: [param0=[patientCode,1919234], param1=[startDt,20010601], param2=[endDt,20161111]]

[Logging Date Time: 2016-11-11 09:57:54,856] =====================================================================================
SQL Command - Statement Id: [GET_CONSENT_LIST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]]

[Logging Date Time: 2016-11-11 09:57:54,856] =====================================================================================
SQL Command - Statement Id: [GET_CONSENT_LIST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]]