CalMHSA Services Missing Diagnosis By Program

Report NameMenu PathClient BasedReport RDL Name
Report Name Services Missing Diagnosis By ProgramMenu Path Services Missing Diagnosis By Program (My Office)Client Based Client BasedReport RDL Name RDLCALMHSAServicesMissingDX.rdl
ParametersData TypeHiddenComments
Parameters ExecutedByStaffIdData Type IntegerHidden NComments StaffId at report run time - system variable
Parameters ProgramData Type Multiple SelectHidden NComments Program multiple select that will display programs associated with the current logged in staff
DataSetsForm(s)HiddenComments
DataSets DataSet1Form(s) Services (My Office)Hidden YComments 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
DataSets ProgramForm(s) Staff/UserHidden N/AComments This query is used for reference only
DataSets MyStaffIDForm(s) N/AHidden YComments This query is used to populate the @Programs multiple select parameter based on logged in user’s associated programs from the Staff/Users form
DataSets GetCountyLogoForm(s) N/AHidden N/AComments County logo image for display on page header
Default User Roles
Default User Roles County Affiliate SysAdmin Clinician Supervisor Billing Supervisor Billing Medical Supervisor CalMHSA SysAdmin