| Report Name | Menu Path | Client Based | Report RDL Name |
|---|---|---|---|
| Report Name Staff Active Licenses Report | Menu Path Staff Active Licenses Report (My Office) | Client Based No | Report RDL Name RDLCALMHSAStaffLicensesReport |
| Parameters | Data Type | Hidden | Comments |
|---|---|---|---|
| Parameters Select Staff | Data Type Multiple Select | Hidden N | Comments Staff Multi Select |
| DataSets | Form(s) | CDAG Enforced | Comments |
|---|---|---|---|
| DataSets Data Set 1 | Form(s) Staff/Users - Licenses/Degrees Tab | CDAG Enforced N/A | Comments 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. |
| DataSets GetCountyLogo | Form(s) N/A | CDAG Enforced N/A | Comments County logo image for display on page header |
| DataSets DataSet2 | Form(s) Staff/Users | CDAG Enforced N/A | Comments 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 |
