Framework

Methodology & Measure Dictionary

Each program is mapped with a logic model that links resources to activities, outputs, outcomes, and long-term impact. Every dashboard measure traces to a step in that chain.

Logic model — Harm Reduction (illustrative)

Comparable models are developed per program; Theory of Change or LogFrame is used where a program's design fits better.

Inputs

• Federal & county funding
• Clinical and outreach staff
• Partner network
• Case management + EHR systems

Activities

• Screening & assessment
• Counseling and treatment
• Outreach and navigation
• Referral coordination

Outputs

• Clients served
• Encounters delivered
• Referrals completed
• Kits & benefits distributed

Outcomes

• Treatment completion
• Health status improvement
• Housing & stability gains
• Reduced readmission

Impact

• Lower overdose mortality
• Improved population health equity
• Stronger community resilience

Measure selection

Measures are co-designed with program managers in discovery workshops, screened for data availability, and mapped to at least one funder or accreditation requirement.

Target setting

Targets come from state benchmarks, federal grant commitments, or a trailing 24-month baseline where no external benchmark exists.

Validation

Each measure is reconciled against the source system during UAT, then re-validated quarterly through the measure review cadence.

Measure dictionary (44 measures)

Definitions, numerators, denominators, source, frequency, and accountable owner. This demo carries 44 illustrative measures; the delivered system is sized for the anticipated 60–70 measures across all HHS programs.

Measure	Program	Category	Numerator	Denominator	Frequency	Source
Clients served Unduplicated clients receiving at least one behavioral health service in the period.	Behavioral Health	Output	Distinct client IDs with ≥1 BH encounter	n/a	Monthly	Case Management (SQL Server)
Crisis encounters Total crisis-flagged encounters delivered in the period.	Behavioral Health	Output	Encounters with crisis service code	n/a	Monthly	EHR (OData feed)
Treatment completion rate Share of clients with a treatment plan who met completion criteria.	Behavioral Health	Outcome	Clients meeting completion criteria	Clients with a closed treatment plan	Quarterly	Case Management (SQL Server)
Improvement in behavioral health status Clients with a ≥5 point improvement between intake and follow-up assessment.	Behavioral Health	Outcome	Clients with improved assessment score	Clients with two valid assessments	Monthly	EHR (OData feed)
Average days to first appointment Mean calendar days from referral receipt to first kept appointment.	Behavioral Health	Efficiency	Sum of days referral → first kept visit	Referrals resulting in a kept visit	Monthly	Scheduling extract (Azure Data Factory)
30-day readmission rate Clients readmitted to crisis services within 30 days of discharge.	Behavioral Health	Quality	Readmissions within 30 days	Discharges in period	Quarterly	EHR (OData feed)
Client satisfaction Share of surveyed clients rating services 4 or 5 out of 5.	Behavioral Health	Quality	Surveys rated 4–5	Surveys returned	Monthly	Survey (SharePoint list)
Access disparity index Largest percentage-point gap in service access rate between demographic groups.	Behavioral Health	Equity	Max group access rate − min group access rate	n/a	Monthly	Warehouse (SQL Server)
Inspections completed Total permitted facility inspections completed in the period.	Environmental Health	Output	Completed inspection records	n/a	Monthly	Inspections DB (SQL Server)
Facilities inspected on schedule Share of facilities inspected within the required frequency window.	Environmental Health	Quality	Facilities inspected within window	Facilities due for inspection	Monthly	Inspections DB (SQL Server)
Average complaint response time Mean days from complaint intake to first field response.	Environmental Health	Efficiency	Sum of response days	Complaints received	Quarterly	Complaint intake (SharePoint list)
Critical violations corrected Critical violations corrected on site or at re-inspection.	Environmental Health	Outcome	Violations corrected	Critical violations cited	Monthly	Inspections DB (SQL Server)
Rural vs urban inspection coverage gap Coverage-rate gap between rural and urban census tracts.	Environmental Health	Equity	Urban coverage − rural coverage	n/a	Monthly	Warehouse (SQL Server)
Clinic visits Total completed clinic visits across all clinical service lines.	Clinical Services	Output	Completed visit records	n/a	Monthly	EHR (OData feed)
Childhood immunization completion Children 24–35 months completing the recommended series.	Clinical Services	Outcome	Children up to date	Children in the age cohort	Monthly	NCIR extract (Azure Data Factory)
Referrals completed Referrals with confirmed receiving-provider contact.	Clinical Services	Output	Closed-loop referrals	n/a	Quarterly	Case Management (SQL Server)
Cost per visit Direct program cost divided by completed visits.	Clinical Services	Efficiency	Direct service cost	Completed visits	Monthly	Finance extract (SQL Server)
No-show rate Scheduled appointments not kept and not cancelled in advance.	Clinical Services	Quality	No-show appointments	Scheduled appointments	Monthly	Scheduling extract (Azure Data Factory)
Uninsured access rate Share of visits delivered to uninsured clients.	Clinical Services	Equity	Visits by uninsured clients	Total visits	Quarterly	Warehouse (SQL Server)
CHIP priority actions on track CHIP action steps rated on track by the responsible partner.	CHA / CHIP	Output	Actions rated on track	Total active actions	Monthly	CHIP tracker (SharePoint list)
Partner organizations reporting Partners submitting a quarterly progress update on time.	CHA / CHIP	Quality	Partners reporting on time	Partners with commitments	Monthly	CHIP tracker (SharePoint list)
Community survey responses Valid community health survey responses collected.	CHA / CHIP	Output	Valid responses	n/a	Quarterly	Survey (SharePoint list)
Priority-population survey representation Share of responses from designated priority populations.	CHA / CHIP	Equity	Priority-population responses	Total responses	Monthly	Warehouse (SQL Server)
Participants served Unduplicated participants issued benefits in the period.	WIC	Output	Participants with issued benefits	n/a	Monthly	Crossroads extract (Azure Data Factory)
Caseload retention Participants recertifying at the end of their certification period.	WIC	Outcome	Participants recertified	Participants due for recertification	Monthly	Crossroads extract (Azure Data Factory)
Breastfeeding initiation rate Infants with any breastfeeding recorded at first certification.	WIC	Outcome	Infants with breastfeeding recorded	Infant certifications	Quarterly	Crossroads extract (Azure Data Factory)
Benefit redemption rate Issued food benefit value actually redeemed by participants.	WIC	Efficiency	Redeemed benefit value	Issued benefit value	Monthly	State issuance file (SFTP → ADF)
Appointment wait time Mean days from request to first available certification appointment.	WIC	Efficiency	Sum of wait days	Appointment requests	Monthly	Scheduling extract (Azure Data Factory)
Language-access service rate Limited-English-proficiency visits served with interpretation support.	WIC	Equity	LEP visits with interpretation	LEP visits	Quarterly	Warehouse (SQL Server)
Naloxone kits distributed Naloxone kits distributed to participants and partners.	Harm Reduction	Output	Kits distributed	n/a	Monthly	Outreach log (SharePoint list)
Participants engaged Unduplicated participants with at least one harm reduction contact.	Harm Reduction	Output	Distinct participants	n/a	Monthly	Case Management (SQL Server)
Overdose reversals reported Community-reported reversals using distributed naloxone.	Harm Reduction	Outcome	Reported reversals	n/a	Quarterly	Outreach log (SharePoint list)
Referral-to-treatment linkage Participants referred who attended a treatment intake within 30 days.	Harm Reduction	Outcome	Referrals attending intake	Treatment referrals made	Monthly	Case Management (SQL Server)
Cost per participant contact Program cost divided by participant contacts.	Harm Reduction	Efficiency	Program cost	Participant contacts	Monthly	Finance extract (SQL Server)
Rural participant reach Share of participants residing in rural census tracts.	Harm Reduction	Equity	Rural-residing participants	Total participants	Quarterly	Warehouse (SQL Server)
Cases investigated Reportable disease cases opened and investigated.	Communicable Disease	Output	Investigated cases	n/a	Monthly	NC EDSS extract (Azure Data Factory)
Cases initiated within 24 hours Cases with first investigative action within 24 hours of report.	Communicable Disease	Efficiency	Cases actioned ≤24h	Cases reported	Monthly	NC EDSS extract (Azure Data Factory)
Contacts successfully reached Named contacts reached and interviewed.	Communicable Disease	Quality	Contacts interviewed	Contacts named	Quarterly	Case Management (SQL Server)
TB treatment completion Active TB clients completing the full treatment regimen.	Communicable Disease	Outcome	Clients completing regimen	Clients starting regimen	Monthly	EHR (OData feed)
STI screening disparity gap Largest screening-rate gap between race/ethnicity groups.	Communicable Disease	Equity	Max group rate − min group rate	n/a	Monthly	Warehouse (SQL Server)
Exercises and drills completed Full-scale, functional, and tabletop exercises conducted.	Preparedness	Output	Exercises completed	n/a	Monthly	Preparedness tracker (SharePoint list)
Staff trained on response roles Assigned response staff completing required role training.	Preparedness	Output	Staff completing training	Staff with response assignments	Monthly	LMS extract (SQL Server)
After-action items closed on time Corrective actions closed by their due date.	Preparedness	Quality	Actions closed on time	Actions due	Quarterly	Preparedness tracker (SharePoint list)
POD activation readiness time Mean days from activation order to operational point of dispensing.	Preparedness	Efficiency	Sum of activation days	Activations and drills	Monthly	Preparedness tracker (SharePoint list)