This algorithm produces a comprehensive list of matched cases between the MPOG and MSQC datasets, enabling researchers and analysts to conduct integrated studies on patient outcomes, procedural quality, and institutional performance.

Key Features:

• Precision Matching: Uses multiple criteria and ranks results to ensure accurate pairing of cases.

• Data Integration: Handles complex cross-references between procedural codes and institutional mappings.

• Scalability: Supports large datasets by utilizing temporary tables and SQL set-based operations.

1. Preparation of Temporary Data Tables:

• The procedure creates temporary tables to organize and filter data from the MPOG and MSQC databases.

• These tables include key details about each case, such as:

  • Institution identifiers

  • Dates of surgery

  • Patient demographic information (age, sex, etc.)

  • Surgical and anesthesia procedure codes.

2. Extraction of Relevant Cases:

• MPOG Cases: The procedure extracts cases from MPOG, including anonymized patient data, procedural codes, and institutional information.

• MSQC Cases: Similarly, cases are pulled from the MSQC database with details like surgery dates, patient demographics, and procedure descriptions.

3. Matching Criteria: The algorithm attempts to match cases by comparing the following attributes:

• Date of Service: Both cases must share the same surgery date.

• Institution ID: Cases must originate from the same healthcare institution.

• Demographics: Matching age, sex, and ASA (American Society of Anesthesiologists) physical status classification.

• Procedure Codes: Surgical and anesthesia CPT (Current Procedural Terminology) codes are compared, including cross-references to predicted or alternate codes.

4. Scoring and Ranking Matches:

• Matches are ranked based on the closeness of their attributes. For example:

  • A match in surgical CPT codes scores higher than a match in alternate anesthesia CPT codes.

  • Exact matches in ASA classification or demographics are prioritized.

• The procedure ensures that only the highest-ranked match for each MSQC case is retained, avoiding duplicate matches.

5. Output Matched Cases:

• The final matched cases are saved in a temporary results table.

• The output includes paired MPOG and MSQC case identifiers, providing a crosswalk between the two registries.

6. Cleanup:

• All temporary tables created during the process are deleted to ensure no residual data is left behind.

----------------------------------------------------

Step 1. Retrieve institutions with available MSQC sites.

Step 2. For MSQC sites, retrieve the MSQC data from the MSQC registry including the 

• date of service

• age (+- 1)

• sex

• institution

• ASA Class

• Anesthesia CPT

• Surgical CPT

Step 3. For MSQC sites, retrieve the MPOG data from the MPOG database including including the same data elements in Step 2.

Step 4. Match the case data between MSQC and MPOG using the following data elements and return the case with the closest match.

• instituion ID

• age (+- 1)

• date of service

• sex