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

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

Update Delete

ID740
Parent ID50
Table Nameqof62_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 @start_d:=('2019-04-01');
SET @end_d:=('2020-03-31');

CREATE TEMPORARY TABLE IF NOT EXISTS
dent_proc ( INDEX(HOSPCODE,PID) )
ENGINE=MyISAM
AS (
SELECT
p.HOSPCODE,
p.PID,
MAX(p.SEQ) AS SEQ,
MAX(p.DATE_SERV) AS DATE_SERV,
GROUP_CONCAT(p.PROCEDCODE) AS PROCEDCODE
FROM procedure_opd p
INNER JOIN cwh_dent_icd10tm i ON p.PROCEDCODE=i.ICD10TM
WHERE p.DATE_SERV BETWEEN @start_d AND @end_d
and p.PROCEDCODE not in ('2330010','2330011','2330012','2330014','2330020','2330040','2330099','2380010','2339920','2338610','2338611')
GROUP BY p.HOSPCODE,p.PID
);


select
a.hospcode AS HOSPCODE,a.cid, a.PID, b.SEQ , b.DATE_SERV, b.procedcode AS PROCEDCODE, a.TYPEAREA, a.nation, a.check_vhid as areacode
from t_person_cid a
LEFT JOIN dent_proc b on a.HOSPCODE = b.HOSPCODE AND a.pid = b.PID
WHERE
a.NATION='099'
AND a.DISCHARGE = '9'
AND LENGTH(TRIM(a.cid))=13
AND SUBSTR(a.cid,2,1)<>'0'
#AND SUBSTR(a.cid,13,1)= mod11(a.cid)
;

#PROVIDER1_SQL#
Script Cron
Force Script Cron0
Active1
Client Office Type
Create Date2017-02-01 05:44:02
Last Update2020-05-05 11:58:14