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 table event_type below)
 id_person  patient unique ID
 category  SAMPLE = for sample appointments
 VISIT       = for visit appointments
 DRUGS   = for drug delivery appointments
 APP         = for other appointments
 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 about the appointment
 ev_vt1  Additional Information
 ev_vt2  time slot
 ev_vt3  clinician/medical specialty
 ev_vt4  used by urgent verify
 usr_ins  user who inserted
 usr_mod  user who modified
 usr_datamod   data when the record was modified

 

event_type :

 event_type  domain  category description
   VISIT  APPOINTMENT  VISIT  medical visit
   APP_CPNVISIT  APPOINTMENT  VISIT  CPN visit
   APP_CCRVISIT  APPOINTMENT  VISIT  CCR visit
   APP_CHECK  APPOINTMENT  VISIT  check-up visit
   APP_TELEVISIT  APPOINTMENT  VISIT  remote control (by email)
   EXAMS  APPOINTMENT  SAMPLE  blood collection
   APP_TEST_HIV  APPOINTMENT  SAMPLE  HIV test
   APP_PTVSAMPLE  APPOINTMENT  SAMPLE  PTV sample
   APP_MEDI  APPOINTMENT  APP  medication (not used)
   APP_VERIFY  APPOINTMENT  APP  urgent verify
   APP_FOOD_INT  APPOINTMENT  APP  food integration
   APP_COUNSELLING  APPOINTMENT  APP  counselling
   APP_ECG  APPOINTMENT  APP  ECG 
   APP_EEG  APPOINTMENT  APP  EEG
   APP_DRUGS  APPOINTMENT  DRUGS  drugs delivery
   APP_DRUGS_TB  APPOINTMENT  DRUGS  TB drugs delivery
   APP_KAP  APPOINTMENT  APP  KAP project (not more used)
   APP_CACUM  APPOINTMENT  APP  CACUM 

 

event_status : 

Code Description
 APE-001  Active
 APE-002  Executed
 APE-003  Missed
 APE-004  End of Asistance

 

For the urgent check appointment specific data: go to the page

For the drugs appointment specific data : go to the page

For the counselling appointment: (APP_COUNSELLING) the ev_vt1 field contain the binary sum of the items choosen:

Value

Description

1

Sexual Behavior

2

HIV status disclosure and test of the partners

4

Adherence to ART

8

Screening of sexually transmitted diseases (STD)

16

Family Planning, Safe Pregnancy and PMTCT

32

Consumption of alcohol and other drugs

64

Reference to Community Support Services

128

Telephone call for preventive follow-up

256

Telephone call for reintegration

512

Consented household searches for preventive follow-up

1024

House searches consented to reintegration

the various type of counseling are coded in binary in the field ev_vt1 with the sum of the binary value of each item that has been chosen.

11

10

9

8

7

6

5

4

3

2

1

1024

512

256

128

64

32

16

8

4

2

1

 

 

 

 

 

 

 

 

 

 

 

for example:

3 = (1+2) = "Sexual behaviour" and "HIV status disclosure and test of the partners"

7 = (1+2+4) = "Sexual behaviour" and "HIV status disclosure and test of the partners" and "Adherence to ART"

65 = (64 + 1) = "Sexual behaviour"and "Reference to Community Support Services"

21 = (16 + 4 + 1) = "Family Planning, Safe Pregnancy and PMTCT" and "Adherence to ART" and "Sexual behaviour"

2047 = (1024+512+256+128+64+32+16+8+4+2+1) =  (ALL the items...)

if we are looking for people with at least  items ,2,4,5,7,8,10 the mask is 01011011011 = 731

WHERE ((TRY_CONVERT(INT,ev_vt1) & 731) = 731)

 

Ordine 200