How To... Review Data Quality - Periodic Data
The Total records submitted is a description of the number and percent of records on the transaction file that were submitted to CDC for analysis by the month and year of the child's date of visit for PedNSS and the mother's expected date of delivery (EDD), or last menstrual period (LMP) if EDD is not available, or infant's birth date for PNSS. Individual months are listed only if they comprise > 5% of the total records on the file. The cumulative percent of records should always be 100%.
A duplicate record is a record submitted from the contributor that is mostly or entirely identical to another record in the same transaction file. When duplicate records are identified the first reported record is retained. There are four types of duplicate errors:
A critical error is a field that has missing or invalid data for the data that are critical for data analysis. Critical fields are defined differently for PedNSS and PNSS.
To reduce the number of records rejected for critical errors in both PedNSS and PNSS, ensure that all critical fields are required to be collected by clinic staff. For PNSS, ensure that a woman's postpartum visit date is copied to the initial visit date field on postpartum only records.
Records Replaced on Master File indicates records on the transaction
file that will replace records already on the master file. This occurs
when all key fields match on both transaction and master file records.
If the data quality report indicates that records were replaced on your master file:
Records added to the master file includes the number and percent of records from the transaction file that were added to the master file. For PNSS, this includes information on the proportion of complete, prenatal only, and postpartum only records on the file. A lower or higher expected proportion of specific record types can indicate problems with assignment of completion codes. Generally the proportion of complete records should not be less than 50% of records and the proportion of either prenatal only or postpartum only records should not be less than 5% of records. These criterion are based on national PNSS that show about 70% of records are complete records 10% of records are prenatal only records, and 20% of records are postpartum only records. The Completion Code and Record Linkage Errors section of this report provides more information on the types of errors that result in incorrect assignment of a completion code for a record.
Total % of transaction records added to the master file is on the last line of the report summarizes the percent of records from the transaction file that were added to the master file.
Updated Number of PNSS Master File Records lists the prior years and
current year-to-date monthly master file record volume including records
from this transaction file that were added to the master file. Some
problems that this portion of the PNSS data quality report can help
identify are monthly record volume that is not similar to other months in
same year, and current year monthly record volumes that are not similar to
prior year monthly record volumes.
If record volume is inconsistent:
Page last reviewed: May 1, 2009
Page last updated: May 1, 2009
Content Source: Division of Nutrition, Physical Activity and Obesity, National Center for Chronic Disease Prevention and Health Promotion
States Department of Health and Human Services