QOF 10 การเข้าถึงบริการทันตกรรมในทุกกลุ่มวัย
ID | 740 |
---|---|
Parent ID | 50 |
Table Name | qof62_kpi10_dental_access |
Title | QOF 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 Cron | 0 |
Active | 1 |
Client Office Type | |
Create Date | 2017-02-01 05:44:02 |
Last Update | 2020-05-05 11:58:14 |
- Home
- About
- Privacy Policy
- Terms of Use
- Contact Us
© 2015. All Rights Reserved.