9 Sentinel Mother-Infant Linkage Quality Assurance Package

This documentation describes 4.1.1 of the Sentinel Mother-Infant Linkage Quality Assurance Package (QA MIL Package). This program package is used for the (QA) review and characterization of the Sentinel Distributed Database (SDD) Mother-Infant Linkage (MIL) table. Table 9.1 describes the modification history of this package.

Table 9.1: QA MIL Package History of Modifications
Version Date Modification
4.1.1 02/28/2025

Updates to embedded program version.

4.1.0

Improvements to logging code and minor package updates.

4.0.0 06/06/2024

Integrates Common Components and the SCDM Snapshot Program Package as modules in the QA MIL Package

3.4.1 04/03/2024
  • Adds the macro variable FEATABLE to control flow to ensure it carries through to Common Components
  • Minor package updates
3.4.0 02/01/2024

The QA MIL Package now generates the Data Characteristics Sign Off Report

3.3.2 12/15/2023

Minor Package Updates and Bug Fixes

3.3.1 08/31/2023

Bug Fixes

Fixed a bug which was preventing certain flags from being included in the QA MIL Package inputfiles. The following flags are now included in the QA MIL Package inputfiles:

  • MIL_2_01_00-0_218: For linked records, rows are not distinct by key variables MPatID, EncounterID, ADate, CPatID
  • MIL_2_01_00-0_218: For linked records, rows are not distinct by key variables MPatID, CPatID, NA, NA
  • MIL_2_01_00-0_219: For linked records, value of MPatID not consistently populated by row and combinations of key variables MPatID, EncounterID, ADate, NA
  • MIL_2_01_00-0_219: For linked records, value of MPatID not consistently populated by row and combinations of key variables MPatID, EncounterID, EncType, NA
  • MIL_2_01_00-0_219: For linked records, value of MPatID not consistently populated by row and combinations of key variables MPatID, ADate, MBirth_Date, NA
  • MIL_2_01_00-0_219: For linked records, value of MPatID not consistently populated by row and combinations of key variables MPatID, EncounterID, Birth_Type, NA
  • MIL_2_01_00-0_219: For linked records, value of MPatID not consistently populated by row and combinations of key variables MPatID, EncounterID, ADate, MBirth_Date
  • MIL_2_01_00-0_219: For linked records, value of MPatID not consistently populated by row and combinations of key variables MPatID, ADate, EncounterID, NA
  • MIL_2_01_00-0_219: For linked records, value of MPatID not consistently populated by row and combinations of key variables MPatID, ADate, Birth_Type, NA
  • MIL_2_01_00-0_221: MPatID is populated but EncounterID = missing ( . or blank)
  • MIL_2_01_00-0_221: MPatID is populated but Age = missing ( . or blank)
  • MIL_2_01_00-0_221: MPatID is populated but MBirth_Date = missing ( . or blank)
  • MIL_2_04_00-0_221: MBirth_Date is populated but EncType = missing ( . or blank)
  • MIL_2_04_00-0_221: MBirth_Date is populated but Birth_Type = missing ( . or blank)
3.3.0 03/09/2023

Adds a new WARN flag MIL_2_09_00-0_280: “If both variables are populated, the difference between CBirth_Date and ADate must be less than or equal to 180 days.”

3.2.0 01/18/2023
  • The package now outputs a new MSOC dataset which returns the distance between cbirth_date and cenr_start, stratified by birth year.
  • Resolved a bug which could cause the package to crash on FlagID 201, 202, or 203.
  • Minor Package Updates
3.1.0 12/16/2021 Adds additional flags to the QA MIL Package:
  • MIL-INF_2_09_00-0_208—Tables linked on PatID, Cbirth_Date is populated, but Cbirth_Date not equal to CBirth_Date in table INF
  • MIL-INF_2_10_00-0_208—Tables linked on CPatID, Sex is populated, but Sex not equal to Sex in table INF
  • MIL-DEL_2_06_00-0_208—Tables linked on EncounterID, Adate is populated, but Adate not equal to ADate in table DEL
  • MIL-DEL_2_07_00-0_208—Tables linked on EncounterID, Ddate is populated, but Ddate not equal to ddate in table DEL
3.0.1 07/29/2021 Minor Package documentation updates to allow for public release of the QA MIL Package
3.0.0 03/15/2021 Major enhancement to comply with SCDM v8.0.0 requirements; Functionality for MIS table checks removed from code.
2.1.0 02/20/2019 Dataset name changes and updates based on new QA CC package
2.0.0 06/04/2018 Enhancements for Round 2 including the following:
• MIS: Adding a check for names and child’s date of birth
• Level 3 aggregates: Added variable DaysDiff
1.2.0 05/02/2018 In MIL and MIS tables, allows infant sex to be O, in addition to: A, M, F, and U
1.1.0 04/06/2018 Create additional level 3 table restricted to unique deliveries
1.0.0 04/05/2018 Original Version

Table 9.2 shows the version of the Sentinel Common Data Model a given version of the QA MIL Package is compatible with.

Table 9.2: QA MIL Package-SCDM Version Compatibility Chart
QA MIL Package Version SCDM Version Date
4.1.0 8.2.1, 8.2.0, & 8.1.0 February 2025
4.0.0 8.2.1, 8.2.0, & 8.1.0 June 2024
3.4.1 8.2.0 & 8.1.0 April 2024
3.4.0 8.2.0 & 8.1.0 Feb 2024
3.3.2 8.2.0 & 8.1.0 Dec 2023
3.3.1 8.1.0 Aug 2023
3.3.0 8.1.0 Mar 2023
3.2.0 8.1.0 Jan 2023
3.1.2 8.0.0 Feb 2022
3.1.0 8.0.0 Dec 2021
3.0.1 8.0.0 Jul 2021
3.0.0 8.0.0 Dec 2020