3 Sentinel Quality Assurance Package

This documentation describes Sentinel Quality Assurance Program Package 9.1.1. This program package is used by the Sentinel Operations Center (SOC) for data quality assurance (QA) review and characterization of the Sentinel Distributed Database (SDD). To create the SDD, each Data Partner (DP) transforms local source data into Sentinel Common Data Model (SCDM) format. The SOC uses a set of data quality review and characterization programs to ensure that the SDD meets reasonable standards for data transformation consistency and quality. This version of the QA program package queries SCDM version 8.0.0 and 8.1.0 tables.

Table 3.1 describes the modification history of this package.

Table 3.1: QA Package History of Modifications
Version Date Modification
9.1.1 04/02/2025

  • Updates embedded program versions.
9.1.0 02/28/2025

  • Improves age reporting by implementing 5 year ago cohorts from 0–80 years of age.
  • Updates run_snapshot macro to allow for calling of refactored scdm_snapshot program.
9.0.2 12/06/2024
  • SCDM 8.2.1 Compatibility: Updates the package to add cause type to the definition of a Cause of Death table unique row.
9.0.1 07/08/2024
  • Minor Package Updates
9.0.0 06/06/2024
  • Integrates Common Components and the SCDM Snapshot Program Package as modules in the QA Package
  • Updates the description of CheckID 245 to read “variable contains an incorrect non-missing value.”
  • Integrates logic allowing for the optional suppression of small cells on a table by table basis
8.9.0 04/11/2024
  • Overhauls the Level 2 module to improve readability and maintainability
  • Consolidates MSOC log output to single qa_package.log file
  • PostalCode_Date is now included in all_l3_dates_dist
  • Fixes an issue where system errors could result in DP Max Date being set to defaults instead of being zeroed out, and in rare cases, giving the impression that the package had run successfully
  • Removes unused variables module_cat and module_util from control_flow

MIR module updates

  • Removes the following non-live birth codes from m_cohortcodes
  • 64631: Recurrent pregnancy loss, delivered, with or without mention of antepartum condition
  • 64601: Papyraceous fetus, delivered, with or without mention antepartum cond
  • Adjusts the Mother’s washout period to 182 days
8.8.0 12/15/2023

QA Package 8.8.0 adds SCDM 8.2.0 compatibility while retaining backwards compatibility with SCDM 8.1.0. It also introduces the a new master program parameter ZIP3, which allows the package to run at Data Partners with three digit zip codes, aswell as numerous minor bug fixes and code enhancements.

SCDM 8.2.0 Compatibility Updates

New Checks
  • CheckID 224: &variable1 &value does not match &variable2 &value
New Flags
  • FlagID: DEM_1_08_00-0_110
    • Description: ImputedHispanic variable does not exist
    • FlagType: Fail
    • Abort: Y
  • FlagID: DEM_1_09_00-0_110
    • Description: ImputedRace variable does not exist
    • FlagType: Fail
    • Abort: Y
  • FlagID: DEM_1_08_00-0_111
    • Description: ImputedHispanic variable is not populated
    • FlagType: Note
    • Abort: N
  • FlagID: DEM_1_09_00-0_111
    • Description: ImputedRace variable is not populated
    • FlagType: Note
    • Abort: N
  • FlagID: DEM_1_08_00-0_112
    • Description: ImputedHispanic variable type does not conform to specifications
    • FlagType: Fail
    • Abort: Y
  • FlagID: DEM_1_09_00-0_112
    • Description: ImputedRace variable type does not conform to specifications
    • FlagType: Fail
    • Abort: Y
  • FlagID: DEM_1_08_00-0_113
    • Description: ImputedHispanic variable length does not conform to specifications
    • FlagType: Fail
    • Abort: Y
  • FlagID: DEM_1_09_00-0_113
    • Description: ImputedRace variable length does not conform to specifications
    • FlagType: Fail
    • Abort: Y
  • FlagID: DEM_1_08_00-0_121
    • Description: ImputedHispanic variable contains an invalid non-missing value
    • FlagType: Fail
    • Abort: Y
  • FlagID: DEM_1_09_00-0_121
    • Description: ImputedRace variable contains an invalid non-missing value
    • FlagType: Fail
    • Abort: Y
  • FlagID: ENR_1_07_00-0_110
    • Description: PlanType variable does not exist
    • FlagType: Fail
    • Abort: Y
  • FlagID: ENR_1_08_00-0_110
    • Description: PayerType variable does not exist
    • FlagType: Fail
    • Abort: Y
  • FlagID: ENR_1_07_00-0_111
    • Description: PlanType variable is not populated
    • FlagType: Note
    • Abort: N
  • FlagID: ENR_1_08_00-0_111
    • Description: PayerType variable is not populated
    • FlagType: Note
    • Abort: N
  • FlagID: ENR_1_07_00-0_112
    • Description: PlanType variable type does not conform to specifications
    • FlagType: Fail
    • Abort: Y
  • FlagID: ENR_1_08_00-0_112
    • Description: PayerType variable type does not conform to specifications
    • FlagType: Fail
    • Abort: Y
  • FlagID: ENR_1_07_00-0_113
    • Description: PlanType variable length does not conform to specifications
    • FlagType: Fail
    • Abort: Y
  • FlagID: ENR_1_08_00-0_113
    • Description: PayerType variable length does not conform to specifications
    • FlagType: Fail
    • Abort: Y
  • FlagID: ENR_1_07_00-0_121
    • Description: PlanType variable contains an invalid non-missing value
    • FlagType: Fail
    • Abort: Y
  • FlagID: ENR_1_08_00-0_121
    • Description: PayerType variable contains an invalid non-missing value
    • FlagType: Fail
    • Abort: Y
  • FlagID: COD_2_02_00-0_223
    • Description: COD value is invalid based on CodeType value
    • FlagType: Warn
    • Abort: N
  • FlagID: COD_2_02_00-0_228
    • Description: COD value length is invalid based on CodeType
    • FlagType: Warn
    • Abort: N
  • FlagID: DEM_2_04_00-0_224
    • Description: Hispanic value does not match ImputedHispanic value
    • FlagType: Note
    • Abort: N
  • FlagID: DEM_2_05_00-0_224
    • Description: Race value does not match ImputedRace value
    • FlagType: Note
    • Abort: N
Modified Flags
  • FlagID: ENR_2_00_00-0_211
    • Description: Duplicate record(s) present for unique key variable(s): PatID, Enr_Start, Enr_End, MedCov, DrugCov, Chart, PlanType, PayerType
    • Description of Change: Added PlanType and PayerType to unique key
    • FlagType: Fail
    • Abort: Y
  • FlagID: ENR_2_02_00-0_226
    • Description: Enr_Start value occurs after Enr_End value
    • Description of Change: ENR_2_02_00-0_226 has been modified to be a FAIL/ABORT flag: Enr_Start value occurs after Enr_End value
    • FlagType: Fail
    • Abort: Y
New Tables
  • cod_l2_cod_codetype: contains the frequency of records stratified by CodeType and COD values
  • enr_l3_catvars: contains the frequency of records stratified by PlanType and PayerType
Updated Tables
  • dem_l3_catvars: This dataset contains frequency of records stratified by sex, race, hispanic, imputedRace, and imputedHispanic values
Additional Updates
  • Added additional logic which will preprocess inputfiles when parameter SCDMVer = 8.1.0 in the QA Package master program, allowing backwards compatibility with SCDM 8.1.0
  • Added additional logic which will preprocess inputfiles to handle ZIP3 when parameter ZIP3 = Y
  • Retired checks 100 & 101. The QA Package will still check for the existence of tables and whether they are populated, but will abort and write an error to the log rather than outputting a flag
  • Retired check 123, which had not been in use since SCDM 7
  • Streamlined Checks 111 & 120 to ensure they did not apply when redundant to each other
  • General refactoring to improve efficiency and code quality, as well as minor bug fixes
8.7.1 10/30/2023

Minor Package Updates and Bug Fixes.

8.7.0 08/31/2023

Elimination of Separate QAR and QCR Lookups

  • Input files are now stored in the inputfiles folder and modified at the start of the package run based on master program parameters

Automated Creation of Data Characteristics Sign-Off Report

  • The Data Characteristics Sign-off Report is automatically generated upon a successful package run. This can be found in the msoc folder under the name data_characteristics_sign_off_report_[dpid]_etl[#].xlsx.
  • Using the previous ETL’s all_l1_l2_flags output dataset, the report calculates difference between flag counts in ETL under review and ETL-1.

Improved Cross Table Checks

  • Refactored the creation of datasets Used in L2 cross table ID variable checks
  • The following NOTE flags were previously CheckID 202 and are now CheckID 201:
    • ENR-VIT_2_01_00-0_201: PatID value present in ENR table, but not in the VIT table
    • ENR-IRX_2_01_00-0_201: PatID value present in ENR table, but not in the IRX table
    • ENR-TXN_2_01_00-0_201: PatID value present in ENR table, but not in the TXN table
    • ENR-PRE_2_01_00-0_201: PatID value present in ENR table, but not in the PRE table
    • ENR-PRR_2_01_00-0_201: PatID value present in ENR table, but not in the PRR table
    • ENR-DEM_2_01_00-0_201: PatID value present in ENR table, but not in the DEM table
    • ENR-DIS_2_01_00-0_201: PatID value present in ENR table, but not in the DIS table
    • ENR-ENC_2_01_00-0_201: PatID value present in ENR table, but not in the ENC table
    • ENR-DIA_2_01_00-0_201: PatID value present in ENR table, but not in the DIA table
    • ENR-PRO_2_01_00-0_201: PatID value present in ENR table, but not in the PRO table
    • ENR-DTH_2_01_00-0_201: PatID value present in ENR table, but not in the DTH table
    • ENR-COD_2_01_00-0_201: PatID value present in ENR table, but not in the COD table
    • ENR-LAB_2_01_00-0_201: PatID value present in ENR table, but not in the LAB table
    • FAC-ENC_2_01_00-0_201: FacilityID value present in FAC table, but not in the ENC table
    • FAC-LAB_2_01_00-0_201: FacilityID value present in FAC table, but not in the LAB table
    • PVD-PRE_2_01_00-0_201: ProviderID value present in PVD table, but not in the PRE table
    • PVD-DIS_2_01_00-0_201: ProviderID value present in PVD table, but not in the DIS table
    • PVD-DIA_2_01_00-0_201: ProviderID value present in PVD table, but not in the DIA table
    • PVD-PRO_2_01_00-0_201: ProviderID value present in PVD table, but not in the PRO table
    • PRS-PRR_2_01_00-0_201: PRM_Code value present in PRS table, but not in the PRR table
    • PRS-PRR_2_02_00-0_201: SurveyID value present in PRS table, but not in the PRR table
    • PRS-PRR_2_03_00-0_201: QuestionID value present in PRS table, but not in the PRR table
    • PRS-PRR_2_04_00-0_201: QuestionVerID value present in PRS table, but not in the PRR table
    • ENC-VIT_2_02_00-0_201: EncounterID value present in ENC table, but not in the VIT table
    • ENC-IRX_2_02_00-0_201: EncounterID value present in ENC table, but not in the IRX table
    • ENC-TXN_2_02_00-0_201: EncounterID value present in ENC table, but not in the TXN table
    • ENC-PRE_2_02_00-0_201: EncounterID value present in ENC table, but not in the PRE table
    • ENC-PRR_2_02_00-0_201: EncounterID value present in ENC table, but not in the PRR table
    • ENC-DIA_2_02_00-0_201: EncounterID value present in ENC table, but not in the DIA table
    • ENC-PRO_2_02_00-0_201: EncounterID value present in ENC table, but not in the PRO table
    • DTH-COD_2_01_00-0_201: PatID value present in DTH table, but not in the COD table

Improved ICD-10 Era Check Handling

Minor Package Updates

  • Removed ETL Number Verification Check
  • Removed Logic for CheckID 204
8.6.3 07/20/2023

Ensured Proper Evaluatation of Special Missing Values for ID Variables

  • Fixed a bug where CheckID 201 was not correctly checking that special missing values for ID variables were present in the Facility and Provider Tables when found in other tables. The following flags will now properly evaluate:
    • PRE-PVD_2_04_00-0_201: ProviderID value present in PRE table, but not in the PVD table
    • DIS-PVD_2_07_00-0_201: ProviderID value present in DIS table, but not in the PVD table
    • DIA-PVD_2_04_00-0_201: ProviderID value present in DIA table, but not in the PVD table
    • PRO-PVD_2_04_00-0_201: ProviderID value present in PRO table, but not in the PVD table
    • ENC-FAC_2_06_00-0_201: FacilityID value present in ENC table, but not in the FAC table
    • LAB-FAC_2_33_00-0_201: FacilityID value present in LAB table, but not in the FAC table
  • These flags are FAIL level flags and will cause the QA Package to abort if triggered.

Ensured Proper Evaluation of Flags Assessing PRS and PRR Tables

  • Fixed a bug preventing checks designed to evaluate whether QuestionID, QuestionVerID, PRM_Code, and SurveyID where present in the PRR table if they exist in the PRS table. The following FlagIDs have been retired:
    • PRS-PRR_2_01_00-0_202: PRM_Code value present in PRR table, but not in the PRS table
    • PRS-PRR_2_02_00-0_202: SurveyID value present in PRR table, but not in the PRS table
    • PRS-PRR_2_03_00-0_202: QuestionID value present in PRR table, but not in the PRS table
    • PRS-PRR_2_04_00-0_202: QuestionVerID value present in PRR table, but not in the PRS table
  • These were duplicates of an existing CheckID 201. These have now been replaced with the following:
    • PRS-PRR_2_01_00-0_201: PRM_Code value present in PRS table, but not in the PRR table
    • PRS-PRR_2_02_00-0_201: SurveyID value present in PRS table, but not in the PRR table
    • PRS-PRR_2_03_00-0_201: QuestionID value present in PRS table, but not in the PRR table
    • PRS-PRR_2_04_00-0_201: QuestionVerID value present in PRS table, but not in the PRR table
  • These new flags are NOTE level flags
8.6.0 02/23/2023

Refactored the Level 1 Module to improve package runtime by reducing the number of times the QA Package Level 1 Module reads Data Partner SCDM tables.

Introduced new FlagType NOTE:

  • In intances where an SCDM variable is optional and not populated, CheckID 111 will now write flag NOTE intead of WARN
  • msoc/all_l1_l2_flags sort order logic is modified to push NOTE flags to bottom of dataset

Mother-Infant Identification Updates:

  • Removed requirement for Data Partner to have at least one year of data available before package begins identifying infants
  • Relaxed infant enrollment criteria to at least 1 day in the first three years of life
  • Relaxed mother enrollment requirements from 180 days of prior enrollment to 90

Minor Package Modifications and Bug Fixes

8.5.2 12/15/2022

Resolves an issue which caused the package to exclude Mothers and Infants whose RACE = “M” from the results.

8.5.1 12/01/2022

CheckID 223 and 228 Modifications

This release adds or modifies the following flags:

  • PRE_2_07_00-0_223: In the Prescribing table, when Rx_CodeType = ND, Rx must be all digits.
  • DIS_2_03_00-0_223: In the Dispensing table, when Rx_CodeType = ND, Rx must be all digits.
  • DIS_2_03_00-0_228: In the Dispensing table, when Rx_CodeType = ND an Rx code length of ≥ 9 and ≤ 11 is now enforced.

Minor Package Modifications and Bug Fixes

  • Updated the MIR module to prevent the package from aborting when BIRTHTYPE = 6.
8.5.0 09/22/2022

CheckID 223 and 228 Modifications

This release adds or modifies the following flags:

  • PRE_2_07_00-0_228: In the Prescribing table, when Rx_CodeType = GP an Rx code length of 14 is now enforced. This flag is a warn.
  • DIA_2_06_00-0_223: In the Diagnosis table, when Dx_CodeType = 09 or Dx_CodeType = 10, a warn flag is thrown if Dx contains a decimal. This flag is a warn.
  • PRO_2_06_00-0_223: In the Procedure table, when Px_CodeType = 09 or Px_CodeType = 10, a warn flag is thrown if Px contains a decimal. This flag is a warn.

DIA_2_06_00-0_228 and PRO_2_06_00-0_228 have been modified to enforce the following new valid lengths:

  • Px_CodeType = 09, Px length ≥ 3 and ≤ 4
  • Dx_CodeType = 09, Dx length ≥ 3 and ≤ 5
  • Dx_CodeType = 10, Dx length ≥ 3 and ≤ 7

CheckID 111 Modifications

Previously, the QA Package would issue a FAIL if the Data Partner did not have at least one observation for in any of the following variables:

  • RxSup and RxAmt in the Dispensing Table
  • Result_Loc in the Lab Results Table
  • EncType and Orig_TransProd in the Inpatient Transfusion Table

As these variables are considered optional by the Sentinel Common Data Model (SCDM), these flags have been downgraded to WARN.

CheckID 121 Modifications

The following values are considered valid by the SCDM, but were missing from the QA Package:

  • In the Lab Results Table, Px_CodeType now accepts the following valid values:

    • CP = Canadian Classification of Diagnostic, Therapeutic, and Surgical Procedures (CCP)
    • CX = Canadian Classification of Health Interventions (CCI)
    • OT = Other

  • In the Prescribing table, Rx_CodeType now accepts the following valid value:

    • AT= Anatomical Therapeutic Chemical Classification (DK)

The following values do not appear in the SCDM and have been removed as valid values from the QA Package:

  • In the Diagnosis table, Dx_CodeType no longer accepts the value C0
  • In the Lab Results Table, Px_CodeType no longer accepts the value CV

Lab Results Table LOINC Value Updates

In response to the August 2.73 LOINC release, the QA Package has been modified

Additional Bug Fixes

This release fixes an issue where the table names for the PRM and PRS tables were not being written to qa_cc_metadata. This would cause Common Components to fail at Data Partners populating those tables.

8.4.1 06/08/2022 New features / enhancements:
  • Minor Input file updates to allow numeric lab values associated with COVID Antibody MS_Test_Names
  • The package will no longer fail and abort on LAB_1_22_00-0_111 (MS_Result_N has no values) when run by Data Partners populating only COVID Labs with character based results
8.4.0 06/02/2022 New features / enhancements:
  • SCDM 8.1.0 Compliance Updates:
    • The QA Package now allows the value M for multi-racial in the Demographic Table’s Race variable
    • Adds new valid MS_Test_Names: SARS_COV_2_AB_TOTAL, SARS_COV_2_AB_A, SARS_COV_2_AB_G, SARS_COV_2_AB_M, SARS_COV_2_AB_AM, SARS_COV_2_AB_GM, SARS_COV_2_AB_NS, UNMAPPED
    • Introduces a new lookup file lkp_lab_loincs.sas7bdat, mapping SOC Approved LOINCS to their corresponding MS_Test_Name
    • Introduces a new set of CheckID 222 Flags: LAB_2_07_[TestID]_222 which warn if MS_Test_Name does not correspond with the appropriate SOC Approved LOINC value
    • Introduces a new set of CheckID 222 Flags: LAB_2_[VarID]_99-U_222 which fail and cause the QA Package to abort in instances where MS_Test_Name is set to UNMAPPED and the following variables do not contain the appropriate value corresponding with Unknown: Modifier, Specimen Source, Fast Ind, Stat, Pt_Loc, Abn_Ind, and Result_Type
    • Flag LAB_2_07_99-U_220 will cause the QA Package to abort if MS_Test_Name is set to UNMAPPED but LOINC is not populated
    • Introduces a new set of CheckID 111 Flags: PRE_1_[VarID]_00-0_111 which cause cause the QA Package to abort if the following variables are not populated in the Prescribing Table: RxSup, RxAmt, RxDoseQuantity, RxFreqQuantity
    • The QA Package will return three new Level 3 tables for characterizing Unmapped LOINCS:
      • lab_l3_unmap_loinc_all: This dataset contains 1-way frequencies for all LOINCS where MS_Test_Name is UNMAPPED
      • lab_l3_n_unmap_loinc_agegrp_sex: This dataset contains frequencies of the top 5000 LOINCS where MS_Test_Name is UNMAPPED, stratified by agegroup and sex
      • lab_l3_n_unmap_loinc_ym: This dataset contains frequencies of the top 5000 LOINCS where MS_Test_Name is UNMAPPED, stratified by year-month
    • SCDM 8.1.0 introduces new key variable combinations for several tables. The new unique row definitions enforced by the package are:
      • Encounter: EncounterID
      • Diagnosis: EncounterID, DX_CodeType, DX, ProviderID
      • Procedure: EncounterID, PX_CodeType, PX, ProviderID
      • Lab Result: LabID
      • Inpatient Pharmacy: RxID
      • Inpatient Transfusion: TransID
      • Prescribing: PrescribingID
8.3.5 03/10/2022 New features/enhancement:
  • Modifies Check 223 to allow alphabetic character M or U as the fifth character in a PRO code when Px_CodeType is C4
  • Addition of valid value SK for px_codetype in LAB and PRO tables.
8.3.4 01/27/2022 New features/enhancement:
  • Modifies Check 223 to allow alphabetic character A as the fifth character in a PRO code when Px_CodeType is C4.
8.3.0 12/16/2021 New features/enhancement:
  • Adds a new dataset dis_l2_rx_rxtype_spec with combinations of Rx, RxType, and Provider Specialty.
  • • Modifies Check 223 to prevent erroneous warns for PRO Table Code Types C2 and C3 based on presence of alphabetic characters F and T, respectively, as the fifth character in a code
  • Adds logic which will abort the package if the ETL number specified in the SCDM Tables Labels does not align with the expected ETL number
8.2.0 11/18/2021 New features/enhancement:
  • Implement ability to QA Rapid COVID Freshest Feasible SDD
  • New QA Package Dataset enc_l2_byvar_dates returns distribution of ENC adate stratified by EncType.
  • CheckID 116 updated from warn to an abort.
  • Minor Package updates
8.1.1 11/10/2021 Minor Package Updates
8.1.0 10/21/2021 New features/enhancement:
  • Addition of .U as an valid value for unknown / missing values in certain Prescribing Table variables
  • New QA Package Dataset vit_l3_pt_ym_stat returning statistics from VIT tables
  • New QA Package Dataset re_l2_rx_rxtype_spec stratifying PRE records by rx, rx_codetype, and Provider Specialty
  • New CheckID 116 which checks FORMATL from PROC CONTENTS results to ensure the formatted value of any ID will not cause downstream issues
8.0.0 09/23/2021 New features/enhancement:
  • Add L2 checks for valid variable combinations of EncType, DDate, Discharge_Disposition, Discharge_Status in Encounter table
  • Add L2 checks to validate new PX_CodeType CV
7.3.0 08/14/2021 New features/enhancement:
  • New table outputting age in days as of earliest enrollment start for infants.
  • Minor package improvements and updates
7.2.1 A minor update to the lab look-up files fixing issue where new COVID Lab LOINCs provided to Data Partners had been omitted.
7.2.0 07/29/2021 New features/enhancement:
  • Addition of CheckIDs 236 and 237: These checks ensure that DTH records have one and only one underlying cause of death.
  • Minor package Updates and improvements
7.1.0 07/01/2021 New features/enhancement:
  • Addition of dia_l2_dx_dxtype_spec, which replaces dia_l2_dx_dxtype. This dataset adds provider specialty (spec) to strata.
  • Addition of pro_l2_px_pxtype_spec which replaces pro_l2_px_pxtype. This dataset adds provider specialty (spec) to strata.
  • Addition of Check 208, which will replace 114 and confirms length of numeric variable is not longer than is needed after confirming this length is the same across SCDM tables
7.0.3 02/27/2021 • Minor package changes for input files only for inpatient tables to enable use of internal dataset
7.0.2 01/29/2021 • Minor maintenance version to address Prescribing table Check ID 120; no longer aborts package.
7.0.1 01/22/2021 • Minor maintenance version to address Prescribing table Check ID 111; no longer aborts package.
7.0.0 04/01/2020 • L1/L2/L3 flags for SCDM v8.0.0 model compliance in existing tables
• Update select L1/L2/L3 flags for SCDM v8.0.0 model compliance in existing tables
• Add compliance checks and new modules for addition of Prescribing, Provider, and Facility tables to the model.
• Temporary removal of the SCDM Snapshot program functionality until the stand-alone version is updated to be SCDM v8.0.0 compliant.
6.2.0 02/14/2020 • Update SCDM Snapshot functionality
* Include SCDMVer variable/ value in qa_cc_metadata output file for future use in qa_common_components
• Replicate all L2/L3 datasets that contain variable DIS.NDC, breaking creating variable
• Rx_Codetype, populated as ND, and renaming NDC to Rx.
• Incorporate new SAS Option (Option=FMTERR) into the master program file.
6.1.0 12/05/2019 • Add SCDM Snapshot program functionality
• Minor bug fix for LAB CheckID 200
• Change input file control_flow from a SAS dataset (.sas7bdat) to a .csv file for internal request building automation
6.0.0 09/16/2019 • Add inpatient transfusion and inpatient dispensing model compliance checks and distribution statistics
5.0.1 05/15/2019 • Minor bug fix for hardcoded dates in the MI ID program
5.0.0 01/31/2019 • Updated to no longer use CC
• Added metadata output table for use with post-QA CC
• Integrated optional execution of MI ID package
4.2.1 08/28/2018 • Addition of warning flag 121 for negative values in vital signs variables HT, WT, Systolic, and Diastolic
4.2.0 08/10/2018 • Add vital signs module and model compliance checks
4.1.5 07/03/2018 • Minor bug fix in dia_l2_dx_dxtype (introduced in 4.1.4)
4.1.4 05/24/2018 • Bugfix for CheckID 223
• Added missing CheckID 223 for PRO in lkp_all_flags
• Updated temporary dataset name in DIA for CheckID 223
4.1.3 05/10/2018 • Minor bug fixes:
• Corrected missing LAB CheckIDs (223, 23X, 243) from msoc. all_l1_l2_flags
• Corrected record counts in msoc.pro_l3_enctype_pxtype_ym
• Removed lowercase function of DP- specific path in LogChecker module
4.1.1 03/08/2018 • Added missing valid value for PRO.px_codetype in lookup table lkp_all_l1
4.1.0 02/22/2018 • Minor bug fixes
• Optimization of L1 module
4.0.2 11/14/2017 • Minor bug fix
4.0.1 09/2/2017 • Minor bug fixes
4.0.0 04/27/2017 • Major updates
3.3.4 2/16/2017 • Added/modified diagnosis datasets
3.3.3 8/17/2016 • Added/modified core and lab datasets
3.3.2 9/30/2015 • Corrected error in PatID exclusion in Labs Module
3.3.1 9/17/2015 • Corrected error in DEM module
3.3.0 5/1/2015 • Redesign of labs module, addition of core checks
3.2.4 9/23/2014 • Updated program for new RequestID compatibility, fixed bug
3.2.3 9/2/2014 • Implemented minor bug fixes
3.2.2 8/26/2014 • Implemented minor bug fixes
3.2.1 7/25/2014 • Implemented minor bug fixes

Table 3.2 shows the version of the Sentinel Common Data Model for which a given version of the QA Package is compatible.3

Table 3.2: QA Package-SCDM Version Compatibility Chart
QA Package Version SCDM Version Release Date
9.1.0 8.2.1, 8.2.0 & 8.1.0 Feb 2025
9.0.2 8.2.1, 8.2.0 & 8.1.0 Dec 2024
9.0.1 8.2.0 & 8.1.0 Jul 2024
9.0.0 8.2.0 & 8.1.0 Jun 2024
8.9.0 8.2.0 & 8.1.0 Apr 2024
8.8.0 8.2.0 & 8.1.0 Dec 2023
8.7.1 8.1.0 Oct 2023
8.7.0 8.1.0 Aug 2023
8.6.3 8.1.0 Jul 2023
8.6.0 8.1.0 Feb 2023
8.5.0 8.1.0 Nov 2022
8.4.2 8.1.0 Jun 2022
8.4.1 8.1.0 Jun 2022
8.4.0 8.1.0 Jun 2022
8.3.5 8.0.0 Mar 2022
8.3.4 8.0.0 Jan 2022
8.3.0 8.0.0 Dec 2021
8.2.0 8.0.0 Nov 2021
8.1.1 8.0.0 Nov 2021
8.1.0 8.0.0 Oct 2021
8.0.0 8.0.0 Sep 2021
7.3.0 8.0.0 Aug 2021
7.2.1 8.0.0 Aug 2021
7.2.0 8.0.0 Jul 2021
7.1.0 8.0.0 Jul 2021
7.0.3 8.0.0 Feb 2021
7.0.2 8.0.0 Jan 2021
7.0.1 8.0.0 Jan 2021
7.0.0 8.0.0 Dec 2020

  1. Please Note: The QA Program Package 8.4.x series and greater is backwards compatible with the SCDM 8.0.0 only for Data Partners building the Rapid COVID Distributed Database.↩︎