school
ID | 48 |
---|---|
Parent ID | 35 |
Table Name | school |
Title | school |
Description | Scripts 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 Cron | 0 |
Active | 1 |
Client Office Type | |
Create Date | 2015-08-18 10:24:13 |
Last Update | 2015-08-18 11:52:41 |
- Home
- About
- Privacy Policy
- Terms of Use
- Contact Us
© 2015. All Rights Reserved.