wiki:Hicdep_1.50/TablePregOut

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 tblPREG
tblPREG_OUTCrossTablePTC002OUTCOM=1,2 or 3 and CHILD_ID doesn't exisit in tblNEWBORN or tblDELIVERYCHILD
tblPREG_OUTCrossTablePTC002OUTCOM=10,11,20 or 21 and CHILD_ID exists in tblNEWBORN or tblDELIVERYCHILD
tblPREG_OUTWithinTablePTW001OUTCOME=20 or 21 and OUTCOM_R null
tblPREG_OUTWithinTablePTW001OUTCOME not 20 or 21 and OUTCOM_R non null
Last modified 6 years ago Last modified on 09/13/11 08:04:25