DREAM Code
code
View
Home
code
View
id
73
Title
Medical visit --> Diagnosis
Type
Database 6.1
Highlight group
Description
the medical visit diagnosis are stored in the D_EVENTS_ATT table with domain "A_VDIAG"
Code
d_events_att
id_events_att (primary key)
(primary key)
id_event (of the visit appointment)
(id_event of the visit appointment)
id_person
patient unique ID (software)
domain
= 'A_VDIAG'
date_event
not used
vt1
ID of the diagnosis (from DiagnosiSintomi table)
vm1
notes
vt12
not used
vt13
user who inserted
vt14
user who modified
vd2
date of modification
Some examples
Description
idDiagsint
in
DiagnosiSintomi
Primary genital syphilis
RMCD00000002428
Tubercolosis
RMCD00000000013
Respiratory tuberculosis, bacteriologically and histologically confirmed
RMCD00000000014
Ordine
320
Drop file here or click to upload
0%