code View

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 Prescription ID
 ev_vt3 Examination ID
 ev_vt4 
 ev_vt5 
 usr_ins 
 usr_mod 
 usr_datamod 
 deleted 

 

Ordine 400