code View

id 69
Title Urgent checks details (or Defaulter Tracing)
Type Database 6.1
Highlight group
Description Details of urgent checks are stored in in D_Events_att. They are child records of the parent record in D_Events with domain "APPOINTMENT", category "APP" and event_type "APP_VERIFY"
Code

Details of urgent checks are records that are children of the parent record in D_Events with domain "APPOINTMENT", category "APP" and event_type "APP_VERIFY"

 

D_Events   description
 id_event  
 domain   = 'APPOINTMENT'
 event_type  APP_VERIFY
 id_person  patient unique ID
 category  APP 
 date_apt  verify date
 date_apt_exe  date when the verify was completed
 date_start  date when the verify was started
 event_status  status of the appointment :
 APE-001 = Active
 APE-002 = Executed
 APE-003 = Missed
 APE-004 = End of Assistance
 ev_vm1  notes about the verify
 ev_vt1  Additional Information
 ev_vt2  Time slot
 ev_vt3  clinical 
 ev_vt4  final outcome (domain = 'VER_F_OUTC'):
VER_F_OUTC_DEAD --> Dead
VER_F_OUTC_LOST --> Lost to follow up
VER_F_OUTC_STIL --> Still in care in our center
VER_F_OUTC_STOP --> Stopped treatment
VER_F_OUTC_TRAN --> Receiving ART from another clinic/Transferred
 usr_ins  user who inserted
 usr_mod  user who modified
 usr_datamod   data when the record was modified

 

D_Events_att

 column name  description
 id_events_att  
 id_event  ID of parent record
 id_person  
 domain   = A_VERIFY
   
 att_date  date of the note
 vm1  note of verify
 vm2  
 vt1  user who inserted
 vt2  user who modified
 vt3

verify type (domain= A_VERIFY_TYPE):
 VERIFY_TYPE_T1     -->  first telephone verification
 VERIFY_TYPE_T2     -->  second telephone verification
 VERIFY_TYPE_T3     -->  third telephone verification
 VERIFY_TYPE_T4     --> telephone verification following the third

 VERIFY_TYPE_T5     --> treatment support
 VERIFY_TYPE_CTL  --> check
 VERIFY_TYPE_HOM  --> check at home

 vt4

 outcome of this verify (this note):

 VERIFY_OUTC_POS
 VERIFY_OUTC_NEG

 vt5  
 vd1  NOT USED - TO CLEAN
 vd2  last modification date
 vd3  NOT USED - TO CLEAN
 

 

Ordine 500