wiki:Hicdep_1.100/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 (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

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
Last modified 11 months ago Last modified on 08/02/17 11:06:45