tblNEWBORN_ABNORM - Abnormalities


holds information related to abnormalities of newborns

Abnormalities in newborns are recorded here, one abnormality per row. The absence of a record is to be interpreted as "unknown whether the abnormality existed" since most cohorts only record positive events.

Core Fields

Note: Fields marked bold form the unique identifier for a record of the table. For multiple abnormalities, please specify one record per abnormality.

Field name
Format
Description
CHILD_ID
Character (or numeric if possible)
Patient ID of the child
ABNORM_T_S

character:

  • O = Old Hicdep-style coding
  • N = New IeDEA-style coding
abnormality type coding system
ABNORM_T

New IeDEA-style coding, see coding table

Old Hicdep-style coding, character:

  • 1 = Birth defect(s) (detectable in physical examination including skin abnormalities)
  • 2 = Congenital infection(s)
  • 3 = Drug withdrawal syndrome
  • 4.1 = Neurological disorder(s): abnormal reflexes
  • 4.2 = Neurological disorder(s): abnormal motility
  • 4.3 = Neurological disorder(s): abnormal tonus
  • 90 = Other health problems
type of abnormality
ABNORM_S
character
further specification of the abnormality

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
tblNEWBORN_ABNORMCrossTableNAC001CHILD_ID doesn't exist in NEWBORN Yes
tblNEWBORN_ABNORMWithinTableNAW001ABNORM_T=90 but ABNORM_S null Yes