Official websites use .gov
A
.gov website belongs to an official government
organization in the United States.
Secure .gov websites use HTTPS
A
lock () or https:// means you've safely connected to
the .gov website. Share sensitive information only on official,
secure websites.
No Updates
Measure Name | Ticket to Work (TTW): % of ELIGIBILITY-GROUP = 48 or 49 (TTW Basic or TTW Medical Improvements) with Age 16-64 |
---|---|
File Type | ELG |
Measure ID | EL-3-005-6 |
Measure Type | Non-Claims Percentage |
Content area | ELG |
Validation Type | Inferential |
---|
Measure Priority | Medium |
---|---|
Focus Area | N/A |
Category | Beneficiary eligibility |
Claim Type | N/A |
---|---|
Adjustment Type | N/A |
Crossover Type | N/A |
Minimum | 0.9 |
---|---|
Maximum | 1 |
TA Minimun | 0.9 |
TA Maximum | 1 |
Longitudinal Threshold | N/A |
For TA
(for including in compliance training) |
TA- Inferential |
For TA
(Longitudinal) |
No |
DD Data Element | MSIS-IDENTIFICATION-NUM • ELIGIBILITY-GROUP |
---|---|
DD Data Element Number | ELG082 • ELG087 |
Annotation | Calculate the percentage of Ticket to Work enrollees that are between the ages of 16 and 64 |
---|---|
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: Eligibility determinants on the last day of DQ report month Using the MSIS IDs that meet the criteria from STEP 1, join to segment ELIGIBILITY-DETERMINANTS-ELG00005 by keeping records that satisfy the following criteria: 1. PRIMARY-ELIGIBILITY-GROUP-IND = 1 2a. ELIGIBILITY-DETERMINANT-EFF-DATE <= last day of the DQ report month 3a. ELIGIBILITY-DETERMINANT-END-DATE >= last day of the DQ report month OR missing OR 2b. ELIGIBILITY-DETERMINANT-EFF-DATE is missing 3b. ELIGIBILITY-DETERMINANT-END-DATE is missing STEP 3: Unique TTW enrollees Of the MSIS IDs that meet the criteria from STEP 2, select TTW enrollees: 1. ELIGIBILITY-GROUP = "48" or "49" 2. Remove any duplicates, so each MSIS ID only appears once. STEP 4: Primary demographics on the last day of DQ report month Using the MSIS IDs that meet the criteria from STEP 3, 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 5: Calculate age Of the MSIS IDs that meet the criteria from STEP 4, 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) STEP 6: TTW enrollees aged 16-64 Merge the MSIS IDs from STEP 3 and 5 and only keep the matches and make sure there is still only one observation per MSIS-ID. Then, select TTW enrollees with ages between 16 and 64: Age >= 16 and Age <=64. STEP 7: Calculate percentage for measure DIVIDE the count of MSIS IDs from STEP 6 by the count of MSIS IDs from STEP 3 |