Cube: Premium Visit

Dimensions available: Bill Item, Bill item premium, Bill rate, Bill rate premium, Branch, Branch rollback, Client, Client Cost Centre, Client Name, Employee, Employee Cost Centre, Employee Creation, Employee Creation Name, Employee Name, Employee Update, Employee Update Name, Facility, Funder, Premium, Service, Service Address, Service Codes, Tag.

Cube Fields

Fields related to the visit premium:

• Premium Pay Code Rate
• Visit Premium Description

Fields related to the visit:

• Visit ID
• Approval Status
• Visit Start Year
• Visit Start Quarter
• Visit Start Month
• Visit Start Day
• Visit Start Month All
• Visit Start Year-Week
• Visit Start Week
• Visit End Year
• Visit End Month
• Visit End Day
• Visit Start Time
• Visit End Time

Client Risks:

• 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

Measures

• Premium Count
• Visit Distinct Count
• Visit Approved Hours Sum
• Visit Approved Hours Avg
• Client Distinct Count
• Employee Distinct Count
• Visit Date MAX
• Visit Date MIN
• Visit Scheduled Hours Sum
• Visit Scheduled Hours Avg
• Visit Punched Hours Sum
• Visit Punched Hours Avg
• Service Distinct Count
• Premium Quantity Sum
• Premium Revenue Sum: the bill rate*quantity. Note that this measure does not take the holiday multiplier into account, as this is not applied to the calculation of premium billable quantities during billing.
• Premium Rate Sum
• Override Bill Sum: for any Visit with an override quantity in hours
• Override Pay Sum: for any Visit with an override quantity in hours
• Override Bill Sum (Visit): for any Visit with an override quantity in Visits
• Override Pay Sum (Visit): for any Visit with an override quantity in Visits