| 09/06/2023 |
3.12.0 |
EL-1-036-43 |
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 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: Race is Native Hawaiian or Other Pacific IslanderOf the MSIS IDs that meet the criteria from STEP 2, further restrict the population by keeping MSIS IDs where:1. RACE = “012,” "013," "014," "015," or "016" on any record segment Step 4 : MSIS IDs where ethnicity is missing, unspecified, or invalidOf the MSIS IDs that meet the criteria from STEP 3, further refine the population by keeping MSIS IDs where:1a. ETHNICITY-CODE is not “0,” “1,” “2,” “3,” “4,” or “5”OR1b. ETHNICITY-CODE is missingSTEP 5: Calculate percentage Divide the count of unique MSIS IDs from STEP 4 by the count of unique MSIS IDs from STEP 3 |
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 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: Race is Native Hawaiian or Other Pacific IslanderOf the MSIS IDs that meet the criteria from STEP 2, further restrict the population by keeping MSIS IDs where:1. RACE = “012,” "013," "014," "015," or "016" on any record segmentSTEP 4: Ethnicity information on the last day of DQ report monthUsing the MSIS IDs that meet the criteria from STEP 3, join to segment ETHNICITY-INFORMATION-ELG00015 by keeping active records that satisfy the following criteria:1a. ETHNICITY-DECLARATION-EFF-DATE <= last day of the DQ report month2a. ETHNICITY-DECLARATION-END-DATE >= last day of the DQ report month OR missingOR1b. ETHNICITY-DECLARATION-EFF-DATE is missing2b. ETHNICITY-DECLARATION-END-DATE is missingSTEP 5 : MSIS IDs where ethnicity is missing, unspecified, or invalidOf the MSIS IDs that meet the criteria from STEP 4, further refine the population by keeping MSIS IDs where:1a. ETHNICITY-CODE is not “0,” “1,” “2,” “3,” “4,” or “5”OR1b. ETHNICITY-CODE is missingSTEP 6: Calculate percentage Divide the count of unique MSIS IDs from STEP 5 by the count of unique MSIS IDs from STEP 3 |
An official website of the United States government
