code View

id 83
Title Medical visit --> Visit details
Type Database 6.1
Highlight group
Description
Code


medical visit details in  D_EVENTS_ATT with domain  "A_VISIT"

D_Events_att table description
id_event d_event id
id_person 
  
domain  = 'A_VISIT'
att_date event date
vt1 AIDS stage
vt2 pediatric edema
vt3 pediatric PercSTD
vt5 
vt6 
vn1 height
vn2 BMI
vn3 arm circumference
vn4 head circumference
vn5 waist circumference
vn6 condom given
vn7 CPT given
vn8 depo given
vn9 doses missed
vn10 heart rate
vn11 breath frequency
vn12 MoART
vn13 Ped_PERCHA
vn14 Ped_PERCWA
vn15 Ped_PERCWH
vn16 Ped_ZSHA
vn17 Ped_ZSWA
vn18 Ped_ZSWH
vn19 PERC_ADA
vn20 PERC_ADF
vn21 weight
vn22 pill count
vn23 subscapular fold
vn24 triceps fold
vn25 Systolic pressure (SBP - Max)
vn26 diastolic pressure (DBP - min)
vn27 body temperature
vn28 
vn29 
vn30 
vb1 breast_feeding ?
vb2 SideEffects_No
vb3 PED_Measured ?
vb4 is pregnant ?
vb5 SideEffects_Hp
vb6 SideEffects_Li
vb7 SideEffects_Ot
vb8 SideEffects_Pn
vb9 SideEffects_Sk
vt4 SideEffects_note
vb10 TBStatus_RxNo
vb11 TBStatus_RxYes
vb12 TBStatus_Susp
vb13 TBStatus_No
vb14 Verifica_TBC
vb15 
vn28 
vd1 DUM
vd2 

 

medical visit details in  D_EVENTS_ATT with domain   A_MOTORM

Diaria in DREAM 5D_Events_att in DREAM 6
iddiariaid_event
idanagraficaid_person
  
 domain = 'A_MOTORM'
Datadate_event 
usrMM_INSvt1
usrMM_MODvt2
usrMM_DATAMODvd1
MM1Assvb1
MM1Obsvb2
MM2Assvb3
MM2Obsvb4
MM3Assvb5
MM3Obsvb6
MM4Assvb7
MM4Obsvb8
MM5Assvb9
MM5Obsvb10
MM6Assvb11
MM6Obsvb12 

 

 

 

 

 

Ordine 305