wiki:Hicdep_1.50/TablePreg

Version 14 (modified by stels, 7 years ago) (diff)

remove links to nonexisting articles

tblPREG - Pregnancy

  1. tblPREG - Pregnancy
    1. Core fields
    2. QA Checks

TODO
abstract for this table

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

MENS_D

yyyy-mm-dd

Date of last menstrual period (If date not known exactly please give approximated date)

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

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

ULTR_A_1

character

If abnormal, please specify

ULTR_2

character:

  • 0=No
  • 1=Yes, normal
  • 2=Yes, abnormal
  • 9=Unknown

Ultrasound 2. trimester

ULTR_A_2

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 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
tblPREGWithinTablePW001ANC_D
tblPREGWithinTablePW002INPREG_Y=2,3,4 but INHIST_Y null
tblPREGWithinTablePW003INPREG_Y=1 but INHIST_Y non null
tblPREGWithinTablePW004INHIST_Y=1 but INHIST_S null
tblPREGWithinTablePW004INHIST_Y=0 or 9 but INHIST_S non null
tblPREGWithinTablePW005KARYO_T=2 but KARYO_A null
tblPREGWithinTablePW006KARYO_T<>2 but KARYO_A non null
tblPREGWithinTablePW007ULTRA_x =2, but ULTR_A_x null
tblPREGWithinTablePW008ULTRA_x <>2, but ULTR_A_x non null
tblPREGCrossTablePC001PROB_Y = 1 but no records in tblPREG_OBS
tblPREGCrossTablePC001PROB_Y = 0 or 9 but records in tblPREG_OBS