CalMHSA Service Errors Report

Report NameMenu PathClient BasedReport RDL Name
CalMHSA Service Errors ReportReports/CalMHSA Service Errors ReportYesRDLCALMHSAServiceErrors.rdl
ParametersData TypeHiddenComments
FROMDateNStart date of service
THRUDateNEnd date of services
Clinical Data Access GroupIDIntegerYPassed by system at report run time based on currently logged in CDAG
Executed By StaffIDIntegerYPassed by system at report run time based on currently logged in CDAG
ProgramsIntegerNProgram Multiple select based on logged in user CDAG and staff programs
DataSetsForm(s)CDAG enforcedComments
DataSet1Services (Administration)YThis 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.
GetCountyLogoN/AN/ACounty logo image for display on page header
ProgramsStaff/UserYUsed to populate the Program parameter with active programs that the user has access to in Staff profile
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