MENU

Staff Multiple Service Detail Report

Report NameMenu PathClient BasedReport RDL Name
Staff Multiple Service Detail ReportReports/Staff Multipole Service Detail Report (My Office)NRDLCALMHSAStaffServiceDetailv2
ParametersData TypeHiddenComments
Service From DateDateN
Service Through DateDateN
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
StaffSingle SelectNSingle select on active staff members from the Staff Table that are not designated as ‘Non Staff User’
ProgramMultiple SelectNProgram multiple select based on logged in user CDAG and staff programs
Show_Date_TotalsSingle SelectNYes/No single select parameter that will show or not show daily totals for a staff on the report
DataSetsForm(s)CDAG enforcedComments
DataSet1Staff service informationN/ADataSet1 Staff service information N/A Staff service information in three different queries connected via 2 union statements, the first query will get any QI Time entries entered for the selected staff that are marked as ‘Busy’. There will not be a client or program for these services and the time entered will only go in the face to face column, no travel or documentation time. The second query will get staff based services for individual (non-group) services where the status is in Show or Complete status (71,75) for selected staff date range, and programs. The third query will only get group services for selected staff date range, and programs for the selected staff services where the status is in Show or Complete status (71,75) but will only display face to face time as travel and documentation time for group services will be defaulted to zero. It will also display the group name instead of client name and will only display one record per group service and will display the duration of the group in the face to face time column. Then the combined data will be grouped by date of service and add subtotals for the travel, documentation, and face to face time for each calendar day as well as a grand total for the selected staff(s),
GetCountyLogoN/AN/ACounty logo image for display on page header
DataSet2Staff Lookup InformationN/AUsed to populate the Staff parameter with active staff members from the Staff Table that are not designated as ‘Non Staff User’
ProgramClient InformationN/AUsed to populate the Program parameter with programs specific to the logged in Staff and available programs of the CDAG at report run time
Header Column #1
County Affiliate SysAdmin Clinician Supervisor Medical Supervisor Billing Supervisor Billing CalMHSA SysAdmin