ข้อมูล s_elder_help
ID | 717 |
---|---|
Parent ID | 1 |
Table Name | s_elder_help |
Title | ข้อมูล s_elder_help |
Description | |
Script | #SQL_OPTIONS# PROVIDERS=1 PROVIDER1=43STD PROVIDER1_VALIDATE_TABLES=accident,admission,anc,appointment SCRIPT_FLOW=SQL #SQL_OPTIONS# #PROVIDER1_SQL# SELECT sp.HOSPCODE AS hospcode, sp.vhid AS areacode, YEAR(sp.DATE_SERV)+543 as b_year, s_pop_sex_age.male_g14+s_pop_sex_age.female_g14 +s_pop_sex_age.male_g15+s_pop_sex_age.female_g15 +s_pop_sex_age.male_g16+s_pop_sex_age.female_g16 +s_pop_sex_age.male_g17+s_pop_sex_age.female_g17 +s_pop_sex_age.male_g18+s_pop_sex_age.female_g18 +s_pop_sex_age.male_g19+s_pop_sex_age.female_g19 +s_pop_sex_age.male_g20+s_pop_sex_age.female_g20 +s_pop_sex_age.male_g21+s_pop_sex_age.female_g21 +s_pop_sex_age.male_g22+s_pop_sex_age.female_g22 AS target, SUM(IF(MONTH(sp.DATE_SERV)= 10,1,0)) as result10, SUM(IF(MONTH(sp.DATE_SERV)= 11,1,0)) as result11, SUM(IF(MONTH(sp.DATE_SERV)= 12,1,0)) as result12, SUM(IF(MONTH(sp.DATE_SERV)= 1,1,0)) as result1, SUM(IF(MONTH(sp.DATE_SERV)= 2,1,0)) as result2, SUM(IF(MONTH(sp.DATE_SERV)= 3,1,0)) as result3, SUM(IF(MONTH(sp.DATE_SERV)= 4,1,0)) as result4, SUM(IF(MONTH(sp.DATE_SERV)= 5,1,0)) as result5, SUM(IF(MONTH(sp.DATE_SERV)= 6,1,0)) as result6, SUM(IF(MONTH(sp.DATE_SERV)= 7,1,0)) as result7, SUM(IF(MONTH(sp.DATE_SERV)= 8,1,0)) as result8, SUM(IF(MONTH(sp.DATE_SERV)= 9,1,0)) as result9, NOW() AS date_com FROM ( SELECT DISTINCT CONCAT(specialpp.HOSPCODE,specialpp.PID), specialpp.HOSPCODE, t_person_cid.vhid, t_person_cid.CID, specialpp.PID, specialpp.DATE_SERV, specialpp.PPSPECIAL, t_person_cid.`NAME`, t_person_cid.LNAME, t_person_cid.SEX, t_person_cid.age_y, t_person_cid.NATION FROM specialpp INNER JOIN t_person_cid ON specialpp.HOSPCODE = t_person_cid.HOSPCODE AND specialpp.PID = t_person_cid.PID WHERE UPPER(specialpp.PPSPECIAL in ('1B1281','1B1282')) AND t_person_cid.age_y >= 60 AND t_person_cid.NATION = '099' #GROUP BY t_person_cid.CID ) AS sp INNER JOIN s_pop_sex_age ON sp.vhid = s_pop_sex_age.areacode AND sp.HOSPCODE=s_pop_sex_age.hospcode AND YEAR(sp.DATE_SERV)+543= s_pop_sex_age.b_year GROUP BY sp.hospcode,sp.vhid,YEAR(sp.DATE_SERV)+543 #PROVIDER1_SQL# |
Script Cron | |
Force Script Cron | 0 |
Active | 1 |
Client Office Type | |
Create Date | 2016-05-13 12:42:13 |
Last Update | 2016-05-13 12:42:13 |
- Home
- About
- Privacy Policy
- Terms of Use
- Contact Us
© 2015. All Rights Reserved.