ผู้เบาหวาน

Update Delete

ID722
Parent ID38
Table Namedm
Titleผู้เบาหวาน
Description
Script#SQL_OPTIONS#
PROVIDERS=1
PROVIDER1=HOSXP
PROVIDER1_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;

/*SQL Script สำหรับ JHCIS เริ่มที่นี่ */
SET @ds1 := '2016-10-01';
SET @ds2 := '2016-10-31';

SELECT
o.hn,
o.vn,
o.an,
pt.pname,
pt.fname,
pt.lname,
TIMESTAMPDIFF(YEAR,pt.birthday,o.vstdate) as age_y,
o.vstdate,
o.vsttime,
o.spclty,
k.department as department,
IF(IFNULL(ds.feel_depression_2_week,'N') <> 'N' OR IFNULL(ds.feel_boring_2_week,'N') <> 'N' OR IFNULL(ds.no_depression,'N') <> 'N','Y','N') as 2Q_test,
IF(IFNULL(ds.feel_depression_2_week,'N') <> 'N','Y','N') as 2Q_depress,
IF(
ds.score_9q_1 > 0
or ds.score_9q_2 > 0
or ds.score_9q_3 > 0
or ds.score_9q_4 > 0
or ds.score_9q_5 > 0
or ds.score_9q_6 > 0
or ds.score_9q_7 > 0
or ds.score_9q_8 > 0
or ds.score_9q_9 > 0

,'Y','N') as 9Q_test,

ds.depression_screen_id,
ds.vn,
ds.staff,
ds.screen_datetime,
ds.feel_depression_2_week,
ds.feel_boring_2_week,
ds.depression_score,
ds.depression_screen_evaluate_id,
ds.suicide_score,
ds.suicide_screen_evaluate_id,
ds.patient_depression_id,
ds.score_9q_1,
ds.score_9q_2,
ds.score_9q_3,
ds.score_9q_4,
ds.score_9q_5,
ds.score_9q_6,
ds.score_9q_7,
ds.score_9q_8,
ds.score_9q_9,
ds.score_8q_1,
ds.score_8q_2,
ds.score_8q_3,
ds.score_8q_4,
ds.score_8q_5,
ds.score_8q_6,
ds.score_8q_7,
ds.score_8q_8,
ds.score_8q_9,
ds.no_depression,
ds.hos_guid,
ds.dep

FROM depression_screen ds
INNER JOIN ovst o ON o.vn = ds.vn
LEFT JOIN patient pt ON pt.hn = o.hn
LEFT JOIN kskdepartment k ON k.depcode = o.main_dep
where o.vstdate BETWEEN @ds1 AND @ds2
;
/*SQL Script สำหรับ JHCIS สิ้นสุดที่นี่ */


#PROVIDER1_SQL#


Script Cron
Force Script Cron0
Active1
Client Office Type
Create Date2016-11-25 05:11:38
Last Update2016-11-25 05:11:38