school

Update Delete

ID48
Parent ID35
Table Nameschool
Titleschool
DescriptionScripts extract table name School to provide information about the school in responsibility area.
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
pcucode AS HOSPCODE,
villcode AS VID,
CONCAT(villcode,schoolno) AS SCHOOLCODE,
schoolname AS SCHOOLNAME,
NULL AS SCHOOLOWNER,
NULL AS SCHOOLTYPE,
NULL AS CLOSEDDATE,
dateupdate AS D_UPDATE
FROM villageschool vsc
WHERE RIGHT(villcode,2) <> '00'

;


#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,
v.village_code AS VID,
CONCAT(v.village_code,vs.village_school_id) AS SCHOOLCODE,
vs.school_name AS SCHOOLNAME,
NULL AS SCHOOLOWNER,
NULL AS SCHOOLTYPE,
NULL AS CLOSEDDATE,
v.entry_datetime AS D_UPDATE
FROM village_school vs
INNER JOIN village v ON v.village_id = vs.village_id
WHERE RIGHT(v.village_code,2) <> '00'
AND (vs.school_name IS NOT NULL OR vs.school_name <> '')

;


#PROVIDER2_SQL#
Script Cron
Force Script Cron0
Active1
Client Office Type
Create Date2015-08-18 10:24:13
Last Update2015-08-18 11:52:41