Project

General

Profile

Feature #199

Etiqueta automática 6

Added by Jorge Luiz da Rocha over 12 years ago. Updated about 12 years ago.

Status:
Closed
Priority:
Urgent
Assignee:
Jorge Luiz da Rocha
Target version:
Versão atual
Start date:
10/11/2012
Due date:
% Done:

0%

Componente:
Casos

Description

Título: Ausência de cultura de acompanhamento (1º ao 6º mês)
Casos de TBDR que não tenham registro de culturas de acompanhamento do 1º ao 6º mês.

History

#1 Updated by Jorge Luiz da Rocha over 12 years ago

Somente para casos de TBDR com forma pulmonar ou ambas com cultura de diagnóstico positiva.

#2 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

No dia 24/10 conversaremos sobre essa etiqueta, pori nao entendi com claresa o que é pra ser feito...

#3 Updated by Maurício Dos Santos over 12 years ago

Feito. jorge me passou npo escritorio que é somente para os casos a partir do segundo mes e casos em tratamento.

#4 Updated by Maurício Dos Santos over 12 years ago

exists(select *
from tbcase c
inner join examculture ec on ec.case_id = c.id
where c.state in (1,2)
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+30)
and ecu.datecollected < (ca.iniTreatmentDate+180))
and c.id = a.id)

#5 Updated by Maurício Dos Santos over 12 years ago

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.id not in (select ca.id
from tbcase ca
inner join examculture ecu on ecu.case_id = ca.id
where ecu.datecollected > (ca.iniTreatmentDate+30)
and ecu.datecollected < (ca.iniTreatmentDate+180))
and c.id = a.id)

#6 Updated by Maurício Dos Santos over 12 years ago

  • Status changed from Feedback to Closed

#7 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 30 DAY))
and ecu.datecollected < (DATE_ADD(a.iniTreatmentDate, INTERVAL 180 DAY)))

#8 Updated by Maurício Dos Santos about 12 years ago

  • Status changed from In Progress to Closed

Also available in: Atom PDF