| 123456789101112131415161718 |
- [Logging Date Time: 2017-03-02 09:34:26,068] =====================================================================================
- SQL Command - Statement Id: [getErPatList] PreparedStatement : [SELECT distinct inpt.pid as pid, substr(inpt.indd, 1, 4) || '/' || substr(inpt.indd, 5, 2) || '/' || substr(inpt.indd, 7, 2) as indd, inpt.intm, inpt.cretno as cretno, inpt.seqno as seqno, inpt.instcd as instcd, ptbs.hngnm as hngnm, inpt.fsexamflag as fsexamflag, inpt.orddeptcd as orddeptcd, inpt.medispclid as doctorid, 0 as hd, TRIM(ptbs.sex || '/' || LPAD(FLOOR(COM.FN_ZZ_GETAGE_EMR2('000000', '0000000', :param0 , 'B', ptbs.brthdd) / 12), 2, 0) || 'y' || LPAD(MOD(COM.FN_ZZ_GETAGE_EMR2('000000', '0000000', :param0 , 'B', ptbs.brthdd), 12), 2, 0) || 'm') AS sa, dept.depthngnm as deptnm, dept.deptengabbr as deptengabbr, usrb.usernm AS doctornm, dept1.depthngnm as erorddeptnm, usrb1.usernm AS ermedispclnm, inpt.erorddeptcd as erorddeptcd, inpt.ermedispclid as ermedispclid, 'N' as diagnm, 'N' as dschnoti, inpt.roomcd as roomcd, 'N' as cnst, inpt.ordtype as ordtype, (SELECT z.cdnm FROM com.zbcmcode z WHERE inpt.insukind = z.cdid AND z.cdgrupid = 'P0008' AND inpt.indd BETWEEN z.valifromdd AND z.valitodd) AS bostyle, inpt.badcd FROM pam.pmihinpt inpt LEFT OUTER JOIN com.zsumusrb usrb ON inpt.medispclid = usrb.userid AND :param0 >= usrb.userfromdd AND :param0 <= usrb.usertodd LEFT OUTER JOIN com.zsdddept dept ON inpt.orddeptcd = dept.deptcd AND :param0 >= dept.valifromdd AND :param0 <= dept.valitodd AND inpt.instcd = dept.instcd LEFT OUTER JOIN com.zsumusrb usrb1 ON inpt.ermedispclid = usrb1.userid AND :param0 >= usrb1.userfromdd AND :param0 <= usrb1.usertodd LEFT OUTER JOIN com.zsdddept dept1 ON inpt.erorddeptcd = dept1.deptcd AND :param0 >= dept1.valifromdd AND :param0 <= dept1.valitodd AND inpt.instcd = dept1.instcd, pam.pmihicdr icdr, pam.pmcmptbs ptbs WHERE inpt.histstat = 'Y' AND inpt.mskind = 'M' AND inpt.indd <= :param0 AND inpt.instcd = '111' AND icdr.ordtype = 'E' AND inpt.pid = icdr.pid AND inpt.indd = icdr.indd AND inpt.cretno = icdr.cretno AND inpt.instcd = icdr.instcd AND inpt.histstat = icdr.histstat AND :param0 >= icdr.fromdd AND :param0 <= icdr.todd AND inpt.pid = ptbs.pid AND inpt.instcd = ptbs.instcd order by indd desc, intm desc, hngnm asc]
- [Logging Date Time: 2017-03-02 09:34:26,068] =====================================================================================
- SQL Command - Statement Id: [getErPatList] PreparedStatement : [SELECT distinct inpt.pid as pid, substr(inpt.indd, 1, 4) || '/' || substr(inpt.indd, 5, 2) || '/' || substr(inpt.indd, 7, 2) as indd, inpt.intm, inpt.cretno as cretno, inpt.seqno as seqno, inpt.instcd as instcd, ptbs.hngnm as hngnm, inpt.fsexamflag as fsexamflag, inpt.orddeptcd as orddeptcd, inpt.medispclid as doctorid, 0 as hd, TRIM(ptbs.sex || '/' || LPAD(FLOOR(COM.FN_ZZ_GETAGE_EMR2('000000', '0000000', :param0 , 'B', ptbs.brthdd) / 12), 2, 0) || 'y' || LPAD(MOD(COM.FN_ZZ_GETAGE_EMR2('000000', '0000000', :param0 , 'B', ptbs.brthdd), 12), 2, 0) || 'm') AS sa, dept.depthngnm as deptnm, dept.deptengabbr as deptengabbr, usrb.usernm AS doctornm, dept1.depthngnm as erorddeptnm, usrb1.usernm AS ermedispclnm, inpt.erorddeptcd as erorddeptcd, inpt.ermedispclid as ermedispclid, 'N' as diagnm, 'N' as dschnoti, inpt.roomcd as roomcd, 'N' as cnst, inpt.ordtype as ordtype, (SELECT z.cdnm FROM com.zbcmcode z WHERE inpt.insukind = z.cdid AND z.cdgrupid = 'P0008' AND inpt.indd BETWEEN z.valifromdd AND z.valitodd) AS bostyle, inpt.badcd FROM pam.pmihinpt inpt LEFT OUTER JOIN com.zsumusrb usrb ON inpt.medispclid = usrb.userid AND :param0 >= usrb.userfromdd AND :param0 <= usrb.usertodd LEFT OUTER JOIN com.zsdddept dept ON inpt.orddeptcd = dept.deptcd AND :param0 >= dept.valifromdd AND :param0 <= dept.valitodd AND inpt.instcd = dept.instcd LEFT OUTER JOIN com.zsumusrb usrb1 ON inpt.ermedispclid = usrb1.userid AND :param0 >= usrb1.userfromdd AND :param0 <= usrb1.usertodd LEFT OUTER JOIN com.zsdddept dept1 ON inpt.erorddeptcd = dept1.deptcd AND :param0 >= dept1.valifromdd AND :param0 <= dept1.valitodd AND inpt.instcd = dept1.instcd, pam.pmihicdr icdr, pam.pmcmptbs ptbs WHERE inpt.histstat = 'Y' AND inpt.mskind = 'M' AND inpt.indd <= :param0 AND inpt.instcd = '111' AND icdr.ordtype = 'E' AND inpt.pid = icdr.pid AND inpt.indd = icdr.indd AND inpt.cretno = icdr.cretno AND inpt.instcd = icdr.instcd AND inpt.histstat = icdr.histstat AND :param0 >= icdr.fromdd AND :param0 <= icdr.todd AND inpt.pid = ptbs.pid AND inpt.instcd = ptbs.instcd order by indd desc, intm desc, hngnm asc]
- [Logging Date Time: 2017-03-02 09:34:26,213] =====================================================================================
- SQL Command - Statement Id: [getErPatList] Parameters: [param0=[srchdd,20170302]]
- [Logging Date Time: 2017-03-02 09:34:26,213] =====================================================================================
- SQL Command - Statement Id: [getErPatList] Parameters: [param0=[srchdd,20170302]]
- [Logging Date Time: 2017-03-02 09:34:26,213] =====================================================================================
- SQL Command - Statement Id: [getErPatList] Types: [param0=[AnsiString, System.String]]
- [Logging Date Time: 2017-03-02 09:34:26,213] =====================================================================================
- SQL Command - Statement Id: [getErPatList] Types: [param0=[AnsiString, System.String]]
|
