|
urgent checks - q_uvu
|
snippet
|
|
0
|
|
EVI-CS03 /Active urgent checks
|
evidenza
|
filequery1003.cs, Evidenze
|
|
|
EVI-CS04 /Has the birth taken place? The result is missing!
|
evidenza
|
filequery1003.cs, Evidenze
|
|
|
EVI-CS06 /People with no appointment
|
evidenza
|
filequery1003.cs, Evidenze
|
|
|
EVI-CS07 /Missed appointments over the last 15 days
|
evidenza
|
filequery1003.cs, Evidenze
|
|
|
EVI-CS08 /Patients still being tested
|
evidenza
|
filequery1003.cs, Evidenze
|
|
|
Last status, Last service (at TODAY)
|
snippet
|
|
10
|
|
HIV status
|
snippet
|
|
30
|
|
EVI-CS09 /HIV+ children in PMTCT (Service not changed)
|
evidenza
|
filequery1003.cs, Evidenze
|
|
|
EVI-CS10 / Children PMTCT > 18 months in STDBY
|
evidenza
|
filequery1003.cs, Evidenze
|
|
|
EVI-CS12 / The social form is missing
|
evidenza
|
filequery1003.cs, Evidenze
|
|
|
EVI-CS14 / Patients who died in the last month
|
evidenza
|
filequery1003.cs, Evidenze
|
|
|
EVI-CS15 / Patients in food integration
|
evidenza
|
filequery1003.cs, Evidenze
|
|
|
EVI-CS13 / Patients in ART without ARV drugs prescriptions
|
evidenza
|
filequery1003.cs, Evidenze
|
|
|
EVI-CS01 EVI-CS02 / Lost To Follow Up > 45 , in ART > 30
|
evidenza
|
filequery1003.cs, Evidenze
|
|
|
EVI-CS16 / Patients CCHC in Food Integr. with BMI > 18.5
|
evidenza
|
filequery1003.cs, Evidenze
|
|
|
Last exam Value and date group by id_person
|
snippet
|
|
50
|
|
EVI-CS17 / Patients with sample > 25 days without reply
|
evidenza
|
filequery1003.cs, Evidenze
|
|
|
EVI-CS19 / Patients with adherence to ARV therapy <95%
|
evidenza
|
filequery1003.cs, Evidenze
|
|
|
EVI-CS20 / Last prescription VL older than 12 months
|
evidenza
|
filequery1003.cs, Evidenze
|
|
|
EVI-CS01, EVI-CS02, EVI-CS22, EVI-CS-23 Lost to Follow Up
|
evidenza
|
filequery1003.cs, Evidenze
|
|
|
First start tarv
|
snippet
|
|
40
|
|
HIV inconsistencies
|
snippet
|
|
70
|
|
From Anagrafica to D_Person and D_Person_att
|
Migration 5 to 6
|
|
|
|
From Gravidanze to D_Status e D_Events
|
Migration 5 to 6
|
|
|
|
From TBC to D_Status
|
Migration 5 to 6
|
|
|
|
From StatoIA to D_Status
|
Migration 5 to 6
|
|
|
|
From RegimeAssistenza to D_Status
|
Migration 5 to 6
|
|
|
|
From Servizio to D_Status
|
Migration 5 to 6
|
|
|
|
From TARV to D_Status
|
Migration 5 to 6
|
|
|
|
From HIV a D_Status
|
Migration 5 to 6
|
|
|
|
From Alimentazione to D_Status
|
Migration 5 to 6
|
|
|
|
From TER_COT in Anag_events to D_Status
|
Migration 5 to 6
|
|
|
|
From TBC_PRE_TPI in Anag_events to D_Status
|
Migration 5 to 6
|
|
|
|
From TER_FLU in Anag_events to D_Status
|
Migration 5 to 6
|
|
|
|
From Diaria to D_Events and D_Events_att
|
Migration 5 to 6
|
|
|
|
EVI-CS01
|
evidenza
|
filequery1002.cs, Trattamenti
|
|
|
EVI-CS02
|
evidenza
|
filequery1002.cs, Trattamenti
|
|
|
From anag_events to D_Events and D_Status
|
Migration 5 to 6
|
|
|
|
Last EXAM value for a given id_person
|
snippet
|
|
60
|
|
From AnagSociale to D_Evaluation and D_Evaluation_att
|
Migration 5 to 6
|
|
|
|
Last status, Last service in the period
|
snippet
|
|
20
|
|
From EsamiPrescritti to d_events_att
|
Migration 5 to 6
|
|
|
|
From Esami to d_events_att
|
Migration 5 to 6
|
|
|
|
From EsamiPrescritti Esami e appuntamenti to d_events
|
Migration 5 to 6
|
|
|
|
From Anag_ClinicaStage to D_Evaluations
|
Migration 5 to 6
|
|
|
|
From Appuntamenti to D_events
|
Migration 5 to 6
|
|
|
|
From Diaria_posologia to d_events_att
|
Migration 5 to 6
|
|
|
|
From ConsegnaFarmaci to d_events and d_events_att
|
Migration 5 to 6
|
|
|
|
From NucleoFam to d_person_fam
|
Migration 5 to 6
|
|
|
|
From Assistente to d_reftables
|
Migration 5 to 6
|
|
|
|
From Bairro to d_reftables
|
Migration 5 to 6
|
|
|
|
From Centro_Rifer to d_reftables
|
Migration 5 to 6
|
|
|
|
From Festivita to d_reftables
|
Migration 5 to 6
|
|
|
|
From Diaria_Diagnosi to d_events_att
|
Migration 5 to 6
|
|
|
|
From Diaria_Sintomi to d_events_att
|
Migration 5 to 6
|
|
|
|
Patients in TPI-TARV treatment in the period
|
evidenza
|
filequery1013.cs, Gestione
|
|
|
Patients in TB-TARV treatment in the end period
|
evidenza
|
filequery1013.cs, Gestione
|
|
|
Patients in TPI treatment at the end of the period
|
evidenza
|
filequery1013.cs, Gestione
|
|
|
Patients in TB treatment at eop
|
evidenza
|
filequery1013.cs, Gestione
|
|
|
DREAM 5 --> DREAM 6 Tables
|
Migration 5 to 6
|
|
|
|
Evidences List
|
Migration 5 to 6
|
|
|
|
DettaglioVerifiche to D_Events_att
|
Migration 5 to 6
|
|
|
|
D_Status domains
|
Migration 5 to 6
|
|
|
|
Patient treatments
|
Database 6.1
|
|
20
|
|
Urgent checks details (or Defaulter Tracing)
|
Database 6.1
|
|
500
|
|
Evidences List
|
Database 6.1
|
|
1,000
|
|
DREAM 6 Tables
|
Database 6.1
|
|
0
|
|
Medical visit --> Symptoms
|
Database 6.1
|
|
310
|
|
Medical visit --> Diagnosis
|
Database 6.1
|
|
320
|
|
Medical visit --> Posology
|
Database 6.1
|
|
330
|
|
Medical visit (appointment)
|
Database 6.1
|
|
300
|
|
Appointments
|
Database 6.1
|
|
200
|
|
Drug delivery (appointment)
|
Database 6.1
|
|
550
|
|
AIDS Stage
|
Database 6.1
|
|
600
|
|
Blood tests (appointment)
|
Database 6.1
|
|
400
|
|
Blood tests --> Prescription
|
Database 6.1
|
|
420
|
|
Patient data
|
Database 6.1
|
|
1
|
|
Blood test --> Result
|
Database 6.1
|
|
430
|
|
Medical visit --> Details
|
Database 6.1
|
|
305
|
|
Various indicators (Events)
|
Database 6.1
|
|
480
|
|
Pregnancies
|
Database 6.1
|
|
500
|
|
Social data
|
Database 6.1
|
|
610
|
|
Family
|
Database 6.1
|
|
800
|
|
Public Events
|
Database 6.1
|
|
1,000
|
|
DREAMLAB tables
|
DREAMLab
|
|
1
|
|
DAT_Esami table
|
DREAMLab
|
|
20
|
|
DAT_ConvFact
|
DREAMLab
|
|
|
|
DAT_CentroRifer
|
DREAMLab
|
|
|
|
DAT_dbCodici
|
DREAMLab
|
|
|
|
DB_Info
|
DREAMLab
|
|
|
|
DAT_UdM
|
DREAMLab
|
|
|
|
DAT_DefEsami
|
DREAMLab
|
|
|
|
DAT_EsamiEx
|
DREAMLab
|
|
|
|
Dat_Paziente
|
DREAMLab
|
|
|
|
DAT_Responsabili
|
DREAMLab
|
|
|
|
DAT_Sieroteca
|
DREAMLab
|
|
|
|
DAT_Stampe
|
DREAMLab
|
|
|
|
DAT_tcpip_bridge
|
DREAMLab
|
|
|
|
DREAM_Log
|
DREAMLab
|
|
|
|
DREAM_Users
|
DREAMLab
|
|
|
|
DREAM_Roles
|
DREAMLab
|
|
|
|
Forms
|
Database 6.1
|
|
625
|