1.危急值程序,如果程序放门诊,且INI中SFBQ00=N设置不是病区,门诊的危急值程序还是会把病区危急值病人信息提醒,要求门诊提醒门诊,住院提醒住院.

跟踪语句:/* Formatted on 2016/10/19 11:58 (Formatter Plus v4.8.7) */
SELECT ybh000, pyrq00, brxm00, sqbqmc, ch0000, zyhghh, xbmc00, zlxmjc
  FROM vw_jy_yw0000
 WHERE (ybh000, pyrq00) IN (
          SELECT ybh000, pyrq00
            FROM (SELECT DISTINCT ybh000, pyrq00
                             FROM jy_yw0000 a
                            WHERE 1 = 1
                              AND pyrq00 = TO_CHAR (SYSDATE - 1, 'YYYYMMDD')
                              AND jgzt00 IN ('6', '8')
                              AND yxbz00 = 'Y'
                              AND (bgckr0 IS NULL OR bgckr0 = 0)
                              AND (  (  SYSDATE
                                      - TO_DATE (   NVL (cbgrq0, '20140101')
                                                 || ' '
                                                 || NVL (cbgsj0, '10:00:00'),
                                                 'YYYYMMDD HH24:MI:SS'
                                                )
                                     )
                                   * 24
                                   * 60 > 30
                                  )
                              AND NOT EXISTS (
                                     SELECT 1
                                       FROM jy_wjzck0_bz0000
                                      WHERE ybh000 = a.ybh000
                                        AND pyrq00 = a.pyrq00
                                        AND jykbz0 IS NOT NULL)
                  UNION
                  SELECT ybh000, pyrq00
                    FROM (SELECT DISTINCT ybh000, pyrq00
                                     FROM jy_yw0000 a
                                    WHERE 1 = 1
                                      AND pyrq00 =
                                                 TO_CHAR (SYSDATE, 'YYYYMMDD')
                                      AND jgzt00 IN ('6', '8')
                                      AND yxbz00 = 'Y'
                                      AND (bgckr0 IS NULL OR bgckr0 = 0)
                                      AND (  (  SYSDATE
                                              - TO_DATE (   NVL (cbgrq0,
                                                                 '20140101'
                                                                )
                                                         || ' '
                                                         || NVL (cbgsj0,
                                                                 '10:00:00'
                                                                ),
                                                         'YYYYMMDD HH24:MI:SS'
                                                        )
                                             )
                                           * 24
                                           * 60 > 30
                                          )
                                      AND NOT EXISTS (
                                             SELECT 1
                                               FROM jy_wjzck0_bz0000
                                              WHERE ybh000 = a.ybh000
                                                AND pyrq00 = a.pyrq00
                                                AND jykbz0 IS NOT NULL))))
   AND ROWNUM = 1


2.如果有危急值样本号的时候,当程序被最小化,不会弹窗弹出.导致不能及时发现.
3.危急值信息不需要手工去点‘查询’.应该为实时刷新. 
;签收查询刷新时间间隔
QSCXSXSJ=3      现有参数设置这个,没有效果.