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 ev_vn1 ev_vn2  ev_vt1 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  Third arv 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 TRANSFER IN              
 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  
 SCR_PAP  PAP smear test SCR_PAP_POS
SCR_PAP_NEG
SCR_PAP_INV
 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
       id_event rapid test    
 SCR_EPA  Screening hepatitis ( HBsAg Test ) SCR_EPA_NEG, SCR_EPA_POS
SCR_EPA_IND
SCR_EPA_INV
      id_event rapid test    
 SCR_SIF  Screening syphilis SCR_SIF_NEG    ,  SCR_SIF_POS
SCR_SIF_IND
SCR_SIF_INV
      id_event rapid test    
 SCR_NEURO  Screening neurological (obsolete) POSITIVE
NEGATIVE
         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  
 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

           
 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
           
 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             

 

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

Ordine 480