Facilitating comprehensive child health monitoring within REDCap - an open-source code for real-time Z-score assessments Authors: Priyanka Mendon, Michael Witsch, Marianne Becker, Aurélie Adamski, Michel Vaillant Published: 2024 ABSTRACT BackgroundMonitoring of somatic development through the assessment of anthropometric variables such as weight, height, and BMI is vital for evaluating the physical development and nutritional status of children. This approach aids in the early identification of somatic developmental disorders, enabling timely medical interventions. It traditionally relies on Z-scores, which compare anthropometric variables with reference standards. In addition to somatic development monitoring, the early detection and management of pediatric and adolescent hypertension are crucial due to potential long-term health risks. However, manual calculations of Z-scores are time-consuming and error-prone, impeding timely interventions for at-risk children. This article introduces an innovative open-code solution for real-time Z-score assessments directly within the electronic data capture platform, Research Electronic Data Capture, (REDCap™), aiming to streamline the monitoring of somatic development in children.MethodsLeveraging the World Health Organization (WHO) growth standards and National Health and Nutrition Examination Survey (NHANES) references, our approach integrates Z-score computations directly into REDCap, providing a secure and user-friendly environment for healthcare professionals and researchers. We employed Bland-Altman analyses to compare our method with established calculators (Knirps and Growth XP™) using synthetic data values for all variables.ResultsBland-Altman plots demonstrated strong agreement between our REDCap calculations and the Knirps and Growth XP systems. Z-scores for height, BMI, and blood pressure consistently aligned, affirming the accuracy of our approach across the measurement range.ConclusionThe integration with REDCap streamlines data collection and analysis, eliminating the need for separate software and data exports. Moreover, our solution uses the World Health Organization (WHO) growth standards and National Health and Nutrition Examination Survey (NHANES) references. This not only ensures calculation accuracy but also enhances its suitability for diverse research contexts. The Bland-Altman analyses establish the reliability of our method, contributing to a more effective approach to child growth and blood pressure monitoring.Supplementary InformationThe online version contains supplementary material available at 10.1186/s12874-024-02405-0. Background Pediatric somatic development monitoring Monitoring somatic development in children plays a critical role in assessing their physical development and nutritional status of children. It involves comparing weight, height, and BMI measurements with standard values to detect early signs of developmental disorders and enable timely medical interventions, if indicated. Traditional methods employ Z-score and percentile calculations to assess a child’s growth, weight, and BMI status relative to a reference population, to identify stunted growth, obesity and accelerated growth [1, 2]. In addition to the described somatic monitoring, the early detection and management of pediatric and adolescent hypertension are vital due to the potential long-term health risks of unrecognized and hence untreated hypertension [3]. Existing tools and software Currently many tools and software offer Z-score and percentile calculations based on WHO 2007 standard growth charts.The “WHO Antroplus software” is a desktop software tool for applying WHO standards reference 2007 for 5–19 years to monitor the growth of school-age children and adolescents [4].The “CDC Growth Charts” from the Centers for Disease Control and Prevention (CDC) offer growth charts for children aged 0 to 20 years [5]. There is a free downloadable SAS program available to calculate the BMI Z-Scores and Percentiles.The EPI Info software from the CDC contains several nutritional anthropometry tools used to collect, analyze, and graph child growth data [6]. This module also contains a data entry form that automatically calculates Z-scores and percentiles, creates growth charts in Visual Dashboard, and has the ability to add Z-scores and percentiles to existing datasets.The RCPCH Digital Growth Charts API from the Royal College of Pediatrics and Child Health (RCPCH) includes a Digital Growth Charts API to accurately calculate centiles for a child’s height, weight, head circumference, and BMI on a subscription model to clinicians [7]. These growth charts are based on the WHO Child Growth Standards available for boys and girls of 2–18 years of age.Finally, the German Health Interview and Examination Survey for Children and Adolescents (KiGGS) conducted by the Robert Koch Institute in Germany, provides reference percentiles for anthropometric measures and blood pressure references for German children and adolescents, including height, weight, and BMI [8]. The “WHO Antroplus software” is a desktop software tool for applying WHO standards reference 2007 for 5–19 years to monitor the growth of school-age children and adolescents [4]. The “WHO Antroplus software” is a desktop software tool for applying WHO standards reference 2007 for 5–19 years to monitor the growth of school-age children and adolescents [4]. The “CDC Growth Charts” from the Centers for Disease Control and Prevention (CDC) offer growth charts for children aged 0 to 20 years [5]. There is a free downloadable SAS program available to calculate the BMI Z-Scores and Percentiles. The “CDC Growth Charts” from the Centers for Disease Control and Prevention (CDC) offer growth charts for children aged 0 to 20 years [5]. There is a free downloadable SAS program available to calculate the BMI Z-Scores and Percentiles. The EPI Info software from the CDC contains several nutritional anthropometry tools used to collect, analyze, and graph child growth data [6]. This module also contains a data entry form that automatically calculates Z-scores and percentiles, creates growth charts in Visual Dashboard, and has the ability to add Z-scores and percentiles to existing datasets. The EPI Info software from the CDC contains several nutritional anthropometry tools used to collect, analyze, and graph child growth data [6]. This module also contains a data entry form that automatically calculates Z-scores and percentiles, creates growth charts in Visual Dashboard, and has the ability to add Z-scores and percentiles to existing datasets. The RCPCH Digital Growth Charts API from the Royal College of Pediatrics and Child Health (RCPCH) includes a Digital Growth Charts API to accurately calculate centiles for a child’s height, weight, head circumference, and BMI on a subscription model to clinicians [7]. These growth charts are based on the WHO Child Growth Standards available for boys and girls of 2–18 years of age. The RCPCH Digital Growth Charts API from the Royal College of Pediatrics and Child Health (RCPCH) includes a Digital Growth Charts API to accurately calculate centiles for a child’s height, weight, head circumference, and BMI on a subscription model to clinicians [7]. These growth charts are based on the WHO Child Growth Standards available for boys and girls of 2–18 years of age. Finally, the German Health Interview and Examination Survey for Children and Adolescents (KiGGS) conducted by the Robert Koch Institute in Germany, provides reference percentiles for anthropometric measures and blood pressure references for German children and adolescents, including height, weight, and BMI [8]. Finally, the German Health Interview and Examination Survey for Children and Adolescents (KiGGS) conducted by the Robert Koch Institute in Germany, provides reference percentiles for anthropometric measures and blood pressure references for German children and adolescents, including height, weight, and BMI [8]. About REDCap Research Electronic Data Capture (REDCap) [9] is a secure web platform created in 2004 at Vanderbilt University. Designed for researchers to design, develop, and manage online databases and surveys, REDCap offers a streamlined process for rapid project creation. It provides a vast array of tools that can be tailored to virtually any data collection strategy. REDCap provides automated export procedures for seamless data downloads to Excel and common statistical packages (SPSS, SAS, Stata, R), a built-in project calendar, a scheduling module, ad hoc reporting tools, and advanced features such as branching logic, file uploading, and calculated fields. It is widely used in academic research institutions. The REDCap Consortium has 6,634 active partners in 154 countries. Notably, it is free to non-profit organizations that join the REDCap Consortium [9]. Need for developing a clinical data collection interface for real-time Z-score calculations An assessment of the existing tools and software reveals a lack of freely available options with real-time calculations specifically tailored to child somatic development monitoring and blood pressure studies. It is also observed that these tools are non-integrated into a secure web-based platform that facilitates structured data collection and analysis in clinical settings. The REDCap Shared Library [10] offers a repository of data collection instruments and forms that are available for download and use by researchers at REDCap partner institutions. However, currently there is no instrument available in the Shared Library that provides automated Z-score computations, which are required for a project for screening of Familial Hypercholesterolemia in School Children in Luxembourg [11]. This study aimed to assess the prevalence of familial hypercholesterolemia in primary school children in Luxembourg City between 7 and 12 years old, invited for their mandatory medical school examinations between 2021 and 2023. This study serves as a relevant reference for the context and importance of real-time Z-score calculations, providing valuable insights into the application of growth monitoring and blood pressure assessments in a large-scale research setting. To address this need gap, we designed a data collection instrument to collect variables and incorporate backend calculations, to allow real-time Z-Score computations by leveraging the ease of use of REDCap. This instrument was then validated by adding synthetic participant values in REDCap and two comparator software tools to verify the accuracy of the resulting values. In this paper, we present a comprehensive overview of our methodology, the implementation of real-time Z-score calculations within the REDCap platform, and validation by comparison with two existing software tools. By sharing this open code solution, we aim to promote standardized growth and blood pressure assessments, facilitate timely interventions, and enhance evidence-based pediatric care. The objective is to foster collaboration and avoid duplicative efforts in similar studies. Enabling researchers to access the code would promote sustainability for future research on child growth and hypertension by providing a robust tool for real-time Z-score computations. Methods The Methods section describes the rationale of selecting REDCap, the growth standards used for computations, and how the data collection instrument was designed with back end calculations. Rationale of selecting REDCap The user-friendly interface requires no background knowledge or technical expertise. REDCap’s web-based nature is compliant with 21CFR part 11 (Part 11 of Title 21 of the Code of Federal Regulations), FISMA (Federal Information Security Modernization Act), HIPAA (Health Insurance Portability and Accountability Act) and GDPR (General Data Protection Regulation). This software is available at no cost for REDCap Consortium partners. Thus, REDCap makes an ideal choice for data collection instruments due to its broad accessibility. For this project, REDCap version 13.1.29 was used. Server Information: REDCap 13.1.29, PHP 7.4.33 (Linux/Unix OS), MariaDB 10.3.39. For calculated field algorithms, REDCap uses JavaScript as the primary scripting language along with various other scripting-related functionalities. The calculated field option is available in the “Online Designer” module in the Project Setup. The JavaScript code allows for real-time calculations and immediate feedback, such as the pop-up confirming the validity of the calculation or alerting the user if there is an error in the algorithm. In addition, REDCap has a data quality tool, Rule#H, for re-calculating and fixing all calculated fields [12]. Calculated fields are fields whose values depend on formulas or logic from other data. Rule H is useful when a change is made to an existing calculated field or a new calculated field type is added to an existing project. To aid the user, a notification appears directing them to the Data Quality Page to fix the calculations as seen in Fig. 1 [13]. Upon executing Rule H, a list of all fields that require revision appears, and they can be updated using the ‘Fix Calcs Now’ button as seen in Fig. 2. Fig. 1Screen capture of REDCap notification when calculated fields are updated Screen capture of REDCap notification when calculated fields are updated Fig. 2Screencapture of REDCap data quality module, rule H window describing the list of calculated fields requiring review Screencapture of REDCap data quality module, rule H window describing the list of calculated fields requiring review Description of the growth standards used The algorithm utilizes the World Health Organization (WHO) growth standards (5 to 19 years) developed in 2007, providing a single growth reference for school-aged children and adolescents [14–16]. The WHO standards are the first globally representative growth standards [17]. To enable accurate blood pressure assessments, we employ the National Health and Nutrition Examination Survey (NHANES) LMS tables for the calculation of Height Z-scores, along with age and sex data referring to the guidelines proposed in “The Fourth Report on the Diagnosis, Evaluation, and Treatment of High Blood Pressure in Children and Adolescents” [18] . NHANES provides data that are instrumental in establishing growth and health standards. Blood pressure standards based on sex, age, and height, provide a more precise classification of blood pressure according to body size. In clinical settings, the height percentile is determined by using the CDC Growth Charts, employing the pre-calculated LMS values for height-for-age (HA) and sex assessment. The LMS method uses three parameters: the median (M), the generalized coefficient of variation (S), and the power in the Box-Cox transformation (L). The LMS method adjusts for skewness and kurtosis in the distribution of anthropometric data, providing a more accurate reflection of the underlying growth patterns. This is crucial for variables like height and BMI, which may not follow a normal distribution. The height Z-score is then used in the computation of the systolic and diastolic blood pressure Z-score. Overview of creating the open code STEP 1: Create a data collection instrument in REDCap A new project was created in REDCap by logging into the REDCap URL of our institution. The “Online Designer” module in REDCap was used to create a new instrument (or data entry form) for data collection as seen in Fig. 3. Fig. 3Screengrab of REDCap dashboard. “Online designer” module is used to create data entry fields Screengrab of REDCap dashboard. “Online designer” module is used to create data entry fields Synthetic data for below variables was collected in the data entry form: Date of InclusionMonth and Year of BirthAge in months calculation: (Inclusion Month and Year) – (Month and Year of Birth)GenderWeight in kilograms (W)Height in centimeters (H)BMI (Calculated field): Calculation: (([W]*10000)/ (([H]) ^ (2)), 1)Systolic Blood Pressure in mmHgDiastolic Blood Pressure in mmHg Date of Inclusion Date of Inclusion Month and Year of Birth Month and Year of Birth Age in months calculation: (Inclusion Month and Year) – (Month and Year of Birth) Age in months calculation: (Inclusion Month and Year) – (Month and Year of Birth) Gender Gender Weight in kilograms (W) Weight in kilograms (W) Height in centimeters (H) Height in centimeters (H) BMI (Calculated field): Calculation: (([W]*10000)/ (([H]) ^ (2)), 1) BMI (Calculated field): Calculation: (([W]*10000)/ (([H]) ^ (2)), 1) Systolic Blood Pressure in mmHg Systolic Blood Pressure in mmHg Diastolic Blood Pressure in mmHg Diastolic Blood Pressure in mmHg STEP 2: Create L, M, S “repository” variables to compute Z-Scores for height for age and BMI for age [16, 19–24] The LMS parameters are the median (M), the generalized coefficient of variation (S), and the power in the Box-Cox transformation (L). The 2007 WHO Reference on Z-scores enlist L, M, and S values for children aged 5 to 19 for height and BMI for both boys and girls. Conditional calculated fields were created for L, M, and S for height-for-age and BMI-for-age for boys and girls from 84 months to 228 months in REDCap. Example: L for BMI of 84 month old girl child: (if ([agemnth_sc] = 84 and [sex_sc] = 2, -1.2565,“”) STEP 3: Compute Z-score for height-for-age and BMI-for-age The following computation is used to calculate a Z-score for an individual child (Zind) with measurement y at age t: Create calculated field \documentclass[12pt]{minimal} \usepackage{amsmath} \usepackage{wasysym} \usepackage{amsfonts} \usepackage{amssymb} \usepackage{amsbsy} \usepackage{mathrsfs} \usepackage{upgreek} \setlength{\oddsidemargin}{-69pt} \begin{document}$$Z_{ind}$$\end{document}Zind \documentclass[12pt]{minimal} \usepackage{amsmath} \usepackage{wasysym} \usepackage{amsfonts} \usepackage{amssymb} \usepackage{amsbsy} \usepackage{mathrsfs} \usepackage{upgreek} \setlength{\oddsidemargin}{-69pt} \begin{document}$$Z_{ind}=\frac{\left[y/M\left(t\right)\right]^{L\left(t\right)}-1}{S\left(t\right)\mathit\cdot\mathit\;L\left(t\right)}$$\end{document}Zind=y/MtLt-1St·Lt Create calculated field \documentclass[12pt]{minimal} \usepackage{amsmath} \usepackage{wasysym} \usepackage{amsfonts} \usepackage{amssymb} \usepackage{amsbsy} \usepackage{mathrsfs} \usepackage{upgreek} \setlength{\oddsidemargin}{-69pt} \begin{document}$$Z_{ind}$$\end{document}Zind \documentclass[12pt]{minimal} \usepackage{amsmath} \usepackage{wasysym} \usepackage{amsfonts} \usepackage{amssymb} \usepackage{amsbsy} \usepackage{mathrsfs} \usepackage{upgreek} \setlength{\oddsidemargin}{-69pt} \begin{document}$$Z_{ind}=\frac{\left[y/M\left(t\right)\right]^{L\left(t\right)}-1}{S\left(t\right)\mathit\cdot\mathit\;L\left(t\right)}$$\end{document}Zind=y/MtLt-1St·Lt Create calculated field \documentclass[12pt]{minimal} \usepackage{amsmath} \usepackage{wasysym} \usepackage{amsfonts} \usepackage{amssymb} \usepackage{amsbsy} \usepackage{mathrsfs} \usepackage{upgreek} \setlength{\oddsidemargin}{-69pt} \begin{document}$$Z_{ind}$$\end{document}Zind \documentclass[12pt]{minimal} \usepackage{amsmath} \usepackage{wasysym} \usepackage{amsfonts} \usepackage{amssymb} \usepackage{amsbsy} \usepackage{mathrsfs} \usepackage{upgreek} \setlength{\oddsidemargin}{-69pt} \begin{document}$$Z_{ind}=\frac{\left[y/M\left(t\right)\right]^{L\left(t\right)}-1}{S\left(t\right)\mathit\cdot\mathit\;L\left(t\right)}$$\end{document}Zind=y/MtLt-1St·Lt 2.Compute the final Z-Score (Z*ind ) of the child for that indicator as:\documentclass[12pt]{minimal} \usepackage{amsmath} \usepackage{wasysym} \usepackage{amsfonts} \usepackage{amssymb} \usepackage{amsbsy} \usepackage{mathrsfs} \usepackage{upgreek} \setlength{\oddsidemargin}{-69pt} \begin{document}$$\begin{array}{r}\mathbf Z_{ind}^\ast={\mathbf Z}_{ind}\\If\;Z_{ind}<=3\end{array}$$\end{document}Zind*=ZindIfZind<=3\documentclass[12pt]{minimal} \usepackage{amsmath} \usepackage{wasysym} \usepackage{amsfonts} \usepackage{amssymb} \usepackage{amsbsy} \usepackage{mathrsfs} \usepackage{upgreek} \setlength{\oddsidemargin}{-69pt} \begin{document}$$\begin{array}{r}\mathbf Z_{ind}^\ast=3+\left(\frac{\boldsymbol y\boldsymbol-\boldsymbol S\boldsymbol D\mathbf3\boldsymbol p\boldsymbol o\boldsymbol s}{\boldsymbol S\boldsymbol D\mathbf{23}\boldsymbol p\boldsymbol o\boldsymbol s}\right)\\If\:Z_{ind\:\:\:}>3\end{array}$$\end{document}Zind*=3+y-SD3posSD23posIfZind>3\documentclass[12pt]{minimal} \usepackage{amsmath} \usepackage{wasysym} \usepackage{amsfonts} \usepackage{amssymb} \usepackage{amsbsy} \usepackage{mathrsfs} \usepackage{upgreek} \setlength{\oddsidemargin}{-69pt} \begin{document}$$\begin{array}{r}\boldsymbol Z_{ind}^\ast=-3+\left(\frac{\boldsymbol y\boldsymbol-\boldsymbol S\boldsymbol D\mathbf3\boldsymbol\:\boldsymbol n\boldsymbol e\boldsymbol g}{\boldsymbol S\boldsymbol D\mathbf{23}\boldsymbol\:\boldsymbol n\boldsymbol e\boldsymbol g}\right)\\If\:Z_{ind\:\:\:}<-3\end{array}$$\end{document}Zind*=-3+y-SD3negSD23negIfZind<-3 2.Compute the final Z-Score (Z*ind ) of the child for that indicator as: Compute the final Z-Score (Z*ind ) of the child for that indicator as: Where SD3pos is the cut-off 3 Standard Deviation calculated at age t by the LMS method: \documentclass[12pt]{minimal} \usepackage{amsmath} \usepackage{wasysym} \usepackage{amsfonts} \usepackage{amssymb} \usepackage{amsbsy} \usepackage{mathrsfs} \usepackage{upgreek} \setlength{\oddsidemargin}{-69pt} \begin{document}$$\boldsymbol S\boldsymbol D\boldsymbol3\boldsymbol p\boldsymbol o\boldsymbol s\:=\:\boldsymbol M\mathit(\boldsymbol t\mathit){\lbrack1\:+\:\boldsymbol L(\boldsymbol t)\;\ast\;\boldsymbol S(\boldsymbol t)\;\ast\;(3)\rbrack}^{\mathbf1\boldsymbol/\boldsymbol L\boldsymbol(\boldsymbol t\boldsymbol)}$$\end{document}SD3pos=M(t)[1+L(t)*S(t)*(3)]1/L(t) SD3neg is the cut-off − 3 Standard Deviation calculated at age t by the LMS method: \documentclass[12pt]{minimal} \usepackage{amsmath} \usepackage{wasysym} \usepackage{amsfonts} \usepackage{amssymb} \usepackage{amsbsy} \usepackage{mathrsfs} \usepackage{upgreek} \setlength{\oddsidemargin}{-69pt} \begin{document}$$\boldsymbol S\boldsymbol D\mathbf3\boldsymbol n\boldsymbol e\boldsymbol g\boldsymbol\:\boldsymbol=\boldsymbol\:\boldsymbol M\boldsymbol(\boldsymbol t\boldsymbol){\boldsymbol\lbrack\mathbf1\boldsymbol\:\boldsymbol+\boldsymbol\:\boldsymbol L\boldsymbol(\boldsymbol t\boldsymbol)\boldsymbol\;\boldsymbol\ast\boldsymbol\;\boldsymbol S\boldsymbol(\boldsymbol t\boldsymbol)\boldsymbol\;\boldsymbol\ast\boldsymbol(\boldsymbol-\mathbf3\boldsymbol)\boldsymbol\rbrack}^{\mathbf1\boldsymbol/\boldsymbol L\boldsymbol(\boldsymbol t\boldsymbol)}$$\end{document}SD3neg=M(t)[1+L(t)*S(t)*(-3)]1/L(t) SD23pos is the difference between the cut-offs 3 Standard Deviation and 2 Standard Deviation calculated at age t by the LMS method: \documentclass[12pt]{minimal} \usepackage{amsmath} \usepackage{wasysym} \usepackage{amsfonts} \usepackage{amssymb} \usepackage{amsbsy} \usepackage{mathrsfs} \usepackage{upgreek} \setlength{\oddsidemargin}{-69pt} \begin{document}$$\boldsymbol S\boldsymbol D\mathbf{23}\boldsymbol p\boldsymbol o\boldsymbol s\boldsymbol\:\boldsymbol=\boldsymbol\:\boldsymbol M\boldsymbol(\boldsymbol t\boldsymbol)\boldsymbol\lbrack\mathbf1\boldsymbol+\boldsymbol L\boldsymbol(\boldsymbol t\boldsymbol)\boldsymbol\;\boldsymbol\ast\boldsymbol\;\boldsymbol S\boldsymbol(\boldsymbol t\boldsymbol)\boldsymbol\;\boldsymbol\ast\boldsymbol\;{\boldsymbol(\mathbf3\boldsymbol)\boldsymbol\rbrack\boldsymbol)}^{\mathbf1\boldsymbol/\boldsymbol L\boldsymbol(\boldsymbol t\boldsymbol)}\boldsymbol-\boldsymbol\;\boldsymbol M\boldsymbol(\boldsymbol t\boldsymbol){\boldsymbol\lbrack\mathbf1\boldsymbol+\boldsymbol L\boldsymbol(\boldsymbol t\boldsymbol)\boldsymbol\;\boldsymbol\ast\boldsymbol S\boldsymbol\;\boldsymbol(\boldsymbol t\boldsymbol)\boldsymbol\ast\boldsymbol\;\boldsymbol(\mathbf2\boldsymbol)\boldsymbol\rbrack}^{\mathbf1\boldsymbol/\boldsymbol L\boldsymbol(\boldsymbol t\boldsymbol)}$$\end{document}SD23pos=M(t)[1+L(t)*S(t)*(3)])1/L(t)-M(t)[1+L(t)*S(t)*(2)]1/L(t) SD23neg is the difference between the cut-offs − 2 Standard Deviation and − 3 Standard Deviation calculated at age t by the LMS method: \documentclass[12pt]{minimal} \usepackage{amsmath} \usepackage{wasysym} \usepackage{amsfonts} \usepackage{amssymb} \usepackage{amsbsy} \usepackage{mathrsfs} \usepackage{upgreek} \setlength{\oddsidemargin}{-69pt} \begin{document}$$\boldsymbol S\boldsymbol D\mathbf{23}\boldsymbol n\boldsymbol e\boldsymbol g\boldsymbol\:\boldsymbol=\boldsymbol\:\boldsymbol M\boldsymbol(\boldsymbol t\boldsymbol){\boldsymbol\lbrack\mathbf1\boldsymbol+\boldsymbol L\boldsymbol(\boldsymbol t\boldsymbol)\boldsymbol\;\boldsymbol\ast\boldsymbol\;\boldsymbol S\boldsymbol(\boldsymbol t\boldsymbol)\boldsymbol\;\boldsymbol\ast\boldsymbol(\boldsymbol-\mathbf2\boldsymbol)\boldsymbol\rbrack}^{\mathbf1\boldsymbol/\boldsymbol L\boldsymbol(\boldsymbol t\boldsymbol)}\boldsymbol-\boldsymbol\;\boldsymbol M\boldsymbol(\boldsymbol t\boldsymbol){\boldsymbol\lbrack\mathbf1\boldsymbol\:\boldsymbol+\boldsymbol\:\boldsymbol L\boldsymbol(\boldsymbol t\boldsymbol)\boldsymbol\;\boldsymbol\ast\boldsymbol S\boldsymbol\;\boldsymbol(\boldsymbol t\boldsymbol)\boldsymbol\ast\boldsymbol(\boldsymbol-\mathbf3\boldsymbol)\boldsymbol\rbrack}^{\mathbf1\boldsymbol/\boldsymbol L\boldsymbol(\boldsymbol t\boldsymbol)}$$\end{document}SD23neg=M(t)[1+L(t)*S(t)*(-2)]1/L(t)-M(t)[1+L(t)*S(t)*(-3)]1/L(t) STEP 4: Create L, M, S “repository” variables to compute Z-scores for systolic and diastolic blood pressure CDC growth charts (NHANES references) on Z Scores enlist L, M and S values for children from the age of 5 to 19 for Height for boys and girls. Conditional calculated fields were created for L, M and S for Height for age. STEP 5: Compute Z-Score for height for age and BMI for age The computation of Blood Pressure Percentile (µ) of age y years and height h in centimeters was done using the following equation: 1\documentclass[12pt]{minimal} \usepackage{amsmath} \usepackage{wasysym} \usepackage{amsfonts} \usepackage{amssymb} \usepackage{amsbsy} \usepackage{mathrsfs} \usepackage{upgreek} \setlength{\oddsidemargin}{-69pt} \begin{document}$$\:\mu\:=\alpha\:+\sum_{J=1}^4{\beta\:}_j\left(y-10\right)^j+\sum_{k=1}^4{\gamma\:}_k\left(Zht\right)^k$$\end{document}μ=α+∑J=14βjy-10j+∑k=14γkZhtk Where, α, β1…, β4 and γ1…, γ4 are taken from Table 1. Table 1Regression coefficients from blood pressure regression modelsVariable NameSymbolSystolic Blood PressureDiastolic Blood PressureMaleFemaleMaleFemaleInterceptα102.19768102.0102761.0121760.50510Age Age-10β11.824161.943970.683141.01301 (Age-10)2β20.127760.0598-0.098350.01157 (Age-10)3β30.00249-0.007890.017110.00424 (Age-10)4β4-0.00135-0.000590.0045-0.00137Normalized Height Zhtγ12.731572.035261.469931.16641 Zht2γ2-0.196180.02534-0.078490.12795 Zht3γ3-0.04659-0.01884-0.03144-0.03869 Zht4γ40.009470.001210.0967-0.00079 Standard Deviationσ10.712810.485511.603210.9573 ρ0.41000.38240.24360.2598 n (Persons)32,16131,06624,05723,443 n (visits)42,07441,01729,18228,794 Table 1Regression coefficients from blood pressure regression modelsVariable NameSymbolSystolic Blood PressureDiastolic Blood PressureMaleFemaleMaleFemaleInterceptα102.19768102.0102761.0121760.50510Age Age-10β11.824161.943970.683141.01301 (Age-10)2β20.127760.0598-0.098350.01157 (Age-10)3β30.00249-0.007890.017110.00424 (Age-10)4β4-0.00135-0.000590.0045-0.00137Normalized Height Zhtγ12.731572.035261.469931.16641 Zht2γ2-0.196180.02534-0.078490.12795 Zht3γ3-0.04659-0.01884-0.03144-0.03869 Zht4γ40.009470.001210.0967-0.00079 Standard Deviationσ10.712810.485511.603210.9573 ρ0.41000.38240.24360.2598 n (Persons)32,16131,06624,05723,443 n (visits)42,07441,01729,18228,794 Regression coefficients from blood pressure regression models The percentile blood Pressure (µ) is then converted to Z-score with the below equation:\documentclass[12pt]{minimal} \usepackage{amsmath} \usepackage{wasysym} \usepackage{amsfonts} \usepackage{amssymb} \usepackage{amsbsy} \usepackage{mathrsfs} \usepackage{upgreek} \setlength{\oddsidemargin}{-69pt} \begin{document}$$\:\mathbf{\left({x-\mu\:}\right)}\boldsymbol/\boldsymbol\sigma$$\end{document}x-μ/σ Where σ (Standard Deviation) is taken from Table 1, and x is the actual blood pressure reading of the participant. RedCap syntaxes for the Z-score calculation of Blood Pressure: Systolic Blood Pressure SDS value for male participants (MSDSSYS):\documentclass[12pt]{minimal} \usepackage{amsmath} \usepackage{wasysym} \usepackage{amsfonts} \usepackage{amssymb} \usepackage{amsbsy} \usepackage{mathrsfs} \usepackage{upgreek} \setlength{\oddsidemargin}{-69pt} \begin{document}$$\mathrm{MSDSSYS}\:=\:102.19768+((((\lbrack A\rbrack)/12)-\:10)\ast1.82416)+((({(\lbrack A\rbrack)/12)-\:10)}^\wedge(2)\ast(0.12776))+((({(\lbrack A\rbrack)/12)-\:10)}^\wedge(3))\ast(0.00249)+((({(\lbrack A\rbrack)/12)-\:10)}^\wedge(4)\ast(-0.00135))+(\lbrack B\rbrack\ast2.73157)+((\lbrack B\rbrack\ast\lbrack B\rbrack)\ast(-0.19618))+(({(\lbrack B\rbrack)}^\wedge(3))\ast(-0.04659))+({(\lbrack B\rbrack)}^\wedge(4))\ast0.00947$$\end{document}MSDSSYS=102.19768+(((([A])/12)-10)*1.82416)+(((([A])/12)-10)∧(2)*(0.12776))+(((([A])/12)-10)∧(3))*(0.00249)+(((([A])/12)-10)∧(4)*(-0.00135))+([B]*2.73157)+(([B]*[B])*(-0.19618))+((([B])∧(3))*(-0.04659))+(([B])∧(4))*0.00947\documentclass[12pt]{minimal} \usepackage{amsmath} \usepackage{wasysym} \usepackage{amsfonts} \usepackage{amssymb} \usepackage{amsbsy} \usepackage{mathrsfs} \usepackage{upgreek} \setlength{\oddsidemargin}{-69pt} \begin{document}$$\mathrm Z-\mathrm{Score}=(\lbrack C\rbrack-\lbrack\mathrm{MSDSSYS}\rbrack)/10.7218$$\end{document}Z-Score=([C]-[MSDSSYS])/10.7218 Systolic Blood Pressure SDS value for male participants (MSDSSYS):\documentclass[12pt]{minimal} \usepackage{amsmath} \usepackage{wasysym} \usepackage{amsfonts} \usepackage{amssymb} \usepackage{amsbsy} \usepackage{mathrsfs} \usepackage{upgreek} \setlength{\oddsidemargin}{-69pt} \begin{document}$$\mathrm{MSDSSYS}\:=\:102.19768+((((\lbrack A\rbrack)/12)-\:10)\ast1.82416)+((({(\lbrack A\rbrack)/12)-\:10)}^\wedge(2)\ast(0.12776))+((({(\lbrack A\rbrack)/12)-\:10)}^\wedge(3))\ast(0.00249)+((({(\lbrack A\rbrack)/12)-\:10)}^\wedge(4)\ast(-0.00135))+(\lbrack B\rbrack\ast2.73157)+((\lbrack B\rbrack\ast\lbrack B\rbrack)\ast(-0.19618))+(({(\lbrack B\rbrack)}^\wedge(3))\ast(-0.04659))+({(\lbrack B\rbrack)}^\wedge(4))\ast0.00947$$\end{document}MSDSSYS=102.19768+(((([A])/12)-10)*1.82416)+(((([A])/12)-10)∧(2)*(0.12776))+(((([A])/12)-10)∧(3))*(0.00249)+(((([A])/12)-10)∧(4)*(-0.00135))+([B]*2.73157)+(([B]*[B])*(-0.19618))+((([B])∧(3))*(-0.04659))+(([B])∧(4))*0.00947\documentclass[12pt]{minimal} \usepackage{amsmath} \usepackage{wasysym} \usepackage{amsfonts} \usepackage{amssymb} \usepackage{amsbsy} \usepackage{mathrsfs} \usepackage{upgreek} \setlength{\oddsidemargin}{-69pt} \begin{document}$$\mathrm Z-\mathrm{Score}=(\lbrack C\rbrack-\lbrack\mathrm{MSDSSYS}\rbrack)/10.7218$$\end{document}Z-Score=([C]-[MSDSSYS])/10.7218 Systolic Blood Pressure SDS value for male participants (MSDSSYS):\documentclass[12pt]{minimal} \usepackage{amsmath} \usepackage{wasysym} \usepackage{amsfonts} \usepackage{amssymb} \usepackage{amsbsy} \usepackage{mathrsfs} \usepackage{upgreek} \setlength{\oddsidemargin}{-69pt} \begin{document}$$\mathrm{MSDSSYS}\:=\:102.19768+((((\lbrack A\rbrack)/12)-\:10)\ast1.82416)+((({(\lbrack A\rbrack)/12)-\:10)}^\wedge(2)\ast(0.12776))+((({(\lbrack A\rbrack)/12)-\:10)}^\wedge(3))\ast(0.00249)+((({(\lbrack A\rbrack)/12)-\:10)}^\wedge(4)\ast(-0.00135))+(\lbrack B\rbrack\ast2.73157)+((\lbrack B\rbrack\ast\lbrack B\rbrack)\ast(-0.19618))+(({(\lbrack B\rbrack)}^\wedge(3))\ast(-0.04659))+({(\lbrack B\rbrack)}^\wedge(4))\ast0.00947$$\end{document}MSDSSYS=102.19768+(((([A])/12)-10)*1.82416)+(((([A])/12)-10)∧(2)*(0.12776))+(((([A])/12)-10)∧(3))*(0.00249)+(((([A])/12)-10)∧(4)*(-0.00135))+([B]*2.73157)+(([B]*[B])*(-0.19618))+((([B])∧(3))*(-0.04659))+(([B])∧(4))*0.00947\documentclass[12pt]{minimal} \usepackage{amsmath} \usepackage{wasysym} \usepackage{amsfonts} \usepackage{amssymb} \usepackage{amsbsy} \usepackage{mathrsfs} \usepackage{upgreek} \setlength{\oddsidemargin}{-69pt} \begin{document}$$\mathrm Z-\mathrm{Score}=(\lbrack C\rbrack-\lbrack\mathrm{MSDSSYS}\rbrack)/10.7218$$\end{document}Z-Score=([C]-[MSDSSYS])/10.7218 With A: Redcap variable for the age of participants in months. B: Redcap variable containing the calculated ZScore for Height. C: Systolic Blood Pressure reading of participant. 2.Systolic Blood Pressure SDS value (SYSSDS1) and Z-Score for female participants:\documentclass[12pt]{minimal} \usepackage{amsmath} \usepackage{wasysym} \usepackage{amsfonts} \usepackage{amssymb} \usepackage{amsbsy} \usepackage{mathrsfs} \usepackage{upgreek} \setlength{\oddsidemargin}{-69pt} \begin{document}$$\mathrm{SYSSDS}1\:=\:102.01027+(((\lbrack A\rbrack/12)-\:10)\ast1.94397)+(((\lbrack A\rbrack/12)-\:10{)^\wedge(}2)\ast(0.00598))+(((\lbrack A\rbrack/12)-\:10{)^\wedge(}3))\ast(-0.00789)+(((\lbrack A\rbrack/12)-\:10{)^\wedge(}4)\ast(-0.00059))+(\lbrack B\rbrack\ast2.03526)+((\lbrack B\rbrack\ast\lbrack B\rbrack)\ast0.02534)+(((\lbrack B\rbrack{)^\wedge(}3))\ast(-0.01884))+((\lbrack B\rbrack{)^\wedge(}4))\ast0.00121.$$\end{document}SYSSDS1=102.01027+((([A]/12)-10)*1.94397)+((([A]/12)-10)∧(2)*(0.00598))+((([A]/12)-10)∧(3))*(-0.00789)+((([A]/12)-10)∧(4)*(-0.00059))+([B]*2.03526)+(([B]*[B])*0.02534)+((([B])∧(3))*(-0.01884))+(([B])∧(4))*0.00121.\documentclass[12pt]{minimal} \usepackage{amsmath} \usepackage{wasysym} \usepackage{amsfonts} \usepackage{amssymb} \usepackage{amsbsy} \usepackage{mathrsfs} \usepackage{upgreek} \setlength{\oddsidemargin}{-69pt} \begin{document}$$\mathrm Z-\mathrm{Score}\;=\;(\lbrack\mathrm C\rbrack-\lbrack\mathrm{SYSSDS}1\rbrack)/10.4855$$\end{document}Z-Score=([C]-[SYSSDS1])/10.4855 2.Systolic Blood Pressure SDS value (SYSSDS1) and Z-Score for female participants:\documentclass[12pt]{minimal} \usepackage{amsmath} \usepackage{wasysym} \usepackage{amsfonts} \usepackage{amssymb} \usepackage{amsbsy} \usepackage{mathrsfs} \usepackage{upgreek} \setlength{\oddsidemargin}{-69pt} \begin{document}$$\mathrm{SYSSDS}1\:=\:102.01027+(((\lbrack A\rbrack/12)-\:10)\ast1.94397)+(((\lbrack A\rbrack/12)-\:10{)^\wedge(}2)\ast(0.00598))+(((\lbrack A\rbrack/12)-\:10{)^\wedge(}3))\ast(-0.00789)+(((\lbrack A\rbrack/12)-\:10{)^\wedge(}4)\ast(-0.00059))+(\lbrack B\rbrack\ast2.03526)+((\lbrack B\rbrack\ast\lbrack B\rbrack)\ast0.02534)+(((\lbrack B\rbrack{)^\wedge(}3))\ast(-0.01884))+((\lbrack B\rbrack{)^\wedge(}4))\ast0.00121.$$\end{document}SYSSDS1=102.01027+((([A]/12)-10)*1.94397)+((([A]/12)-10)∧(2)*(0.00598))+((([A]/12)-10)∧(3))*(-0.00789)+((([A]/12)-10)∧(4)*(-0.00059))+([B]*2.03526)+(([B]*[B])*0.02534)+((([B])∧(3))*(-0.01884))+(([B])∧(4))*0.00121.\documentclass[12pt]{minimal} \usepackage{amsmath} \usepackage{wasysym} \usepackage{amsfonts} \usepackage{amssymb} \usepackage{amsbsy} \usepackage{mathrsfs} \usepackage{upgreek} \setlength{\oddsidemargin}{-69pt} \begin{document}$$\mathrm Z-\mathrm{Score}\;=\;(\lbrack\mathrm C\rbrack-\lbrack\mathrm{SYSSDS}1\rbrack)/10.4855$$\end{document}Z-Score=([C]-[SYSSDS1])/10.4855 Systolic Blood Pressure SDS value (SYSSDS1) and Z-Score for female participants:\documentclass[12pt]{minimal} \usepackage{amsmath} \usepackage{wasysym} \usepackage{amsfonts} \usepackage{amssymb} \usepackage{amsbsy} \usepackage{mathrsfs} \usepackage{upgreek} \setlength{\oddsidemargin}{-69pt} \begin{document}$$\mathrm{SYSSDS}1\:=\:102.01027+(((\lbrack A\rbrack/12)-\:10)\ast1.94397)+(((\lbrack A\rbrack/12)-\:10{)^\wedge(}2)\ast(0.00598))+(((\lbrack A\rbrack/12)-\:10{)^\wedge(}3))\ast(-0.00789)+(((\lbrack A\rbrack/12)-\:10{)^\wedge(}4)\ast(-0.00059))+(\lbrack B\rbrack\ast2.03526)+((\lbrack B\rbrack\ast\lbrack B\rbrack)\ast0.02534)+(((\lbrack B\rbrack{)^\wedge(}3))\ast(-0.01884))+((\lbrack B\rbrack{)^\wedge(}4))\ast0.00121.$$\end{document}SYSSDS1=102.01027+((([A]/12)-10)*1.94397)+((([A]/12)-10)∧(2)*(0.00598))+((([A]/12)-10)∧(3))*(-0.00789)+((([A]/12)-10)∧(4)*(-0.00059))+([B]*2.03526)+(([B]*[B])*0.02534)+((([B])∧(3))*(-0.01884))+(([B])∧(4))*0.00121.\documentclass[12pt]{minimal} \usepackage{amsmath} \usepackage{wasysym} \usepackage{amsfonts} \usepackage{amssymb} \usepackage{amsbsy} \usepackage{mathrsfs} \usepackage{upgreek} \setlength{\oddsidemargin}{-69pt} \begin{document}$$\mathrm Z-\mathrm{Score}\;=\;(\lbrack\mathrm C\rbrack-\lbrack\mathrm{SYSSDS}1\rbrack)/10.4855$$\end{document}Z-Score=([C]-[SYSSDS1])/10.4855 With A: Redcap variable for the age of participants in months. B: Redcap variable containing the calculated Z-Score for Height. C: Systolic Blood Pressure reading of participant. 3.Diastolic Blood Pressure SDS value and Z-Score for Male participants (DIASBPM)\documentclass[12pt]{minimal} \usepackage{amsmath} \usepackage{wasysym} \usepackage{amsfonts} \usepackage{amssymb} \usepackage{amsbsy} \usepackage{mathrsfs} \usepackage{upgreek} \setlength{\oddsidemargin}{-69pt} \begin{document}$$\mathrm{DIASBPM}\:=\:61.01217+(((\lbrack A\rbrack/12)-\:10)\ast0.68314)+(((\lbrack A\rbrack/12)-\:10{)^\wedge(}2)\ast(-0.09835))+(((\lbrack A\rbrack/12)-\:10{)^\wedge(}3))\ast(0.01711)+(((\lbrack A\rbrack/12)-\:10{)^\wedge(}4)\ast(0.00045))+(\lbrack B\rbrack\ast1.46993)+((\lbrack B\rbrack\ast\lbrack B\rbrack)\ast(-0.07849))+(((\lbrack B\rbrack{)^\wedge(}3))\ast(-0.03144))+((\lbrack B\rbrack{)^\wedge(}4))\ast0.00967$$\end{document}DIASBPM=61.01217+((([A]/12)-10)*0.68314)+((([A]/12)-10)∧(2)*(-0.09835))+((([A]/12)-10)∧(3))*(0.01711)+((([A]/12)-10)∧(4)*(0.00045))+([B]*1.46993)+(([B]*[B])*(-0.07849))+((([B])∧(3))*(-0.03144))+(([B])∧(4))*0.00967\documentclass[12pt]{minimal} \usepackage{amsmath} \usepackage{wasysym} \usepackage{amsfonts} \usepackage{amssymb} \usepackage{amsbsy} \usepackage{mathrsfs} \usepackage{upgreek} \setlength{\oddsidemargin}{-69pt} \begin{document}$$\mathrm Z-\mathrm{Score}=\;(\lbrack\mathrm D\rbrack-\lbrack\mathrm{DIASBPM}\rbrack)/11.6032$$\end{document}Z-Score=([D]-[DIASBPM])/11.6032 3.Diastolic Blood Pressure SDS value and Z-Score for Male participants (DIASBPM)\documentclass[12pt]{minimal} \usepackage{amsmath} \usepackage{wasysym} \usepackage{amsfonts} \usepackage{amssymb} \usepackage{amsbsy} \usepackage{mathrsfs} \usepackage{upgreek} \setlength{\oddsidemargin}{-69pt} \begin{document}$$\mathrm{DIASBPM}\:=\:61.01217+(((\lbrack A\rbrack/12)-\:10)\ast0.68314)+(((\lbrack A\rbrack/12)-\:10{)^\wedge(}2)\ast(-0.09835))+(((\lbrack A\rbrack/12)-\:10{)^\wedge(}3))\ast(0.01711)+(((\lbrack A\rbrack/12)-\:10{)^\wedge(}4)\ast(0.00045))+(\lbrack B\rbrack\ast1.46993)+((\lbrack B\rbrack\ast\lbrack B\rbrack)\ast(-0.07849))+(((\lbrack B\rbrack{)^\wedge(}3))\ast(-0.03144))+((\lbrack B\rbrack{)^\wedge(}4))\ast0.00967$$\end{document}DIASBPM=61.01217+((([A]/12)-10)*0.68314)+((([A]/12)-10)∧(2)*(-0.09835))+((([A]/12)-10)∧(3))*(0.01711)+((([A]/12)-10)∧(4)*(0.00045))+([B]*1.46993)+(([B]*[B])*(-0.07849))+((([B])∧(3))*(-0.03144))+(([B])∧(4))*0.00967\documentclass[12pt]{minimal} \usepackage{amsmath} \usepackage{wasysym} \usepackage{amsfonts} \usepackage{amssymb} \usepackage{amsbsy} \usepackage{mathrsfs} \usepackage{upgreek} \setlength{\oddsidemargin}{-69pt} \begin{document}$$\mathrm Z-\mathrm{Score}=\;(\lbrack\mathrm D\rbrack-\lbrack\mathrm{DIASBPM}\rbrack)/11.6032$$\end{document}Z-Score=([D]-[DIASBPM])/11.6032 Diastolic Blood Pressure SDS value and Z-Score for Male participants (DIASBPM)\documentclass[12pt]{minimal} \usepackage{amsmath} \usepackage{wasysym} \usepackage{amsfonts} \usepackage{amssymb} \usepackage{amsbsy} \usepackage{mathrsfs} \usepackage{upgreek} \setlength{\oddsidemargin}{-69pt} \begin{document}$$\mathrm{DIASBPM}\:=\:61.01217+(((\lbrack A\rbrack/12)-\:10)\ast0.68314)+(((\lbrack A\rbrack/12)-\:10{)^\wedge(}2)\ast(-0.09835))+(((\lbrack A\rbrack/12)-\:10{)^\wedge(}3))\ast(0.01711)+(((\lbrack A\rbrack/12)-\:10{)^\wedge(}4)\ast(0.00045))+(\lbrack B\rbrack\ast1.46993)+((\lbrack B\rbrack\ast\lbrack B\rbrack)\ast(-0.07849))+(((\lbrack B\rbrack{)^\wedge(}3))\ast(-0.03144))+((\lbrack B\rbrack{)^\wedge(}4))\ast0.00967$$\end{document}DIASBPM=61.01217+((([A]/12)-10)*0.68314)+((([A]/12)-10)∧(2)*(-0.09835))+((([A]/12)-10)∧(3))*(0.01711)+((([A]/12)-10)∧(4)*(0.00045))+([B]*1.46993)+(([B]*[B])*(-0.07849))+((([B])∧(3))*(-0.03144))+(([B])∧(4))*0.00967\documentclass[12pt]{minimal} \usepackage{amsmath} \usepackage{wasysym} \usepackage{amsfonts} \usepackage{amssymb} \usepackage{amsbsy} \usepackage{mathrsfs} \usepackage{upgreek} \setlength{\oddsidemargin}{-69pt} \begin{document}$$\mathrm Z-\mathrm{Score}=\;(\lbrack\mathrm D\rbrack-\lbrack\mathrm{DIASBPM}\rbrack)/11.6032$$\end{document}Z-Score=([D]-[DIASBPM])/11.6032 With A: Redcap variable for the age of participants in months. B: Redcap variable containing the calculated Z-Score for Height. D: Diastolic Blood Pressure reading of participant. 4.Diastolic Blood Pressure SDS value and Z-Score for Female participants (SDSDIAF).\documentclass[12pt]{minimal} \usepackage{amsmath} \usepackage{wasysym} \usepackage{amsfonts} \usepackage{amssymb} \usepackage{amsbsy} \usepackage{mathrsfs} \usepackage{upgreek} \setlength{\oddsidemargin}{-69pt} \begin{document}$$\mathrm{SDSDIAF}\:=\:60.5051+(((\lbrack A\rbrack/12)-\:10)\ast1.01301)+(((\lbrack A\rbrack/12)-\:10{)^\wedge(}2)\ast(0.01157))+(((\lbrack A\rbrack/12)-\:10{)^\wedge(}3))\ast(0.00424)+(((\lbrack A\rbrack/12)-\:10{)^\wedge(}4)\ast(-0.00137))+(\lbrack B\rbrack\ast1.16641)+((\lbrack B\rbrack\ast\lbrack B\rbrack)\ast(0.12795))+(((\lbrack B\rbrack{)^\wedge(}3))\ast(-0.03869))+((\lbrack B\rbrack{)^\wedge(}4))\ast(-0.00079)$$\end{document}SDSDIAF=60.5051+((([A]/12)-10)*1.01301)+((([A]/12)-10)∧(2)*(0.01157))+((([A]/12)-10)∧(3))*(0.00424)+((([A]/12)-10)∧(4)*(-0.00137))+([B]*1.16641)+(([B]*[B])*(0.12795))+((([B])∧(3))*(-0.03869))+(([B])∧(4))*(-0.00079)\documentclass[12pt]{minimal} \usepackage{amsmath} \usepackage{wasysym} \usepackage{amsfonts} \usepackage{amssymb} \usepackage{amsbsy} \usepackage{mathrsfs} \usepackage{upgreek} \setlength{\oddsidemargin}{-69pt} \begin{document}$$\mathrm Z-\mathrm{Score}\;=\;(\lbrack\mathrm D\rbrack-\lbrack\mathrm{SDSDIAF}\rbrack)/10.9573$$\end{document}Z-Score=([D]-[SDSDIAF])/10.9573 4.Diastolic Blood Pressure SDS value and Z-Score for Female participants (SDSDIAF).\documentclass[12pt]{minimal} \usepackage{amsmath} \usepackage{wasysym} \usepackage{amsfonts} \usepackage{amssymb} \usepackage{amsbsy} \usepackage{mathrsfs} \usepackage{upgreek} \setlength{\oddsidemargin}{-69pt} \begin{document}$$\mathrm{SDSDIAF}\:=\:60.5051+(((\lbrack A\rbrack/12)-\:10)\ast1.01301)+(((\lbrack A\rbrack/12)-\:10{)^\wedge(}2)\ast(0.01157))+(((\lbrack A\rbrack/12)-\:10{)^\wedge(}3))\ast(0.00424)+(((\lbrack A\rbrack/12)-\:10{)^\wedge(}4)\ast(-0.00137))+(\lbrack B\rbrack\ast1.16641)+((\lbrack B\rbrack\ast\lbrack B\rbrack)\ast(0.12795))+(((\lbrack B\rbrack{)^\wedge(}3))\ast(-0.03869))+((\lbrack B\rbrack{)^\wedge(}4))\ast(-0.00079)$$\end{document}SDSDIAF=60.5051+((([A]/12)-10)*1.01301)+((([A]/12)-10)∧(2)*(0.01157))+((([A]/12)-10)∧(3))*(0.00424)+((([A]/12)-10)∧(4)*(-0.00137))+([B]*1.16641)+(([B]*[B])*(0.12795))+((([B])∧(3))*(-0.03869))+(([B])∧(4))*(-0.00079)\documentclass[12pt]{minimal} \usepackage{amsmath} \usepackage{wasysym} \usepackage{amsfonts} \usepackage{amssymb} \usepackage{amsbsy} \usepackage{mathrsfs} \usepackage{upgreek} \setlength{\oddsidemargin}{-69pt} \begin{document}$$\mathrm Z-\mathrm{Score}\;=\;(\lbrack\mathrm D\rbrack-\lbrack\mathrm{SDSDIAF}\rbrack)/10.9573$$\end{document}Z-Score=([D]-[SDSDIAF])/10.9573 Diastolic Blood Pressure SDS value and Z-Score for Female participants (SDSDIAF).\documentclass[12pt]{minimal} \usepackage{amsmath} \usepackage{wasysym} \usepackage{amsfonts} \usepackage{amssymb} \usepackage{amsbsy} \usepackage{mathrsfs} \usepackage{upgreek} \setlength{\oddsidemargin}{-69pt} \begin{document}$$\mathrm{SDSDIAF}\:=\:60.5051+(((\lbrack A\rbrack/12)-\:10)\ast1.01301)+(((\lbrack A\rbrack/12)-\:10{)^\wedge(}2)\ast(0.01157))+(((\lbrack A\rbrack/12)-\:10{)^\wedge(}3))\ast(0.00424)+(((\lbrack A\rbrack/12)-\:10{)^\wedge(}4)\ast(-0.00137))+(\lbrack B\rbrack\ast1.16641)+((\lbrack B\rbrack\ast\lbrack B\rbrack)\ast(0.12795))+(((\lbrack B\rbrack{)^\wedge(}3))\ast(-0.03869))+((\lbrack B\rbrack{)^\wedge(}4))\ast(-0.00079)$$\end{document}SDSDIAF=60.5051+((([A]/12)-10)*1.01301)+((([A]/12)-10)∧(2)*(0.01157))+((([A]/12)-10)∧(3))*(0.00424)+((([A]/12)-10)∧(4)*(-0.00137))+([B]*1.16641)+(([B]*[B])*(0.12795))+((([B])∧(3))*(-0.03869))+(([B])∧(4))*(-0.00079)\documentclass[12pt]{minimal} \usepackage{amsmath} \usepackage{wasysym} \usepackage{amsfonts} \usepackage{amssymb} \usepackage{amsbsy} \usepackage{mathrsfs} \usepackage{upgreek} \setlength{\oddsidemargin}{-69pt} \begin{document}$$\mathrm Z-\mathrm{Score}\;=\;(\lbrack\mathrm D\rbrack-\lbrack\mathrm{SDSDIAF}\rbrack)/10.9573$$\end{document}Z-Score=([D]-[SDSDIAF])/10.9573 With A: Redcap variable for the age of participants in months. B: Redcap variable containing the calculated Z-Score for Height. D: Systolic Blood Pressure reading of participant. Results To ensure the accuracy and reliability of this solution, the REDCap instrument Z-scores were validated with two comparator software tools, the “Knirps calculator” version 1.7 14.10.2021, copyright, Michael Witsch, Luxembourg and the Growth XP version 2.8.0.58 [25]. Synthetic participant data with specific values for each of the data entry fields was entered in both REDCap and the comparator software tools to ensure same results are obtained. To validate the blood pressure Z-scores of REDCap with the Knirps calculator, the REDCap Blood pressure Z-scores values were compared against the Knirps Blood Pressure percentile values using the Z-score to percentile table (Supplementary Table). An example demonstrating the value comparison and accuracy to the third decimal is provided in Table 2 (Additional example screenshots are available in Supplementary information). Table 2Parameters of a participant considered to calculate the Z-Scores of the anthropometric variables and blood pressure and corresponding results generated by the three applicationsParametersParticipant age in months138SexFemaleWeight (kg)28.4Height (cm)141Systolic Blood Pressure (mmHg)105Diastolic Blood Pressure (mmHg)65Height Z-Score REDCap-1.063Height Z-Score Knirps Calculator-1.064Height Z-Score Growth XP-1.06BMI Z-Score REDCap-1.88BMI Z-Score Knirps Calculator-1.88BMI Z-Score Growth XP system-1.88Systolic Blood Pressure REDCap0.183Systolic Blood Pressure Knirps Calculator0.183Diastolic Blood Pressure REDCap0.353Diastolic Blood Pressure Knirps Calculator0.353 Table 2Parameters of a participant considered to calculate the Z-Scores of the anthropometric variables and blood pressure and corresponding results generated by the three applicationsParametersParticipant age in months138SexFemaleWeight (kg)28.4Height (cm)141Systolic Blood Pressure (mmHg)105Diastolic Blood Pressure (mmHg)65Height Z-Score REDCap-1.063Height Z-Score Knirps Calculator-1.064Height Z-Score Growth XP-1.06BMI Z-Score REDCap-1.88BMI Z-Score Knirps Calculator-1.88BMI Z-Score Growth XP system-1.88Systolic Blood Pressure REDCap0.183Systolic Blood Pressure Knirps Calculator0.183Diastolic Blood Pressure REDCap0.353Diastolic Blood Pressure Knirps Calculator0.353 Parameters of a participant considered to calculate the Z-Scores of the anthropometric variables and blood pressure and corresponding results generated by the three applications As demonstrated in the screen captures of the Knirps Calculator, Fig. 4, REDCap, Fig. 5 and Growth XP, Fig. 6, the Z-scores of height, BMI, systolic and diastolic blood pressure match to the second decimal for height and BMI in all calculator systems and to the third decimal for systolic and diastolic blood pressure between REDCap and the Knirps calculator. The Growth XP system does not calculate blood pressure Z-scores. The scores are summarized in Table 2. Scores from these three calculators were validated using the Bland-Altman Plots.Fig. 4Screen capture of the KNIRPS calculator. The Z-scores are highlighted inside the green boxesFig. 5Screen capture of REDCap database. The Z-scores are highlighted inside the green boxesFig. 6Screen capture of GrowthXp for the calculated Z-scores [25] Screen capture of the KNIRPS calculator. The Z-scores are highlighted inside the green boxes Screen capture of REDCap database. The Z-scores are highlighted inside the green boxes Screen capture of GrowthXp for the calculated Z-scores [25] Bland-Altman plots for demonstrating the agreement in methods of REDCap, Knirps and GrowthXP Bland-Altman plots, also known as Tukey Mean-Difference plots, are used to compare measurement calculations performed using two distinct tools: our custom calculations in REDCap and the Knirps calculator. These plots allow us to visually assess the agreement between the two measurement methods by examining the distribution of the differences between them. They provide a clear overview of how closely the REDCap calculations align with those produced by the Knirps calculator [26]. As can be deciphered from Fig. 7, Bland-Altman plots demonstrate strong agreement between the proposed REDCap solution, the Knirps calculator, and the Growth XP system. Furthermore, the majority of data points for all plots fall within the limits of agreement, indicating consistent agreement across the range of measurements.Fig. 7Bland Altman plots for demonstrating strong agreement between REDCap solution, Knirps calculator and the Growth XP system [26] Bland Altman plots for demonstrating strong agreement between REDCap solution, Knirps calculator and the Growth XP system [26] This consistency supports the reliability of our REDCap-based real-time child growth Z-score assessments. Our approach is a dependable and efficient tool for evidence-based pediatric care and research, contributing to advancements in child health assessment. Discussion Our open-source code solution seamlessly integrates Z-score calculations into the REDCap platform, facilitating real-time assessments and offering customization options. As mentioned before, current tools and software offering Z-score and Percentile Calculations based on WHO 2007 growth charts, including Epi Info 7 offering data entry forms for these calculations. However, there is a scarcity of other freely available options with real-time calculations specifically tailored to child growth and blood pressure monitoring. To address this identified need gap, this proposed open-code solution emerges as a specialized approach within the REDCap platform. By incorporating Z-score calculations directly within REDCap, this solution streamlines the entire data collection and analysis process for child growth monitoring and hypertension studies, allowing researchers to perform all tasks within a unified platform. This eliminates the need for external software or data exports and empowers timely interventions for children at risk. The open-code approach fosters collaboration, creating a community of users committed to continuous improvement. This collaborative potential ensures the tool’s sustainability, maintaining its relevance in the dynamic field of child health research. However, our newly developed product has limitations. The “Calculated Field” module, intended for simple calculations and conditional logic, restricts us to basic mathematical operations. Despite the notification of calculation validity in the Logic Editor text box, instances of a blank calculated data entry field have occurred due to inaccuracies in the formula. To facilitate a better user experience for entering logic, the logic editor is displayed in a modal dialogue box. The logic editor also prompts the user with a “valid” notification at the bottom left of the dialogue box to gauge the correctness of the entered logic as seen in Fig. 8.Fig. 8Screen capture of REDCap logic editor module highlighting the validity of the entered logic Screen capture of REDCap logic editor module highlighting the validity of the entered logic Calculated fields rely on values from other fields, and modifying these source values may prompt the recalculation of dependent fields, potentially causing unforeseen results, if not managed carefully. However, there is a corrective feature in the Data Quality module called as “Rule H: Incorrect values for calculated fields”, which re-runs the calculations and “fixes” these errors. However, after this fix, the data entry forms that have been impacted must be re-saved for the updated calculation to reflect in the data field audit trail [12]. Complex calculations within the “Calculated Field” module could potentially influence the performance of data entry forms, leading to slower page loading times, especially when dealing with large datasets or intricate logic. Debugging errors in calculated fields, especially complex or nested calculations, could be challenging perhaps because of the lack of comprehensive debugging tools. Differences in REDCap versions across projects or institutions, may lead to compatibility issues for calculated fields, particularly if users with different versions access the same project. Despite these limitations, we used our open-source code solution within REDCap successfully during the EARLIE study without major issues in the calculations. Statistical analyses are currently ongoing to produce the final results. Conclusion In conclusion, this paper introduces an open-code solution integrated within the REDCap platform for real-time Z-score calculations, which is valuable for pediatric somatic growth monitoring and hypertension studies using the WHO and NHANES reference standards. The methodology addresses the existing need gap associated with manual and non-integrated methods of Z-score calculations. With this approach, data collection would be streamlined and efficient. Lastly, the solution demonstrates broad applicability in pediatric research settings. The article is summarized in Fig. 9. Fig. 9Summary of the research article Summary of the research article Supplementary Information Supplementary Material 1: Z-Score to Percentile Conversion Table.Supplementary Material 2. Other example screenshots of Z-score comparison between the 3 software.Supplementary Material 3. Guide to upload the REDCap open code to new projects.Supplementary Material 4. REDCap Open Code Data Instrument Zip File. Supplementary Material 1: Z-Score to Percentile Conversion Table. Supplementary Material 2. Other example screenshots of Z-score comparison between the 3 software. Supplementary Material 3. Guide to upload the REDCap open code to new projects. Supplementary Material 4. REDCap Open Code Data Instrument Zip File.