ตัดข้อมูลจำนวนเด็ก 9, 18, 30 42 เดือน
ID | 1 |
---|---|
Parent ID | 1 |
Table Name | rep_child_cal_age |
Title | ตัดข้อมูลจำนวนเด็ก 9, 18, 30 42 เดือน |
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; SELECT person.HOSPCODE AS hospcode, CONCAT(chospital.provcode,chospital.distcode,chospital.subdistcode,chospital.mu) as areacode, DATE_FORMAT(DATE(person.BIRTH + INTERVAL 9 MONTH),'%Y%m') 9month_target, DATE_FORMAT(DATE(person.BIRTH + INTERVAL 18 MONTH),'%Y%m') 18month_target, DATE_FORMAT(DATE(person.BIRTH + INTERVAL 30 MONTH),'%Y%m') 30month_target, DATE_FORMAT(DATE(person.BIRTH + INTERVAL 42 MONTH),'%Y%m') 42month_target, COUNT(DISTINCT person.HOSPCODE, person.PID) child_count FROM person LEFT JOIN chospital ON person.HOSPCODE = chospital.hoscode WHERE person.BIRTH > DATE_FORMAT(DATE(NOW() - INTERVAL 4 YEAR),'%Y-%m-01') AND person.TYPEAREA IN ('1','3') AND person.`NATION` = '099' AND person.`DISCHARGE` = '9' AND chospital.`provcode` = @provcode GROUP BY person.HOSPCODE, DATE_FORMAT(DATE(person.BIRTH),'%Y-%m-01'); #PROVIDER1_SQL# |
Script Cron | |
Force Script Cron | 0 |
Active | 1 |
Client Office Type | |
Create Date | 2015-06-04 16:49:10 |
Last Update | 2015-06-10 05:00:13 |
- Home
- About
- Privacy Policy
- Terms of Use
- Contact Us
© 2015. All Rights Reserved.