code View

id 69
Title Urgent checks details
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 child records of the parent record in D_Events with domain "APPOINTMENT", category "APP" and event_type "APP_VERIFY"

 

D_Events_att

 column name  description
 id_events_att  
 id_event  ID of parent record
 id_person  
 domain   = A_VERIFY
   
 vd1  do not use (see d_events record for date when verify was opened)
 att_date  note date
 vm1  note
   
 vt1  
 vt2  
 vd2  
 vt3

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_CTL  --> check
 VERIFY_TYPE_HOM  --> check at home

 
Ordine 500