MENU

Reports

How to Run Reports in SmartCare

  1. Click the Search icon
  2. Type the name of the report in the search bar (see list below).
  3. Click to select the report
  1. A new window will open, enter the parameters for the report. (This will look different depending on the report.)
  2. Click View Report. 
  1. The Report will display. To export the report, click the Save/Export button drop down arrow.
  2. Select Excel or other export option.
  1. To Print, click the Print icon.
  1. To save your report parameters for quick use next time, click the Add Favorite icon.
  2. Enter a Name for your favorite. 
  3. Click Ok
  1. To access the next time you want to run the report, click the Favorite icon and select it. 

Other Reporting Workflows

List of CalMHSA Reports & Description

Report Name Description
CalMHSA Client Meds By Program Report This report is designed to display client medications ordered from the Rx module in SmartCare. The design and layout is based on the existing SmartCare product report – Client Medications by Program however this report – CalMHSA Client Meds By Program Report will allow a user to select multiple programs in the Program parameter.
Staff My Caseload Details Report This report is designed to display caseload information for the currently logged in Staff person who runs it in SmartCare. The design is similar to the My Caseload (My Office) List Page but includes additional columns such as next upcoming appointment information.
Staff QI Time Report This report will show QI Time calendar entries for a staff person that are marked as busy for the user entered date range that includes: Date, Staff Name, Staff Degree (LPHA or above vs. not LPHA), Duration with summaries for each staff.
Staff (Logged In) Service Detail Report This report is designed to display all individual, group, and Staff QI (marked as busy) records where the service status is in Show or Complete status (for individual or group) services for the logged in staff (user). The report will show each service for the selected date range and programs selected from the parameters and include subtotals on travel, documentation, and face to face time as well as overall grand total.
CalMHSA Special Populations Report This report is designed to display all special populations for any clients where the start and end dates of the special population are between the From and Through date parameters entered. The report will NOT display SUD special populations if the staff that is running the report does NOT have a program associated with the Staff Programs where at least one program has a service area of SUD or in other words, the staff running the report must have at least one program with a service area of SUD to see any Special Population records entered from the and Special Populations (SUD) (Client) form
Staff Multiple Service Detail Report This report is a multiple staff selection version of the Staff Service Detail Report that will display individual, group, and Staff QI calendar entries marked as busy for the selected staff, date range, and programs selected by the end user.    IT will summarize the face to face, travel, and documentation time for each staff person and will NOT display charge information.
CalMHSA CSIs Completed Report This report is designed to display the percentage of clients who have had a program enrollment within a user entered date range and program selection for any programs that are defined as Service Area = MH. The percentages will show the amount of enrollment records have a record within the CSI Standalone form Follow Up, Complete, or Missing.
CalMHSA Client Clinical Problems Report This report is designed to display all problems where the start and end dates of the problem are between the From and Through date parameters entered for the selected client and programs by the end user.
CalMHSA Program Charge Errors Report This report is designed to display charge errors based on the following criteria: 1. Services/Charges that did not have a Charge Calculated. If there is no charge, then the system does not see a need to identify a Plan, and therefore there is no Billing Code Assigned. 2. Charges that do not have a Billing Code because either the client has NO Coverage Plans Assigned, they have Coverage Plans assigned but their Effective Date does not align with the Date of Service, or they have Coverage associated with a Service Area that does not align with the Service Area of the Service 3. The Client has Coverage Hx Record that is associated with a Service Area that does not align with the Service Area of the Service 4. the Service Area of the Charge Aligns with the Service Area of the Coverage History record BUT, the Specific Plan that was added under the Service Area was not correct (for example the MH Medi-Cal Plan was added under the DMC Service Area)
CalMHSA Services Missing Diagnosis By Program This query will get all records from the Service Error table where the clientId and programId of the service error does NOT have a diagnosis record from the Diagnosis Document form
CalMHSA Services Diagnosis Errors This query will get all records from the Service Error table where the clientId and programId of the service error has an error. The error categories are: No associated record in document diagnosis form for client and program Diagnosis on file but NOT signed Diagnosis date is current date but service has NOT been processed Diagnosis on file but date of diagnosis is after first date of service Other
CalMHSA Client Face Sheet
CalMHSA Staff Service Detail
Service Report Excel Format This query will get all services for both staff based and non-staff based (inpatient services, if applicable) where the status is in Show or Complete status (71,75) for selected staff date range, and programs. For group services, each client and the amount of time spent in the group appointment will display. The format of the report was designed so that end users can export the data out to Excel.
CalMHSA User Role Report This query will retrieve all active staff records and all use roles assigned to them from the Staff Details screen where the email address of the user does not contain calmhsa, vencill, buchanan, or streamline. The user can choose to display the detail or summary version of the report. The format of the report was designed so that end users can export the data out to Excel.
CalMHSA BHQIP Incoming MCP Referrals Report This report is used to track referrals (inquiries) from MCPs entered in SmartCare. These will always be referrals from the MCP to the MHP. This report includes the MCP who referred the client. This report contains PHI. This report is meant to be exported to excel where you can manipulate the data further for additional quality assurance and performance improvement activities. This report can be used to provide a summary for the BHQIP September submission requirements for item 2b.
CalMHSA BHQIP Screening Tools Report This report is used to track the Adult and Youth Medi-Cal Mental Health Screening tools completed in SmartCare. This report provides information on the results of the screening tools, as well as some other data points counties may be interested in. This report contains PHI. This report is meant to be exported to excel where you can manipulate the data further for additional quality assurance and performance improvement activities. This report can be used to provide a summary for the BHQIP September submission requirements for item 2a.
CalMHSA BHQIP Transition of Care Tool Report This report is used to track the Transition of Care tools completed in SmartCare. These will always be referrals from the MHP to the MCP. This report includes the MCP referred to. This report contains PHI. This report is meant to be exported to excel where you can manipulate the data further for additional quality assurance and performance improvement activities. This report can be used to provide a summary for the BHQIP September submission requirements for item 2b.