CalMHSA Special Populations Report

Report Description
Report Description This report is designed to display all special populations for any clients where the start and end dates of the special population are between the From and Through date parameters entered. The report will NOT display SUD special populations if the staff that is running the report does NOT have a program associated with the Staff Programs where at least one program has a service area of SUD or in other words, the staff running the report must have at least one program with a service area of SUD to see any Special Population records entered from the and Special Populations (SUD) (Client) form.
Report NameMenu PathClient BasedReport RDL Name
Report Name CalMHSA Special Populations ReportMenu Path CalMHSA Special Populations (My Office)Client Based YReport RDL Name RDLCALMHSASpecialPopulations
ParametersData TypeHiddenComments
Parameters FROMData Type DateHidden N
Parameters THRUData Type DateHidden N
Parameters Special PopulationsData Type IntegerHidden NComments Multiple select parameter that will display all active special populations from the xSpecialPopulations Code Category in Global Codes
Parameters Executed By StaffIdData Type IntegerHidden YComments Passed by system at report run time based on currently logged in Staff
DataSetsForm(s)CDAG EnforcedComments
DataSets DataSet1Form(s) Special Populations (Client) and Special Populations (SUD) (Client)CDAG Enforced YComments This query will retrieve all records from the Special Populations (Client) and Special Populations (SUD) (Client) forms if the start and/or end dates were active during the date range entered by the user and the special population record has not been deleted
DataSets GetCountyLogoForm(s) N/ACDAG Enforced N/AComments County logo image for display on page header
DataSets Global CodesForm(s) YCDAG Enforced Used to populate the Special Populations parameter with active special population global codes
Default User Roles
Default User Roles County Affiliate SysAdmin, LPHA/Clinician, Clinician Supervisor, Inpatient/Residential, Prescriber, Health Maintenance Alert, Medical/RN, Reception and Front Desk, Medical Records/Quality Assurance, Non-LPHA, Billing Supervisor, Billing, Medical Supervisor, CalMHSA SysAdmin, LVN/Minimal Medical, Auditor/Read-Only, Mental Health Clinical Organizational Provider, SUD Organizational Provider, MH Organizational Provider