id	79
Title	Blood tests (Appointment)
Type	Database 6.1
Highlight group
Description	The blood test appointment is store in the d_events table with domain 'APPOINTMENT' and category 'SAMPLE'
Code	Column name   id_event    domain   = 'APPOINTMENT'  category   = 'SAMPLE'  event_type   =   APP_TEST_HIV (for test HIV)   APP_PTVSAMPLE (for exams in PTV)   EXAMS (for all the other examinations)  id_person  unique id for patient  date_start  date of prescription  date_apt_exe  date of sample (appointment execution date)  ev_vd1  completation date  ev_vd2  date when was sent to laboratory  date_event  date of results  date_apt  date of the appointment  event_status  status of the appointment  ev_vm2    ev_vd3    ev_vn1  Laboratory's NID  ev_vm1  note      ev_vt1  status of examination:  SP_MANCATO = appointment is missed  SP_PRELIEV  = waiting for sample  SP_REFERTO = sample done, waiting for a result  SP_COMPLET = examination is complete, result is received  SP_REJECT = sample rejected by LAB  ev_vt2     ev_vt3    ev_vt4    ev_vt5    usr_ins    usr_mod    usr_datamod    deleted
Ordine	400