ข้อมูล s_elder_help

Update Delete

ID717
Parent ID1
Table Names_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 Cron0
Active1
Client Office Type
Create Date2016-05-13 12:42:13
Last Update2016-05-13 12:42:13