tblPREG - Pregnancy


holds general pregnancy-related information

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
MENS_D
yyyy-mm-dd
Date of last menstrual period (If date not known exactly please give approximated date)
MENS_D_A
character: see coding of date precision
Precision annotation variable for date of last menstrual period
EST_CONCEPT_D
yyyy-mm-dd
Estimated date of conception. Derive in accordance with local norms based on ultrasound, date of last menstrual period (plus 2 weeks), fundal height, newborn exam/signs/symptoms, etc.
EST_CONCEPT_D_A
character: see coding of date precision
Precision annotation variable for estimated date of conception
CONCEPT

character:

  • 1=Natural
  • 2=Infertility treatment unspecified
  • 2.1=IVF (In Vitro Fertilisation)
  • 2.2=ICSI (IntraCytoplasmic Sperm Injection)
  • 2.3=Ovulation induction
  • 3=Artificial insemination
  • 4=Self insemination
  • 9=Unknown
Conception
ANC_D
yyyy-mm-dd
Date of first antenatal care contact
ANC_D_A
character: see coding of date precision
Precision annotation variable for date of first antenatal care contact
PREG_TEST_D
yyyy-mm-dd
Date of first positive pregnancy test
PREG_TEST_D_A
character: see coding of date precision
Precision annotation variable for date of first pregnancy test
NUM_FETUS
numeric
Number of fetuses
INPREG_Y

character:

  • 1=Yes
  • 2=No: ectopic
  • 3=No: missed abortion
  • 4=No: death in utero (IUFT)
At first gynaecological visit: intact intrauterine pregnancy?
INHIST_Y

numeric:

  • 0=No
  • 1=Yes
  • 9=Unknown
If no in INPREG_Y was a histological investigation of reason made.
INHIST_S
character
If yes, please specify reason
INV_PROC
  • 0=No
  • 1=Yes, chorionic villus sampling (CVS)
  • 2=Cordocentesis
  • 3=Amniocentesis
  • 9=Unknown
Invasive procedure
KARYO_T
  • 0=Not done
  • 1=Normal
  • 2=Abnormal
  • 9=Unknown
Karyotype
KARYO_A
character
If abnormal, please specify
CHORIO

character:

  • 1=Monochorionic
  • 2=Dichorionic
  • 3=Trichorionic
  • etc.
  • 9=Unknown
For multiple pregnancies
ULTR_1

character:

  • 0=No
  • 1=Yes, normal
  • 2=Yes, abnormal
  • 9=Unknown
Ultrasound 1. Trimester (if > 1 ultrasound during trimester, code as 2 if any are abnormal)
ULTR_A_1
character
If abnormal, please specify
ULTR_2

character:

  • 0=No
  • 1=Yes, normal
  • 2=Yes, abnormal
  • 9=Unknown
Ultrasound 2. trimester (if > 1 ultrasound during trimester, code as 2 if any are abnormal)
ULTR_A_2
character
If abnormal, please specify
ULTR_3

character:

  • 0=No
  • 1=Yes, normal
  • 2=Yes, abnormal
  • 9=Unknown
Ultrasound 3. Trimester (if > 1 ultrasound during trimester, code as 2 if any are abnormal)
ULTR_A_3
character
If abnormal, please specify
PROB_Y

numeric:

  • 1 = Yes
  • 0 = No
  • 9 = Unknown
did any obstetrical problems occur? (if yes, recorded in tblPREG_OBS)

QA Checks


TableCrosstableError CodeDescriptionStudy specificHICDEP?
AllTablesCrossTableATC001any date in database after DEATH_D in tblLTFU Yes
AllTablesCrossTableATC002any date in database after DROP_D in tblLTFU Yes
AllTablesCrossTableATC003any date in database before BIRTH_D in tblBAS Yes
AllTablesCrossTableATC004any date in database in the future Yes
AllTablesCrossTableATC005patients submitted previously who have been missed out Yes
AllTablesCrossTableATC006Any fields not coded as coding lists on table definition Yes
tblPREGWithinTablePW001ANC_D <mens_d< td=""></mens_d<> Yes
tblPREGWithinTablePW002INPREG_Y=2,3,4 but INHIST_Y null Yes
tblPREGWithinTablePW003INPREG_Y=1 but INHIST_Y non null Yes
tblPREGWithinTablePW004INHIST_Y=1 but INHIST_S null Yes
tblPREGWithinTablePW004INHIST_Y=0 or 9 but INHIST_S non null Yes
tblPREGWithinTablePW005KARYO_T=2 but KARYO_A null Yes
tblPREGWithinTablePW006KARYO_T<>2 but KARYO_A non null Yes
tblPREGWithinTablePW007ULTRA_x =2, but ULTR_A_x null Yes
tblPREGWithinTablePW008ULTRA_x <>2, but ULTR_A_x non null Yes
tblPREGCrossTablePC001PROB_Y = 1 but no records in tblPREG_OBS Yes
tblPREGCrossTablePC002PROB_Y = 0 or 9 but records in tblPREG_OBS Yes