PNSS Edit Criteria

Unusual Data Distribution

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

Edit Criteria: Files containing no acceptable data other than zeroes in fields where zero is a valid value.

Field
Numbers
Field Names
16 Monthly Household Income—Prenatal Visit
36 Total Weight Gain
43 Parity
47 Medical Care Began
49 Multivitamin Consumption Prior to Pregnancy
51 Cigarettes/Day— Months Prior to Pregnancy
52 Cigarettes/Day—Prenatal Visit
53 Cigarettes/Day—Last 3 Months of Pregnancy
54 Cigarettes/Day—Postpartum Visit
57 Drinks/Week—3 Months Prior to Pregnancy
58 Drinks/Week—Last 3 Months of Pregnancy

Other Unusual Data Distribution

Edit Criteria: Data distribution of field codes or field code records. Volume is significantly different than the national PNSS data distribution.
Field
Numbers
Field Names Criteria
06 Completion Code Values for codes 1, A, B < 50%;  values for codes 2-6 < 5%; values for codes 7-8 < 5%.
07 Initial Visit Date 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 values for total records/30 + 20%).
08 Postpartum Visit Date 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 values for total records/30 + 20%).
10 Woman's Date of Birth > 20% of values < (current year - 36 years) or   > 20% of values > (current year - 17 years).  On annual data sets, values should be evenly distributed (quantity of values for Month should be total records/12 + 20%; quantity of values for Day should be values for total records/30 + 20%).
14 Education 20% of values < 7 or 20% of values > 15.  Values for code 12 not greater than values for any other single code.  Values for code 0 > 1%.
15 Household Size—Prenatal Visit > 20% of values > 6.  National distribution: 5% of values fall outside this cutoff.
16 Monthly Household Income—Prenatal Visit > 20% of values > 2100.  National distribution: 5% of values fall outside this cutoff.  Sum of records with values 0000-0900 > 80% of all records with values 0000-8000.
17 Migrant Status Values for code 2 not greater than values for code 1.
26 Date of Last Menstrual Period (LMP) 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 values for total records/30 + 20%).
27 Expected Date of Delivery (EDD) 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 values for total records/30 + 20%).
28 Height of Woman—English > 20% of values < 60 (inches) or > 20% of values > 69 (inches).  National distribution: 5% of values are outside each of these cutoffs.
29 Height of Woman—Metric > 20% of values < 151.0 (centimeters) or > 20% of values > 174.0 (centimeters).  National distribution: 5% of values are outside each of these cutoffs.
30 Pre-Pregnancy Weight Estimate > 20% of values < 100 (pounds) or > 20% of values > 227 (pounds).  National distribution: 5% of values are outside each of these cutoffs.
31 Woman's Weight English—Prenatal Visit > 20% of values < 108 (pounds) or > 20% of values > 238 (pounds).  National distribution: 5% of values are outside each of these cutoffs.
32 Woman's Weight Metric—Prenatal Visit > 20% of values < 49.0 (kilograms) or > 20% of values > 108.0 (kilograms).  National distribution: 5% of values are outside each of these cutoffs.
33 Woman's Weight English—Postpartum Visit > 20% of values < 110 (pounds) or > 20% of values > 238 (pounds).  National distribution: 5% of values are outside each of these cutoffs.
34 Woman's Weight Metric—Postpartum Visit > 20% of values < 51.0 (kilograms) or > 20% of values > 108.0 (kilograms).  National distribution: 5% of values are outside each of these cutoffs.
35 Positive or Negative (Pos or Neg) Weight Gain Value for neg code (-) is < 0.5% or > 4%.
36 Total Weight Gain > 20% of values < 4 (pounds) or > 20% of values > 57 (pounds).  National distribution: 5% of values are outside each of these cutoffs.
37 Hemoglobin—Prenatal Visit > 30% of values fall on the half or whole integer (e.g., 11.0, 11.5).  Expected prevalence:  20%.  > 20% of values < 10.1 (g/dL) or > 20% of values > 14.5 (g/dL).  National distribution: 5% of values are outside each of these cutoffs.
38 Hematocrit—Prenatal Visit > 20% of values < 30.6 (%) or > 20% of values > 41.9 (%).  National distribution: 5% of values are outside each of these cutoffs.
39 Date of Hemoglobin or Hematocrit Measure—Prenatal Visit 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 values for total records/30 + 20%).
40 Hemoglobin—Postpartum Visit > 30% of values fall on the half or whole integer (e.g., 11.0, 11.5).   Expected prevalence:  20%.  > 20% of values < 9.6 (g/dL) or > 20% of values > 14.9 (g/dL).  National distribution: 5% of values are outside each of these cutoffs.
41 Hematocrit—Postpartum Visit > 20% of values < 28.2 (%) or > 20% of values > 43.1 (%).  National distribution: 5% of values are outside each of these cutoffs.
42 Date of Hemoglobin or Hematocrit Measure—Postpartum Visit 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 values for total records/30 + 20%).
43 Parity 20% of values > 4.  Values for code 0 < 19% or > 50%.  Values for code 1 not greater than values for code 2 not greater than values for code 3.
47 Medical Care Began > 20% of values > 6.  National distribution: 5% of values fall outside this cutoff.
48 Date Enrolled in WIC 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 values for total records/30 + 20%).
51 Cigarettes/Day—3 Months Prior to Pregnancy Values for code 00 < 50%.  Sum of records with codes 10, 20, 30, 40 not > 50% of the sum of records with codes 10-97.
52 Cigarettes/Day—Prenatal Visit Values for code 00 < 50%.  Sum of records with codes 10, 20, 30, 40 not > 50% of the sum of records with codes 10-97.
53 Cigarettes/Day—Last 3 Months of Pregnancy Values for code 00 < 50%.  Sum of records with codes 10, 20, 30, 40 not > 50% of the sum of records with codes 10-97.
54 Cigarettes/Day—Postpartum Visit Values for code 00 < 50%.  Sum of records with codes 10, 20, 30, 40 not > 50% of the sum of records with codes 10-97.
55/56 Household Smoking—Prenatal and Postpartum Visit Values for code 2 > 90%.
57 Drinks/Week—3 Months Prior to Pregnancy Values for code 00 < 60%.
58 Drinks/Week—Last 3 Months of Pregnancy Values for code 00 < 90%.
60 Infant's Date of Birth > 10% of records have gestational age at birth exactly 280 days.  This indicates that the Date of LMP or EDD are likely computer from the Infant's Date of Birth, rather than obtained independently (based on the national distribution, the percent should not exceed 4%).
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 values for total records/30 + 20%).
61 Number of Infants Sum of values for codes 2-8 < 1% or > 4%.  Values for code 1 not greater than values for any other code.
62 Born Alive or Dead Value for code 2 > 5%.
63 Birthweight—English > 20% of values < 05 (pounds),  00 (ounces) or > 20% of values > 09 (pounds),  03 (ounces).   National distribution: 5% of values fall outside this cutoff.
64 Birthweight—Metric > 20% of values < 2270 (grams)  or > 20% of values > 4178 (grams).   National distribution: 5% of values fall outside this cutoff.
65 Currently Breastfed Value for code 1 < 20% or > 90% (excluding 8s).