tblNEWBORN - Newborn


holds information related to newborns

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
Character (or numeric if possible)
Patient ID of the child (If child is not enrolled into care, enter mother's ID with dashed numeric Suffix such as [MOTHER_ID]-1, [MOTHER_ID]-2, etc. here)

numeric:

  • 0 = No
  • 1 = Yes
  • 9 = Unknown
Did the child enter your program through a PMTCT program/Trial? Note: Children can be considered to have entered through a PMTCT program if their mother received PMTCT drugs (either in a dedicated PMTCT program or an integrated program) and the infant was diagnosed in PMTCT follow-up and enrolled at <6 months of Age. Enter 1 if child entered through a PMTCT program, 0 if child is known to have NOT entered through a PMTCT program (e.g. hospitalization, TB program, General HIV clinic) and 9 if unknown.

numeric:

  • 0 = No
  • 1 = Yes
  • 9 = Unknown
Was the child ever breastfed?
numeric: number of weeks
For how many weeks was the child breastfed?
yyyy-mm-dd
Breastfeeding, start date.
yyyy-mm-dd
Breastfeeding, end date.
Ethnicity of father
numeric
1st APGAR score
numeric
minute at which the 1st APGAR test was performed
numeric
2nd APGAR score
numeric
minute at which the 2nd APGAR test was performed
numeric
3rd APGAR score
numeric
minute at which the 3rd APGAR test was performed

numeric:

  • 0 = No
  • 1 = Yes
  • 9 = Unknown
Referral to intensive/intermediate care unit?
character
if yes, specify reason
yyyy-mm-dd
Date of entry to intensive/intermediate care unit

numeric:

  • 0 = No
  • 1 = Yes
  • 9 = Unknown
did any abnormalities occur? (if yes, recorded in tblNEWBORN_ABNORM)

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
tblNEWBORNCrossTableNC001CHILD_ID doesn't exist in tblDELIVERY_CHILD Yes
tblNEWBORNCrossTableNC002ABNORM_Y = 1, yet no records in tblNEWBORN_ABNORM Yes
tblNEWBORNCrossTableNC003ABNORM_Y = 0 or 9, yet records in tblNEWBORN_ABNORM Yes
tblNEWBORNWithinTableNW001BRFEED_SD>BRFEED_ED Yes
tblNEWBORNWithinTableNW002APGARM_x's out of order (e.g APGARM_3 < APGARM_2) Yes
tblNEWBORNWithinTableNW003ICU_Y=1, but ICU_S or ICS_D null Yes
tblNEWBORNWithinTableNW004ICU_Y=0 or 9, but ICU_S or ICU_D non null Yes