Health care data solutions.
by Charadata
The Initiation and Engagement of Substance Use Disorder Treatment (IET) measure is used to evaluate the effectiveness of health plans and providers in ensuring timely access to treatment for individuals diagnosed with substance use disorder (SUD). It is commonly used by Medicaid Managed Care Organizations (MCOs) and follows NCQA HEDIS specifications.
Below are shown snippets of working with these sets in Microsoft SQL Server.
The measure consists of two key components:
At a minimum you’ll need a unique ID number, date of birth, date of death (for exclusion purposes), and an enrollment time frame. Age will be calculated later and will be as of the encounter date.
Often, there will be a SQL “gaps and islands” problem with the dates, an extra step to accurately reflect time periods where the insured was continuously enrolled. That’s only if the table splits these periods if the insured changes plans or addresses, but otherwise continues with the same Managed Care Organization. For IET, an encounter only counts if the member was enrolled 194 days prior to and 47 days after the substance abuse disorder episode date.
So, you’ll have something like this to start:
SELECT
a.insured_id
, a.date_of_birth
, a.date_of_death
, b.enrolled_from
, b.enrolled_thru
INTO
#INSURED
FROM
insured_table AS a
-- ugly continuous enrollment part
INNER JOIN
(
SELECT
z.insured_id
, z.enroll_session
, MIN(date_from) AS enrolled_from
, MAX(ISNULL(date_thru, '9999-12-31')) AS enrolled_thru
FROM
(
SELECT
y.*
, SUM(y.enroll_split) OVER (PARTITION BY y.ins_id ORDER BY y.date_from) AS enroll_session
FROM
(
SELECT
x.*
, CASE
WHEN x.ins_row = 1 THEN 0
WHEN x.ins_row != 1 AND x.lag_thru = x.date_from THEN 0
ELSE 1
END AS enroll_split
FROM
(
SELECT
insured_id
, date_from
, date_thru
, (LAG(date_thru, 1) OVER (PARTITION BY insured_id ORDER BY date_from, ISNULL(date_thru, '9999-12-31'))) + 1 AS lag_thru
, ROW_NUMBER() OVER (PARTITION BY insured_id ORDER BY date_from) AS ins_row
FROM
insured_table
) AS x
) AS y
) AS z
GROUP BY
z.insured_id
, z.enroll_session
) AS b
ON a.insured_id = b.insured_id
This will make things easier later. At each step of the specifications – episodes, initiation, and engagement – you’ll notice the same diagnosis groups mentioned.
Add in the two ICD-10 diagnosis codes for counseling and surveillance of alcohol and drug abuse, Z71.41 and Z71.51, and you’ve got all of the diagnosis codes required by this quality metric.
Create a temporary table of these now. This assumes you already have a table arranged with one row per diagnosis per claim. Facility claims can have a lot of diagnoses!
SELECT
claim_id
, diagnosis_date
, CASE
WHEN diagnosis_code IN -- alcohol abuse and dependence set
THEN 'alcohol'
WHEN diagnosis_code IN -- opioid abuse and dependence set
THEN 'opioids'
WHEN diagnosis_code IN -- other drug abuse and dependence
THEN 'other'
ELSE 'surveillance'
END AS cohort
INTO
#DIAGNOSES
FROM
diagnosis_table
WHERE
diagnosis_code IN (
-- bunch of ICD-10 F codes for alcohol abuse and dependence
OR -- bunch of ICD-10 F codes for opioid abuse and dependence
OR -- F codes for other drug abuse and dependence
OR 'Z71.41','Z71.51'
)
Their encounters will be excluded in the next step.
Oh boy, here in the specifications you’ll see a wall of text. New “episodes” will be from November 15 of the previous year to November 14 of the target year.
First, find SUD episodes. Flag inpatient discharges and monthly opioid treatment services because these are treated differently later.
SELECT
c.*
, DATEDIFF(YEAR, i.date_of_birth, c.date_of_service) -
CASE
WHEN DATEADD(YEAR, DATEDIFF(YEAR, i.date_of_birth, c.date_of_service), i.date_of_birth) > c.date_of_service THEN 1
ELSE 0
END AS episode_age -- Calculate age
, d1.cohort
, CASE
WHEN c.revenue_code IN -- ... Inpatient Stay value set
THEN 1
ELSE 0
END AS ep_inpat
, CASE
WHEN c.procedure_code IN -- ... OUD Monthly Office Based Treatment value set
THEN 1
ELSE 0
END AS ep_opioid
INTO
#EPISODES
FROM
claims_table AS c
-- Here is where you exclude not-continuously enrolled patients. And those that died.
INNER JOIN
#INSURED AS i
ON i.insured_id = c.insured_id
AND i.enrolled_from <= DATEADD(DAY, -194, c.date_of_service)
AND i.enrolled_thru >= DATEADD(DAY, 47, c.date_of_service)
AND YEAR(ISNULL(i.date_of_death, '9999-12-31')) != 2025 -- Change to whatever your measure year is.
INNER JOIN
#DIAGNOSES AS d1
ON c.claim_id = d1.claim_id
AND d1.cohort IN ('alcohol','opioids','other')
LEFT JOIN -- Need it again for the counseling and surveillance value set
#DIAGNOSES AS d2
ON c.claim_id = d1.claim_id
AND d1.cohort IN ('surveillance')
WHERE
-- WHERE... one of those many value sets is true. Lots to put here.
-- Also exclude hospice patients!
AND c.insured_id NOT IN (SELECT insured_id FROM #HOSPICE)
Next, remove episodes found above where the insured already has a history of SUD. You’ll have to do something like what’s shown below. Consequently, your claims table will need service dates going back to May 5 of the previous year, May 5 being 194 days prior to the new episode date of November 15.
#EPISODES AS e
...
WHERE NOT EXISTS (
SELECT
c.insured_id
, c.date_of_service
FROM
claims_table AS c
WHERE
-- ... procedure and revenue codes for SUD history
AND DATEDIFF(DAY, c.date_of_service, e.date_of_service) BETWEEN 1 AND 194
AND e.insured_id = c.insured_id)
Lastly, remove SUD medication history. It’s a similar process to the above except it includes pharmacy claims.
Initiation services are best determined in four step and combined afterwards.
Here you are looking for three types of services that occur up to 34 days after the initiation of treatment.
Remember that the denominator for this measure is based on episodes, not on the number of insured with an episode. One member can have multiple episodes, each requiring its own initiation and engagement treatment to be numerator compliant.
Also, there can be only one episode per day.
According to medicaid.gov’s MAC Scorecard, the median rates in 2023 for initiation and engagement were 44.5 percent and 15.5 percent, respectively. Go there to see how your MCO compares.

Contact Charadata for more help with this metric.
tags: Quality Rating System Measures - Initiation and Engagement of Substance Use Disorder Treatment