DREAM Code

Title

Urgent checks details (or Defaulter Tracing)

Type

Database 6.1

Highlight group

Description

Details of urgent checks are stored in in D_Events_att. They are child records of the parent record in D_Events with domain "APPOINTMENT", category "APP" and event_type "APP_VERIFY"

Code

Details of urgent checks are records that are children of the parent record in D_Events with domain "APPOINTMENT", category "APP" and event_type "APP_VERIFY"

D_Events	description
id_event
domain	= 'APPOINTMENT'
event_type	APP_VERIFY
id_person	patient unique ID
category	APP
date_apt	verify date
date_apt_exe	date when the verify was completed
date_start	date when the verify was started
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 verify
ev_vt1	Additional Information
ev_vt2	Time slot
ev_vt3	clinical
ev_vt4	final outcome (domain = 'VER_F_OUTC'): VER_F_OUTC_DEAD --> Dead VER_F_OUTC_LOST --> Lost to follow up VER_F_OUTC_STIL --> Still in care in our center VER_F_OUTC_STOP --> Stopped treatment VER_F_OUTC_TRAN --> Receiving ART from another clinic/Transferred
usr_ins	user who inserted
usr_mod	user who modified
usr_datamod	data when the record was modified

D_Events_att

column name	description
id_events_att
id_event	ID of parent record
id_person
domain	= A_VERIFY

att_date	date of the note
vm1	note of verify
vm2
vt1	user who inserted
vt2	user who modified
vt3	verify type (domain= A_VERIFY_TYPE): VERIFY_TYPE_T1 --> first telephone verification VERIFY_TYPE_T2 --> second telephone verification VERIFY_TYPE_T3 --> third telephone verification VERIFY_TYPE_T4 --> telephone verification following the third VERIFY_TYPE_T5 --> treatment support VERIFY_TYPE_CTL --> check VERIFY_TYPE_HOM --> check at home
vt4	outcome of this verify (this note): VERIFY_OUTC_POS VERIFY_OUTC_NEG
vt5
vd1	NOT USED - TO CLEAN
vd2	last modification date
vd3	NOT USED - TO CLEAN

Ordine

500

code View