EL-18-001-1

Data Quality Measure

Last updated

No Updates

Key Information

Measure Name	Race values
File Type	ELG
Measure ID	EL-18-001-1
Measure Type	Frequency
Content area	ELG

Validation

Validation Type	Frequency

Measure Priority

Measure Priority	N/A
Focus Area	N/A
Category	N/A

Claim Information

Claim Type	N/A
Adjustment Type	N/A
Crossover Type	N/A

Thresholds

Minimum	N/A
Maximum	N/A
TA Minimun
TA Maximum
Longitudinal Threshold	N/A
For TA (for including in compliance training)	No
For TA (Longitudinal)	No

Data Elements

DD Data Element	RACE
DD Data Element Number	ELG213

Annotation	Count the number of unique MSIS IDs for each valid value for race, invalid values, and the overall total
Specification	STEP 1: Enrolled on the last day of DQ report month Define 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 missing 3. MSIS-IDENTIFICATION-NUM is not missing STEP 2: Race information on the last day of DQ report month Using 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 month 2a. RACE-DECLARATION-END-DATE >= last day of the DQ report month OR missing OR 1b. RACE-DECLARATION-EFF-DATE is missing 2b. RACE-DECLARATION-END-DATE is missing STEP 3: Frequency Count 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 missing 4. Total: RACE = (any missing or non-missing value)

Annotation

Count the number of unique MSIS IDs for each valid value for race, invalid values, and the overall total

Specification

STEP 1: Enrolled on the last day of DQ report month

Define 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 missing

3. MSIS-IDENTIFICATION-NUM is not missing

STEP 2: Race information on the last day of DQ report month

Using 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 month

2a. RACE-DECLARATION-END-DATE >= last day of the DQ report month OR missing

OR

1b. RACE-DECLARATION-EFF-DATE is missing

2b. RACE-DECLARATION-END-DATE is missing

STEP 3: Frequency

Count 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 missing

4. Total: RACE = (any missing or non-missing value)