Standards for Excluding Data from Annual PedNSS Reports and Flagging Questionable Data

Annual PedNSS Report Data Tables Affected by Standards Annual PedNSS Report Demographic and Health Indicators PedNSS Fields Included in Indicator Analysis  (Cr=Critical field, C=core field, S=supplemental field)   Standards for Excluding Data   Standards for Flagging Questionable Data
Vital Data Items Not Reported* >5% BIVs** > 40% Cumulative Missing, Miscoded or BIV Data Out-of-Range Annual Report Prevalence Rates Questionable Data Large Shifts in Trends
1, 5, 8, 9,11, 16, 20,21 Age Date of Birth [Cr] Critical N/A (not applicable) Critical error if missing or miscoded N/A Flag rate ≤ 2% in any one or more age categories (per Table 1) Flag shift of ≥ 5% in any one or more age categories (per Table 11)
Date of Visit [Cr] Critical N/A Critical error if missing or miscoded N/A
1, 4,  8-10, 16-19 Race/Ethnicity Race/Ethnicity  [C] N/A N/A Exclude if >40% missing or miscoded data N/A N/A Flag shift of ≥ 5% in one or more racial and ethnic categories (per Table 10)
WIC Race/Ethnicity [C]
1, 4, 8-10, 16-19 Contributor-Specific Race/Ethnicity Contributor-Specific Race/Ethnicity [S] N/A N/A Exclude if >40% missing or miscoded data  None N/A Flag shift of ≥ 5% in any one or more racial and ethnic categories (per Table 10)
1 Poverty Level Household Size [C] N/A N/A Exclude if >40% missing or miscoded data for either field  N/A N/A Flag shift of ≥ 5% for one or more poverty levels (per Table 1 in current and prior year reports)
Monthly Household Income [C]
1 Migrant Status Migrant Status [S] N/A N/A Exclude if >40% missing or miscoded data N/A Flag rate=100% (per Table 1) Flag shift of ≥ 5% (per Table 1 in current and prior annual PedNSS reports)
1 Program Participation WIC  [S] N/A N/A Exclude if >40% missing or miscoded data N/A N/A Flag shift of ≥ 5% for one or more program participation categories (per Table 1 in current and prior year reports)
SNAP [S] N/A Exclude if >40% missing or miscoded data Exclude rate=0% or 100% (per Table 1)
Medicaid [S] N/A Exclude if >40% missing or miscoded data Exclude rate=0% or 100% (per Table 1)
TANF [S] N/A Exclude if >40% missing or miscoded data Exclude rate=0% or 100% (per Table 1)
2, 6, 8, 12, 18 Low Birthweight Birthweight--English [C] N/A Exclude if ≥ 5% BIVs (per Table 22) Exclude if > 40% missing, miscoded or BIV data (per Table 22) N/A Flag ≥ 2% and < 5% BIVs (per Table 22) Flag shift of ≥ 1% (per Table 12), except for contributors with <10,000 records, flag shift of ≥ 2%.
Birthweight--Metric [C]
2, 6, 8, 12, 18 High Birthweight Birthweight--English [C] N/A Exclude if ≥ 5% BIVs (per Table 22) Exclude if > 40% missing, miscoded or BIV data (per Table 22) N/A Flag ≥ 2% and < 5% BIVs (per Table 22) Flag shift of ≥ 1% (per Table 12), except for contributors with <10,000 records, flag shift of ≥ 2%.
Birthweight--Metric [C]
2, 6, 8, 12, 16, 18, 20 Short Stature Height---English [C] Per theme Exclude if ≥ 5% BIVs on Height (per Table 22) Exclude if > 40% missing, miscoded or BIV data on Height (per Table 22) N/A Flag ≥ 2% and < 5% BIVs (per Table 22) Flag shift of ≥ 1% , except for contributors with <10,000 records, flag shift of ≥ 2%
Height---Metric [C] Per theme
Date of Birth [Cr] Critical
Date of Height/Weight Measure [C] N/A
Sex [Cr] Sex
2, 6, 8, 12, 16, 18, 20 Underweight Weight---English [C] Per theme Exclude if ≥ 5% BIVs on Height, Weight, or Weight-for-Length/BMI-for-Age (per Table 22) Exclude if > 40% missing, miscoded or BIV data on Height, Weight or Weight-for-Length/BMI-for-age (per Table 22) N/A Flag ≥ 2% and <5% BIVs on Height, Weight, or Weight-for-Length/BMI-for-Age (per Table 22) Flag shift of ≥ 1% (per Table 12), except for contributors with <10,000 records, flag shift of ≥ 2%
Weight---Metric [C] Per theme
Height---English [C] Per theme
Height---Metric [C] Per theme
Date of Birth [Cr] Critical
Date of Height/Weight Measure [C] N/A
Sex [Cr] Per theme N/A
2, 6, 8, 12, 16, 18, 20 Overweight Weight---English [C] Per theme Exclude if ≥ 5% BIVs on Height, Weight, or Weight-for-Length/BMI-for-Age (per Table 22) Exclude if > 40% missing, miscoded or BIV data on Height, Weight, or Weight-for-Length/BMI-for-Age (per Table 22) N/A Flag ≥ 2% and <5% BIVs on Height, Weight, or Weight-for-Length/BMI-for-Age (per Table 22) Flag shift of ≥ 1% (per Table 12), except for contributors with <10,000 records, flag shift of ≥ 2%
Weight---Metric [C] Per theme
Height---English [C] Per theme
Height---Metric [C] Per theme
Date of Birth [Cr] *
Date of Height/Weight Measure [C] N/A
Sex [Cr] Per theme N/A
2, 6, 8, 12, 16, 18, 20 Obese Weight---English [C] Per theme Exclude if ≥ 5% BIVs on Height, Weight, or Weight-for-Length/BMI-for-Age (per Table 22) Exclude if > 40% missing, miscoded or BIV data on Height, Weight, or Weight-for-Length/BMI-for-Age (per Table 22) N/A Flag ≥ 2% and <5% BIVs on Height, Weight, or Weight-for-Length/BMI-for-Age (per Table 22) Flag shift of ≥ 1% (per Table 12), except for contributors with <10,000 records, flag shift of ≥ 2%
Weight---Metric [C] Per theme
Height---English [C] Per theme
Height---Metric [C] Per theme
Date of Birth [Cr] Critical
Date of Height/Weight Measure [C] N/A
Sex [Cr] Per theme N/A
2 Low Hemoglobin Hemoglobin [C] Per theme N/A (Hemoglobin/
Hematocrit data are assessed jointly)
N/A (Hemoglobin/ Hematocrit data are assessed jointly) Exclude rate ≤ 3.0% (per Table 2) Flag rate ≥ 35.0% (per Table 2). Flag ≥ 2% and <5% BIVs (per Table 22) Flag shift of ≥ 3% (per Table 2 in prior and current year reports)
Sex [Cr] Per theme
Date of Birth [Cr] Per theme
Date of Hemoglobin/ Hematocrit Measure [C] N/A
2 Low Hematocrit Hematocrit [C] Per theme N/A (Hemoglobin/
Hematocrit data are assessed jointly)
N/A (Hemoglobin/
Hematocrit data are assessed jointly)
Exclude rate ≤ 3.0% (per Table 2) Flag rate ≥ 35.0% (per Table 2). Flag ≥ 2% and <5% BIVs (per Table 22) Flag shift of ≥ 3% (per Table 2 in current and prior year reports)
Sex [Cr] Per theme
Date of Birth [Cr] Critical
Date of Hemoglobin/  Hematocrit Measure [C] N/A
2, 6, 8, 12, 17, 18, 21 Low Hemoglobin/ Hematocrit Hemoglobin [C] Per theme Exclude if ≥ 5% BIV data on Hemoglobin/ Hematocrit (per Table 22) Exclude if > 40% missing, miscoded or BIV data on Hemoglobin/ Hematocrit (per Table 22) Exclude rate ≤ 3.0% (per Table 2) Flag rate ≥ 35.0% (per Table 2). Flag ≥ 2% and <5% BIVs on Hemoglobin/Hematocrit (per Table 22) Flag shift of ≥ 3% (per Table 12)
Hematocrit [C] Per theme
Sex [Cr] Per theme
Date of Birth [Cr] Critical
Date of Hemoglobin/ Hematocrit Measure [C] N/A
2, 3, 7, 9, 13, 19 Ever Breastfed Currently Breastfed [C] Per theme Per theme N/A Exclude if >40% missing or miscoded Ever BF data (Table 22) Exclude rate ≤ 25% or ≥ 97% (per Table 3) N/A Flag shift of ≥ 4% (per Table 13)
Ever Breastfed [C]
2, 3, 7, 9, 13, 19 Breastfed at Least 1+ Week Through 18+ Months Currently Breastfed [C]  Per theme N/A Exclude if >40% missing or miscoded Breastfed at Least 6 and 12 Months data (per Table 22)  Exclude BF 1+ weeks to 6+ months if BF 6+ month rate ≤ 4% or ≥ 90% (per Table 3). Exclude 9+, 12+ and 18+ months rates if BF 12+ month rate is ≤ 2% or ≥ 90% (per Table 3) N/A Flag shift of ≥ 4% (per Table 3)
Ever Breastfed [C] Per theme
Length of Time Breastfed  [C] Per theme
Date of Birth [C] Critical
Date of Most Recent Breastfeeding Response [C] N/A
3, 7, 9 Exclusively Breastfed 3+ months and 6+ months Introduction to Supplementary Feeding  [S] N/A N/A Exclude if >40% missing or miscoded Exclusively BF at Least 3 Months data (per Table 22) Exclude 3 month rate ≤ 1% or ≥ 90% (per Table 3) . Exclude 6 month rate ≤ 0.1% or ≥ 90% (per Table 3) N/A 3 and 6 months rates- flag shift of ≥ 4% (per Table 3 in current and prior year reports)
Currenlty Breastfed [C] N/A
Ever Breastfed [C] N/A
Date of Birth  [Cr] N/A
Date of Most Recent Breastfeeding Response [C] N/A
2, 7, 9 TV Viewing TV Viewing [C] N/A N/A Exclude if >40% missing or miscoded data (per Table 22) Exclude rate ≤ 10% or ≥ 97% (per Table 2) N/A Flag shift of > 4% (per Table 2 in current and prior year reports)
2, 7, 9 Smoking in the Household Household Smoking [C] N/A N/A Exclude if >40% missing or miscoded data (per Table 22) Exclude rate ≤ 1% or ≥ 70% (per Table 2) N/A Flag shift of > 4% (per Table 2 in current and prior year reports)
* Vital PedNSS data items must be reported before an annual PedNSS report is produced by CDC. Vital data items include: State, Substate, Date of Visit, Date of Birth, Child's Alphanumeric Identifer, Sex, and at least one of the following three themes of data items: 1) anthropometry theme- height, weight, date of height/weight measure, 2) hematology theme - hemoglobin or hematocrit, date of hemoglobin/hematocrit measure, or 3) breastfeeding theme - currently breastfed, ever breastfed, length of time breastfed, date of most recent breastfeeding response.

** BIVs or biologically implausible values, are values falling outside the range considered biologically plausible (generally +/- 4 standard deviations)