ผู้เบาหวาน
ID | 722 |
---|---|
Parent ID | 38 |
Table Name | dm |
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 Cron | 0 |
Active | 1 |
Client Office Type | |
Create Date | 2016-11-25 05:11:38 |
Last Update | 2016-11-25 05:11:38 |
- Home
- About
- Privacy Policy
- Terms of Use
- Contact Us
© 2015. All Rights Reserved.