Cube: Medication

Use this cube to report on recorded medications and administrations for your clients. You can add detail to your report with fields from the following dimensions:

Branch, Branch rollback, Client, Client Name, Employee Creation, Employee Creation Name, Employee Update, Employee Update Name, Medication, Medication Administration.

Cube Fields

• Medication Admin. Held: for a given administration, true if the held option was checked, and false otherwise.

Creation and update dates:

• Medication Creation Year
• Medication Creation Month
• Medication Creation Day
• Medication Update Year
• Medication Update Month
• Medication Update Day

Start and end dates:

• Medication Start Year
• Medication Start Month
• Medication Start Day
• Medication End Year
• Medication End Month
• Medication End Day

Administration dates: 

• Medication Administration Completed Year
• Medication Administration Completed Month
• Medication Administration Completed Day
• Medication Administration Completed Time

Discrepancy:

• Medication Discrepancy
• Medication Discrepancy Status
• Medication Discrepancy Note

Measures

• Medication Count
• Client Distinct Count