tblPREG_OUT - Pregnancy outcome


describes the pregnancy outcome

Please also read the notes on pregnancy tables.

Core Fields

Note: Fields marked bold form the unique identifier for a record of the table.
Field name
Format
Description
MOTHER_ID
Character (or numeric if possible)
Patient ID of mother of the child
PREG_SEQ
numeric
Sequence number of the pregnancy for the specified mother
CHILD_ID
Character (or numeric if possible)
Patient ID of the child (if child is not enrolled into care, enter mother's ID with dashed numeric Suffix such as [MOTHER_ID]-1, [MOTHER_ID]-2, etc. here)
OUTCOM

character:

  • 1=Born alive, HIV negative
  • 2=Born alive, HIV positive
  • 3=Born alive, unknown HIV Status
  • 4=Born alive
  • 10=Stillborn
  • 11=Spontaneous miscarriage
  • 20=Termination: surgical
  • 21=Termination: medication
  • 22=Termination: method unknown
Pregnancy outcome
OUTCOM_R

Numeric:

  • 1=Fetus with malformation
  • 2=Dead fetus
  • 3=Unwanted pregnancy
  • 8=Other
  • 9=Unknown
Reason for termination
OUTCOM_D
yyyy-mm-dd
Date of birth or termination of pregnancy
OUTCOM_D_A
character: see coding of date precision
Precision annotation variable for date of birth or termination of pregnancy
B_GAGEW
numeric
Gestational age in complete weeks at birth or termination
B_GAGED
numeric
Gestational age in days in addition to weeks at birth or termination
CHILD_HIV

numeric:

  • 1 = HIV exposed, Status indeterminate
  • 2 = HIV infected
  • 3 = HIV uninfected
HIV Status for a child not enrolled into HIV care
CHILD_HIV_D
yyyy-mm-dd
Date associated with ascertainment of HIV status for child not enrolled into HIV care
CHILD_HIV_D_A
character: see coding of date precision
Precision annotation variable for date associated with ascertainment of HIV status for child

QA Checks


TableCrosstableError CodeDescriptionStudy specificHICDEP?
AllTablesCrossTableATC001any date in database after DEATH_D in tblLTFU Yes
AllTablesCrossTableATC002any date in database after DROP_D in tblLTFU Yes
AllTablesCrossTableATC003any date in database before BIRTH_D in tblBAS Yes
AllTablesCrossTableATC004any date in database in the future Yes
AllTablesCrossTableATC005patients submitted previously who have been missed out Yes
AllTablesCrossTableATC006Any fields not coded as coding lists on table definition Yes
tblPREG_OUTCrossTablePTC001MOTHER_ID+PREG_SEQ doesn't exist in tblPREG Yes
tblPREG_OUTCrossTablePTC002OUTCOM=1,2 or 3 and CHILD_ID doesn't exisit in tblNEWBORN or tblDELIVERYCHILD Yes
tblPREG_OUTCrossTablePTC003OUTCOM=10,11,20 or 21 and CHILD_ID exists in tblNEWBORN or tblDELIVERYCHILD Yes
tblPREG_OUTWithinTablePTW001OUTCOME=20 or 21 and OUTCOM_R null Yes
tblPREG_OUTWithinTablePTW002OUTCOME not 20 or 21 and OUTCOM_R non null Yes