PNSS Edit Criteria

Mis-codes

Clinic Code Numbers Not on CDC's List of Clinic Code Numbers

Edit Criteria: CDC compares the clinic code numbers on the contributor's transaction (data) file to the clinic code numbers listed on CDC's copy of the contributor's PNSS/PedNSS code file. Transaction file clinic code numbers not on CDC's list of clinic code number on >10 records are identified. The field number and name that is edited includes:

Field
Numbers
Field Names
03 Clinic

 

Mis-codes (cont'd)

Fields Containing Zero as a Value When Zero is Never Valid

Edit Criteria: Values of zero on more than 2% of records.
The field numbers and names that do not include zero as a valid value include:

Field
Numbers
Field Names
04 Zip Code
05 Source of Data
08 Postpartum Visit Date
10 Woman's Date of Birth
11 Race/Ethnicity
12 WIC Race/Ethnicity
14 Education
15 Household Size—Prenatal Visit
17 Migrant Status
18 WIC—Prenatal Visit
19 WIC—Postpartum Visit
20 Food Stamps—Prenatal Visit
21 Food Stamps—Postpartum Visit
22 Medicaid—Prenatal Visit
23 Medicaid—Postpartum Visit
24 TANF—Prenatal Visit
25 TANF—Postpartum Visit
26 Date of Last Menstrual Period (LMP)   
27 Expected Date of Delivery (EDD)
28 Height of Woman—English 
29 Height of Woman—Metric 
30 Pre-Pregnancy Weight Estimate
31 Woman's Weight English—Prenatal Visit 
32 Woman's Weight Metric—Prenatal Visit 
33 Woman's Weight English—Postpartum Visit 
34 Woman's Weight Metric—Postpartum Visit 
35 Positive or Negative (Pos or Neg) Weight Gain
37 Hemoglobin—Prenatal Visit 
38 Hematocrit—Prenatal Visit 
39 Date of Hemoglobin or Hematocrit Measure—Prenatal Visit
40 Hemoglobin—Postpartum Visit 
41 Hematocrit—Postpartum Visit 
42 Date of Hemoglobin/Hematocrit Measure—Postpartum Visit
45 Gestational Diabetes—Postpartum Visit
46 Hypertension During Pregnancy—Postpartum Visit
48 Date Enrolled in WIC
50 Multivitamin Consumption During Pregnancy
55 Household Smoking—Prenatal Visit
56 Household Smoking—Postpartum Visit
60 Infant's Date of Birth
61 Number of Infants
62 Born Alive or Dead
63 Birthweight—English 
64 Birthweight—Metric 
65 Currently Breastfed
66 Ever Breastfed

 

Mis-codes (cont'd)

Fields With Other Unacceptable Values

Edit Criteria: Fields with unacceptable codes or values on more than 5% of records.
The field numbers, names, and edit criteria include:
Field
Numbers
Field Names Criteria
04 Zip Code Values other than 5 digit Post Office zip code
05 Source of Data Values other than 1-4, Blank or 9 = unknown
08 Postpartum Visit Date Non-numeric, excluding blanks. After excluding all blanks or all 9s, Year is 3 years < computer date or Year is > computer date. Month is blank, 99 or < 01 or > 12; Day is blank, 99 or < 01 or > maximum days for month; Year is blank, 9999 or 0000
10 Woman's Date of Birth Non-numeric, excluding blanks. After excluding all blanks or all 9s, Year is > 55 years less than computer date or Year is < 10 years under computer date. Month is blank, 99 or < 01 or > 12; Day is blank, 99 or < 01 or > maximum days for month; Year is blank, 9999 or 0000
11 Race/Ethnicity Values other than 1(yes) or 2 (no)  in each of the six positions, Blanks or 999999 = unknown  
12 WIC Race/Ethnicity Values other than 3 position codes defined by the USDA for the WIC Program, Blanks or 999=unknown
14 Education Values other than 01-18, Blanks or 99 = unknown 
15 Household Size—Prenatal Visit Values other than 01-30, Blanks or 99 = unknown
16 Monthly Household Income—Prenatal Visit Values other than 0000-8000, 8888, Blanks or 9999 = unknown
17 Migrant Status Values other than 1 (migrant) or 2 (non-migrant),  Blank or 9 = unknown  
18 WIC—Prenatal Visit Values other than 1 (Yes) or 2 (No),  Blank or 9 = unknown  
19 WIC—Postpartum Visit Values other than 1 (Yes) or 2 (No),  Blank or 9 = unknown  
20 Food Stamps—Prenatal Visit Values other than 1 (Yes) or 2 (No),  Blank or 9 = unknown  
21 Food Stamps—Postpartum Visit Values other than 1 (Yes) or 2 (No),  Blank or 9 = unknown  
22 Medicaid—Prenatal Visit Values other than 1 (Yes) or 2 (No),  Blank or 9 = unknown  
23 Medicaid—Postpartum Visit Values other than 1 (Yes) or 2 (No),  Blank or 9 = unknown  
24 TANF—Prenatal Visit Values other than 1 (Yes) or 2 (No),  Blank or 9 = unknown  
25 TANF—Postpartum Visit Values other than 1 (Yes) or 2 (No),  Blank or 9 = unknown  
26 Date of Last Menstrual Period (LMP) Non-numeric, excluding blanks. After excluding all blanks or all 9s, Year is 3 years < computer date or Year is > computer date. Month is blank, 99 or < 01 or > 12; Day is blank, 99 or < 01 or > maximum days for month; Year is blank, 9999 or 0000
27 Expected Date of Delivery (EDD) Non-numeric, excluding blanks. After excluding all blanks or all 9s, Year is 3 years < computer date or Year is > computer date. Month is blank, 99 or < 01 or > 12; Day is blank, 99 or < 01 or > maximum days for month; Year is blank, 9999 or 0000
28 Height of Woman—English 990 - 998 or non-numeric, excluding blanks.  Last digit (fraction) other than 0-7
29 Height of Woman—Metric  Non-numeric, excluding blanks
30 Pre-Pregnancy Weight Estimate Non-numeric, excluding blanks
31 Woman's Weight English—Prenatal Visit  9990 - 9998 or non-numeric, excluding blanks.  Last digit (fraction) other than 0-3
32 Woman's Weight Metric—Prenatal Visit  Non-numeric, excluding blanks
33 Woman's Weight English—Postpartum Visit  9990 - 9998 or non-numeric, excluding blanks.  Last digit (fraction) other than 0-3
34 Woman's Weight Metric—Postpartum Visit  Non-numeric, excluding blanks
35 Positive or Negative (Pos or Neg) Weight Gain Values other than + or -, Blank or 9 = unknown
36 Total Weight Gain Non-numeric, excluding blanks
37 Hemoglobin—Prenatal Visit  990 - 998 or non-numeric, excluding blanks  
38 Hematocrit—Prenatal Visit  990 - 998 or non-numeric, excluding blanks  
39 Date of Hemoglobin or Hematocrit Measure— Prenatal Visit Non-numeric, excluding blanks. After excluding all blanks or all 9s, Year is 3 years < computer date or year is > computer date; Month is blank or < 01 or > 12; Day is blank, 99 or < 01 or > maximum days for month; Year is blank, 9999 or 0000
40 Hemoglobin—Postpartum Visit 990 - 998 or non-numeric, excluding blanks  
41 Hematocrit—Postpartum Visit 990 - 998 or non-numeric, excluding blanks  
42 Date of Hemoglobin/Hematocrit Measure—Postpartum Visit Non-numeric, excluding blanks. After excluding all blanks or all 9s, Month is blank, 99 or < 01 or > 12; Day is blank, 99 or < 01 or > maximum days for month; Year is blank, 9999 or 0000
43 Parity Values other than  00-29, Blanks or 99 = unknown
44 Date Last Pregnancy Ended Non-numeric, excluding blanks. After excluding all blanks or all 9s, Year is 41 years < computer date or Year is > computer date. Month is blank, 99 or < 01 or > 12; Year is blank, 9999 or 0000
45 Gestational Diabetes—Postpartum Visit Values other than 1 (Yes) or 2 (No),  Blank or 9 = unknown  
46 Hypertension During Pregnancy—Postpartum Visit Values other than 1 (Yes) or 2 (No),  Blank or 9 = unknown  
47 Medical Care Began Values other than 0 - 8, Blank or 9 = unknown
48 Date Enrolled in WIC Non-numeric, excluding blanks. After excluding all blanks or all 9s, Month is blank, 99 or < 01 or > 12; Day is blank, 99 or < 01 or > maximum days for month; Year is blank, 9999 or 0000
49 Multivitamin Consumption Prior to Pregnancy Values other than 0 - 8, Blank or 9 = unknown
50 Multivitamin Consumption During Pregnancy Values other than 1(Yes) or 2 (No),  Blank or 9 = unknown  
51 Cigarettes/Day—3 Months Prior to Pregnancy Non-numeric, excluding blanks
52 Cigarettes/Day—Prenatal Visit Non-numeric, excluding blanks
53 Cigarettes/Day—Last 3 Months of Pregnancy Non-numeric, excluding blanks
54 Cigarettes/Day—Postpartum Visit Non-numeric, excluding blanks
55 Household Smoking— Prenatal Visit Values other than 1(Yes) or 2 (No),  Blank or 9 = unknown  
56 Household Smoking— Postpartum Visit Values other than 1(Yes) or 2 (No),  Blank or 9 = unknown  
57 Drinks/Week—3 Months Prior to Pregnancy Values other than 00 - 21 or 98, Blanks or 99 = unknown/refused
58 Drinks/Week—Last 3 Months of Pregnancy Values other than 00 - 21 or 98, Blanks or 99 = unknown/refused
60 Infant's Date of Birth Non-numeric, excluding blanks. After excluding all blanks or all 9s, Year is 3 years < computer date or Year is > computer date. Month is blank, 99 or < 01 or > 12; Day is blank, 99 or < 01 or > maximum days for month; Year is blank, 9999 or 0000
61 Number of Infants Values other than 1 - 8, Blank or 9 = unknown
62 Born Alive or Dead Values other than 1 (born Alive),  2 (born dead), Blank or 9 = unknown
63 Birthweight—English  9990-9998 or non-numeric, excluding blanks. Last two digits (ounces) other than 00-15
64 Birthweight—Metric  Non-numeric characters, excluding blanks
65 Currently Breastfed Values other than 1 (yes),  2 (no), Blank or 9 = unknown
66 Ever Breastfed Values other than 1 (yes),  2 (no), Blank or 9 = unknown