Cube: Activity Code

Use this cube to report on the use of activity codes throughout your visits. You can complete this information with fields from the following dimensions:

Activity codes, Branch, Branch rollback, Cancel Code, Client, Client Name, Employee, Employee Name, Facility, Funder, Service, Service Codes.

Fields

• Approval Status: of the visit'; approved, not approved, or rejected
• Account Type
• Visit ID

Service information:

• Service Skill Type: category of skills on the service
• Service Skill Name: name of the skill on the service
• Service Label Name: invoice label on the service
• Service Label Value: invoice label value

Visit date:

• Visit Start Year
• Visit Start Month
• Visit Start Day
• Visit End Year
• Visit End Month
• Visit End Day
• Visit Start Time
• Visit End Time

Measures

• Visit Count
• Visit Approved Hours Sum: the total of approved hours for a given visit, irrespective of the bill-override or pay-override 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
• Visit Date MIN
• Visit Scheduled Hours Sum
• Visit Scheduled Hours Avg
• Override Bill Sum
• Override Pay Sum