| 11/20/2025 |
4.0.22 |
EL-18-001-1 |
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: FrequencyCount the number of unique MSIS IDs from STEP 2 for:1. Each valid value: RACE = (“001,” “002,” “003,” “004,” “005,” “006,” “007,” “008,” “009,” “010,” “011,” “012,” “013,” “014,” “015,” “016,” "017", and “018”) 2. Any valid value: RACE = (“001" or “002" or “003" or “004" or “005" or “006" or “007" or “008" or “009" or “010" or “011" or “012" or “013" or “014” or “015" or “016” "017" or “018”) 3. Invalid value: RACE not equal to (“001" or “002" or “003" or “004" or “005" or “006" or “007" or “008" or “009" or “010" or “011" or “012" or “013" or “014” or “015" or “016” or "017" or “018”) or missing4. Total: RACE = (any missing or non-missing value) |
N/A |