Version: BR20.2🔗

Features/General🔗

• Changed exclusion criteria to exclude participants based on hardcoded list of participants who 'Withdrew consent to share' (list based on Ripple form)
• List of measures & fields included/excluded - 2.0

BioSpecimen Toxicology Results🔗

• Ingestion into dat
• Fixed missing plural on 'nails' for all nails field names
• Changed from 'description' to 'Description' for DD element on BioSpecimen tables
• Removed Creatine and MEP fields from ‘Urine Results’:
  • MEP
    • 'bio_bm_biosample_urine_results_bio_c_mep_u'
    • 'bio_bm_biosample_urine_results_bio_c_mep_u_cat'
    • 'bio_bm_biosample_urine_results_bio_c_mep_unit_u'
  • Creatine
    • 'bio_bm_biosample_urine_results_bio_creat_u'
    • 'bio_bm_biosample_urine_results_bio_creat_u_units'

Basic Demographics (sed_basic_demographics)🔗

• Values for 'Mother Education', 'Mother Income' and 'Mother Race' (multi) populated based on V01 onwards
• Updated ‘Description’ for selected items

Visit Data (par_visit_data)🔗

• Biological Mother (BioSpecimen & TLFB) SU Flags fields
  • Added 'from Biological Mother' to ‘Description’
  • Added *_bm_* abbreviation
• Child (Health V2) SU Flags fields
  • Added *_ch_* abbreviation
• Added ‘Stimulant’ Rollover SU flag field
• Updated 'Description' for Rollover SU flags in Visit Data
  • par_visit_data_su_flag_alcohol: 'Rolled up Alcohol SU flag across sources (BioSpecimens, TLFB Self-report, Health V2 FAS)'
  • par_visit_data_su_flag_cannabis: 'Rolled up Cannabis SU flag across sources (BioSpecimens, TLFB Self-report)'
  • par_visit_data_su_flag_nicotine: 'Rolled up Nicotine SU flag across sources (BioSpecimens, TLFB Self-report)'
  • par_visit_data_su_flag_opioid: 'Rolled up Opioid SU flag across sources (BioSpecimens, TLFB Self-report, Health V2 NOWS)'
  • par_visit_data_su_flag_stimulant: 'Rolled up Stimulant SU flag across sources (BioSpecimens, TLFB Self-report)'
• Removed open text entries in 'reason_visit_missed' field
  • Open text entries found only for the 'Other' entry (last concatenated response)
• Protocol Exception fields
  • ‘protocol_exception’
  • ‘protocol_exception_date’
• Withdrawal fields
  • Removed ‘withdrawal’ and ‘withdrawal_reason’
  • Replaced 'withdrawal_date' with 'missed_visit_date'

Data Dictionary🔗

• Added 'Description' content for 'Note' and other fields with blank 'Description' (APA, PMS, CDI)
  • Anthropometrics (ph_ch_anthro): ‘warning_message’
  • APA (pex_bm_apa):
    • ‘apa2_pers_note’
    • ‘apa2_anger_tscorenote’
    • ‘apa2_anx_tscorenote’
    • ‘apa2_somat_note’
    • ‘apa2_repet_focinote’
    • ‘apa2_mania_note’
    • ‘apa2_sleep_tscorenote’
• CDI (ncl_ch_cdiwgen): 'wd__people_nmw_001’
• PMS forms
  • ‘mh_cg_pms __cc__1to5_note’
  • ‘mh_cg_pms__cc__inf_note’
  • ‘mh_cg_pms__peer_note’
  • ‘mh_cg_pms__selfreg_note’
• Adjusted 'Description' for selected Demographics fields
• Changed 'source' for 'ra' forms from 'RA' to 'Research Assistant'
  • ‘RA Feedback’ (adm_ra_fbck)
  • ‘Pre/Post MRI Prep’ (mri_ra_prep)
• Set 'source' for 'Visit Data' as: 'General'
• Set 'domain' to 'Tabular Imaging' and 'Tabular EEG' for MR/EEG checklist forms
• Addition of ‘subdomain’ DD element:
  • ‘Administrative’ for MRI/EEG checklist forms
  • ‘n/a’ for all other forms
• Removed "Data entry not required" from TIC screener (sed_cg_tic_screener) table label

Database/Scoring🔗

• BISQ (ph_cg_bisq) Score fields
  • Added:
    • ‘parent_behavior_score’
    • ‘parent_perception_score’
    • ‘total_score’
  • Excluded (no data available):
    • ‘infant_sleep_score’
    • Can be calculated based on: ‘total_score’3 – (‘parent_behavior_score’ + ‘parent_perception_score’*)
• CHAOS (mh_cg_chaos)
  • Added prorated scoring
• EEG Checklist (eeg_ch_chkl)
  • Implemented mapping and correct allocation of values
• ecPROMIS instruments - Implemented prorated scoring and rescored:
  • ecPROMIS (1-5 y/o) - Caregiver-Child Interactions (mh_cg_pms__cc__1to5)
  • ecPROMIS (<1 y/o) Caregiver-Child Relationship Scale (mh_cg_pms__cc__inf)
  • ecPROMIS - Peer Relations (mh_cg_pms__peer)
  • ecPROMIS - Self Regulation (mh_cg_pms__selfreg)
• eHITS (sed_bm_ehits)
  • Made 'total_score' blank if all responses are NA/DK/DTA
  • Removed 'score' field
• ‘Pex Health’ forms
  • Adjustment to REDCap DD
  • Triggered import of missing values
• TLFB (pex_ch_tlfb):
  • TLFB breakdown fields (reported frequency use for substance subcategories per week) included
  • Modified parser to extract more accurate ‘Date of Administration’ for subset of cases submitted late (based on ‘time_first_session’ instead of ‘time_completion’)
• 'TIC Screener' (sed_cg_tic_screener)
  • Added 'Candidate Age' (candidate_age)
  • Based on 'Visit Start Date' as proxy for ‘Date of Administration’

Filters🔗

• List of measures & fields included/excluded - 2.0
• Anthropometrics (ph_ch_anthro): Excluded Z-Score fields
• BioSensor Setup (nt_ch_sens_setup) - Excluded:
  • ‘rlg_001_i_01_cf’
  • ‘llg_001_i_01_cf’
  • ‘srs_001_i_01’
• ecPROMIS PA/GS (ph_cg_pms__pags) - Excluded score fields:
  • ‘ph_cg_pms__pags_total_score’
  • ‘ph_cg_pms__pags_t_score’
  • ‘ph_cg_pms__pags_se_score’
• eHITS (sed_bm_ehits) - Removed 'score' field
• ‘Pre/Post MRI Prep’ (mri_ra_prep) - Excluded:
  • ‘mri_ra_prep_s1_mri_002’
  • ‘mri_ra_prep_s1_chk_001’ to ‘s1_chk_004’
  • ‘mri_ra_prep_s1_trp_001’ to ‘s4_trp_001’
• SPM-2 Toddler (ncl_cg_spm2_i_tod) - Included:
  • ‘ncl_cg_spm2_i_tod_tss_t_score’
  • ‘ncl_cg_spm2_i_tod_soc_t_score’
  • ‘ncl_cg_spm2_i_tod_vis_t_score’
  • ‘ncl_cg_spm2_i_tod_hea_t_score’
  • ‘ncl_cg_spm2_i_tod_tou_t_score’
  • ‘ncl_cg_spm2_i_tod_tstsml_t_score’
  • ‘ncl_cg_spm2_i_tod_bod_t_score’
  • ‘ncl_cg_spm2_i_tod_bal_t_score’
  • ‘ncl_cg_spm2_i_tod_pla_t_score’

Genomics/Geocoding/Study Navigator🔗

• Files included in ‘concatenated’ folder

BR20.2 Resolved Known Issues🔗

Demographics - Visit Information🔗

#	Table/Var	Fixed Issue/Update
1	par_visit_data	Remove 'protocol_exception' field (3 cases with 'IRB Deviation')
2	par_visit_data	Remove open text fields
3	par_visit_data	Remove 'participant_withdrawal' and 'participant_withdrawal_reason' fields
4	par_visit_data	Remove incorrect 'lol' test entry for 'Reason visit missed'
5	par_visit_data	Set 'source' to 'General' across all items and set 'description' to 'Biological Mother' for all SU flag fields

Behavior & Caregiver-Child Interaction🔗

#	Table/Var	Fixed Issue/Update
1	CHAOS	Scoring Correction: implement scoring, including prorated scores
2	ECBQ & IBQR	Remove Variables: administration (all, partial, none) & data_taken
3	ecPROMIS Peer Relationships	Correct prorated scoring
4	ecPROMIS Self-Reg/Flex	Correct prorated scoring
5	ecPROMIS Ch-CG Rel	Correct prorated scoring (for both versions: <1 yr & 1-5 yr)

Biospecimen & Omics🔗

#	Table/Var	Fixed Issue/Update
1	Urine	Remove Variables: Remove (1) bio_c_mep_u; bio_c_mep_u_cat; bio_c_mep_unit_u (only keep nmep[normeperidine]) and (2) Creatinine variables (e.g. bio_creat_u and associated units field)
2	Nails/Urine	Data Request: Add 'ANALYSIS DATE' for Biospec tables.

Novel Tech & Wearable Sensors🔗

#	Table/Var	Fixed Issue/Update
1	Biosensor Setup	Remove fields: (1) sensor plan, (2) _cf variable for RL ID a, (3) _cf variable for LL ID

Physical Health🔗

#	Table/Var	Fixed Issue/Update
1	BISQ	Add missing score fields: parent_behavior_score, parent_perception_score, total_score
2	ecPROMIS PA/Greenspace	Data Error: Add missing score fields
3	ecPROMIS PA/Greenspace	Removed score fields due to inaccurate values - noted as active known issue
4	Growth (ph_ch_anthro)	Removed z-scores recalculated based on actual DOB (added for 20.1) due to identifiability risks (this has been noted again as an active known issue)

Pregnancy & Exposure, Including Substance Use🔗

#	Table/Var	Fixed Issue/Update
1	ASSIST V1	SME Request: (1) Order variables in the order of the survey and (2) Remove adjusted age, candidate age, and sequence fields
2	ASSIST V2	SME Request: (1) Order variables in the order of the survey; (2) Remove sequence field; (3) Address blanks and 2 outliers (.47, .55) in candidate_age
3	ASSIST V3	SME Request: (1) Order variables in the order of the survey; (2) Remove sequence & gestational_age fields; (3) Address why candidate_age is < 3-9 months in some instances
4	DSM5 (pex_bm_str__ptsd)	SME Request: (1) Remove sequence field (V1-3); (2) Remove candidate_age from V1; (3) Remove gestational_age from V2, V3; (3) Address outliers in candidate_age at V2 & V3

Social & Environmental Determinants🔗

#	Table/Var	Fixed Issue/Update
1	sed_bm_ehits	Addressed differences between total_score and score
2	sed_cg_nsc (Experiences w/ Police)	Remove instrument

EEG🔗

#	Table/Var	Fixed Issue/Update
1	EEG	Addition of missing EEG capping quality variables for V03