Report Description | ||||||
This report is a version of the ‘Staff QI Time Report’ where instead of looking at QI time for the select staff, this report will look at all Mobile Crisis calendar entries that are marked as busy. | ||||||
Report Name | Menu Path | Client Based | Report RDL Name | |||
CalMHSA 202 – Mobile Crisis Admin Time Report | CalMHSA 202 – Mobile Crisis Admin Time Report (My Office) | N | RDLCALMHSA_MobileCrisisQITime | |||
Parameters | Data Type | Hidden | Comments | |||
From | Date | N |
| |||
Thru | Date | N |
| |||
Staff | Multiple Select | N | Multiple select parameter that will display all Staff members | |||
DataSets | Form(s) | CDAG enforced | Comments | |||
DataSet1 | Staff Calendar, Staff/Users (Admin) | N | This query pulls the following data from both the Appointment Table and the Staff Table. Staff id, staff full name, staff’s licenses, the appointment start time, the appointment, the appointment’s program id, the appointment type, the appointment status, and the calculated time that the staff sent during the appointment(calculations is based on the appointment start and end time.) The data is pulled based off all the selected staff members on the Staff parameter, the From and Thru date compared to the appointments own start and end time, the appointment being shown as busy, and appointment type having ‘Mobile Crisis’ in it’s name. | |||
GetCountyLogo | N/A | N/A | County logo image for display on page header | |||
DataSet2 | User/Staff(Admin) | N | This query is used to populate the ‘Staff’ Parameter. It pulls all staff records that are not set as a ‘NonStaffUser’, are not set to as deleted, are set as active, and have at least a LastName or a FirstName on the record. | |||
|
|
| Default User Roles | |||
|
|
|
| |||
