code View

id 40
Title From anag_events to D_Events and D_Status
Type Migration 5 to 6
Highlight group
Description
Code

In D_Events

anag_events in DREAM 5D_Events in DREAM 6
 IdAnagEvents id_event
 IdAnagrafica id_person
  
  domain = 'ANAG_EVENT'
 IdEvent event_type
 DateStart date_event
 EventStatus event_status
 EventVal ev_vn1
 EventB ev_vn2
 usr_INS usr_INS
 usr_MOD usr_MOD
 usr_DATAMOD usr_DATAMOD

Note: TER_COT, TER_FLU and TBC_PRE_TPI,PAR_3MDELIVERY, PAR_FASTFLOW, PAR_GAAC, PAR_6MDELIVERY  moved to D_status

In D_Status:

anag_events in DREAM 5D_Status in DREAM 6
 IdAnagEvents id_status
 IdAnagrafica id_person
 -  domain =  TER_COT, TER_FLU and TBC_PRE_TPI,PAR_3MDELIVERY, PAR_FASTFLOW, PAR_GAAC, PAR_6MDELIVERY
 IdEvent status (YES or NO)
 DateStart date_started
 EventStatus status_type = 'ANAG_EVENT'
 usr_INS usr_INS
 usr_MOD usr_MOD
 usr_DATAMOD usr_DATAMOD

Indicators in ANAG_EVENTS riportati in
d_events and d_status		       
 event_typeDescription  date_started (in d_status) o
date_event (in d_events)		EventStatus -> Event_Status (d_events) o
Status (d_Status)		EventVal -> ev_vn1EventB -> ev_vn2history ?Patch
FIRST-TARV-STARFirst start of TARVd_eventsdate_event    X
LAST-TARV-STARTLast start of TARVd_eventsdate_event    X
2ND-LINE-SWITCHsecond arv line switch ARVd_eventsdate_eventMotivo del passaggio da Global reference   X
3RD-LINE-SWITCHthirdarv line switch ARVd_eventsdate_eventMotivo del passaggio da Global reference   X
BMI-PRE-TARVBMI  before start of TARVd_eventsdate_event BMI   
SS-PRE-TARVAIDS stage before TARVd_eventsdate_event Stadio AIDS   
CV-PRE-TARVViral load before start of TARVd_eventsdate_event CV   
CD4-PRE-TARVCD4 before start TARVd_eventsdate_event CD4   
HG-PRE-TARVEmoglobina before start TARVd_eventsdate_event Hemo   
ACC-TRASF-INif transfered d_eventsdate_event     
TER_COTPrevention with Cotrimozazoled_statusdate_startedStatus : YES or NO True/FalseYES 
TBC_PRE_TPITB prevention with isoniazide d_statusdate_startedStatus : YES or NO True/FalseYES 
TER_FLUprevention with Fluconazolod_statusdate_startedStatus : YES or NO True/FalseYES 
EVN_CNSTeleconsultod_eventsdate_eventAnteporre codice tipologia consulto ( da fare!) | nota Quesito    
 BFEED breastfeeding d_status date_started  Status : YES or NO    
SCR_TBData screening TBd_eventsdate_event  True/FalseYES 
SCR_HPVData screening HPVd_eventsdate_eventSCR_HPV_NEG
SCR_HPV_POS
SCR_HPV_SUS
SCR_HPV_INV
SCR_HPV_OTH
SCR_HPV_OTH|SUSPEITA DE MIOMAS		  YES 
SCR_STIData screening MSTd_eventsdate_event  True/FalseYES 
         
EVN_CHRONICIpertensione primaria essenzialed_eventsdate_eventRMCD00000000809    
EVN_CHRONICInsufficenza renale cronicad_eventsdate_eventRMCD00000001224    
EVN_CHRONICDiabete (cronico...)d_eventsdate_eventRMCD00000000486    
EVN_CHRONICAsmad_eventsdate_eventRMCD00000000925    
EVN_CHRONICEpilessiad_eventsdate_eventRMCD00000000677    
         
ALLERGIAAllergia d_eventsdate_eventfree text    
EVN_PARPregnant at registrationd_eventsdate_event  True/False  
EVN_ART_KSKaposi's Sarcoma at ART initiationd_eventsdate_event  True/False  
ART_INIT_WOMANWoman ART initiationd_eventsdate_eventART_INIT_WOMAN_IPP , ART_INIT_WOMAN_ANC, ART_INIT_WOMAN_IPN    
PAR_GAAC d_statusdate_startedStatus : YES or NO True/False  
PAR_FASTFLOW d_statusdate_startedStatus : YES or NO True/False  
PAR_3MDELIVERY d_statusdate_startedStatus : YES or NO True/False  
PAR_6MDELIVERY d_statusdate_startedStatus : YES or NO True/False  
SCR_EPAScreening epatite  d_eventsdate_eventSCR_EPA_NEG, SCR_EPA_POS    
SCR_SIFScreening sifilided_eventsdate_eventSCR_SIF_NEG    ,  SCR_SIF_POS    
TREAT_FLUtrattamento con flunocazolod_eventsdate_event  True/False  
EVN_CRYOTHERAPYCrioterapia  DLY (if in the same day) | notes    
EVN_OTH_SU_REFVIA - riferito ad altro centro  0001 (motivi del riferimento ad altro centro) |notes    
EVN_DIAG_REVhiv + diagnosys reveleationd_eventsdate_event     

 
Ordine