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