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

[Logging Date Time: 2016-11-07 17:49:16,847] =====================================================================================
SQL Command - Statement Id: [GET_CONSENT_LIST] Parameters: [param0=[patientCode,1845065], param1=[startDt,20161104], param2=[endDt,20161107]]

[Logging Date Time: 2016-11-07 17:49:16,847] =====================================================================================
SQL Command - Statement Id: [GET_CONSENT_LIST] Parameters: [param0=[patientCode,1845065], param1=[startDt,20161104], param2=[endDt,20161107]]

[Logging Date Time: 2016-11-07 17:49:16,892] =====================================================================================
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-07 17:49:16,892] =====================================================================================
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-07 17:49:17,015] =====================================================================================
SQL Command - Statement Id: [getPatientInfoIn] PreparedStatement : [SELECT a.orddeptcd,               a.pid as IO_Pt_ID,               to_char(a.cretno) as IO_CretNo,               (select ptbs.sex || '/' ||                       com.fn_zz_getageas(ptbs.rrgstno1,                                          ptbs.rrgstno2,                                          TO_CHAR(SYSDATE, 'YYYYMMDD'),                                          'A',                                          ptbs.brthdd)                  from pam.pmcmptbs ptbs                 where ptbs.instcd = a.instcd                       and ptbs.pid = a.pid) as IO_sex_age_y_m,               (select ptbs.hngnm                  from pam.pmcmptbs ptbs                 where ptbs.instcd = a.instcd                       and ptbs.pid = a.pid) as IO_Pt_Name,               (select ptbs.rrgstno1 || '-' || substr(ptbs.rrgstno2, 1, 1) ||                       '******'                  from pam.pmcmptbs ptbs                 where ptbs.instcd = a.instcd                       and ptbs.pid = a.pid) IO_JuminNo,               (select dept.DEPTENGABBR                  from com.zsdddept dept                 where dept.deptcd = a.wardcd                       and dept.instcd = a.instcd                       and dept.valitodd >= a.indd                       and dept.valifromdd <= a.indd) as IO_Ward,               a.roomcd as IO_roomNO,               a.indd as IO_ADdate,               a.dschdd as IO_Dschdd,               a.ordtype as IO_VisitType,               a.orddeptcd as IO_DeptCd,               (select dept.deptengabbr                  from com.zsdddept dept                 where dept.deptcd = a.orddeptcd                       and dept.instcd = a.instcd                       and dept.valitodd >= a.indd                       and dept.valifromdd <= a.indd) as IO_DeptNm,               COM.FN_ZS_GETDEPTNAME(a.instcd, a.orddeptcd, a.indd) AS IO_Dept2,               '' AS IO_OPdeptCd,               '' AS IO_OPdeptNm,               '' AS IO_OPdrNm,               '' AS IO_OPdrId,               (SELECT diag.diagcd                  FROM emr.mmohdiag diag                 WHERE diag.pid = a.pid                       AND diag.orddd = a.indd                       AND diag.cretno = a.cretno                       AND diag.diaghistcd = 'O'                       AND diag.diagtypecd = 'D'                       AND diag.diagkindcdflag = 'M'                       AND diag.genrflagcd = a.ordtype                       AND diag.diaghistno = (select max(diagh.diaghistno)                                          from emr.mmohdiag diagh                                         where diagh.pid = a.pid                                               AND diagh.orddd = a.indd                                               AND diagh.cretno = a.cretno                                               AND diagh.instcd = '111'                                AND diagh.diaghistcd = 'O'                                AND diagh.diagkindcdflag = 'M'                                AND diagh.genrflagcd = a.ordtype                                         group by pid)) as IO_DxCd,               (SELECT term.diaghngnm                  FROM emr.mmohdiag diag,                       emr.mmbvdiag term                 WHERE diag.pid = a.pid                       AND diag.orddd = a.indd                       AND diag.cretno = a.cretno                       AND diag.instcd = term.instcd                       AND diag.diagcd = term.orgdiagcd                       AND diag.diaghistcd = 'O'                       AND diag.diagtypecd = 'D'                       AND diag.diagkindcdflag = 'M'                       AND diag.diagdd >= term.termfromdd                       AND diag.diagdd <= term.termtodd                       AND diag.diagdd >= term.diagattrfromdd                       AND diag.diagdd <= term.diagattrtodd                       AND diag.genrflagcd = a.ordtype                       AND diag.diaghistno = (select max(diagh.diaghistno)                                                from emr.mmohdiag diagh                                               where diagh.pid = a.pid                                                     AND diagh.orddd = a.indd                                                     AND diagh.cretno = a.cretno                                                     AND diagh.instcd = '111'                                      AND diagh.diaghistcd = 'O'                                      AND diagh.diagkindcdflag = 'M'                                      AND diagh.genrflagcd = a.ordtype                                               group by pid)) as IO_DxNm,               a.MEDISPCLID as IO_MaindrId,               COM.FN_ZS_GETUSERNM(a.MEDISPCLID, a.indd) as IO_MaindrNm,               '111' as IO_HosType,               case when ex.bp is null then '02' else ex.bp end as IO_bp,               case when ex.dm is null then '02' else ex.dm end as IO_dm,               case when ex.heart is null then '02' else ex.heart end as IO_heart,               case when ex.kidney is null then '02' else ex.kidney end as IO_kidney,               case when ex.respiration is null then '02' else ex.respiration end as IO_respiration,               case when ex.hx is null then '02' else ex.hx end as  IO_hx,               case when ex.allergy is null then '02' else ex.allergy end as  IO_allergy,               case when ex.drug is null then '02' else ex.drug end as  IO_drug,               case when ex.smoking is null then '02' else ex.smoking end as  IO_smoking,               case when ex.idio is null then '02' else ex.idio end as  IO_idio,               case when ex.nacrotics is null then '02' else ex.nacrotics end as  IO_nacrotics,               case when ex.airway is null then '02' else ex.airway end as  IO_airway,               case when ex.hemorrhage is null then '02' else ex.hemorrhage end as  IO_hemorrhage,               ex.etc IO_status_etc,               '' as IO_OrderNo,               '111' as IO_PrintTime,               a.medispclid as IO_MaindrId,               COM.FN_ZS_GETUSERNM(a.medispclid, a.indd) as IO_MaindrNm,               '111' as IO_OcrCd,               '111' as IO_InputId,               '111' as IO_InputNm,               '111' as IO_SignImg,              a.fstrgstdt          FROM pam.pmihinpt a         left outer join emr.mmohoprs oprs            on (oprs.pid = a.pid and oprs.ophistcd = 'O' and opcnfmdd >= a.indd )         left outer join cmr.consent_data_ex ex            on (ex.pid = a.pid and ex.cln_date = a.indd)         WHERE a.instcd =  :param0                AND a.pid =  :param1                AND a.indd =  :param2                AND a.histstat = 'Y'               AND a.mskind = 'M'                    AND a.cretno =  :param3                    order by a.fstrgstdt desc]

[Logging Date Time: 2016-11-07 17:49:17,015] =====================================================================================
SQL Command - Statement Id: [getPatientInfoIn] PreparedStatement : [SELECT a.orddeptcd,               a.pid as IO_Pt_ID,               to_char(a.cretno) as IO_CretNo,               (select ptbs.sex || '/' ||                       com.fn_zz_getageas(ptbs.rrgstno1,                                          ptbs.rrgstno2,                                          TO_CHAR(SYSDATE, 'YYYYMMDD'),                                          'A',                                          ptbs.brthdd)                  from pam.pmcmptbs ptbs                 where ptbs.instcd = a.instcd                       and ptbs.pid = a.pid) as IO_sex_age_y_m,               (select ptbs.hngnm                  from pam.pmcmptbs ptbs                 where ptbs.instcd = a.instcd                       and ptbs.pid = a.pid) as IO_Pt_Name,               (select ptbs.rrgstno1 || '-' || substr(ptbs.rrgstno2, 1, 1) ||                       '******'                  from pam.pmcmptbs ptbs                 where ptbs.instcd = a.instcd                       and ptbs.pid = a.pid) IO_JuminNo,               (select dept.DEPTENGABBR                  from com.zsdddept dept                 where dept.deptcd = a.wardcd                       and dept.instcd = a.instcd                       and dept.valitodd >= a.indd                       and dept.valifromdd <= a.indd) as IO_Ward,               a.roomcd as IO_roomNO,               a.indd as IO_ADdate,               a.dschdd as IO_Dschdd,               a.ordtype as IO_VisitType,               a.orddeptcd as IO_DeptCd,               (select dept.deptengabbr                  from com.zsdddept dept                 where dept.deptcd = a.orddeptcd                       and dept.instcd = a.instcd                       and dept.valitodd >= a.indd                       and dept.valifromdd <= a.indd) as IO_DeptNm,               COM.FN_ZS_GETDEPTNAME(a.instcd, a.orddeptcd, a.indd) AS IO_Dept2,               '' AS IO_OPdeptCd,               '' AS IO_OPdeptNm,               '' AS IO_OPdrNm,               '' AS IO_OPdrId,               (SELECT diag.diagcd                  FROM emr.mmohdiag diag                 WHERE diag.pid = a.pid                       AND diag.orddd = a.indd                       AND diag.cretno = a.cretno                       AND diag.diaghistcd = 'O'                       AND diag.diagtypecd = 'D'                       AND diag.diagkindcdflag = 'M'                       AND diag.genrflagcd = a.ordtype                       AND diag.diaghistno = (select max(diagh.diaghistno)                                          from emr.mmohdiag diagh                                         where diagh.pid = a.pid                                               AND diagh.orddd = a.indd                                               AND diagh.cretno = a.cretno                                               AND diagh.instcd = '111'                                AND diagh.diaghistcd = 'O'                                AND diagh.diagkindcdflag = 'M'                                AND diagh.genrflagcd = a.ordtype                                         group by pid)) as IO_DxCd,               (SELECT term.diaghngnm                  FROM emr.mmohdiag diag,                       emr.mmbvdiag term                 WHERE diag.pid = a.pid                       AND diag.orddd = a.indd                       AND diag.cretno = a.cretno                       AND diag.instcd = term.instcd                       AND diag.diagcd = term.orgdiagcd                       AND diag.diaghistcd = 'O'                       AND diag.diagtypecd = 'D'                       AND diag.diagkindcdflag = 'M'                       AND diag.diagdd >= term.termfromdd                       AND diag.diagdd <= term.termtodd                       AND diag.diagdd >= term.diagattrfromdd                       AND diag.diagdd <= term.diagattrtodd                       AND diag.genrflagcd = a.ordtype                       AND diag.diaghistno = (select max(diagh.diaghistno)                                                from emr.mmohdiag diagh                                               where diagh.pid = a.pid                                                     AND diagh.orddd = a.indd                                                     AND diagh.cretno = a.cretno                                                     AND diagh.instcd = '111'                                      AND diagh.diaghistcd = 'O'                                      AND diagh.diagkindcdflag = 'M'                                      AND diagh.genrflagcd = a.ordtype                                               group by pid)) as IO_DxNm,               a.MEDISPCLID as IO_MaindrId,               COM.FN_ZS_GETUSERNM(a.MEDISPCLID, a.indd) as IO_MaindrNm,               '111' as IO_HosType,               case when ex.bp is null then '02' else ex.bp end as IO_bp,               case when ex.dm is null then '02' else ex.dm end as IO_dm,               case when ex.heart is null then '02' else ex.heart end as IO_heart,               case when ex.kidney is null then '02' else ex.kidney end as IO_kidney,               case when ex.respiration is null then '02' else ex.respiration end as IO_respiration,               case when ex.hx is null then '02' else ex.hx end as  IO_hx,               case when ex.allergy is null then '02' else ex.allergy end as  IO_allergy,               case when ex.drug is null then '02' else ex.drug end as  IO_drug,               case when ex.smoking is null then '02' else ex.smoking end as  IO_smoking,               case when ex.idio is null then '02' else ex.idio end as  IO_idio,               case when ex.nacrotics is null then '02' else ex.nacrotics end as  IO_nacrotics,               case when ex.airway is null then '02' else ex.airway end as  IO_airway,               case when ex.hemorrhage is null then '02' else ex.hemorrhage end as  IO_hemorrhage,               ex.etc IO_status_etc,               '' as IO_OrderNo,               '111' as IO_PrintTime,               a.medispclid as IO_MaindrId,               COM.FN_ZS_GETUSERNM(a.medispclid, a.indd) as IO_MaindrNm,               '111' as IO_OcrCd,               '111' as IO_InputId,               '111' as IO_InputNm,               '111' as IO_SignImg,              a.fstrgstdt          FROM pam.pmihinpt a         left outer join emr.mmohoprs oprs            on (oprs.pid = a.pid and oprs.ophistcd = 'O' and opcnfmdd >= a.indd )         left outer join cmr.consent_data_ex ex            on (ex.pid = a.pid and ex.cln_date = a.indd)         WHERE a.instcd =  :param0                AND a.pid =  :param1                AND a.indd =  :param2                AND a.histstat = 'Y'               AND a.mskind = 'M'                    AND a.cretno =  :param3                    order by a.fstrgstdt desc]

[Logging Date Time: 2016-11-07 17:49:17,016] =====================================================================================
SQL Command - Statement Id: [getPatientInfoIn] Parameters: [param0=[instcd,111], param1=[pid,1845065], param2=[orddd,20161104], param3=[cretno,1]]

[Logging Date Time: 2016-11-07 17:49:17,016] =====================================================================================
SQL Command - Statement Id: [getPatientInfoIn] Parameters: [param0=[instcd,111], param1=[pid,1845065], param2=[orddd,20161104], param3=[cretno,1]]

[Logging Date Time: 2016-11-07 17:49:17,016] =====================================================================================
SQL Command - Statement Id: [getPatientInfoIn] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String]]

[Logging Date Time: 2016-11-07 17:49:17,016] =====================================================================================
SQL Command - Statement Id: [getPatientInfoIn] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String]]

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

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

[Logging Date Time: 2016-11-07 17:49:17,102] =====================================================================================
SQL Command - Statement Id: [getUserSignImage] Parameters: [param0=[userid,104806]]

[Logging Date Time: 2016-11-07 17:49:17,102] =====================================================================================
SQL Command - Statement Id: [getUserSignImage] Parameters: [param0=[userid,104806]]

[Logging Date Time: 2016-11-07 17:49:17,102] =====================================================================================
SQL Command - Statement Id: [getUserSignImage] Types: [param0=[AnsiString, System.String]]

[Logging Date Time: 2016-11-07 17:49:17,102] =====================================================================================
SQL Command - Statement Id: [getUserSignImage] Types: [param0=[AnsiString, System.String]]