Open Enrollments and Last Service Date Report

Report Description
This report is designed to display the last service date for clients who have an open (not discharged) program enrollment for the selected programs parameter. The report will enforce CDAG security for the program parameter based on the logged in StaffId value.
Report NameMenu PathClient BasedReport RDL Name
CalMHSA Open Enrollments and Last Service DateReports/CalMHSA Open Enrollments and Last Service DateNRDLCALMHSALastServiceDate.rdl
ParametersData TypeHiddenComments
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
ProgramMultiple SelectNProgram multiple select based on logged in user CDAG and staff programs
DataSetsForm(s)CDAG EnforcedComments
DataSet1Client Programs, New Service NoteYesUsed to get the client enrollments, status, enrolled data and last date of service for selected programs in the program parameter
GetCountyLogoN/AN/ACounty logo image for display on page header
DataSet2Team RolesYesUsed to populate the Program parameter with active programs that the user has access to in Staff profile
Default User Roles
County Affiliate SysAdmin CalMHSA SysAdmin Clinician Supervisor Medical Supervisor