Version: BR20.1🔗

Features/General🔗

• Additional Multiple Birth & Postnatal Recruitment participants cleaned & included
• List of measures & fields included/excluded - 2.0

Age Fields:🔗

• Administration-based ages:
  • 'Gestational age' (gestational_age): Blank for V02 onwards across all tables
  • 'Candidate Age' (candidate_age): Blank for V01 across all tables
  • 'Adjusted Chronological Age (adjusted_age)': Blank for V01 across all tables
• Ages at Delivery (GAD/MAD/MAV01):
  • Based on true DOB
  • Only at V02 (V01 for MAV01)
  • Added direct from csv
• 3rd party instruments ‘Date of Administration’ extracted from parsed files for: Bayley, CDI, Vineland, TLFB

MRI/EEG/BioSensors🔗

MRI🔗

• Derivatives Added: NiBabies, BIBSNet, QSIprep, OSPREY, MRIQC, XCP-D
• Data Dictionary Updates:
  • Addition of subdomain, metric, and atlas columns
  • Relabelled table_label values to include human readable labels
  • Addition of age columns for img_brainswipes and eeg files
• XCP-D data available for both hashes of the XCP-D runs
• Removed V06 from imaging and EEG files

EEG🔗

• EEG Acquisition Form (eeg_ch_chkl) included
• Field hum_001_i_04 not included (to be included in BR20.2)
• Inclusion of ERP SummaryStats MADE files - DD template generated and DD details added
• MADE data (533/1,720 sessions)
• Tabular derivatives:
  • Summary Stats
  • EEG QC new fields added: stimtracker_artifact, technical_issues, technical_issues_notes
  • MADE Processing report: Including change in title from ‘preproc’ to ‘preprocessing’

BioSensors🔗

• Instrument name for 'BioSensor' forms changed to include 'Novel Tech' (nt) domain
• ‘BioSensor Setup’ (nt_ch_sens_setup) included
• ‘BioSensor Receipt’ (nt_ch_sens_setup) included

BioSpecimen toxicology results:🔗

• Ingestion into database from csv files
• Values for the 'Nail Weight' field (bio_bm_biosample_nails_results_bio_nail_weight) set to double (previously incorrectly set to 'integer')
• All negative values for 'bio_bm_biosample_urine_bio_c_cot_u' set to ‘0’
• Collection/Received/Report/ dates included
• Urine Results:
  • Renamed urine file name from ‘bio_bm_biosample_urine’ to ‘bio_bm_biosample_urine_results’
  • 'biosample_urine_bio_c_cot_u'
    • Negatives converted to '0'
    • Missing values changed from '0' to blank
  • Values for the 'Urine Specific Gravity' field (bio_bm_biosample_urine_bio_spg_u) set to the correct floating point value (had been previously set to '1' and data type to 'integer')
  • Set units to ‘Ng/ml’ for ‘unit’ fields missing values
    • c_ket_unit_u
    • c_mda_unit_u
    • c_mdea_unit_u
    • c_mdm_unit_u
    • c_mep_unit_u
    • c_nket_unit_u
    • c_nmep_unit_u
    • c_tram_unit_u

Basic Demographics (sed_basic_demographics)🔗

• Child ACS Race/Ethnicity changed to 'Unknown' for all V01
• Replaced:
  • “defined by Ripple” with “(ACS item)” for:
    • 'sed_basic_demographics_child_ethnicity'
    • 'sed_basic_demographics_child_race'
  • “LORIS” with “RedCAP at V01” for:
    • 'sed_basic_demographics_rc_mother_education'
    • 'sed_basic_demographics_rc_mother_income'
  • “LORIS” mention with “Mother’s race/ethnicity (ACS item at enrollment)” for:
    • 'sed_basic_demographics_screen_mother_race'
    • 'sed_basic_demographics_screen_mother_ethnicity'
  • Changed ‘Sex’ description to "Child sex (Male, Female)":
    • 'sed_basic_demographics_sex'
• Updated ‘response 5’ label for Multiracial (non-Black)' to: “participants who identify as more than one race or one race plus Hispanic ethnicity, but do not endorse Black as an option)”
• Removed “For example: ...." for the 'Description' of all option fields
• Removed:
  • 'child_ethnoracial_acs_by_multi_race'
  • ‘Hawaiian’ as an option for 'screen_mother_race' (Correct response is 'Hawaiian or Other Pacific Islander')

Visit Data (par_visit_data):🔗

• BioSpecimen SU flags based on Urine results added to 'Visit Data' - Alcohol; Opioid; Cannabis; Nicotine
• TLFB SU flags added to 'Visit Data': Alcohol; Opioid; Cannabis; Nicotine
• Health V2 SU flags added to 'Visit Data'
  • FAS (Fetal Alcohol Syndrome)
  • NOWS (Neo-natal Opioid Withdrawal Syndrome)
• Removed par_visit_data_su_flag_bio_{barb|benzo|mscrlx}
• Sites listed changed to indexed sites
• Fixed incorrect output for 'screen_mother_ethnicity’ - Incorrectly reported 'Hispanic/Non-Hispanic' entries (should be ‘0’/’1’)

Rollover SU Flags🔗

• Rolled up Alcohol flag (par_visit_data_su_flag_alcohol) - 'Yes if:
  • either 'par_visit_data_su_flag_bio_ethanol' = 'Yes' OR
  • ‘par_visit_data_su_flag_tlfb_alcohol' = 'Yes' OR
  • 'par_visit_data_su_flag_healthv2_fas' = 'Yes'
• Rolled up Cannabinoid flag (par_visit_data_su_flag_cannabis) - 'Yes' if either:
  • 'par_visit_data_su_flag_bio_cannabinoid' = 'Yes' OR
  • 'par_visit_data_su_flag_tlfb_cannabis' = 'Yes'
• Rolled up nicotine flag (par_visit_data_su_flag_nicotine) - 'Yes' if either:
  • 'par_visit_data_su_flag_bio_nicotine' = 'Yes' OR
  • par_visit_data_su_flag_tlfb_nicotine' = 'Yes'
• Rolled up opioid flag (par_visit_data_su_flag_opioid) - 'Yes' if either:
  • 'par_visit_data_su_flag_bio_opioid' = 'Yes' OR
  • 'par_visit_data_su_flag_tlfb_opioid' = 'Yes' OR
  • 'par_visit_data_su_flag_healthv2_nows' = 'Yes'

Blank entries:🔗

• TLFB can be V01, V02, V03, blank when no data.
• Health v2 FAS/NOWS only @ V02, blank for V01, V03.
• BioSpecimen Urine only @ V01, blank for V02, V03

Data Dictionary🔗

• Demographics (sed_bm_demo):
  • 'Income': Data levels merge - From 10 levels down to 6 levels
  • 'Education': Data levels merge - From 21 levels down to 6 levels
• Current Employment (sed_cg_employ): Sed_cg_employ_002: Changed from 'Nominal' to 'Ordinal'
• Household Chemical Exposures (Sed_cg_hce):
  • sed_cg_hce_002: change from 'Ordinal' to 'Nominal'
  • sed_cg_hce_007: Kept as 'Nominal'
  • sed_cg_hce_008_i_01: Changed from 'Nominal' to 'Ordinal'
• Changed 'type_var' to 'administrative’ for 'age' fields

Database/Scoring🔗

• APA (pex_bm_apa):
  • Scoring in line with 15.2 - Including removal of incorrectly acquired Level-2 data for subscales not meeting Level-1 criteria
  • Anger score fields included
• Anthropometrics (ph_ch_anthro):
  • Z-Scores updated via csv from ETL using true DoB
  • Pushed as blank, where blank on ETL file
  • BMI algorithm to be reviewed
• CDI (ncl_ch_cdiwgen/ncl_ch_cdiwges):
  • Fields Changed from 'static' to 'character' and levels added
• Demographics (sed_bm_demo):
  • Added '(other biological parent)' to description for 'sed_bm_demo_herit_i_oth' fields
• SPM-2 (ncl_cg_spm2_i_inf/ncl_cg_spm2_i_tod):
  • Score and status fields included
• TLFB (pex_ch_tlfb):
  • SU Flags based on cumulative scores across V01 & V02
• Vancouver Index of Acculturation (sed_cg_via):
  • Swapped sub-scores across all questions sets
• 'LaunchPad Complete' date updated to correct date for participant inclusion
• Removed '1999-12-26' dates from 'Participant Withdrawal Date' when used for 'Missed Visit' (no participant withdrawal)

Filters🔗

• List of measures & fields included/excluded - 2.0
  • Included:
    • 'Bayley-4' (ncl_ch_bayley)
    • 'SPM-2 Toddler' (ncl_cg_spm2_i_tod)
    • ‘TIC - Screener’ (sed_cg_tic_screener)
    • ‘EEG Acquisition Form’ (eeg_ch_chkl)
• ‘Administration’ and ‘Date of Administration’ included across the board (not excluded even if requested by WG)
• EPDS: Remove 'pex_bm_epds_score'
• Removed ‘Warning’ fields: sed_cg_{ace|cabr_sf|pedaces}_sensitive

Demographics🔗

• Excluded:
  • Selected Roster variables excluded as per Roster Exclusion list:
    • 'Demographics' (sed_bm_demo)
    • 'Child Demographics' (sed_bm_demo_child)
  • Roster table fields excluded
    • 'Demographics' (sed_bm_demo) - from: 'roster_table_00', 'roster_table_1', ... to 'roster_table_20'
    • 'Child Demographics' (sed_bm_demo_child) - from: 'i_roster_table_1' to 'i_roster_table_32' & ‘sed_bm_demo_child_i_roster_001_i_01’
• Included:
  • 'Demographics' (sed_bm_demo)
    • 'sed_bm_demo_roster_001_i_00'
    • ‘disab_001’ to ‘disab_006’
    • ‘sed_bm_demo_transp_001'
  • 'Child Demographics' (sed_bm_demo_child)
    • 'sed_bm_demo_child_i_roster_002_i_02_i_00'
    • 'sed_bm_demo_child_i_roster_020_i_02_i_00'

Shadow Matrices🔗

• Added note to blanks on ‘Visit Data’ indicating “Data not available for participant at this timepoint”

Genomics/Geocoding/Study Navigator🔗

• Files prepared and ready for de-identification (separate from BR20,1 run)
• To be added to ‘concatenated’ folder

BR20.1 Resolved Known Issues🔗

General🔗

• Corrected age_adjusted across instruments (now based on EDD instead of LMP (EDD +280 days)

Domain-Specific🔗

#	Table/Var	Fixed Issue/Update
Demographics
Visit Information (par_visit_data)
1	participant_withdrawal_date	Data Error: Change sentinel value for withdrawal date of participants who did NOT withdraw (12/26/1999) to null
2	su_flag_bio_*	Remove SU flags derived from USDTL urine toxicology for V02 (not collected)
3	su_flag_tlfb_*	Data Error: Correct erroneous positive TLFB SU flags (e.g. nicotine use reported only weeks 3 & 4, but V01 & V02 'self_report_nicotine'=1)
4	par_visit_data_su_flag_tlfb_*	Data Error: Change TLFB SU flags for participants without a V02 from 'no' to 'null'
Basic Demographics (sed_basic_demographics)
1	Child Multi-Ethnicity	Remove child_ethnoracial_acs_by_multi_ethnicity V01 data
2	Child Multi-Race	Remove child_ethnoracial_acs_by_multi_race (duplicate of Child Multi-Ethnicity)
3	screen_mother_race	Data Error: Remove invalid response option 2 = Hawaiian
4	rc_mother_income	Data Request: Income data levels change - roll up 10 levels to 6
Behavior & Caregiver-Child Interaction
4	MAPS-TL/PROMIS	Workgroup validate prorated scoring
5	ECBQ (mh_cg_ecbq)	Data Error: Add missing score fields (currently under LORIS review)
6	IBQR (mh_cg_ibqr)	Shadow Matrix Error: Missingness reason showing as LOGIC SKIPPED, but missingess is not caused by branching logic. Currently under LORIS review.
Biospecimen & Omics
1	Urine	Restored missing values for urinary cotinine (bio_c_cot_u) erroneously set to 0 (N = 18)
Neurocognition & Language
1	SPM-2 Infant (ncl_cg_spm2__inf)	Add missing status scores that are currently missing for all but one subscale
2	SPM-2 Infant (ncl_cg_spm2__inf)	Add Variables: age fields
3	CDI	Benchmark age, adjusted benchmark age, and adjusted percentile scores added for the English CDI words and gestures
Physical Health
1	Growth (ph_ch_anthro)	Data Request: recalculate z-score based on actual DOB
2	BFH	Add variables: add remaining variables flagged for inclusion (currently only 2 of the 17 present)
3	ecPROMIS Sleep (ph_cg_pms__sleep)	Data Error: Add missing score fields
Pregnancy & Exposure, Including Substance Use
1	pex_bm_apa	Data Request: Remove Level 2 data for participants not meeting Level 1 threshold
2	pex_bm_epds_score	Remove Variable (duplicate of pex_bm_epds_total_score)
3	pex_bm_apa_apa2_*	Data Correction: Add missing APA Level 2 scores (all are currently blank)
4	TLFB	Add Variables: Add all age variable fields
5	TLFB	Data Request: Detailed variable breakdown (e.g. create new subcategories to separate out 'nicotine' from 'cigarettes, e-cigarettes, cigars etc.' & extract frequency for each)
6	TLFB (PNR)	Data Error: Postnatal Recruits reported in v1 or v2, but should be v3
Social & Environmental Determinants
1	sed_bm_demo (Adult)	SME Request: Remove Roster Gender fields (based on internal list)
2	sed_bm_demo_child	SME Request: Remove Roster Gender AND Sex fields (based on internal list)
3	sed_bm_demo_child	SME Request: Remove Roster '_table' fields (eg roster_table_13)
4	sed_bm_demo_child__roster_001__01	Remove variable (SED request - duplicate of roster_001)
5	sed_bm_demo_transp_001	Add Variables: transportation
6	sed_bm_demo_disab_*	Add Variables: disability
7	sed_cg_employ_002	DD Update: Change type_level to 'Ordinal'
8	sed_cg_hce_007 & sed_cg_hce_008_i_0	DD Update: Change type_level to 'Ordinal'
9	sed_cg_hce_002	DD Update: Change type_level to 'Nominal'
10	sed_*_{ace/car_sf/pedals}_sensitive	Remove 'sensitive' variables across SED tables
11	Vancouver Index (VIA)	Data Request: Correct flipped question order in English/Spanish versions
12	sed_cg_employ_101*	DD Update: use "spouse/partner" in 'Description': “Do you have a partner?”
13	HOME-21 (sed_cg_home_it)	Data Error: Add missing score fields
14	PACES <18 (sed_cg_paces)	Data Error: Add missing score fields (currently under LORIS review)