PedNSS Edit Criteria

Unusual Data Distribution

Files With Fields Containing No Acceptable Data Other Than Zero (When Zero is a Valid Value)

Edit Criteria: Fields containing no data in acceptable ranges other than zeroes. The field numbers, names and edit criteria include:
Field
Numbers		 Field Names
15 Monthly Household Income
33 Length of Time Breastfed
35 Introduction to Supplementary Feeding
36 TV Viewing

 

Unusual Data Distribution (cont'd)

Other Unusual Data Distribution

Edit Criteria: Data distribution of field codes or field code record volume is significantly different than the national PedNSS data distribution.
Field
Numbers		 Field Names Criteria
07 Date of Visit On Annual PedNSS Record Volume and Data Quality report, month and day values should be evenly distributed (quantity of values for Month should be total months/12 + 20%;  quantity of values for Day should be values for total days/30 + 20%.
09 Date of Birth On Annual PedNSS Record Volume and Data Quality report, month and day values should be evenly distributed (quantity of values for Month should be total months/12 + 20%;  quantity of values for Day should be values for total days/30 + 20%.
10 Sex  Values for code 1 (male) < 48% or > 56%.
14 Household Size > 20% of values > 6.  National distribution: 5% of values fall outside this cutoff.
15 Monthly Household Income > 20% of values > 2100.   National distribution:  5% of values fall above this cutoff.  Sum of records with values 0000-0900 > 80% of all records with values 0000-8000. 
16 Migrant Status Values for code 2 not greater than values for code 1.
21 Birthweight—English > 20% of values <04 (pounds), 14 (ounces) or > 20% of values > 09 (pounds),  02 (ounces).  National distribution:  5% of values are outside of each of these cutoffs.  1,2
22 Birthweight—Metric > 20% of values <2216 (grams)  or > 20% of values >4147 (grams).
National distribution:  5% of values are outside each of these cutoffs.  1,2
27 Date of Height/Weight Measure On annual data sets, Month and Day values should be evenly distributed (quantity of values for Month should be total records/12 + 20%;  quantity of values for Day should be total records/30 + 20%)
28 Hemoglobin     > 20% of values are <10.3 (g/dL) or >20% of values >14.0 (g/dL).   National distribution: 5% of values are outside each of these cutoffs. Digital preference: >30% of Hb values fall on the whole or half integer  (e.g. 11.0, 11.5,  12.0, 12.5)  (expected prevalence:  20%). 2,3
29 Hematocrit      > 20% of values are <31.7 (%) or >20 % of values > 41.3 (%).
National distribution:  5% of values are outside each of these cutoffs. 2,3
30 Date of Hemoglobin/Hematocrit Measure On annual data sets, Month and Day values should be evenly distributed (quantity of values for Month should be total records/12 + 20%;  quantity of values for Day should be total records/30 + 20%)3
31
32		 Currently Breastfed
Ever Breastfed		 Currently Breastfed and Ever Breastfed codes are combined.
< 10% or > 95% of combined field values = 19 (yes, unknown or not applicable) or 21 (no, yes).4
09
31
34		 Date of Birth                      Currently Breastfed
Date of Most Recent Breastfeeding Response		 Percent Decline in Currently Breastfed.
Ratio of percent currently breastfed in the second 6 months of infancy to the percent currently breastfed in the first 6 months of infancy >0.6 (a ratio of 0.5, i.e. 50%, or smaller is considered plausible).
Records for children aged < 12 months included in analysis. 
09
31
32
34		 Date of Birth
Currently Breastfed
Ever Breastfed
Date of Most Recent Breastfeeding Response		 Percent Ever Breastfed Consistent Across Age Ranges.
Ratio of the percent ever breastfed in the second six months of infancy to the percent ever breastfed in the first 6 months <0.9 or > 1.1 (a ratio of 1.0 is expected).
Records for children ages < 12 months included in analysis.
33 Length of Time Breastfed Values for code 01 not greater than values for code 02 not greater than values for code 03.
Sum of records with codes 08, 12, 16, 20, 24, 28, 32, 36, 40, 44, and 48 exceeds sum of other codes from 04-52. 4
09
33
34		 Date of Birth
Length of Time Breastfed
Date of Most Recent Breastfeeding Response		 Breastfeeding Duration Exceeds Current Age of Child.
Length of Time Breastfed exceeds child's current age (Date of Birth vs. Date of Most Recent Breastfeeding Response in weeks) on >2% of records (no child should have a breastfeeding duration exceeding his age). 4
09
33
34		 Date of Birth
Length of Time Breastfed
Date of Most Recent Breastfeeding Response		 Breastfeeding Duration Equals Current Age of Child.
Length of Time Breastfed (in weeks) = child's current age (Date of Birth vs. Date of Most Recent Breastfeeding Response in weeks) on > 5% of records (<4% of children are weaned at exactly their current age, this week).  Records for children aged 6 - 24 months included in analysis. 4
37 Household Smoking Values for code 2 (no) > 90%
1Unusual data distribution for this field is calculated only on records for children <12 months of age.
2Unusual data distribution edits for this field is different from PNSS unusual data distribution edits for this same field; each were derived from data distributions unique to each system.
3Unusual data distribution for this field is calculated only on records for children >6 months of age.
4Unusual data distribution for this field is calculated only on records for children < 24 months of age.