| 11/20/2025 |
4.0.22 |
EL-1-011_1-29 |
UPDATE |
Specification |
STEP 1: 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 2: Race information on the last day of DQ report monthUsing the MSIS IDs that meet the criteria from STEP 1, join to segment RACE-INFORMATION-ELG00016 by keeping active records that satisfy the following criteria:1a. RACE-DECLARATION-EFF-DATE <= last day of the DQ report month2a. RACE-DECLARATION-END-DATE >= last day of the DQ report month OR missingOR1b. RACE-DECLARATION-EFF-DATE is missing2b. RACE-DECLARATION-END-DATE is missingSTEP 3: Valid, specified raceOf the MSIS IDs that meet the criteria from STEP 2, further refine the population by keeping records with: 1. RACE = (“001,” “002,” “003,” “004,” “005,” “006,” “007,” “008,” “009,” “010,” “011,” “012,” “013,” “014,” “015,” “016,” or “018”) STEP 4: More than one valid race valueOf the MSIS IDs that meet the criteria from STEP 3, further refine to distinct MSIS IDs that have more than one specified value for raceSTEP 5: Calculate percentageDivide the unique count of MSIS IDs from STEP 4 by the unique count of MSIS IDs from STEP 2 |
N/A |