Cube: Daily Activities

Use this cube to report on daily activities -  completion rate, comments, start and end dates, revision dates, and creation. You can tie in information about the visit and the client's risks, as well as fields from the following dimensions:

ADL, Branch, Branch rollback, Cancel Code, Client, Client Name, Employee, Employee Creation, Employee Creation Name, Employee Name, Employee Update, Employee Update Name, Facility, Funder, Service, Service Address, Service Codes.

Cube Fields

• ADL ID
• ADL Completed: value either false or true
• ADL Comment: submitted on mobile with completion of ADL
  Approval Status: of the visit - approved, not approved, or rejected
• Account Type

Client risks (from Client Profile>Overview>Risk Assessment):

• Client Risk Name
• Client Risk Category
• Client Risk Severity
• Client Risk Creation Date
• Client Risk Revision Date
• Client Risk Employee Creation Firstname
• Client Risk Employee Creation Lastname

Visit information:

• Visit Funder Status: specifically for LHIN
• Visit ID
• Visit Late Hours Range: internal only
• Visit Sequence By Client: internal only
• Visit Sequence By Client And Service: internal only
• Visit Punched: value either false or true
• Visit Punch Start Time
• Visit Punch End Time
• Visit Start Year
• Visit Start Month
• Visit Start Day
• Visit Start Year-Week
• Visit Start Week
• Visit End Year
• Visit End Month
• Visit End Day
• Visit Start Time
• Visit End Time

ADL dates - creation, revision, start, and end:

• ADL Creation Year
• ADL Creation Month
• ADL Creation Day
• ADL Creation Year-Week
• ADL Creation Week
• ADL Revision Year
• ADL Revision Month
• ADL Revision Day
• ADL Revision Year-Week
• ADL Revision Week
• ADL Start Year
• ADL Start Month
• ADL Start Day
• ADL End Year
• ADL End Month
• ADL End Day

Measures

• Visit Distinct Count
• Visit Approved Hours Sum: the total of approved hours for a given visit, irrespective of the bill-override or pay-verride quantities or units. 
• Visit Approved Hours Avg: the average of approved hours for a given visit, irrespective of the bill-override or pay-override quantities or units. 
• Client Distinct Count
• Employee Distinct Count
• Visit Date MAX max
• Visit Date MIN min
• Visit Scheduled Hours Sum 
• Visit Scheduled Hours Avg
• Visit Punched Hours Sum
• Visit Punched Hours Avg
• Visit Scheduled minus Punched Duration Hours Sum
• Visit Late Hours Sum (punch start - visit start - service code buffer)
• Visit Late Hours Avg (punch start - visit start - service code buffer)
• Override Bill Sum
• Override Pay Sum