Feature #200
Etiqueta automática 7
Jorge Luiz da Rocha0%
Description
Título: Ausência de cultura de acompanhamento (7º ao 12º mês)
Casos de TBDR com forma pulmonar ou ambas e cultura de diagnóstico positiva que não tenham registro de culturas de acompanhamento do 7º ao 12º mês.
History
#1
Updated by Maurício Dos Santos over 12 years ago
- Tracker changed from Melhoria to Feature
- Status changed from New to Feedback
- Assignee changed from Maurício Dos Santos to Jorge Luiz da Rocha
Conversamos no dia 24/10 sobre.
#2
Updated by Maurício Dos Santos over 12 years ago
Feito, jorge pediu para considerar apenas casos em tratamento..
exists(select *
from tbcase c
inner join examculture ec on ec.case_id = c.id
where c.state in (1,2)
and c.classification in (1)
and c.infectionSite in (0,2)
and c.id in (select ca.id
from tbcase ca
inner join examculture ecu on ecu.case_id = ca.id
where ecu.datecollected = (select min(datecollected) from examculture where case_id = ca.id)
and ecu.result in (1,2,3,4))
and c.id not in (select ca.id
from tbcase ca
inner join examculture ecu on ecu.case_id = ca.id
where ecu.datecollected > (ca.iniTreatmentDate+181)
and ecu.datecollected < (ca.iniTreatmentDate+360))
and c.id = a.id)
#3
Updated by Maurício Dos Santos over 12 years ago
- Status changed from Feedback to Closed
#4
Updated by Maurício Dos Santos about 12 years ago
- Status changed from Closed to In Progress
classification in (1)
and a.state in (1,2)
and a.infectionSite in (0,2)
and exists (select *
from examculture ec
where ec.case_id = a.id
and ec.dateCollected = (select min(dateCollected) from examculture ec2 where ec2.case_id = ec.case_id)
and ec.result in (1,2,3,4,5))
and not exists(select *
from examculture ecu
where ecu.case_id = a.id
and ecu.datecollected > (DATE_ADD(a.iniTreatmentDate, INTERVAL 181 DAY))
and ecu.datecollected < (DATE_ADD(a.iniTreatmentDate, INTERVAL 360 DAY)))
#5
Updated by Maurício Dos Santos about 12 years ago
- Status changed from In Progress to Closed