Multi-Facility Executive Reports for Adult Family Home Operators

A multi-facility executive report should help an authorized operator compare operational risk, unresolved work, and performance across Adult Family Homes without mixing residents, flattening unlike facilities, or exposing detailed care records unnecessarily. The report must preserve each home's independent facility boundary even when ownership is shared.

This guide covers reporting design, not a universal compliance score or management standard. It was reviewed on August 8, 2026. Operators should validate metrics, facility relationships, privacy, employment use, and regulatory interpretation with qualified guidance.

Keep facility identity explicit

Every metric and drill-down should carry a stable facility ID, licensed name, reporting period, time zone, and data-through time. Do not group records by a typed facility name that may vary.

WAC 388-76-10036 addresses multiple Adult Family Home management and requires each home to have a person responsible for managing the overall delivery of care, with the responsible person designated to one home at a time. Executive reporting should preserve home-level accountability rather than presenting the portfolio as one undifferentiated facility.

The multi-facility AFH management software guide covers navigation and operational boundaries. This article focuses on portfolio reporting.

Define the authorized portfolio

Before generation, resolve which facilities the current user may include. Store:

• Operator or organization
• Authorized facility IDs
• User role and effective access
• Report purpose
• Period
• Included metric set
• Data-through time
• Request and generation identifiers

Never accept a browser-supplied list of facility IDs without server authorization. If access changes during generation, fail safely or produce only the reauthorized scope with an explicit notice.

Use layered reporting

Create three levels:

• Executive overview: counts, trends, priority exceptions
• Facility comparison: normalized metrics and facility context
• Authorized drill-down: resident, caregiver, medication, document, or case details

The overview should not contain resident names. Detailed data appears only after the user selects a facility and the server reauthorizes the request.

Avoid giant dashboards with dozens of equal cards. Use tabs for operations, resident care, medication, staffing, compliance, pharmacy, and data quality.

Build metrics from defined source records

Each metric needs:

• Name and purpose
• Numerator and denominator
• Included and excluded states
• Source modules
• Facility time-zone rule
• Calculation version
• Data freshness requirement
• Owner
• Drill-down query

Examples include unresolved medication exceptions, overdue resident tasks, open incident corrective actions, expiring documents, staff credential gaps, refill risk, appointment follow-up, and access-review status.

Do not calculate from card counts or cached browser data. Use server-authorized source records and retain the calculation version.

Normalize comparisons honestly

Raw counts can mislead when homes differ in resident census, acuity, medication opportunities, staffing model, or reporting period. Provide appropriate denominators, such as:

• Per active resident
• Per scheduled medication opportunity
• Per assigned task
• Per staffed hour when reliably available
• Per active caregiver
• Per completed refill request

Show both numerator and denominator. Do not turn normalized figures into a universal quality ranking.

Small numbers can fluctuate dramatically. Display sample size and suppress or contextualize unstable comparisons.

Separate resident care, operations, and data quality

An apparent performance problem may be a data-quality issue. Use separate sections:

• Care delivery exceptions
• Operational backlog
• Staffing coverage
• Compliance and document tasks
• Medication and pharmacy workflow
• Data completeness and synchronization
• Security and access governance

For example, a high missed-documentation count could reflect an eMAR outage, ungenerated schedules, or genuine unrecorded doses. Route each to the appropriate drill-down.

Preserve local facility accountability

Assign each facility exception to its responsible manager or role. The executive view can monitor status and escalation while the facility owns investigation and resolution.

Show:

• Opened date
• Facility owner
• Priority
• Current state
• External dependency
• Target resolution
• Evidence of closure
• Reopened status

Do not let a central administrator bulk-clear facility alerts without source evidence.

Protect resident and employee privacy

Portfolio reports can reveal information across many homes. Apply least privilege, strong authentication, report-purpose controls, secure delivery, download auditing, and time-bounded administrative access.

WAC 388-76-10315 requires resident records to remain confidential and protected from unauthorized use or alteration. Executive access does not eliminate the need for resident-record boundaries.

Employee metrics also need context and restricted use. Avoid displaying caregiver rankings or protected leave information in the executive overview.

Make the active facility boundary visible

When a user drills down, display the facility name and ID in the page header, filter bar, report title, and export. Changing the facility should clear residents, drafts, attachments, recipients, and cached result rows.

Provide a return-to-portfolio action without preserving hidden filters from the previous home. For users with many facilities, support search by authorized facility name or ID.

Never use a global resident search before the active facility is confirmed.

Show freshness and outages

Every facility tile or table row should display last successful synchronization and data-through time. Mark stale or incomplete data prominently.

If a system or integration outage affects one home, do not compare its incomplete period as normal. Exclude, annotate, or provide a separate data-quality state based on the metric definition.

Report generation should snapshot the source version or data-through point so figures do not change while the user pages through the report.

Use trends without hiding current cases

Show period-over-period trends with the same calculation definition. If the definition changes, start a new series or label the break.

Pair every trend with current actionable cases. A lower portfolio average can hide one facility with an urgent unresolved medication exception.

Useful views include:

• Current open cases
• New during period
• Resolved during period
• Reopened
• Carried forward
• Median age and oldest case

Avoid decorative charts that cannot be reconciled to source rows.

Build medication and pharmacy sections carefully

Medication reporting can include:

• Due or unresolved eMAR exceptions
• PRN follow-up incomplete
• Medication order acceptance pending
• Refill risk and pharmacy turnaround
• Receipt verification pending
• Inventory discrepancies
• Expiration and recall cases

Use scheduled opportunities as denominators where appropriate. Do not compare raw missed-dose counts between homes with different medication volumes.

Each drill-down must reauthorize resident access and preserve order, schedule, administration, supply, and amendment context.

Build staffing and access sections responsibly

Operational measures may include:

• Unfilled shifts
• Required role coverage gaps
• Credential or document deadlines
• Pending access invitations
• Dormant accounts
• Deactivation exceptions
• Emergency access events
• Access reviews overdue

Do not infer staffing compliance from scheduled headcount alone. Resident needs and qualified-role requirements require context.

Keep time-off reasons, performance-review content, and background-check details out of the executive overview.

Produce executive-ready PDF and CSV outputs

The PDF should include:

• Report title and authorized portfolio
• Period and data-through time
• Metric definitions or reference
• Executive priorities
• Facility comparison tables
• Trends with sample size
• Open-case appendix as authorized
• Page numbers and generation identifier

Use a clean, flat, color-independent design. Avoid dark headers, decorative cards, or printing the application shell.

CSV exports support analysis but must follow the same facility and field permissions. Record requester, facilities, filters, generation time, file ID, and downloads.

Support annotations and governance

Allow authorized facility managers to add a dated explanation or corrective-action reference without changing metric values. Executive reviewers can acknowledge, request follow-up, or assign a review.

Preserve every annotation, author, edit, and status transition. Do not let explanations hide the underlying case or alter the source data.

Maintain a metric catalog with owner, version, review date, and change approval. A dashboard number without a definition is not governance evidence.

Test portfolio boundaries and calculations

Use demonstration facilities to test:

1. User authorized for one of several homes.
2. Executive authorized for a selected portfolio.
3. Facility search by name and ID.
4. Drill-down reauthorization.
5. Resident results cleared on facility switch.
6. Different time zones and reporting cutoffs.
7. Stale data excluded or annotated.
8. Metric definition changed mid-series.
9. Small denominator and suppressed comparison.
10. Medication rate reconciled to source opportunities.
11. Facility case reopened after portfolio review.
12. PDF with only authorized details.
13. Direct API request for an unapproved facility.
14. CSV export and download audit.
15. Access revoked during report generation.

Confirm that portfolio totals equal the sum of included facility records under the same definition and snapshot.

Frequently asked questions

Should operators compare raw incident or medication counts?

Raw counts need census, opportunity, acuity, time, and data-quality context. Show transparent denominators and source cases.

Can an executive report include every resident name?

The overview generally does not need resident identities. Restrict detail to authorized drill-downs for a defined purpose.

What happens when one facility's data is stale?

Display the freshness problem and exclude or qualify affected metrics according to the published definition. Do not compare incomplete data as normal.

Can a central administrator clear facility exceptions?

Resolution should come from linked source evidence and accountable ownership. Executive access should not create a blanket clear-all shortcut.

How should metric changes affect trends?

Version every calculation. Label a break or start a new series when definitions are not comparable.

See the portfolio without dissolving facility boundaries

A trustworthy executive report combines authorized portfolio scope, defined metrics, honest denominators, facility accountability, data freshness, protected drill-downs, and reconcilable exports.

Explore AFH Manager to evaluate multi-facility dashboards, facility search, operational metrics, medication and staffing reports, secure drill-downs, PDF exports, and metric governance. Test authorization and reconciliation before production use.