tblNEWBORN - Newborn
holds information related to newborns
Please also read the notes on pregnancy tables
|
Core FieldsNote: 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)
|
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.
|
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.
|
|
|
numeric minute at which the 1st APGAR test was performed
|
|
numeric minute at which the 2nd APGAR test was performed
|
|
numeric minute at which the 3rd APGAR test was performed
|
Referral to intensive/intermediate care unit?
|
character if yes, specify reason
|
yyyy-mm-dd Date of entry to intensive/intermediate care unit
|
|
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 |
tblNEWBORN | CrossTable | NC001 | CHILD_ID doesn't exist in tblDELIVERY_CHILD | | Yes |
tblNEWBORN | CrossTable | NC002 | ABNORM_Y = 1, yet no records in tblNEWBORN_ABNORM | | Yes |
tblNEWBORN | CrossTable | NC003 | ABNORM_Y = 0 or 9, yet records in tblNEWBORN_ABNORM | | Yes |
tblNEWBORN | WithinTable | NW001 | BRFEED_SD>BRFEED_ED | | Yes |
tblNEWBORN | WithinTable | NW002 | APGARM_x's out of order (e.g APGARM_3 < APGARM_2) | | Yes |
tblNEWBORN | WithinTable | NW003 | ICU_Y=1, but ICU_S or ICS_D null | | Yes |
tblNEWBORN | WithinTable | NW004 | ICU_Y=0 or 9, but ICU_S or ICU_D non null | | Yes |