10/07/2025 |
4.0.19 |
MCR-13-006_1-18 |
UPDATE |
Specification |
STEP 1: Active non-duplicate paid individual capitation payment financial transactions during report monthDefine the FTX universe for the FTX0002 table by keeping active records that satisfy the following criteria:1. Reporting Period from the filename = DQ report month2. No Duplicates: Duplicates are dropped at the table level, if the following four data elements are the same: ICN-ORIG, ICN-ADJ, PAYMENT-OR-RECOUPMENT-DATE, and ADJUSTMENT-IND.STEP 2: Managed Care Plan Payee ID TypeOf the records that meet the criteria from STEP 1, further restrict them by the following criteria:1. PAYEE-MCR-PLAN-TYPE - "02" or "03"2. PAYEE-ID-TYPE = "02"STEP 3: Non-missing Payee IDOf the records that meet the criteria from STEP 2, further restrict them by the following criteria: 1. PAYEE-ID is not missingSTEP 4: Enrolled on the last day of DQ report monthDefine the eligible population from segment ENROLLMENT-TIME-SPAN-ELG00021 by keeping active records that satisfy the following criteria:1. ENROLLMENT-EFF-DATE <= last day of the DQ report month 2. ENROLLMENT-END-DATE >= last day of the DQ report month OR missing3. MSIS-IDENTIFICATION-NUM is not missingSTEP 5: Managed care enrollment on the last day of DQ report monthOf the MSIS-IDs that meet the criteria from STEP 4, further refine the population using segment MANAGED-CARE-PARTICIPATION-ELG00014 by keeping records that satisfy the following criteria:1a. MANAGED-CARE-PLAN-ENROLLMENT-EFF-DATE <= last day of the DQ report month2a. MANAGED-CARE-PLAN-ENROLLMENT-END-DATE >= last day of the DQ report month OR missingOR1b. MANAGED-CARE-PLAN-ENROLLMENT-EFF-DATE is missing2b. MANAGED-CARE-PLAN-ENROLLMENT-END-DATE is missingSTEP 6: No managed care participation PCCM planOf the records that meet the criteria from STEP 3, further restrict them by attempting to merge them with the data from STEP 5 and keeping those that satisfy the following criteria:1a. PAYEE-ID = MANAGED-CARE-PLAN-ID2a. MSIS-IDENTIFICATION-NUM matches 3a. MANAGED-CARE-PLAN-TYPE does NOT equal "02" or "03" for any records where 1a and 2a are satisfiedORIt is not the case that:1b. PAYEE-ID = MANAGED-CARE-PLAN-ID2b. MSIS-IDENTIFICATION-NUM matches STEP 7: Calculate the percentage for the measureDivide the count of records from STEP 6 by the count of records from STEP 3 |
STEP 1: Active non-duplicate paid individual capitation payment financial transactions during report monthDefine the FTX universe for the FTX0002 table by keeping active records that satisfy the following criteria:1. Reporting Period from the filename = DQ report month2. No Duplicates: Duplicates are dropped at the table level, if the following four data elements are the same: ICN-ORIG, ICN-ADJ, PAYMENT-OR-RECOUPMENT-DATE, and ADJUSTMENT-IND.STEP 2: Managed Care Plan Payee ID TypeOf the records that meet the criteria from STEP 1, further restrict them by the following criteria:1. PAYEE-MCR-PLAN-TYPE = "02" or "03"2. PAYEE-ID-TYPE = "02"or "05" or "06"STEP 3: Non-missing Payee IDOf the records that meet the criteria from STEP 2, further restrict them by the following criteria: 1. PAYEE-ID is not missingSTEP 4: Enrolled on the last day of DQ report monthDefine the eligible population from segment ENROLLMENT-TIME-SPAN-ELG00021 by keeping active records that satisfy the following criteria:1. ENROLLMENT-EFF-DATE <= last day of the DQ report month 2. ENROLLMENT-END-DATE >= last day of the DQ report month OR missing3. MSIS-IDENTIFICATION-NUM is not missingSTEP 5: Managed care enrollment on the last day of DQ report monthOf the MSIS-IDs that meet the criteria from STEP 4, further refine the population using segment MANAGED-CARE-PARTICIPATION-ELG00014 by keeping records that satisfy the following criteria:1a. MANAGED-CARE-PLAN-ENROLLMENT-EFF-DATE <= last day of the DQ report month2a. MANAGED-CARE-PLAN-ENROLLMENT-END-DATE >= last day of the DQ report month OR missingOR1b. MANAGED-CARE-PLAN-ENROLLMENT-EFF-DATE is missing2b. MANAGED-CARE-PLAN-ENROLLMENT-END-DATE is missingSTEP 6: No managed care participation PCCM planOf the records that meet the criteria from STEP 3, further restrict them by attempting to merge them with the data from STEP 5 and keeping those that satisfy the following criteria:1a. PAYEE-ID = MANAGED-CARE-PLAN-ID2a. MSIS-IDENTIFICATION-NUM matches 3a. MANAGED-CARE-PLAN-TYPE does NOT equal "02" or "03" for any records where 1a and 2a are satisfiedORIt is not the case that:1b. PAYEE-ID = MANAGED-CARE-PLAN-ID2b. MSIS-IDENTIFICATION-NUM matches STEP 7: Calculate the percentage for the measureDivide the count of records from STEP 6 by the count of records from STEP 3 |
05/27/2025 |
4.0.9 |
MCR-13-006_1-18 |
UPDATE |
Specification |
STEP 1: Active non-duplicate paid individual capitation payment financial transactions during report monthDefine the FTX universe for the FTX0002 table by keeping active records that satisfy the following criteria:1. Reporting Period from the filename = DQ report month2. No Duplicates: Duplicates are dropped at the table level, if the following four data elements are the same: ICN-ORIG, ICN-ADJ, PAYMENT-OR-RECOUPMENT-DATE, and ADJUSTMENT-IND.STEP 2: Managed Care Plan Payee ID TypeOf the records that meet the criteria from STEP 1, further restrict them by the following criteria:1. MCR-PLAN-TYPE - "02" or "03"2. PAYEE-ID-TYPE = "02"STEP 3: Non-missing Payee IDOf the records that meet the criteria from STEP 2, further restrict them by the following criteria: 1. PAYEE-ID is not missingSTEP 4: Enrolled on the last day of DQ report monthDefine the eligible population from segment ENROLLMENT-TIME-SPAN-ELG00021 by keeping active records that satisfy the following criteria:1. ENROLLMENT-EFF-DATE <= last day of the DQ report month 2. ENROLLMENT-END-DATE >= last day of the DQ report month OR missing3. MSIS-IDENTIFICATION-NUM is not missingSTEP 5: Managed care enrollment on the last day of DQ report monthOf the MSIS-IDs that meet the criteria from STEP 4, further refine the population using segment MANAGED-CARE-PARTICIPATION-ELG00014 by keeping records that satisfy the following criteria:1a. MANAGED-CARE-PLAN-ENROLLMENT-EFF-DATE <= last day of the DQ report month2a. MANAGED-CARE-PLAN-ENROLLMENT-END-DATE >= last day of the DQ report month OR missingOR1b. MANAGED-CARE-PLAN-ENROLLMENT-EFF-DATE is missing2b. MANAGED-CARE-PLAN-ENROLLMENT-END-DATE is missingSTEP 6: No managed care participation PCCM planOf the records that meet the criteria from STEP 3, further restrict them by attempting to merge them with the data from STEP 5 and keeping those that satisfy the following criteria:1a. PAYEE-ID = MANAGED-CARE-PLAN-ID2a. MSIS-IDENTIFICATION-NUM matches 3a. MANAGED-CARE-PLAN-TYPE does NOT equal "02" or "03" for any records where 1a and 2a are satisfiedORIt is not the case that:1b. PAYEE-ID = MANAGED-CARE-PLAN-ID2b. MSIS-IDENTIFICATION-NUM matches STEP 7: Calculate the percentage for the measureDivide the count of records from STEP 6 by the count of records from STEP 3 |
STEP 1: Active non-duplicate paid individual capitation payment financial transactions during report monthDefine the FTX universe for the FTX0002 table by keeping active records that satisfy the following criteria:1. Reporting Period from the filename = DQ report month2. No Duplicates: Duplicates are dropped at the table level, if the following four data elements are the same: ICN-ORIG, ICN-ADJ, PAYMENT-OR-RECOUPMENT-DATE, and ADJUSTMENT-IND.STEP 2: Managed Care Plan Payee ID TypeOf the records that meet the criteria from STEP 1, further restrict them by the following criteria:1. PAYEE-MCR-PLAN-TYPE - "02" or "03"2. PAYEE-ID-TYPE = "02"STEP 3: Non-missing Payee IDOf the records that meet the criteria from STEP 2, further restrict them by the following criteria: 1. PAYEE-ID is not missingSTEP 4: Enrolled on the last day of DQ report monthDefine the eligible population from segment ENROLLMENT-TIME-SPAN-ELG00021 by keeping active records that satisfy the following criteria:1. ENROLLMENT-EFF-DATE <= last day of the DQ report month 2. ENROLLMENT-END-DATE >= last day of the DQ report month OR missing3. MSIS-IDENTIFICATION-NUM is not missingSTEP 5: Managed care enrollment on the last day of DQ report monthOf the MSIS-IDs that meet the criteria from STEP 4, further refine the population using segment MANAGED-CARE-PARTICIPATION-ELG00014 by keeping records that satisfy the following criteria:1a. MANAGED-CARE-PLAN-ENROLLMENT-EFF-DATE <= last day of the DQ report month2a. MANAGED-CARE-PLAN-ENROLLMENT-END-DATE >= last day of the DQ report month OR missingOR1b. MANAGED-CARE-PLAN-ENROLLMENT-EFF-DATE is missing2b. MANAGED-CARE-PLAN-ENROLLMENT-END-DATE is missingSTEP 6: No managed care participation PCCM planOf the records that meet the criteria from STEP 3, further restrict them by attempting to merge them with the data from STEP 5 and keeping those that satisfy the following criteria:1a. PAYEE-ID = MANAGED-CARE-PLAN-ID2a. MSIS-IDENTIFICATION-NUM matches 3a. MANAGED-CARE-PLAN-TYPE does NOT equal "02" or "03" for any records where 1a and 2a are satisfiedORIt is not the case that:1b. PAYEE-ID = MANAGED-CARE-PLAN-ID2b. MSIS-IDENTIFICATION-NUM matches STEP 7: Calculate the percentage for the measureDivide the count of records from STEP 6 by the count of records from STEP 3 |