| 11/20/2025 |
4.0.22 |
EL-6-041-41 |
UPDATE |
Specification |
STEP 1: Enrolled at any time within the past 12 monthsDefine 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 >= 12 months prior to last day of the DQ report month OR missing3. MSIS-IDENTIFICATION-NUM is not missingSTEP 2: Enrollment Type is Medicaid or CHIPUsing the MSIS IDs that meet the criteria from STEP 1, further refine the population by keeping records with: 1. ENROLLMENT-TYPE = "1" or "2"STEP 3: Non-duplicate enrollment spansDuplicate records are dropped if the following three data elements are the same: MSIS-IDENTIFICATION-NUM, ENROLLMENT-EFF-DATE, and ENROLLMENT-END-DATESTEP 4: Sort records chronologically for each MSIS IDFor each MSIS ID identified in STEP 2, sort records chronologically by ENROLLMENT-EFF-DATE and ENROLLMENT-END-DATESTEP 5: Maximum enrollment end date thus farFor each combination of ENROLLMENT-EFF-DATE, and ENROLLMENT-END-DATE for a given MSIS ID, set Max_End_Date_Thus_Far = the maximum value for ENROLLMENT-END-DATE for that combinationSTEP 6: Total record count by MSIS IDFor each MSIS ID identified in STEP 2, set Tot_Rec = Count of unique combinations of ENROLLMENT-EFF-DATE and ENROLLMENT-END-DATESTEP 7: Previous enrollment end dateFor each combination of ENROLLMENT-EFF-DATE, and ENROLLMENT-END-DATE for a given MSIS ID, set Prev_Enrollment_End_Date = the ENROLLMENT-END-DATE value immediately prior to the ENROLLMENT-END-DATE value for that combinationSTEP 8: Enrollment span startFor each combination of ENROLLMENT-EFF-DATE, and ENROLLMENT-END-DATE for a given MSIS ID, set Enrollment_Span_Start = "1" as follows:1a. Tot_Rec = 1 for the MSIS IDOR1b. ENROLLMENT-EFF-DATE is greater than Prev_Enrollment_End_Date ELSESet Enrollment_Span_Start = "0"STEP 9: Total count of noncontiguous enrollment spansFor each MSIS ID that meets the criteria from STEP 2, set Tot_Enrollment_Span = Count of rows where Enrollment_Span_Start = "1"STEP 10: Count of MSIS IDs with three or more enrollment gapsFor each MSIS ID that meets the criteria from STEP 2, further refine the population by keeping records where Tot_Enrollment_Span is greater than 3. Note that since gaps exist between enrollment spans, there must be at least 4 noncontiguous enrollment spans to equal 3 enrollment gaps for a given MSIS ID. STEP 11: Calculate percentage for measureDivide the count of MSIS IDs from STEP 10 by the count of MSIS IDs from STEP 2 |
N/A |