Report Description | ||||||
This report is designed to provide users an overview of their client’s active medications/orders. It allows multi-day review, status detail, order’s information text and comments. | ||||||
Report Name | Menu Path | Client Based | Report RDL Name | |||
CalMHSA 102 – MAR Report | CalMHSA 102 – MAR Report (My Office) | No | RDLCALMHSA_MAR | |||
Parameters | Data Type | Hidden | Comments | |||
StartDate | Date | N |
| |||
EndDate | Date | N |
| |||
Units | Multiple Select | N | Multiple select parameter that displays all that has clients assigned to them and if the login user have access to the unit’s associated program. | |||
Clients | Multiple Select | N | Multiple select parameter that displays all clients that have orders within the selected units in the Units parameters | |||
OrderTypes | Multiple Select | N | A Multiple select parameter that displays all active Order Types that has it’s AddOrderToMar column set as ‘Y’ | |||
Executed By StaffId | Integer | Y | Passed by system at report run time based on currently logged in Staff | |||
Clinical Data Access GroupId | Integer | Y | Passed by system at report run time based on currently logged in Staff | |||
DataSets | Form(s) | CDAG enforced | Comments | |||
DataSet1 | Medication Management (RX) (Client) | Y | This query is used to pull the Client MAR information base on the clients selected in the Client Parameter, the order types selected in the OrderTypes Parameter, the logged in user’s CDAG, the client’s order being active during the selected time ranged set the StartDate/EndDate Parameters, the client’s order discontinue date and time is Null or that it is greater or equal to the MAR’s scheduled date and time, client orders being no completed. | |||
Units | Units/Rooms/Beds(Admin), Units/Residential Set Up(Admin) | N | This query is used to populate the Unit Parameter. It pulls in a distinct list of Units based on currently open clients and the program permissions of the logged in user. | |||
OrderTypes | Order Set(Admin) -> Order Set Details | N | This query is used to populate the OrderTypes Parameter. It pulls data from the Orders table. It looks for all orders that has its AddOrderToMar set to ‘Y’, is active, and is not deleted. | |||
Clients | User/Staff(Admin) -> Proc/Prog/Loc/Proxy/Supervisor, Bedboard | N | This query is used to populate the Clients Parameter base on the client being admitted on a bed within the selected unit in the Unit parameter, | |||
|
|
| Default User Roles | |||
|
|
|
|
![](https://2023.calmhsa.org/wp-content/uploads/2024/07/590.png)