code View

id 84
Title Various indicators
Type Database 6.1
Highlight group
Description
Code

In D_Events are stored point indicators that occur on a specific date:

D_Events table 
 id_event 
 id_person 
  
 domain  = 'ANAG_EVENT'
 event_type 
 date_event 
 event_status 
 ev_vn1 
 ev_vn2 
 usr_INS 
 usr_MOD 
 usr_DATAMOD 

 

 event_typeDescription Event_Statusev_vn1ev_vn2history ?Patch
FIRST-TARV-STARFirst start of TARV    X
LAST-TARV-STARTLast start of TARV    X
2ND-LINE-SWITCHsecond arv line switch ARVreason code   X
3RD-LINE-SWITCHthirdarv line switch ARVreason switch   X
BMI-PRE-TARVBMI  before start of TARV     
SS-PRE-TARVAIDS stage before TARV AIDS stage   
CV-PRE-TARVViral load before start of TARV CV   
CD4-PRE-TARVCD4 before start TARV CD4   
HG-PRE-TARVEmoglobina before start TARV Hemo   
ACC-TRASF-INif transfered      
EVN_CNSTeleconsultonote

(in ev_vm1 is saved the link to the online report)
    
SCR_TBData screening TB  True/FalseYES 
SCR_HPVData screening HPVSCR_HPV_NEG
SCR_HPV_POS
SCR_HPV_SUS
SCR_HPV_INV
SCR_HPV_OTH
SCR_HPV_OTH|SUSPEITA DE MIOMAS
  YES 
SCR_STIData screening MST  True/FalseYES 
       
EVN_CHRONICIpertensione primaria essenzialeRMCD00000000809    
EVN_CHRONICInsufficenza renale cronicaRMCD00000001224    
EVN_CHRONICDiabete (cronico...)RMCD00000000486    
EVN_CHRONICAsmaRMCD00000000925    
EVN_CHRONICEpilessiaRMCD00000000677    
       
ALLERGIAAllergia free text    
EVN_PARPregnant at registration  True/False  
EVN_ART_KSKaposi's Sarcoma at ART initiation  True/False  
ART_INIT_WOMANWoman ART initiationART_INIT_WOMAN_IPP , ART_INIT_WOMAN_ANC, ART_INIT_WOMAN_IPN    
SCR_EPAScreening epatite  SCR_EPA_NEG, SCR_EPA_POS    
SCR_SIFScreening sifilideSCR_SIF_NEG    ,  SCR_SIF_POS    
TREAT_FLUflunocazolo treatment  True/False  
EVN_CRYOTHERAPYCrioterapiaDLY (if in the same day) | notes    
EVN_OTH_SU_REFVIA - referred0001 (transfer reason) |notes    
EVN_DIAG_REVhiv + diagnosys reveleation     

 

 

 

Note: indicators which have a beginning and an end are stored in D_status Table:
TER_COT, TER_FLU and TBC_PRE_TPI,PAR_3MDELIVERY, PAR_FASTFLOW, PAR_GAAC, PAR_6MDELIVERY 

In D_Status:

D_Status table 
 id_status 
 id_person 
 domain  =  TER_COT, TER_FLU and TBC_PRE_TPI,PAR_3MDELIVERY, PAR_FASTFLOW, PAR_GAAC, PAR_6MDELIVERY
 status  (YES or NO)
 date_started 
 status_type  = 'ANAG_EVENT'
 usr_INS 
 usr_MOD 
 usr_DATAMOD 
 
 event_type Description 
  Status
 history ?
TER_COT Prevention with Cotrimozazole YES or NOYES
TBC_PRE_TPI TB prevention with isoniazide  YES or NOYES
TER_FLU prevention with Fluconazolo YES or NOYES
 BFEED is breastfeeding ? YES or NO ?
PAR_GAAC self help group YES or NO ?
PAR_FASTFLOW fast flow program YES or NO ?
PAR_3MDELIVERY quarterly drug delivery YES or NO ?
PAR_6MDELIVERY six-monthly drug delivery YES or NO ?



 
       
Ordine 480