Version 14 (modified by stels, 7 years ago) (diff) |
---|
tblPREG - Pregnancy
- 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:
| Conception |
ANC_D | yyyy-mm-dd | Date of first antenatal care contact |
INPREG_Y | character:
| At first gynaecological visit: intact intrauterine pregnancy? |
INHIST_Y | numeric:
| If no in INPREG_Y was a histological investigation of reason made. |
INHIST_S | character | If yes, please specify reason |
INV_PROC |
| Invasive procedure |
KARYO_T |
| Karyotype |
KARYO_A | character | If abnormal, please specify |
CHORIO | character:
| For multiple pregnancies |
ULTR_1 | character:
| Ultrasound 1. trimester |
ULTR_A_1 | character | If abnormal, please specify |
ULTR_2 | character:
| Ultrasound 2. trimester |
ULTR_A_2 | character | If abnormal, please specify |
PROB_Y | numeric:
| did any obstetrical problems occur? (if yes, recorded in tblPREG_OBS) |
QA Checks
Table | Crosstable | Error Code | Description | Study specific | 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 | ||
tblPREG | WithinTable | PW002 | INPREG_Y=2,3,4 but INHIST_Y null | ||
tblPREG | WithinTable | PW003 | INPREG_Y=1 but INHIST_Y non null | ||
tblPREG | WithinTable | PW004 | INHIST_Y=1 but INHIST_S null | ||
tblPREG | WithinTable | PW004 | INHIST_Y=0 or 9 but INHIST_S non null | ||
tblPREG | WithinTable | PW005 | KARYO_T=2 but KARYO_A null | ||
tblPREG | WithinTable | PW006 | KARYO_T<>2 but KARYO_A non null | ||
tblPREG | WithinTable | PW007 | ULTRA_x =2, but ULTR_A_x null | ||
tblPREG | WithinTable | PW008 | ULTRA_x <>2, but ULTR_A_x non null | ||
tblPREG | CrossTable | PC001 | PROB_Y = 1 but no records in tblPREG_OBS | ||
tblPREG | CrossTable | PC001 | PROB_Y = 0 or 9 but records in tblPREG_OBS |