tblNEWBORN - Newborn
holds information related to newborns
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 (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) |
| ENTRY_PMTCT_Y | numeric:
|
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. |
| BREASTFD_Y | numeric:
|
Was the child ever breastfed? |
| BREASTFD_DUR | numeric: number of weeks | For how many weeks was the child breastfed? |
| 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:
|
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:
|
did any abnormalities occur? (if yes, recorded in tblNEWBORN_ABNORM) |
QA Checks
| Table | Crosstable | Error Code | Description | Study specific | Is 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 |