Reports
CalMHSA Report Documentation
Summary – how to create reports using Visual Studio or Report Builder
How to connect to the SmartCare database using SQL Server Management Services
How to use certain functions such as get global codes by id
Commonly used tables
How to upload reports into SmartCare
Summary – how to create list page favorites
How to create widgets
How to use Ad-hoc reporting module in SmartCare
Summary – CalMHSA data analysis future vision
Data warehouse introduction
SmartCare dataw arehouse model
How to use PowerBI to create data dashboards
CalMHSA example – Org hierarchy
Base level SmartCare 6.0 database ERD
SmartCare document functionality tables ERD
SmartCare document functionality tables ERD
SmartCare account receivable tables ERD
Best viewed in as a PDF in Page View mode