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 *TOO
 ev_vd1  pregnancy service start date
 ev_vd2  estimated date of delivery
 ev_vt1  place of delivery  *POD
 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  Mode of Delivery    *MOD
 usr_ins  
 usr_mod  
 usr_datamod  

 

Type of Outcome  (*TOO) (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

 

Place Of Delivery (*POD) (ev_vt1)

PARLUO01  At home
PARLUO02  At home with a midwife
PARLUO03  Health Center
PARLUO04  Hospital

Mode Of Delivery (*MOD)  (ev_vt4)

 PAR-001  Vaginal delivery
 PAR-002  Delivery with episiotomy
 PAR-003  Cesarean

 

Ordine 500