A PowerBI-based clinical decision support dashboard for the Edward Hines Jr. VA Hospital that identifies Veterans discharged from inpatient Mental Health wards (2S/2N) who have not completed a required post-discharge follow-up outpatient appointment within 7 days.
The MH PostDischarge Dashboard is a dynamic PowerBI report designed to help Nursing Department leadership at Edward Hines Jr. VA Hospital (Station 578) monitor and act on post-discharge follow-up compliance for Mental Health inpatients.
When a Veteran is discharged from the 2S or 2N inpatient mental health/psychiatry wards, clinical best practice and VA policy require that a post-discharge outpatient mental health appointment be completed within 7 calendar days of discharge. This dashboard identifies Veterans where that follow-up has not occurred, enabling timely intervention by clinical staff.
- Pre-populated, filtered lists of Veterans who:
- Were admitted to the 2S or 2N inpatient mental health/psychiatry wards
- Have been discharged from that ward
- Have NOT completed a post-discharge follow-up outpatient appointment within 7 days
- The dashboard is designed as an exception report: patients appear only when the system has failed to schedule, perform, or complete the required follow-up
| Component | Technology | Environment |
|---|---|---|
| Data Source | MS SQL Server (VA Corporate Data Warehouse) | VhaCdwDwhSql33.vha.med.va.gov |
| Database | D03_VISN12Collab |
VA on-prem network |
| Reporting | PowerBI (Gov Cloud) | V12 Hines VA - Informatics |
| Source Control | Git + GitHub | KCoderVA/578-MH-postDischarge-dashboard |
| IDE | VS Code v1.110.0 | Windows 11 workstation |
\root\
├── .github/ # GitHub config (templates, workflows, Copilot instructions)
├── .vscode/ # VS Code workspace settings & tasks
├── archive/ # Long-term development storage
├── config/ # Project configuration (SQL profiles, PowerBI themes)
├── data/ # Sample/mock data and schema documentation
├── docs/ # Project documentation, architecture records, guides
├── logs/ # Development logs
├── prompts/ # AI prompt templates & Copilot snippets
├── scripts/ # PowerShell, Python, and batch automation scripts
├── src/ # Primary source code (SQL, PowerBI, PowerAutomate)
├── tests/ # Test scripts and test data
├── CHANGELOG.md # Versioned change history
├── CONTRIBUTING.md # Contribution guidelines
├── LICENSE # Apache License 2.0
├── README.md # This file
└── SECURITY.md # Security and PHI/PII policy
- VS Code v1.110.0 or later with the following extensions:
- MS SQL Tools (
ms-mssql.mssql) - PowerShell (
ms-vscode.powershell) - GitHub Copilot (
github.copilot-chat) - Prettier (
esbenp.prettier-vscode)
- MS SQL Tools (
- PowerBI Desktop (Gov Cloud compatible)
- Git and Git LFS installed locally
- VA Network access with appropriate Entra ID credentials
- Access to
VhaCdwDwhSql33.vha.med.va.govSQL Server via Windows Integrated Security
- Clone the repository:
git clone https://github.com/KCoderVA/578-MH-postDischarge-dashboard.git
- Open the workspace file in VS Code:
.vscode/578-MH-postDischarge-dashboard.code-workspace - Install recommended extensions when prompted
- Verify SQL Server connectivity using the
CDW_SQL33connection profile
This project is designed to be replicated at other VA hospitals. When the project reaches v1.0 release, a separate public repository will be created containing:
- Sanitized SQL stored procedure templates
- PowerBI report templates (
.pbitfiles) - Implementation guide with step-by-step deployment instructions
- Configuration documentation for adapting to your facility's data sources
See docs/guides/implementationGuide.md for details.
| Role | Name | Department |
|---|---|---|
| Developer | Kyle J. Coder | Advanced Analytics & Informatics Team |
| Key Stakeholder | Heidi Mercurio, Chief Nurse | Nursing Services |
- No PHI/PII is stored in this repository
- All patient data access is handled at runtime via Microsoft Entra ID authentication
- See SECURITY.md for full security policy
- See CONTRIBUTING.md for contributor security requirements
See CONTRIBUTING.md for guidelines on coding standards, commit conventions, and the pull request process.
This project is licensed under the Apache License 2.0. See LICENSE for the full text.
Copyright 2026 Kyle J. Coder, U.S. Department of Veterans Affairs
Edward Hines Jr. VA Hospital - Advanced Analytics & Informatics Team
Created: 2026-03-04 | Version: v0.1.0