ผลการดำเนินงาน CA Colon
ID | 799 |
---|---|
Parent ID | 1 |
Table Name | t_fit_test_cid |
Title | ผลการดำเนินงาน CA Colon |
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:=2018; SELECT t.hospcode AS HOSPCODE ,t.date_serv AS DATE_SERVE_FIT,t.PPSPECIAL,t.cid AS CID,t.BIRTH, t.SEX, t.check_typearea AS TYPEAREA, t.check_vhid AS VHID, t.NATION, t.instype AS INSTYPE ,t.main AS HMAIN ,c.HOSPCODE AS PROC_HOSPCODE , c.DATE_SERV AS PROC_DATE_SERVE, c.r_code AS R_CODE, c.r_date AS R_DATE ,c.source AS SOURCE,c.PROCEDCODE ,c.result AS RESULT FROM t_fit_test_cid t INNER JOIN t_person_db p ON t.hospcode=p.hospcode AND t.pid=p.pid LEFT JOIN tmp_colonoscopy c ON t.cid=c.cid WHERE t.PPSPECIAL IN('1B0060','1B0061') AND t.DATE_SERV BETWEEN '20180115' AND '20180930' AND t.HOSPCODE=t.PPSPLACE #PROVIDER1_SQL# |
Script Cron | |
Force Script Cron | 0 |
Active | 1 |
Client Office Type | |
Create Date | 2018-07-04 09:12:16 |
Last Update | 2018-07-04 09:12:16 |
- Home
- About
- Privacy Policy
- Terms of Use
- Contact Us
© 2015. All Rights Reserved.