CalMHSA 102 – MAR Report

 

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

 

 

 

County Affiliate SysAdmin,

Medical IP/CSU/Res,

County Affiliate SysAdmin