รายงาน Demo2

Update Delete

ID802
Parent ID56
Table Namedemo2
Titleรายงาน Demo2
Description
Script#SQL_OPTIONS#
PROVIDERS=2
PROVIDER1=JHCIS
PROVIDER2=HOSXP
PROVIDER1_VALIDATE_TABLES=accident,admission,anc,appointment
PROVIDER2_VALIDATE_TABLES=person_anc_service,ovst,ovst_seq
SCRIPT_FLOW=SQL
#SQL_OPTIONS#

#PROVIDER1_SQL#


SET @provcode = :provcode;
SET @rep_year = :rep_year;
SET @hoscode = :hoscode;
SET @hosname = :hosname;
SET @hostype = :hostype;
SET @address = :address;
SET @subdistcode = :subdistcode;
SET @distcode = :distcode;
SET @level_service = :level_service;

SELECT *
FROM t_envocc e
INNER JOIN t_person_cid p ON e.CID=p.CID
WHERE (SUBSTR(DIAGCODE,1,3) BETWEEN 'M00' AND 'M99' OR SUBSTR(DIAGCODE,1,3) IN('G56'))
AND e.HOSPCODE ='02485'
AND e.flag_y96 IN(1)
AND DATE_SERV BETWEEN '2017-01-01' AND '2018-06-09'
AND p.check_typearea in(1,3) AND p.NATION in(99)
AND (p.DISCHARGE in(2,3,9) OR (p.DISCHARGE in(1) AND p.DDISCHARGE BETWEEN '2017-10-01' AND '2018-09-30'))
AND TIMESTAMPDIFF(year,p.birth,CONCAT('2017-10-01')) BETWEEN 0 AND 199


#PROVIDER1_SQL#


#PROVIDER2_SQL#
SET @provcode = :provcode;
SET @rep_year = :rep_year;
SET @hoscode = :hoscode;
SET @hosname = :hosname;
SET @hostype = :hostype;
SET @address = :address;
SET @subdistcode = :subdistcode;
SET @distcode = :distcode;
SET @level_service = :level_service;


/*SQL Script สำหรับ HosXP เริ่มที่นี่ */
SELECT

FROM

WHERE
;
/*SQL Script สำหรับ HosXP สิ้นสุดที่นี่ */

#PROVIDER2_SQL#
Script Cron
Force Script Cron0
Active1
Client Office Type
Create Date2018-08-08 02:28:21
Last Update2018-08-08 02:34:01