C. V ITAL S IGNS Q UALITY R EVIEW O UTPUT E XAMPLE
VI. APPENDIX A: LIST OF ALL QA ERR CODES
Full Err Code Description of Error
ALL2.1.1 PatID variable has inconsistent lengths across tables ENR_DEM2.1.10 At least one PatID in the ENR table is not in the DEM table ENR_DIS2.1.11 At least one PatID in the ENR table is not in the DIS table ENR_ENC2.1.12 At least one PatID in the ENR table is not in the ENC table ENR_DIA2.1.13 At least one PatID in the ENR table is not in the DIA table ENR_PRO2.1.14 At least one PatID in the ENR table is not in the PRO table ENR1.0.0 Table does not exist
ENR1.1.1 PatID variable is not character type ENR1.1.2 PatID variable has missing values
ENR1.1.3 PatID variable has non-missing values that are not left-justified ENR1.1.4 PatID variable contains special characters
ENR1.2.1 Enr_Start variable is not SAS date value of numeric data type ENR1.2.2 Enr_Start variable is not of length 4
ENR1.2.3 Enr_Start variable has missing values
ENR1.3.1 Enr_End variable is not SAS date value of numeric data type ENR1.3.2 Enr_End variable is not of length 4
ENR1.3.3 Enr_End variable has missing values
ENR1.3.6 Enr_End variable has values after the maximum dispensing
dates and utilization
ENR1.4.1 MedCov variable is not character type
ENR1.4.2 MedCov variable is not exactly 1 character in length ENR1.4.3 MedCov variable has missing values
ENR1.4.4 MedCov variable has values other than "Y", "N", or "U"
ENR1.5.1 DrugCov variable is not character type
ENR1.5.2 DrugCov variable is not exactly 1 character in length ENR1.5.3 DrugCov variable has missing values
ENR1.5.4 DrugCov variable has values other than "Y", "N", or "U"
ENR1.6.1 Chart variable is not character type
ENR1.6.2 Chart variable is not exactly 1 character in length ENR1.6.3 Chart variable has missing values
ENR1.6.4 Chart variable has values other than "Y" or "N"
ENR2.0.0 Record(s) have duplicate key value combinations (with respect to table definition)
ENR2.2.1 Enr_Start is after Enr_End
ENR2.2.3 Enr_Start occurs more than once in the file in combination with PatID, MedCov, and DrugCov
Full Err Code Description of Error
ENR2.3.4 Enr_End occurs more than once in the file in combination with PatID, MedCov, and DrugCov
ENR2.6.1 At least one PatID has records with inconsistent MedCov and DrugCov indicators with the same year/month/day of enrollment
ENR3.0.1 Significant change in number of records between ETLs ENR3.1.1 Problem with number of unique PatIDs
ENR3.2.1 Problem with distribution of Enr_Start variable ENR3.3.4 Problem with distribution of Enr_End variable
ENR3.4.1 Problem with distribution of enrollment months per patient for patients with MedCov = "Y"
ENR3.4.2 Problem with distribution of MedCov indicators
ENR3.4.3 Problem with distribution of MedCov indicators per year within the ETL ENR3.4.4 Problem with distribution of MedCov indicators per year-month within the
ETL
ENR3.4.5 Problem with distribution of MedCov indicators per year across ETLs ENR3.4.6 Problem with distribution of MedCov indicators per year-month across ETLs ENR3.5.1 Problem with distribution of enrollment months per patient for patients with
DrugCov = "Y"
ENR3.5.2 Problem with distribution of DrugCov indicators
ENR3.5.3 Problem with distribution of DrugCov indicators per year within the ETL ENR3.5.4 Problem with distribution of DrugCov indicators per year-month within the
ETL
ENR3.5.5 Problem with distribution of DrugCov indicators per year across ETLs ENR3.5.6 Problem with distribution of DrugCov indicators per year-month across ETLs ENR3.6.1 Problem with distribution of enrollment months per patient for patients with
MedCov = "Y" and DrugCov = "Y"
ENR3.6.2 Problem with distribution of MedCov*DrugCov indicators
ENR3.6.3 Problem with distribution of MedCov*DrugCov indicators per year within the ETL
ENR3.6.4 Problem with distribution of MedCov*DrugCov indicators per year-month within the ETL
ENR3.6.5 Problem with distribution of MedCov*DrugCov indicators per year across ETLs
ENR3.6.6 Problem with distribution of MedCov*DrugCov indicators per year-month across ETLs
ENR3.6.7 Problem with distribution of total number of patients with MedCov = "Y" and DrugCov = "Y" and at least 1 overlapping enrollment span
ENR3.6.8 Problem with distribution of total number of overlapping enrollment spans for all patients with MedCov = "Y" and DrugCov = "Y"
ENR_DEM2.1.1 At least one PatID in the DEM table is not in the ENR table
Full Err Code Description of Error DEM1.0.0 Table does not exist
DEM1.1.1 PatID variable is not character type DEM1.1.2 PatID variable has missing values
DEM1.1.3 PatID variable has non-missing values that are not left-justified DEM1.1.4 PatID variable contains special characters
DEM1.2.1 Birth_Date variable is not SAS date value of numeric data type DEM1.2.2 Birth_Date variable is not of length 4
DEM1.2.3 Birth_Date variable has missing values
DEM1.2.4 Birth_Date variable has values before 1/1/1885 DEM1.3.1 Sex variable is not character type
DEM1.3.2 Sex variable is not exactly 1 character in length DEM1.3.3 Sex variable has missing values
DEM1.3.4 Sex has values other than "F", "M", "A", or "U"
DEM1.4.1 Hispanic variable is not character type
DEM1.4.2 Hispanic variable is not exactly 1 character in length DEM1.4.3 Hispanic variable has missing values
DEM1.4.4 Hispanic variable has values other than "Y", "N", or "U"
DEM1.5.1 Race variable is not character type
DEM1.5.2 Race variable is not exactly 1 character in length DEM1.5.3 Race variable has missing values
DEM1.5.4 Race variable has values other than "0", "1", "2", "3", "4", or "5"
DEM1.6.1 ZIP variable is not character type
DEM1.6.2 ZIP variable is not exactly 5 characters in length DEM1.6.3 ZIP variable has missing values
DEM1.7.1 ZIP_Date variable is not SAS date value of numeric data type DEM1.7.2 ZIP_Date variable is not length of 4
DEM1.7.3 ZIP_Date variable has missing values
DEM1.7.4 ZIP_Date variable has values before MinDate DEM1.7.5 ZIP_Date variable has values after MaxDate
DEM2.0.0 Record(s) have duplicate key value combinations (with respect to table definition)
DEM3.0.1 Significant change in number of records between ETLs DEM3.1.1 Problem with number of unique PatIDs
DEM3.2.2 Problem with distribution of age
DEM3.2.3 Problem with distribution of age groups (0-1 yrs, 2-4 yrs, 5-9 yrs, 10-14 yrs, 15-18 yrs, 19-21 yrs, 22-44 yrs, 45-64 yrs, 65-74 yrs, 75+ yrs)
DEM3.3.1 Problem with distribution of Sex variable DEM3.4.1 Problem with distribution of Race variable DEM3.5.1 Problem with distribution of Hispanic variable
ENR_DIS2.1.2 At least one PatID in the DIS table is not in the ENR table
Full Err Code Description of Error DIS1.0.0 Table does not exist
DIS1.1.1 PatID variable is not character type DIS1.1.2 PatID variable has missing values
DIS1.1.3 PatID variable has non-missing values that are not left-justified DIS1.1.4 PatID variable contains special characters
DIS1.2.1 RxDate variable is not a SAS date value of numeric data type DIS1.2.2 RxDate variable is not of length 4
DIS1.2.3 RxDate variable has missing values DIS1.3.1 NDC variable is not character data type
DIS1.3.2 NDC variable is not exactly 11 characters in length DIS1.3.3 NDC variable has missing values
DIS1.3.4 NDC variable contains special characters or non-digits DIS1.4.1 RxSup variable is not numeric type
DIS1.4.2 RxSup variable is not of length 4
DIS1.4.3 RxSup variable has negative, missing, or zero values
DIS1.4.4 RxSup variable has a format length (no format length should be specified) DIS1.5.1 RxAmt variable is not numeric type
DIS1.5.2 RxAmt variable is not of length 4
DIS1.5.3 RxAmt variable has negative, missing or zero values
DIS1.5.4 RxAmt variable has a format length (no format length should be specified) DIS2.0.0 Record(s) have duplicate key value combinations (with respect to table
definition)
DIS3.0.1 Significant change in number of records between ETLs DIS3.1.1 Problem with number of unique PatIDs
DIS3.2.1 Problem with distribution of RxDate (i.e. total number of dispensings per year) within the ETL
DIS3.2.2 Problem with distribution of RxDate (i.e. total number of dispensings per year-month) within the ETL
DIS3.2.3 Significant change in number of records per RxDate (year) across ETLs DIS3.2.4 Significant change in number of records per RxDate (year-month) across ETLs DIS3.2.5 Problem with distribution of RxDate (overall) within the ETL
DIS3.2.6 Problem with distribution of RxDate (overall) across ETLs DIS3.4.1 Problem with distribution of RxSup
DIS3.5.1 Problem with distribution of RxAmt
DIS3.5.2 Problem with average number of prescriptions per PatID by year ENR_ENC2.1.3 At least one PatID in the ENC table is not in the ENR table ENC_DIA_PRO2.2.1 EncounterID variable has inconsistent lengths across tables
Full Err Code Description of Error
ENC_DIA_PRO2.2.6 ENC table has EncounterID values which are not found in the DIA and PRO tables
ENC_DIA_PRO2.5.1 Provider variable has inconsistent lengths across tables ENC_DIA2.2.4 ENC table has EncounterID values not found in the DIA table ENC_PRO2.2.5 ENC table has EncounterID values not found in the PRO table ENC1.0.0 Table does not exist
ENC1.1.1 PatID variable is not character type ENC1.1.2 PatID variable has missing values
ENC1.1.3 PatID variable has non-missing values that are not left-justified ENC1.1.4 PatID variable contains special characters
ENC1.2.1 EncounterID variable is not character type ENC1.2.2 EncounterID variable has missing values
ENC1.2.3 EncounterID variable has non-missing values that are not left-justified ENC1.2.4 EncounterID variable contains special characters
ENC1.3.1 ADate variable is not SAS date value of numeric data type ENC1.3.2 ADate variable is not of length 4
ENC1.3.3 ADate variable has missing values
ENC1.4.1 DDate variable is not SAS date value of numeric data type ENC1.4.2 DDate variable is not of length 4
ENC1.5.1 Provider variable is not character type
ENC1.5.2 Provider
of the tavariable has missing values and should be populated for all records ble (part of the definition of the table)
ENC1.5.3 Provider variable has non-missing values that are not left-justified ENC1.5.4 Provider variable contains special characters
ENC1.6.1 Facility_Location variable is not character type
ENC1.6.2 Facility_Location variable is not exactly 3 characters in length ENC1.6.3 Facility_Location variable contains non-digits
ENC1.6.4 Facility_Location has missing values
ENC1.6.5 Facility_Location variable has non-missing values that are not left-justified ENC1.7.1 EncType variable is not character type
ENC1.7.2 EncType variable is not exactly 2 characters in length ENC1.7.3 EncType variable has missing values
ENC1.7.4 EncType variable has values other than "IP", "IS", "ED", "AV", or "OA"
ENC1.8.1 Facility_Code variable is not character type ENC1.8.2 Facility_Code variable contains special characters
ENC1.8.3 Facility_Code variable has non-missing values that are not left-justified ENC1.8.4 Facility_Code has missing values
ENC1.9.1 Discharge_Disposition variable is not character type
Full Err Code Description of Error
ENC1.9.2 Discharge_Disposition variable is not exactly 1 character in length
ENC1.9.3 Discharge_Disposition variable has values other than "A", "E", "U", or missing ENC1.10.1 Discharge_Status variable is not character data type
ENC1.10.2 Discharge_Status variable is not exactly 2 characters in length
ENC1.10.3 Discharge_Status variable has values other than "AF", "AL", "AM", "AW",
"EX", "HH", "HS", "HO", "IP", "NH", "OT", "RS", "RH", "SH", "SN", “UN”, or missing
ENC1.11.1 DRG variable is not character type
ENC1.11.2 DRG variable is not exactly 3 characters in length ENC1.11.3 DRG variable contains non-digits
ENC1.12.1 DRG_Type variable is not character type
ENC1.12.2 DRG_Type variable is not exactly 1 character in length
ENC1.12.3 DRG_Type variable contains values other than "1", "2", or missing ENC1.13.1 Admitting_Source variable is not character type
ENC1.13.2 Admitting_Source variable is not exactly 2 characters in length
ENC1.13.3 Admitting_Source variable contains values other than "AV", "ED", "AF", "AL",
"HH", "HS", "HO", "IP", "NH", "OT", "RS", "RH", "SN", "UN", or missing ENC2.0.0 Record(s) have duplicate key value combinations (with respect to table
definition)
ENC2.2.1 EncounterID values occur more than once
ENC2.2.7 EncounterID variable does not contain (in this order) PatID, ADate, Provider, EncType
ENC2.3.1 ADate is after DDate (for IP and IS only)
ENC2.3.2 ADate and DDate variables have values before DP_MinDate ENC2.4.1 DDate variable is missing for EncType value "IP"
ENC2.4.2 DDate variable is populated for records with EncType values other than "IP"
or "IS"
ENC2.9.1 Discharge_Disposition variable is missing for EncType values "IP" or "IS"
ENC2.9.2 Discharge_Disposition variable is populated for records with EncType values other than "IP" or "IS"
ENC2.10.1 Discharge_Status variable is missing for EncType values "IP" or "IS"
ENC2.10.2 Discharge_Status variable is populated for records with EncType values other than "IP" or "IS"
ENC2.11.1 DRG variable is missing for EncType values "IP" or "IS"
ENC2.11.2 DRG variable is populated for records with EncType values other than "IP",
"IS", or "ED"
ENC2.12.1 DRG_Type variable is missing for EncType values "IP" or "IS"
ENC2.12.2 DRG_Type variable is populated for records with EncType values other than
"IP", "IS", or "ED"
ENC2.13.1 Admitting_Source variable is missing for EncType values "IP" or "IS"
Full Err Code Description of Error
ENC2.13.2 Admitting_Source variable is
other than "IP" or "IS" populated for records with EncType values ENC3.0.1 Significant change in number of records between ETLs
ENC3.1.1 Problem with number of unique PatIDs ENC3.2.1 Problem with number of unique EncounterIDs
ENC3.3.1 Problem with distribution of ADate (i.e. total number of records per year) within the ETL
ENC3.3.2 Problem with distribution of ADate (i.e. total number of records per
month) within the ETL
year-ENC3.3.3 Significant change in number of records per ADate (year) across ETLs ENC3.3.4 Significant change in number of records per ADate (year-month) across ETLs ENC3.3.5 Problem with distribution of ADate (overall) within the ETL
ENC3.3.6 Problem with distribution of ADate (overall) across ETLs
ENC3.4.1 Problem with distribution of DDate (i.e. total number of records per year) within the ETL
ENC3.4.5 Problem with distribution of DDate (i.e. total number of records per
month) within the ETL
year-ENC3.4.6 Significant change in number of records per DDate (year) across ETLs ENC3.4.7 Significant change in number of records per DDate (year-month) across ETLs ENC3.4.8 Problem with distribution of DDate (overall) within the ETL
ENC3.4.9 Problem with distribution of DDate (overall) across ETLs
ENC3.4.10 Problem with distribution of DDate variable by EncType per year ENC3.4.11 Problem with distribution of DDate variable by EncType per year-month ENC3.4.12 Problem with distribution of length of stay (DDate-ADate + 1) by EncType ENC3.4.13 Problem with distribution of length of stay (DDate-ADate + 1) by EncType per
year
ENC3.5.1 Problem with number of unique Provider values ENC3.7.4 Problem with distribution of number
EncType of encounters per member by year and
ENC3.7.5 Problem with distribution of number of encounters per member by year-month and EncType
ENC3.7.6 Problem with distribution of number of records by EncType per year within the ETL
ENC3.7.7 Problem with distribution of number of records by EncType per year-month within the ETL
ENC3.7.8 Significant change in number of records by EncType per year across ETLs ENC3.7.9 Significant change in number
ETLs of records by EncType per year-month across
ENC3.9.1 Problem with distribution of Discharge_Disposition variable (overall)
Full Err Code Description of Error
ENC3.9.2 Problem with distribution of Discharge_Disposition variable (by EncType) ENC3.10.1 Problem with distribution of Discharge_Status variable (overall)
ENC3.10.2 Problem with distribution of Discharge_Status variable (by EncType) ENC3.11.1 Problem with distribution of DRG variable
ENC3.12.1 Problem with distribution of DRG_Type variable (overall)
ENC3.12.2 Problem with distribution of DRG_Type variable (by year to confirm switch from old to new system)
ENC3.12.3 Problem with distribution of DRG_Type variable (by EncType) ENC3.13.1 Problem with distribution of Admitting_Source variable (overall) ENC3.13.2 Problem with distribution of Admitting_Source variable (by EncType) ENR_DIA2.1.4 At least one PatID in the DIA table is not in the ENR table
ENC_DIA2.2.2 DIA table has EncounterID values not found in the ENC table DIA1.0.0 Table does not exist
DIA1.1.1 PatID variable is not character type DIA1.1.2 PatID variable has missing values
DIA1.1.3 PatID variable has non-missing values that are not left-justified DIA1.1.4 PatID variable contains special characters
DIA1.2.1 EncounterID variable is not character type DIA1.2.2 EncounterID variable has missing values
DIA1.2.3 EncounterID variable has non-missing values that are not left-justified DIA1.2.4 EncounterID variable contains special characters
DIA1.3.1 ADate variable is not SAS date value of numeric data type DIA1.3.2 ADate variable is not of length 4
DIA1.3.3 ADate variable has missing values DIA1.4.1 Provider variable is not character type
DIA1.4.2 Provider variable has missing values and should be populated for all records of the table (part of the definition of the table)
DIA1.4.3 Provider variable has non-missing values that are not left-justified DIA1.4.4 Provider variable contains special characters
DIA1.5.1 EncType variable is not character type
DIA1.5.2 EncType variable is not exactly 2 characters in length
DIA1.5.3 EncType variable has missing values and should be populated for all records of the table (part of the definition of the table)
DIA1.5.4 EncType variable has values other than "IP", "IS", "ED", "AV", or "OA"
DIA1.6.1 DX variable Is not character type
DIA1.6.2 DX variable is not exactly 18 characters in length
DIA1.6.3 DX variable has missing values and should be populated for all records of the table (part of the definition of the table)
DIA1.6.4 DX variable contains special characters other than a decimal point
Full Err Code Description of Error
DIA1.6.5 Problem with the length of DX values DIA1.7.1 Dx_Codetype variable is not character type
DIA1.7.2 Dx_Codetype variable is not exactly 2 characters in length
DIA1.7.3 Dx_Codetype variable contains values other than "09", "10", "11", "SM", or
"OT"
DIA1.8.1 OrigDX variable is not character type DIA1.9.1 PDX variable is not character type
DIA1.9.2 PDX variable is not exactly 1 character in length
DIA1.9.3 PDX variable contains values other than "P", "S", "X", or missing DIA2.0.0 Record(s) have duplicate key value combinations (with respect to table
definition)
DIA2.2.6 EncounterID variable does not contain (in this order) PatID, ADate, Provider, EncType
DIA2.9.2 PDX variable is populated for EncType values other than "IP" or "IS"
DIA2.9.1 PDX variable has missing values for EncType values "IP" or "IS"
DIA3.0.1 Significant change in number of records between ETLs DIA3.1.1 Problem with number of unique PatIDs
DIA3.2.1 Problem with number of unique EncounterIDs
DIA3.3.1 Problem with distribution of ADate (i.e. total number of records per year) within the ETL
DIA3.3.2 Problem with distribution of ADate (i.e. total number of records per year-month) within the ETL
DIA3.3.3 Significant change in number of records per ADate (year) across ETLs DIA3.3.4 Significant change in number of records per ADate (year-month) across ETLs DIA3.3.5 Problem with distribution of ADate (overall) within the ETL
DIA3.3.6 Problem with distribution of ADate (overall) across ETLs DIA3.4.1 Problem with number of unique Provider values
DIA3.5.1 Problem with distribution of number of records by EncType per year within the ETL
DIA3.5.2 Problem with distribution of number of records by EncType per year-month within the ETL
DIA3.5.3 Significant change in number of records by EncType per year across ETLs DIA3.5.4 Significant change in number
ETLs of records by EncType per year-month across
DIA3.5.5 Problem with distribution of number of unique diagnoses per encounter visit (overall)
DIA3.6.1 Problem with distribution of DX variable
DIA3.6.2 DX variable is not consistent with Dx_Codetype variable DIA3.7.1 Problem with distribution of Dx_Codetype (by year) DIA3.7.2 Problem with distribution of Dx_Codetype (by EncType)
Full Err Code Description of Error
DIA3.9.1 Problem with distribution of PDX variable.
DIA3.9.2 Problem with distribution of PDX*EncType
ENR_PRO2.1.5 At least one PatID in the PRO table is not in the ENR table ENC_PRO2.2.3 PRO table has EncounterID values not found in the ENC table
ENR_PRO2.1.5 At least one PatID in the PRO table is not in the ENR table ENC_PRO2.2.3 PRO table has EncounterID values not found in the ENC table