CalMHSA Service Errors Report

Report NameMenu PathClient BasedReport RDL Name
Report Name CalMHSA Service Errors ReportMenu Path Reports/CalMHSA Service Errors ReportClient Based YesReport RDL Name RDLCALMHSAServiceErrors.rdl
ParametersData TypeHiddenComments
Parameters FROMData Type DateHidden NComments Start date of service
Parameters THRUData Type DateHidden NComments End date of services
Parameters Clinical Data Access GroupIDData 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 CDAG
Parameters ProgramsData Type IntegerHidden NComments Program Multiple select based on logged in user CDAG and staff programs
DataSetsForm(s)CDAG enforcedComments
DataSets DataSet1Form(s) Services (Administration)CDAG enforced YComments This query will display any services where the service date is between the @FROM and @THRU parameters, has a status of Show or Complete (71,75), and has an error in the ServiceErrors table. The dataset will display the serviceid, clientid, client name, date of service, units, procedure code, staffid, staff name, program name, location, and error message. The report will NOT show rate information.
DataSets GetCountyLogoForm(s) N/ACDAG enforced N/AComments County logo image for display on page header
DataSets ProgramsForm(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 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