wiki:Hicdep_1.60/TableDeliveryMum

Version 1 (modified by trac, 6 years ago) (diff)

copy from version 1.50

tblDELIVERY_MUM - Delivery information related to the mother

This table contains information about the delivery specific to the mother. Child-specific information is recorded in tblDELIVERY_CHILD instead.

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

MEMRUP_D

yyyy-mm-dd

Date of rupture of membranes

MEMRUP_T

hh:mm

Time of rupture of membranes

LABOUR

character:

  • 1=Spontanous
  • 2=Induced
  • 3=No labour (elective C-section)

Onset of labor

INTERV

character:

  • 0=No
  • 1=Fetal blood sampling FBS
  • 2=Internal electrodes
  • 3=1+2
  • 90=Other
  • 91=1+Other
  • 92=2+Other
  • 93=1+2+Other

Interventions during delivery

INTERV_O

character

Interventions during delivery - other

TEAR_Y

numeric:

  • 1=Yes
  • 0=No
  • 9=Unknown

Episiotomy/tear

BLDLOSS

numeric (mL)

Estimated blood loss during delivery

CONTREAT

character:

  • 0=No, treatment has been interrupted
  • 1=Yes, at the foreseen intervals
  • 2=Yes, but not at forseen time points
  • 9=Unknown

Did the patient continue the usual antiretroviral therapy?

DISCHA_D

yyyy-mm-dd

Date of discharge from hospital

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
tblDELIVERY_MUMCrossTableDMC001MOTHER_ID doesn't exist in tblPREGYES
tblDELIVERY_MUMCrossTableDMC002MOTHER_ID doesn't exist in tblDELIVERY_CHILD with same MEMRUP_DYES
tblDELIVERY_MUMWithinTableDMW001PREG_SEQ invalid (PREG_SEQ>1 and PREG_SEQ=x, but PREG_SEQ=x-1 doesn't exist)YES
tblDELIVERY_MUMWithinTableDMW002DISCHA_D < MEMRUP_DYES
tblDELIVERY_MUMWithinTableDMW004INTERV=0-3 but INTERV_O non nullYES
tblDELIVERY_MUMWithinTableDMW003INTERV=90,91, 92 or 93 but INTERV_O nullYES