code View

id 75
Title Medical visit (Appointment)
Type Database 6.1
Highlight group
Description Medical visits are recorded in the table d_events (appointment) and d_events_att (visit details)
Code

Medical visit data in D_EVENTS

 d_events table 
 id_event primary key
 id_person patient id
  
 domain   =  'APPOINTMENT'
 date_event 
 date_apt date of the appointment
 event_type = 'VISIT'
 date_apt_exe date of the visit 
 apt_status appointment status
 ev_vm1 note
 usr_ins user who inserted
 usr_mod user who edited
 usr_datamod edit date

 

Ordine 300