wiki:Hicdep_1.50/TableNewbornAbnorm

Version 6 (modified by stels, 6 years ago) (diff)

remove links to nonexisting articles

tblNEWBORN_ABNORM - Abnormalities

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

CHILD_ID

Character (or numeric if possible)

Patient ID of the child

ABNORM_T

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

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