code View

id 77
Title Drug delivery (appointment)
Type Database 6.1
Highlight group
Description Drug delivery are attributes of the domain = APPOINTMENT , event_type = APP_DRUGS in d_events table
Code

--> in d_events

d_events table  for Drugs delivery  
 id_event  
 domain = 'APPOINTMENT'
 event_type = 'APP_DRUGS'
 id_person  
 date_apt appointment date
 date_apt_exe delivery date
 date_start appointment created date
 event_status = 'APE-002'
 category = DRUGS
 ev_vm1  
 usr_ins  
 usr_mod  
 usr_datamod  

--> in d_events_att

d_events_att   
id_events_att (primary key)  
id_event  
id_person  
   
domain = 'A_DRUGS'
date_event do not use
vt1 deliverable
vt2 drug
vt3  
vt4 idfarmaco
vt5 utente_ins
vt6 utente_mod
vd2 data_mod
vt7 WarningReso
vt8  
vn1 frequency
vn2 days delivered
vn3 days coverage
vn4 days uncovered
vn5 pills not returned
vn6 morning
vn7 midday
vn8 percentage of adherence
vn9 afternoon
vn10 QUANTITY
vn11 returned
vn12 evening
vn13  
vd1 delivery date
vb1 additional
vb2 when needed
vb3 norecalc
vb4 replacement

 

 

var j = from a in db.d_events_att.Where(w => w.domain == "A_DRUGS")        //Consegna farmaci
		from b in db.d_events_att.Where(w => w.domain == "A_DPRES" && a.vn13 == w.id_events_att).DefaultIfEmpty() //Diaria Posologia

 
Ordine 550