| 123456789101112131415161718 |
- [Logging Date Time: 2019-06-04 15:53:05,665] =====================================================================================
- SQL Command - Statement Id: [getInPatList] PreparedStatement : [SELECT DISTINCT ptbs.pid , SUBSTR(inpt.indd, 1, 4) || '/' || SUBSTR(inpt.indd, 5, 2) || '/' || SUBSTR(inpt.indd, 7, 2) AS indd , inpt.indd AS orddd , inpt.cretno , inpt.seqno , inpt.instcd , ptbs.hngnm , ( SELECT code.cdnm FROM com.zbcmcode code WHERE code.cdgrupid = 'P0021' AND code.cdid = inpt.fsexamflag AND inpt.indd BETWEEN code.valifromdd AND code.valitodd ) AS fsexamflag , /*+ INDEX_DESC(icdr ix_pmihicdr_03) */ icdr.orddeptcd AS orddeptcd , icdr.medispclid AS doctorid , TO_DATE( :param0 ) - TO_DATE(inpt.indd) AS hd , TRIM(ptbs.sex || '/' || COM.FN_ZZ_GETAGE_EMR(ptbs.rrgstno1, ptbs.rrgstno2, inpt.indd, 'B', ptbs.brthdd)) AS sa , dept.depthngnm AS deptnm , dept.deptengabbr , NVL(( SELECT usernm FROM EMA.VW_COM_ZSUMUSRB WHERE userid = icdr.medispclid AND userfromdd <= :param0 AND usertodd >= :param0 ), '-') AS doctornm , ( SELECT term.termengnm FROM emr.mmohdiag diag , emr.mrtmterm term WHERE diag.diagcd = term.termcd AND diag.instcd = term.instcd AND diag.diagdd >= term.termfromdd AND diag.diagdd <= term.termtodd AND diag.pid = inpt.pid AND diag.orddd = inpt.indd AND diag.cretno = inpt.cretno AND diag.orddeptcd = icdr.orddeptcd AND diag.instcd = inpt.instcd AND diag.diaghistcd = 'O' AND diag.diagtypecd = 'D' AND diag.diagkindcdflag = 'M' AND ROWNUM = 1 ) AS diagnm , CASE inpt.indschacptstat WHEN 'D' THEN '퇴원' WHEN 'T' THEN '가퇴원' ELSE CASE inpt.dschnotiyn WHEN 'Y' THEN '퇴원통보' ELSE CASE inpt.dschdclrtyn WHEN 'Y' THEN '퇴원예고' ELSE '-' END END END AS dschnoti , icdr.roomcd , CASE WHEN ( SELECT COUNT(1) FROM emr.mmrhcnstinfo WHERE pid = inpt.pid AND orddd = inpt.indd AND cretno = inpt.cretno AND reqdd = :param0 AND chosflag IN ('I','E') AND cnstflag IN ('1','2') AND ROWNUM = 1 ) > 0 THEN 'Y' ELSE 'N' END AS cnst , icdr.ordtype AS ordtype , ( SELECT z.cdnm FROM com.zbcmcode z WHERE z.cdgrupid = 'P0008' AND inpt.insukind = z.cdid AND inpt.indd BETWEEN z.valifromdd AND z.valitodd ) AS bostyle , 'N' AS elbulbodstat , 'N' AS ordtm , DECODE(icdr.indschacptstat, 'A', 'Y', 'N') AS admsyn FROM pam.pmihinpt inpt , pam.pmihicdr icdr , com.zsdddept dept , ema.vw_pam_pmcmptbs ptbs WHERE inpt.instcd = :param1 AND inpt.mskind = 'M' AND inpt.histstat = 'Y' AND inpt.pid = :param2 AND CASE WHEN ( SELECT orddeptkind FROM com.zsdddept WHERE instcd = :param1 AND :param0 BETWEEN valifromdd AND valitodd AND deptcd = :param3 ) = 'D' AND inpt.orddeptcd = :param3 THEN 'Y' WHEN ( SELECT orddeptkind FROM com.zsdddept WHERE instcd = :param1 AND :param0 BETWEEN valifromdd AND valitodd AND deptcd = :param3 ) = 'C' AND inpt.centcd = :param3 THEN 'Y' ELSE 'N' END = 'Y' AND icdr.instcd = inpt.instcd AND icdr.pid = inpt.pid AND icdr.indd = inpt.indd AND icdr.cretno = inpt.cretno AND icdr.histstat = inpt.histstat AND :param0 BETWEEN icdr.fromdd AND icdr.todd AND icdr.ordtype IN ('I', 'D', 'E') AND icdr.wardcd = :param4 AND icdr.indschacptstat IN ('A', 'D', 'T') AND ptbs.instcd = icdr.instcd AND ptbs.pid = icdr.pid AND dept.instcd = icdr.instcd AND dept.deptcd = icdr.orddeptcd AND dept.orddeptflag = 'D' AND dept.orduseyn = 'Y' AND inpt.indd BETWEEN dept.valifromdd AND dept.valitodd ORDER BY roomcd, ptbs.hngnm, inpt.indd DESC, inpt.cretno DESC]
- [Logging Date Time: 2019-06-04 15:53:05,665] =====================================================================================
- SQL Command - Statement Id: [getInPatList] PreparedStatement : [SELECT DISTINCT ptbs.pid , SUBSTR(inpt.indd, 1, 4) || '/' || SUBSTR(inpt.indd, 5, 2) || '/' || SUBSTR(inpt.indd, 7, 2) AS indd , inpt.indd AS orddd , inpt.cretno , inpt.seqno , inpt.instcd , ptbs.hngnm , ( SELECT code.cdnm FROM com.zbcmcode code WHERE code.cdgrupid = 'P0021' AND code.cdid = inpt.fsexamflag AND inpt.indd BETWEEN code.valifromdd AND code.valitodd ) AS fsexamflag , /*+ INDEX_DESC(icdr ix_pmihicdr_03) */ icdr.orddeptcd AS orddeptcd , icdr.medispclid AS doctorid , TO_DATE( :param0 ) - TO_DATE(inpt.indd) AS hd , TRIM(ptbs.sex || '/' || COM.FN_ZZ_GETAGE_EMR(ptbs.rrgstno1, ptbs.rrgstno2, inpt.indd, 'B', ptbs.brthdd)) AS sa , dept.depthngnm AS deptnm , dept.deptengabbr , NVL(( SELECT usernm FROM EMA.VW_COM_ZSUMUSRB WHERE userid = icdr.medispclid AND userfromdd <= :param0 AND usertodd >= :param0 ), '-') AS doctornm , ( SELECT term.termengnm FROM emr.mmohdiag diag , emr.mrtmterm term WHERE diag.diagcd = term.termcd AND diag.instcd = term.instcd AND diag.diagdd >= term.termfromdd AND diag.diagdd <= term.termtodd AND diag.pid = inpt.pid AND diag.orddd = inpt.indd AND diag.cretno = inpt.cretno AND diag.orddeptcd = icdr.orddeptcd AND diag.instcd = inpt.instcd AND diag.diaghistcd = 'O' AND diag.diagtypecd = 'D' AND diag.diagkindcdflag = 'M' AND ROWNUM = 1 ) AS diagnm , CASE inpt.indschacptstat WHEN 'D' THEN '퇴원' WHEN 'T' THEN '가퇴원' ELSE CASE inpt.dschnotiyn WHEN 'Y' THEN '퇴원통보' ELSE CASE inpt.dschdclrtyn WHEN 'Y' THEN '퇴원예고' ELSE '-' END END END AS dschnoti , icdr.roomcd , CASE WHEN ( SELECT COUNT(1) FROM emr.mmrhcnstinfo WHERE pid = inpt.pid AND orddd = inpt.indd AND cretno = inpt.cretno AND reqdd = :param0 AND chosflag IN ('I','E') AND cnstflag IN ('1','2') AND ROWNUM = 1 ) > 0 THEN 'Y' ELSE 'N' END AS cnst , icdr.ordtype AS ordtype , ( SELECT z.cdnm FROM com.zbcmcode z WHERE z.cdgrupid = 'P0008' AND inpt.insukind = z.cdid AND inpt.indd BETWEEN z.valifromdd AND z.valitodd ) AS bostyle , 'N' AS elbulbodstat , 'N' AS ordtm , DECODE(icdr.indschacptstat, 'A', 'Y', 'N') AS admsyn FROM pam.pmihinpt inpt , pam.pmihicdr icdr , com.zsdddept dept , ema.vw_pam_pmcmptbs ptbs WHERE inpt.instcd = :param1 AND inpt.mskind = 'M' AND inpt.histstat = 'Y' AND inpt.pid = :param2 AND CASE WHEN ( SELECT orddeptkind FROM com.zsdddept WHERE instcd = :param1 AND :param0 BETWEEN valifromdd AND valitodd AND deptcd = :param3 ) = 'D' AND inpt.orddeptcd = :param3 THEN 'Y' WHEN ( SELECT orddeptkind FROM com.zsdddept WHERE instcd = :param1 AND :param0 BETWEEN valifromdd AND valitodd AND deptcd = :param3 ) = 'C' AND inpt.centcd = :param3 THEN 'Y' ELSE 'N' END = 'Y' AND icdr.instcd = inpt.instcd AND icdr.pid = inpt.pid AND icdr.indd = inpt.indd AND icdr.cretno = inpt.cretno AND icdr.histstat = inpt.histstat AND :param0 BETWEEN icdr.fromdd AND icdr.todd AND icdr.ordtype IN ('I', 'D', 'E') AND icdr.wardcd = :param4 AND icdr.indschacptstat IN ('A', 'D', 'T') AND ptbs.instcd = icdr.instcd AND ptbs.pid = icdr.pid AND dept.instcd = icdr.instcd AND dept.deptcd = icdr.orddeptcd AND dept.orddeptflag = 'D' AND dept.orduseyn = 'Y' AND inpt.indd BETWEEN dept.valifromdd AND dept.valitodd ORDER BY roomcd, ptbs.hngnm, inpt.indd DESC, inpt.cretno DESC]
- [Logging Date Time: 2019-06-04 15:53:05,684] =====================================================================================
- SQL Command - Statement Id: [getInPatList] Parameters: [param0=[srchdd,1432], param1=[instcd,1234], param2=[pid,2143], param3=[orddeptcd,1324], param4=[wardcd,43124]]
- [Logging Date Time: 2019-06-04 15:53:05,684] =====================================================================================
- SQL Command - Statement Id: [getInPatList] Parameters: [param0=[srchdd,1432], param1=[instcd,1234], param2=[pid,2143], param3=[orddeptcd,1324], param4=[wardcd,43124]]
- [Logging Date Time: 2019-06-04 15:53:05,684] =====================================================================================
- SQL Command - Statement Id: [getInPatList] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String]]
- [Logging Date Time: 2019-06-04 15:53:05,684] =====================================================================================
- SQL Command - Statement Id: [getInPatList] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String]]
|
