ข้อมูลโรงเรียน

Update Delete

ID725
Parent ID40
Table Nameschool
Titleข้อมูลโรงเรียน
Descriptionเก็บข้อมูลโรงเรียนในหน่วยบริการ
Script#SQL_OPTIONS#
PROVIDERS=1
PROVIDER1=HOSXP
PROVIDER1_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
(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 <> '')

;



#PROVIDER1_SQL#

Script Cron
Force Script Cron0
Active1
Client Office Type
Create Date2016-12-14 10:33:32
Last Update2016-12-14 10:33:32