wiki:Hicdep_1.50/TableNewborn

tblNEWBORN - Newborn

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

BRFEED_SD

yyyy-mm-dd

Breastfeeding, start date.

BRFEED_ED

yyyy-mm-dd

Breastfeeding, end date.

FAT_ETH

See Coding Table.

Ethnicity of father

APGAR_1

numeric

1st APGAR score

APGARM_1

numeric

minute at which the 1st APGAR test was performed

APGAR_2

numeric

2nd APGAR score

APGARM_2

numeric

minute at which the 2nd APGAR test was performed

APGAR_3

numeric

3rd APGAR score

APGARM_3

numeric

minute at which the 3rd APGAR test was performed

ICU_Y

numeric:

  • 1 = Yes
  • 0 = No
  • 9 = Unknown

Referral to intensive/intermediate care unit?

ICU_S

character

if yes, specify reason

ICU_D

yyyy-mm-dd

Date of entry to intensive/intermediate care unit

ABNORM_Y

numeric:

  • 1 = Yes
  • 0 = No
  • 9 = Unknown

did any abnormalities occur? (if yes, recorded in tblNEWBORN_ABNORM)

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
tblNEWBORNCrossTableNC001CHILD_ID doesn't exist in tblDELIVERY_CHILD
tblNEWBORNCrossTableNC002ABNORM_Y = 1, yet no records in tblNEWBORN_ABNORM
tblNEWBORNCrossTableNC003ABNORM_Y = 0 or 9, yet records in tblNEWBORN_ABNORM
tblNEWBORNWithinTableNW001BRFEED_SD>BRFEED_ED
tblNEWBORNWithinTableNW002APGARM_x's out of order (e.g APGARM_3 < APGARM_2)
tblNEWBORNWithinTableNW003ICU_Y=1, but ICU_S or ICS_D null
tblNEWBORNWithinTableNW004ICU_Y=0 or 9, but ICU_S or ICU_D non null
Last modified 6 years ago Last modified on 09/13/11 08:24:01