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
Character (or numeric if possible)
Patient ID of mother of the child
numeric
Sequence number of the pregnancy for the specified mother
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)

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

Numeric:

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

numeric:

  • 1 = HIV exposed, Status indeterminate
  • 2 = HIV infected
  • 3 = HIV uninfected
HIV Status for a child not enrolled into HIV care
yyyy-mm-dd
Date associated with ascertainment of HIV status for child not enrolled into HIV care
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