code View

id 85
Title Pregnancies
Type Database 6.1
Highlight group
Description pregnancies are stored in d_status (start and the stop of the pregnancy (two records)) while in d_events there are all the informations about the pregnancy
Code

In D_Status

 Column name Description
id_status 
id_person 
  
domain =  'ST_PREGN'
date_started date of conception for YES
 date of delivery for NO
StatusYES (pregnant) or NO (not pregnant) 
usr_INS 
usr_MOD 
usr_DATAMOD 
active = 1 if last

 

In D_Events

DREAM 6Note
id_event 
  
 domain  = 'PREGNANCY'
 id_person 
 date_start date of conception
 date_event date of delivery
 event_status type of outcome
 ev_vd1 HIV prevention start date
 ev_vd2 estimated date of delivery
 ev_vt1 
 ev_vt2 
 ev_vt3 
 ev_vn1 born dead
 ev_vn2 born alive
 ev_vn3 late prevention onset
 ev_vn4 week
 ev_vd3 start TARV date
 ev_vt4 type of birth
 usr_ins 
 usr_mod 
 usr_datamod 

 

 

Ordine 500