script_test_10869

Update Delete

ID19
Parent ID11
Table Namerep_opd_visit
Titlescript_test_10869
Description
Script#SQL_OPTIONS#
PROVIDERS=2
PROVIDER1=JHCIS
PROVIDER2=HOSXP
PROVIDER1_VALIDATE_TABLES=visitanc,visitancpregnancy,visit
PROVIDER2_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;

SELECT
v.pcucode hospcode,
MONTHNAME(v.visitdate) visitmonth,
@rep_year visityear,
COUNT(1) visitcount
FROM
visit v
WHERE
v.visitdate BETWEEN CONCAT((@rep_year-1),'-10-01') AND CONCAT(@rep_year,'-09-30')
GROUP BY
MONTH(v.visitdate)
;

#PROVIDER1_SQL#

#PROVIDER2_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 (select hospitalcode from opdconfig) as hospcode,
monthname(vstdate) as visitmonth,
year(vstdate) as visityear,
count(vn) as visitcount

FROM ovst
GROUP BY month(vstdate),year(vstdate)
ORDER BY year(vstdate) desc, month(vstdate) desc
;

#PROVIDER2_SQL#
Script Cron
Force Script Cron0
Active1
Client Office Type
Create Date2015-06-12 11:25:17
Last Update2015-06-12 12:09:14