| 11/20/2025 |
4.0.22 |
EL-19-001-1 |
UPDATE |
Specification |
STEP 1: Enrolled any 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 >= first day of the DQ report month OR missing3. MSIS-IDENTIFICATION-NUM is not missingSTEP 2: Enrolled any day of prior DQ report monthDefine the prior 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 prior DQ report month 2. ENROLLMENT-END-DATE >= first day of the prior DQ report month OR missing3. MSIS-IDENTIFICATION-NUM is not missingSTEP 3: Enrolled in prior month but not current monthKeep all MSIS IDs from STEP 2 that are NOT in STEP 1STEP 4: Eligibility determinants any day of prior DQ report monthUsing the MSIS IDs that meet the criteria from STEP 3, join to segment ELIGIBILITY-DETERMINANTS-ELG00005 by keeping records that satisfy the following criteria:1. PRIMARY-ELIGIBILITY-GROUP-IND = 12. ELIGIBILITY-DETERMINANT-EFF-DATE <= last day of the prior DQ report month3. ELIGIBILITY-DETERMINANT-END-DATE >= first day of the prior DQ report month OR missing*Note: If multiple segments meet the criteria for one MSIS ID, keep latest one (sort by max end date, max effective date, min record byte offset)STEP 5: Valid, known eligibility termination reasonOf the MSIS IDs that meet the criteria from STEP 4, further refine the population by keeping records with: 1. ELIGIBILITY-TERMINATION-REASON = (“01”,“02”,“04”, “06”,”07”,“08”,“09”,“10”,“11”,“12”, “13”,“14”,“15”,“16”,“17”, “18”,“19”, “20”, “23”, “24”, “25”, “26”, “27”, “28”, “29”, “30”, or “31”)STEP 6: Missing, invalid, unknown, or other eligibility termination reasonKeep all MSIS IDs from STEP 3 that are NOT in STEP 5STEP 7: Calculate percentageDivide the unique count of MSIS IDs from STEP 6 by the unique count of MSIS IDs from STEP 3 |
N/A |