Import Errors and Warnings
 
This topic describes the possible errors and warnings that the MCMP-PAT Importer generates.

Critical Errors
The list of critical errors below will prevent the import process from continuing.
Error Description Sample Error Message
Missing required column The column or columns holding the primary key value must be present in the source file.  For the Patient dataset, the column is PatIDHIC.  For the Patient Visits dataset the columns are PatIDHIC and HFPCVisitDate. "'PatIDHIC' is required but is missing from the source file."
Duplicate value in primary key column(s) A duplicate value in the column or columns that hold the primary key will prevent the data from being imported. For patients dataset:
"999999999X duplicate found. Each row in the PatIDHIC column must have a unique value."

For visits dataset:
"Duplicate visit of 999999999X on 01/01/2008.  Only one visit date per patient is allowed."
Extra column A column name that is not in the list of valid columns. "'Blah blah' is not a valid column name."
Duplicate column name A column that appears twice in the source file. "'DMBPSystolic' has a duplicate column."
Lab dates without value columns or vice versa For example, the DMHbA1cDate column is present but DMHbA1cValue is not. "'DMLDLCDate' requires that the DMLDLCValue column be included."
Blood pressure dates without systolic or diastolic columns or vice versa For example, the DMBPSystolic and DMBPDiastolic columns are present but the DMBPDate column is not. "'DMBPSystolic' requires that the DMBPDate column be included."

Value Errors
These errors are caused by invalid values or values that are outside of the valid range.  Rows with errors are displayed with light red background in the "Check Data" step in the Importer utility.  These are some example situations that can cause this error.
Column name
 Value to import Valid values Result
DMHbA1cDate 05/05/2007 Assuming that the database in use is for the baseline year, then the valid date range is 01/01/2006 to 12/31/2006. The value will not be imported.
DMBPSystolic 360 Maximum valid value is 350. The value will not be imported.
HFConfirmed 4 0, 1 & 2 The value will not be imported since it is not in the list of valid values.  The valid values of other columns under the HF measure may still be imported.
CADLDLCDate X The date must be in "MM/DD/YYYY" format. The value will not be imported since it is an invalid date. "X" is only allowed to represent an unknown date during manual abstraction.

Warnings
These situations are not considered errors though the examples in the last two rows will prevent the value from being imported.
Column name
 Value to import Warning Valid values Result
FirstName
 "First Name Is Longer Than 20 Characters" Text is too long. The FirstName column has a maximum of 20 characters. The value will be truncated.  The value to be imported will be "First Name Is Longer".
CADLipid 0 The stored value is 1/"Yes" and will not be overwritten. This assumes that the stored value is 1/Yes, and the user opted not to overwrite 1/Yes values. The value will not be imported even though it is valid.
CADLDLCDate 09/10/2006 The stored value is 11/12/2006 and will not be overwritten. This assumes that the stored date is 11/12/2006, and the user opted not to overwrite more current dates. The date will not be imported even though it is valid.