Report Description | ||||||
This report is designed to provide users a provider’s current 274 MH and SUD child/adult caseload along with the provider’s max amount of clients they are set to accept. | ||||||
Report Name | Menu Path | Client Based | Report RDL Name | |||
CalMHSA 203 – Staff 274 MH/SUD Caseload Report | CalMHSA 203 – Staff 274 MH/SUD Caseload Report (My Office) | No | RDLCALMHSA_203_StaffCaseload274 | |||
Parameters | Data Type | Hidden | Comments | |||
Staff | Muli-Select | N | All County Staff select | |||
DataSets | Form(s) | CDAG enforced | Comments | |||
Dataset1 | User/Staff -> Staff Details | N | This query pulls in the following data from the Staff, CustomStaff, and CustomStaffCaseloadCounts tables. Staff Id, Staff full name, whether the staff is a clinician or not, any degree the staff might have, staff’s email, Staff’s Max Medi-Cal Adult MH, Staff’s Max Medi- Cal Children MH, Staff’s Max Medi-Cal Adults SUD, Staff’s Max Medi-Cal Children SUD, Staff’s Max Medi-Cal Adults Combined, Staff’s Max Medi-Cal Child Combined, Staff’s Max Provider Group Will Accept, Staff’s Adult Caseload, and Staff’s Child Caseload. | |||
GetCountyLogo | N/A | N/A | County logo image for display on page header | |||
GetStaff | User/Staff(Admin) | N | This query is used to populate the ‘Staff’ parameter. The query pulls in all available county staff members records that is set as active and is not a non-staff user(I.E. Client Portal account). | |||
|
|
| Default User Roles | |||
|
|
|
|
![](https://2023.calmhsa.org/wp-content/uploads/2024/07/556.png)