CalMHSA Client Meds By Program Report

Report Description
Report Description This report is designed to display client medications ordered from the Rx module in SmartCare. The design and layout is based on the existing SmartCare product report – Client Medications by Program however this report – CalMHSA Client Meds By Program Report will allow a user to select multiple programs in the Program parameter.
Report NameMenu PathClient BasedReport RDL Name
Report Name CalMHSA Client Meds By Program ReportMenu Path Reports/ CalMHSA Client Meds By Program ReportClient Based NReport RDL Name Client Medications by Program.rdl
ParametersData TypeHiddenComments
Parameters ExecutedByStaffIdData Type IntegerHidden YComments Passed by system at report run time based on currently logged in CDAG
Parameters Executed By StaffIdData Type IntegerHidden YComments Passed by system at report run time based on currently logged in staff person
Parameters ProgramData Type IntegerHidden NComments Program multiple select based on logged in user CDAG and staff programs
Parameters DateData Type DateHidden NComments Default to current date
DataSetsForm(s)CDAG EnforcedComments
DataSets DataSet1Form(s) MedicationsCDAG Enforced YComments This query will display any medications where the medication has not been discontinued. It will retrieve the client id, medication id, client name, medication name, any instructions, the medication start and end dates, script order and created dates, and the user who entered and prescribed the medication.
DataSets GetCountyLogoForm(s) N/ACDAG Enforced N/AComments County logo image for display on page header
DataSets ProgramForm(s) Staff/UserCDAG Enforced YComments Used to populate the Program parameter with active programs that the user has access to in Staff profile
Default User Roles
Default User Roles Administrator - Non-Clinical Billing Billing Supervisor CalMHSA SysAdmin County Affiliate SysAdmin Medical Records/Quality Assurance Reception/Front Desk UM