• Home
  • My Scripts
  • ตรวจความถูกต้องโรคเรื้อรัง

ตรวจความถูกต้องโรคเรื้อรัง

Update Delete

ID43
Parent ID14
Table Namecheck_chronic
Titleตรวจความถูกต้องโรคเรื้อรัง
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
personchronic.pid,
personchronic.chroniccode,
personchronic.datefirstdiag,
personchronic.datedxfirst,
personchronic.typedischart,
personchronic.cup,
personchronic.hospfirstdiag,
personchronic.dateupdate
FROM
personchronic
WHERE
personchronic.chroniccode IS NULL
OR personchronic.datefirstdiag IS NULL
OR personchronic.datedxfirst IS NULL
OR personchronic.hospfirstdiag IS NULL
OR personchronic.cup IS NULL
OR personchronic.typedischart IS NULL
OR personchronic.dateupdate IS NULL
ORDER BY
personchronic.pid;


#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

FROM

WHERE

;

#PROVIDER2_SQL#
Script Cron
Force Script Cron0
Active1
Client Office Type
Create Date2015-06-18 11:36:17
Last Update2015-06-18 01:45:45