PPA3 หญิงตั้งครรภ์ได้รับการดูแลก่อนคลอด 5 ครั้งตามเกณฑ์
ID | 839 |
---|---|
Parent ID | 64 |
Table Name | 65_ppa_5anc_2 |
Title | PPA3 หญิงตั้งครรภ์ได้รับการดูแลก่อนคลอด 5 ครั้งตามเกณฑ์ |
Description | |
Script | #SQL_OPTIONS# PROVIDERS=1 PROVIDER1=43STD PROVIDER1_VALIDATE_TABLES=student,t_person_cid,anc,labor 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:=2022; SET @start_d:=concat(@b_year,'0301'); SET @end_d:=concat(@b_year,'0630'); SELECT l.HOSPCODE,p.check_hosp,p.check_vhid,l.cid,p.`NAME`,p.LNAME,p.BIRTH,l.GRAVIDA,p.age_y,l.bdate bdate_labor,a.bdate bdate_anc,a.g1_date,a.g2_date,a.g3_date,a.g4_date,a.g5_date FROM t_labor l INNER JOIN t_person_cid p ON l.cid=p.cid INNER JOIN chospital h ON p.check_hosp=h.hoscode LEFT JOIN t_person_anc a ON l.cid=a.cid AND l.bdate =a.bdate AND l.GRAVIDA =a.gravida WHERE l.BDATE BETWEEN @start_d AND @end_d AND l.BTYPE NOT IN(6) AND p.check_typearea in(1,3) AND p.nation in(99) AND p.discharge IN(9) ORDER BY l.cid; #PROVIDER1_SQL# |
Script Cron | |
Force Script Cron | 0 |
Active | 1 |
Client Office Type | |
Create Date | 2022-04-01 02:00:36 |
Last Update | 2022-08-02 09:46:44 |
- Home
- About
- Privacy Policy
- Terms of Use
- Contact Us
© 2015. All Rights Reserved.