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 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')
 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:
 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
 vt4  outcome of this verify (this note)
 vt5  
 vd1  NOT USED - TO CLEAN
 vd2  last modification date
 vd3  NOT USED - TO CLEAN
 

 

Ordine 500