ผลการดำเนินงาน CA Colon

Update Delete

ID799
Parent ID1
Table Namet_fit_test_cid
Titleผลการดำเนินงาน CA Colon
Description
Script#SQL_OPTIONS#
PROVIDERS=1
PROVIDER1=43STD
PROVIDER1_VALIDATE_TABLES=accident,admission,anc,appointment
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;

SET @b_year:=2018;


SELECT
t.hospcode AS HOSPCODE
,t.date_serv AS DATE_SERVE_FIT,t.PPSPECIAL,t.cid AS CID,t.BIRTH, t.SEX, t.check_typearea AS TYPEAREA, t.check_vhid AS VHID, t.NATION, t.instype AS INSTYPE
,t.main AS HMAIN
,c.HOSPCODE AS PROC_HOSPCODE , c.DATE_SERV AS PROC_DATE_SERVE, c.r_code AS R_CODE, c.r_date AS R_DATE
,c.source AS SOURCE,c.PROCEDCODE
,c.result AS RESULT
FROM
t_fit_test_cid t
INNER JOIN t_person_db p ON t.hospcode=p.hospcode AND t.pid=p.pid
LEFT JOIN tmp_colonoscopy c ON t.cid=c.cid
WHERE t.PPSPECIAL IN('1B0060','1B0061')
AND t.DATE_SERV BETWEEN '20180115' AND '20180930' AND t.HOSPCODE=t.PPSPLACE


#PROVIDER1_SQL#

Script Cron
Force Script Cron0
Active1
Client Office Type
Create Date2018-07-04 09:12:16
Last Update2018-07-04 09:12:16