code View

id 84
Title Various indicators (Events)
Type Database 6.1
Highlight group
Description punctual events that happen on a particular date and are stored in the d_events table
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  date of the event
 event_status  
 ev_vn1  
 ev_vn2  
 usr_INS  
 usr_MOD  
 usr_DATAMOD  

d_events table 

 event_type Description  Event_Status Form associated ev_vn1 ev_vn2 history ? Patch
FIRST-TARV-STAR First start of TARV           X
LAST-TARV-START Last start of TARV           X
2ND-LINE-SWITCH second arv line switch ARV reason code         X
3RD-LINE-SWITCH thirdarv line switch ARV reason switch         X
BMI-PRE-TARV BMI  before start of TARV            
SS-PRE-TARV AIDS stage before TARV     AIDS stage      
CV-PRE-TARV Viral load before start of TARV     CV      
CD4-PRE-TARV CD4 before start TARV     CD4      
HG-PRE-TARV Emoglobina before start TARV     Hemo      
ACC-TRASF-IN if transfered             
RE-ENROLLED IF RE-ENROLLED            
EVN_CNS Teleconsulto note

(in ev_vm1 is saved the link to the online report)		          
SCR_TB Data screening TB POSITIVE
NEGATIVE		 YES   (was True/False) YES  
SCR_HPV Screening Cervical cancer  VIA VILI SCR_HPV_NEG
SCR_HPV_POS
SCR_HPV_SUS
SCR_HPV_INV
SCR_HPV_OTH		 YES     YES  
SCR_PAP PAP smear test   YES     YES  
EVN_CRYOTHERAPY  Cryotherapy

notes as free text

 YES        
SCR_STI Screening MST   YES   True/False YES  
SCR_CRAG Screening CrAg  Cryptococcal Antigen SCR_CRAG_POS
SCR_CRAG_NEG		          
SCR_EPA Screening hepatitis ( HBsAg Test ) SCR_EPA_NEG, SCR_EPA_POS          
SCR_SIF Screening syphilis SCR_SIF_NEG    ,  SCR_SIF_POS          
SCR_NEURO Neurological Screening  SCR_NEURO_POS
SCR_NEURO_NEG		          
SCR_BREASTC Breast Cancer Screening SCR_BREASTC_NORMAL: 1. Normal Scan
SCR_BREASTC_RESCAN:
 2. Suggested Re-Scan
SCR_BREASTC_REFER:
 3. Referred for further management
SCR_BREASTC_CYSTIC:
 4. Cystic Mass/Masses
SCR_BREASTC_FIBROA
 5. Fibroadenoma /Solid mass
SCR_BREASTC_DILATED
 6. Dilated Duct
SCR_BREASTC_GLAND
 7. Glandular Mass		       YES  
EVN_OTHPRS Other Prescription            
EVN_CHRONIC Primary essential hypertension RMCD00000000809          
EVN_CHRONIC Chronic renal failure RMCD00000001224          
EVN_CHRONIC Chronic diabetes RMCD00000000486          
EVN_CHRONIC Asthma RMCD00000000925          
EVN_CHRONIC Epilepsy RMCD00000000677          
               
ALLERGIA Allergy free text          
EVN_PAR Pregnant at registration       True/False    
EVN_ART_KS Kaposi's Sarcoma at ART initiation       True/False    
TB_ART_START TB at ART initiation

TB_ART_START_L2Y = last 2 years

TB_ART_START_N2Y = not in hte last 2 years

TB_ART_START_CURR = currently with TB

          
GRAV-TARV-START Pregnant at ART initiation            
ART_INIT_WOMAN Woman ART initiation ART_INIT_WOMAN_IPP , ART_INIT_WOMAN_ANC, ART_INIT_WOMAN_IPN          
EVN_DIAG_REV hiv + diagnosys reveleation            
EVN_VCN_COVID  Vaccine SARS-Cov-2 EVN_VCN_COVID_1
EVN_VCN_COVID_2
EVN_VCN_COVID_3
(for dose)		          
EVN_CLPSCPY  Colposcopy EVN_CLPSCPY_POS
EVN_CLPSCPY_NEG
EVN_CLPSCPY_SUS (for Suspected)		          

 

Note: indicators which have a beginning and an end are stored in D_status Table:
 
Ordine 480