| Report Name | Menu Path | Client Based | Report RDL Name |
|---|---|---|---|
| Services Missing Diagnosis By Program | Services Missing Diagnosis By Program (My Office) | Client Based | RDLCALMHSAServicesMissingDX.rdl |
| Parameters | Data Type | Hidden | Comments |
|---|---|---|---|
| ExecutedByStaffId | Integer | N | StaffId at report run time - system variable |
| Program | Multiple Select | N | Program multiple select that will display programs associated with the current logged in staff |
| DataSets | Form(s) | Hidden | Comments |
|---|---|---|---|
| DataSet1 | Services (My Office) | Y | 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 |
| Program | Staff/User | N/A | This query is used for reference only |
| MyStaffID | N/A | Y | This query is used to populate the @Programs multiple select parameter based on logged in user’s associated programs from the Staff/Users form |
| GetCountyLogo | N/A | N/A | County logo image for display on page header |
| Default User Roles |
|---|
| County Affiliate SysAdmin Clinician Supervisor Billing Supervisor Billing Medical Supervisor CalMHSA SysAdmin |
