• Home
  • My Scripts
  • QOF 10 การเข้าถึงบริการทันตกรรมในทุกกลุ่มวัย

QOF 10 การเข้าถึงบริการทันตกรรมในทุกกลุ่มวัย

Update Delete

ID789
Parent ID53
Table Name_sk_qof60_kpi10_dental_access
TitleQOF 10 การเข้าถึงบริการทันตกรรมในทุกกลุ่มวัย
Description
Script#SQL_OPTIONS#
PROVIDERS=1
PROVIDER1=43STD
PROVIDER1_VALIDATE_TABLES=accident,admission,anc,appointment
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;

SET @b_year:=(SELECT yearprocess FROM sys_config LIMIT 1);
SET @start_d:=concat(@b_year-1,'-04-01');
SET @end_d:=concat(@b_year,'-03-31');

SELECT
p.HOSPCODE,s.cid, p.PID,p.SEQ,p.DATE_SERV,p.PROCEDCODE ,s.TYPEAREA, s.nation ,s.DISCHARGE
FROM procedure_opd p
INNER JOIN cwh_dent_icd10tm i ON p.PROCEDCODE=i.ICD10TM
INNER JOIN
( SELECT
se.HOSPCODE ,se.pid ,se.SEQ ,se.DATE_SERV ,c.cid, c.TYPEAREA ,c.nation ,c.DISCHARGE
FROM service se
INNER JOIN t_person_cid c on se.HOSPCODE = c.HOSPCODE and se.PID = c.PID
WHERE se.date_serv BETWEEN @start_d AND @end_d
) s ON p.hospcode=s.hospcode AND p.PID = s.PID AND p.SEQ=s.SEQ
WHERE p.date_serv BETWEEN @start_d AND @end_d


#PROVIDER1_SQL#
Script Cron
Force Script Cron0
Active1
Client Office Type
Create Date2017-02-01 05:44:02
Last Update2017-12-27 02:15:37