| Report Name | Menu Path | Client Based | Report RDL Name |
|---|---|---|---|
| Staff Active Licenses Report | Staff Active Licenses Report (My Office) | No | RDLCALMHSAStaffLicensesReport |
| Parameters | Data Type | Hidden | Comments |
|---|---|---|---|
| Select Staff | Multiple Select | N | Staff Multi Select |
| DataSets | Form(s) | CDAG Enforced | Comments |
|---|---|---|---|
| Data Set 1 | Staff/Users - Licenses/Degrees Tab | N/A | This query will display records Staff Id, Staff name, and all active staff licenses from the Staff/Users – Licenses / Degrees tab. An active license is where the start and end dates are null, start date is on or before the current date and end date is null, start date is on or before the current date and end date is on or after the current date, or start date is null and end date is on or after the current date. |
| GetCountyLogo | N/A | N/A | County logo image for display on page header |
| DataSet2 | Staff/Users | N/A | Used to populate the Staff parameter with active staff records and where non staff records equals=’N’ |
| Default User Roles |
|---|
| County Affiliate SysAdmin Clinician Supervisor Medical Supervisor CalMHSA SysAdmin |
