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

Table Crosstable Error Code Description Study specific Is HICDEP
AllTables CrossTable ATC001 any date in database after DEATH_D in tblLTFU Yes
AllTables CrossTable ATC002 any date in database after DROP_D in tblLTFU Yes
AllTables CrossTable ATC003 any date in database before BIRTH_D in tblBAS Yes
AllTables CrossTable ATC004 any date in database in the future Yes
AllTables CrossTable ATC005 patients submitted previously who have been missed out Yes
AllTables CrossTable ATC006 Any fields not coded as coding lists on table definition Yes
tblPREG WithinTable PW001 ANC_D <mens_d< td=""></mens_d<> Yes
tblPREG WithinTable PW002 INPREG_Y=2,3,4 but INHIST_Y null Yes
tblPREG WithinTable PW003 INPREG_Y=1 but INHIST_Y non null Yes
tblPREG WithinTable PW004 INHIST_Y=1 but INHIST_S null Yes
tblPREG WithinTable PW004 INHIST_Y=0 or 9 but INHIST_S non null Yes
tblPREG WithinTable PW005 KARYO_T=2 but KARYO_A null Yes
tblPREG WithinTable PW006 KARYO_T<>2 but KARYO_A non null Yes
tblPREG WithinTable PW007 ULTRA_x =2, but ULTR_A_x null Yes
tblPREG WithinTable PW008 ULTRA_x <>2, but ULTR_A_x non null Yes
tblPREG CrossTable PC001 PROB_Y = 1 but no records in tblPREG_OBS Yes
tblPREG CrossTable PC002 PROB_Y = 0 or 9 but records in tblPREG_OBS Yes