DREAM Code
code
View
Home
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
GRA-006
Born dead
Ordine
500
Drop file here or click to upload
0%