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
Character (or numeric if possible)
Patient ID of mother of the child
numeric
Sequence number of the pregnancy for the specified mother
yyyy-mm-dd
Date of last menstrual period (If date not known exactly please give approximated date)
Precision annotation variable for date of last menstrual period
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.
Precision annotation variable for estimated date of conception

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
yyyy-mm-dd
Date of first antenatal care contact
Precision annotation variable for date of first antenatal care contact
yyyy-mm-dd
Date of first positive pregnancy test
Precision annotation variable for date of first pregnancy test
numeric
Number of fetuses

character:

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

numeric:

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

character:

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

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)
character
If abnormal, please specify

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)
character
If abnormal, please specify

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)
character
If abnormal, please specify

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