|
||||||||||||||||
|
|
How To... Review Data Quality - Periodic Data
Quality
|
|
|||||||||||
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 initial visit date 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%.
Duplicate Records
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:
Critical 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.
Review PedNSS edit criteria for Duplicate
Records and Critical Errors.
Review PNSS edit criteria for Duplicate
Records and Critical Errors.
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 65% of records are complete records 12% of records are prenatal only records, and 23% 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
the
same year, and current year monthly record volumes that are not similar to
prior year monthly record volumes.
If record volume is inconsistent: