10 About the QA MIL Program Package
This chapter describes QA MIL Package methods and capabilities and provides the information required to get started with running the tool.
10.1 Methods
The methods section of this document has been organized by level, checking type and source table. This division has been made to clearly define the nature of each check being performed on the MIL table.
Records from the source table will be processed to evaluate each QA check described in this section. Each QA check will correspond to a value in a supplemental lookup table that includes a list of all quality check flags. Some flags are assigned as warns when triggered; others as aborts, which will stop the package from processing further. The flag assignment will ultimately determine how remaining processing will be completed if any requirements are not met. Detailed instructions are provided for the Level 3 descriptive counts only, as this logic is more involved than preceding levels.
10.2 Linkage Rate Calculation
The method for calculating the delivery linkage rate in the Sentinel’s Quality Assurance and Data Characterization Tools is shown in Equation (10.1).
Definition 10.1 (Delivery Linkage Rate) The delivery linkage rate \(R\) is defined as:
\[\begin{equation} R=\frac{L}{(L+M)} \tag{10.1} \end{equation}\]
where:
- \(L\) is the number of linked deliveries—e.g., a MPatID-ADate pair with evidence of a live birth delivery linked to 1 or more CPatID; and
- \(M\) is the number of unlinked deliveries—e.g., a MPatID-ADate pair with evidence of a live birth delivery but no associated CPatID.9
10.3 Control Flow Module
In this package, the module execution sequence has been ordered with module stop-gaps as described below.
- All level 1 checks for existence of tables are performed first and, if any tables do not exist, the process will abort.
- All Level 1 checks for variables including existence, data type, and length are performed and, if any major issues are detected—i.e., if MPatID or CPatID does not exist—the process will abort.
- All Level 1 checks for valid values are performed and, if any major issues with the data are detected, the package will abort.
- All Level 2 checks are performed and, if any major issues with the MIL data are detected, the package will abort.
- All level 3 and linkage integrity checks are then performed.