code View

id 76
Title Appointments
Type Database 6.1
Highlight group
Description Appointments are stored in the d_events table
Code

 

D_Events in DREAM 6 description
id_event 
domain  = APPOINTMENT
event_type (see below) 
      VISIT medical visit
      APP_DRUGS drug delivery
      EXAMS blood collection
      APP_MEDI medication
      APP_VERIFY urgent verify
      APP_FOOD_INT food integration
      APP_COUNSELLING counselling
      APP_CHECK check-up visit
      APP_TEST_HIV HIV test
      APP_DRUGS_TB TB drugs delivery
      APP_KAP KAP
      APP_CACUM CACUM
      APP_PTVSAMPLE PTV sample
      APP_CPNVISIT CPN visit
      APP_CCRVISIT CCR visit
 id_person patinet unique ID
 category= 'SAMPLE' for EXAMS, APP_PTVSAMPLE, APP_TEST_HIV
 date_apt appointment date
 date_apt_exe date when appointment was done
 date_start date when appointment was taken
 event_status status of the appointment :
 APE-001 = Active
 APE-002 = Executed
 APE-003 = Missed
 APE-004 = End of Assistance
 ev_vm1 notes
 ev_vt1 
 ev_vt1 
 ev_vt1 
 usr_ins 
 usr_mod 
 usr_datamod  

 

For drugs appointment :

D_Events in DREAM 6 
id_event 
domain= APPOINTMENT
event_type= APP_DRUGS
id_person 
category= DRUGS
date_aptappointment date
date_apt_exedelivery date
date_startappointment insert date
event_status= APE-002
event_type 
ev_vm1 
usr_ins 
usr_mod 
usr_datamod  

 

event_type :

event_typedomaincategorydream 5Description
VISITAPPOINTMENTVISITAPT-001VISIT
APP_DRUGSAPPOINTMENTDRUGSAPT-002DRUGS
EXAMSAPPOINTMENTSAMPLEAPT-003SAMPLE
APP_MEDIAPPOINTMENTAPPAPT-004MEDICATION - not used -
APP_VERIFYAPPOINTMENTAPPAPT-005VERIFY
APP_FOOD_INTAPPOINTMENTAPPAPT-006FOOD INTEGRATION
APP_COUNSELLINGAPPOINTMENTAPPAPT-007COUNSELING
APP_CHECKAPPOINTMENTVISITAPT-008CHECK
APP_TEST_HIVAPPOINTMENTSAMPLEAPT-009HIV TEST
APP_DRUGS_TBAPPOINTMENTDRUGSAPT-010TB DRUGS
APP_KAPAPPOINTMENTAPPAPT-KAPKAP
APP_CACUMAPPOINTMENTAPPAPT-EXBE1Visit for CACUM prevention
APP_PTVSAMPLEAPPOINTMENTSAMPLEAPT-E01PTV - SAMPLE
APP_CPNVISITAPPOINTMENTVISITAPT-E02CPN - VISIT
APP_CCRVISITAPPOINTMENTVISITAPT-E03CCR - VISIT

 

event_status : 

CodeDescription
 APE-001 Active
 APE-002 Executed
 APE-003 Missed
 APE-004 End of Asistance
Ordine 200