7c.2 การตรวจสอบคุณภาพข้อมูลการให้บริการ
ID | 728 |
---|---|
Parent ID | 42 |
Table Name | cc_service_7c2 |
Title | 7c.2 การตรวจสอบคุณภาพข้อมูลการให้บริการ |
Description | |
Script | #SQL_OPTIONS# PROVIDERS=1 PROVIDER1=hosxp PROVIDER1_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 (SELECT hospitalcode FROM opdconfig) as hospcode ,pa.hn as hn ,pa.pname as pname ,pa.fname as fname ,pa.lname as lname ,vn.age_y as age ,vn.pdx as pdx ,opd.vstdate as vstdate ,opd.cc as cc FROM opdscreen opd LEFT JOIN patient pa ON pa.hn=opd.hn LEFT JOIN vn_stat vn ON vn.vn=opd.vn WHERE opd.vstdate BETWEEN '2015-01-10' AND '2016-09-30' limit 10000 #PROVIDER1_SQL# |
Script Cron | |
Force Script Cron | 0 |
Active | 1 |
Client Office Type | |
Create Date | 2016-12-14 01:31:16 |
Last Update | 2016-12-14 03:19:48 |
- Home
- About
- Privacy Policy
- Terms of Use
- Contact Us
© 2015. All Rights Reserved.