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