3.1 สรุปจำนวนค่ารักษาพยาบาลผู้ป่วยนอก
ID | 805 |
---|---|
Parent ID | 58 |
Table Name | opd_alien |
Title | 3.1 สรุปจำนวนค่ารักษาพยาบาลผู้ป่วยนอก |
Description | |
Script | #SQL_OPTIONS# PROVIDERS=2 PROVIDER1=JHCIS PROVIDER2=HOSXP PROVIDER1_VALIDATE_TABLES=visitanc,visitancpregnancy,visit PROVIDER2_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; /*SQL Script สำหรับ JHCIS เริ่มที่นี่ */ SELECT FROM WHERE ; /*SQL Script สำหรับ JHCIS สิ้นสุดที่นี่ */ #PROVIDER1_SQL# #PROVIDER2_SQL# SET @provid = :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 @provcode = :provcode; SET @level_service = :level_service; /*SQL Script สำหรับ HosXP เริ่มที่นี่ */ SELECT @hoscode as hospcode, @rep_year as rep_year, v.vn, v.income, v.rcpt_money, v.vstdate,v.hn, v.uc_money, v.pdx,v.dx0,v.dx1,v.dx2,v.dx3,v.dx4,v.dx5, #v.income AS "รวมค่าใช้จ่าย",v.uc_money AS "ลูกหนี้สิทธิ",v.remain_money AS "ค้าง", concat(p.pname,p.fname,' ',p.lname) as name,p.citizenship,pttype.oldcode , IF(ert.er_pt_type IN(1,2),o.vn,NULL) AS eropd from vn_stat v left outer join patient p on p.hn=v.hn left outer join ovst o on o.vn=v.vn #left outer join pcode pc on pc.code=v.pcode LEFT JOIN pttype ON pttype.pttype=v.pttype LEFT JOIN er_regist er ON er.vn=o.vn LEFT JOIN er_pt_type ert ON ert.er_pt_type=er.er_pt_type where v.vstdate BETWEEN CONCAT(@rep_year-1,'1001') AND CONCAT(@rep_year,'0930') AND p.citizenship NOT IN(99,00,98) AND pttype.oldcode IN ('01','02','03','04','05','08',13,14,15,16) and v.income > 0 and o.an is null /*AND v.pdx IS NOT NULL*/ group by v.vn ; /*SQL Script สำหรับ HosXP สิ้นสุดที่นี่ */ #PROVIDER2_SQL# |
Script Cron | |
Force Script Cron | 0 |
Active | 1 |
Client Office Type | |
Create Date | 2019-04-23 03:32:12 |
Last Update | 2019-04-23 03:32:12 |
- Home
- About
- Privacy Policy
- Terms of Use
- Contact Us
© 2015. All Rights Reserved.