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  
 ev_vt1  id_event rapid test
 usr_INS  
 usr_MOD  
 usr_DATAMOD  

d_events table 

 event_type Description  Event_Status Form associated Multi Value ev_vn1 ev_vn2  ev_vt1 history ? Readonly Patch
FIRST-TARV-STAR  First start of TARV (date_event)                YES X
LAST-TARV-START  Last start of TARV (date_event)                YES X
2ND-LINE-SWITCH  Second arv line switch ARV  reason code              YES X
3RD-LINE-SWITCH  Third arv line switch ARV  reason switch              YES X
BMI-PRE-TARV  BMI  before start of TARV                YES  
SS-PRE-TARV  AIDS stage before TARV       AIDS stage        YES  
CV-PRE-TARV  Viral load before start of TARV       CV        YES  
CD4-PRE-TARV  CD4 before start TARV       CD4        YES  
HG-PRE-TARV  Emoglobina before start TARV       Hemo        YES  
 ACC-TRASF-IN IF TRANSFER IN                YES  
 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          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        YES    
 SCR_PAP  PAP smear test SCR_PAP_POS
SCR_PAP_NEG
SCR_PAP_INV
 YES  YES        YES    
 EVN_CRYOTHERAPY   Cryotherapy for cervical cancer  free note text   YES              
 SCR_STI  Screening MST POSITIVE
NEGATIVE
 YES          YES    
 SCR_CRAG  Screening CrAg  Cryptococcal Antigen SCR_CRAG_POS
SCR_CRAG_NEG
SCR_CRAG_INV
   YES      id_event rapid test      
 SCR_EPA  Screening hepatitis ( HBsAg Test ) SCR_EPA_NEG, SCR_EPA_POS
SCR_EPA_IND
SCR_EPA_INV
   YES     id_event rapid test      
 SCR_SIF  Screening syphilis SCR_SIF_NEG    ,  SCR_SIF_POS
SCR_SIF_IND
SCR_SIF_INV
   YES     id_event rapid test      
 SCR_NEURO  Screening neurological (obsolete) POSITIVE
NEGATIVE
   YES        YES    
 SCR_EPILEPSY  Screening epilepsy POSITIVE
NEGATIVE
 YES          YES    
 EVN_EPILEPSY_FU  Epilepsy Follow Up  free note text   YES          YES    
 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       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 note 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

   YES            
 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    YES            
 EVN_DIAG_REV  hiv + diagnosys reveleation

EVN_DIAG_REV_YES

EVN_DIAG_REV_NO

   YES            
 EVN_VCN_COVID  Vaccine SARS-Cov-2 EVN_VCN_COVID_1
EVN_VCN_COVID_2
EVN_VCN_COVID_3
(for dose)
   YES            
 EVN_VCN_HPV  Vaccine HPV      YES            
 EVN_CLPSCPY  Colposcopy EVN_CLPSCPY_POS
EVN_CLPSCPY_NEG
EVN_CLPSCPY_SUS
   YES            
 EVN_CCBIOPSY  Cervical Biopsy

 free note text 

               
 EVN_CC_THERMO  Cervical cancer Thermoablation treatment (or Thermocoagulation)  free note text                 
 EVN_CC_LEEP  Cervical cancer LEEP (or LLETZ)  free note text                 
 EVN_DRUG_RES  Drug resistance Report  DETECTED
NOTDETECTED
 YES              
 EVN_HNC_REQ  Request a change of therapy     YES          YES  
 EVN_OTH_SU_REF  Referred to other sanitary unit                YES  

 

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

Ordine 480