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 
  

 

Ordine 500