WikiPrint - from Polar Technologies

tblPREG_OUT - Pregnancy outcome

This table describes outcomes of pregnancies described in tblPREG.

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

OUTCOM

character:

  • 1=Born alive, HIV negative
  • 2=Born alive, HIV positive
  • 3=Born alive, unknown HIV status
  • 10=Stillborn
  • 11=Spontaneous miscarriage
  • 20=Termination: surgical
  • 21=Termination: medication

Pregnancy outcome

OUTCOM_R

  • 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

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

QA Checks

Table Crosstable Error Code Description Study specific HICDEP?
AllTablesCrossTableATC001any date in database after DEATH_D in tblLTFUYES
AllTablesCrossTableATC002any date in database after DROP_D in tblLTFUYES
AllTablesCrossTableATC003any date in database before BIRTH_D in tblBASYES
AllTablesCrossTableATC004any date in database in the futureYES
AllTablesCrossTableATC005patients submitted previously who have been missed outYES
AllTablesCrossTableATC006Any fields not coded as coding lists on table definitionYES
tblPREG_OUTCrossTablePTC001MOTHER_ID+PREG_SEQ doesn't exist in tblPREGYES
tblPREG_OUTCrossTablePTC002OUTCOM=1,2 or 3 and CHILD_ID doesn't exisit in tblNEWBORN or tblDELIVERYCHILDYES
tblPREG_OUTCrossTablePTC003OUTCOM=10,11,20 or 21 and CHILD_ID exists in tblNEWBORN or tblDELIVERYCHILDYES
tblPREG_OUTWithinTablePTW001OUTCOME=20 or 21 and OUTCOM_R nullYES
tblPREG_OUTWithinTablePTW002OUTCOME not 20 or 21 and OUTCOM_R non nullYES