wiki:Hicdep_1.60/TableDeliveryChild

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

copy from version 1.50

tblDELIVERY_CHILD - Delivery information related to the child(ren)

This table holds information about a delivery specific to a child. Mother-specific data is kept in tblDELIVERY_MUM.

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

MEMRUP_D

yyyy-mm-dd

Date of rupture of membranes

CHILD_ID

Character (or numeric if possible)

Patient ID of the child

B_SEQ

numeric

If multiple births, indicate number (1=first born)

DELIV_D

yyyy-mm-dd

Date of delivery

DELIV_T

hh:mm

Time of delivery

DELIV_M

character:

  • 1=Vaginally, spontaneous
  • 2=Vaginally, forceps
  • 3=Vaginally, vacuum
  • 10= Cesarean section, primary/elective (before onset of labour and rupture of membrane)
  • 11=Cesarean section, Secondary

Mode of delivery

LABOUR_P

numeric

Duration of labour in hours (from cervical dilatation (>=3 cm) until delivery)

BREECH_Y

numeric:

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

Was the child born from a breech presentation?

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_CHILDCrossTableDCC001MOTHER_ID doesn't exist in tblPREGYES
tblDELIVERY_CHILDCrossTableDCC002CHILD_ID doesn't exist in tblPREG_OUTYES
tblDELIVERY_CHILDWithinTableDCW001Duplicate records for same Mother_ID, CHILD_ID YES
tblDELIVERY_CHILDWithinTableDCW002B_SEQ >4YES
tblDELIVERY_CHILDWithinTableDCW003B_SEQ>1, but no record exists for same Mother, Child with B_SEQ=1YES
tblDELIVERY_CHILDWithinTableDCW005DELIV_D < MEMRUP_DYES
tblDELIVERY_CHILDWithinTableDCW004LABOUR_P >72YES
tblDELIVERY_CHILDWithinTableDCW0062 children, same mother, same MEMRUP_D, DELIV_D >DELIV_D , yet B_SEQ< B_SEQYES