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
Status YES (pregnant) or NO (not pregnant)  
usr_INS  
usr_MOD  
usr_DATAMOD  
active  = 1 if last

 

In D_Events

DREAM 6 Note
id_event  
   
 domain   = 'PREGNANCY'
 id_person  
 date_start  date of conception
 date_event  date of delivery
 event_status  type of outcome
 ev_vd1  pregnancy service 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  

 

Type of outcome (event_status value)

GRA-001 Birth
GRA-002 Abortion
GRA-003 Death of mother
GRA-004 Renounce
GRA-005 HIV-neg (to REMOVE !)
GRA-006 Born dead
Ordine 500