| 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
|
