EL-1-016-17

Data Quality Measure

Last updated

No Updates

Key Information

Measure Name	% of MSIS IDs with age 0
File Type	ELG
Measure ID	EL-1-016-17
Measure Type	Non-Claims Percentage
Content area	ELG

Validation

Validation Type	Longitudinal and inferential

Measure Priority

Measure Priority	Medium
Focus Area	N/A
Category	Beneficiary demographics

Claim Information

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

Thresholds

Minimum	0.02
Maximum	0.08
TA Minimun	0.0001
TA Maximum	0.15
Longitudinal Threshold	0.05
For TA (for including in compliance training)	TA- Inferential
For TA (Longitudinal)	No

Data Elements

DD Data Element	MSIS-IDENTIFICATION-NUM
DD Data Element Number	ELG019

Annotation	Calculate the percentage of individuals with age = 0
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: Primary demographics on the last day of DQ report month Using the MSIS IDs that meet the criteria from STEP 1, join to segment PRIMARY-DEMOGRAPHICS-ELG00002 by keeping records that satisfy the following criteria: 1a. PRIMARY-DEMOGRAPHIC-ELEMENT-EFF-DATE <= last day of the DQ report month 2a. PRIMARY-DEMOGRAPHIC-ELEMENT-END-DATE >= last day of the DQ report month OR missing OR 1b. PRIMARY-DEMOGRAPHIC-ELEMENT-EFF-DATE is missing 2b. PRIMARY-DEMOGRAPHIC-ELEMENT-END-DATE is missing STEP 3: Calculate Age and Keep Age=0 Of the MSIS IDs that meet the criteria from STEP 2, calculate Age: 1a. If DATE-OF-DEATH is non-missing and occurs before the last day of the DQ report month, Age is equal to the years between DATE-OF-DEATH and DATE-OF-BIRTH. 1b. Otherwise, Age is equal to the years between the last day of the DQ report month and DATE-OF-BIRTH. Note: perform calculations to count full years (e.g., 5/1/2015 – 8/1/1950 = 64) 2. Only keep records where Age = 0. STEP 4: Calculate percentage Divide the count of unique MSIS IDs from STEP 3 by the count of unique MSIS IDs from STEP 1

Annotation

Calculate the percentage of individuals with age = 0

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: Primary demographics on the last day of DQ report month

Using the MSIS IDs that meet the criteria from STEP 1, join to segment PRIMARY-DEMOGRAPHICS-ELG00002 by keeping records that satisfy the following criteria:

1a. PRIMARY-DEMOGRAPHIC-ELEMENT-EFF-DATE <= last day of the DQ report month

2a. PRIMARY-DEMOGRAPHIC-ELEMENT-END-DATE >= last day of the DQ report month OR missing

OR

1b. PRIMARY-DEMOGRAPHIC-ELEMENT-EFF-DATE is missing

2b. PRIMARY-DEMOGRAPHIC-ELEMENT-END-DATE is missing

STEP 3: Calculate Age and Keep Age=0

Of the MSIS IDs that meet the criteria from STEP 2, calculate Age:

1a. If DATE-OF-DEATH is non-missing and occurs before the last day of the DQ report month, Age is equal to the years between DATE-OF-DEATH and DATE-OF-BIRTH.

1b. Otherwise, Age is equal to the years between the last day of the DQ report month and DATE-OF-BIRTH.

Note: perform calculations to count full years (e.g., 5/1/2015 – 8/1/1950 = 64)

2. Only keep records where Age = 0.

STEP 4: Calculate percentage

Divide the count of unique MSIS IDs from STEP 3 by the count of unique MSIS IDs from STEP 1